Can not connect to SQL Server from client

Question

I have SBS2008 Standard with SQL2005 Express. I have created a database in the ServerName/SBSMonitoring instance for an application. I have allowed TCP:1433 through the Windows Firewall, I have changed the access to allow remote access via Surface Area config however I can not connect to the SQL Server when I create a DSN on a client. I can create one locally on the SBS and connect ok. Apart from the firewall and the default of local access only via Surface Area config I can not think what else would cause this. Now obviously I can resolve the Server name and ping it.

 

Any ideas?

Answer 1

Hi Bob,

Can you provide us with the exact error messages that comes up ?

---

Thanks, Leks

Answer 2

Hi Leks,

Thanks for coming back to me, it was stating that it could not connect to the Server however I have resolved this by doing the following. On the Server go to SQL Server configeration manager. There are two SQL instances listed, the one I was trying to connect to displayed an APIPA address so I changed this to the IP address used by the Server and restarted the Service. This then allowed me to connect.