SQL Server cannot create the mirroring endpoint, 'Mirroring'.
------------------------------
Create failed for Endpoint 'Mirroring'. (Microsoft.SqlServer.Smo)
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Database mirroring is disabled by default. Database mirroring is currently provided for evaluation purposes only and is not to be used in production environments. To enable database mirroring for evaluation purposes, use trace flag 1400 during startup. For more information about trace flags and startup options, see SQL Server Books Online. (Microsoft SQL Server, Error: 1498)
------------------------------
Hmmm... Let's try this:
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=3786143&SiteID=1
------------------------------
After MSSQL says that it is possible to mirror on 2 instance on same host, it requires mirroring on 2 separate hosts. Therefore, different instance on same host is not allowed after all. Then MSSQL required both hosts to have SQL service pack 2. After updating the engines to SP2, still it won't work. MSSQL=Syet!
------------------------------
After MSSQL says that it is possible to mirror on 2 instance on same host, it requires mirroring on 2 separate hosts. Therefore, different instance on same host is not allowed after all. Then MSSQL required both hosts to have SQL service pack 2. After updating the engines to SP2, still it won't work. MSSQL=Syet!
No comments:
Post a Comment