Hi Sharavi, This is MSSQL error. The database seems to be missing the authorization for your SID. Kindly go check whether you have complete proper authorization. If not, please restore the database from your backup before SP upgrade and start it again. I am sure the SP not affected this, since it will never touch any thing in SQL admin. Check whether any changes happened in SQL level. If you have an issue on authorization kindly execute the script attached to the note 551915 Regards, Dinesh
| | | ---------------Original Message--------------- From: sharavi_2k Sent: Monday, January 24, 2011 1:15 AM Subject: Solution manager down Dear All I am having big problem our solution manager is down kindly help me to solve this problem. system configuration: Solution manger 7.01 ehp1 this was upgraded from nw04s a year back . Yesterday I was trying to upgrade from sp19 to sp24 then when i try to connect jspm then the problem started. 1. when i ran JSPM it was asking for SDM password and i have provided the password and i am 100 % sure it is the correct password. but still the sytem is not accepting the password. 2. at the same time i tried config tool but it is giving an error message (error while connecting DB) 3.now i want to uninstall solman and restore the DB but even sapinst is giving error below is the error from sapinst_dev. TRACE Running with toplevel file C:\Program Files/sapinst_instdir/SOLMAN/LM/UNINSTALL/AS/tople vel.xml TRACE Running with dialog file C:\Program Files/sapinst_instdir/SOLMAN/LM/UNINSTALL/AS/dialo g.xml TRACE Running with keydb file C:\Program Files/sapinst_instdir/SOLMAN/LM/UNINSTALL/AS/keydb .xml TRACE Opened iaejs701.dll TRACE Opened iacdlib701.dll TRACE Opened iaccdlib.dll TRACE Opened iapasswdman701.dll TRACE This is SAPinst, version 701, make variant 700_REL, build 844351 compiled on Aug 9 2006, 07:13:26 TRACE [synxcaccmg.cpp:640] CSyADsPath::fromString(INT\gsmadm) Account INT/gsmadm has ADS path 'WinNT://INT/gsmadm' TRACE [synxcaccnt.cpp:967] iastring CSyAccountImpl::getSID(IUnknown* pUnk) const gsmadm has SID S-1-5-21-1482476501-1715567821-1801674531-7805 TRACE [synxcuser.cpp:1088] CSyUserImpl::isExistingOnOS() existence check for user gsmadm returned true. TRACE [syxxccache.cpp:208] CSyAccountCache::getUserImpl(name="INT\gsmadm ", sid="", create=false, ISyProgressObserver* ) inserted account (gsmadm, S-1-5-21-1482476501-1715567821-1801674531-7805, USER) into the accountcache. TRACE [syxxsyshlp.cpp:175] syslib::logSystemState() Process environment =================== Environment Variables ===================== = C:=C:\Program Files\sapinst_instdir\SOLMAN\LM\UNINSTALL\AS = E:=E:\solmansoftware\INSTMASTER\IM_WINDOWS_I386 ALLUSERSPROFILE = C:\Documents and Settings\All Users APPDATA = C:\Documents and Settings\gsmadm\Application Data CLIENTNAME = 1DXBHOITALTA795 ClusterLog = C:\WINDOWS\Cluster\cluster.log CommonProgramFiles = C:\Program Files\Common Files COMPUTERNAME = SAPSOL01 ComSpec = C:\WINDOWS\system32\cmd.exe DBMS_TYPE = mss FP_NO_HOST_CHECK = NO HOMEDRIVE = C: HOMEPATH = \Documents and Settings\gsmadm JAVA_HOME = C:\j2sdk1.4.2_11 lib = C:\Program Files\SQLXML 4.0\bin\ LOGONSERVER = \\1DXBSFDCADR02 MSSQL_DBNAME = GSM MSSQL_SCHEMA = gsm MSSQL_SERVER = SAPSOL01 NUMBER_OF_PROCESSORS = 4 OS = Windows_NT Path = C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32 \Wbem;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files\Microsoft SQL Server\90\DTS\Binn\;C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\;D:\usr\s ap\GSM\SYS\exe\uc\NTI386;E:\usr\sap\GSM\SYS\exe\uc\N TI386 PATHEXT = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH PROCESSOR_ARCHITECTURE = x86 PROCESSOR_IDENTIFIER = x86 Family 6 Model 15 Stepping 6, GenuineIntel PROCESSOR_LEVEL = 6 PROCESSOR_REVISION = 0f06 ProgramFiles = C:\Program Files SAPEXE = D:\usr\sap\GSM\SYS\exe\uc\NTI386 SAPINST_EXEDIR_CD = E:/solmansoftware/INSTMASTER/IM_WINDOWS_I386 SAPLOCALHOST = sapsol01 SAPSYSTEMNAME = GSM SESSIONNAME = RDP-Tcp#1 SystemDrive = C: SystemRoot = C:\WINDOWS TEMP = C:\WINDOWS\TEMP\1 TMP = C:\WINDOWS\TEMP\1 USERDNSDOMAIN = INT.GULF-NEWS.COM USERDOMAIN = INT USERNAME = gsmadm USERPROFILE = C:\Documents and Settings\gsmadm windir = C:\WINDOWS User: INT\gsmadm, Id: S-1-5-21-1482476501-1715567821-1801674531-7805 Working directory: C:\Program Files\sapinst_instdir\SOLMAN\LM\UNINSTALL\AS Current access token ==================== Could not get thread token. Last error: 1008. I assume that no thread token exists. Got process token. Privileges: Privilege SeBackupPrivilege, display name: Back up files and directories, not enabled. Privilege SeRestorePrivilege, display name: Restore files and directories, not enabled. Privilege SeShutdownPrivilege, display name: Shut down the system, not enabled. Privilege SeDebugPrivilege, display name: Debug programs, not enabled. Privilege SeAssignPrimaryTokenPrivilege, display name: Replace a process level token, not enabled. Privilege SeLockMemoryPrivilege, display name: Lock pages in memory, not enabled. Privilege SeSystemEnvironmentPrivilege, display name: Modify firmware environment values, not enabled. Privilege SeIncreaseQuotaPrivilege, display name: Adjust memory quotas for a process, not enabled. Privilege SeChangeNotifyPrivilege, display name: Bypass traverse checking, enabled. Privilege SeRemoteShutdownPrivilege, display name: Force shutdown from a remote system, not enabled. Privilege SeTcbPrivilege, display name: Act as part of the operating system, not enabled. Privilege SeUndockPrivilege, display name: Remove computer from docking station, not enabled. Privilege SeSecurityPrivilege, display name: Manage auditing and security log, not enabled. Privilege SeTakeOwnershipPrivilege, display name: Take ownership of files or other objects, not enabled. Privilege SeLoadDriverPrivilege, display name: Load and unload device drivers, not enabled. Privilege SeManageVolumePrivilege, display name: Perform volume maintenance tasks, not enabled. Privilege SeSystemProfilePrivilege, display name: Profile system performance, not enabled. Privilege SeImpersonatePrivilege, display name: Impersonate a client after authentication, enabled. Privilege SeSystemtimePrivilege, display name: Change the system time, not enabled. Privilege SeCreateGlobalPrivilege, display name: Create global objects, enabled. Privilege SeProfileSingleProcessPrivilege, display name: Profile single process, not enabled. Privilege SeIncreaseBasePriorityPrivilege, display name: Increase scheduling priority, not enabled. Privilege SeCreatePagefilePrivilege, display name: Create a pagefile, not enabled. Groups: Group count: 15 \LOCAL S-1-2-0 Attributes: SE_GROUP_MANDATORY SE_GROUP_ENABLED_BY_DEFAULT SE_GROUP_ENABLED BUILTIN\Administrators S-1-5-32-544 Attributes: SE_GROUP_MANDATORY SE_GROUP_ENABLED_BY_DEFAULT SE_GROUP_ENABLED SE_GROUP_OWNER \Everyone S-1-1-0 Attributes: SE_GROUP_MANDATORY SE_GROUP_ENABLED_BY_DEFAULT SE_GROUP_ENABLED BUILTIN\Users S-1-5-32-545 Attributes: SE_GROUP_MANDATORY SE_GROUP_ENABLED_BY_DEFAULT SE_GROUP_ENABLED INT\Domain Users S-1-5-21-1482476501-1715567821-1801674531-513 Attributes: SE_GROUP_MANDATORY SE_GROUP_ENABLED_BY_DEFAULT SE_GROUP_ENABLED INT\SAP_GSM_GlobalAdmin S-1-5-21-1482476501-1715567821-1801674531-7807 Attributes: SE_GROUP_MANDATORY SE_GROUP_ENABLED_BY_DEFAULT SE_GROUP_ENABLED NT AUTHORITY\INTERACTIVE S-1-5-4 Attributes: SE_GROUP_MANDATORY SE_GROUP_ENABLED_BY_DEFAULT SE_GROUP_ENABLED INT\CERTSVC_DCOM_ACCESS S-1-5-21-1482476501-1715567821-1801674531-7112 Attributes: SE_GROUP_MANDATORY SE_GROUP_ENABLED_BY_DEFAULT SE_GROUP_ENABLED SE_GROUP_RESOURCE SAPSOL01\SAP_LocalAdmin S-1-5-21-3396065928-4188363256-2833855170-1012 Attributes: SE_GROUP_MANDATORY SE_GROUP_ENABLED_BY_DEFAULT SE_GROUP_ENABLED SAPSOL01\SAP_GSM_LocalAdmin S-1-5-21-3396065928-4188363256-2833855170-1013 Attributes: SE_GROUP_MANDATORY SE_GROUP_ENABLED_BY_DEFAULT SE_GROUP_ENABLED NT AUTHORITY\Authenticated Users S-1-5-11 Attributes: SE_GROUP_MANDATORY SE_GROUP_ENABLED_BY_DEFAULT SE_GROUP_ENABLED BUILTIN\Remote Desktop Users S-1-5-32-555 Attributes: SE_GROUP_MANDATORY SE_GROUP_ENABLED_BY_DEFAULT SE_GROUP_ENABLED NT AUTHORITY\REMOTE INTERACTIVE LOGON S-1-5-14 Attributes: SE_GROUP_MANDATORY SE_GROUP_ENABLED_BY_DEFAULT SE_GROUP_ENABLED \ S-1-5-5-0-340695 Attributes: SE_GROUP_MANDATORY SE_GROUP_ENABLED_BY_DEFAULT S | | __.____._ Copyright © 2011 Toolbox.com and message author. Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251 | | Most Popular White Papers In the Spotlight _.____.__ |