SQL Server Managment Studio 2005 to an Express data source

I simply mounted SQL Server Standard Edition with the Management Studio. I'm able to connect to my SQL web server instance yet I can not connect to a SQL Server Express instance on a remote computer system.

Is the Management Studio Standard able to connect to an Express data source or do I need to install the SQL Server Management Studio Express?

I made use of to be able to connect to the remote instance under Vista yet I mounted 7 lately and also I can not bear in mind if I mounted the Express variation of the monitoring workshop under Vista ...

I need to additionally add that I can connect to the remote data source making use of Visual Studio 2008 is Server Explorer.

MODIFY : I am still incapable to connect to this details instance ...
Maybe it has something to do with the reality that I'm attached to the web server using a VPN link?
Additionally, are Visual Studio and also SSMS making use of the very same carrier? Could it have something to do with that said?

2019-12-02 03:02:20
Source Share
Answers: 3

For those that do not recognize the Browser service permits customers to see Named Instances, which SQLEXpress (by default) develops a called instance called SERVERNAME\SQLExpress. Without internet browser service running you will not have the ability to see it from another location. Additionally allow the service run as Network Service (or relied on ADVERTISEMENT account is favored, admin civil liberties not required) so you can see it uncreative over your network.

2019-12-03 05:48:03

Firstly see to it the internet browser solution is working on the remote web server - Also see to it you are making use of servername\sqlexpressname

2019-12-03 04:54:39

Make sure the Express instance is set up to approve remote links, check here for information ; the typical SSMS can connect to Express circumstances without a trouble.

2019-12-03 04:35:17