Connecting to a MSDE server in Internet



Hi !!

I would like to connect to a SQL Server (MSDE edition) that's in Internet,
using Enterprise Manager either Query Analizer. For these I've configured
the client tool as:

Server Alias: INET_SERVER
Net: TCP/IP
Connection parameters:
Server name: [DNS_NAME]\[REMOTE_SERVER_NAME]\[INSTANCE_NAME]
Port number: 1433

Althought I've tried to configure the server name in different ways, I
haven't found the successful way to do it.
I don't think it's a firewall problem. In theory I've successfull disabled.


Thanks !!

Josep.



.



Relevant Pages

  • Re: sql server 2000 tools
    ... First you need to register production server with your username and password ... You don't need to access *.ldf files ... Then you should do a Transaction Log backup from Enterprise Manager. ...
    (microsoft.public.sqlserver.tools)
  • Re: Linked Server (Oracle 9i)
    ... >enterprise manager registration properties if you are using sa or windows ... >> Microsoft ODBC for Oracle ... >> When I try to connect to the linked server in Enterprise Manager I get ...
    (microsoft.public.sqlserver.odbc)
  • Re: Linked Server (Oracle 9i)
    ... >enterprise manager registration properties if you are using sa or windows ... >> Microsoft ODBC for Oracle ... >> When I try to connect to the linked server in Enterprise Manager I get ...
    (microsoft.public.sqlserver)
  • Re: Processadmin problems
    ... Enterprise Manager was written a little earlier than some of the function ... > our server as well as by support personnel for the application. ... > This login had been a member of the sysadmin fixed server role but I ...
    (microsoft.public.sqlserver.security)
  • Re: SA can not create users
    ... I also thought it may be enterprise manager but if I register different ... server on same enterprise manager I am able to create users for that new ... Simon Hayes wrote: ... >client tools completely. ...
    (comp.databases.ms-sqlserver)