What is the correct connection string? in ASP.NET

Advertise with us

Control Panel Forum Hosting Help ASP.NET 4.5 & SQL 2012 Hosting Resources Notice

Home » Questions & Answers » What is the correct connection string?

What is the correct connection string?

08 Jun, 12

Author: Andrej Atanasovski
FEIT (en.feit.ukim.edu.mk without www) - Skopje

I know that my database name will be UserId_DatabaseName, where UserId is the username I'm using for the hosting here, while DatabaseName is the name of the database. I also know that I can set the connection string in web.config, but what is the correct string? My database is in the database folder. I used this example which you give in one of your pages in the Control Panel as hint:

Data Source=.\SQLExpress;Persist Security Info=True;Integrated Security=SSPI;Initial Catalog=UserId_DatabaseName;

I set the username and the database name, but I still didn't manage to connect to the database. Solution?

P.S. This is the error I'm getting:

Cannot open database UserId_DatabaseName requested by the login. The login failed. Login failed for user 'DOTNETSPIDER1\UserId'

UserId and DatabaseName are my username and the database real name, of course.

Answers .............

Author: Aaron Li

Freelance

Posted Date: 08 Jun, 12

Go through here : http://aspspider.com/tips/Tip16.aspx,
hope it help.

Author: Andrej Atanasovski

FEIT (en.feit.ukim.edu.mk without www) - Skopje

Posted Date: 11 Jun, 12

Thanks for the answer, however I managed to solve the problem on my own. Works great now.

Author: Sagar Kadam

Posted Date: 13 Jun, 12

Hello Andrej, I have the same problem. Can you tell how do you resolve it?

You must login to post answer for this question.

Total members: 250700
Average new registrations per day (in last 7 days): 7

New Registration: Open

Register Now

Talk to Webmaster
Tony John

Facebook
Google+
Twitter