sql server msde: Hello there,
got my Windows 2003 SBS installed with its "native" MSDE. There I see
two different instances: SBSMonitoring and another one which is related
to an other software app. Now I have to install a third software which
has to rely on an MSDE or SQL database. As I already have MSDE, I
thought to connect to it and let the installer create its database in
it. The problem is, with the account "sa" without password (blank) I
can't get connected to SERVERNAME, although I get connected to
SERVERNAME\SBSMonitoring ... what's wrong? Where am I failing?

Thanks...

hi,
[quoted text, click to view]
MSDE installs by default dsabling standard SQL Server authenticated
connections.. this can be corrected both at install time and later, "at
runtime" as described in
http://support.microsoft.com/default.aspx?scid=kb;en-us;285097

as regard the "sa" problem.. you mean the sa login you are trying to use has
a blank password and you can not get connected?
what is the exception you are reported with?
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
--------- remove DMO to reply

multipost answered in microsoft.public.it.sql

regards
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
--------- remove DMO to reply