Skip to main content
L
Libby_H
Inspiring
April 22, 2008
Answered

CF8 Enterprise and MS SQL Server

  • April 22, 2008
  • 4 replies
  • 875 views
I need to port a CF8 Enterprise applcation off an MS Access DB to an existing MS SQL Server database/environment (I guess I am technically piggy-backing my database into an existing 'instance'). I have created my SQL Server database, loaded it from the old Access database, and am now looking to connect to it from the CF Administrator.
I am receiving the "java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection." error. I've left the id and password fields blank, thus causing this error. I've checked, and the server properties (using SQL Sever Enterprise Manager) and validiated that it is set for mixed mode authentication (both SQL Server and Windows), but can't get any further.
Any ideas?
This topic has been closed for replies.
Correct answer Libby_H
I was able to verify that SQL Server was using mixed mode authentication (both Windows and SQL Server), and that TCP/IP was enabled and using port 1433.
I had to establish a local ID within SQL Server and then used that ID/password combination in the configuration of the datasource within the CF Administrator. And then Bingo, that worked.
Thanks everyone for you suggestions and patience. Oh, and I also purchased a SQL Server 2000 book to help me get through the necessary code changes between MS Access and MS SQL Server.

4 replies

L
Libby_HAuthorCorrect answer
Inspiring
April 30, 2008
I was able to verify that SQL Server was using mixed mode authentication (both Windows and SQL Server), and that TCP/IP was enabled and using port 1433.
I had to establish a local ID within SQL Server and then used that ID/password combination in the configuration of the datasource within the CF Administrator. And then Bingo, that worked.
Thanks everyone for you suggestions and patience. Oh, and I also purchased a SQL Server 2000 book to help me get through the necessary code changes between MS Access and MS SQL Server.
M
miarte
Participant
April 24, 2008
Yeap, it always come down to SQL server.

I was able to connect using the IP address on VMWare Fusion and not with the server name.

Anyway, thanks.
~Cheer
M
miarte
Participant
April 23, 2008
I'm having the same problem. The only difference is I'm trying to connect to SQL server on a Guess Windows XP using VMWare Fusion on the Mac with Leopard.

I'm selecting the driver MS SQL Server from the drop down when creating a new DSN to connect to the DB.

I verified the authentication login for windows and SQL and still have the same results.
J
johnab
Participating Frequently
April 23, 2008
guys,
this problem always comes down to the SQL server. By default TCPIP connections are not enabled with 2005 so you need to edit the configuration of the SQL server to permit TCPIP and make sure it's listening on port 1433

here are a few links that should help,
http://www.mattwoodward.com/blog/index.cfm?event=showEntry&entryID=01930619-FD0A-4F02-31B1BFC7D1D9A44C
J
JR__Bob__Dobbs-qSBHQ2
Inspiring
April 22, 2008
Are you wanting to use SQL authentication or Windows authentication? If SQL you need to provide the username and password for a SQL login.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices