Upgrade To SQL2005 - Installed Instances
Nov 5, 2006
My SQL2000 databases did not upgrade to SQL2005. When I look at the Properties>>Options>>Compatibility Level the only options I have is version 7 and version 8... version 9 - which is SQL2005, is not there.
So what did I do? During the upgrade process - the installation wizard - I made a couple of choices that I believe might have lead to my current condition. The first thing is that I chose to select a installed instance. The second choice I made was to use a domain user account for the Authentication. The second selection I believe had nothing to do with the condition, but I did notice that my Systems Admin user account for SQL is no longer availble... which is a problem because now when I log into the SQL Management Console... it's using the domain name to authenticate rather than using the SA name like it was in SQL2000.
So here is what I think the solution is... I need to create a new Server Registration and create the databases in the new instance and then restore the data from SQL2000 to SQL2005 new instance, and then I can change the Compatibility Level to version 9.
The only issue I still don't have an answer for is the authentication into SQL. I want to not use the domain user account... how can I change this or can I? This also creates an issue when creating the ODBC connection as it wants to use the domain user account to verify.
So if someone can let me know if this is the right direction? Also any suggestions... i would greatly appreciate it!
John