Hi All,
How can I tell what account SQL Agent configured to start up with? Local or domain?In Enterprise Mangler, right click on the SQL Server Agent and select Properties. If you can't connect to the server, look at the Service in Windows services, and click the "Log On" tab to see the login information.
-PatP|||I looked in Enterprise Manager and the radio button next to System Account is selected. Is it local or domain?|||Local. If it were a domain administrator, the domain name would be a prefix such as MyDomain\Administrator in the box.
-PatP|||Thank you.
Showing posts with label configured. Show all posts
Showing posts with label configured. Show all posts
Thursday, February 16, 2012
Builtin\Administrator login
BUILTIN/ADMINISTRATORS
Hi all
If sql server2005(yucon) is configured to windows authentication only and
builin/administrators group is removed manually, how to connect to sql serve
r.
No other user account is available.
--
Thanks in Advance
Regards
SuparichituduIn the registry under HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQ
LServer
change loginmode to 2. This enables mixed mode (after SQL Server
restarts) and you can log on with sa (if you know the password).
Markus
If sql server2005(yucon) is configured to windows authentication only and
builin/administrators group is removed manually, how to connect to sql serve
r.
No other user account is available.
--
Thanks in Advance
Regards
SuparichituduIn the registry under HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQ
LServer
change loginmode to 2. This enables mixed mode (after SQL Server
restarts) and you can log on with sa (if you know the password).
Markus
Labels:
administrators,
allif,
andbuilin,
authentication,
builtin,
configured,
connect,
database,
group,
manually,
microsoft,
mysql,
oracle,
server,
server2005,
sql,
windows,
yucon
Subscribe to:
Posts (Atom)