still error in service listing manager....

Hi Remus:

I am using latest ServiceListingManager v1.1.3 and still getting this error....

Msg 6522, Level 16, State 1, Procedure ssb_create_certificate_from_blob, Line 0
A .NET Framework error occurred during execution of user defined routine or aggregate 'ssb_create_certificate_from_blob':
System.Data.SqlClient.SqlException: A certificate with name 'CMA_sbuser' already exists or this certificate already has been added to the database.System.Data.SqlClient.SqlException: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnectionSmi.EventSink.ProcessMessagesAndThrow(Boolean ignoreNonFatalMessages)
at Microsoft.SqlServer.Server.SmiEventSink_Default.ProcessMessagesAndThrow(Boolean ignoreNonFatalMessages)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQuerySmi(Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.SqlServiceBroker.Samples.CertificatesBlob.CertificatesBlob.ssb_create_certificate_from_blob(SqlString databaseName, SqlString certificateName, SqlString authorizationUser, SqlBinary certificateBody)

Help is greatly appreciated....

Thanks,

Pramod

[1507 byte] By [PramodSKumar] at [2007-12-24]
# 1

This occurs because the certificate is already deployed. For dialog security, v1.1.3 handles this gracefully, so the problem should be in the endpoint security. It means you have already set up the security between the tho SQL instances hosting the services. To work around the problem, make sure that you do not check the 'Endpoint' option on the first page of the Listing Import Wizard.

I'll keep in mind to make this more friendlier, it seems to cause some confusion.

HTH,
~ Remus

RemusRusanu at 2007-8-31 > top of Msdn Tech,SQL Server,SQL Service Broker...
# 2
It means...i dont need to select endpoint in both imports i.e A & B.
PramodSKumar at 2007-8-31 > top of Msdn Tech,SQL Server,SQL Service Broker...
# 3
Yes, if you import two service A and B from the same host instance, you only have to choose the 'Endpoint' option once.
RemusRusanu at 2007-8-31 > top of Msdn Tech,SQL Server,SQL Service Broker...

SQL Server

Site Classified