Re: SMS Setup Fails - Remote SQL Admin rights

Problem is resolved - finally!

Although we had already verified DNS records earlier on it turned out to be
DNS causing the problem after all: we discovered an old record in one of the
reverse lookup zones. Same IP but different hostnames.

"Garth" wrote:

What is the error that you get?
Have you tested to ensure that the computer account is a full admin on the
SQL box by using the AT commandlien trick?

"TimDK" <TimDK@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:875647E9-9C95-46B8-A8BE-86B1C36254BE@xxxxxxxxxxxxxxxx
SQL is not clustered ...

"Garth" wrote:

It sound like you are trying to setup SMS on a SQL clusters, if this is
the
case this is unsupported and will not work.


"TimDK" <TimDK@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6DE9E485-5381-4292-95AC-E295CE007047@xxxxxxxxxxxxxxxx
I'm working on the installation of SMS2003 SP3. The SQL DB is hosted on
a
remote server.

When running the SMS2003 setup (advanced security) an error occurs: it
appears as if the local computer has no rights on the SQL server
although
I've verified and made sure the computer account is a member of the
local
administrators on the SQL box.

Both servers are fresh windows2K3 installations and no other software
(except SQL2005) is installed on them. Both servers also reside in the
same
location so there are no firewalls involved.

Strangely enough I've tried running the SMS installation on a 3rd box
in
the
environment using the same SQL backend and there the installation went
smoothly. I used the same procedure to do the installation and all I
basically did was adding the computer account of the SMS server to the
local
admins of the SQL box.

Anybody has any ideas on how to further troubleshoot and fix this ... ?


.

Relevant Pages

  • RE: Server cant be seen from the network
    ... Microsoft CSS Online Newsgroup Support ... I discovered that if I turned the SQL server ... NAT issues caused with the installation of the "full" SQL ...
    (microsoft.public.windows.server.sbs)
  • Help Please with a step by step keystroke by keystroke(or Mouse) illustration on how to setup a stan
    ... the most typical for the average developer wanting to push .Net SQL driven ... did it would involve a domain server, ... client network utility force protocol encryption is NOT checked) ... Please give a complete account of the standalone CA installation as this ...
    (microsoft.public.sqlserver.security)
  • RE: Server cant be seen from the network
    ... I did allow the accounting tech to ... After the "full" SQL server was loaded, ... NAT issues caused with the installation of the "full" SQL server/services, ...
    (microsoft.public.windows.server.sbs)
  • Re: installing help for sql 2005
    ... Now i installed the sql server2005 on one of my ... server and its running fine but i am now getting an other problem which is ... installation help with snap shots because i installed the sql server 2005 ... remote connections are disabled by default. ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server 2005 Beta running on Windows XP Professional set up iss
    ... >loading a beta version of SQL Sever 2005 onto Windows XP Pro SP2. ... >complimentary copy as part of a 3 CD set including Visual Studio/SQL Server ... >> The setup process appears to get 90% through the installation but always ... >> that it may not be suitable to support the beta edition of SQL Sever 2005. ...
    (microsoft.public.sqlserver.setup)
Loading