> I am trying to set up a datasource connection to a SQL
> Server. The test server works fine, the production fails.
>
> The DS connection is set up on the production server just as
> it is on the test server. All SQL Server settings that I can
> see are the same.
>
> I can log into the production server with the username and pw
> over a TCP/IP connect and named pipes with Enterprise manager.
>
> I have tried with and without USE TRUSTED CONNECTION.
>
> I have gone into the Win2000 ODBC tool in the control panel
> and tested the connection there. It tested out fine.
>
> Have used the SA account and another account.
>
> I tried putting the username and password in just the CF
> Datasource setup, just the templates query, and both.
>
> The server is on the same lan as the CF server.
>
> Nothing seems to get around this error:
> ODBC Error Code = 28000 (Invalid authorization specification)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed
> for user '\'.
If you're using SQL Server 2000/MDAC 2.6, there's a bug in the initial
release that doesn't allow native SQL Server logins to work, only trusted
connections:
http://support.microsoft.com/support/kb/articles/Q279/5/26.ASP?LN=EN-US&SD=g
n&FR=0&qry=MDAC%202.6&rnk=46&src=DHCS_MSPSS_gn_SRCH&SPR=SQL
You won't be able to use a trusted connection in your datasource unless the
CF Server is running as a user with the appropriate rights - by default, CF
runs as SYSTEM, which has no trusted connection rights.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
