System Center Configuration Manager TechCenter >
System Center Configuration Manager Forums
>
Configuration Manager Admin Console
>
cannot connect to Console
cannot connect to Console
- Hi,
I have SMS Provider and SCCM Console installed on SCCM Server and SQL Cluster on remote server. Before the windows firewall is turned on, the sccm console has no problem connecting to the SQL database. But when the windows firewall is turned on, then the SCCM Console cannot connect to SQL. I see from the log of smsprov.log as shown below, the sms provider cannot connect to the SQL database. But when I tried to connect to SQL database on SCCM Server using ODBC, it can establish the connection. I did DCOM setting on my SCCM server, but it still failed.
e:\nts_sms_fre\sms\siteserver\sdk_provider\smsprov\sspobjectquery.cpp(5566) : SQL Connection attempt timed out
SQL Error: [01000][67][Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
SQL Connection attempt timed out [08001][17][Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. -- [01000][67][Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
[AC8][Wed 10/21/2009 15:34:13]:<*><*> CANT CONNECT TO SQL, RETURNING ERROR <*><*>
Answers
Hi,
Finally it can be connected. I added Inbound UDP for SQL connection- Marked As Answer byWallyMSFT, OwnerThursday, October 29, 2009 2:51 AM
All Replies
- On which server did you turn on the firewall? SQL server or SCCM server?
- On SCCM Server, I turn on the firewall, the firewall on SQL Server is turned off. But in future, both servers will turn on the firewall.
- Hi,
check if the needed port has been opened:
http://technet.microsoft.com/en-us/library/bb632618.aspx
HTH.
Jie-Feng Ren - MSFT - But between SCCM and SQL, it's only 1433. Since SMS Provider sits on SCCM server, the ports are don't need to be opened for those SMS Provider related port.
- Hi,
Here is the firewall settings for SCCM Clients http://technet.microsoft.com/en-us/library/bb694088.aspx
Please check the necessary firewall settings are already have done correctly.
Regards from www.windowsadmin.info
ManuPhilip - Hi,
But now the console cannot connect to SQL, nothing to do with the sccm client yet. - Have you tried to make a program exception instead of just a port opening in the firewall?
Hi,
Finally it can be connected. I added Inbound UDP for SQL connection- Marked As Answer byWallyMSFT, OwnerThursday, October 29, 2009 2:51 AM
