Re: SMS and SQL intergration

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Cathy Moya [MS] (camoya_at_online.microsoft.com)
Date: 10/20/04


Date: Wed, 20 Oct 2004 10:02:10 -0700

What errors are you seeing? Did you grant the SMS account (computer
account/advanced security or service account/standard security) admin rights
on the SQL Server computer?

-- 
Cathy Moya, MCSE: Security, MCT
Technical Writer, Enterprise Management Content Group
Check out the SMS Technical FAQ:
http://www.microsoft.com/technet/prodtechnol/sms/sms2003/techfaq/default.mspx
This posting is provided AS IS with no warranties and confers no rights.
"Shaun Gardiner" <Soldier220@gmail.com> wrote in message
news:fdc979bf.0410200820.da98edd@posting.google.com...
> I am attempting to set up my SMS server using an SQL server that is
> seperate from the SMS server.  For one reason or another I am unable
> to do this.  Is there anyone out there that can give me some tips on
> making this thing work?


Relevant Pages

  • Re: Reinstall of SMS 2003 has no Status Messages
    ... The user running SMS setup has admin rights to SQL as well correct? ... > account does not have Administrator's privileges on the SQL Server. ...
    (microsoft.public.sms.setup)
  • Re: Reinstall of SMS 2003 has no Status Messages
    ... Errors accessing SQL usually mean the SMS Service account does not have ... admin rights to the SQL server. ... Is the SMS site server and SQL server on ... There are however multiple attempts in the log files to ...
    (microsoft.public.sms.setup)
  • Re: Failed to get a SQL Server connection
    ... remote SQL Server device. ... check that you have installed the SMS SQL database on the default ... Use the output to verify that the account is enabled, ... SMS Site Component Manager failed to reinstall this component on this site ...
    (microsoft.public.sms.setup)
  • Http verification .sms_aut (port 80) failed
    ... I noticed I couldn't get SMS reports to work.... ... MP encountered an error when connecting to SQL Server. ... If using a standard SQL security account, ...
    (microsoft.public.sms.admin)
  • Re: Http verification .sms_aut (port 80) failed
    ... I noticed I couldn't get SMS reports to work.... ... MP encountered an error when connecting to SQL Server. ... If using a standard SQL security account, ... SMS_SITE_COMPONENT_MANAGER service to immediately apply the new configuration. ...
    (microsoft.public.sms.admin)