Changing Domains??? 
Author Message
 Changing Domains???
Can a sqlserver7 b moved from one domain 2 another ?And if yes,then why is
sqlserver not able 2 start?

Is it because.SQL Server NT account is inaccessible or whether the
.Internal SQL server name is now different than the network name.??

(MCDBA questn)

TIA.,
Dinesh



Fri, 04 Apr 2003 03:00:00 GMT
 Changing Domains???

The MSSQLServer service and probably the SQLServerAgent service are both
setup to operate on the computer under the context of a specfic domain user.
If you changed the domain that the computer belongs to, it is possible that
1)  The domain\username that the  SQL services are set to login as are no
longer valid because the domain is gone
2)  The domain\username that the  SQL services are set to login as are no
longer valid because the appropriate trust relationship has not been
established.

You may be better off to just change the user that these services login as.


Quote:
> Can a sqlserver7 b moved from one domain 2 another ?And if yes,then why is
> sqlserver not able 2 start?

> Is it because.SQL Server NT account is inaccessible or whether the
> .Internal SQL server name is now different than the network name.??

> (MCDBA questn)

> TIA.,
> Dinesh



Fri, 04 Apr 2003 03:00:00 GMT
 Changing Domains???
If you didn't change the machine name of the server that SQL Server is
running on, it should be OK.  You will need to use a valid domain account on
the new domain for the SQL Server services to use.


Fri, 04 Apr 2003 03:00:00 GMT
 Changing Domains???

Thanks Mike and Bob !!

Dinesh



Sat, 05 Apr 2003 11:15:21 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Changing domains

2. Changed Domains and Now Errors (Help)

3. changing domains with SQL

4. SQL machine changing domains

5. changing domains

6. SQL7.0 - Changing domain

7. CHANGED DOMAIN

8. Changing domains

9. SQL Server Logins changing DOMAINS

10. SQL server 7 login failure after changing domain

11. Changing Domains

12. Change Domain = No Performance Monitor


 
Powered by phpBB® Forum Software