January 10, 2007 at 5:36 pm
I'm having registry issues with my SQL 2005 named instance installation that prevents me from launching SQL Server from a command prompt.
Here's what I did:
- Installed SQL 2000 Standard as a default instance, patched it up to SP4, attached a couple databases. Everything is fine.
- Installed SQL 2005 Enterprise Edition as a named instance, patched it up to SP1. When I was trying to move around system files, by starting SQL Server from command prompt with -c -f -T3608 flags it gives me the following error:
"Your SQL Server installation is either corrupt or has been tampered with (SQL Registry Version Not Same As Server). Please uninstall then re-run setup to correct this problem"
However, SQL Server itself starts up just fine from the Configuration Manager.
To try to resolve this I have done the following:
- Uninstalled SQL 2005. Reboot. Then reinstall SQL 2005. -> Gives the same error.
- Run SQL 2005 setup:
"start /wait setup.exe /qb INSTANCENAME=
which is supposed to repair the registry. -> Still gives the same error.
My only guess is the side by side thing with SQL 2000, but I'm not sure how to fix this or what is the cause.. Anyone have any ideas?
Thanks!
January 10, 2007 at 5:59 pm
Moving system files means moving system databses or sql binaries?
BOL topic "moving system databases"
http://msdn2.microsoft.com/en-us/library/ms345408.aspx
How to move SQL Server databases to a new location by using Detach and Attach functions in SQL Server
http://support.microsoft.com/kb/224071
MohammedU
Microsoft SQL Server MVP
January 10, 2007 at 6:08 pm
I'm trying to move system databases. The problem though is that I can't get to the first step, which is to start the SQL Server in administrative single user mode from command line (with trace flag -T3608).
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply