June 2, 2009 at 6:31 am
Hi!
I'm currently in the process of upgrading from SQL2000 to SQL2005. A new server, with Windows Server 2008 is taken into production at the same time. Old SQL2000 server is running Windows Server 2003.
What I'll do is:
- Install SQL2000 on the new server
- Restore the master database from the old server to the new server to migrate all the hundreds of SQL Server logins
- Upgrade to SQL Server 2005 in the new server.
- Move data from all the user databases on SQL2000 to the new server.
First step is done. Second step became a problem, when it turned up that the newly installed SQL2000 on our WS2008 machine has SQL-version 8.00.2039 and the SQL-version on the WS2003 machine is 8.00.2055. I googled a little, and found that KB960082 would upgrade to SQL-version 8.00.2055.
So I downloaded from KB960082, but can't install the patch on WS2008. I get "Not enough storage is available to process this command", which is caused by update.exe issuing non-existent API-calls (http://support.microsoft.com/kb/941384).
Right now I'm stuck in my upgrade on something as trivial as update.exe not being able to run, stopping me from upgradeing SQL2000 to 8.00.2055 (which is just an intermediate step anyway, I want to get rid of SQL2000, this is just to be able to recover my logins).
Anyone experienced this? Anyone got a solution or workaround? Microsofts support-article for the problem only explains what's happening, nothing about how to fix it, and live happily ever after...
Sql Server blog: http://www.tsql.nu
June 2, 2009 at 7:20 am
Sorry, I can't help you with your problem applying the patch, but personally I wouldn't do it that way anyway. Restoring a master database to antoher server is always tricky and sometimes even dangerous.
MS has a KB article on how to transfer logins between instances using a stored procedure. I've done at least 10 migrations using those scripts and never had a problem.
http://support.microsoft.com/kb/246133
[font="Verdana"]Markus Bohse[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply