Connecting to Local Database
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.