Skip to main content
A
Anonymous
August 2, 2006
Question

MS SQL newbe : error creating datasource

  • August 2, 2006
  • 2 replies
  • 490 views
I have just created an empty database with SQL Server Management Studio Express.
No tables established yet. CF program should create them at initialization.

Now I am trying to create the datasource in cfide/admin and I get this error:

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

Please advise.
Thank You
ContiW
This topic has been closed for replies.

2 replies

A
Anonymous
August 2, 2006
this is a weird one that seems everyone goes thru and then forgets...

i am running msSQL2000 but should be similar

if i can remember,
you need a server number... can't remember if it is assigned or default...

mine is D2XXXXXX (not sure if a security issue so x'ed no's. try mousing over server icon in tray or opening db service manager

username: sa

password: is password created for sql server

datasource name and database same.

hope the is it.
T
The_ScareCrow
Inspiring
August 2, 2006
Do a search of these forums for sql server dsn and you will find heaps of threads.
But basically
You need to ensure the user has permission to the server
You need to ensure the port being used is open
If using windows xp there are other issues.

Ken
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices