Re: SMS reinstall

From: Jeff Harbaugh [MSFT] (jeffharb_at_online.microsoft.com)
Date: 07/21/04 

Date: Wed, 21 Jul 2004 11:56:57 -0700

Is the account you are logged in as part of the SQL Admins? Do you knwo the
security of the SQL server? Is it using mixed or integrated. If you log onto
the machine as a domain admin you should be able to open the SQL server and
check the logins and security. You will need to have this fixed prior to
making changes. 

-- 
Thanks,
Jeff Harbaugh [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
<anonymous@discussions.microsoft.com> wrote in message 
news:184e01c46f52$58c1e500$a501280a@phx.gbl...
>I did a search and came up with no results found for a
> smsdbmon.log file.Also, the SQL is running on the same
> server.When I try to modify setup, I get the error: Cannot
> connect to SQL Server (servername)using integrated
> security. Make sure the SQL Server is using integrated
> security and your logon account has sa rights to the
> server.
>>-----Original Message-----
>>Reinstallation would involve not only the site systems
> but all of the
>>clients since the password for the client accounts would
> become different. I
>>would only do that as a last resort. First you could run
> setup again and
>>choose modify or reset the current installation.
>>If that does not work I would look at the smsdbmon.log to
> see the SQL
>>errors. From there make sure all SMS_Service accounts
> have permissions to
>>the SQL box.
>>
>>-- 
>>Thanks,
>>Jeff Harbaugh [MSFT]
>>This posting is provided "AS IS" with no warranties, and
> confers no rights.
>>
>>"Gerry" <anonymous@discussions.microsoft.com> wrote in
> message
>>news:156101c46f3a$045a0050$a401280a@phx.gbl...
>>> We are having an issue with SMS 2.0.
>>> I have taken over the setup of SMS 2.0 from another
> person
>>> in our IT department. I am unable to get the SMS
>>> administrator to connect to the site. It takes a long
> time
>>> and then states connection failed. The person who
>>> originally installed SMS states it used to connect, but
>>> can also no longer get SMS to connect. I have searched
> the
>>> web for any solutions , tried everything I have found
> with
>>> no results. I am thinking I may need to start over on
> the
>>> install. My question is, if I start over is this going
> to
>>> cause problems because the local SMS accounts are
> already
>>> installed on all the pcs  on the network (approx. 140
> pcs).
>>> What do I need to do to sucessfully reinstall SMS or get
>>> it to function as it is? The other IT person does not
>>> remember the passwords for these local accounts and I am
>>> assuming there would a lot of manual process invovled
> in a
>>> reinstall because of what is already installe on all the
>>> pcs in regards to SMS. Please advise.
>>> Thanks
>>
>>
>>.
>>

Relevant Pages

  • 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 resolved a problem like this changing the Security settings on SMS_MP ... I had to go into SQL Server Configuration Manager / SQL Server 2005 Network ... I noticed I couldn't get SMS reports to work.... ... If using a standard SQL security account, ...
    (microsoft.public.sms.admin)
  • Re: Moving from Standard Security to Advanced Security
    ... The only thing I usually hear about is when people don't set up the accounts ... Security that should help avoid those pitfalls. ... Check out the SMS Technical FAQ: ...
    (microsoft.public.sms.admin)
  • MP Not responding
    ... I am new to SMS 2003 .Following is the configuration of the OUR SMS ... MP encountered an error when connecting to SQL Server. ... If using a standard SQL security account, ...
    (microsoft.public.sms.setup)
  • Re: Newbie question on SQL connection
    ... Let me educate you about SQL Server security. ... The "Trusted Connection" error is associated with the "Windows ... granting permissions to these accounts in SQL ...
    (microsoft.public.dotnet.framework.aspnet)