Currently, I am using the SQL Server 2012 Express version and it is installed on Windows Server 2012 R2. Now I just want to connect to this database from a Windows 7 client. The Windows 7 computer already has its own SQL Server 2012 Express.

When I browse the database from the client, I only see client database's instance name only. There is no server's instance.

I already enabled the Named Pipes and TCP/IP on the server and I am new in that kind of business. So please let me know how can I connect to the SQL Server on the server from the client.

  • How are you browsing from the client? If you're selecting "Browse for more" in the SSMS connect dialog, make sure you've selected the Network Servers tab to view machines on the network. – HandyD Mar 1 at 5:54
  • Yes, I tried,But its also show the only client's database. – Loran Mar 1 at 5:57
  • Please take a look at Microsoft's instructions. If some step fails, add a screenshot about it. Any error messages are useful too. – vonPryz Mar 1 at 6:27
  • @Loran, the browse functionality is not reliable depending on the network topology. To connect to a remote instance named SQLEXPRESS, you should be table to connect specifying the host and instance name, like "SomeServer\SQLEXPRESS". – Dan Guzman Mar 1 at 11:32
  • Check that the SQL Browser service is running on the server. If it is not, the client won't be able to connect using the name of the instance. – Doug Deden Mar 1 at 20:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.