connection problems in secondary site and SQL server

hi:
I spend some days with problems in me proxy MP.
When i do the http verificartion show error.

Finally i can see this error in Status Message Viewer. Error 5420.

I have one primary and one secondary site. Standard security, primary and
secondary use the same SQL database. In me primary alla run fine, not in
seconcary, for this problems in MP.

SQL use SQL and Windows autentication. I use SMSService account to
comunicate between sites and add this account to
SMS_SiteSystemToSQLConnection_<sitecode > group

please i can appreciate if any share the correct use of account in SMS system

Any another idea to find the problem?

I appreciate the time to read and help me.

Thanks in advanced
cyber






SMS Management Point encountered an error when connecting to its Database
SMS on SQL Server My_Primary_SMS_Server. The OLEDB error code was 0x80004005.

Possible cause: The SQL server site system is turned off, not connected to
the network, or not functioning properly.
Solution: Verify that the SQL server site system is turned on, connected to
the network, and functioning properly.

Possible cause: SMS Management Point does not have sufficient access rights
to the SQL server site system.
Solution: Verify that the SQL server is properly configured to allow
Management Point access. If using a standard SQL security account, verify
that the SQL Server is configured to allow standard SQL Security; or
configure the Management Point to use an NT integrated security account, with
appropriate access. If using integrated security, verify the account used
by the MP to connect to the SQL server is a member of the
SMS_SiteSystemToSQLConnection_<sitecode > group on the SQL server, that the
account is not locked out, and that the account password is not expired. (In
standard security, the default account is SMS_SQL_RX_<sitecode>.)

Possible cause: Network problems are preventing SMS Management Point from
properly accessing the SQL server.
Solution: Investigate and correct any problems with your network.

Possible cause: The Management Point having problems is at a secondary site,
and SQL access account being used was recently reset by the parent site.
Solution: This can automatically repair itself after one hour , as long as
the account in use is not locked out. Check that the account in use is not
locked out. Instead of waiting an hour, you can stop and start the
SMS_SITE_COMPONENT_MANAGER service to immediately apply the new configuration.

Possible cause: The SQL server Service Principal Names (SPNs) are not
registered correctly in Active Directory
Solution: Ensure SQL server SPNs are correctly registered. Review Q829868.
.

Relevant Pages

  • Re: Error 15401 using sp_grantlogin (not addressed by current KB articles)
    ... Restarting Windows 2000 resolved the problem for this particular account, ... confused when it sees a duplicate SID. ... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ...
    (microsoft.public.sqlserver.security)
  • Re: SharePoint V3 Install Error
    ... But it our case it had to do with Group Policies that forbid the account of ... WSS FAQ:www.wssv3faq.com/wss.collutions.com ... Event Source: WindowsSharePointServices3Search ... whatever you are installing WSS as sufficient rights to the SQL Server ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: connection problems in secondary site and SQL server
    ... I use SMSService account to ... SMS on SQL Server My_Primary_SMS_Server. ... Verify that the SQL server site system is turned on, ... If using a standard SQL security account, ...
    (microsoft.public.sms.admin)
  • RE: Problems with WebParts
    ... to a database called aspnetdb. ... > The connection string specifies a local SQL Server Express instance using a ... > server account must have read and write access to the applications directory. ... > This is necessary because the web server account will automatically create ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: connection problems in secondary site and SQL server
    ... i can't add this account to this group. ... I have one primary and one secondary site. ... SMS Management Point encountered an error when connecting to its Database ... SMS on SQL Server My_Primary_SMS_Server. ...
    (microsoft.public.sms.admin)
Loading