how to run database page by IIS

[hotthoughtguy]

when i m accessing database from my Default.aspx page exception raises i:e Cannot open database "MyDatabase" requested by the login. The login failed. Login failed for user '[Computer Name/ASPNET]'. any idea how to solve this?

[kevinnicol]

Couple of options: -Add the asp.net user account as a login to the Database Server (not very secure, probalby a bad option) -Connect to the database using a connection string that uses a login account already configured on the database server.

[hotthoughtguy]

and how to configure user to databse server? i am using SQL Express 2005 my connection string is string connString = @"server = .\sqlexpress; integrated security = true; database = MyDatabase";

[kevinnicol]

Change your connection string to something like that, must make sure the user id is a user configured on the server and specify its password. Data Source=.\sqlexpress;integrated security = true;database =MyDatabase;User Id=myUsername;Password=myPassword;

[hotthoughtguy]

how to configure user to database i am using SQL Express 2005

[hotthoughtguy]

i am connecting though SQL Client

[hotthoughtguy]

same exception

[Not Active]

It is bad manners to post the same question to multiple forums

---

I know the language. I've read a book. - _Madmatt

[Mycroft Holmes]

Using a forum as your primary learning tool is not a good idea. Read the manual (Book On Line), learn to use Google to do some research[^]

Never underestimate the power of human stupidity RAH

[hotthoughtguy]

alright...