VWD - Error logiing in to db

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SAC - 15 Feb 2008 16:16 GMT

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.

Reply to this Message

tian - 15 Feb 2008 17:37 GMT

Two methord
1-
add ＇ＮＴ　ＡＵＴＨＯＲＩＴＹ＼ＮＥＴＷＯＲＫ　ＳＥＲＶＥＲ＇in your
system:

　　progress：
computer－＞manage－＞local user and group－＞group－＞double click Ａdministrator－＞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=databasename"

> 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
[quoted text clipped - 15 lines]
>
> Thanks.

Reply to this Message

SAC - 15 Feb 2008 17:58 GMT

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.

> Two methord
> 1-
[quoted text clipped - 28 lines]
>>
>> Thanks.

Reply to this Message

VWD - Error logiing in to db

Free Magazines