<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">
You won't break anything by changing SQL back to mixed mode. That way you can create a SQL only user for them and not give them admin access to the entire server. It requires a bounce of the SQL server though.<div><br><div> <p style="margin: 0.0px 0.0px 0.0px 0.0px"><font face="Helvetica" size="3" style="font: 12.0px Helvetica">-Ryan</font></p> </div><br><div><div>On Jan 23, 2008, at 11:54 AM, d4rk f1br wrote:</div><br class="Apple-interchange-newline"><div>Running CallManager 4.1(3) and want to setup or allow some of our sql reporting and developer folks access to the CDR database so that they can create some custom reporting for supervisors and management.</div> <div> </div> <div>Not finding any best practices regarding anything related to this. I do notice that my CM cluster sql appears to be configured with "Windows only" authentication.</div> <div> </div> <div>I notice there are already some users associated with the CDR database on CM.</div> <div> </div> <div>CCMCDR</div> <div>CCMServiceRW</div> <div>CCMUser</div> <div>Administrator</div> <div> </div> <div>Should one create a new user for this or use an existing? Should I leave CM set to use 'Windows only' authentication ? Can you even change that without having a negative impact?</div> <div> </div> <div>I know that prior to 4.x the default use to be mixed mode allowing for SQL and Windows authentication.</div> <div> </div> <div>Any thoughts or suggestions regarding any of this would be appreciated. Always like to hear from others prior to moving forward with things I am not 100% sure about.</div> <div> </div> <div> </div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">_______________________________________________</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">cisco-voip mailing list</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><a href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</a></div> </div><br></div></body></html>