Mono Support Potential SQL issues. (Closed)

Viewed 39905 time(s), 3 post(s), 4/20/2014 3:18:06 PM - by Terfex
4/20/2014 3:18:06 PM
71 Reputation 7 Total posts

Hi,

I've recently moved my Monox Installation from an old Godaddy Server to one of their new Windows Plesk Servers. However I can't seem to get the site to run on the new server. The old server had SQL 2008 and IIS 7.0. The new server has IIS 8.0 and SQL 2012. I have managed to get the site to run on my development PC with IIS 8.0 and SQL 2012. GoDaddy support have looked extensively and conclude it's an SQL issue. I have been using SQL Management Studio to upload my working local database to their server which looks ok until I try to load the site. I have noticed the collations of my local Database and GoDaddy's is different however.

This is the error I get:
This event has been logged and will be addressed by the maintenance department. We appreciate your patience.

Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at System.Web.Util.SecUtility.CheckSchemaVersion(ProviderBase provider, SqlConnection connection, String[] features, String version, Int32& schemaVersionCheck) at System.Web.UI.WebControls.WebParts.SqlPersonalizationProvider.CheckSchemaVersion(SqlConnection connection) at System.Web.UI.WebControls.WebParts.SqlPersonalizationProvider.LoadPersonalizationBlobs(WebPartManager webPartManager, String path, String userName, Byte[]& sharedDataBlob, Byte[]& userDataBlob) at MonoSoftware.MonoX.VersionedPersonalizationProvider.LoadPersonalizationBlobs(WebPartManager wpm, String path, String userName, Byte[]& sharedDataBlob, Byte[]& userDataBlob) at System.Web.UI.WebControls.WebParts.PersonalizationProvider.LoadPersonalizationState(WebPartManager webPartManager, Boolean ignoreCurrentUser) at System.Web.UI.WebControls.WebParts.WebPartPersonalization.Load() at System.Web.UI.WebControls.WebParts.WebPartPersonalization.LoadInternal() at System.Web.UI.WebControls.WebParts.WebPartManager.OnInit(EventArgs e) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Please let me know if I need to provide more info.

1
4/21/2014 6:48:26 AM
71 Reputation 7 Total posts

Don't worry, fixed the issue with this post: 

Installaion Error by Dagon

2
4/22/2014 8:21:13 AM
15993 Reputation 2214 Total posts

Thanks for linking back, let us know if you have any further issues.

3
This is a demo site for MonoX. Please visit Mono Software for more info.