|
Home > Archive > MS SQL Server > August 2005 > Lost connection to MSSQL 2000, please help me !!!
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Lost connection to MSSQL 2000, please help me !!!
|
|
| Djangar S. 2005-08-08, 9:23 am |
|
Explanation:
After attaching MSSQL 2000 SP3 server into domain,
Local Admin and SA cannot login into MSSQL
EM and QA are not working.
"Change the MSSQLServer service account to be a domain account. Make this domain account a member of the
Local Administrators group on the machine." - Tried, but no chance.
| |
| Sue Hoegemeier 2005-08-09, 3:23 am |
| What are the errors?
-Sue
On Mon, 8 Aug 2005 09:50:41 -0400, "Djangar S."
<snapplefor@hotmail.com> wrote:
>
>
>Explanation:
>
>After attaching MSSQL 2000 SP3 server into domain,
>
>Local Admin and SA cannot login into MSSQL
>
>EM and QA are not working.
>
>
>
>
>
>"Change the MSSQLServer service account to be a domain account. Make this domain account a member of the
>
>Local Administrators group on the machine." - Tried, but no chance.
>
>
>
>
>
| |
| frankm 2005-08-09, 11:23 am |
| Check to see if Group Policies were pushed down to the server after being added to the domain.
If so - you will need the Domain or Enterprise admin, more than likely create an OU in AD for service accounts. Or at the least apply these policies to the service account. Even if you try to set these localy - you may not be able to or they can be overwritten by a global push from Active Directory.
a.. Policies
a.. Act as Part of the Operating System
b.. Bypass Traverse Checking
c.. Lock Pages In Memory (usually done on install, by the install)(AWE thing)
d.. Log on as a Batch Job
e.. Log on as a Service
f.. Replace a Process Level Token
"Djangar S." <snapplefor@hotmail.com> wrote in message news:%233h5jACnFHA.1948@TK2MSFTNGP12.phx.gbl...
Explanation:
After attaching MSSQL 2000 SP3 server into domain,
Local Admin and SA cannot login into MSSQL
EM and QA are not working.
"Change the MSSQLServer service account to be a domain account. Make this domain account a member of the
Local Administrators group on the machine." - Tried, but no chance.
|
|
|
|
|