Step 4: Sitecore XP9 Install using SIF – Ask your SQL Server to buckle up

As a next step there are few activities to be performed at SQL Server end.

Note: Step 1-4 are optional if you already have a Sitecore user in SQL server with sysadmin rights. But if not follow the steps.

1.     Login to your SQL Server. Navigate to Security -> Logins -> Right Click and select on New Login

1

2.    Select SQL Server Authentication. Enter the desired User Name and Password. Uncheck the Enforce Password Policy

2.png

3.    Go to Server Tab and select Sysadmin Role. Click OK

3

4.    Click ok and try login with the new user created. All set? Lets move on.

5.    As a next step we need to Enable Contained Database Authentication. There is a SQL script mentioned in the Installation Guide, we need to execute that script on SQL Server.

sp_configure ‘contained database authentication’, 1;

go

reconfigure;

go

4

Already, next step is Installing SIF.

One thought on “Step 4: Sitecore XP9 Install using SIF – Ask your SQL Server to buckle up

Add yours

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Powered by WordPress.com.

Up ↑

%d bloggers like this: