Hello everyone.

I have a DNN install that I have been using for some time now. I am trying to get it moved to a new dedicated server. I have the site files running on the new server but have kept the same connection string and using the SQL DB on the old server without any problems. I am now trying to move the SQL DB to my new server. I created a blank DB in SQL Manager and Imported the data from the running database. Everything seemed to import without any errors but when I try to load the site I get the error below. I have googled this and read many posts about it. I have checked my connection string and everything seems correct as far as I know. The worst part is my old provider seems to have turned everything off and skipped town. (I will NEVER use Host Department again!!!!) Anyway, I now do not have access to the old database and my site is not loading at all so I have to get this working somehow, fast!!

My server uses MS SQL 2005. My connection string:

<add name="SiteSqlServer" connectionString="Data Source=97.74.*.*,1433;Network Library=DBMSSOCN;Initial Catalog=pgt_main;User Id=dbname;Password=dbpwd;" providerName="System.Data.SqlClient" />
    

Error:

Server Error in '/pgt' Application.

---

The stored procedure 'dbo.GetPortalAliasByPortalID' doesn't exist.

[InvalidOperationException: The stored procedure 'dbo.GetPortalAliasByPortalID' doesn't exist.]
   System.Data.SqlClient.SqlCommand.DeriveParameters() +947206
   System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) +88
   Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) +212
   Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) +303
   Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) +154
   Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) +36
   Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) +200
   DotNetNuke.Data.SqlDataProvider.GetPortalAliasByPortalID(Int32 PortalID) +87
   DotNetNuke.Entities.Portals.PortalAliasController.GetPortalAliasByPortalID(Int32 PortalID) +35
   DotNetNuke.Entities.Portals.PortalSettings.GetPortalAliasLookup() +74
   DotNetNuke.Entities.Portals.PortalSettings.GetPortalAliasInfo(String PortalAlias) +14
   DotNetNuke.HttpModules.UrlRewriteModule.RewriteUrl(HttpApplication app) +3342
   DotNetNuke.HttpModules.UrlRewriteModule.OnBeginRequest(Object s, EventArgs e) +1180
   System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

Thank you Matthias,

I do have a MS SQL user set up in SQL Manager which is already set as dbo so there has to be some other problem.

i've had this happen to me once. that would be because of the database

to go down my checklist.

1. Are you able to connect to your Database using the exact details in MSSQL Mgmt Studio?
2. Is your database complete? View it visually and try searching for that Stored Procedure.

since you've created and imported data, it logically should work. coupled with the connection details. it even more should work! Usually this happens cause the database had an error installing... you weren't installing DNN were you?