Re: Security Question - Totally Stumped

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
    ... As I said earlier when I did this and used the ConnectComputer ... then go to connectcomputer from SERVER2) with the same result. ... SERVER2 has joined to the SBS domain (verified by looking at the AD on ... When I log into SERVER2 using the Admin credentials of the domain ...
    (microsoft.public.windows.server.sbs)
  • Re: transaction log shipping wizard uses wrong computer name?
    ... I'm still hoping someone can point me to a solution here...It looks like the "jobserver" name is an alias to the machine name that SQL Agent is running on...I presume that the SQL agent picked this up when I first installed SQL2005 on the server before it was joined to the domain. ... I'm configuring log shipping on server1 and backingup/restoring to server2. ...
    (microsoft.public.sqlserver.tools)
  • Security Question - Totally Stumped
    ... SERVER2 has joined to the SBS domain (verified by looking at the AD on ... When I log into SERVER2 using the Admin credentials of the domain ... To add to this SERVER2 also has SQL 2005 with Reporting Services. ...
    (microsoft.public.windows.server.sbs)
  • New Server Cannot See Out
    ... We have a network setup in location 2 where we are doing development and also have a server in that location (everything at location 2 is behind the same firewall). ... There is a new server in location 2 running Windows 2003 Server and SQL Server 2005. ... The problem is that Server2 cannot see Server1, ... Also, any of the Dev machines can see and connect to Server2 as well, but Server1 cannot. ...
    (microsoft.public.sqlserver.connect)
  • Error 18456, State 28000
    ... Running SQL Server 2000... ... On server2, i have the exact same group set up... ... users in this group doesn't get recognized by my new sql installation. ... get the error above (SQL Error 18456, ...
    (microsoft.public.sqlserver.security)