July 29, 2010 at 10:57 pm
how to allow databse mirroring network access using sql authentication
July 29, 2010 at 11:02 pm
If I remember correctly, your choices are Windows Authentication or Certificate Authentication.
You may want to check this out in Books Online, it should help you clarify the choices.
July 29, 2010 at 11:14 pm
Thanks a lot..
and i am getting error when sql server was restarted.
error
2010-07-28 16:01:40.89 Server SQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required.
2010-07-28 16:01:41.53 spid12s Service Broker manager has shut down.
2010-07-28 16:01:41.53 spid12s Error: 17054, Severity: 16, State: 1.
2010-07-28 16:01:41.53 spid12s The current event was not reported to the Windows Events log. Operating system error = 1717(The interface is unknown.). You may need to clear the Windows Events log if it is full.
2010-07-28 16:01:41.61 Server The connection has been lost with Microsoft Distributed Transaction Coordinator (MS DTC). Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) will begin once the connection is re-established. This is an informational message only. No user action is required.
2010-07-28 16:01:41.84 spid5s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
2010-07-28 16:01:41.86 Server The SQL Network Interface library could not deregister the Service Principal Name (SPN) for the SQL Server service. Error: 0x45b, state: 4. Administrator should deregister this SPN manually to avoid client authentication errors.
i am not able to find the exact root cause for can you please help me to solve this
July 30, 2010 at 2:34 am
krishnaveni_chigurupati (7/29/2010)
SQL Server is terminating because of a system shutdown.
Someone shut the server down. This is not a SQL error, if the server is shut down SQL obviously has to shut down.
Look in the windows event log (system log) and see if you can tell why the machine shut down.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply