Re: RWW and Sql Enterprise Manager

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thanks again,
Just to be clear -
I can run Ent Manager on the remote server thru RWW, no problem.
My goal is to have the two servers managed by a single Enterprise
Manager instance to facilitate onerous data changes between SQL
servers.
Is this possible under RWW ? (not having much luck so far...)
The last time we did this the client VPN'ed into my SBS box while I
opened my 1433 ports (my risk)

Under RWW willl it work if I open '1433 out' on the clients server and
again open my inward ports and use my local Ent manager?

Scuse if I am talking nonsense!

Casey

On May 8, 2:26 pm, bass_player <basspla...@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
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 -- Hide quoted text -

- Show quoted text -


.

Relevant Pages

  • Re: Xserve a good choice for SMB
    ... CIOs whose IT departments are relying on Windows-based or Linux/Unix-based servers could find cost savings and more manageable operations by switching to Apple's Latest News about Apple Xserve. ... Overall cost of ownership is much less than the alternatives," Andrew E. Filipowski, product manager at SolidSpace, told MacNewsWorld. ... The statement below shows that he/she has no knowledge of the remote support tools that have been built into Intel servers for years, allowing full out-of-band remote management, including physically powering off the box. ...
    (comp.sys.mac.advocacy)
  • Re: Xserve a good choice for SMB
    ... CIOs whose IT departments are relying on Windows-based or Linux/Unix-based servers could find cost savings and more manageable operations by switching to Apple's Latest News about Apple Xserve. ... Overall cost of ownership is much less than the alternatives," Andrew E. Filipowski, product manager at SolidSpace, told MacNewsWorld. ... What support do you get if you don't opt for Server Software support, which starts at $5,995 ... The statement below shows that he/she has no knowledge of the remote support tools that have been built into Intel servers for years, allowing full out-of-band remote management, including physically powering off the box. ...
    (comp.sys.mac.advocacy)
  • Re: vpn to server then remote desktop to client
    ... I can now log on to RWW however I cannot connect to client PCs. ... The client could not connect to the remote computer. ... servers but not on the other. ...
    (microsoft.public.windows.server.sbs)
  • Re: vpn to server then remote desktop to client
    ... I'm not sure how you can be supporting several SBS 2003 servers and not be fully aware of the major features? ... RWW = Remote Web Workplace ... If I knew what rww was and how to use it I suppose I could be persuaded to ... >> By establishing a vpn to the server first I can use remote desktop to ...
    (microsoft.public.windows.server.sbs)
  • Can Not connect to IPC$ Share while processing a CCR
    ... CCM log shows the SMS server successfully connecting to the Admin$ share, but the attempt to connect to the IPC$ shares of these systems fails with an error 5. ... Logical Disk Manager Administrative Service ... Network Associates Task Manager ... Remote Access Auto Connection Manager ...
    (microsoft.public.sms.setup)