| Author |
Topic |
|
patshaw
Posting Yak Master
177 Posts |
 Posted - 2007-03-23 : 05:21:17
|
| I have installed SQL Server 2000 Enterprise on an office based server. I can rdp to that machine and SQL Server appears to be functioning correctly.I need to connect to this SQL Server from Enterprise Manager on my local machine using the ip address and the sa login, but I cannot. I get the 'SQL Server does not exist or access is denied' error. I have tried the same thing from another machine with the same result.When I rpd to the office server I attempt to connect to SQL on my local machine using the same method it is fine, but I cannot do the reverse.Is there something obvious here that I am overlooking? Any input would be greatly appreciated. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-03-23 : 05:27:22
|
is the SQL Server a default instance ? What is the port no used ? try specifing <ip address>,<port no>
KH |
 |
|
|
patshaw
Posting Yak Master
177 Posts |
Posted - 2007-03-23 : 05:43:44
|
| Hi Khtan,It is a the only instance on the machine but it is named. I have tried specifying the port (1433) but still get no connectivity. |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-03-23 : 05:47:41
|
for named instance, use <ipaddress>\<instance name>example 192.168.0.1\MySQLServer
KH |
|
|
|
patshaw
Posting Yak Master
177 Posts |
Posted - 2007-03-23 : 05:53:46
|
| No, still no connection........fails with the same message. |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-03-23 : 05:59:16
|
is it on the same network ? any firewall that is blocking the port ? Any other machine on the network that can connect to this server ?
KH |
|
|
|
patshaw
Posting Yak Master
177 Posts |
Posted - 2007-03-23 : 06:37:20
|
| --is it on the same network ?I'm not sure I understand you - I have installed SQL Server directly onto the only server. This is a small office with only one network.--Any other machine on the network that can connect to this server ?Yes, there are around 6 machines that connect to the server.--any firewall that is blocking the port ?Not that I am aware of. I can ftp straight to the server with no problems. I set the ftp server up on the server using serv-u ftp. I was not aware of a firewall. The server is W2k, does this have any built-in firewall? |
|
|
|
patshaw
Posting Yak Master
177 Posts |
Posted - 2007-03-24 : 07:16:54
|
| This is sorted now. I re-started SQL Server (again!!) and all worked fine. |
|
|
|
patshaw
Posting Yak Master
177 Posts |
Posted - 2007-03-29 : 01:55:19
|
| Actually, it isn't fine after all. It appears that the only time I can connect to the SQL Server is when there is a VPN connection between my computer and the server that the SQL Server resides on. As soon as I close the VPN I cannot see this SQL Server from my local machine.Any ideas anybody? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-03-29 : 02:06:43
|
| You have different subnet masks?Server is on DMZ zone?Peter LarssonHelsingborg, Sweden |
|
|
|
patshaw
Posting Yak Master
177 Posts |
Posted - 2007-03-29 : 03:12:27
|
| I can connect to mycomputerA from ServerB at any time with or without VPN being on but cannot connect to ServerB from mycomputerA without VPN on. I really don't understand. |
|
|
|
patshaw
Posting Yak Master
177 Posts |
Posted - 2007-03-29 : 04:34:21
|
| The reason I need to make a connection to the server is so that that I can replicate to it (hence my post on the DTS/Replication forum). I set up a distribution database on the server and that is all ok. When I attempt to set up a Publisher on the other computer it wants to know where the Distributer is and fails because it cannot see the server.Is there another way or workaround I can use so that I can set up a publisher on my machine without specifying the elusive server as the distributor, and then use PULL to get the data accross? |
|
|
|
|
Can't see database server on other machine from EM