| Author |
Topic |
|
mccoigk
Starting Member
12 Posts |
 Posted - 2009-01-13 : 13:43:18
|
| I am creating a new System DSN on a workstation in a remote domain from my SQL Server I want to connect to. When I browse for the data source none of the SQL servers in my domain are in the list, only the remote domain servers can be seen. Fine, so I type in the server name along with the login and get SQL Server error 53 and 17 (SQL Server does not exist or access denied). I know the multiple logins Im trying are correct, I even try with IP address even though I know WINS/NETBIOS/lmhosts is setup properly. Nothing works.I thought the problem was domain related or possibly a firewall problem however I have no problems creating a data source in the remote domain to gather data from other SQL Servers in my domain and other remote domains.I dont think the problem is TCPIP or Named Pipes as I can connect from other workstations in my domain with the same SQL Server.Any ideas on how to fix this? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
mccoigk
Starting Member
12 Posts |
Posted - 2009-01-13 : 14:05:11
|
| OK, went to 'Client Config' for TCP/IP I unchecked 'Dynamically determine port' and entered port 1433. Now my error message is 10060 and 17, cant connect. Any other ideas? Thanks for your help. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
mccoigk
Starting Member
12 Posts |
Posted - 2009-01-13 : 14:18:00
|
| I thought that was the default port? I know we've never changed any settings in our SQL Servers so I was guessing that was the default. Is there a place to check this to be sure? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
mccoigk
Starting Member
12 Posts |
Posted - 2009-01-13 : 14:41:22
|
| Verified in the error log: 'Server is listening on ['any' <ipv4> 1433]. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
mccoigk
Starting Member
12 Posts |
Posted - 2009-01-13 : 15:22:36
|
| Here it is:[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
mccoigk
Starting Member
12 Posts |
Posted - 2009-01-13 : 18:10:11
|
| It returned an error. So I guess I am chasing a network config problem.... |
|
|
|
|
ODBC Data Source Connection problems