April 4, 2003 at 10:52 am
We're running SQL7 on W2K. On the LAN it works great. Our remote users are having problems connecting through the VPN, getting the same error message each time.
Connection failed:
SQLState: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQLServer Driver][Named Pipes]ConnectionOpen(CreateFile()).
Connection failed:
SQLState: '08001'
SQL Server Error: 6
[Microsoft][ODBC SQLServer Driver][Named Pipes]Specified SQL server not found.
TechNet recommended switching to Named Pipes. This is the result. Over TCP/IP we got SQL server error 11 (general network error) instead of the 6. I don't know if that's a step forward or back.
In our SQL setup we have 1433 listening for TCP/IP and Named Pipes. The pipe names are correct in the client configs. Why is it not finding the server?
Any help is greatly appreciated.
April 4, 2003 at 11:00 am
If your users can't ping your SQL server and can ping the IP adress, then maybe you should add an alias from the client network utility of SQL on every client machine.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply