Re: SMS install

In article <AC45CE19-03CB-400E-BBFA-627B4FEEE623@xxxxxxxxxxxxx>, "=?Utf-
8?B?U2NvdHQgQWxsZW4=?=" <Scott Allen@xxxxxxxxxxxxxxxxxxxxxxxxx> says...
> I am trying to install SMS and SQL on seperate servers in seperate domains. I
> have gave sa and local admin rights to the computer account and to the
> account that is installing SMS. During the install wizard, I have choosen Adv
> security and selected SQL security. The account I use for SQL security has
> full access to the SQL server. In the SMS log file, it states that user does
> not have access to the database. Can someone please assist me and clarify
> this situation. Cheers.
>
Ok, for starters I am definitely not a sql expert, and I know next to
nothing about sql logins.

Yet, if you use advanced security then sms uses the computer account to
do everything. You initially state that you gave sa permissions to the
computer account. This should be fine. Later you state that the account
you use for sql security has full access to the sql server, which
account are we referring to here?

These two domains are in the same forest, right?
--
Kim Oppalfens
MVP SMS
Computacenter Belgium
.

Relevant Pages

  • Re: SMS database issue after the move
    ... I found the problem...the SQL service was started using a domain service ... account instead of local system account...after the change, ... since you used advanced security make sure on your database server ... > permission to access master and dbo equivalence to your sms database. ...
    (microsoft.public.sms.admin)
  • Re: SMS 2003 SP2 and SQL 2000
    ... most likely the issues is related to that you are using "core" SQL functionality to dump the database to the same file every time it back's up the SMS db. ... As Garth did mention you should disable all this SQL Server Agent jobs and rather rely on the SMS_SITE_BACKUP task instead, as it will backup all required components at the same point in time. ...
    (microsoft.public.sms.admin)
  • Re: SMS install
    ... >> I am trying to install SMS and SQL on seperate servers in seperate domains. ... >> account that is installing SMS. ... >> full access to the SQL server. ...
    (microsoft.public.sms.setup)
  • Re: SMS install
    ... >>> I am trying to install SMS and SQL on seperate servers in seperate domains. ... >>> account that is installing SMS. ... >>> security and selected SQL security. ...
    (microsoft.public.sms.setup)
  • Re: installing sms 2.0 with SQL already installed
    ... I'm not sure what you mean by the service acct. ... Is this the sms service ... account or the account for accessing the sql db? ... to use integrated windows authentication with the sql db where sms will use ...
    (microsoft.public.sms.installer)