Getting started with Dot Net Nuke

[LoopyLoo75]

I have a dot net nuke website on my local machine, and I need to upload it to make it go live, I have tried simply ftp'ing my folder up to the server, with no success.

I am new to the whole web publishing think, and would like some advice on how to get my site uploaded. I have setup a portal alias for my domain.

Many thanks in advance of your help

Donna

[Rock]

Originally Posted by LoopyLoo75

I have a dot net nuke website on my local machine, and I need to upload it to make it go live, I have tried simply ftp'ing my folder up to the server, with no success.

I am new to the whole web publishing think, and would like some advice on how to get my site uploaded. I have setup a portal alias for my domain.

Many thanks in advance of your help

Donna

Hi Donna,

If you can provide us with the version of DNN you've installed on your local machine & the backup of your MSSQL database, we can have a new instance of the portal installed on your site & the database restored on the server & make it to work within no time.

[LoopyLoo75]

where would i find an email address to send you my database.

cheers
Donna

[Rock]

Originally Posted by LoopyLoo75

where would i find an email address to send you my database.

cheers
Donna

You can upload the database backup in your webspace. We'll have it restored directly on the server..

[LoopyLoo75]

Okay my database is in the wwwroot folder of my webspace, and my domain is pinkandbluetoys.co.uk

The version of DNN i was using was 5.0.0, but I wasnt using anything fancy, so I am sure it will be backwards compatible from what I have read.

Do you need any more information from me?

Many thanks for your speedy co-operation.

Donna

[Rock]

Originally Posted by LoopyLoo75

Okay my database is in the wwwroot folder of my webspace, and my domain is pinkandbluetoys.co.uk

The version of DNN i was using was 5.0.0, but I wasnt using anything fancy, so I am sure it will be backwards compatible from what I have read.

Do you need any more information from me?

Many thanks for your speedy co-operation.

Donna

Hi Donna,

What you've provided is an 'SQL Server 2005/2008 (Express) File' & not a database backup. The file appears to be an empty database file. Please refer this link for more info on : How to backup an MSSQL Server 2005 Database

Anyways, I've installed the latest version of DNN [05.01.04 (3)] on your site [ http://www.pinkandbluetoys.co.uk ] & have sent the host/admin details on your registered email address.

Please let us know if you need any further assistance on this..

[LoopyLoo75]

Thanks for your help so far.... I will have a go with your instructions.
Cheers
Donna

[Rock]

Originally Posted by LoopyLoo75

Thanks for your help so far.... I will have a go with your instructions.
Cheers
Donna

You're welcome

[LoopyLoo75]

I have successfully backed up my database, and have uploaded into the APP_DATA directory on the server. I have logged on to control panel and gone to restore the database, from the host file space. However when I do that I get the following error, can you please help.

Page URL: http: //213.175.208.10:9001/Default.aspx?pid=SpaceMsSql2005&mid=59&ctl=restore &ItemID=13993&SpaceID=1221
Logged User: pinkandb
Work on Behalf: pinkandb
Hosting Space: 1221
Stack Trace: System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Exception: Error executing 'RESTORE' task on 'pinkandbdnndb' SQL_DATABASE ---> System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> The media family on device 'C:\WINDOWS\TEMP\pinkandbdnndb.bak' is incorrectly formed. SQL Server cannot process this media family.
RESTORE FILELIST is terminating abnormally.
at System.Web.Services.Protocols.SoapHttpClientProtoc ol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtoc ol.Invoke(String methodName, Object[] parameters)
at DotNetPanel.Providers.Database.DatabaseServer.Rest oreDatabase(String databaseName, String[] fileNames)
at DotNetPanel.EnterpriseServer.DatabaseServerControl ler.RestoreSqlDatabase(Int32 itemId, String[] uploadedFiles, String[] packageFiles)
--- End of inner exception stack trace ---
at DotNetPanel.EnterpriseServer.DatabaseServerControl ler.RestoreSqlDatabase(Int32 itemId, String[] uploadedFiles, String[] packageFiles)
at DotNetPanel.EnterpriseServer.esDatabaseServers.Res toreSqlDatabase(Int32 itemId, String[] uploadedFiles, String[] packageFiles)
--- End of inner exception stack trace ---
at System.Web.Services.Protocols.SoapHttpClientProtoc ol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtoc ol.Invoke(String methodName, Object[] parameters)
at DotNetPanel.EnterpriseServer.esDatabaseServers.Res toreSqlDatabase(Int32 itemId, String[] uploadedFiles, String[] packageFiles)
at DotNetPanel.Portal.SqlRestoreDatabase.RestoreDatab ase()

Many thanks

Donna

[Rock]

Hi Donna,

I'm receiving exactly the same error when restoring the backup into your database on the SQL server. The error (which I've copied below) clearly mentions the backup file not being in a proper format.

TITLE: Microsoft SQL Server Management Studio
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
ADDITIONAL INFORMATION:

Server Name: DB2005
Error Number: 3241
Severity: 16
State: 7
Line Number: 1

The media family on device 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\pinkandbdnndb.bak' is incorrectly formed. SQL Server cannot process this media family.
RESTORE FILELIST is terminating abnormally. (Microsoft SQL Server, Error: 3241)
------------------------------
BUTTONS:
OK
------------------------------

If you've installed Microsoft SQL Server Management Studio Express on your local machine you'd be able to connect to the remote SQL server from your local machine & populate the tables online without the need to restore the backup file.

Microsoft SQL Server Management Studio Express (SSMSE) is a free, easy-to-use graphical management tool for managing SQL Server 2005 Express Edition and SQL Server 2005 Express Edition with Advanced Services. It can be downloaded from the following link & needs to be installed onto your local machine.

Download details: Microsoft SQL Server Management Studio Express

Please let know if you need any further assistance into this.

[LoopyLoo75]

I have installed the tool, and used the SQL Server Import Export Wizard, it eventually failed with the following error:

TITLE: SQL Server Import and Export Wizard
------------------------------

Error 0xc002f210: Preparation SQL Task 1: Executing the query "TRUNCATE TABLE [dbo].[aspnet_Applications]
" failed with the following error: "Cannot truncate table 'dbo.aspnet_Applications' because it is being referenced by a FOREIGN KEY constraint.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

Can you point me in the right direction.

Cheers
Donna

[LoopyLoo75]

If I choose not to export into my server database all the database tables that begin with aspnet_* then I get the following error message....

Error 0xc0202009: Data Flow Task 1: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "The statement has been terminated.".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "The INSERT statement conflicted with the FOREIGN KEY constraint "FK_PackageAssemblies_PackageAssemblies". The conflict occurred in database "pinkandbdnndb", table "dbo.Packages", column 'PackageID'.".
(SQL Server Import and Export Wizard)


I am beginning to think that I may have even screwed up my databsae. There must be a simple way to get my development database onto the server!!!!!

Arrggghhh!!!!!

Donna

[Rock]

Originally Posted by LoopyLoo75

There must be a simple way to get my development database onto the server!!!!!

Is there a possibility of me getting access to your local machine? Backing up the database properly on the local machine & uploading the backup file to the server & later on restoring it directly on the server is the best & easiest way to get this done. Please open up a ticket with our Windows Support Dept, so someone may work on this issue in my absence.

[LoopyLoo75]

I have just upgraded from using SQL Server 2005 to SQL Server 2008 with you, and I am trying to access the database on the server using the IP address you have given me previously using SQL Server Management Studio. I successfully connect to the server, but when I attempt to expand the database list, my database is not listed, and I get the following error.

TITLE: Microsoft SQL Server Management Studio
------------------------------

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click: http://go.microsoft.com/fwlink?ProdN...r&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

The server principal "DotNetUser" is not able to access the database "globalconferencing" under the current security context. (Microsoft SQL Server, Error: 916)

For help, click: Source: MSSQLServer ID: 916 (SQL Server 10.00.1600) - Events And Errors Message Center: Message Details



Any ideas?

Cheers
Donna

[Rock]

Originally Posted by LoopyLoo75

I have just upgraded from using SQL Server 2005 to SQL Server 2008 with you, and I am trying to access the database on the server using the IP address you have given me previously using SQL Server Management Studio. I successfully connect to the server, but when I attempt to expand the database list, my database is not listed, and I get the following error.

TITLE: Microsoft SQL Server Management Studio
------------------------------

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click: Source: ID: (SQL Server ) - Events And Errors Message Center: Message Details

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

The server principal "DotNetUser" is not able to access the database "globalconferencing" under the current security context. (Microsoft SQL Server, Error: 916)

For help, click: Source: MSSQLServer ID: 916 (SQL Server 10.00.1600) - Events And Errors Message Center: Message Details

Any ideas?

Cheers
Donna

Hi Donna,

This is a bug in the Microsoft SQL Server Management Studio [MSSMS]:

Follow the these steps to apply the workaround:

• Open Microsoft SQL Server Management Studio & connect to the server using correct login credentials.
  
• Bring Object Explorer Details window by selecting View --> Object Explorer Details in menu (or hitting F7).
• In Object Explorer window click at Databases folder.
• In Object Explorer Details window right-click at the column header and deselect Collation.
• Refresh Databases folder & the database should be visible.

Please let us know if this workaround works for you. MSSMS will remember columns selection settings in the future & use it next time you expand databases.

Regarding issues with the DNN installation, the DB restore in SQL 2008 server & the host/admin passwords has been sorted out.

Emails containing respective login details have been sent on your registered email address.

Please let us know if you continue to face any other problems with the installation, Good luck

[LoopyLoo75]

I have tried that and get the following message:

TITLE: Microsoft SQL Server Management Studio
------------------------------

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click: http://go.microsoft.com/fwlink?ProdN...r&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

The server principal "DonnaMoores" is not able to access the database "apgnetworkFantasyFootball" under the current security context. (Microsoft SQL Server, Error: 916)

For help, click: Source: MSSQLServer ID: 916 (SQL Server 10.00.1600) - Events And Errors Message Center: Message Details

---------------------------------------------------------------

this is trying to connect to the database "apgnetworkFantasyFootball" which isnt mine, as I only have one database and it is not that one!!