Dear ALL,
I have a Web site hosted with a provider since 4 years (www.imposition.com).
We are now moving everything to GoDaddy.
I copied all files to GoDaddy, in the SAME directories and sub-directories;
I backed up the database and used Database Puslishing Wizard to move the database to GoDaddy.
During the publishing, I keep getting 1 error, as follows:
TITLE: SqlPubWiz
------------------------------
An error occured while trying to publish the following script:
/****** Object: Table [dbo].[PortalDesktopModules] Script Date: 03/08/2011 15:20:45 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PortalDesktopModules]') AND type in (N'U'))
DROP TABLE [dbo].[PortalDesktopModules]
------------------------------
ADDITIONAL INFORMATION:
Could not drop object 'dbo.PortalDesktopModules' because it is referenced by a FOREIGN KEY constraint. (System.Web.Services)
How can I resolve this error? Is it important at all?
Also, it seems my web.config has issues because I also get the following error when I try to access the website on a new location (temporary) (www.impositionforum.com):
DotNetNuke Error: - Version 04.05.01
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Thanks in advance for your help!!
Ray