Click here to Skip to main content
15,881,248 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
when open server i not found any server in server name
i type "."not connect
Posted

1 solution

You can follow these steps to get it resolved.
1. Pull down the Server Name combo
2. Click on <browse for more...>
3. In Local Servers tab, expand the Database Engine element 
4. Hopefully, you will find your server name here. Just select it and click OK. That's it

//If this doesn't resolve your problem
5. Sometimes it doesn't appears in the Local Servers tab and you may find it in the Network Servers tab

//if this doesn't help
6. Usually the server name is same as your computer name. Right click on the My Computer and go to properties where you can find the name of your computer. Type that as the server name.

//if this doesn't help
7. If you have installed SQLExpress then try adding "\SQLExpress" to the computer name while typing as server name.


Update

As the above solutions don't help, please try this
Go to SQL Server Configuration Manager > SQL Server Services > In Right Side window show all the servers which may stop. If you are using "SQLEXPRESS" then , Right click on SQL Server(SQLEXPRESS) and start

Try searching the solution in following links
Unable to connect to SQL Express "Error: 26-Error Locating Server/Instance Specified)[^]
Solution: Error: 26 – Error Locating Server/Instance Specified[^]


Hope, it helps :)
 
Share this answer
 
v3
Comments
ramadan2 25-Mar-15 2:26am    
i try all that
not connect error 26
Suvendu Shekhar Giri 25-Mar-15 2:41am    
Please check the updated solution :)
Joan Magnet 25-Mar-15 8:17am    
Maybe you haven't installed any server, only the Sql Server Management tools.

Download the correct version.
Suvendu Shekhar Giri 25-Mar-15 8:18am    
Yes, that can also be the problem.
Joan Magnet 25-Mar-15 8:26am    
There are a lot of SQL Server Express downloads. Some of them are only tools. Choose the correct version.

Check the install directory.

http://dba.stackexchange.com/questions/92022/sql-server-express-2014-installation-directory

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900