registering remote servers 1

[annel]

I was handed a sql server database on a web server 250 km south from where I live and asked to change certain elements on it. I've never used sql server before. I need to access this database remotely (hopefully download it to my computer to change it and then upload it back to the web server). I have an ip address for the sql server but everytime I try to register this remote server I get a connection failed error message. The other problem I have is that the remote sql server is sql server version 6.5, I have sql server 7.0 --I'm not sure if ther will be any conflicts. Can anyone help me?<br>
Thanks annel

 

[strafe]

Similar situation here at work- although this is a development environment. Simple solution I found was to install the SQL Server 6.5 client on my machine. This will allow you to manage the 6.5 machine, although it means you will be using 2 different Enterprise Managers. I am sure there is a simple way to manager both from the SQL 7.0 interface, I'm not sure what it is.<br>
<br>
hope that helps

 

[LN]

Hi,


It is not enough that you have ip address of the server. you also need to have username and password to get connected to the server.

LN

 

[culshaja]

Have you configured the server in the client network utility? You can't put an IP Address int6o the server name slot when trying to register a server!
What you have to do is to add a new entry to the client network utility, give it an alias, specify the IP Address and get the right port. When this is done you can use the Server alias when registering the remote server. It took me ages to work that one out the first time I tried to do it. Watch the port, that catches you out quite a bit as people change the port number for security reasons.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305

 

[foxdev]

James, I am able to use an IP address as the server name when registering a SQL Server, at least in SQLS7. I can do this without changing anything in my client connection manager.

As you've discovered, annel, the SQLS7 EM will refuse to register an SQLS6.5 server. 7's Query Analyzer will work, though.

Robert Bradley

http://www.foxdev.com/

 

[culshaja]

Robert, are you going across a router and through a firewall? This was what was happening to me, and I couldn't use an IP Address - I kept getting an ODBC error. This was the only way to solve the problem.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305

 

[foxdev]

Actually, yes, I am going through a firewall. In fact, it is the most restrictive setup I've ever worked under (its my client's location, not something of my own doing and nothing I have control over), as things like HTTP are handled via proxy server.

Behind this digital curtain, I've been able to connect to SQL Servers in Texas and Michigan by specifying the IP address of the server - it works fine in both EM and QA. The only thing I did in SQLS's Client Configuration was ensure that TCP/IP was available as a protocal (changing it from the default of Named Pipes). I do not have a DSN set up to point to these servers.

Robert Bradley

http://www.foxdev.com/

 

[culshaja]

It wasn't a DSN I set up. I entered the IP Address in the server name box when trying to register the server via the wizard. I got right to the very end, and then it worked for a while and then reported a cannot connect error - I've probably got the content of the error message wrong.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305

 

[TomSark]

So... you did set up a TCP/IP alias in the client network utility?


Tom

 

[culshaja]

Yep, and then it worked a treat! Don't ask me why it didn't work before.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305