I'm brand new to dotnet...when I press F5 on a webpage with a gridview
connected to the pubs db, I get an error
[SqlException (0x80131904): Cannot open database "pubs" requested by the
login. The login failed.
Login failed for user 'NOTEBOOK\ASPNET'.]
I'm logged into this computer as <DomainName>\Administrator
I checked the db users and there is none called ASPNET.
I tried adding it with ownership on the DB and still no prpgress.
I tried logging into the local computer (NOTEBOOK) rather than the domain.
but no success.
Any ideas on what I need to do?
Thanks.Two methord
1-
add Σ??????????Σ????
???????in your
system:
progress
computer_manage_local user and group_group_double click dminis
trator_add_advanced_search_s
elect "Σ??????????Σ
???????????" in the
list_OK
2-
Add a user to your database.
edit your connstring in the web.config.
like this:
connString="server=192.168.0. 15;uid=****;pwd=****;database=databasena
me"
"SAC" <some@.microsoft.com> д?
news:uQjzt4%23bIHA.2688@.TK2MSFTNGP06.phx.gbl...
> I'm brand new to dotnet...when I press F5 on a webpage with a gridview
> connected to the pubs db, I get an error
> [SqlException (0x80131904): Cannot open database "pubs" requested by the
> login. The login failed.
> Login failed for user 'NOTEBOOK\ASPNET'.]
> I'm logged into this computer as <DomainName>\Administrator
> I checked the db users and there is none called ASPNET.
> I tried adding it with ownership on the DB and still no prpgress.
> I tried logging into the local computer (NOTEBOOK) rather than the domain.
> but no success.
> Any ideas on what I need to do?
> Thanks.
>
Thanks so much for your reply.
I've added the user to the db, but I'm not sure how to edit the connection
string.
Here's what I have now:
<connectionStrings>
<add name="pubsConnectionString1" connectionString="Data
Source=NOTEBOOK\sqlexpress;Initial Catalog=pubs;Integrated Security=True"
providerName="System.Data.SqlClient" />
<add name="NorthwindConnectionString1" connectionString="Data
Source=NOTEBOOK\sqlexpress;Initial Catalog=Northwind;Integrated
Security=True"
providerName="System.Data.SqlClient" />
<add name="CHConnectionString" connectionString="Data
Source=notebook\sqlexpress;Initial Catalog=CH;Integrated Security=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
Please help me by showing how this should be edited.
Thanks.
"tian" <xingyao@.yeah.net> wrote in message
news:F871450A-9B03-4A2C-AFFC-5704621E9FD3@.microsoft.com...
> Two methord
> 1-
> add Σ??????????Σ????
???????in your
> system:
> progress
> computer_manage_local user and group_group_double click dmin
istrator_add_advanced_search_
select "Σ??????????
Σ???????????" in the
> list_OK
> 2-
> Add a user to your database.
> edit your connstring in the web.config.
> like this:
> connString="server=192.168.0. 15;uid=****;pwd=****;database=databasena
me"
> "SAC" <some@.microsoft.com> д?
> news:uQjzt4%23bIHA.2688@.TK2MSFTNGP06.phx.gbl...
>
Wednesday, March 28, 2012
VWD - Error logiing in to db
Labels:
0x80131904,
asp,
brand,
dotnet,
error,
errorsqlexception,
gridviewconnected,
logiing,
net,
press,
pubs,
vwd,
webpage
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment