Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Services / Reporting Services / April 2006

Tip: Looking for answers? Try searching our database.

Windows Authentication Problem

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Cayman Visitor - 27 Apr 2006 00:18 GMT
I'm having problems with Windows Authentication in RS 2000.  This is on a
brand new server.  Here is the setup I've done.

-Install Win2003 SP1 (install all updates to be current)
-Install IIS (with ASP.NET and FrontPage extensions)
-Install VS.NET 2003
-Install SQL 2000 (with SP4)
-Install Reporting Services 2000 (with SP2)

Besides that all is defaults (no annoyomous access and windows
authentication on RS sites).  However, when I try to access the report server
(http://localhost/reports) I am asked for my login credentials (I'm logged in
as Domain Admin which is also local admin).  I'm using IE6 which has "Enable
Windows Authentication" properly set.

I have no idea why I'm getting prompted for login info, any ideas?  My
domain controller is running Win2000.  I'm just at a loss why this isn't
working seemlessly!
Kaisa M. Lindahl Lervik - 28 Apr 2006 07:37 GMT
What do you mean by "  I'm using IE6 which has "Enable  Windows
Authentication" properly set."?
There are 4 different settings for User Authentication in IE, and all of
these are depending on what security zone your site is in.

I'd suggest adding http://localhost/ to Trusted sites, and set the User
Authentication to "Automatic logon with current username and password" for
this security zone. That should fix your login problem.
The User Authentication is at the bottom of the Security Settings list.

Kaisa M. Lindahl Lervik

> I'm having problems with Windows Authentication in RS 2000.  This is on a
> brand new server.  Here is the setup I've done.
[quoted text clipped - 17 lines]
> domain controller is running Win2000.  I'm just at a loss why this isn't
> working seemlessly!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.