Configuring AdminStudio to automatically connect to SQL Database using Windows Authentication

Summary

Synopsis

This article discusses configuring the AdminStudio product to automatically connect to a default Application Catalog Database using Windows Authentication each time the AdminStudio product is launched.

Discussion

The AdminStudio Product needs to connect to a Microsoft SQL Server Application Catalog database when launched. To specify a default Application catalog and connect to it using windows authentication, modify the Shared AdminStudio.ini file by performing the following steps:

1. Locate and open the following file on the machine where AdminStudio is installed:

C:\AdminStudio Shared\Shared AdminStudio.ini

2. Insert the following in the [Database Settings] section of the Shared AdminStudio.ini file:

[Database Settings]

DefaultDatabase=Provider=SQLOLEDB.1;;Initial Catalog=nameofdatabase;Data Source=nameofsqlserver;Integrated Security=SSPI

Note: To connect using Server authentication, you can specify

[Database Settings]

DefaultDatabase=Provider=SQLOLEDB.1;User ID=userid; PWD=password;Initial Catalog=nameofdatabase;Data Source=nameofsqlserver;

Was this helpful?

Support Hub

Product

AdminStudio

Deployment type

On-premises

Visibility

Guest

URL Name

configuring-adminstudio-to-automatically-connect-to-sql-database-using-windows-authentication