views:

24

answers:

2

Is It Possible to connect SQL Server 2008 from SQL Server 2005 Enterprise Manager?

I am getting below mentioned error while connecting 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: 1326)

+1  A: 

Yes it's possible.

KuldipMCA
there problem in your setting if you use network the ask your administrator to check the rights given to your login user. and Default setting is default connected to what ever you define in the Default setting when you install the sql.
KuldipMCA
A: 

Have you used the SQL Server Configuration Manager to enable remote connections?

Under SQL Native Client 10.0 Configuration --> Client Protocols, you need to enable TCP/IP (I assume that's what you are using).

tster