DQS Connection Error

Question

When I [Connect  to Server] I receive this error:

I have this ith a CTP3 and an upgraded RC0 instance.    Any thoughts?

Error detais:

   at Microsoft.Ssdqs.Infra.Log.LLogger`1.InitConfiguration()
   at Microsoft.Ssdqs.Infra.Log.LLogger`1.GetLogger(Type loggerType, String name)
   at Microsoft.Ssdqs.Infra.Log.ServerLogger.GetLogger(Type type)
   at Microsoft.Ssdqs.Core.Startup.ServerInit..cctor()
Microsoft.Ssdqs.Infra.Exceptions.ServerException:
   at Microsoft.Ssdqs.Core.Startup.ServerInit..cctor()
System.TypeInitializationException:
   at Microsoft.Ssdqs.Core.Startup.ServerInit.Init()
.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   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)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.Ssdqs.Infra.Database.DBAccess.ExecCommand()
   at Microsoft.Ssdqs.Proxy.Database.DBAccessClient.Exec()
   at Microsoft.Ssdqs.Proxy.EntryPoint.BaseEntryPointClient.SetDataQualitySession(Nullable`1 clientId, Nullable`1 knowledgebaseId)
   at Microsoft.Ssdqs.Proxy.EntryPoint.BaseEntryPointClient..ctor(String serverName, String databaseName, Nullable`1 clientId, Nullable`1 knowledgebaseId)
   at Microsoft.Ssdqs.Proxy.EntryPoint.NotificationEntryPointClient..ctor(String serverName, String databaseName)
   at Microsoft.Ssdqs.Proxy.EntryPoint.ProxyEntryPointFactory.GetNotificationEntryPoint(String serverName, String databaseName)
   at Microsoft.Ssdqs.Studio.ViewModels.Data.Common.DataManager.ConnectToDatabase(String instance, String database, Boolean useEncryption)
   at Microsoft.Ssdqs.Studio.ViewModels.ViewModels.Application.LogOnWindowViewModel.ConnectToServer()
   at Microsoft.Ssdqs.Studio.ViewModels.Utilities.UIAsynchronousRelayAction.Action()
   at Microsoft.Ssdqs.Studio.ViewModels.Utilities.UIAsynchronousAction.ActionExecuter()

---

Rob

Answer 1

Hi Rob,

 

The CTP3->RC0 upgrade path is not supported. Please uninstall CT3, and re-install RC0.

In order to save your knowledge bases, you can export them from CTP3 before uninstalling (this can be done by opening a knowledge base for domain management - look at the green arrow on top of the list of domains) and then import the KBs to RC0 installation (this can be done by creating a new KB and selecting the option to import it from file).

Upgrades will be supported from RC0 and forward.

 

Thanks,

Omer 

Answer 2

 

One clarification - by saying that the CTP3->RC0 upgrade is not supported, I meant that the DQS feature should be removed and re-installed.

However, the following link contains instructions on how to perform this upgrade without the need to re-install the whole SQL. This can help if you are using other SQL features that do support the CTP3->RC0 upgrade.

http://social.technet.microsoft.com/wiki/contents/articles/5635.upgrade-dqs-sql-server-code-named-denali-ctp3-to-sql-server-2012-rc0.aspx

These instructions together with export/import the KBs as mentioned above, can be the most convenient solution for this upgrade path.

Thanks,

Omer