Re: Connect with alias



My progam installed an instance of MSDE on their "Server" (just an XP
machine).
I have a copy of SQL Server at my office.

From their CLIENT1:
YES: connect to my my SQL Server
NO: connect to their MSDE Server
NO : Connect to MSDE Server with alias with DYNAMIC PORT #
YES: connect to their MSDE Server with alias set up WITH PORT# specified


From CLIENT2:
YES: connect to my my SQL Server
NO: connect to their MSDE Server
YES: Connect to MSDE Server with alias with DYNAMIC PORT #
YES: connect to their MSDE Server with alias set up WITH PORT# specified


FROM MY OFFICE:
YES: connect to my my SQL Server
YES: connect to their MSDE Server
YES: Connect to MSDE Server with alias with DYNAMIC PORT #
YES: connect to their MSDE Server with alias set up WITH PORT# specified

"Andrea Montanari" <andrea.sqlDMO@xxxxxxxxxxx> wrote in message
news:4jen0lF7ki7dU1@xxxxxxxxxxxxxxxxx

all in the same scenario? :-|


.



Relevant Pages

  • Re: sa account - hpw to reset a compromised pw
    ... Try connecting to your MSDE server with a Administrator account and then ... Addtional Information ... Manage the SQL Server Desktop Engine by Using the Osql ...
    (microsoft.public.sqlserver.security)
  • Re: Login Failed
    ... James Goodman "Murphy" wrote in message ... >> to access the server I am denied access. ... >> need to login as administrator in order to connect the MSDE server machine ...
    (microsoft.public.sqlserver.msde)
  • Re: MSDE on XP running, but not recognized in ODBC
    ... > I installed an MSDE instance for a user running XP with an ... > we go to pick the MSDE Server, ... Thanks, JRaub. ...
    (microsoft.public.sqlserver.msde)
  • Re: MSDE 2000 SP3a on a Windows 2003 server
    ... Apperently my ports are setup correctly, but MSDE server ... 2004-02-20 15:35:12.26 server SQL server listening on ...
    (microsoft.public.sqlserver.msde)
  • [fw-wiz] Re: firewall-wizards digest, Vol 1 #1322 - 1 msg
    ... Most of the protocols you mention are RPC based connections. ... There were AD server, File server and ... > different client. ... > correct this dynamic port setup issue. ...
    (Firewall-Wizards)