Hi all, i installed SQL Server management Studio 2005 of express edition in a server when i am trying to connect to server after installation i am getting the error < can not connect to server Additional Information:a network related or instance specific error occured while establishing a connection to sql server .the server was not found or not accesible.verify that the instance name is correct and the sql server is configured to allow remote connections .(provider:named pipes provider,error:40-could not open a connection to sql server)(microsoft sql server, error:2) > can any one suggest how to connect to instance.
asked Aug 08 '11 at 06:33 AM in Default
Named Pipes? Take a look at the server configuration. make sure that the TCP/IP protocol is enabled. it's unlikely that most systems these days are running named pipes such that you can make that type of connection. Just about everyone runs TCPIP though.
answered Aug 08 '11 at 06:44 AM
Grant Fritchey ♦♦