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" <xi*****@yeah.netwrote in message
news:F8**********************************@microsof t.com...
Two methord
1-
add £§£Î£Ô¡¡£Á£Õ£Ô£È£Ï£Ò£É£Ô£Ù£Ü£Î£Å£Ô£×£Ï£Ò£Ë¡¡£Ó£Å£Ò £Ö£Å£Ò£§in your
system:
¡¡¡¡progress£º
computer£*£¾manage£*£¾local user and group£*£¾group£*£¾double click £Ádministrator£*£¾add£*£¾advanced£*£¾search£*£¾sel ect "£Î£Ô¡¡£Á£Õ£Ô£È£Ï£Ò£É£Ô£Ù£Ü£Î£Å£Ô£×£Ï£Ò£Ë¡¡£Ó£Å£Ò£ ֣ţÒ" 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"
"SAC" <so**@microsoft.comдÈëÏûÏ¢
news:uQ****************@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.