Hi,
I tried to Install MSDE (SQL Server free ed.) on XP Home Ed. It's running
but from other computer I could not connect to that database using sa
account. Unlike when installed on XP Professional which MSDE can perform
almost like SQLServer. Does it because XP Home Ed.?
Thanks,
Martin
hi Martin,
prof_martin wrote:
> Hi,
> I tried to Install MSDE (SQL Server free ed.) on XP Home Ed. It's
> running but from other computer I could not connect to that database
> using sa account. Unlike when installed on XP Professional which MSDE
> can perform almost like SQLServer. Does it because XP Home Ed.?
>
MSDE installs by default disabling network protocols for security reasons...
you can bypass this setting at install time, providing the
DISABLENETWORKPROTOCOLS=0
parameter to the setup.exe boostrap installer and/or later, at "run time",
running the Server Network Utility (svrnetcn.exe) and enabling the
desired/required protocol(s)...
additionally, WinXP sp2 installs and enables by default the Windows
Firewall, and you have handle and manage to allow incoming remote
connections, as reported in http://support.microsoft.com/kb/841249/en-us
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Ahaa Andrea,
So you are the one the author DBAMgr2K, I'm using it ver 0.7.0. Quite useful
some more it's free. Only thing about your powerful software when database
structure need to be amended some field for datatype, its prompt something so
I was not able to do it. Anyway nearly perfect for free level.
Just confirmed with you, we got 5 PC all XP Home, PC1 I installed
MSDE2K+DBAMgr2K, the rest of PC contain application which consume Data from
PC1. Is this by right should works? And Is this smart enough for low cost
infrastructure for SME?
We have plan to upgrade PC1 using XP Professional, if necessary.
I really appreciate your answer.
Thanks you,
Martin A.N. (from Singapore)
"Andrea Montanari" wrote:
> hi Martin,
> prof_martin wrote:
> MSDE installs by default disabling network protocols for security reasons...
> you can bypass this setting at install time, providing the
> DISABLENETWORKPROTOCOLS=0
> parameter to the setup.exe boostrap installer and/or later, at "run time",
> running the Server Network Utility (svrnetcn.exe) and enabling the
> desired/required protocol(s)...
> additionally, WinXP sp2 installs and enables by default the Windows
> Firewall, and you have handle and manage to allow incoming remote
> connections, as reported in http://support.microsoft.com/kb/841249/en-us
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||prof_martin wrote:
> Ahaa Andrea,
> So you are the one the author DBAMgr2K, I'm using it ver 0.7.0. Quite
> useful some more it's free. Only thing about your powerful software
> when database structure need to be amended some field for datatype,
> its prompt something so I was not able to do it. Anyway nearly
> perfect for free level.
thank you for your interest in this prj of mine, and please feel free to
(privately) contact me for any question or concern, as long as for
suggestions and feedback...
> Just confirmed with you, we got 5 PC all XP Home, PC1 I installed
> MSDE2K+DBAMgr2K, the rest of PC contain application which consume
> Data from PC1. Is this by right should works? And Is this smart
> enough for low cost infrastructure for SME?
> We have plan to upgrade PC1 using XP Professional, if necessary.
> I really appreciate your answer.
it is ok on the client level... but I'd go for XP pro on the server for the
advanced net facilities it provides on XP home...
my $0.02
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||hi,
i installed msde in windows 2000 prof. its installed succes fully but i dont
know how to run it.becase there is no indication for installation
completion.a folder which i gave in seup file was created and some folders
like binn,data, were created . but there is no tool to run the msde.
do i have to down load any thing more.
i down loaded msde 2000 release A.
thanks
vinoth
|||hi,
vinoth wrote:
> hi,
> i installed msde in windows 2000 prof. its installed succes fully but
> i dont know how to run it.becase there is no indication for
> installation completion.a folder which i gave in seup file was
> created and some folders like binn,data, were created . but there is
> no tool to run the msde.
> do i have to down load any thing more.
> i down loaded msde 2000 release A.
> thanks
> vinoth
you are correct, the installer terminates it's work without any prompt.. if
you provided the
/L*v "c:\MsdeLog.txt"
additional parameter to the setup.exe boostrap installer you can inspect it
at it's end to verify MSDE has been succesfully installed...
you won't see anything in the tray area (the SQL Server Service Manager
icon) i f you do not restart your system, as all this requires a reboot to
register SQL Server services..
but you can connect to it using the only (command line) tool MSDE is
provided with, oSql.exe as reported in
http://support.microsoft.com/default...;EN-US;q325003
again... MSDE is not provided with graphical tools, but you can have a look
at a free prj of mine at the link followind my sign, which provides a user
interface similar to Enterprise Manager... further tools, bot commercial and
free are listed in http://www.microsoft.com/sql/msde/partners and/or
http://www.aspfaq.com/show.asp?id=2442
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment