ADO DB Connection to SQL Server (ASP.Net)

[Guest]

I'm attempting to connect to a SQL Server DB, using ADO, from my new ASP.NET
web application. I can use the same connect string from within a VB.Net app
(windows app) just fine, but I cannot do it from within my web app... Here
is the error I am receiving:

Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.

I am using windows authentication, which works just fine within my windows
app - I'm using the web server on my local machine... Here is my connect
string and code associated with this:

sDatabaseType = "SQL Server"
sServerName = "MyServer"
sDatabaseName = "MyDatabase"sConnectString = "DRIVER={SQL
Server};SERVER=" & sServerName & ";Trusted_connection=yes;DATABASE=" &
sDatabaseName & ";"
gdcDataConnection = New ADODB.Connection
gdcDataConnection.Open(sConnectString)

I would appreciate any help that you can provide!!!!!
Thank you!-Valerie

 

[Cor Ligthert]

Krdev.

This problem is almost forever that the user for a webserver application is
the ASPNET or the IIS user. And need therefore the rights on the database
that you use confirm that.

I hope this helps,

Cor

 

[Guest]

ASP .Net application is runnig under "ASPNET" account for IIS 5 and Network
Services in IIS 6. While Windows appliations are running under the current
user account.
So what you need is add access persissions on the server, database, table,
views, stored prcedures for the ASPNET or the Network Services account

I hope this helps