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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Trying to upgrade to R2 but getting strange error

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 cluster

http://support.microsoft.com/kb/2019402


Go to Top of Page

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 cluster

http://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]
Go to Top of Page

revdnrdy
Posting Yak Master

220 Posts

Posted - 2011-11-16 : 11:45:18
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/

Go to Top of Page

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]
Go to Top of Page

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.
Go to Top of Page

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]
Go to Top of Page

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.
Go to Top of Page

revdnrdy
Posting Yak Master

220 Posts

Posted - 2011-11-16 : 17:06:24
Well

I 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
Go to Top of Page
   

- Advertisement -