SQL Error Msg 10040

I'm trying to connect to an SQL server, but keep getting the following message
"Db-Library network communications layer not loaded"
Does this mean that the server is not responding (i.e. not there)?, and how do I fix it?

Thanks,
Paul
bickieAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

cymbolicCommented:
As a basic test of your connectivity, try first to map to a drive/volume on your server.  Also, sometimes mapping a drive first facilitates your connection to the server.  If this doesn't work (and I suspect it won't) chances are good that a necessary network protocol is not loaded.  Load these in the network icon inside of your control panel inside the My computer icon on your desktop.  Sounds like those little Russian eggs, one inside the other, doesn't it!
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
cmcnallyCommented:
Hi Paul,

There could be a number of reasons for that error, I would recommend trying the following steps.

What protocol is the MS SQL server set up to use? Named Pipes?, SPX?  If so, use Control-Panel, Networks and make sure you have TCP/Ip or SPX installed, and Client for Microsoft networks if you use TCP/IP or Named Pipes.

Have you installed the client utilities for Microsoft SQL server from the Microsoft SQL server CD?  If not, you must install client drivers and choose the 16 bit client or 32 bit client.  When installing the client, you will be asked which 'network support' to install, named pipes, tcp/ip, ipx etc.  The server will be listening on one or more of those protocols.

Reboot.  The installation may add to your Path statement

Find out which prototcol the server is listening to.  Then run the 'sql server configuration utility' on the client.  This utility lets you choose the network protocol to use and will search your 'path' for the proper DLL's to connect to the server.  If the utility cannot find the DLL's then your path may be too long with the addition of the new path to the dll's.  

#3 if you are still having problems
0
bickieAuthor Commented:
Thanks,

I've got it too work now!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.