Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 SQL Server 2008 Connection Failed

Author  Topic 

ss2008dba
Starting Member

2 Posts

Posted - 2011-02-14 : 11:56:05
Hi All,

This error is occurring with all users on a system with ODBC access to a SQL Server 2008 database on the same network:

Connection Failed:
SQL State '01000'
SQL Server Error 10060
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect())
Connection Failed:
SQL State '08001'
SQL Server Error 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

We also cannot connect to the database using SQL Server Management Studio, which is installed on a different server on the network that the database is hosted on. All users connect to the db via Windows authentication and we all have active directory domain accounts in a Windows Server 2008 Small Business Server network.

All users had been able to access the database previously with no problems up until this morning when we all attempted to log in. I was able to check the SQL Server Configuration Manager and the database service is started and running.

The SA says nothing has changed in the system over the weekend, but I'm thinking that a port may have been closed on the firewall or that something has changed in our Windows accounts that's causing the domain accounts to not be authenticated through SQL Server.

Can anyone provide any guidance on what type of changes to the system that could have caused this issue or provide any other troubleshooting tips so we can restore connections to the database?

Thanks,
Gupta

Peter99
Constraint Violating Yak Guru

498 Posts

Posted - 2011-02-14 : 15:02:40
in sql server configuratin manager check remote connections enable for local and remote connections.
Go to Top of Page

ss2008dba
Starting Member

2 Posts

Posted - 2011-02-14 : 16:49:17
This issue has been resolved. The SA enabled Windows firewall which was blocking access to the SQL Server ports on the db server. Those ports were opened in the firewall and now all is well....
Go to Top of Page
   

- Advertisement -