Pretty much same situation for us. Ian _________________________________ Ian K Gray OEL IS - European Infrastructure Support Tel: +44 1236 502661 Mob: +44 7881 518854 Ad eundum quo nemo ante iit
"Chad Stiller" <[EMAIL PROTECTED]> Sent by: Servers Alive Discussion List <[email protected]> 22/02/2008 16:50 Please respond to Servers Alive Discussion List <[email protected]> To Servers Alive Discussion List <[email protected]> cc Subject Re: [SA-list] SQL 2005 Running .Net is not a problem for us on the server side, most have 2.0 or higher currently, no real app issues we have to work around with it on the back end. SQL level accounts are not a problem either, although we try to use Windows authentication where possible for single sign on/ease of use. We currently have two or three SQL 2k5 servers and about half a dozen SQL 2K in production. I have yet to use SA to monitor more then the SQL services at the OS level, so would be interested to see how the check progresses. Thanks! Chad >>> "Dirk Bulinckx" <[EMAIL PROTECTED]> 2/21/2008 3:51 PM >>> We're currently (re)looking at adding a SQL2005 check (similar to the SQL2000/SQL7 check in SA). Looking at how SQL2005 "works" we won't be able to use SQL DMO in all cases (seems that SQL2005 can only use DMO when in some kind of compatibility mode :-( ), so we will have to use the "new" SQL SMO. This does mean using the .NET 2.0 Framework -> do you see this as a problem? Also from an authentication point of view it can OR use the current logged-in NT user OR use SQL authentication. This means that IF we have such a check for SQL2005 and you want to run SA as service (system account) THEN you will have to use SQL authentication -> is this possible on YOUR SQL2005 installation? Dirk Bulinckx. To unsubscribe send a message with UNSUBSCRIBE as subject to [email protected] If you use auto-responders (like ou! t-of-the-office messages), then make sure that they are not send to the list nor to the individual members of the list that send a message. Doing this will get you removed from the list. To unsubscribe send a message with UNSUBSCRIBE as subject to [email protected] If you use auto-responders (like out-of-the-office messages), then make sure that they are not send to the list nor to the individual members of the list that send a message. Doing this will get you removed from the list. ______________________________________________________________________________ Any opinions expressed in this email are those of the individual and not necessarily of the Company. This email and any files transmitted with it, including replies and forwarded copies (which may contain alterations) subsequently transmitted from the Company are confidential and solely for the use of the intended recipient. It may contain material protected by legal privilege. If you are not the intended recipient or the person responsible for delivering to the intended recipient, be advised that you have received this email in error and that any use is strictly prohibited. Please notify the sender immediately of the error and delete any copies of this message Warning: Although the Company has taken reasonable precautions to ensure that no viruses are present in this e-mail, the Company cannot accept responsibility for any loss or damage arising from the use of this e-mail or attachments. To unsubscribe send a message with UNSUBSCRIBE as subject to [email protected] If you use auto-responders (like out-of-the-office messages), then make sure that they are not send to the list nor to the individual members of the list that send a message. Doing this will get you removed from the list.
