MSDE from Hoster installed

Hello
my DEd win 2003 server, uses MSDE
all is ok, the server run, and can create from script Db
but if i want login or create connection MSDE say wrong pass
i never change the pass or other
i have the server complet reinstalled from hoster image
what i doing wrong ?
hi,
MS News wrote:
> Hello
> my DEd win 2003 server, uses MSDE
> all is ok, the server run, and can create from script Db
> but if i want login or create connection MSDE say wrong pass
> i never change the pass or other
> i have the server complet reinstalled from hoster image
> what i doing wrong ?
assuming you are trying to connect using the standard SQL Server
authentication with the "sa" login and you can't remember it's pasword, you
can login using integrated security (the Windows authentication) using a
local admin member and set the "sa" password to whatever you want via the
system stored procedure sp_password,
http://msdn.microsoft.com/library/de...a-pz_5x44.asp,
in the form
EXEC sp_password @.new = 'whatever', @.loginame = 'sa'
as all local admins members are automatically members of the
BUILTIN\Administrators login group in MSDE too, with sysadmins privileges...
connect via oSql.exe providing the -E parameter to specify integrated
security..
c:\..\>osql.exe -E -S(local)\InstanceName
1>EXEC sp_password @.new = 'whatever', @.loginame = 'sa'
2>GO
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
|||hey thats realy works !
thanks!
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> schrieb im Newsbeitrag
news:3s11vbFlebp5U1@.individual.net...
> hi,
> MS News wrote:
> assuming you are trying to connect using the standard SQL Server
> authentication with the "sa" login and you can't remember it's pasword,
> you can login using integrated security (the Windows authentication) using
> a local admin member and set the "sa" password to whatever you want via
> the system stored procedure sp_password,
> http://msdn.microsoft.com/library/de...a-pz_5x44.asp,
> in the form
> EXEC sp_password @.new = 'whatever', @.loginame = 'sa'
> as all local admins members are automatically members of the
> BUILTIN\Administrators login group in MSDE too, with sysadmins
> privileges...
> connect via oSql.exe providing the -E parameter to specify integrated
> security..
> c:\..\>osql.exe -E -S(local)\InstanceName
> 1>EXEC sp_password @.new = 'whatever', @.loginame = 'sa'
> 2>GO
> --
> 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
>