Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Add another administrator

Author  Topic 

e.heijmans@12move.nl
Starting Member

10 Posts

Posted - 2015-02-10 : 03:54:52
I recently bought a Surface Pro 3 and installed SQL Server on it. I added the current user as sysadmin. Later I created other accounts.

Now I have the problem that I forgot to add the other accounts to the role sysadmin. And for some strange reason, I can't log on with the original account anymore (this was a email account that the Surface uses; this problem is posted in another forum).

So I can't logon to SQL Server with my local account. I tried to run setup again, hoping that I could add administrators there. But I can't get past the Features page. That gives me an error telling me I haven't selected anything. But the checkboxes are greyed out.

Has anyone any idea on how to solve this?

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2015-02-11 : 01:49:26
When you installed the SQL Server , did you set up the "sa" username , what password did you choose?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

e.heijmans@12move.nl
Starting Member

10 Posts

Posted - 2015-02-13 : 05:01:26
Hi Jack,
I've installed in Windows mode, so I can't use sa.

But someone else provided the solution by turning my attention to this link:

[url]http://www.mssqltips.com/sqlservertip/2465/how-to-connect-to-sql-server-if-you-are-completely-locked-out/[/url]
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2015-02-16 : 01:37:27
useful , thanks

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -