I'm about halfway through writing my first ever ASP.NET 2.0 web site project using Visual Web Developer. When I first begun I was absolutely new to all of it and it's all been a massive learning curve.
I've become much better now, but it would appear the way I set it up originally isn't working. Well, it works fine on the machine I built it on so I'm thinking I've somehow tied it to my Windows account?
Anyway, I moved the project folder exactly as was (including the App_Data folder which has the database in it) to my laptop. I installed the necessary bits and piece so my laptop could understand it all, then changed the connection string to reflect the new physical location of the database in the web.config file.
The site runs in my browser, but won't let me log on. It won't connect to the database! Oh, I did also notice these in the connection string but don't really understand them. "Integrated Security=True;Connect Timeout=30;User Instance=True".
Anyway, any help would be greatly appreciated. If you know where I need to be looking, even that would stop me worrying a little!
Your connection string is using Integrated Security (Windows Security) so it probably isnt going to work on a different machine unless your running on a network or something and you have used the same user account on another machine.
You might want to consider SQL authentication as apposed to windows authentication if you are going to be moving around boxes freely and are not on a domain.
You would have a connection string like this then : Data Source=server;Initial Catalog=database;User ID=user;Password=password
Bookmarks