Installing MSDE2000 for Remote Connection

[Phil]

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]

"Phil" <Ph**@nospam.com> wrote in message
news:d4**********@nwrdmz01.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:-

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

You don't mention which version of MSDE, but as of SP3 network access is
disabled by default - see the DISABLENETWORKPROTOCOLS 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/default...b;en-us;841249
http://support.microsoft.com/default...b;en-us;814130
http://support.microsoft.com/default...b;en-us;328306

Simon

[Phil]

Thanks Simon,

As usual a swift and informative response. It is/was SP3 and I did not
include the DISABLENETWORKPROTOCOLS 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" <sq*@hayes.ch> wrote in message
news:42********@news.bluewin.ch...

"Phil" <Ph**@nospam.com> wrote in message
news:d4**********@nwrdmz01.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:-

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

You don't mention which version of MSDE, but as of SP3 network access is
disabled by default - see the DISABLENETWORKPROTOCOLS 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/default...b;en-us;841249
http://support.microsoft.com/default...b;en-us;814130
http://support.microsoft.com/default...b;en-us;328306

Simon

[Simon Hayes]

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