Re: it's THREE times that i post Really wanna solve this!!!!!

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

how??

how can i get to grant permissions on my database??
could you tell me in detail?

"Rob Schieber" <schiebrc@xxxxxxxxxxx> wrote in message
news:%23aPz9kPAGHA.2708@xxxxxxxxxxxxxxxxxxxxxxx
> micky wrote:
>> ===========================================================
>> Cannot open user default database. Login failed.
>> Login failed for user 'NT AUTHORITY\SYSTEM'.
>> ============================================================
>>
>> my website consist of three wesite in a solution.
>>
>> Solution(http://localhost/solution/)
>> -App_Data/db.mdf
>> -a(http://localhost/solution/a/)
>> -b(http://localhost/solution/b/)
>> -c(http://localhost/solution/c/)
>>
>> a,b,c sites are using db.mdf file in app_data folder of solution project
>> so i made connection string like below.
>>
>> <add name="ConnectionString" connectionString="Data
>> Source=.\SQLExpress;Integrated Security=True;User
>> Instance=True;AttachDBFilename=C:\Inetpub\wwwroot\Solution\App_Data\db.mdf"
>> providerName="System.Data.SqlClient" />
>>
>> the problem is ...
>> open a,b or c website and then i also open vs2005 to modify database
>> error occur to me...like Unc share...
>>
>> in opposite , it will be same result ...
>>
>> help me~~
>
>
> Since you are using Integrated Security, that means that the identity of
> the caller is assumed, in most cases this is the ASPNet account, you need
> to grant permissions on your database to this account.
>
> --
> Rob Schieber
>
>
>
>
> --
> ÿþ-


.

Relevant Pages

  • Re: its THREE times that i post Really wanna solve this!!!!!
    ... Cannot open user default database. ... so i made connection string like below. ... Since you are using Integrated Security, that means that the identity of the caller is assumed, in most cases this is the ASPNet account, you need to grant permissions on your database to this account. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Ownership Chains Not Working?
    ... I agree with Sue. ... I grant permissions only to user-defined ... > database A has all kinds of privileges that I don't want this user to have ...
    (microsoft.public.sqlserver.security)
  • Re: Deny permission to the object browser in query analizer
    ... you grant permissions to though. ... determined table in a database. ... objects thru the object browser in the query analizer. ...
    (microsoft.public.sqlserver.security)
  • Re: its THREE times that i post Really wanna solve this!!!!!
    ... This could also be because you set your account to have ... a default database other than master. ... >>> Cannot open user default database. ... >> to grant permissions on your database to this account. ...
    (microsoft.public.dotnet.framework.aspnet)
  • User permissions
    ... Is there a transact-sql or other way that I can use to ... grant permissions to all objects in a database to a ... Enterprise Manager. ...
    (microsoft.public.sqlserver.security)