Connecting to Local Database

Hello,

I am attempting to connect to the local instance of SQL Express running on the VPS through SQL Management Studio (2008 R2), also running on the VPS. It appears as though the local database engine is named 'MSSQLSERVER' in this case but any attempted connection to 'localhost\MSSQLSERVER' fails.

What connecting to the database engine, what connection properties should I be using? Again, it's not a remote connection or anything - everything is being done within the VPS.

Thanks!

Hi There,

You can try on the command prompt SQLCMD /L
SQLCMD /L will list all SQL server in your network.

If your SQL Server instance was installed as a default instance (“MSSQLSERVER”), we can use ".","localhost" or "(local)" to connect to it. If not, we need to specify “.\InstanceName” .

Cheers