Connection problem after installing msde2000a

Hi everyone,
I just installed on my windows 2000 computer using the following command
line with a strong sa password:
c:> setup sapwd="my_password". I want to create a new access database
project (.adp) but after I input the credentials for sa and user, I get a
message saying that SQL Server doesn't exist or access denied. I specified
the name of the computer in the server name dropdown during one try and it
failed. Then I specified (local) in the same dropdown and it failed again.
1- Can somebody give me a clue about what Happenned?
2- Can somebody provide me with a URL where I can download msde2000 NOT
msde2000a (which is nightmare to configure)? When I installed msde2000 I
didn't have all those problems.
Thanks
hi,
Zadi Friedrich wrote:
> Hi everyone,
> I just installed on my windows 2000 computer using the following
> command line with a strong sa password:
> c:> setup sapwd="my_password". I want to create a new access database
> project (.adp) but after I input the credentials for sa and user, I
> get a message saying that SQL Server doesn't exist or access denied.
> I specified the name of the computer in the server name dropdown
> during one try and it failed. Then I specified (local) in the same
> dropdown and it failed again. 1- Can somebody give me a clue about
> what Happenned? 2- Can somebody provide me with a URL where I can
> download msde2000 NOT msde2000a (which is nightmare to configure)?
> When I installed msde2000 I didn't have all those problems.
> Thanks
MSDE installs by default disabling standard SQL Server connections and only
allowing trusted WinNT connections...
you can modify this behavior both at install time, providing the
SECURITYMODE=SQL
parameter to the setup.exe boostrap installer, or later, at run time,
"hacking" the Windows registry as described in
http://support.microsoft.com/default...b;en-us;285097
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3k76mdFt0vekU1@.individual.net...
> hi,
> Zadi Friedrich wrote:
> MSDE installs by default disabling standard SQL Server connections and
> only allowing trusted WinNT connections...
> you can modify this behavior both at install time, providing the
> SECURITYMODE=SQL
> parameter to the setup.exe boostrap installer, or later, at run time,
> "hacking" the Windows registry as described in
> http://support.microsoft.com/default...b;en-us;285097
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
you can also change that by going to the service right-click on SQL server
instance then go properties.
under the security tab you will be able to change for SQL Server and
Windows.
then stop the service, restart it and enjoy !.>