I have inherited a Windows 7 Professional pc with an existing instance of SQL Express 2008. I have local admin rights on the machine. I do not know the SA password. I am unable to create databases or logins, or modify the SA login's password. I would like to grant my domain account SYSAdmin privileges.
I have tried the following, in both situations I right clicked and ran SQL management studio as Administrator, and used Windows authentication to log in to the local SQL express.
I created a local admin account, with administrator privileges and logged in to my PC as that. I have logged to my PC as a Domain Admin.
I understand that if I log in as an administrator using windows authentication I should have full privileges, what can can be stopping me from getting this access?