0

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.

5
  • 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, 2019 at 5:54
  • Yes, I tried,But its also show the only client's database.
    – Loran
    Mar 1, 2019 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, 2019 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, 2019 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, 2019 at 20:09

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.