.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Moving SharePoint Database to non trusted domain SQL server

Posted By:      Posted Date: September 28, 2010    Points: 0   Category :SharePoint


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?


View Complete Post

More Related Resource Links

moving sharepoint server 2007 to another domain


We are moving from our company location to another location with different network and different domain.at the first location we are using sharepoint server 2007 on windows server 2003

at the location that we are moving to,we are trying to install sharepoint server 2007 on windows server 2008,so I installed sherepoint server 2007,opened the site ,it got opened with me,took restore from the old company location,tried to restore it on the new location got error hresult ox80040e05,also when i tried to open the site ,i got error accesss denied

does moving sharepoint to different domain not on same network require more steps

Moving SharePoint 2007 from Domain to a Workgroup


For development purposes, we have SharePoint 2007 installed on a virtual server (Wind 2003) on a company desktop (Vista Business ed.).  The SharePoint is using Active Directory and company domain. For learning purposes, we want to copy the virtual machine on another Vista machine that is outside the domain and is not using AD:

Question 1 : How can we move the SharePoint from a domain to a Workgroup
Question 2: Is it possible to still be able to use emails (through local installation of Outlook) on the same computer that is not on the domain? If, yes, what are the possibilities (any articles on it? Etc.)?


SharePoint 2010 Server: Cannot manage all user profiles from upgraded MOSS SSP database

I have upgraded an SSP database to SharePoint 2010 and successfully performed User Profile Synchronization with Active Directory, however I cannot manage ALL of the user profiles in the database. I go to "Manage User Profiles" in Central Administration and perform a filtered search (i.e. I want all DOMAIN accounts beginning with "j" so I search for "DOMAIN\j" in Manage User Profiles), but I don't receive ALL the user profiles back. I receive about 8 in return when I know there are about 20 starting with "j". If I create a new AD account beginning with "j" it is successfully synched with SharePoint 2010 and I see it in the Manage User Profiles. I ran an stsadm -o sync to clear any old synchronization information, and the Forefront Synchronization Service appeared to pull in many changes to existing accounts (including ones I can't currently manage), but I still cannot manage them using "Manage User Profiles". I really need to be able to manage all the profiles so I can manually edit some fields. Can anyone please help? Thanks in advance.

Moving sharepoint database from one drive to other

I am having the sharepoint installed on c drive which doesn't have much space. Is it possible to move the content database to some other drive on the machine. If yes, then what is the procedure and do i have to make changes anywhere related to these changes? Also is there any possibility of something going wrong somewhere during this process? thanks in advance!

Same server farm administrator domain account for both Intranet and Internet Sharepoint site?

Hello,   We are planning to setup 2 streams of architecture for both Intranet and Internet web sites. Just wondering whether there is any best practices/security concerns if we are using the same domain account as the Server Farm Administrator for both Intranet and Internet platform?   Thanks,

Sharepoint 2010 Web Server/Domain Controller ratio

Is this number the same 3:1 as it was in with Sharepoint 2007?

Moving Sharepoint 2010 Database

I'm planning on moving our sharepoint (2010) database from one server to another (SQL 2008), however the MSDN method recommends we setup a SQL alias on the sharepoint server and use the detach/attach method. Surely there is a better method to change the database server name instead of creating an alias on the sharepoint box?  

SharePoint 3.0 stop logging after moving database

Hello! Our SP 3.0 logging and Usage Analysis Processing were used to working ok. After we moved database to another server for disk space reason, there is no new log file generated from the date of db moving. The logging settings and Usage Analysis setting are still the same. We tried disable / re-enable logging, it didn't help. From system log, I saw following errors, and then granted the service account all access to "IIS WAMREG admin Service" DCOM Config based on document found in MSDN. It still not help "The application-specific permission settings do not grant Local Activation permission for the COM Server application ..." Could someone please share info/knowledge on similar issue and solutions? I really appreciate it! Thank you in advance! John

Best practices on moving SharePoint databases physically, while keeping them on the same SQL server?

I'd need to move the SharePoint 2010 databases (preferably all of them) with as little hassle as possibly from one partition to another. I tried once, and ended up with a broken SharePoint and had to recover from backups. What's the best practices for moving the databases without breaking SharePoint completely in the process? I'm guessing I need to shut down the SharePoint server for this... That's not impossible if needed.

Monitoring and moving SharePoint foundation 2010 database on SBS 2008


I have successfully followed the white paper for upgrading SharePoint Services 3.0 to SharePoint Foundation 2010. Other than an authentication link problem all went smoothly.

I do have two small problems. The Small Business Server console reports that SharePoint is not functioning (it is functioning as I can connect to the site), this is more a nussance as my daily reports are inaccurate and I hope if this is normal there is or will be a hotfix to repair the reporting. This also comes to the second more serious problem.

In upgrading the process moved the database from it's own drive back to the system drive. I should have payed more attention to the directories in the upgrade process. Live and learn. Since the reporting is wrong in the console the move database wizard also does not work. Knowing that SBS gets cranky when things aren't done with a wizard or in a super specific order, is there a proper way to move the database? I am beging to get the long list of warnings as the drive fills up.

Any help would be appreciated. Thank you.



Moving a larger Sharepoint 2007 site collection over to a new server



We have a Sharepoint 2007 site collection roughly 36 GB in size and have been having problems moving the site to a new server farm (Also 2007). We are trying the Sharepoint backup and restore method, but I understand that this method is not recommended for sites over 5GB. Has anyone moved a site of this size and how did you do it?

Thanks  Ron


Any negative impact to Sharepoint and Project Server if IP for backend database server is changed.


If IP address of the backend database server will be changed for sharepoint 2007 and project server 2007, will it impact any way  both the servers.

Relocate Sharepoint 3.0 database from SBS2008 to a different server

The SBS2008 server got Sharepoint3 and SQL2005 pre-installed. Is it possible to move the sharepoint database to a different server? The reason for that is mainly due to storage capacity.

unable to save data in SQL Server database through Sharepoint 2007


Hi All,

I have created dummy database, Table in SQL Server 2005 with some values.
Iam able to pull data from the SQL database to sharepoint dataview webpart through data connection using sharepoint desigher.

Now i have to enter new record in to SQL table through sharepoint. i have checked with sharepoint designer but unable get it done.

Can some one have idea on this. Please help me to get it done

Thanks in Advance.

Moving Sharepoint 2007 from Virtual Server 2005 to Hyper-V


I'm a little unsure of the exact sequence to move my Sharepoint 2007 Virtual server from VS2005 to Hyper-V.  In my enviroment, my sharepoint machine and SQL machine are on 2 different boxes.  SQL 2005 is on Hyper-V and Sharepoint is on Virtual Server 2005.  Do I shutdown the SQL VM before I move Sharepoint???   Will the new VM and SQL sync back up without any help??

Also, what happens to the SQL database if the new Sharepoint VM (on Hyper-V) has issues or problems??  Does that make my SQL server

out of sync with my old Sharepoint VM???  I have done multiple moves between VS2005 and Hyper-V so I really familiar with the process.

I usually keep the old VM around for a while after moving just in case there is a problem.   I can always blow away the new VM and crank up the old.   Viola!  I'm back to square one.

Any ideas??



Moving Reporting Service database to a new server.


I have a reportserver database on a 2005 instance.  I've moved it and reportservertempdb to a 2008 server.  In the config tool > Database > Change Database,  I'm getting

"The database you have selected is not a report server database.  Please select a SQL Server database that contains report server specific tables and stored procedures and try again."

I have done exactly what is noted in this thread:  http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/f8be967e-2126-4b1d-bcbe-9903d5c6b66a

Thanks for any help.



Unable to connect to the SQL content database from sharepoint web front server.



SharePoint farm is as below. 1 SQL, 1 WFE, 1 Application server. SQL 2005 and SharePoint 2007 with SP1.

SharePoint portal is working fine from 1 year, suddenly from today morning in the WFE eventvwr we are getting 27745, 3355 and 5586 event id errors. Site also giving error saying "unable to connect the content database". This is repeating for 10 to 15 min.

when ever these errors occur in eventvwr sharepoint will not work.

Please suggest on this issue.

waiting for MS replies..






ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend