How to create a public connection string

 Hi Hold,

 

Please find below link. You can follow steps which given in below link

https://www.mssqltips.com/sqlservertip/2340/resolving-could-not-open-a-connection-to-sql-server-errors/ 

I got the error below when I try to create a .udl file.

 

 

Hi Hold,

 

Please Create a file with extension .udl anywhere on the web server, double click the file, it will open a dialog that will allow you to test the connection to the sql server. you select your servername and you database name and test connection once successfult you can go in file and check your connection string details.

 

This is how you can write a connection string in your web.config. You can use this easily throughout your application.

If you are able to connect to your database using the UDL test suggested by Sourav then try increasing the session timeout time by following command.

 

db.Database.CommandTimeout = int.MaxValue; 

 

So command Timeout can be any integer value here. Sometimes our query execution takes a lot time so because of that also you get timeout exception. But before all of this try check whether you are able to connect to you database from web using UDL test.

 

Steps to perform udl test are available on below microsoft link.

https://blogs.msdn.microsoft.com/farukcelik/2007/12/31/basics-first-udl-test/