"Brent Horine" <anonymous@discussions.microsoft.com> wrote in message
news:OJE4bvfWEHA.716@TK2MSFTNGP11.phx.gbl...
> I have installed MSDEa on a remote Windows 2003 Web Edition server
according
> to the following:
>
> setup.exe SAPWD=******* DISABLENETWORKPROTOCOLS=0 SECURITYMODE=SQL
>
> I connect to this server using remote desktop and I can use osql to login.
> I cannot get to it using Query Analyzer or osql from my development
machine.
> I am using the IP address as the Server name (which has worked for me in
the
> past). Response I get is:
>
> [DBNETLIB]SQL Server does not exist or access denied.
> [DBNETLIB]ConnectionOpen (Connect()).
>
> I have used svrnetcn.exe to verify that both Named Pipes and TCP/IP are
> enabled protocols. TPC/IP is using port 1433 and the Hide Server option
is
> NOT checked.
>
> I can ftp and ping the machine so at least some packets are getting
through.
> I don't know enough about IPSec on Win2003, but I don't see anything
> obviously blocking port 1433. I am able to connect to other remote SQL
> servers so our office firewall does not seem to be the problem.
>
> Any clues why I cannot connect remotely?
>
> Thanks,
>
> Brent
>
>

"Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:uhkel1fWEHA.1764@TK2MSFTNGP10.phx.gbl...
> Are you using sa/password or windows auth?
>
> Are you using a named instance?
>
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
>
>
> "Brent Horine" <anonymous@discussions.microsoft.com> wrote in message
> news:OJE4bvfWEHA.716@TK2MSFTNGP11.phx.gbl...
> > I have installed MSDEa on a remote Windows 2003 Web Edition server
> according
> > to the following:
> >
> > setup.exe SAPWD=******* DISABLENETWORKPROTOCOLS=0 SECURITYMODE=SQL
> >
> > I connect to this server using remote desktop and I can use osql to
login.
> > I cannot get to it using Query Analyzer or osql from my development
> machine.
> > I am using the IP address as the Server name (which has worked for me in
> the
> > past). Response I get is:
> >
> > [DBNETLIB]SQL Server does not exist or access denied.
> > [DBNETLIB]ConnectionOpen (Connect()).
> >
> > I have used svrnetcn.exe to verify that both Named Pipes and TCP/IP are
> > enabled protocols. TPC/IP is using port 1433 and the Hide Server option
> is
> > NOT checked.
> >
> > I can ftp and ping the machine so at least some packets are getting
> through.
> > I don't know enough about IPSec on Win2003, but I don't see anything
> > obviously blocking port 1433. I am able to connect to other remote SQL
> > servers so our office firewall does not seem to be the problem.
> >
> > Any clues why I cannot connect remotely?
> >
> > Thanks,
> >
> > Brent
> >
> >
>
>