I need to manage a SQL Server installation over the internet via a VPN
connection.
Enterprise Manager can't see the server, when I put in the name, EM times
out.
How can I Register this server if EM can't see it from here?
If I Register the server while I'm at that site, should it then work from my
remote office?
Thanks
KelvinNot being able to connect to the SQL server in question may be due to a
couple of different issues.
Please try the below suggestions:
1 - Possibly due to latency in the VPN connection causing a connection
time-out.
- Increase the Enterprise Manager timeout for the connection
- In Enterprise Manager, select TOOLS, OPTIONS and click on the ADVANCED
tab.
- Extend the value in the 'Login time-out' field (default of 10 seconds).
If the above doesn't work, then:
2 - Possibly a DNS/WINS resolution issue going over the VPN
- Run the Client Configuration Utility (CLICONFG.EXE) on your machine that
has the server registered in Enterprise Manager
- Click on the ALIAS tab
- Click ADD
- Type the name of the SQL Server (same name as you registered it with in
EM) in the 'Server Alias' field
- Click on the TCP/IP protocol (or applicable protocol if not using TCP/IP)
- In the 'Server Name' field, type the TCP/IP address for the server (or
the protocol's reference to the server if not using TCP/IP).
Dave
"Kelvin Beaton" wrote:
> I need to manage a SQL Server installation over the internet via a VPN
> connection.
>
> Enterprise Manager can't see the server, when I put in the name, EM times
> out.
>
> How can I Register this server if EM can't see it from here?
>
> If I Register the server while I'm at that site, should it then work from
my
> remote office?
>
> Thanks
>
> Kelvin
>
>|||thanks Dave
The second option worked!
Thanks a million
Kelvin
"DBADave" <DBADave@.discussions.microsoft.com> wrote in message
news:F2C00FEF-4800-4DE3-BAEC-E0125CE8BB7A@.microsoft.com...[vbcol=seagreen]
> Not being able to connect to the SQL server in question may be due to a
> couple of different issues.
> Please try the below suggestions:
> 1 - Possibly due to latency in the VPN connection causing a connection
> time-out.
> - Increase the Enterprise Manager timeout for the connection
> - In Enterprise Manager, select TOOLS, OPTIONS and click on the ADVANCED
> tab.
> - Extend the value in the 'Login time-out' field (default of 10 seconds).
> If the above doesn't work, then:
> 2 - Possibly a DNS/WINS resolution issue going over the VPN
> - Run the Client Configuration Utility (CLICONFG.EXE) on your machine
> that
> has the server registered in Enterprise Manager
> - Click on the ALIAS tab
> - Click ADD
> - Type the name of the SQL Server (same name as you registered it with in
> EM) in the 'Server Alias' field
> - Click on the TCP/IP protocol (or applicable protocol if not using
> TCP/IP)
> - In the 'Server Name' field, type the TCP/IP address for the server (or
> the protocol's reference to the server if not using TCP/IP).
> Dave
>
> "Kelvin Beaton" wrote:
>
Friday, February 24, 2012
How can I get Enterprise Manager to see my remote server?
Labels:
database,
enterprise,
installation,
internet,
manage,
manager,
microsoft,
mysql,
oracle,
remote,
server,
sql,
via,
vpnconnection
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment