I am using the local dbo account of "sa" no password. It will not authenicate in CF MX Admin. The drivers are those in CF MX.
-----Original Message----- From: Brook [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 8:54 PM To: CF-Talk Subject: Re: CFMX / MSSQL What type of drivers are you using? The ODBC Socket Connection should work. If you want to use the Sql Server Driver, you need to have mixed mode authentication on your SQL Server. You need to setup a sql server login, with a username an password. Then use this username and password to connect to the datasource via CFMX. In earlier version you could use window authentication with the sql server driver, but not in MX. And you should try to avoid the ODBC Socket Connection. I have both those services stopped.. Brook At 08:24 PM 30/09/02 -0400, you wrote: >I have CF MX installed and SQL 7. > >I created the database along with in the >Control Panel, I created the ODBC connection >to the DB with a DSN name of: myDB > >Now in CF it will not connect. >I have SQL 7 set to TCP/IP in the Client Network >Utility. > >I have no PWD associated since this is used >as my DEV box. > >Any ideas? > > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists