The SQL server is set up with mixed authentication, and Dreamweaver can
access the DB just fine when I enter the connection string. It is the
ASP scripts which pull this error.
The connection string used is:
------------------------------------------------------------------------
--
"Driver={SQL Server};Server=TEST_SERVER;Database=STAFF;Uid=sa;Pwd="
------------------------------------------------------------------------
--
Max.
-----Original Message-----
From: [email protected]
[mailto:[EMAIL PROTECTED] On Behalf Of David Horowitz
Sent: Wednesday, September 14, 2005 4:47 AM
To: [email protected]
Subject: RE: [ASP] SQL Server Connection Problem
Folks,
The error says sa is not associated with a trusted connection --
wouldn't that indicate Windows Authentication is being used (or trying
to be used) instead of SQL Server Authentication?
Maxwell, what is you connection string exactly?
David
<html><body><p class="MsoNormal"><font face="Arial" style="font-size:
8pt">____________________________________________________________<br>CRBAfrica
- providing professional debt management and credit reference <br>bureau
services in Kenya, Uganda, Botswana, Tanzania, Ghana, Zambia, <br>Mauritius and
Egypt.<br>____________________________________________________________<br>AccessKenya
- Your Corporate ISP - CRB's solution provider for fast <br>efficient Email
and Internet
Services<br>____________________________________________________________<br><br><br>ATTENTION<br>____________________________________________________________<br>The
information in this electronic mail message is private and confidential
<br>and only for the addressee. Should you receive this message by mistake,
<br>you are hereby notified that any disclosure, reproduction, distribution or
<br>use of this message is strictly prohibited. Please inform the sender by
reply <br>transmission and delete the message without copying or opening it.
Any <br>unauthorised use or interception of this e.mail is illegal. If this
e.mail is not <br>intended for you, you may not copy, distribute or disclose
the contents to <br>anyone. Save for the bona fide company matters, the CRB
Group of <br>companies does not accept responsibility for the opinions
expressed in <br>this
e.mail.<br>____________________________________________________________</font></p></body></html>
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/17folB/TM
--------------------------------------------------------------------~->
---------------------------------------------------------------------
Home : http://groups.yahoo.com/group/active-server-pages
---------------------------------------------------------------------
Post : [email protected]
Subscribe : [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
---------------------------------------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/active-server-pages/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
