connection error

Question

Post reply

connection error

mayank jarsaniya

Hall of Fame

Points: 3532
More actions
December 24, 2009 at 8:15 am

#136962

hi i got following error:
i am using sql server authenticated user and has all the rights to sql server.
An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Communication link failure".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Named Pipes Provider: No process is on the other end of the pipe.

Viewing 14 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply

steveb. SSC-Forever Points: 46733 More actions · Answer 1

I have to ask;

Does your SQL server allow remote connections and named pipes?

you have to enable this in SQL server configuration manager

Steve Jones - SSC Editor SSC Guru Points: 738609 More actions · Answer 2

Steve Jones - SSC Editor

SSC Guru

Points: 738609

December 24, 2009 at 8:27 am

#1096321

Also, are you local or remote to the SQL server?

mayank jarsaniya Hall of Fame Points: 3532 More actions · Answer 3

yes i am alowing remote connections and tcp and named pipes both are enabled

Steve Jones - SSC Editor SSC Guru Points: 738609 More actions · Answer 4

the pipe isn't open, as shown in the error. Does the SQL Server error log on startup show listening on the port/pipe you're using? Are you on the same machine as the SQL Server? Which version of SQL is this?

steveb. SSC-Forever Points: 46733 More actions · Answer 5

Is SQL Browser running?

also as above, are you local or remote?

mayank jarsaniya Hall of Fame Points: 3532 More actions · Answer 6

i am local and database and .net application both resides on single machine.

Sql Server Browser is running.

I have created a sql server user and granted all the roles and permission to them

Jeffrey Williams SSC Guru Points: 90350 More actions · Answer 7

Is this a named instance on your local PC? If so, what is the name of the instance and how are you trying to connect?

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

mayank jarsaniya Hall of Fame Points: 3532 More actions · Answer 8

hi it is default instance.....not a named.

i am connecting through dot net application using a sql server authenticated user.

user has all the rights as 'sa'.

Ritesh Medhe SSCommitted Points: 1941 More actions · Answer 9

are you able to connect through SSMS if sql2k5 or Enterprise manager sql2k?

mayank jarsaniya Hall of Fame Points: 3532 More actions · Answer 10

mayank jarsaniya

Hall of Fame

Points: 3532

December 28, 2009 at 2:41 am

#1096631

yes...i can connect..

Steve Jones - SSC Editor SSC Guru Points: 738609 More actions · Answer 11

Steve Jones - SSC Editor

SSC Guru

Points: 738609

December 28, 2009 at 9:04 am

#1096718

What's your connection string?

Ritesh Medhe SSCommitted Points: 1941 More actions · Answer 12

Ritesh Medhe

SSCommitted

Points: 1941

December 28, 2009 at 10:56 pm

#1096905

is it SQL Server 2005 Express?

Ritesh Medhe SSCommitted Points: 1941 More actions · Answer 13

can you let me know the port on which SQL service is running?

if it is not running on default port 1433 then you need to create an alias using SQL Server Configuration Manager or else you need to create a system dsn in odbc...