Cable Forum

Cable Forum (https://www.cableforum.uk/board/index.php)
-   Virgin Media Internet Service (https://www.cableforum.uk/board/forumdisplay.php?f=12)
-   -   SQL Server connection since upgrade (https://www.cableforum.uk/board/showthread.php?t=29525)

Terry_Reader 30-05-2005 22:13

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

Paul 30-05-2005 22:30

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 ?)

Roy MM 30-05-2005 22:31

Re: SQL Server connection since upgrade
 
Firstly :welcome: to the site,

I'm getting "outbind not a registered protacol" i would wait for the more knowledgeable member offer advice.

Raistlin 30-05-2005 22:35

Re: SQL Server connection since upgrade
 
Quote:

Originally Posted by Roy MM
Firstly :welcome: 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 :shrug:

Terry_Reader 30-05-2005 22:38

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

Paul K 30-05-2005 22:42

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?

Terry_Reader 30-05-2005 22:46

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

Paul K 30-05-2005 22:48

Re: SQL Server connection since upgrade
 
Quote:

Originally Posted by Roy MM
Firstly :welcome: 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 :shrug:
As to Borked there are two O's in school ;) The last URL in your previous post is mis spelled lol

Paul 30-05-2005 22:49

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 ?

Terry_Reader 30-05-2005 22:58

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!

Paul 30-05-2005 23:11

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.

Terry_Reader 30-05-2005 23:30

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?

Raistlin 30-05-2005 23:42

Re: SQL Server connection since upgrade
 
Terry,

:welcome: 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.

Paul 31-05-2005 01:04

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.

Terry_Reader 31-05-2005 01:20

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!!!!!


All times are GMT. The time now is 05:05.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2026, vBulletin Solutions Inc.
All Posts and Content are © Cable Forum