Can not connect to SQL Servre via Coldfusion 8 DSN

By default CF connects to SQL server using SQL authentication.

Your options:
Change your DSN to a use a SQL login username and password.



To use integrated (windows) authentication set your ColdFusion Application Server windows service to the windows account you wish to access SQL server.
You have two options:

1. Use Microsoft's JDBC driver
http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?forumid=1&catid=6&threadid=1206110&highlight_key=y&keyword1=integrated

http://www.microsoft.com/downloads/details.aspx?FamilyID=C47053EB-3B64-4794-950D-81E1EC91C1BA&displaylang=en

2. Use the drivers bundled with ColdFusion create an "Other" datasource as in this article.
http://www.adobe.com/go/42dcb10a
Note the article refers to ColdFusion versions 6 and 7 so it may not apply to version 8.

http://www.gfisk.com/coldfusion-8-data-source-with-ms-sql-express-2005

http://kb.adobe.com/selfservice/viewContent.do?externalId=kb400255&sliceId=1

--
Ken Ford
Adobe Community Expert - Dreamweaver/ColdFusion
Fordwebs, LLC
http://www.fordwebs.com


"mpire88" <webforumsuser@macromedia.com> wrote in message news:g71sph$qg8$1@forums.macromedia.com...
>I have installed Coldfusion 8 on a windows xp professional laptop as well as
> SQL Server 2000. I have created the DSN and restored the neccessary databases.
> When I go to the Coldfusion Administrator to connect to the database via DSN I
> get the following error mesage. I am attempting to connect through my windows
> account.
>
> Connection verification failed for data source: OTT
> java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]A username was not
> specified and the driver could not establish a connection using NTLM (type 2)
> integrated security: InitializeSecurityContext, 0x80090304
> The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC
> Driver]A username was not specified and the driver could not establish a
> connection using NTLM (type 2) integrated security: InitializeSecurityContext,
> 0x80090304
>
> Can anyone please help with this
>