SQL Server Enabling Authentication

John Smith

  • May 31, 2019


Before reading this piece of writing you must have a basic understanding of Microsoft SQL Server Management Studio. If you are familiar with the application you will understand the procedure quickly, but if you never used SQL Server before and going to try it for the first time it will be a little harder for you to understand.

If you are willing to get Microsoft SQL Server 2017 price you are welcome to visit Xcentric Services, Microsoft Partners in Pakistan here you can check all original Microsoft products available for users in Pakistan.

This blog explains how you can permit SQL Server authentication, and how you can use it with a Business Intelligence case. SQL Server authentication is recommended for connecting Business Intelligence to its application and warehouse databases for security reasons.

SQL Server Enabling Authentication Through SQL Management Studio

To enable SQL Server Authentication for your help you have to do these steps first of all open SQL Server Management Studio and then just connect to the SQL Server instance you would like to use for Business Intelligence. After that, you will see Object Explorer, right-click the server, and then click Properties. At server properties, you will be able to see many options but you have to go to the Security page, under Server authentication, select SQL  and Windows Authentication mode, and then click OK. After getting to Object Explorer, right-click on your server, and just click on Restart. If the SQL Agent is running, it must also be restarted.

Using SQL Server Authentication In Business Intelligence

Creating A SQL Server Authentication User

During the deployment of an instance with new databases, the user must have the System Admin role, or else all of these, Database Creator, Disk Admin, Process Admin, and Security Admin.

Create a user like this in SQL Management Studio by following mentioned steps. Open SQL Management Studio and then connect to the SQL  instance you would like to use for Business Intelligence. You have to expand the Security folder and right-click on the logins folder, and then click New Login.

Then enter the login name as Business Intelligence User, select the SQL Server Authentication radio button, and enter the passwords. You will then click the Server Roles page and check the System Admin Role, or the combination of Database Creator, Disk Admin, Process Admin, and Security Admin Roles.

After deploying an instance, it is possible to remove the System Admin role from this user. For regular operation, the user will only require the default schema and the database owner role membership. The System Admin role will be required again when attempting to upgrade an instance.

How To Change Existing Occurrence To Enable Authentication?

Follow the mentioned procedure to change an existing occurrence to start using SQL  authentication after enabling it for its submission and databases.

Application Database

Run Notepad as administrator on your computer, it is simple all you have to do is to right-click on it and select the Run as administrator option. Control the linking sequence to use SQL  confirmation. After saving, reset Business Intelligence’s application pool in IIS. Updated application database connection string. To change the credentials when the connection string is encrypted, first, decrypt the connection string using the exe. file command-line tool, then update the credentials. To get back to the protected position, encode the linking sequence when you update the authorizations.

Warehouse Database

Manage the Data Linking Sequence option given in the general type with the new linking sequence that uses SQL Server validation.

Hope this blog helped you out and that you are able to enable the authentication by yourself. Getting the original Microsoft SQL Server 2017 Price is a bit tough job online but at Xcentric Store you can check all prices and you can buy Microsoft Original Products.







Want To Increase Your Ranking On The Search Engines?
Get In Touch With Us!

Fields marked with * are required.