how to run database page in 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?

[T M Gray]

Don't use integrated security and specify a username and password in your connection string.

[hotthoughtguy]

string connString = @"server = .\sqlexpress; integrated security = true; database = MyDatabase"; hv i to use this string connString = @"server = .\sqlexpress; username = "xyz" ; password = "xyz" ; database = MyDatabase";

[T M Gray]

hotthoughtguy wrote:

string connString = @"server = .\sqlexpress; username = "xyz" ; password = "xyz" ; database = MyDatabase";

Something like that. I think it is user id instead of username, and of course no quotes around the values. For a good reference see http://www.connectionstrings.com/[^]

[Not Active]

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

---

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

[hotthoughtguy]

altight.. sorry

[hotthoughtguy]

well thanks for that link