Summary
Configuring AdminStudio to automatically connect to SQL Database using Windows AuthenticationSynopsis
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?
Related Articles
Inventory Adapter Studio installations on standalone beacons cannot connect to source databases using SQL Authentication 4Number of Views Authentication error when attempting to enable Windows Authentication and connect to AdminStudio via Enterprise server tab 12Number of Views Automatically Log into AdminStudio Enterprise Server in AdminStudio Enterprise with Windows Authentication 6Number of Views Manage AdminStudio users through AES or WFM without adding them to SQL 10Number of Views Error 27502.Could Not Connect to Microsoft SQL Server '(local) Using MSOLEDBSQL 19.0 31Number of Views
Revenera Assistant
Online
Hi, I am Reva - Ask me anything.
Updates
No new updates
Chat
Home
Updates
/**/
Thanks for the feedback!
Your feedback has been saved.Rate this response:
1
2
3
4
5
Add Additional feedback ( Optional )
0/240
English
English
Language changed successfully
Something went wrong
Email sent successfully
Something went wrong
Case create successfully
Are you sure you want to cancel
the case creation?
Please select a product to submit the case.
Please select a product version to submit the case.
0/255
Upload Attachment
File Upload
Maximum file
size allowed is 3 MB.
File type
not supported.
Supported file types:
Documents (.txt, .doc, .docx, .pdf), Images (.jpg, .png), Comma Separated Files
(.csv) Speadsheets (.xlsx, .xls)
Are you sure you want to cancel the case creation?
Case closed successfully
File Upload
Maximum file size allowed is 3 MB.
File type not supported.
Supported file types:
Documents (.txt, .doc, .docx, .pdf), Images (.jpg, .png), Comma Separated Files
(.csv) Speadsheets (.xlsx, .xls)
Are you sure you want to close this case
| Products | Region | Phone Numbers |
|---|---|---|
| FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield |
North America * |
+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America) |
| Europe * |
+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe) |
|
| Japan * | +81 3-4540-5335 (select option 2) | |
| Australia * |
+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia) |
|
|
Usage Intelligence (formerly
Revulytics) Compliance Intelligence |
Please use the Case Portal to submit your support ticket or reach out to your Revenera contact. | |
File Upload
Maximum file
size allowed is 3 MB.
File type
not supported.
Supported file types:
Documents (.txt, .doc, .docx, .pdf), Images (.jpg, .png), Comma Separated Files
(.csv) Speadsheets (.xlsx, .xls)
© 2026 Flexera Software. All Rights Reserved.
Case id: 00001065
Activity: Status change: 2 hours ago