But when im trying to add connection, select my computer at Server
name, type a databasename then pressing OK i get this message:
An error has occured while estabilishing a connection to the server.
When connection to SQL server 2005, this faliure may be caused by the
fact that under the default settings SQL Server does not allow remote
connections. (provider: Names pipes provider, error: 40 - Could not
open a connection to SQL Server)
Does anyone know what todo?
hermanTry this: open the SQL Server Configuration Manager, expand SQL Server 2005 Network Configuration, highlight protocols for MSSQLSERVER and enable TCIP/IP.
Mike
No comments:
Post a Comment