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
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 Can't access database from other computers.

Author  Topic 

jlm159
Starting Member

3 Posts

Posted - 2011-06-21 : 11:13:16
I am setting up a new domain controller that is running Server 2008. We run an MRP software that installs SQL Server 2005 Express on the computer that stores the database (the DC in our case). I am trying to get it setup and am having trouble getting it functional for all computers on the network. I set up the database and brought over a snapshot from the old server, so there is good data in the database.
Currently, it works on the domain controller itself, but when I try to connect from another machine, I cannot set up the ODBC Connection. I get the following error:

Connection failed:
SQLState: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
(Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Drive][DBNETLIB]SQL Server does not exist or access denied.

I have tried to match the settings in Microsoft SQL Server Management Studio Express to those on the old server machine. I did the same for the SQL Server Configuration Manager.
I am not sure what to try from here so I would appreciate any help.

Thanks

Jim Manz

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-06-21 : 11:35:20
Make sure that remote connections are enabled.
Make sure firewall isn't blocking.
Make sure users attempting to login have permission.
Make sure you have the instance name correct in the ODBC connection.
Go to Top of Page

jlm159
Starting Member

3 Posts

Posted - 2011-06-21 : 14:48:29
How do I make sure that the firewall isn't blocking and that the users have proper permission? I have validated the other two.
I followed some directions from http://msdn.microsoft.com/en-us/library/cc646023.aspx. This was to allow the SQl server access through the firewall. However, I am still getting the same error.
When you refer to the permissions, do you mean domain permissions?

Jim Manz
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-06-21 : 15:58:35
Make sure the login exists, I mean, for users attempting to connect. Are you using SQL or Windows Authentication?
Go to Top of Page

jlm159
Starting Member

3 Posts

Posted - 2011-06-21 : 16:09:44
I got it fixed! It turns out that I didn't have the Firewall setup correctly. Thanks for the tip. I had to allow the SQL Server and the SQL Browser Service access through the firewall. I used the following document for guidance: http://support.microsoft.com/kb/914277

Thanks again.

Jim Manz
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-06-21 : 16:17:05
Excellent. Glad you got it sorted out
Go to Top of Page
   

- Advertisement -