[dba-VB] SQL Server - User not associated with a trusted connection

John,

You need to right click on the SQL server instance and change the login to
use both Windows and SQL instead of Windows only authentication.

Eric 

-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of John Colby
Sent: Sunday, October 16, 2005 8:42 PM
To: dba-sqlserver at databaseadvisors.com
Cc: dba-vb at databaseadvisors.com; 'Access Developers discussion and
problemsolving'
Subject: [dba-VB] SQL Server - User not associated with a trusted connection

What does this mean?

I am struggling to get a DotNetNuke web site running on some system at my
home office.  I have IIS set up and running, SQL Server set up and running,
SV 2003 Installed and running.  I followed the directions in the DotNetNuke
book which has me set up a SQL Server database, a DotNetNukeUser user, using
SQL Server logon (which MAY be the issue).  I created the database, the
user, the password and told the DotNetNuke web.Config all this info but when
the ASP install script runs and tries to access SQL Server I get this "not
associated with a trusted connection" error from SQL Server for this user.  

I believe that when I set up SQL Server I told it to use Windows Login.  Is
it possible to use either one independent of the other.  IOW, can I use a
specified SQL Server user / password even though I told the install to use
Windows login authentication?

If not, what do I do?  Set up a DotNetNukeUser user in Windows and then pass
in that Windows user and it's password in the connection string?

I am sooooo close I can taste it.

John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/


_______________________________________________
dba-VB mailing list
dba-VB at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-vb
http://www.databaseadvisors.com



                                                                                                                                                                      
                                                                                                                                                                                                             ----------------------------------------------------------------
The information contained in this e-mail message and any file, document, previous e-mail message and/or attachment transmitted 
herewith is confidential and may be legally privileged. It is intended solely for the private use of the addressee and must not be 
disclosed to or used by anyone other than the addressee. If you receive this transmission by error, please immediately notify the 
sender by reply e-mail and destroy the original transmission and its attachments without reading or saving it in any manner.  If you 
are not the intended recipient, or a person responsible for delivering it to the intended recipient, you are hereby notified that any 
disclosure, copying, distribution or use of any of the information contained in or attached to this transmission is STRICTLY 
PROHIBITED. E-mail transmission cannot be guaranteed to be secure or error free as information could be intercepted, corrupted, 
lost, destroyed, arrive late or incomplete, or contain viruses.
The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of 
email transmission. Users and employees of the e-mail system are expressly required not to make defamatory statements and not 
to infringe or authorize any infringement of copyright or any other legal right by email communications. Any such communication is 
contrary to company policy. The company will not accept any liability in respect of such communication.