Connecting ColdFusion to SQL Server 2000 (MSDE)

[David Brim]

June,

Would you mind sharing the port number?

David

[zerium]

David, since i was trying to figure this out and it led me to this post here is
your answer: Go to: C:\Program Files\Microsoft SQL Server\80\Tools\Binn (or
wherever your root install is to MSDE) double click SVRNETCN.exe in the left
column click on TCP/IP and then Enable click apply. then restart the
MSSQLSERVER service (or you can just reboot) then go into Coldfusion and use
the defaults for setting up a connection to SQL Server. The port number was
right however SQL Server wasn't listening on that port via TCP/IP. Use
LOCALHOST for your Server. Hope this helps. Oh yes and don't use what I found
on the net a ODBC tunnel... you have to specify the user account there so if
you ever move to a production environment you will have to change your querys.
-Steven

[Gary1]

I had same problem. Just upgraded my development PC from CF5 to CF7. Using
Win2000 Server and SQL Server 2000/IIS. Couldn't get the connection to SQL
Server in CF Administrator to work. I too tried (local) and a dozen other
server and port settings. This is such a popular configuration, I think it's
terrible that Macromedia provided such poor documentation on how to connect to
SQL Server. Even if you search the KB on the Macro. web site, there is NOTHING
on how to correctly configure SQL Server, as it compares to how you had it with
CF 5. Anyway, turns out, all I needed to do was change the server name in CF
Admin to either 127.0.0.1 or localhost (either works) and the default port of
1433 seemed to work.

But what was even worse, when I started SQL Server 2K Enterprise Manager, none
of my databases showed up. When I tried to "attach" my primary database, it
said it couldn't....that some other process had control of the files. So, I
couldn't even access any databases, not even the SYSTEM or MSDB, all were gone.
But after establishing a successful connection in CF Admin to the SQL Server
(using localhost), I went back to Enterprise Manager, and all my databases
showed up. Now why would that happen?

Somehow, after establishing a successful connection in CF Admin (thanks to
this forum and your help...NOT MACROMEDIA'S LOUSY DOCUMENTATION OR SUPPORT
SECTION), I can now see all my databases in SQL Server. Anyone else experience
this? I hope it's not a frequent occurance, and was only caused because CF
Administrator couldn't establish a successful connection.

I spent hours yesterday, trying to figure out what was wrong with my upgrade.
I am trying to convince my company to upgrade from CF5 to CF7 and I have to do
a demo of CF7 this week to some VPs. I was just about ready to say "forget
it."

When I searched these forums for "SQL Server" I discovered I wasn't the only
person having problems with this same issue. There were many posts regarding
this. The upgrade process should have taken care of it, but it didn't. I
thought I may have old MDAC drivers, or JDBC drivers, or an old JDK. The KB
implied you had to have all these updated drivers.

Anyway, I still need to test my connection to another datasource, an IBM DB2
external server. I had it all configured and working fine in CF5. Haven't had
a chance to test it yet, but have a feeling it's not going to work in CF7
because it's asking for totally different information in the CF Admin than CF5
did. So I may be back on these forums. Anyway, THANKS to all to suffered
gladly, as I did, trying to upgrade this product in spite of it's poor
documentation for such a popular configuration. Before I read these messages
in this forum, I couldn't establish a connection to my SQL Server, thus
couldn't run any of my CF Apps, and couldn't open ANY databases in Enterprise
Manager. I was about to panic. So thanks again, you folks made my day a
little (a lot actually) easier.

Gary

[RenWeb Bob]

I also had the same problem. I agree with the frustration as to why the
upgrade from CF 5 to MX does not automatically correct datasource connections.
In my case I still could not connet when I renamed the database on my MSDE from
(localhost) to 127.0.0.1 as suggeted in the documentation. Any Ideas?

For reference here is the exact error message.

Connection verification failed for data source: CDS-MO
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing
socket. Connection refused: connect
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC
Driver]Error establishing socket. Connection refused: connect