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 |
|
Movva
Starting Member
15 Posts |
 Posted - 2011-06-03 : 14:41:05
|
| Hi,I have downloaded and installed Sql Server 2008 R2 express edition on my Windows 7 Home premium. When I try logging into my Management studio I am getting the below errorTITLE: Connect to Server------------------------------Cannot connect to local.------------------------------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------------------------------I only see Sql Server Management Studio, Sql Server Configuration Manager under programs. Can some one help how do I fix the above issue.Thanks,L |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Movva
Starting Member
15 Posts |
Posted - 2011-06-03 : 15:17:21
|
| Tara, Thanks for the quick reply. By default it was (local) in the server name and it was not connecting and throwing the error. But as you said I tried (local)\sqlexpress for the server name and it works like a charm. Can you help me understand why it does and doesn't when server name as just (local)? Appreciate your time. I am just trying to understand more stuffThanks,L |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Movva
Starting Member
15 Posts |
Posted - 2011-06-03 : 15:40:22
|
| Thanks. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Cannot connect to local.