Create SQL 2005 Data Source

[emmim44]

Hi all,
I am trying to create a db source using sql 2005 on my local machine. How will I do that?

[Daverms]

Hi,

A step by step tutorial is available here.

[Newsgroup_User]

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


"emmim44" <webforumsuser@macromedia.com> wrote in message news:g6vtlo$mld$1@forums.macromedia.com...
> Hi all,
> I am trying to create a db source using sql 2005 on my local machine. How will I do that?

[emmim44]

I have enabled the TCP on SQL 05 but still dont work... The port I am using is 1433... since it is windows aut... the username and pass is blank. What else wrong ??
The error :
Connection verification failed for data source: SC
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Could not establish a connection using integrated security: No LoginModules configured for JDBC_DRIVER_01
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Could not establish a connection using integrated security: No LoginModules configured for JDBC_DRIVER_01

[JR__Bob__Dobbs-qSBHQ2]

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&high...

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

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.

[emmim44]

Thank you all. it is done.