SQL Server connection since upgrade
30-05-2005, 22:13
|
#1
|
|
Inactive
Join Date: May 2005
Age: 71
Posts: 7
|
SQL Server connection since upgrade
Hi all,
I've recently (last Saturday) been upgraded tot the new silver set top box and since then I have been unable to connect to an external SQL server site that I use for an animal sanctuary registration site. I had this problem a few months ago and had to get a seperate adsl connection from Nildram then suddenly the problem disappeared so I dropped the Nildram.
Anyone any help? All was fine until the new box arrived!
Terry Reader
Educational Health and Safety Website
www.schoolshealthandsafety.co.uk
On-line Registry of Animal Sanctuaries and Rescue Centres
www.animal-sanctuaries.co.uk
|
|
|
30-05-2005, 22:30
|
#2
|
|
Dr Pepper Addict
Cable Forum Admin
Join Date: Oct 2003
Location: Nottingham
Age: 63
Services: Zen & YouFibre FTTP, Sky Q TV, Sky Mobile, Flextel SIP
Posts: 31,415
|
Re: SQL Server connection since upgrade
Does the sql site have a firewall - if so, is your current ip address (which will have changed) allowed access ?
(btw, I can't see an MS SQL server on either of those sites, is it on a different ip ?)
__________________
Baby, I was born this way.
|
|
|
30-05-2005, 22:31
|
#3
|
|
Inactive
Join Date: Jun 2003
Location: Treasure Island
Age: 80
Services: NTL cable 20mb Broadband, V+ package.
Posts: 1,971
|
Re: SQL Server connection since upgrade
Firstly  to the site,
I'm getting "outbind not a registered protacol" i would wait for the more knowledgeable member offer advice.
|
|
|
30-05-2005, 22:35
|
#4
|
|
Inactive
Join Date: Feb 2004
Location: There's no place like 127.0.0.1
Services: Depends on the person and the price they're offering
Posts: 12,384
|
Re: SQL Server connection since upgrade
Quote:
|
Originally Posted by Roy MM
Firstly  to the site,
I'm getting "outbind not a registered protacol" i would wait for the more knowledgeable member offer advice.
|
outbind is probably something to do with the SQL Server connection
|
|
|
30-05-2005, 22:38
|
#5
|
|
Inactive
Join Date: May 2005
Age: 71
Posts: 7
|
Re: SQL Server connection since upgrade
Quote:
|
Originally Posted by Paul M
Does the sql site have a firewall - if so, is your current ip address (which will have changed) allowed access ?
(btw, I can't see an MS SQL server on either of those sites, is it on a different ip ?)
|
Paul,
The site that hosts all my internet sites is Protecweb. They do not have a firewall as far as I am aware since I have accessed them from different ip adresses without needing to register. I will email them though and check.
www.animal-sanctuaries.co.uk has a sql db that is used to generate the list of sanctuaries that are of a particular type. www.scholshealthandsafety.co.uk does not need a database.
Terry Reader
Educational Health and Safety Website
www.schoolshealthandsafety.co.uk
On-line Registry of Animal Sanctuaries and Rescue Centres
www.animal-sanctuaries.co.uk
|
|
|
30-05-2005, 22:42
|
#6
|
|
Inactive
Join Date: Jun 2003
Location: Essex innit
Age: 52
Services: Sky HD + 16Mb ADSL
BT Telephone
Posts: 15,735
|
Re: SQL Server connection since upgrade
The links in your post is borked which isn't helping. Have you checked your host hasn't adjusted anything?
|
|
|
30-05-2005, 22:46
|
#7
|
|
Inactive
Join Date: May 2005
Age: 71
Posts: 7
|
Re: SQL Server connection since upgrade
Quote:
|
Originally Posted by Paul
The links in your post is borked which isn't helping. Have you checked your host hasn't adjusted anything?
|
Paul,
"borked" ?
please translate lol
|
|
|
30-05-2005, 22:48
|
#8
|
|
Inactive
Join Date: Jun 2003
Location: Essex innit
Age: 52
Services: Sky HD + 16Mb ADSL
BT Telephone
Posts: 15,735
|
Re: SQL Server connection since upgrade
Quote:
|
Originally Posted by Roy MM
Firstly  to the site,
I'm getting "outbind not a registered protacol" i would wait for the more knowledgeable member offer advice.
|
URL in the top post is outbind://16-0000000012F4499A268C344C8D0E4F94BC961B3A64298100/www.animal-sanctuaries.co.uk
so that be part of the reason, both sites seemed to be working fine and the database worked when I looked at the centers list on the sanctuary site 
As to Borked there are two O's in school  The last URL in your previous post is mis spelled lol
|
|
|
30-05-2005, 22:49
|
#9
|
|
Dr Pepper Addict
Cable Forum Admin
Join Date: Oct 2003
Location: Nottingham
Age: 63
Services: Zen & YouFibre FTTP, Sky Q TV, Sky Mobile, Flextel SIP
Posts: 31,415
|
Re: SQL Server connection since upgrade
Terry,
First can you please edit you signature to 4 lins max, thanks.
Second - how exactly are you connecting to the database ?
__________________
Baby, I was born this way.
|
|
|
30-05-2005, 22:58
|
#10
|
|
Inactive
Join Date: May 2005
Age: 71
Posts: 7
|
Re: SQL Server connection since upgrade
Quote:
|
Originally Posted by Paul M
Terry,
First can you please edit you signature to 4 lins max, thanks.
Second - how exactly are you connecting to the database ?
|
Paul,
Is the signature below ok? - btw - I'm having to cut n paste even though I've set my sig up - how do I get it to enter automatically - Ican't seem to find an option box anyway - I assume there is one.
I'm trying to connect via Enterprise Manager as I always have done.
__________________
I just found where the option is!
|
|
|
30-05-2005, 23:11
|
#11
|
|
Dr Pepper Addict
Cable Forum Admin
Join Date: Oct 2003
Location: Nottingham
Age: 63
Services: Zen & YouFibre FTTP, Sky Q TV, Sky Mobile, Flextel SIP
Posts: 31,415
|
Re: SQL Server connection since upgrade
Quote:
|
Originally Posted by Terry_Reader
Is the signature below ok?
|
Yes.
Quote:
|
Originally Posted by Terry_Reader
I'm trying to connect via Enterprise Manager as I always have done.
|
I have tried to connect to www.animal-sanctuaries.co.uk on the standard ms sql port from three different sources and none can connect - either it's dead, it's firewall protected, or it's on a different address/ip.
__________________
Baby, I was born this way.
|
|
|
30-05-2005, 23:30
|
#12
|
|
Inactive
Join Date: May 2005
Age: 71
Posts: 7
|
Re: SQL Server connection since upgrade
Quote:
|
Originally Posted by Paul M
Yes.
I have tried to connect to www.animal-sanctuaries.co.uk on the standard ms sql port from three different sources and none can connect - either it's dead, it's firewall protected, or it's on a different address/ip.
|
Paul,
The sql db is not named the same as the su=ite, nor is it a part of the site directly. I can give you the detail but would prefer not to do so over an open forum message. Is there a way I can contact you directly?
|
|
|
30-05-2005, 23:42
|
#13
|
|
Inactive
Join Date: Feb 2004
Location: There's no place like 127.0.0.1
Services: Depends on the person and the price they're offering
Posts: 12,384
|
Re: SQL Server connection since upgrade
Terry,
 to Cable Forum.
If you click on Paul's name in the top left of his posts a drop-down menu will appear.
Select "Send a private message to Paul M". This will send a message directly to Paul. These messages are only readable by the intended recipient.
|
|
|
31-05-2005, 01:04
|
#14
|
|
Dr Pepper Addict
Cable Forum Admin
Join Date: Oct 2003
Location: Nottingham
Age: 63
Services: Zen & YouFibre FTTP, Sky Q TV, Sky Mobile, Flextel SIP
Posts: 31,415
|
Re: SQL Server connection since upgrade
I got your pm, and I can connect to your server fine.
From a command prompt, can to type ;
telnet <server> 1433
and press enter (putting in the server name you sent me).
then try ;
telnet 195.82.99.16 1433
and press enter - this is not an sql server, but just a dummy program listening on the same port - you should be able to connect, and then get dropped.
__________________
Baby, I was born this way.
|
|
|
31-05-2005, 01:20
|
#15
|
|
Inactive
Join Date: May 2005
Age: 71
Posts: 7
|
Re: SQL Server connection since upgrade
telnet <server> 1433 - I got "Could not open connection to the host on port 1433: connection failed"
telnet 195.82.99.16 1433 - I got "Could not open connection to the host on port 1433: connection failed"
so something is obviously blocking my connection and the only thing that has changed is the new pretty silver box from Samsung!!!!!
|
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT. The time now is 04:57.
|