I just installed SQL Server Standard Edition with the Management Studio. I'm able to connect to my SQL server instance but I can't connect to a SQL Server Express instance on a remote computer.
Is the Management Studio Standard able to connect to an Express database or do I have to install the SQL Server Management Studio Express ?
I used to be able to connect to the remote instance under Vista but I installed 7 recently and I can't remember if I installed the Express version of the management studio under Vista...
I should also add that I can connect to the remote database using Visual Studio 2008's Server Explorer.
EDIT: I am still unable to connect to this specific instance...
Maybe it has something to do with the fact that I'm connected to the server via a VPN connection?
Also, are Visual Studio and SSMS using the same provider? Could it have something to do with that?