| Author |
Topic |
|
dishask23
Starting Member
5 Posts |
 Posted - 2009-10-22 : 15:36:44
|
| Hi!I am using SQL Server Management Studio Express on my home PC with Windows XP SP3.There is no default server name mentioned in the "connect to server" popup window. When I try to browse for more also, it doesnt display any server name. I have tried to enter the machine name itself as the server name but it doesnt connect and shows the following error:TITLE: Connect to Server------------------------------Cannot connect to disha.------------------------------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: 2)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476------------------------------I have unblocked port 1434 from the Windows Firewall and gone through the help windows as well but I cant figure out what the problem might be.Please suggest to me what I can do in order to connect to the server. Thanks a lot!RegardsDisha |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dishask23
Starting Member
5 Posts |
Posted - 2009-10-23 : 05:54:27
|
| I have read your blog and followed the following link metnioned by you:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=101037&whichpage=2I entered the server name as IP address or hostname, PortNumber as well as with the prefix tcp: but got the same error as ssss28 in the thread.I tried to see which instance is installed in SQL Server Configuration Manager. When I click SQL Server 2005 Services, it shows "there are no items to show in this view"the default instance MSSQLSERVER is nowhere to be seen. What shall I do now? |
 |
|
|
dishask23
Starting Member
5 Posts |
Posted - 2009-10-23 : 05:58:13
|
| Also in SQL Server 2005 Surface Area Configuration, when I click Suface Area Configuration for Services and Cinnections, I get the following error:TITLE: Surface Area Configuration------------------------------Could not load file or assembly 'Microsoft.SqlServer.CustomControls, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (SQLSAC)------------------------------BUTTONS:OK------------------------------ |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dishask23
Starting Member
5 Posts |
|
|
dishask23
Starting Member
5 Posts |
Posted - 2009-10-31 : 11:25:59
|
| Hi!Please can you tell me whether I need to download anything else besides sql server management studio express. I am eagerly awaiting your response. Thanks a lot! |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-10-31 : 13:28:45
|
| you need to install sql server, not just management studiodownload page: http://www.microsoft.com/downloadS/details.aspx?familyid=220549B5-0B07-4448-8848-DCC397514B41&displaylang=en |
|
|
|
|
cannot connect to server