How To change the Authentication method from SQL to Windows when configuring SEPM database.

To change Authentication method from SQL to Windows you need:

•        Create new user in SQL Management Studio
•        Use Management Server Configuration Wizard to reconfigure SEPM

Creating new user in SQL Management Studio.

1.       1.       Connect to the database using Object Explorer.

2.       2.       Go to: Security -> Logins

3.       3.       Press right button on Logins and chose "New Login..."

 4.       In new window fill:

•         Login name - write AD or Local user name – in this situation “PABLO-B8948CAA4\pawel”;

•         Check if  “Windows authentication” is marked;

•         Default database  - Remember to select proper DB - in this case "sepm";

In "Select page" row, chose "User Mapping"

On the right select SEPMs DB (in this case "sepm")

In "Database role membership for: master" select

-          db_datareader

-          db_datawriter

-          db_ddladmin

!!Remember that public should be also selected!!

Press OK.

SEPM Configuration.

1.       1.       Chose option „Reconfigure the management server”

2.       2.     Change Server name.  Symantec suggest leave other options as default.

3.       Select „Microsoft SQL Server”.

• In „Database Server enter full path to database server instance – in this case it is

 “PABLO-B8948CAA4\PAWELDB”

• Database name should be the one which you where using before.

• Authentication: Windows Authentication