Changing My Default Database?

Hi.

I thought I had this solved but after running aspnet_regiis again
I am having the same problem.

I can't log onto my sql server because the default DB is master.
The following command using sqlcmd gives me the master db:


Code:


SELECT *
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
GO



So, to try to fix this i ran:


Code:


EXEC sp_defaultdb 'sa', 'my_default_db'
GO



and no luck. I went over to the DB server and checked
the permissions under SERVER/SQLEXPRESS > SECURITY > LOGINS. All except NTAuthority and Administrators have
my intended DB as the default (including ASPNET).

This is frustrating because I know I have figured it out
before but I can't remember what I did. Help appreciated.

Thanks.