Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MangoSkin
Starting Member
22 Posts |
 Posted - 2010-07-04 : 00:14:03
|
| I installed Sql Server 2008 on Windows 7 Professional. But when I try to connect to the database enginer I am getting this error.TITLE: Connect to Server------------------------------Cannot connect to mssqlserver.------------------------------ADDITIONAL INFORMATION:A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that 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: 53)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476------------------------------BUTTONS:OK------------------------------Please help. |
|
|
jaydavisus
Starting Member
2 Posts |
Posted - 2010-07-06 : 20:34:05
|
| If you are connecting to the local instance use localhost as the Server Name. Connecting using the default instance name of MSSQLSERVER indicates to the server the connection is coming from outside and therefore it looks to see if Remote Connections are enabled. By default they are not. Use localhost.Jay D. |
 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-07-07 : 02:54:28
|
| Make sure that the service is running and try to connect using the servername "(local)"- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
|
|
|
|
|
|
Installed Sql Server 2008 On Windows 7