From: admin@lists.myITforum.com [mailto:admin@lists.myITforum.com] On Behalf Of Benjamin Derr
Sent: Friday, January 01, 2010 3:46 PM
To: mssms@lists.myitforum.com
Subject: Re: [mssms] RE: Failed SCCM SP2 Update

I saw this issue with a secondary site that was uninstalled and renamed, and reinstalled; if this is a non-existent server name, i would delete it from the SQL security rights.

On Wed, Dec 30, 2009 at 11:46 PM, Miriyala, Vasu <vasu.miriyala@capgemini.com> wrote:

Hi Darin,

 

Below is what it should look like when its successfully executed and so was in my case… It looked for ‘'NT AUTHORITY\SYSTEM'’ in my case and added successfully. I also checked my LAB SP2 upgrade logs, which used system account only and upgraded successfully.

 

<12-12-2009 11:07:59> Adding smsdbrole_siteprovider to db_owner: EXEC sp_addrolemember 'db_owner', 'smsdbrole_siteprovider'

<12-12-2009 11:07:59> Adding smsdbrole_siteserver to db_owner: EXEC sp_addrolemember 'db_owner', 'smsdbrole_siteserver'

<12-12-2009 11:07:59> Adding a login for SMS Site Server: IF NOT EXISTS (select * from master.sys.server_principals where name='NT AUTHORITY\SYSTEM') CREATE LOGIN [NT AUTHORITY\SYSTEM] FROM WINDOWS

<12-12-2009 11:07:59> Creating user for SMS Site Server to master db: IF NOT EXISTS (select * from sys.database_principals where name='NT AUTHORITY\SYSTEM') CREATE USER [NT AUTHORITY\SYSTEM]

<12-12-2009 11:07:59> Granting an execute permissions on sys.xp_msver: GRANT EXECUTE on sys.xp_msver to [NT AUTHORITY\SYSTEM]

 

It is just trying to create Windows based Login name in SQL, the same way you create accounts in SQL console manually

 

Can you try run” select * from master.sys.server_principals “ and how many rows you get, ideally you should get one row and it should have “Name” with value of “NT AUTHORITY\SYSTEM'’. Also, try to create the account yourself before starting the upgrade using “CREATE LOGIN [NT AUTHORITY\SYSTEM] FROM WINDOWS” or CREATE LOGIN [AN\AR-CM$] FROM WINDOWS and see if upgrade goes successful. Last but not least, you can also try setup.exe /testdbupgrade on an offline copy of your DB to ensure it is SP2 ready

 

Thanks

Vasu

 

From: admin@lists.myITforum.com [mailto:admin@lists.myITforum.com] On Behalf Of Darin Nelson
Sent: 30 December 2009 11:42 PM


To: mssms@lists.myitforum.com
Subject: [mssms] Failed SCCM SP2 Update

 

Hello group!

 

We are having some issues with our SP2 update on our SCCM 2007 R2 Site Server.  It’s giving us an SQL error.  I have attached a few lines of the ConfigMgrSetup.log file.  It appears as if it’s getting hung up on the domain\server name in SQL.  The Site Server is AR-CM and our domain is actually AN.CC.MN.US and the update appears to be looking for AN\AR-CM$, which of course it’s not finding.  I am wondering where it’s getting the AN\AR-CM$ from and if we can change that.  Or maybe it’s something totally unrelated???

 

---------------------------

<12-30-2009 11:28:13> Adding Permission: GRANT EXECUTE ON CH_GetMPList TO [smsdbrole_CH]

<12-30-2009 11:28:13> Adding Permission: GRANT EXECUTE ON CH_UpdateInactiveClients TO [smsdbrole_CH]

<12-30-2009 11:28:13> Adding smsdbrole_siteprovider to db_owner: EXEC sp_addrolemember 'db_owner', 'smsdbrole_siteprovider'

<12-30-2009 11:28:13> Adding smsdbrole_siteserver to db_owner: EXEC sp_addrolemember 'db_owner', 'smsdbrole_siteserver'

<12-30-2009 11:28:13> Adding a login for SMS Site Server: IF NOT EXISTS (select * from master.sys.server_principals where name='AN\AR-CM$') CREATE LOGIN [AN\AR-CM$] FROM WINDOWS

<12-30-2009 11:28:13> ***SqlError: [42000][15401][Microsoft][ODBC SQL Server Driver][SQL Server]Windows NT user or group 'AN\AR-CM$' not found. Check the name again.

<12-30-2009 11:28:13> SqlExecute <IF NOT EXISTS (select * from master.sys.server_principals where name='AN\AR-CM$') CREATE LOGIN [AN\AR-CM$] FROM WINDOWS>

<12-30-2009 11:28:13> CSql::Execute failed, SQL error <>

<12-30-2009 11:28:13> Setup cannot upgrade the ConfigMgr database.  Contact your SQL administrator.

---------------------------------------

 

 

Any assistance would be greatly appreciated!

 

Darin Nelson

Information Technology

Cambridge Campus

P: 763-433-1824

F: 763-433-1911

 

cid:image006.jpg@01CA3AB4.7E418D70

 

"Success is not the key to happiness, happiness is the key to success. If you love what you are doing, you will be successful." - Albert Schweitzer

 


==============
Missed an email? Check out the list archive:
http://myitforum.com/cs2/blogs/smslist/

This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message.


==============
Missed an email? Check out the list archive:
http://myitforum.com/cs2/blogs/smslist/



==============
Missed an email? Check out the list archive:
http://myitforum.com/cs2/blogs/smslist/

Published with BlogMailr

17:55 - Jan 01, 2010



Trackbacks

No Trackbacks

Comments

No Comments