Unable to connect to site Database connection
Hi All, I'm trying to connect one of my site server(nmrfl1sms) into another site server (amrksms1) by using smsadminconsole->Actions->All task->Connect to sitedatabase. while doing this i'm getting below error. The Site Server Cannot be contacted. Please enter a new Site Server name in google, i found below link, i chceked, all my permissions are correct. still i'm getting this error, please help me to resolve this. http://support.microsoft.com/kb/317872
April 12th, 2011 5:55am

can you check if you are member of smsadmin group on computer(proper rights to connect to SMS provider) to which you are connecting ? can you Try with FQDN name ? what does the smsadminUI.log says (\site server\SMS_sitecode\AdminUI\AdminUILog\SmsAdminUI.log ) ?//Eswar Koneti @ www.eskonr.com
Free Windows Admin Tool Kit Click here and download it now
April 12th, 2011 5:59am

Hi, We are part of SMSAdmins group, thing is that we are able to connect same still day before yesterday, from yesterday onwards we are facing the issue. if i try with FQDN, i'm getting error like please enter a vaild server name. when i saw my log file below two lines are showing redmark. [1E5C][Mon 04/11/2011 09:59:37]:Error(ConnectServer): Possible UI connection error code is -2147023174 [0x800706ba] [1E5C][Mon 04/11/2011 09:59:37]:Failed to set the connection. error code: -2147023174 below are few lines from end of the log file. do u want more entried from log file? [3E10][Mon 04/11/2011 11:14:42]:Setting connection to NameSpace: \\NMRFLISMS1\root\sms\site_OLM [3E10][Mon 04/11/2011 11:14:42]:Info(ConnectServer): Connecting to server : namespace \\NMRFLISMS1\root\sms\site_OLM [3E10][Mon 04/11/2011 11:14:42]:Info(ConnectServer): Connecting to server. Network : \\NMRFLISMS1\root\sms\site_OLM [3E10][Mon 04/11/2011 11:14:43]:SiteCode OLM - SiteServerName NMRFLISMS1, Provider Version : 2.50.4253.3000 [3E10][Mon 04/11/2011 11:14:43]:SiteBuildNumber is 4253 [3E10][Mon 04/11/2011 11:14:43]:set the connection succeeded.
April 12th, 2011 6:15am

Hi, We are part of SMSAdmins group, thing is that we are able to connect same still day before yesterday, from yesterday onwards we are facing the issue. if i try with FQDN, i'm getting error like please enter a vaild server name. when i saw my log file below two lines are showing redmark. [1E5C][Mon 04/11/2011 09:59:37]:Error(ConnectServer): Possible UI connection error code is -2147023174 [0x800706ba] [1E5C][Mon 04/11/2011 09:59:37]:Failed to set the connection. error code: -2147023174 below are few lines from end of the log file. do u want more entried from log file? [3E10][Mon 04/11/2011 11:14:42]:Setting connection to NameSpace: \\NMRFLISMS1\root\sms\site_OLM [3E10][Mon 04/11/2011 11:14:42]:Info(ConnectServer): Connecting to server : namespace \\NMRFLISMS1\root\sms\site_OLM [3E10][Mon 04/11/2011 11:14:42]:Info(ConnectServer): Connecting to server. Network : \\NMRFLISMS1\root\sms\site_OLM [3E10][Mon 04/11/2011 11:14:43]:SiteCode OLM - SiteServerName NMRFLISMS1, Provider Version : 2.50.4253.3000 [3E10][Mon 04/11/2011 11:14:43]:SiteBuildNumber is 4253 [3E10][Mon 04/11/2011 11:14:43]:set the connection succeeded. You said it worked previously, which negates this suggestion, but it's worth a look: http://technet.microsoft.com/en-us/library/bb633148.aspx
Free Windows Admin Tool Kit Click here and download it now
April 12th, 2011 6:38am

below are few lines from end of the log file. do u want more entried from log file? [3E10][Mon 04/11/2011 11:14:42]:Setting connection to NameSpace: \\NMRFLISMS1\root\sms\site_OLM [3E10][Mon 04/11/2011 11:14:42]:Info(ConnectServer): Connecting to server : namespace \\NMRFLISMS1\root\sms\site_OLM [3E10][Mon 04/11/2011 11:14:42]:Info(ConnectServer): Connecting to server. Network : \\NMRFLISMS1\root\sms\site_OLM [3E10][Mon 04/11/2011 11:14:43]:SiteCode OLM - SiteServerName NMRFLISMS1, Provider Version : 2.50.4253.3000 [3E10][Mon 04/11/2011 11:14:43]:SiteBuildNumber is 4253 [3E10][Mon 04/11/2011 11:14:43]:set the connection succeeded. The above log shows connection is succeded and more over this log file is not todays one (mon 04/11/2011) did you install any patches or serivce pack on the computer ? is it happening only when you connect remotly or even when you login to server physically ?//Eswar Koneti @ www.eskonr.com
April 12th, 2011 6:57am

in server, i'm able to open SMS admin console and Database. its happening only when i connectiong this site server into another site server. we did not install any patches.
Free Windows Admin Tool Kit Click here and download it now
April 12th, 2011 7:25am

i did the stepes provided for SMS maeshalls. i added SMS Admins into the DCOM. still no luck.
April 12th, 2011 7:36am

adminUI.log can give have more information why it failed to connect etc... seems to be issue with the computer which you are tying to connect . any chance of WMI or someother permissions ?//Eswar Koneti @ www.eskonr.com
Free Windows Admin Tool Kit Click here and download it now
April 12th, 2011 8:17am

I've checked the WMI and oher permissions too.. everything is ok. still i'm getting error.. is reboot the server will help?
April 12th, 2011 9:55am

This may sound dumb, but are you trying to connect a console to a Secondary site server?
Free Windows Admin Tool Kit Click here and download it now
April 12th, 2011 10:05am

we don't have secondary site servers. that is primary site server. we use to connect all site servers into single desktop to manage. remaining servers are able to connect. this only one server (which we use to connect previsoly) is not connecting now. please help me to resolve the same.
April 12th, 2011 11:59am

Check this thread out: http://social.technet.microsoft.com/Forums/en/configmgrosd/thread/7e351396-6d52-4dc2-8a55-8e4d387bf6aa Find out why you are getting RPC Server unavailable ...
Free Windows Admin Tool Kit Click here and download it now
April 13th, 2011 2:26am

I.ve checked above thread, and checked the user permission on SMSAdmins and DCOM users group. it is available. Still no luck. previsloy we are able to access the same. suddenly it is not connecting. other than AdminUI.log is there any log file i can check regardng this error.
April 13th, 2011 11:07am

Hi, I' opened wbmtest from run and able to connect the site server. while running the query select * from sms_site i'm getting error. is query is correct?
Free Windows Admin Tool Kit Click here and download it now
April 13th, 2011 11:24am

Go to the site you want to run the console on, open WBEMTEST and connect to the SMS namespace on the server you want to connect the console too. Logon and open WBMTEST using the credentials you'd expect to use in the Console ... does it connect to the namespace (\\server\sms\site_<SITECODE>) correctly? Can you run a query like "SELECT * FROM SMS_SITE" for example?
April 13th, 2011 11:30am

Go to the site you want to run the console on, open WBEMTEST and connect to the SMS namespace on the server you want to connect the console too. Logon and open WBMTEST using the credentials you'd expect to use in the Console ... does it connect to the namespace (\\server\sms\site_<SITECODE>) correctly? Can you run a query like "SELECT * FROM SMS_SITE" for example? Namespace should be \\server\ROOT\sms\site_<sitecode> nick
Free Windows Admin Tool Kit Click here and download it now
April 13th, 2011 12:51pm

Is the machine in the same domain? Is this a child-primary? If so, login to the central site server and attempt to connect to the child primary with the central site server's console.nick
April 13th, 2011 12:52pm

Go to the site you want to run the console on, open WBEMTEST and connect to the SMS namespace on the server you want to connect the console too. Logon and open WBMTEST using the credentials you'd expect to use in the Console ... does it connect to the namespace (\\server\sms\site_<SITECODE>) correctly? Can you run a query like "SELECT * FROM SMS_SITE" for example? Namespace should be \\server\ROOT\sms\site_<sitecode> nick Thanks Nick
Free Windows Admin Tool Kit Click here and download it now
April 14th, 2011 4:00am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics