If you’re using AMD Phenom 3-core processors, SQL Server 2005 won’t install without going through some hoops first. Microsoft just published a knowledge base article on SQL 2005 errors on 3 and 6 core servers.
I don’t usually blog about knowledge base articles, but I got such a laugh out of that one that I just had to share it.
Want to know about MS KB articles as soon as they’re published? Subscribe to the Microsoft Knowledge Base RSS feed for SQL Server. You DO use an RSS reader, don’t you? Hint hint….
hi,
I’m running WinXP and that KB fix didn’t work for me, wondering which OS you are using to run SQL 2005 ?
I don’t use an AMD processor, so I can’t help you there. You probably want to call Microsoft for support.
The fix http://tinyurl.com/c37ewp worked for me, thanks anyway.
i used AMD Phenom 3-core processors,os 2003 server. sql server2005 not installed my system plz help me and ram 2gb .
Sandeep – can you be more specific about the problem that you’re having? For example, can you include error messages?
Hello.
I am using AMD Phenom II X6 1055T.
I have this problem while i am trying to install sql server 2005 on windows xp sp3. The workaround with /NUMPROCS=1 doesn’t work.
But i found the solution by disabling all the other 5-cores on BIOS.
After i sucessfully install it, i apply the SP3 for sql server 2005, then re-enable all the cores.
Solve the problem.
Forgot to mention.
I have 4gb of ram.
And i install on 32-bit windows XP SP3.
Anon – what’s the error you’re getting, and what edition of SQL Server are you using?
The error was the sql server services wouldn’t start. I traced it with visual studio and if i remember correctly, it runs an 64-bit code.
It’s sql server 2005 developer edition.