Hello All,

I have a working DNN 4.0.2 site utilizing a database created in SQL Server 2005 Express Edition and have attempted to migrate this database to SQL Server 2005, but an error results.

Yes, the <connectionStrings> strings and a <appSettings> in web.config were updated appropriately to reflect the SQL Server 2005 database.  See below.

When the website is accessed the "Could not find stored procedure 'dbo.GetPortals'." error was reported.  See details below.

I used Microsoft SQL Server Management Studio to export the Express database file to a SQL Server 2005 database. "Copy data from one or more tables or views"

After the web.config change was made, the web site was rebuilt in Visual Web Developer 2005 Express Edition, the IDE used to create the original site.

FYI, this error is mentioned in "DotNetNuke Installation Guide.pdf".  However, the Guide states "To solve this
error, delete the dnn.conifg file from the /Install folder."  "dnn.config" does not exist in the source tree.  Other postings have mentioned this fact, as well.

Any suggestions?

Thank you,

Wayne

<connectionStrings>

<!-- Connection String for SQL Server 2005 Express

<add name="SiteSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;" providerName="System.Data.SqlClient" /> -->

<!-- Connection String for SQL Server 2000/2005 -->

<add name="DotNetNuke" connectionString="Server=(server);Database=(database);uid=(uid);pwd=(pwd;" providerName="System.Data.SqlClient" />

<add name="SiteSqlServer" connectionString="Server=(server);Database=(database);uid=(uid);pwd=(pwd);" providerName="System.Data.SqlClient" />

</connectionStrings>

<appSettings>

<!-- Connection String for SQL Server 2005 Express - kept for backwards compatability - legacy modules

<add key="SiteSqlServer" value="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;" /> -->

<!-- Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules -->

<add key="DotNetNuke" value="Server=(server);Database=(database);uid=(uid);pwd=(pwd);"/>

<add key="SiteSqlServer" value="Server=(server);Database=(database);uid=(uid);pwd=(pwd);"/>

Error reported:

Server Error in '/DotNetNuke1' Application.

---

Could not find stored procedure 'dbo.GetPortals'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Could not find stored procedure 'dbo.GetPortals'.

Source Error:

Line 154:            Dim objFolderController As New Services.FileSystem.FolderController
Line 155:            Dim objPortalController As New PortalController
Line 156:            Dim arrPortals As ArrayList = objPortalController.GetPortals()
Line 157:            Dim i As Integer
Line 158:            For i = 0 To arrPortals.Count - 1

[SqlException (0x80131904): Could not find stored procedure 'dbo.GetPortals'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +857162
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734774
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +31
   System.Data.SqlClient.SqlDataReader.get_MetaData() +62
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +886
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +122
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) +62
   Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) +499
   Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +201
   Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText) +40
   Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) +262
   DotNetNuke.Data.SqlDataProvider.GetPortals() +47
   DotNetNuke.Entities.Portals.PortalController.GetPortals() +16
   DotNetNuke.Common.Global.CacheMappedDirectory() in C:\Inetpub\wwwroot\DotNetNuke1\App_Code\Global.asax.vb:156
   DotNetNuke.Common.Global.Application_Start(Object Sender, EventArgs E) in C:\Inetpub\wwwroot\DotNetNuke1\App_Code\Global.asax.vb:266

If you just exported data tables and imported them into the new SQL Server, there are quite a few stored procedures that probably didn't make it over.  If fact, I'd guess that NONE of the stored procedures made it over.

I believe that you should make a BACKUP of your database on the original SQL Server Express, and then RESTORE this to your SQL Server 2005.  That will move the data, the stored procedures, and whatever else is there.