Moving a workgroup SQL Server to AD problem

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.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Moving a workgroup SQL Server to AD problem

Author

Topic

WiZCoke
Starting Member

2 Posts

Posted - 2009-04-22 : 04:51:33

Just added Active Directory to one of my development servers and thus implementing a domain for the first time in this network.
Then I added the SQL Server to that domain in its System/Computer Name config. So far so good.

The problem was now that the Webserver couldnt connect to the SQL Server anymore since its ODBC configuration didnt work now, having AD...

Reading some on Books Online I found that I should register the SQL Server in AD with the following Stored Procedure query:

DECLARE @RetCode INT
EXEC @RetCode = sp_ActiveDirectory_SCP @Action = N'create'
PRINT 'Return code = ' + CAST(@RetCode AS VARCHAR)

However, running that I receive the following error:
Msg 14359, Level 16, State 1, Procedure sp_ActiveDirectory_SCP, Line 170
Active Directory directory service is not enabled on the network, or it is not supported by the operating system.
Return code = 1

What have I missed?
Where should I go from here? Since this is a development environment I can reinstall the SQL Server if that is needed.

darkdusky
Aged Yak Warrior

591 Posts

Posted - 2009-04-22 : 10:39:57

Love to help but I'm afraid Peso might not let me edit my answer

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=123127

WiZCoke
Starting Member

2 Posts

Posted - 2009-04-22 : 11:03:19

I got a step further now by removing and reinstalling Active Directory this time with DNS pointed to the Domain Controller and when the SQL Server was moved to the new domain it picked up AD. Now I could create a New Login with an AD account (this wasnt possible earlier today). This solved the ODBC issue.

Next problem is I am installing Site Server Express 2008 but it tells me my SQL Server 2005 isnt of a recent enough version. Guess I have to update it with latest Service Pack. Just hope this is possible using an MSDN license as I am.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources