Showing posts with label mirroring. Show all posts
Showing posts with label mirroring. Show all posts

Sunday, March 11, 2012

An error occurred while starting mirroring?

How can I troubleshoot this?
Olav
An error occurred while starting mirroring.
ADDITIONAL INFORMATION:
Alter failed for Database 'Commerce'. (Microsoft.SqlServer.Smo)
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
The server network address "TCP://lion.safari.webinnovation.no:5022" can not
be reached or does not exist. Check the network address name and that the
ports for the local and remote endpoints are operational. (Microsoft SQL
Server, Error: 1418)
Hi
"Olav" wrote:

> How can I troubleshoot this?
> Olav
> An error occurred while starting mirroring.
> --
> ADDITIONAL INFORMATION:
> Alter failed for Database 'Commerce'. (Microsoft.SqlServer.Smo)
> --
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> The server network address "TCP://lion.safari.webinnovation.no:5022" can not
> be reached or does not exist. Check the network address name and that the
> ports for the local and remote endpoints are operational. (Microsoft SQL
> Server, Error: 1418)
>
There are many posts on this error! Did you check out
http://msdn2.microsoft.com/en-us/library/aa337361.aspx and
http://msdn2.microsoft.com/en-us/library/ms189127.aspx
John
|||The problem was that the Mirror database was not restored with the
NORECOVERY option.
Olav
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:20CFB426-D745-4F01-A71F-E629A3F70055@.microsoft.com...
> Hi
> "Olav" wrote:
> There are many posts on this error! Did you check out
> http://msdn2.microsoft.com/en-us/library/aa337361.aspx and
> http://msdn2.microsoft.com/en-us/library/ms189127.aspx
> John

An error occurred while starting mirroring?

How can I troubleshoot this?
Olav
An error occurred while starting mirroring.
ADDITIONAL INFORMATION:
Alter failed for Database 'Commerce'. (Microsoft.SqlServer.Smo)
--
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
The server network address "TCP://lion.safari.webinnovation.no:5022" can not
be reached or does not exist. Check the network address name and that the
ports for the local and remote endpoints are operational. (Microsoft SQL
Server, Error: 1418)Hi
"Olav" wrote:

> How can I troubleshoot this?
> Olav
> An error occurred while starting mirroring.
> --
> ADDITIONAL INFORMATION:
> Alter failed for Database 'Commerce'. (Microsoft.SqlServer.Smo)
> --
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> The server network address "TCP://lion.safari.webinnovation.no:5022" can n
ot
> be reached or does not exist. Check the network address name and that the
> ports for the local and remote endpoints are operational. (Microsoft SQL
> Server, Error: 1418)
>
There are many posts on this error! Did you check out
http://msdn2.microsoft.com/en-us/library/aa337361.aspx and
http://msdn2.microsoft.com/en-us/library/ms189127.aspx
John|||The problem was that the Mirror database was not restored with the
NORECOVERY option.
Olav
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:20CFB426-D745-4F01-A71F-E629A3F70055@.microsoft.com...
> Hi
> "Olav" wrote:
>
> There are many posts on this error! Did you check out
> http://msdn2.microsoft.com/en-us/library/aa337361.aspx and
> http://msdn2.microsoft.com/en-us/library/ms189127.aspx
> John

An error occurred while starting mirroring?

How can I troubleshoot this?
Olav
An error occurred while starting mirroring.
--
ADDITIONAL INFORMATION:
Alter failed for Database 'Commerce'. (Microsoft.SqlServer.Smo)
--
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
--
The server network address "TCP://lion.safari.webinnovation.no:5022" can not
be reached or does not exist. Check the network address name and that the
ports for the local and remote endpoints are operational. (Microsoft SQL
Server, Error: 1418)Hi
"Olav" wrote:
> How can I troubleshoot this?
> Olav
> An error occurred while starting mirroring.
> --
> ADDITIONAL INFORMATION:
> Alter failed for Database 'Commerce'. (Microsoft.SqlServer.Smo)
> --
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> The server network address "TCP://lion.safari.webinnovation.no:5022" can not
> be reached or does not exist. Check the network address name and that the
> ports for the local and remote endpoints are operational. (Microsoft SQL
> Server, Error: 1418)
>
There are many posts on this error! Did you check out
http://msdn2.microsoft.com/en-us/library/aa337361.aspx and
http://msdn2.microsoft.com/en-us/library/ms189127.aspx
John|||The problem was that the Mirror database was not restored with the
NORECOVERY option.
Olav
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:20CFB426-D745-4F01-A71F-E629A3F70055@.microsoft.com...
> Hi
> "Olav" wrote:
>> How can I troubleshoot this?
>> Olav
>> An error occurred while starting mirroring.
>> --
>> ADDITIONAL INFORMATION:
>> Alter failed for Database 'Commerce'. (Microsoft.SqlServer.Smo)
>> --
>> An exception occurred while executing a Transact-SQL statement or batch.
>> (Microsoft.SqlServer.ConnectionInfo)
>> --
>> The server network address "TCP://lion.safari.webinnovation.no:5022" can
>> not
>> be reached or does not exist. Check the network address name and that the
>> ports for the local and remote endpoints are operational. (Microsoft SQL
>> Server, Error: 1418)
>>
> There are many posts on this error! Did you check out
> http://msdn2.microsoft.com/en-us/library/aa337361.aspx and
> http://msdn2.microsoft.com/en-us/library/ms189127.aspx
> John