CODEWITHSUNDEEP
c#asp.netsql-server
WIRN
WIRN

Reputation: 947

connecting to sql server, problems

I just build my first web-application in asp.net that connects to a local database. I got a weird problem.

The connection to the database works if i open the website BEFORE sql server after reboot. I can insert/read from the db from my webpage. But then sql server cant connect to the db. It looks like this then:

enter image description here

If i start sql server before the website then sql server works but the webpage doesnt work, visual studio then gives me this error:

enter image description here

Why are they interfering with each other and what can i do about it? I use visual studio 2010 and sql server 2008 R2.

Upvotes: 2

Views: 117

Answers (1)

Md. Arafat Al Mahmud
Md. Arafat Al Mahmud

Reputation: 3214

did you try to open your connection through server explorer from visual studio 2010 ? everytime you want to display the page in an web browser..just make sure you open the database connection through server explorer, it will work...no matter what was the order of your starting sql server.

Upvotes: 1

Related Questions