I am trying to connect to remote SQL server from VB (developer environment) using DataEnvironment designer and OLE DB for SQL provider. For some reason I get a message "Connection Failed.SQLState:"01000"SQL Server Error: 1326 [DBNMPNTW]ConnectionOpen (CreateFile()),Connection failed SQLState '08001' SQL Server Error 1326". Any idea what should I check? SQL Server is located on Windows NT machine.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Connection to SQL server failed. Error 1326.
- Thread starter tatochka
- Start date
It seems that you are trying to connect via Named Pipes. Check your "client network utility" for correct aliases and that your ole db connection is pointing to the correct server name. Check the protocols supported on your SQL server and that "named pipes" is available. If not, change the protocol in the "client network utility" to whatever the server is supporting.
Hope this helps.
Hope this helps.
- Thread starter
- #3
The server name is correct (I can even ping it from DOS). "Client Network Utility" and "Server Network Utility" both have Named pipes first in the list. I don't know much about network so I don't know what else to check.
- Thread starter
- #4
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question