-
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_S3DStandardUser.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>\S3DStandardUser.SQL
Replace [Database_Name] with your Site database name in Windows_S3DStandarduser.SQL or S3DStandardUser.SQL.
-
Press ENTER.
-
Rerun the Windows_S3DStandardUser.SQL or S3DStandardUser.SQL script six more times providing the Site Schema, Catalog, Catalog Schema, Model, Report, and Report Schema database names as you did for the Site database.
-
After the script finishes, close the command window.