I work at a company where most things are password protected by a system admin password (which I dont have). Today I downloaded SQL Server and set up a basic local server. I was able to get in but when I went to create a new database it told me I didnt have authority.
I went to the security --> login tab and saw that it had not automatically defaulted my account to system administrator. Looking at the SA account, I can see it is password protected. Despite my best efforts I am unable to grant myself sysadmin access.
Does anyone know if SQL Server would automatically include the system password? I put no passwords in when setting up the server.
Any ideas or insight would be greatly appreciated.
