CMS and SQL Server Login

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hey all,

First time being able to use the TechNet newsgroups. :) We are currently
looking to upgrade SMS 2003 to Configuration Manager Server. For the upgrade,
it advised us that we need to turn off SQL Authentication and have it be
Windows Only. Our problem is that we have a 3rd party application that hard
codes a DB login ID and password and allows non-SMS users to view information
for computers. This 3rd party tool is used heavily by our technicians. If we
turn off the SQL Authentication, the tool will no longer work.

Can we turn the SQL authentication off for the upgrade and then switch it
back to allow SQL Auth and Windows?
.

Relevant Pages

  • Re: CMS and SQL Server Login
    ... I used mixed mode all the time.. ... looking to upgrade SMS 2003 to Configuration Manager Server. ... This 3rd party tool is used heavily by our technicians. ... turn off the SQL Authentication, the tool will no longer work. ...
    (microsoft.public.sms.setup)
  • Upgrade and application server issue
    ... All the aaplication servers users use SQL authentication only user names and passwords. ... Do we need to do anything after doing upgrade like joining them to AD structure or upgrade will take care of? ...
    (microsoft.public.windows.server.migration)
  • Re: Here is what MS says about MCE 2005 and XP Pro
    ... I'll NEVER buy another HP with any MCE software. ... MCE2004 to 2005 wuth the HP upgrade CD. ... downloads and Windows LIVE progammable updates. ... MS-MVP Windows Media Center\Windows Powered Smart Display\Security ...
    (microsoft.public.windows.mediacenter)
  • Re: Seeking upgrade advise for motherboard change with oem windows
    ... i only have oem windows xp with only a restart disc need to know if i ... need only an xp upgrade version to do it or will i need a full 98 ... Ken Blake - Microsoft MVP Windows: ...
    (microsoft.public.windowsxp.general)
  • Re: Here is what MS says about MCE 2005 and XP Pro
    ... install directly to 2005 and be done with the HP version. ... Newegg.com among others sells MCE 2005. ... WMCE 2005 upgrade from HP in late 2004 and 3 times after attempting to ... downloads and Windows LIVE progammable updates. ...
    (microsoft.public.windows.mediacenter)