Microsoft SQL Server forum - Installing MSDE2000 for Remote Connection

Author

Installing MSDE2000 for Remote Connection

Phil

2005-04-27, 8:24 pm

I attempted to install MSDE on a WinXP machine(server) today. I installed
from the command prompt as follows:-

>setup INSTANCENAME="NetSDK" SECURITYMODE=SQL BLANKSAPWD=1

Before I get 'blasted', I know that I 'really shouldn't' use a blank sa pswd
but.......I did :-)

I then detached (sp_detachdb) an existing db from another machine. Moved it
onto the new instance and reattached it.

Finally, I executed the following scripts:-

sp_addlogin @loginame = 'name', @passwd = 'password', @defdb = 'dbName'
sp_grantdbaccess 'name'
sp_addrolemember 'db_owner', 'name'

So, this was fine and I could connect to the new db using either windows
integrated security or 'name'/'password' BUT..BIG BUT, only at the server.
When I tried to connect from a client I received an error message, 'SQL
Server Does Not Exist or Access Denied'.

I am assuming that all is well with the db and that it is something I have
done...or more probably not done with the sql server instance (as the error
suggests:-). Can anyone please suggest my error?

Thanks

Simon Hayes

2005-04-27, 8:24 pm

"Phil" <Phil@nospam.com> wrote in message
news:d4osus$gde$1@nw
rdmz01.dmz.ncs.ea.ibs-infra.bt.com...
>I attempted to install MSDE on a WinXP machine(server) today. I installed
>from the command prompt as follows:-
>
>
> Before I get 'blasted', I know that I 'really shouldn't' use a blank sa
> pswd but.......I did :-)
>
> I then detached (sp_detachdb) an existing db from another machine. Moved
> it onto the new instance and reattached it.
>
> Finally, I executed the following scripts:-
>
> sp_addlogin @loginame = 'name', @passwd = 'password', @defdb = 'dbName'
> sp_grantdbaccess 'name'
> sp_addrolemember 'db_owner', 'name'
>
> So, this was fine and I could connect to the new db using either windows
> integrated security or 'name'/'password' BUT..BIG BUT, only at the server.
> When I tried to connect from a client I received an error message, 'SQL
> Server Does Not Exist or Access Denied'.
>
> I am assuming that all is well with the db and that it is something I have
> done...or more probably not done with the sql server instance (as the
> error suggests:-). Can anyone please suggest my error?
>
> Thanks
>

You don't mention which version of MSDE, but as of SP3 network access is
disabled by default - see the DISABLENETWORKPROTOC
OLS switch in the readme
file. In addition, the Windows XP SP2 firewall blocks any MSSQL services on
the box from listening on the network. See these articles:

http://support.microsoft.com/defaul...kb;en-us;841249
http://support.microsoft.com/defaul...kb;en-us;814130
http://support.microsoft.com/defaul...kb;en-us;328306

Simon

Phil

2005-04-27, 8:24 pm

Thanks Simon,

As usual a swift and informative response. It is/was SP3 and I did not
include the DISABLENETWORKPROTOC
OLS switch and therefore by default the
libraries are disabled.....so, my question then is, once installed how do I
change the value from NULL or 1 to 0? Would I be right (and hopeful) to
think it might be as simple as a registry key change????? If not, do I have
to perform a setup /upgradesp install?

Looking forward to your response.

Phil

"Simon Hayes" <sql@hayes.ch> wrote in message
news:426fffdb_2@news
.bluewin.ch...
>
> "Phil" <Phil@nospam.com> wrote in message
> news:d4osus$gde$1@nw
rdmz01.dmz.ncs.ea.ibs-infra.bt.com...
>
> You don't mention which version of MSDE, but as of SP3 network access is
> disabled by default - see the DISABLENETWORKPROTOC
OLS switch in the readme
> file. In addition, the Windows XP SP2 firewall blocks any MSSQL services
> on the box from listening on the network. See these articles:
>
> http://support.microsoft.com/defaul...kb;en-us;841249
> http://support.microsoft.com/defaul...kb;en-us;814130
> http://support.microsoft.com/defaul...kb;en-us;328306
>
> Simon
>
>

Simon Hayes

2005-04-28, 3:24 am

You can use SVRNETCN.EXE to enable network protocols - it's the SQL
Server Network Utility, and as far as I know, it's installed with MSDE.

Simon

Sponsored Links