Re: SMS database issue after the move

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

Hi Steve,

Thanks for your help.

I found the problem...the SQL service was started using a domain service
account instead of local system account...after the change, I reset the site
again...and worked.

Cheers
Jimmy
"Steve Thompson" <stevethompson@xxxxxxxxxxxxx> wrote in message
news:uvVTQztjFHA.3064@xxxxxxxxxxxxxxxxxxxxxxx
> OK, since you used advanced security make sure on your database server
> that
> your sms site server +computer account+ (not the service account) has
> public
> permission to access master and dbo equivalence to your sms database.
>
> Steve
> "Jimmy Liu" <jliu@xxxxxxxxxx> wrote in message
> news:OPW$MOtjFHA.3288@xxxxxxxxxxxxxxxxxxxxxxx
>> Yes, I ran site setup after. Also I have Advance security for SMS... and
> am
>> looking into the permission...
>>
>> My SQL admin used SQL server and Windows authentication on the SQL and
> looks
>> like I have to find out the service account that he used and apply the
>> proper permission for it .
>>
>> I will give it a try.
>>
>> Thanks
>> Jimmy
>>
>> "Steve Thompson" <stevethompson@xxxxxxxxxxxxx> wrote in message
>> news:uVEOEgsjFHA.1048@xxxxxxxxxxxxxxxxxxxxxxx
>> > "Jimmy Liu" <jiliu@xxxxxxx> wrote in message
>> > news:umWy%23pojFHA.3436@xxxxxxxxxxxxxxxxxxxxxxx
>> >> I recently move the SQL database for SMS 2003 SP1 from one remote
> server
>> > to
>> >> the other remote server.
>> >>
>> >> The migration seems fine and able to see the new server name under
>> >> Site
>> >> Hierarchy - Site Settings- Site Systems as SQL server. The new SQL
>> >> server
>> >> name has been added to the local admin group.
>> >>
>> >> When I opened SMS Admin console from the SMS server, it shows it
> connects
>> > to
>> >> the new SQL database, however after I look at some records from
>> >> Components
>> >> status, the last record date is the date that I migrated the database
>> >> (meaning, no new data being added after the migration). Also,
>> >> although
>> > the
>> >> new SQL server name shows under Site Sytem (as I mentioned above), the
>> > Site
>> >> System Status still show the old server name as SQL server and the
> status
>> > is
>> >> OK (of course, the last record date is the date I backed up and
> migrated
>> > the
>> >> database).
>> >>
>> >> Can anyone help me and show me the right direction.
>> >
>> > I assume you ran a site reset after the database move? Did you verify
> that
>> > either the SMS service account (standard security) or the SMS site
> server
>> > computer (advanced security) has proper permissions at the SQL Server
> sms
>> > database?
>> >
>> > Steve
>> >
>> >
>>
>>
>
>


.

Relevant Pages

  • Re: Adv Client with Workgroup Computers
    ... I was trying to use the SMS tools from the SMS server to initiate harware ... Inv for example the account is a domain account but the Client PC is in a ... Is there a procedure for installing the ADV client localy on a workgroup ... I have manually added to the WINS server. ...
    (microsoft.public.sms.admin)
  • MP Control Manager Issue
    ... Windows 2003 Standard Server ... SMS 2003 SP1 ... MP encountered an error when connecting to SQL Server. ... If using a standard SQL security account, ...
    (microsoft.public.sms.admin)
  • Re: SQL account rights
    ... Please advice what is the best, suitable rights rather than domain admin ... issues, such as a server that might have IIS running on the same machine, ... applicable to SQL 2000 environment, ... files, or backups, make sure that the service account has Full ...
    (microsoft.public.sqlserver.security)
  • RE: MP Install issue
    ... Where in the installation are you talking about specifying the account rather ... > MPDB ERROR - CONNECTION PARAMETERS ... > SQL Server Name: servername ... > with a trusted SQL Server connection. ...
    (microsoft.public.sms.setup)
  • Re: SQL Express Fails with Hardware Error
    ... The LocalSystem account is a built-in account, ... which the SQL Service runs. ... MCSE, CCEA, Microsoft MVP - Terminal Server ... Minimum Hardware Requirement (Warning) ...
    (microsoft.public.sqlserver.setup)