Re: New SMS 2003 install - Unable to connect to database

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

"Joshua" <Joshua@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B01D0927-6B2A-451F-B7E6-40F6F5B4E7AE@xxxxxxxxxxxxxxxx
We are working to setup another sms2003 primary site and it is connecting
to
a remote sql server 2005 database. When we open the admin console, it
fails
immediately with an error connecting to the database. What have we done
wrong?

Just replied to you on an older thread...

Try adding your SMS server's computer account in the local administrators
group on the remote sql server.

Installation is a lot easier when SQL and SMS are on the same server.


Steve


.

Relevant Pages

  • Re: New SMS 2003 install - Unable to connect to database
    ... a remote sql server 2005 database. ... When we open the admin console, it fails immediately with an error connecting to the database. ... Kim Oppalfens - Sms Expert for lack of any other expertise ...
    (microsoft.public.sms.setup)
  • SQL + Browse directory list
    ... if you have a remote SQL Server ... choose 'New Database', in the 'Data Files' tab and press the ...
    (microsoft.public.vb.winapi.networks)
  • SQL - Browse directory List
    ... if you have a remote SQL Server ... choose 'New Database', in the 'Data Files' tab and press the ...
    (microsoft.public.vb.winapi)
  • Re: RF connection handling.
    ... but writes to the database need to be performed ... you are in range and sync between the local store to the remote SQL Server ... Sync Services for ADO.Net, currently in beta, is designed to help ... could simply try to open a database connection before performing any ...
    (microsoft.public.sqlserver.ce)
  • RE: SQL Server CE and PDA and C#
    ... You can indeed create a SQL CE database and use it locally on device without ... ever using a remote SQL Server database. ... you can only have a single open connection to the ... > I wanna test some things with my Pocket PC 2003 based PDA and SQL Server CE. ...
    (microsoft.public.pocketpc.developer)