Moving SharePoint Database to non trusted domain SQL server
Hi, We have SharePoint and SQL server in a extranet domain. We would like move the SQL server databases for SharePoint to our corporate SQL server (on the corporate domain). The Corporate domain does not trust the extranet domain, and thus the web farm account cannnot be specified on the corportare SQL instance. If it possible to migrate the databases to a non tusted domain? I've seen the script to create a new Config database using SQL authentication psconfig -cmd configdb -create -server <SQL server name> -database <database name> -dbuser <SQL account> -dbpassword <SQL password> -user <AD user account> -password <AD user password> Can I edit the config of SharePoint to point to the new SQL server, or do I need to create the entire sharepoint enviromnent again and attach the content databases? I also have a SSP database that's heavily customised for searcvhing and the BDC. Will this need recreating again or can I move the BDC database to the new server and attach? Thanks,
September 28th, 2010 5:19pm

You should be able to connect to an existing db using psconfig. Take a look at the comman ref. http://technet.microsoft.com/en-us/library/cc263093%28office.12%29.aspx So instead of your line above with configdb -create, you would move the db then use configdb -connect. I'm not sure about the ssp db.
Free Windows Admin Tool Kit Click here and download it now
September 28th, 2010 9:43pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics