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.
| 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.ThanksJim 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. |
 |
|
|
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 |
|
|
|
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? |
|
|
|
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/914277Thanks again.Jim Manz |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-06-21 : 16:17:05
|
Excellent. Glad you got it sorted out  |
|
|
|
|
|
|
Can't access database from other computers.