Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sailing_Nut
Starting Member
2 Posts |
 Posted - 2007-12-04 : 22:26:01
|
| Hello,I'm getting an error when attempting to do an upgrade (from 2000 SP3) install of SQL 2005 on my W2K3 server. (The server is my AD controler as well.)The error is as follows:TITLE: Microsoft SQL Server 2005 Setup------------------------------SQL Server Setup was unable add user WTBHOME\Administrator to local group SQLServer2005SQLAgentUser$XXXXXX$MSSQLSERVER.I Googled the error and tried the suggestion to manually add the account to the group, but when I run the setup again, I still have the same problem.Any and all help is greatly appreciated! |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-12-04 : 22:38:18
|
I googled that error and found this solutionquote:
Problem resolved.As xrab suggested I created SQLServer2005MSFTEUser$SANORAYA$MSSQLSERVER local group and added local account to the group. Setup failed again with different error message "can't change permissions on "some file"... Make sure you run setup under admin privileges" or similar.After that I ran uninstall, and then removed everything remaining manually from Program Files\Miscorosft SQL Server directory". Then copied everythin from Setup disk to HDD and ran setup again from HDD. Beleive it or not, everying went fine.
found in this thread here http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1659185&SiteID=1You might be having this issue because you are installing SQL on a domain controller. This is really a bad idea also, because if your SQL Server gets compromised, then that user will have domain admin privs (as if access to all databases wasn't bad enough).-ec |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-04 : 22:38:24
|
| Is WTBHOME\Administrator a domain account? You start sql agent with it? If so, can try start sql agent with local system then do upgrade. |
|
|
|
Sailing_Nut
Starting Member
2 Posts |
Posted - 2007-12-05 : 09:05:01
|
quote:
Originally posted by eyechart
I googled that error and found this solutionquote:
Problem resolved.As xrab suggested I created SQLServer2005MSFTEUser$SANORAYA$MSSQLSERVER local group and added local account to the group. Setup failed again with different error message "can't change permissions on "some file"... Make sure you run setup under admin privileges" or similar.After that I ran uninstall, and then removed everything remaining manually from Program Files\Miscorosft SQL Server directory". Then copied everythin from Setup disk to HDD and ran setup again from HDD. Beleive it or not, everying went fine.
found in this thread here http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1659185&SiteID=1You might be having this issue because you are installing SQL on a domain controller. This is really a bad idea also, because if your SQL Server gets compromised, then that user will have domain admin privs (as if access to all databases wasn't bad enough).-ec
I found that exact same thread and had already tried manually adding the user to the group, but it still bombs out with the same error.Thanks for taking the time to look around for me!Any other ideas? (I ran out of luck/patience with Google and forums.) |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-12-05 : 09:08:33
|
Post also found on SQLSERVERCENTRAL.COM
E 12°55'05.25"N 56°04'39.16" |
|
|
|
|
|
|
|
|
SQL 200 to 2005 upgrade problem