May 25, 2006 at 8:23 am
Hi!
I have just upgraded SQL Server from 2000 to 2005 (Developer) on my local test machine, but now my ASP.NET code can no longer find the database.
I can log in via Management Studio with Windows Authentication, but I have not been able to set up a SQL Server Authentication login that works with Management Studio. (I figure I could use such a login in the connection string of my web.config file in ASP.NET.)
Any tips will be most welcome.
May 25, 2006 at 7:52 pm
I forgot to mention the exact error I get. I can set up logins on the server, and I can set up users for those logins in the target database, but no matter how I tweak the settings for the logins and users, when I try to log in via Management Studio with the new login I am told that the login is not associated with a trusted SQL Server connection.
May 26, 2006 at 4:48 am
SQL 2005 defaults to Windows Authentication only I think. Sonds to me like you have that security setting and what you're looking for is to have it set to Windows AND SQL authentication. I think this is in the Properties of the SQL server on the Security page.
May 26, 2006 at 6:14 am
Thanks for replying!
The server is set up for mixed mode authentication, both Windows and SQL Server. But still, no matter what new logins I create on the server, when I try to log in with them via Management Studio it says that they are not associated with a trusted SQL Server connection.
May 30, 2006 at 3:26 pm
Have you gone into SQL Server Configuration Manager (Start | All Programs | Microsoft SQL Server 2005 | Configuration Tools | SLQ Server Configuration Manager) and enabled the protocols you want to use (SQL Server 2005 Network Configuration | Protocols for SQL Server instance?
K. Brian Kelley
@kbriankelley
May 30, 2006 at 10:18 pm
Thanks, Brian, for the reply.
Yes, the necessary protocols are enabled. Anything else you suggest I try?
--- BR
May 31, 2006 at 6:54 am
*waps himself for not reading closer*
You said you are set up for Mixed Mode. If you recently changed the setting, the SQL Server will need to be restarted for the change to take effect. Could that be it?
K. Brian Kelley
@kbriankelley
May 31, 2006 at 7:50 am
I have rebooted several times to try to figure this thing out. Maybe it is just some weird problem and I have to uninstall and reinstall. I was using SQL Server Express for a short time before I upgraded to Developer Edition, and the SQL Server authentications were working then, but not after the upgrade.
June 18, 2006 at 6:07 am
Just a note to finish this thread that I had to completely uninstall SQL Server 2005 and reinstall it to get the logins to work properly.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply