Cannot Connect to SQL 2000
22 Message(s) by 4 Author(s) originally posted in cfml database access
| From: Lynda |
Date: Thursday, October 25, 2007
|
I recently reinstalled
SQL Server and now I am unable to create the
DSN through
ColdFusion Admin. The name of the SQL
instance was changed during the reinstall. I
have attempted to use the new name in CFADMIN but get the following
error :
"JAVA.sql.SQLException: [Macromedia][SQLServer
JDBC
Driver][Macromedia][SQLServer JDBC Driver]The requested instance is either
invalid or not running.
The
root cause was that: JAVA.sql.SQLException: [Macromedia][SQLServer JDBC
Driver][Macromedia][SQLServer JDBC Driver]The requested instance is either
invalid or not running."
The instance is running and I can create a
connect ion through the Data Source
(
ODBC )
tool in Admin Tools but I can set it up in CFAdmin.
Thanks in advance for your advise!
| From: JR Bob Dobbs |
Date: Thursday, October 25, 2007
|
Things to check:
1. Mixed mode
authentication in enabled on your SQL
server
2.
TCP/IP protocol is enable on your SQL server
3. The
port SQL listens on and the port configured in CFADMIN are the same
4. The port isn't blocked by a
firewall
| From: Lynda |
Date: Thursday, October 25, 2007
|
Thanks for the reply. I have checked all the things you mentioned. They are all
correct. The error looks to me like ColdFusion thinks the instance doesn't exist. I
can see it running and can connect to the db so I am stumped. Thanks again.
| From: JR Bob Dobbs |
Date: Thursday, October 25, 2007
|
Does the
machine have multiple instances of SQL installed, including MSDE or
SQL
Express ? If so make sure that your connection includes
"SERVERNAME\INSTANCENAME" for a
named instance or "SERVERNAME\" for the default
instance.
| From: Lynda |
Date: Thursday, October 25, 2007
|
I do not think so. The instance is registered as servername\instancename. I am using the whole name as the server name.
| From: Adam Cameron |
Date: Thursday, October 25, 2007
|
I have a vague recollection that there was a
bug in one of the SQL2k
service packs that made it difficult/impossible for ColdFusion to
talk to it.
What's your
patch level on the SQL Server?
I have never attempted to connect to a named-instance SQL Server using the
instance name; it's never worked. I have always used IP Address (or [def]DNS[/def] (Domain Name Service)
domain name... NOT
Windows network computer name) and port number.
Named instances of SQL2k can end up with weird port numbers, which are
sometimes in use by other services. Have you sniffed the port to see
what's actually repsonding on it? It might not be the SQL Server.
Can you telnet
onto it (I'm buggered if I know any commands SQL Server will
accept via telnet, but at least getting a connection'd be a start).
--
Adam
| From: cf_dev2 |
Date: Thursday, October 25, 2007
|
Are you sure the port number is correct? I have read a few posts by people having problems with SQL 2005 express not using the expected port number.
| From: Lynda |
Date: Thursday, October 25, 2007
|
Yes, checked the port several times. My server name and instance names are the same. Do you think it is possible that could cause a problem?
| From: JR Bob Dobbs |
Date: Thursday, October 25, 2007
|
| From: Lynda |
Date: Thursday, October 25, 2007
|
Thank you. I gave that a try. The driver error went away, but it was replaced
with the following:
"com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the
host has failed. JAVA.net.UnknownHostException:
The root cause was that: com.microsoft.sqlserver.jdbc.SQLServerException: The
TCP/IP connection to the host has failed. JAVA.net.UnknownHostException:"
| From: cf_dev2 |
Date: Thursday, October 25, 2007
|
That's good news. Are your firewalls configured to allow access to the sql server?
| From: Lynda |
Date: Thursday, October 25, 2007
|
Yes to both.
| From: cf_dev2 |
Date: Thursday, October 25, 2007
|
UnknownHostException
Hm. On second thought that error sounds like its not resolving the server name. Have you tried using using the IP
address in place of the server name?
| From: JR Bob Dobbs |
Date: Thursday, October 25, 2007
|
Does the account the Cold Fusion service is running as have rights to access
other servers on your network?
I agree with cf_dev, it looks like the service is having problems connecting
on the correct port and/or resolving the address of the SQL machine.
| From: Adam Cameron |
Date: Friday, October 26, 2007
|
local machine. I have tried every combination I could think of
IP\instancename, computername\IP.
Nonono. Just the IP address. Forget about the instance name: you do not
need it.
Just use the IP address and the port.> translations of my
data . Actually I am running with no service packs.
Patch it up.> a fresh reinstall that was performed yesterday by Microsoft. Besides the
client network tool, is there another way to determine the port? I cannot
telnet to that port using 127.0.0.1.
Have a look in
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib\Tcp
--
Adam
| From: Lynda |
Date: Friday, October 26, 2007
|
I have tried usingthe IP address instead. This is an instance running on my
local machine. I have tried every combination I could think of
IP\instancename, computername\IP. I have checked the port several times and
even tried changing it. I can create a DSN through the
admin tools in Windows
and connect through an ODBC Socket connection but I get too many weird
translations of my data. Actually I am running with no service packs. This is
a fresh reinstall that was performed yesterday by Microsoft. Besides the
client network tool, is there another way to determine the port? I cannot
telnet to that port using 127.0.0.1.
| From: JR Bob Dobbs |
Date: Friday, October 26, 2007
|
| From: Adam Cameron |
Date: Friday, October 26, 2007
|
In any case applying the SP probably would not hurt.
Yep. Patch it up, and try again.
I realise Lynda said that the computer in question is a local PC, so
probably isn't outwardly facing (ie: onto the 'net). But this warning
could still be relevant:
A couple of years ago - long after SQL Slammer had done the rounds, so one
might think it was no longer a problem - one of our jr developers was
tasked with setting up a new SQL Server instance which ended up being
outwardly facing. She did not remember to patch it (and I - the
box was my
responsibility - forgot to check).
It took about half an hour of uptime for it to get infected, and about
15min after that before our
LAN was flattened by virus-enabled traffic
trying to find other machines to infect. Suddenly 20-odd people couldn't
work whilst we cleaned out their machines, and checked for any number of
other infections. I wasn't popular that day (not least of all with
myself!).
Always... ALWAYS... make sure your SQL Servers are fully patched.
I'd *never* attach a machine with non-patched SQL Server even to a LAN,
let alone the outside world.
I cannot stress that enough.
--
Adam
| From: Lynda |
Date: Friday, October 26, 2007
|
Just the IPdoesn't work. This is the error I get when I give that a try.
"Connection
verification failed for data
source : lpSQL
JAVA.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing
socket to host and port: 127.0.0.1:1433. Reason: Connection refused: connect
The root cause was that: JAVA.sql.SQLException: [Macromedia][SQLServer JDBC
Driver]Error establishing socket to host and port: 127.0.0.1:1433. Reason:
Connection refused: connect"
I'm
downloading the SP now.
| From: cf_dev2 |
Date: Friday, October 26, 2007
|
Yes, try the SP. I remember a conversation with Dr. Who a few weeks ago.
According to them they were getting Connection refused: until they applied SP4
(CF8/MS SQL2000). In any case applying the SP probably would not hurt.
| From: cf_dev2 |
Date: Friday, October 26, 2007
|
It took about half an hour of uptime for it to get infected, and about
> 15min after that before our LAN was flattened by virus-enabled traffic
> trying to find other machines to infect.
Holy crap. You have got me wanting to check the SP levels of every sql server I
work with... and I'm not the dba or network admin
| From: Lynda |
Date: Friday, October 26, 2007
|
SP 4 fixed the problem.
Thanks to everyone for their help!!
Next Message: Connection Failed for the network data souce
Blogs related to Cannot Connect to SQL 2000
Pda
... mini sd cards dunlop strike update female lapdancers kicking balls free dowenload fl studioupdate version how to stop googleupdaterservice.ese chipdalle blackpool lapdancing symantic intelligent updater yast
cannot connect to update
...
Pda
... ibuprofin pxa maurice clarett update 2006 kent hovind update firmware update for beta brite sign yast
cannot connect to update server in suse linux 9.1 vitality avt defibrillator malfunction update floyd+landis+update n7o firmware
...
Pda
... at ts list galleries updated daily hs-v2 update prophasy update pda activesync assinged ip address ambest rating update general insurance corporation india blackberry 7510 update drvupdate.com yast
cannot connect to update server in
...
Pda
... téléphone de pda serials
2000 update winantivirus pro 2006 2.1.259.12 post traumatic stress disorder pda driver_updates the gyroscopic inertial thruster update interqual and pda pda birdsoft download pdanet 1.73 yast
cannot connect ...
Pda
44th bridge construction update tsbm
2000 updates otter pda case updates novosti lapdancing portsmouth updates on darlie routier naztech x3 sports case compatible to the dell axim x51 pda scrip advantage update healthyupdates indian
...
Pda
how to make bluetooth connection from pda to pc driver_updates what is 120-day safety update report wintv
2000 updates natalie holloway update directv.com/update pdair leather case 9500 short baby update klubsaham com komunitas investor
...