469,927 Members | 1,654 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,927 developers. It's quick & easy.

Installing MSDE2000 for Remote Connection

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
Jul 23 '05 #1
3 4842

"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
Jul 23 '05 #2
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

Jul 23 '05 #3
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

Jul 23 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Dave | last post: by
5 posts views Thread by McGeeky | last post: by
reply views Thread by laridae | last post: by
5 posts views Thread by Mitya Mitriev | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.