RE: Installing SMS 2003 SP3 with a Remote SQL 2005 SP2 backend



Nevermind. I discovered that even though the SQL back end is on a seperate
susytem, SMS 2003 cannot hook into it because is 64 bit.

"Michael" wrote:

We are having issue getting this to work. When using the advanced security
option durning the install we receive the following error:

Either the SQL Server is in a Windows NT 4 domain or this computer's machine
account does not have Administrator's privileges on the SQL Server. To
install a site in advanced security, all servers must be in Active Directory
and the site server's machine account must have Administrator's privileges on
the SQL Server.

We have added the sms site server machine account to the local administrator
on the SQL server. We have reviewed all the associated articles and even
performed the SPN assignment and still cannot get past this point.

I backed out the installation and used the standard security model with a
service account and it worked correctly that way but I would prefer using the
advanced client model as recommended by Microsoft.

Can anyone provide any insight as to why this is not working correctly?

All servers are running Windows 2003 with SP2 and upto date patches. The
SQL is on 64 bit and the sms is on 32 bit
.



Relevant Pages

  • Cannot install SMS2003 Primary Site with SQL2000sp3a
    ... we got problems installing SMS 2003. ... it always pop a window say cannot locate the SQL Database or you dont have ... but we build that SQL Server 2000 sp3a right ...
    (microsoft.public.sms.setup)
  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... I moved every table I was able to move to the SQL ... closed connections - but all of these errors are in the version which used ... the SQL Server 2000 and everything worked ... communication between ODBC (OLEDB and Native Client, ...
    (microsoft.public.sqlserver.connect)
  • 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: Moving SMS SQL Database
    ... We have a customer running SMS 2003 in Advanced Security with a remote SMS ... SQL database. ... They need us to move the database to a different server. ... groups and permissions referencing the OLD SQL Server ...
    (microsoft.public.sms.admin)
  • Re: SMS Maintenance Tasks missing
    ... Wait about 10 minutes and run ACLRESET (on both the SMS and SQL server). ... >>> installed SMS 2.0 with sp1 first which included the maintenance tasks? ...
    (microsoft.public.sms.setup)

Loading