Activating MSDE for remote Access

From: Joseph Geretz (jgeretz_at_nospam.com)
Date: 07/02/04 

Date: Fri, 2 Jul 2004 10:17:07 -0400

I'm finding that when I install MSDE, by default no protocols are enabled
for remote access. I've found that I can use the SQL Server Network Utility
to enable the TCP/IP protocol and then the MSDE instance is accessible from
remote workstations.

But how can I do this without having the SQL Server Client Tools installed?
Is there a command line or configuration option I can use?

Thanks for your help,

Joe Geretz

Relevant Pages

  • Re: Sql Remote Connection issue
    ... Remote access is set to 1. ... Sql Server is listening on 127.0.0.1:1433. ... The above would indicate it's using the default port. ... To verify the connection I'm using telnet to verify communications is ...
    (microsoft.public.sqlserver.connect)
  • RE: Problems connecting to MSDE server
    ... Thank you for your post regarding unable to connect to SQL Server. ... didn't specify to enable protocols when installing, ... run svrnetcn.exe which will bring up the Server Network configuration ... The client tools ship with a full copy of SQL Server, ...
    (microsoft.public.sqlserver.msde)
  • TCP/IP and security
    ... I need to change the protocols settings during installation or, ... is selected as the default port instead ... - whatever port I say to SQL Server to use, ... STILL do not use it!(errorlog after service start lists the protocols used, ...
    (microsoft.public.sqlserver.security)
  • Re: Can I Upgrade
    ... I installed MSDE and configured it as I told you previously and I'm able to connect to that instance from another machine. ... Last guess is you are configuring this port setting for another instance of SQL Server. ... First and foremost is the fact that MSDE2000 will not start the protocols TCP/IP or Named Pipes. ...
    (microsoft.public.sqlserver.setup)
  • Re: Can I Upgrade
    ... Yes I am using the program svrnetcn to configure the protocols. ... As you can see SQL server is only listening on Shared Memory ... So the big question of the day is why is Named Pipes and TCP/IP not ... Microsoft SQL Server 2000 Developer Edition. ...
    (microsoft.public.sqlserver.setup)
Loading