hi, i am trying to acces my database but i get this error. I allowed remote
connections in sql server 2005 but i still get the error.
TITLE: Connect to Server
--
Cannot connect to MSSQLSERVER.
ADDITIONAL INFORMATION:
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.
(provider: Named Pipes Provider, error: 40 - Could not open a connection to
SQL Server) (Microsoft SQL Server, Error: 53)
Hoping for some help , kind regards xenta.How is the client configured? Check with cliconfg.exe.
What app are you using? If not a tool like QA, SSMS etc, then what does the
connection string look
like?
How is the server configured? Check with SQL Server Configuration Manager. D
oes it listen to Named
Pipes, for instance.
The error states that the client tries to connect using Named Pipes.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"zentax" <millionsmillions@.hotmail.com> wrote in message
news:eYGOxgcdHHA.2088@.TK2MSFTNGP05.phx.gbl...
> hi, i am trying to acces my database but i get this error. I allowed remot
e connections in sql
> server 2005 but i still get the error.
> TITLE: Connect to Server
> --
> Cannot connect to MSSQLSERVER.
> --
> ADDITIONAL INFORMATION:
> 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. (provider: Named Pipes Provider, error:
40 - Could not open a
> connection to SQL Server) (Microsoft SQL Server, Error: 53)
>
> Hoping for some help , kind regards xenta.
>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment