MSDE Install Question

I installed MSDE using Windows authentication and gave the SA logon ID a
"strong" password. However, when I attempt to logon to the MSDE database
(via OSQL) I get a message stating something to the effect of "the logon ID
is not associated with a trusted account". I realize what this means (i.e.
the logon ID "sa" is not a Windows account). However, what I'm wondering is
how do I logon to a brand new (MSDE) server once it's been installed to use
Windows authentication if I haven't setup any accounts/roles yet?
-- Thanks, Jeff
hi Jeff,
Jeff B. wrote:
> I installed MSDE using Windows authentication and gave the SA logon
> ID a "strong" password. However, when I attempt to logon to the MSDE
> database (via OSQL) I get a message stating something to the effect
> of "the logon ID is not associated with a trusted account". I
> realize what this means (i.e. the logon ID "sa" is not a Windows
> account). However, what I'm wondering is how do I logon to a brand
> new (MSDE) server once it's been installed to use Windows
> authentication if I haven't setup any accounts/roles yet?
> -- Thanks, Jeff
by default, the Windows administrators group will be mapped to the SQL
Server BUILTIN\Administrators WinNT group, so you can log in as a Windows
admin..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply