Welcome to the Inedo Forums! Check out the Forums Guide for help getting started.
If you are experiencing any issues with the forum software, please visit the Contact Form on our website and let us know!
Using windows authentication to connect to SQL Server
-
Hi,
Currently we have given BM ServiceAaccount access to SQL Servers and using Integrated authentication to connect to SQL Servers.
We would like to use the deployment user's windows account to be used to connect to SQL Servers instead of giving BM ServiceAccount access to SQL Servers.
Could you please give us the instructions on how this can be accomplished?
Thanks,
RamProduct: BuildMaster
Version: 4.9.2 -
Are you referring to connecting to the BuildMaster database, or connecting to databases you have configured in the Database Connections section within BuildMaster?
The former cannot be done as it must use the account that hosts the web application or service. The latter cannot be done through the web application with Integrated authentication because BuildMaster does not impersonate users like that - you must use SQL Authentication and specify the credentials in the connection string if you want to go that route.
The other alternative is to create a Change Script Deployment tool, and have the respective users run the tool as their own accounts, though of course this requires manual intervention.
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login