John Colby
jwcolby at ColbyConsulting.com
Sun Oct 16 22:55:06 CDT 2005
Never mind, I got it. Wooohooo, I have DNN running on one of my machines now, with VS 2003 as well. Not my Laptop Dev machine but at least I can go to work now. <huge grin> John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Colby Sent: Sunday, October 16, 2005 11:42 PM To: dba-sqlserver at databaseadvisors.com Cc: dba-vb at databaseadvisors.com; 'Access Developers discussion and problemsolving' Subject: [AccessD] 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/ -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com