Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Development Tools  ASP.NET  unable to access database

Author  Topic  anomie Starting Member 16 Posts Posted - 2009-01-23 : 11:30:19 Hi all, I have made significant progress with my website over the last few days. Debugging returns no exceptions apart from when i publish the site in order to test it. I am currently creating the site as a project in visual web developer 2008 (express). When i run the site, the debugger tells me that it cannot open the database because my login credentials have failed. I'm currently developing the site locally/on my machine so i have specified the 'connectionString' within 'web.config' to Server=(local)\SqlExpress;Integrated Security=True; Opening the database requested by login credentials, expecting the database server to accept my default machine log-in details to suffice. im running the Cassini server provided by visual web developer 2005 (windows XP home). I understand that my OS isnt IIS compliant thus i have no IIS installed. It seems that the windows authentication login failed. I think the default entrys are the pc's name followed by the user name and password. Do i have to use an alternative log in method, or do i have to delete and create a new user account in which to log in? Is there an alternative way for me to access the database? Any help toward this issue will be greatly appreciated, Many thanx, 4aces