The
Atlas Hub database administrator should follow these steps to set up Windows authentication for SQL Server:
-
Create a domain service for
Atlas Hub admin. For example:
service.starteamadmin
-
Login to the
Atlas Hub machine as an administrator and add that account to the administrator group.
-
Shutdown the
Atlas Hub.
-
Login to
Microsoft SQL Server database machine and add the service account to
Microsoft SQL Server and change the db ownership to this account using the following script. The following script adds login
service.starteamadmin to
Microsoft SQL Server.
Login as sa
Use master
GO
Create LOGIN [<domain name>\service.starteamadmin] FROM WINDOWS WITH DEFAULT_DATABASE=<starteam database name>
GO
Use <starteam database name>
GO
Exec sp_changedbowner [<domain name>\server.starteamadmin]
GO
Replace
<starteam database name> with the
Atlas Hub database name and
<domain name> with the domain name.
-
Log back in to
Atlas Hub production machine using the
Atlas Hub service account.
-
Go to Server Administration and open the configuration properties.
-
Click on the
Database Connection tab.
-
Check the box
Use Windows Authentication then click
Verify to verify database connection.
-
Click
OK.
-
Click the menu option
.
-
Uncheck the
localsystem account and define the service using
Atlas Hub service account.
-
Make sure the user account settings are set to
Never Notify.
-
Start the server.