Cannot open database "mydatabse" requested by the login..

i was using .net's internal server as a my web server(local)

now i have changes it to IIS(local)

but now i amgetting an error like

Cannot open database "mydatabse" requested by the login. The login failed.
Login failed for user 'SV2\ASPNET'

'SV is my achine name ASPNET is a login in the directory in seccurity/logins in sql server management studio

what can i do?

Hi,

Are you sure you have given the machinename\aspnet account the required permissions

http://forums.asp.net/p/905865/1001573.aspx

At times, adding <identity impersonate="true"/> to the web.config helps you to impersonate the user acccessing the application

Also check your connection string.

HTH,
Suprotim Agarwal

--
http://www.dotnetcurry.com
--

|||

Is your database on a different machine than your web server? If so, you need to give the account that the web application is running under access to the database.

|||

Hi,

Your connection string is set to use windows authentication or logged in user credentials, either change it to use SQL username password.