Link to home
Create AccountLog in
Avatar of Marcaug007
Marcaug007

asked on

SQL 2005 Database Mirroring

I'm trying to setup a mirror in SQL 2005 using the GUI interface in SQL Studio manager...It will connect & succeed on everything during setup, but when I click on start mirroring I get the following error...
03/06/2008 16:19:40,spid16s,Unknown,Database mirroring has been terminated for database 'ProdTrack'. This is an informational message only. No user action is required.
03/06/2008 16:19:40,spid16s,Unknown,Error: 1443<c/> Severity: 16<c/> State: 2.
03/06/2008 16:19:20,spid27s,Unknown,Database mirroring connection error 5 'Connection handshake failed. The login 'NT AUTHORITY\ANONYMOUS LOGON' does not have CONNECT permission on the endpoint. State 84.' for 'TCP://datacollection.DELL_DOMAIN:5022'.
03/06/2008 16:19:20,spid27s,Unknown,Error: 1474<c/> Severity: 16<c/> State: 1.
03/06/2008 16:15:41,spid15s,Unknown,Database mirroring has been terminated for database 'ProdTrack'. This is an informational message only. No user action is required.
Avatar of chapmandew
chapmandew
Flag of United States of America image

Did you create the necessary endpoints?
Avatar of Marcaug007
Marcaug007

ASKER

In Studio Manager I went thru using the wizard, Select my pricipal, mirror, & witness servers...At the end it succeeds where it says creating endpoints, so I'm assuming it did.

Also, upon my restore to the mirror server using no recovery, my datbase says (restoring)
I can't see where?
I think the issue is within when I do the Restore.  After I do the restore  using no recovery the database never seems to finish.  I get the pop up saying restore complete, but when I look in Studio Manager it has (restoring) after the database name.  Is this correct, because anything I try to do to that database gives me an error that it is still restoring can't complete task.  I've tried it several times with the same result.  Maybe I need the most basic steps to setup mirroring with a witness from start to finish.  Almost click by click if available.
Yep, it is correct.  It says restoring because the database hasn't been recovered (and you don't want it to be)....since it is restoring, you can still apply logs, etc to it.  It is what you want.
Okay, maybe  I need to setup permissions?
What are you trying to do to the database?  You won't be able to do anything because it is in a state where you can't change anything on it....
Here's the error I get....Where Do I assign these permissions??

03/07/2008 10:17:01,spid26s,Unknown,Database mirroring connection error 5 'Connection handshake failed. The login 'NT AUTHORITY\ANONYMOUS LOGON' does not have CONNECT permission on the endpoint. State 84.' for 'TCP://DATACOLLECTION.DELL_DOMAIN:5022'.
03/07/2008 10:17:01,spid26s,Unknown,Error: 1474<c/> Severity: 16<c/> State: 1.
this should work...substitute endpointname with your endpointname

grant connect on endpoint:[endpointname]: to [NT AUTHORITY\ANONYMOUS LOGON ]

Do I do this in studio manager? or How?
in a new query window...yes, 'New Query' in management studio
grant connect on endpoint MIRROR to NT AUTHORITY\ANONYMOUS LOGON]


Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'to'.
ASKER CERTIFIED SOLUTION
Avatar of chapmandew
chapmandew
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
grant connect on endpoint:[mirroring] to [NT AUTHORITY\ANONYMOUS]


Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'endpoint:'.
grant connect on endpoint::[mirroring] to [NT AUTHORITY\ANONYMOUS]