errors while connecting to Sql server with DSN connect

[Swagener]

The aim is to get it working on this machine so I can port everything
to a Enterprise Version but can't get around this error for the last
two days. Any help is much appreciated, as I am not getting any
further with this.

Internet Explorer Error:
HTTP 500.100 - Internal Server Error - ASP error
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'ssgroup\wagesz'.
/Survey/asp.asp, line 13

ASP Connect string:
dim strSQL
set Global_DBConnection=Server.CreateObject("ADODB.Connection")
DSN="Driver={SQL Server};Server=localhost
\SQLEXPRESS;Database=surveys;UID=domainA;PWD=xxxxxx"
Global_DBConnection.Open(DSN)

IIS 5.0 SP4 Configurations:
Directory Security = Anonymous Acces Enabled with user abc1\IWAM_abc1,
Basic Authentication not enabled, Intregrated Windows Authentication
is enabled.

SQL Server Security Configuration:
Server Security Mode= SQL Server and Windows Authentication (Mixed
Mode)
Others= Remote Connection enabled, all services running, tcp and named
pipes enabled
Domain Useer Account in MSQL = The User domainA is part of W2k Admin
Group and in Sql Server the entire BUILTIN\Administrators group is
added in Server security Node and in the db node its added as a user
with DB_owner membership.
(The user trying to connect is a domain user, which has admin rights
on the machine (test purpose))

Rick

 

[Mark Rae [MVP]]

Internet Explorer Error:
HTTP 500.100 - Internal Server Error - ASP error
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'ssgroup\wagesz'.
/Survey/asp.asp, line 13

ASP Connect string:
dim strSQL
set Global_DBConnection=Server.CreateObject("ADODB.Connection")
DSN="Driver={SQL Server};Server=localhost
\SQLEXPRESS;Database=surveys;UID=domainA;PWD=xxxxxx"
Global_DBConnection.Open(DSN)

You're in the wrong newsgroup - this one is for ASP.NET.

For ASP Classic issues, please post to:
microsoft.public.inetserver.asp.general