Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rswift
Starting Member
3 Posts |
 Posted - 2011-05-10 : 17:32:05
|
| We have a 2003 server that was in a domain that has been closed down.2 of the offices remain and have a domain controller in a different domain. They want me to save the server as a member server to access the old data. I have done a good bit of research and tried to remove the sql from the Active Directory before I do a dcpromo to remove it and I get an error: error 2812 could not find stored procedure 'master.dbo.xp_cmdshell'. Has anyone got any idea how to work around this, or a better process to get the task done?Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
rswift
Starting Member
3 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
rswift
Starting Member
3 Posts |
Posted - 2011-05-11 : 13:35:36
|
In SQL Server Enterprise Manager>console root>Microsoft SQL Servers>SQL Servers Group>name of Server>properties>active Directory.Hey the instance has been removed from AD after a reboot I guess. After the error I thought it did not go through.Anyway is there any better way to remove this server from the domain than DCpromo, so as not to upset SQL or it's working condition?Rswift quote:
Originally posted by tkizer
What tool are you using to do this? I'm so confused as I don't see anything like this in the SQL Server properties of the SQL tools. Are you talking about an Active Directory tool? Why would it need xp_cmdshell? That is so bizarre.You likely have xp_cmdshell disabled and will need to enable it to get past the error: http://weblogs.sqlteam.com/tarad/archive/2006/09/14/12103.aspxTara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
|
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Removing AD from 2003SBS server with 2005SQL