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

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

This could also be because you set your account to have
a default database other than master. Then, took your
default database offline.

As a bit of a goofball sometimes, I did this once.

--
Robbe Morris - 2004/2005 Microsoft MVP C#
http://www.eggheadcafe.com/forums/merit.asp





"micky" <somequestion@xxxxxxxxx> wrote in message
news:ecqdQWQAGHA.3976@xxxxxxxxxxxxxxxxxxxxxxx
> 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: Is the login control with sql server express a known bug
    ... I added ASPNET into the admin group but it didn't solved my problem. ... TEST NUMBER 1 using the Northwind database running from VisualStudio ... Cannot open user default database. ... IIS and which account is running the ASP.NET. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Please! Doesnt anyone know a better way to do this?
    ... account, they need to automatically be directed to the page to enter data ... session variable on the Account page. ... I assume here that you're checking a database when the user attempts to ... When a new user attempts to login or clicks to register, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Best way to parse file into db-type layout?
    ... That's an awful lot of columns to put into a database table, ... The rows are identified by Letter type and an account number (always the ... Off to search for dictionaries and databases now. ... > What you need is a clear appreciation of what you are trying to do ...
    (comp.lang.python)
  • Re: Help with WSS 3.0 Server Farm Config - Backend SQL 2005
    ... I had to use only "sharepoint" to get the ... What interest me though is that the database get created but fails after ... Virtual Server with DBSVR ... an account local to the WEBSVR) to create and access the SQL server, ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Relationships, forms and command buttons
    ... asking how to do a particular thing in terms of the database objects itself. ... If they change their bank account, ... tblIndividuals and tblCAFGAYEDons) with linking tables with an autonumber PK ...
    (microsoft.public.access.gettingstarted)