Hi,

I have a SQL Server that was earlier a part of the domain and had a domain
account for the MSSQLSERVER service and SQLSERVERAGENT service. Now it has
been taken of the domain and given a different name. The SQL Server service
refuses to start. I took out the domain account from the log on as screen of
the service and entered the sa credentials. However, it still fails to start.
What should be done to get it started? Thanks in advance.

What error messages are you getting in errorlog and/or eventlog?

Linchi

"ronnie" wrote:

> Hi,
>
> I have a SQL Server that was earlier a part of the domain and had a domain
> account for the MSSQLSERVER service and SQLSERVERAGENT service. Now it has
> been taken of the domain and given a different name. The SQL Server service
> refuses to start. I took out the domain account from the log on as screen of
> the service and entered the sa credentials. However, it still fails to start.
> What should be done to get it started? Thanks in advance.

The services (all of them) need a WINDOWS level account, not the 'sa'
account from within sql server.

--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net


"ronnie" <ronnie@discussions.microsoft.com> wrote in message
news:5B3F2E7C-A461-42F0-B122-925971AB2B70@microsoft.com...
> Hi,
>
> I have a SQL Server that was earlier a part of the domain and had a domain
> account for the MSSQLSERVER service and SQLSERVERAGENT service. Now it has
> been taken of the domain and given a different name. The SQL Server
> service
> refuses to start. I took out the domain account from the log on as screen
> of
> the service and entered the sa credentials. However, it still fails to
> start.
> What should be done to get it started? Thanks in advance.

Thanks for your responses. I was able to get it started. I had to create a
new windows account for running the SQLSERVER service that had local
administrator's privileges. Then when I tried to start the service I still
got an error. In the system error log I found this error -

Event:3095 Source: NETLOGON - This Windows NT computer is configured as a
member of a workgroup, not as a member of a domain. The Netlogon service does
not need to run in this configuration.

On researching the internet I found this resolution - configure Netlogon
service to start Manually and make sure that the workstation service is
running. Then restart.

Since both of these services were running I restarted the machine and the
SQL Server started.

"TheSQLGuru" wrote:

> The services (all of them) need a WINDOWS level account, not the 'sa'
> account from within sql server.
>
> --
> Kevin G. Boles
> Indicium Resources, Inc.
> SQL Server MVP
> kgboles a earthlink dt net
>
>
> "ronnie" <ronnie@discussions.microsoft.com> wrote in message
> news:5B3F2E7C-A461-42F0-B122-925971AB2B70@microsoft.com...
> > Hi,
> >
> > I have a SQL Server that was earlier a part of the domain and had a domain
> > account for the MSSQLSERVER service and SQLSERVERAGENT service. Now it has
> > been taken of the domain and given a different name. The SQL Server
> > service
> > refuses to start. I took out the domain account from the log on as screen
> > of
> > the service and entered the sa credentials. However, it still fails to
> > start.
> > What should be done to get it started? Thanks in advance.
>
>
>