Login failed

[mxo]

hi all please any one who can help me Iam getting this error when i try to log on my site

Thanking you in advanced

Cannot open database "ASPNETDB" requested by the login. The login failed.
Login failed for user 'NETWORK-SYHFY\IWPD_27(databasename)'.

 

[adamroof]

either login to your database via your web.config using SQL authentication in your connection string,

    <appSettings>
        <add key="appTitle" value="My Intranet"/>
        <add key="conString" value="server=(local);database=ASPNETDB;uid=DBUser;Password=StRonGPassWordHere!" />
    </appSettings>

or grant your Domain\Domain Users a limited role within your database via the SQL server
then all you need is

<add key="conString" value="server=(local);database=ASPNETDB;trusted_connection=True;"/>
...
<system.web>
 <authentication mode="Windows"/>
 <identity impersonate="true"/>
 <authorization>
   <allow roles="Domain\Domain Users"/>
   <deny users="*"/>
 </authorization>
</system.web>

I would go with the domain users option if this is on your Intranet