We will probably be jumping version to SQL2008 in 'x' months so any development in the MSSQL area is most welcome.
Barry -----Original Message----- From: Servers Alive Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Michael D. Shook Sent: February 21, 2008 7:21 PM To: Servers Alive Discussion List Subject: Re: [SA-list] SQL 2005 1) .NET is standard for our servers due to other needs, so this poses no problem. 2) My DBA assures me that a SQL login can be created if necessary for Servers Alive to connect to the db. Since this will be a read only access, there is little or no security risk exposed. Mike Shook Dirk Bulinckx wrote: > 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 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. > 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. 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.
