MS SQL problems

[MogUK]

Hi

Due to a merger with another company, our database is about to get over 100
times the hits and is not capable of handling the traffic.

We have upgraded to Windows 2003 Standard, SQL Server 2000 (SP4) and
Coldfusion MX 7. I havecreated a new SQL database to use and am trying to
create the coldfusion datasource. I have tried from both the server itself, and
a laptop used for devleopment.

Both machine can connect to the database as a normal windows datasource (using
admin tools), but when i try to create the datasoruce in CFMX7 I get

Connection verification failed for data source: sql_silverstardating
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

I have tried all variations of IP address, hostname, and user name, and am
getting the same thing.. please cananyone assist as this is getting a tad
frustrating.

Many thnks

Morgan

[Dan Bracuk]

I'm not sure, but I think you might have to set up Cold Fusion as a user on the
database.

Originally posted by: MogUK
Hi

Due to a merger with another company, our database is about to get over 100
times the hits and is not capable of handling the traffic.

We have upgraded to Windows 2003 Standard, SQL Server 2000 (SP4) and
Coldfusion MX 7. I havecreated a new SQL database to use and am trying to
create the coldfusion datasource. I have tried from both the server itself, and
a laptop used for devleopment.

Both machine can connect to the database as a normal windows datasource (using
admin tools), but when i try to create the datasoruce in CFMX7 I get

Connection verification failed for data source: sql_silverstardating
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

I have tried all variations of IP address, hostname, and user name, and am
getting the same thing.. please cananyone assist as this is getting a tad
frustrating.

Many thnks

Morgan

[BKBK]

I have tried all variations of IP address, hostname, and user name, and am
getting the same thing

Could we have a look at the settings you applied in the Coldfusion
Administrator?
For example, my Microsoft SQL Server 2000 SP4 settings are

CF Data Source Name : test_DSN
Database: test_DB
Server : 127.0.0.1
Port : 1433
Username : sa
Password : d8kj_M$2q