Solved

ODBC Connection to MS SQL Server

Posted on 1997-10-30
2
726 Views
Last Modified: 2008-03-06
I get this error message when I try to connect to a MS SQL server from a client.


Connection Failed:
SQLState: '01000'
SQL Server Error: 1326
[Microsoft][ODBC SQL Server Driver][DBNMPNTW]ConnectionOpen CreateFile()).
Connection Failed:
SQLState: '08001'
SQL Server Error: 1326
[Microsoft][ODBC SQL Server Driver][DBNMPNTW]ConnectionOpen (CreateFile()).
0
Comment
Question by:arcam
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 6

Expert Comment

by:jpk041897
ID: 1089031
How is you system set up?

Is the DB on the same box, or on a sepparete server?

How are you mapping your connection to the DB server.

This kind of error usualy shows up when communication between the client and the server cannot be initialized.
0
 
LVL 3

Accepted Solution

by:
Pegasus100397 earned 50 total points
ID: 1089032
Arcam, I've seen this problem as well on a server that is so busy running a database recovery that it cannot process the connection request. Check the server utilitization to see how busy it is. If the problem is random or only during heavy-usage times then this is most likely the problem. Add more memory, faster machine, etc.

Good luck with your problem!
Pegasus
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

635 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question