ITQ’s End User Portal for System Center Orchestrator (EUPSCO) – Part 4: Database

In our previous post (ITQ’s End User Portal for System Center Orchestrator (EUPSCO) – Part 3: Service Accounts), we covered setting up/preparing the Service Accounts. In this post we follow Damian Flynn’s steps on the Database.

The following is a re-write (to accommodate screenshots) from Damian Flynn’s article, with the addition of screenshots by me.

 

Database

In this lab example, I will be using the existing SQL Server installation and existing SQL Instance that I used for the Orchestrator installation. This is not necessary, but makes things simpler and more contained.

Start by launching SQL Server Management Studio, ensure to run it as Administrator.

sql-server-management-studio ITQ's End User Portal for System Center Orchestrator (EUPSCO) - Part 4: Database

Connect to the existing SQL Server Instance. In my example, my server name is EUPSCO, and my SQL Instance name is also EUPSCO.

sql-server-management-studio ITQ's End User Portal for System Center Orchestrator (EUPSCO) - Part 4: Database

In the Object Explorer, expand the Server Name, and select expand Security.

sql-server-management-studio ITQ's End User Portal for System Center Orchestrator (EUPSCO) - Part 4: Database

Right-click on Logins, and select New Login.

sql-server-management-studio ITQ's End User Portal for System Center Orchestrator (EUPSCO) - Part 4: Database

In the New Login dialog,enter the Service Account that we created in Part 3 – Service Accounts, along with the domain; then click OK. In my lab example this is: SCEUPSCO_AppPool.

sql-server-management-studio ITQ's End User Portal for System Center Orchestrator (EUPSCO) - Part 4: Database

Now, still in the Object Explorer, expand the Server Name, and expand Databases.

sql-server-management-studio ITQ's End User Portal for System Center Orchestrator (EUPSCO) - Part 4: Database

Right-click on Databases and select New Database.

sql-server-management-studio ITQ's End User Portal for System Center Orchestrator (EUPSCO) - Part 4: Database

On the New Database dialog, provide a Database Name. In my lab example, I used EUPSCO.

sql-server-management-studio ITQ's End User Portal for System Center Orchestrator (EUPSCO) - Part 4: Database

In the Owner field, click the “…” button to present the Select Database Owner dialog, enter the Service Account name, then click the Check Names button.

sql-server-management-studio ITQ's End User Portal for System Center Orchestrator (EUPSCO) - Part 4: Database

On the Multiple Objects Found dialog, select the Service Account that you created, then click OK.

sql-server-management-studio ITQ's End User Portal for System Center Orchestrator (EUPSCO) - Part 4: Database

Back on the Select Database Owner dialog, click OK.

sql-server-management-studio ITQ's End User Portal for System Center Orchestrator (EUPSCO) - Part 4: Database

Back on the New Database dialog, it should now show both the Database Name and Owner fields filled out; then click OK to create the database (accepting the defaults for Database File Size, and Log File Size).

sql-server-management-studio ITQ's End User Portal for System Center Orchestrator (EUPSCO) - Part 4: Database

In the Object Explorer, you should now see the newly created database. In my lab example, this is EUPSCO.

sql-server-management-studio ITQ's End User Portal for System Center Orchestrator (EUPSCO) - Part 4: Database

 

In our next post, we will discuss the Portal Installation steps.

%d bloggers like this: