2

I finished my Asp.net Mvc application and want to deploy it to server.

My problem is the connection string for database server doesn't have Visual Studio to connect with SQL and know connection string, I want to know how to get the connection string without Visual Studio - what is the easiest way to get it to replace the old one in web.config?

Improve this question
3
  • 1
    The template for a connection string is : connectionString="Data Source=ServerName;Initial Catalog=DatabaseName;Integrated Security=False;User Id=userid;Password=password;MultipleActiveResultSets=True" /. If you know the name of the server, the database, the user ID and password, you should be able to simply construct the string. Commented May 22, 2016 at 14:04
  • You can look at connection string syntax at www.connectionstrings.com. Commented May 22, 2016 at 14:32
  • ok i will see thank you Commented May 22, 2016 at 14:34

1 Answer 1

Reset to default
3

First create a file in your desktop with udl format. Then double click on it and enter your database info and press ok. open the file with notepad and you will see connection string.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.