errors while connecting to Sql server with DSN connect

S

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
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,744
Messages
2,569,479
Members
44,899
Latest member
RodneyMcAu

Latest Threads

Top