Re: SQL Server login problem

From: Jasper Smith (jasper_smith9@hotmail.com)
Date: 12/27/02 

From: "Jasper Smith" <jasper_smith9@hotmail.com>
Date: Fri, 27 Dec 2002 11:52:14 -0000

Assuming you did not remove the BUILTIN\Administrators
login from SQL Server then use the Control Panel>Services
applet to change the startup account for the SQL Service to
Local System. This should allow you to start the service. Now
open Enterprise Manager locally on the server and use it to
set the startup account to the new domain account you have
created. This will give this account the permissions required
to run SQL Server. You can do the same for the SQL Agent.
It might be worth adding the account to the local administrators
group on the server (although this is not strictly necessary and
not really best practice from a security standpoint) just to rule
out permissions errors whilst solving this problem. 

-- 
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Anders Windelhed" <anders@windelhed.com> wrote in message
news:pqWO9.1785$T41.1960@amstwist00...
> Hello! I have a big problem with my SQL server. I had to remove the domain
> from my server (same machine that was running the SQL server) and after I
> had done so I remembered that I used windows authentication when starting
> the SQL server. The only user that had access to the server is now
> deleted... I have created a new domain with the same name in hope that it
> would allow me to start the database again but that did not help.
>
> The error message I receive is:
> "An error 1069 - (The service did not start due to a logon failure)
occurred
> while performing this service operation on the MSSQLServer service."
>
> Is there a way to start the service and access the data again or do I have
> to reinstall the server again?
>
> Best regards
>
> Anders
>
>

Relevant Pages

  • Re: xp_cmdshell issue, local system
    ... SQL Server MVP ... > you change startup account ... >> Server and SQL Agent service accounts. ...
    (microsoft.public.sqlserver.security)
  • Re: xp_cmdshell issue, local system
    ... > How is that it worked for one (sql server startup account) but not for ... Server and SQL Agent service accounts. ... SQL Server MVP ... Now when I go and try the same for the agent startup account it ...
    (microsoft.public.sqlserver.security)
  • Re: Error 15401 using sp_grantlogin (not addressed by current KB articles)
    ... Restarting Windows 2000 resolved the problem for this particular account, ... confused when it sees a duplicate SID. ... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ...
    (microsoft.public.sqlserver.security)
  • Re: SharePoint V3 Install Error
    ... But it our case it had to do with Group Policies that forbid the account of ... WSS FAQ:www.wssv3faq.com/wss.collutions.com ... Event Source: WindowsSharePointServices3Search ... whatever you are installing WSS as sufficient rights to the SQL Server ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Problems with WebParts
    ... to a database called aspnetdb. ... > The connection string specifies a local SQL Server Express instance using a ... > server account must have read and write access to the applications directory. ... > This is necessary because the web server account will automatically create ...
    (microsoft.public.dotnet.framework.aspnet)