Create SQL 2005 Data Source

5 replies
865 views
Translate

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

This topic is closed to new replies. Start a new post to keep the conversation going.

E

emmim44Author

Inspiring

Thank you all. it is done.

Translate

E

emmim44Author

Inspiring

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

Translate

J

JR__Bob__Dobbs-qSBHQ2

Inspiring

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.

Translate

N

Newsgroup_User

Inspiring

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?

Translate

D

Daverms

Inspiring

Hi,

A step by step tutorial is available here.

Translate

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.