SQL Server 2005 login problems

I had a very strange problem with SQL Server 2005 April CTP today that I have “solved” but just want to put it out there in case anyone has this happen too!

I installed VS2005 Beta2 and SQL Server 2005 April CTP Developer on a completely repaved clean machine. There is nothing else on the box.

I did this before I went to D.C. so that’s about 2 weeks ago. I ran through all o fmy demos and everything worked great. I went away for a week and still didn’t turn that machine on for another week, until today. I was unable to log into the sql server from code or from the Mgmnt Studio interface, not even into the default database. On both the lowly user or even the admin account, I was getting “invalid user”. I couldn’t run any of my demos from Visual Studio. I tried all kinds of stuff and finally gave in and uninstalled and reinstalled and everything is now fine.

I would be very interested to know if anyone else has had this behavior. I know it’s just a beta and expect wierdness, but am still curious.


  Sign up for my newsletter so you don't miss my conference & Pluralsight course announcements!  

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.