Wednesday, March 21, 2012

MSDE OSQL Utility

Dear all,
I have a question about the OSQL utility and the installation of MSDE. I
tried to install MSDE and SQL Server on the same machine. This should work
some people told me. As a result however my application is no longer showing
me the available servers on the machine. (laptop).
I removed everything and reinstalled only MSDE.
When I use the OSQL utility and enter OSQL -L it says there are no servers.
Should it not say which server is available.
Has anyone experienced this before. My system is no longer showing the
available servers. My application still seems to work because when I type in
the name of the server manually it is located.
How can I solve this problem.
regards,
Danny Gaethofs
hi Danny,
"Danny Gaethofs" <dangaet@.home.nl> ha scritto nel messaggio
news:uAGDu0P4EHA.2404@.TK2MSFTNGP14.phx.gbl
> Dear all,
> I have a question about the OSQL utility and the installation of
> MSDE. I tried to install MSDE and SQL Server on the same machine.
> This should work some people told me. As a result however my
> application is no longer showing me the available servers on the
> machine. (laptop).
> I removed everything and reinstalled only MSDE.
> When I use the OSQL utility and enter OSQL -L it says there are no
> servers. Should it not say which server is available.
> Has anyone experienced this before. My system is no longer showing the
> available servers. My application still seems to work because when I
> type in the name of the server manually it is located.
> How can I solve this problem.
> regards,
> Danny Gaethofs
MSDE installs by default disabling network protocols in order to minimize
external (malicious) attacks, preventing the installed instances to be
available for remote connections and disabling it's broadcast enlisting for
available SQL Server/MSDE instances...
to make it available for remote users and to enable server enlistment you
have to use Server Network Utility (svrnetcn.exe) and enable the
desired/preferred network protocol(s)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

No comments:

Post a Comment