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 |
jhermiz
3564 Posts |
Posted - 2011-11-16 : 08:02:29
|
I'm having a strange issue with upgrading SQL Server 2008 SP3 to R2.Error reads: No Mapping Between account names and security IDs was done.This causes the db engine from not being installed. I have googled and checked all articles and I am not certain how to fix this issue.This is running on a 64bit windows 2008 server.Weblog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
|
revdnrdy
Posting Yak Master
220 Posts |
Posted - 2011-11-16 : 10:48:28
|
If this is for a failover cluster then this microsoft kb may help.To supply a quick answer though you will have to re-install your clusterhttp://support.microsoft.com/kb/2019402 |
|
|
jhermiz
3564 Posts |
Posted - 2011-11-16 : 11:01:03
|
quote: Originally posted by revdnrdy If this is for a failover cluster then this microsoft kb may help.To supply a quick answer though you will have to re-install your clusterhttp://support.microsoft.com/kb/2019402
Not for a failover cluster. Seen that article already. This has to do with SIDS and group policy more then anything. I am getting closer to a solution, Ill post back if I get anywhere.Weblog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
|
|
revdnrdy
Posting Yak Master
220 Posts |
|
jhermiz
3564 Posts |
Posted - 2011-11-16 : 12:06:37
|
quote: Originally posted by revdnrdy Ok thats good to know that it isn't in a cluster.Did you also find this article? It seems to reflect your issue.http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/cda774d4-6329-4809-9d42-9447750e4d60/
Yep it got around the first error now i have a new error when trying to upgrade to R2: The service did not respond to the start or control request in a timely manner.Im beginning to think we have a bad media or corrupted install files?Weblog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
|
|
revdnrdy
Posting Yak Master
220 Posts |
Posted - 2011-11-16 : 14:44:54
|
The error sounds like you simply need to restart the sql services.Open services.msc from run line (start - run - services.msc). You can restart the sql services from that mmc (or snap in as they call it).You can also do this from the cmd prompt but I don't recall off hand that syntax (its easy to do I just don't recall it).I couldn't comment on corrupted files or media as I have not had those issues fortunately. |
|
|
jhermiz
3564 Posts |
Posted - 2011-11-16 : 15:37:13
|
quote: Originally posted by revdnrdy The error sounds like you simply need to restart the sql services.Open services.msc from run line (start - run - services.msc). You can restart the sql services from that mmc (or snap in as they call it).You can also do this from the cmd prompt but I don't recall off hand that syntax (its easy to do I just don't recall it).I couldn't comment on corrupted files or media as I have not had those issues fortunately.
I found some articles with MSFT employees saying it could be possibly bad media on the MSDN forums. Then we tried to reinstall it from scratch, not a single error but at the end of the install it comes up with a SETUP failed and asks to send to Microsoft - so the outcome is we have bad media (for the second time). We download from our MSDN subscription but this is the second time for R2 we've had issues with the install. Going to try to download it again.Weblog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
|
|
influent
Constraint Violating Yak Guru
367 Posts |
Posted - 2011-11-16 : 16:08:22
|
By "from scratch" do you mean you uninstalled all the SQL Server components before you tried to reinstall?I don't know why Microsoft doesn't provide checksums. That is my "I don't know why Microsoft..." for the day. |
|
|
revdnrdy
Posting Yak Master
220 Posts |
Posted - 2011-11-16 : 17:06:24
|
WellI would take a moment to pause here.What are the odds that 2 subscription downloads are bad? It just sounds peculiar to me. When you get the setup failed error are you able to review any windows logs on the server like eventvwr to see if anything is posted? I guess I am thinking of compatibility issues although I do understand you are upgrading from an exisitng install yes?Your error about the service not starting suggests that the install was ok but that maybe there was an issue with services being started or restarted..r&r |
|
|
|
|
|