dbTalk Databases Forums  

SQL server connection

comp.databases comp.databases


Discuss SQL server connection in the comp.databases forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
sara
 
Posts: n/a

Default SQL server connection - 09-20-2006 , 03:04 PM






Hi All,

I was able to connect to MS SQL Server 2005 on my computer but after a
while I can not. When I want to connect to it using MS SQL Server
Management Studio I got this error:

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) (.Net SqlClient Data Provider)

Error Number: 2
Severity: 20
State: 0

Can you help me?
Thanks a lot in advance.


Reply With Quote
  #2  
Old   
Ed Prochak
 
Posts: n/a

Default Re: SQL server connection - 09-21-2006 , 01:24 PM







sara wrote:
Quote:
Hi All,

I was able to connect to MS SQL Server 2005 on my computer but after a
while I can not. When I want to connect to it using MS SQL Server
Management Studio I got this error:

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) (.Net SqlClient Data Provider)

Error Number: 2
Severity: 20
State: 0

Can you help me?
Thanks a lot in advance.
What did your DBA (Database Administrator) say?



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.