I have a shared hosted SQL Server 2005 at an ISP, that I can connect to from SQL Server 2005 Management Studio. However, I cannot connect from SQL Server 2008 Management Studio.
I log on with SQL Server authentication (username+password).
When I connect, I get the error:
The server principal "MyUserName" is not able to access the database [name of first database on server - 00_something - not mine] under the current security context.
How can I get around this, and just get straight to the one database I do have access to on this server? I tried setting the "Default database" for the connection to the name of my database, but it does not change anything.
I would really like to not have to install SQL Server 2005 Management studio to connect to this one database...