-
Log on to the Microsoft SQL database server computer using the local administrative account.
-
Open a command prompt window.
-
If you are using Windows authentication, type the following command at the command prompt:
sqlcmd -S <ComputerName>\<ServerName> -i <FileLocation>\Windows_S3DAdminUser.SQL
-OR-
If you are using SQL authentication, type the following command at the command prompt:
sqlcmd -S <ComputerName>\<ServerName> -U <username> -P <password> -i <FileLocation>\S3DAdminUser.SQL
-
Press ENTER.
-
Optionally and only if you want to grant the db_owner role to the new login user on already existing databases, run this script:
If you are using Windows authentication, type the following command at the command prompt:
sqlcmd -S <ComputerName>\<ServerName> -i <FileLocation>\Windows_S3DGrantAdminOwnership.SQL
-OR-
If you are using SQL authentication, type the following command at the command prompt:
sqlcmd -S <ComputerName>\<ServerName> -U <username> -P <password> -i <FileLocation>\S3DGrantAdminOwnership.SQL
Replace [Site_Database_name] in the script with your Site database name and likewise for Site Schema, Catalog, Catalog Schema, Model, Report, and Report Schema database in Windows_S3DGrantAdminOwnership.SQL or S3DGrantAdminOwnership.SQL.
-
Press ENTER.
-
After the script finishes, close the command window.