Find out what account the MSSQL Service is running under?

  • How can I find out which account MSSQL service is running under?

  • At the server running MSSQL go to Control Panel->Admin Tools-> Services. Find MSSQL (and any related SQL services running on the server, if needed) and double click the service. Go to Log On information. My assumption is Windows 2000 so it may be a little different navigation under 2003, not sure. HTH.

    -- You can't be late until you show up.

  • This is also in Enterprise Manager, under the properties for the server. Check the security tab and you should use this tab to change the account if needed. That way the permissions will be correct.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply