Re: Windows 2003 and ASP
- From: jeff.nospam@xxxxxxxx (Jeff Cochran)
- Date: Wed, 15 Jun 2005 11:22:13 GMT
On 14 Jun 2005 00:15:44 -0700, CosmicLeap@xxxxxxxxx wrote:
>Hi,
>I am unable to connect to a database in my SQL 2000 Server installed on
>
>a Windows 2003 Server machine from an asp page on another machine(the
>web server). It gives the the
>following error:
>
>
>Microsoft OLE DB Provider for SQL Server (0x80004005)
>Login failed for user 'sa'. Reason: Not associated with a trusted SQL
>Server connection.
>
>
>I also sometimes get:
>MSDataShape (0x80004005)
>Data provider could not be initialized.
>
>The authentication mode is mixed. That means it is supposed to accept
>SQL authentication.
>
>I can connect with the same connection string and parameters from a
>visual basic 6 application.
>
>
>I can also connect the web client with the same DB in SQL 2000 running
>on Windows 2000/XP.
>
>If I put the web server on that same machine I can also connect.
>
>I believe it is something to do with security. Please advise me on what
>
>to do. It is very urgent.
Take a look at:
Why do I get database-related 80004005 errors?
http://www.aspfaq.com/show.asp?id=2009
HOWTO: IIS and SQL Server on Separate Machines with Trusted
Connection:
http://support.microsoft.com/default.aspx?scid=kb;en-us;q176379
Jeff
.
- References:
- Windows 2003 and ASP
- From: CosmicLeap
- Windows 2003 and ASP
- Prev by Date: Re: How to dereferencing ADODB on server?
- Next by Date: Re: How to dereferencing ADODB on server?
- Previous by thread: Re: Windows 2003 and ASP
- Next by thread: Error Creating ADODB.Connection Connection in IIS6
- Index(es):
Relevant Pages
|
