Including a manager customer to SQL Server 2008

Just how do you add a manager customer to SQL Server 2008?

0
2019-05-07 09:06:54
Source Share
Answers: 2

Hmm, there are 2 various points this can suggest.

  1. Just how do I create a new customer account that has management civil liberties?
  2. I currently have a windows customer that is a manager, just how do I add that customer to SQL?

Solutions:

  1. In SQL Management Studio, create a new login and also add it to the sysadmin server duty.
  2. In SQL Management Studio, create a login attached to the Windows account or a team that it's a participant of. You could well locate BUILTIN \ Administrators is currently there.
0
2019-05-09 03:08:39
Source

If you're doing it using T - SQL :

Granting a Windows Login the capacity to connect to SQL Server :

CREATE LOGIN [Domain\User] FROM WINDOWS;

or

CREATE LOGIN [Domain\Group] FROM WINDOWS;

If SQL Server - based login :

CREATE LOGIN [LoginName] WITH PASSWORD = 'SomePassword';

After that, you can do either points. You can add it to the subscription of the sysadmin dealt with web server duty making use of sp_addsrvrolemember :

EXEC sp_addsrvrolemember 'LoginName', 'sysadmin';

or you can grant the login CONTROL SERVER permissions :

GRANT CONTROL SERVER TO [LoginName];
0
2019-05-08 21:19:59
Source