Sagewire Logo

Does CFMX 7 support SQL SERVER 2005?

6 Message(s) by 3 Author(s) originally posted in server admin


From: ROQUE5072 Date:   Thursday, August 30, 2007
We are getting this error only when executing a stored procedure that utilizes
link server s. The error is:

[Macromedia][SQL Server JDBC Driver][SQLServer]Named Pipes Provider: Couldn't
open a connection to SQL Server [5].

Our SQL Server is set to use Windows authentication only (Kerberos -based
authentication). The error above happens when a stored procedure needs to
query a table from another server (linked server). We've loaded the latest
DataDirect JDBC driver s (3.5)
http://kb.adobe.com/selfservice/viewContent.do?externalId=42dcb10a&sliceId=2

Is there an updated driver or a service pack available (3.7 perhaps)?

Does anybody have any ideas?

Thank you in advanced.


From: JohnEric Date:   Thursday, August 30, 2007
Short answer yes.

We are using the Microsoft JDBC v1.1 driver but, the updated DataDirect driver should
work as well.

Since the only error you say you are getting is with execution of a stored
procedure on a linked server, does that mean that you can execute a simple
select statement against the linked server?

Something like SELECT * FROM [linkedServer].[db].[schema].[table] ?

It may just be that you are running into the double hop problem with Kerebos
authentication if the connection to the linked server is through the current
login context.


From: ROQUE5072 Date:   Friday, August 31, 2007
Thanks for helping. I appreciate the reply.

Yes, we also have problems with simple select statement against the linked
server.

We are definitely having a Kerberos authentication related problem. It only
happens when using the SQL Server driver supplied with MX 7 and ColdFusion 8. If we
configure a datasource using the ODBC Socket driver, the problem goes away.
However, we'd like to keep using the SQL Server driver (JDBC).

Is Adobe providing an updated driver to support SQL Server 2005 / Kerberos
Authentication? Is this download available anywhere?

Thanks again for your help.


From: Wilgeno Date:   Thursday, September 06, 2007
Make sure your SQL server has TCP/IP enable in the SQL Server Manager. This has been talked about on other sites like carehart.org.

Cheers,


From: JohnEric Date:   Thursday, October 04, 2007
http://kb.adobe.com/selfservice/viewContent.do?externalId=42dcb10a

they released the 3.5 datadirect drivers a while ago, I think at the same time as the cumulative hotfix #2.


From: ROQUE5072 Date:   Friday, October 05, 2007
First, many thanks to everyone who replied.

I posting this message in case anyone else runs into integrated security,
trusted connection or windows authentication / Kerberos double-hop problems
between SQL Server 2005 and Cold Fusion using the CFMX 7 supplied DataDirect
JDBC drivers.

We found a solution that worked. Basically, we downloaded the Microsoft SQL Server
2005 JDBC drivers as described in this technote:

http://kb.adobe.com/selfservice/viewContent.do?externalId=ded4216b

However, make sure to download the latest version of the driver, which is 1.1
(http://www.microsoft.com/downloads/details.aspx?FamilyId=6D483869-816A-44CB-978
7-A866235EFC7C&displaylang=en)

The technote left out some very important information that made it work for
us. Basically, the JDBC URL must contain the 'integratedSecurity=true'
parameter and that the sqljdbc.jar and sqljdbc_auth.dll must be copied to a
folder that is part of your windows system path (ie. c:\windows\system32).

Here's the complete JDBC URL syntax:


jdbc:sqlserver://[server]:1433;databaseName=[database];integratedSecurity=true;S
electMethod=direct;sendStringParametersAsUnicode=false; MaxPooledStatements=0;

Thanks again and good luck to all..



Next Message: Will ColdFusion 8 work w/ Apache 1.3.36 or 1.3.37 (Unix/Linux)?


Blogs related to Does CFMX 7 support SQL SERVER 2005?

Magazine publishing independent motor news and reviews.
sql server dataabase samples mushroom basil pasta wedding guest 4x. pro.msi cofidence visa sand wedge caviller approach definition maelstrom creekside stables mrs. brenda gerstner lula and 200707040000:200707050000. ...

TIFF Image Viewer CP, EXIF FAX ActiveX 6.0 BMP,...
Net-ready ActiveX component for which gives your end-users the ability to create SQL queries via an intuitive visual interface. Supports Oracle, Microsoft SQL Server, MySQL, PostgreSQL and many other SQL dialects. ...

Domain Name Yahoo & Register Domain Name
ListSpawner™ can be used with any web hosting account/service that provides SQL database support, and PHP 4.3 (or above) with PHP mail. If you don't have a suitable web hosting provider. Click for Details ...

Apple and Google fall, Yahoo climbs in consumer ratings ...
Citrix. Cognos. Coldfusion. CRM. Crystal Reports. Software Development. ERP. HTML. IBM. IT Infrastructure. ITIL. J2EE. Java. LAN/WAN. Linux. Lotus Notes. MS Project .NET. Oracle. SDLC. SQL. IT Support. IT Training ...

oDesk Job Openings Summary (rss) - 63 new articles
NET and SQL Server 2005 Budget: $1800.00 Starting On: August 26, 2007 Ending On: Posted On: August 20, 2007 ID: 285272 Country: United States Hours Billed: 0. click to apply � Email to a friend - http://www.feedblitz.com/f/f.fbz? ...

useful bookmarks / websites
If I return out of a try/finally in C#, does the code in the finally-clause run? 15 Seconds : Creating a Data Access Layer in .NET - Part 1; wayne plourde :: software architect :: articles; Implementing Triggers in SQL Server 2000 ...


Programming | Sports | Autos

copyright 2006
Valid XHTML 1.0 Transitional