Re: RWW and Sql Enterprise Manager

I understand how you feel as I was a developer myself. But security is of
utmost importance. If you are simply looking at managing these SQL Servers
remotely, let's say a SQL Server inside a SBS domain, RWW should work fine.
It's just like running secure RDP on the remote machine. Or, have a VPN
connection and run an RDP session on the remote machine and run Enterprise
Manager from there. Opening ports to manage remote SQL Servers from a single
Enterprise Manager instance is not recommended on an unsecured network
connection.
--
MCP MCDBA MCAD MCSD MCT MCTS MCITP:DBA
"Helping people grow and develop their full potential as God has plan for
them"


"casy" wrote:

Thanks for the tip on webbased managers, I didnt know they existed,
will have a look- if they work SQL 2000/2005 then great!

So under a straight RWW configuration it is impossible to use Ent
Manager?
If you open up the extra ports then it is possible?

Security: I'm the developer supporting a remote site, so with other
sites and a VPN, we open the ports, do the work then close them. There
is really no other way or have I missed something?

Casey


On May 7, 3:08 pm, bass_player <basspla...@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
I won't do that for security reasons but just in case, check your firewall if
it is allowing port forwarding to 1433/1434 - both inbound and outbound.
Again, this is very risky. Have you tried using ASP Enterprise Manager?
There's one from SourceForgehttp://sourceforge.net/projects/asp-ent-man/

and an unsupported one from Microsofthttp://www.microsoft.com/downloads/details.aspx?FamilyID=c039a798-c57...
--
MCP MCDBA MCAD MCSD MCT MCTS MCITP:DBA
"Helping people grow and develop their full potential as God has plan for
them"



"casy" wrote:
Hi All,

Can I log on to my SBS 2003 Premium server and use the server SQL
Enterprise manager to also register my remote SQL database (to enable
data transfer etc)?

Have tried but cannot seem to get access, I know a full VPN works....

Casey- Hide quoted text -

- Show quoted text -



.

Relevant Pages

  • Stored Procedure Fails Only When Called By Agent
    ... connect to and add logins for 12 remote SQL servers ... remote server, one at a time, for 5 tables. ... These stored procedures work fine when run from Query Analyzer, ... I get an error message of "Msg 17, ...
    (microsoft.public.sqlserver.replication)
  • Having an updated base every day
    ... I have two symmetrical databases on two SQL servers - one remote, ... The data in the remote server changes every minute. ... The data in the remote database should ... result could be achieved by detaching the remote base and bringing over the ...
    (microsoft.public.sqlserver.server)
  • Visual Studio 6. SP6 - SQL Server 7
    ... nachdem ich das SP6 für Visual Studio 6.0 installiert habe ... ist es dem Enterprise Manager des SQL Servers nicht mehr ...
    (microsoft.public.de.vc)
  • Re: Unable to browse for available SQL servers across subnets??
    ... > can only browse for available SQL servers in the subnet where Enterprise ... > span aross at least 2 different subnets. ... > Enterprise Manager, I can only browse list of servers on the local subnet. ... > exchange browse lists info across subnets. ...
    (microsoft.public.sqlserver.connect)
  • Re: Unable to browse for available SQL servers across subnets??
    ... > can only browse for available SQL servers in the subnet where Enterprise ... > span aross at least 2 different subnets. ... > Enterprise Manager, I can only browse list of servers on the local subnet. ... > exchange browse lists info across subnets. ...
    (microsoft.public.sqlserver.server)