December 24, 2009 at 8:15 am
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.
December 24, 2009 at 8:23 am
I have to ask;
Does your SQL server allow remote connections and named pipes?
you have to enable this in SQL server configuration manager
December 24, 2009 at 8:27 am
Also, are you local or remote to the SQL server?
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
December 24, 2009 at 8:35 am
yes i am alowing remote connections and tcp and named pipes both are enabled
December 24, 2009 at 8:37 am
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?
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
December 24, 2009 at 8:38 am
Is SQL Browser running?
also as above, are you local or remote?
December 25, 2009 at 4:35 am
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
December 25, 2009 at 9:25 am
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
Problems are opportunities brilliantly disguised as insurmountable obstacles.
How to post questions to get better answers faster
Managing Transaction Logs
December 27, 2009 at 11:00 pm
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'.
December 28, 2009 at 1:45 am
are you able to connect through SSMS if sql2k5 or Enterprise manager sql2k?
December 28, 2009 at 2:41 am
yes...i can connect..
December 28, 2009 at 9:04 am
What's your connection string?
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
December 28, 2009 at 10:56 pm
is it SQL Server 2005 Express?
December 28, 2009 at 11:14 pm
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...
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply