Thanks a lot, I read those articles but I can't use their methods. Let me
explain my senario:
------------------------------------
Local System:
- Win XP SP2
- MS SQL Server 2005 Express
- Firewall: Norton Internet Security 2007
- DotNetNuke 4.5.5 (Installed using Install Package)
------------------------------------
Remote Host:
- My remote host lets me create a single SQL Server 2000 databse, define its name, data source name, and one user and password to access the database. It
gives me the IP address to a shared database server where I can browse by my MS SQL Server Management Studio Express.
------------------------------------
- Problem 1:
Back up/Restore method: I backed up my dotnetnuke local datatbase to a file to upload to my remote host. But when I try to restore the remote database,
the browse window shows me the local file system of the remote system! I can't browse my own local files to select and restore my dotnetnuke datatbase.
Failed!
Detach/Attach method: When I try to attach my own database on the remote host using SQL SMSE, I get the following error:
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Detach database failed for Server 'xxx.xxx.xxx.xxx'.
(Microsoft.SqlServer.Express.Smo)
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
EXECUTE permission denied on object 'sp_detach_db', database 'master',
owner 'dbo'. (Microsoft SQL Server, Error: 229)
Failed Too.
Problem 2:
I found this page:
http://weblogs.asp.net/scottgu/archive/2006/12/22/recipe-deploying-a-sql-database-to-a-remote-hosting-environment-part-1.aspx
and downloaded the cool tool (MS SQL Server Publishing Wizard) that supposed to work as described in that page. But when I try to connect to my localhost to choose the source database using it, I get the following error:
TITLE: Database Publishing Wizard
------------------------------
Failed to connect to server localhost. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
(provider: Named Pipes Provider, error: 40 - Could not open a connection to
SQL Server) (Microsoft SQL Server, Error: 2)
So I went to SQL Server Surface Area Configuration and under the "Surface Area Configuration for Services and Connections" I enabled Local and remote connections using both TCP/IP and named pipes. I also disabled my Norton Internet Security firewall, but got the same last error! :(
Failed.
Sorry for the long post,
What should and can I do?
TIA.