key vault connect string

Question

Hello,
My connection to on-prem sql server is as follows:
server name: server1\instance1
Authentication: sql server Authentication
Login: user1
Password: pass1

Question:
What is the connectionstring to be placed inside the keyvault?
I tried the following but it can not connect
Server=server1\instance1;Database=dbName;User Id=user1;Password=pass1;

Thank you

Answer 1

Hello @arkiboys ,

Thanks for the question and using MS Q&A platform.

Step1: Before you create the Azure Key Vault secret, you need to test the connection with the details provided (Server Name, Database Name, User Name and Password).

Step2: In Azure Key Vault, create a secret:

• Name: OnPremiseSQL
• Value: server=<computer_name>\<instance_name>;database=<database_name>;user=<User_name>;password=<Password>

Sample On-premise SQL Server Connection String: server=CHPRADEEP;database=master;user=azure;password=password@12345

Step3 Let create the on-premise linked service using the secret created in the Azure Key Vault.

Hope this will help. Please let us know if any further queries.

---

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators