How to Authorize Additional Connections after Connecting to SQL Server

In this article, users can learn to authorize additional connections after connecting them to a Database Engine in SQL Server.

Users can easily connect Database Engine to tools which are running in a computer, especially if they know the names of the instance, or if they are connecting to the engine as a part of the Administrator group. Note that in order to connect a database engine user needs to operate the connection procedure from the host SQL server.

Authorize Additional Connections in SQL Server

Steps for determining the name of Instance

Step 1: Login as a member of Windows Administrator group.

Step 2: Go to Connect to Server and Click Cancel.

Step 3: Select Registered Servers on View menu, if the registered servers don’t automatically display on your screen.

Step 4: Select Database Engine from Registered Servers toolbar > and expand Database Engine> then right-click on Local Server Groups > Go to Tasks > Select Register Local Servers.

Steps to Connect to a Database Engine

Step 1: Open Management Studio, go to File menu and select Connect Object Explorer.

Dialog box Connect to Server will open. Here the Server type will display the type of component which was last used by users.

Step 2: Now Select Database Engine.

Step 3: Open Server name box, here users need to type the Database engine instance that they want to connect. The default name of SQL Server instance is the same as the computer name.

Step 4:  Then click on Connect.

Authorizing Additional Connections

When a user installs a SQL server, he/she becomes an administrator, and one of the first things they do is authorize selected users or engines to connect to their network. For doing so, the user needs to create a login and authorize that login for accessing as a user in that database.

These logins can be Windows Authentication logins that take credentials from Windows or SQL Server Authentication or independent logins with your Windows credentials.

Steps for Authorizing Additional Connections

Note: User needs to create a new login account and access it as a user.

Step 1: Go to Management Studio, > Right Click on Logins > Select New Login.

Login- A New dialog will appear on your screen.

Step 2: The first page is for inserting General information, go to Login name and type ID of your Window login in this format <domain>\<login>.

Step 3: Go to Default Database and select AdventureWorks2008R2 or master, whatever is available. If both options are available then select the former.

Step 4: To turn new login into an administrator, open Server Roles page, and select sysadmin, or just leave it blank.

Step 5: In User Mapping page, select AdventureWorks2008R2 or master database, whichever is available? A user box is already populated with logins so ensure to use a unique login as to avoid any database from replacing any other account. When this file will be closed it will add this user to the selected database.

Step 6: In order to map the login with other database owner schema, type dbo in Default Schema Box.

Step 7: Accept the standard default setting for the Status box and select ‘OK’ to finally create the login.

Now users can use this login to grant Authorization to Additional Connections.

Despite best practices in place, companies can encounter a SQL crash. Hence as a failsafe measure keep a powerful tool to repair sql server database handy.

Author Introduction:

Victor Simon is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including access recovery and sql recovery software products. For more information visit www.datanumen.com

Leave a Reply

Your email address will not be published. Required fields are marked *