Re: Security Question - Totally Stumped

I would recommend to disjoin the server via properties (add it to a
workgroup), then delete the computer account on the SBS box, create a new
account and use the "ConnectComputer" to join the server back into the
domain. This is the proper way of doing it in an SBS environment and I'm
pretty sure you will not have the same problems afterwards.

--
Claus
"Richard K" <Rkokoski@xxxxxxxxx> wrote in message
news:eB7J8igYIHA.6140@xxxxxxxxxxxxxxxxxxxxxxx
I have done it both ways (from SERVER2 join the domain via My
Computer/Properties and provide credentials) and (from SERVER1 add SERVER2
then go to connectcomputer from SERVER2) with the same result. When doing
the 2nd option of going to connectcomputer I do get a message of "this
computer has already joined the domain" so not sure what ConnectComputer
should do here for the SERVER2.

What's strange is SERVER1 (SBS 2003 box) SERVER2 looks perfect. I can
even go to SERVER2 and log in using the domain credentials. I know
something is not quite right but I'm lost as to what to turn to next.


"Claus" <cjobes@xxxxxxxxxxxxx> wrote in message
news:u5ln1egYIHA.4448@xxxxxxxxxxxxxxxxxxxxxxx
When you joined the server into the domain, did you use "connectcomputer"
or did you do this manually?

--
Claus
"Richard K" <Rkokoski@xxxxxxxxx> wrote in message
news:eLn0JFgYIHA.4696@xxxxxxxxxxxxxxxxxxxxxxx
Setup: Domain = MyDomain, SERVER (SBS 2003 R2), SERVER2 (Windows 2003
R2, SQL 2005)

SERVER2 has joined to the SBS domain (verified by looking at the AD on
SERVER).

When I log into SERVER2 using the Admin credentials of the domain
(Mydomain\administrator) no problem. When I open up IE from SERVER2 and
try to hit CompanyWeb running off of SERVER in the SBS domain I get
prompted for credentials instead of just going to the web site. I can
put in "MyDomain\Administrator" and password and it opens up Companyweb
no problem, but why am I even prompted? I logged in under a domain
account.

To add to this SERVER2 also has SQL 2005 with Reporting Services. With
using the same MyDomain\Administrator login I try and hit
http://SERVER2/Reports and again I am prompted for credentials instead
of going directly to the site. I can put in credientals and it
continues. I even log in as the local Admin and the same thing happens.
I have looked at the group memberships and I can't see a problem. Just
to add to this I can go to any XP workstation and login as
MyDomain\Administrator and no problem hitting CompanyWeb or
http://SERVER2/Reports. Finally, I even try another domain account that
has domain admin privledges and get the same results so it's something
with this machine.

Where this is causing me a problem is that I cannot install CRM
Professional on SERVER2 because it says it cannot see the SQL Report
Server and I know it's because it can't go directly to the site and
instead looking for credentials. Since I didn't have much important
stuff on SERVER2 I even re-installed the OS thinking something to hosed
but I get the same results.

I'm totally lost on where to turn for answers on this one. I've wasted
DAYS on this one.

Thanks for any help or guidance.

-Richard K








.

Relevant Pages

  • Re: Security Question - Totally Stumped
    ... I've found the answer thanks to Merv in the SBS ... machine as the admin or through the domain admin account I can't even ... to take the local admin account on server2 and not the domain account ... "ConnectComputer" option. ...
    (microsoft.public.windows.server.sbs)
  • Re: Security Question - Totally Stumped
    ... admin or through the domain admin account I can't even hit the Reporting ... take the local admin account on server2 and not the domain account (which I ... Then delete the account on the SBS. ...
    (microsoft.public.windows.server.sbs)
  • RE: Login failed for user (null). Reason: Not associated with a trusted SQL Server connection.
    ... If server2 and serv3 are not on a domain what account are you using to log ... Are you using pass-thru authentication? ... Enable security account auditing on your Server2 box to see what account ...
    (microsoft.public.sqlserver.connect)
  • Re: Security Question - Totally Stumped
    ... reporting service it depends what you have set the default domain login ... to take the local admin account on server2 and not the domain account ... Then delete the account on the SBS. ...
    (microsoft.public.windows.server.sbs)
  • Re: Security Question - Totally Stumped
    ... reporting service it depends what you have set the default domain login to. ... take the local admin account on server2 and not the domain account (which ... Then delete the account on the SBS. ...
    (microsoft.public.windows.server.sbs)
Loading