Can't acess RS2005 in a domain environment?!

hi,
I have installed SQL 2005 on server A and RS 2005 on server B.
server C is the domain controller.
Every thing works fine when i browse the virtual directories on the local
machine (B).
When i try to acess RS virtual directories from my XPSP2/IE7 workstation i
am prompted for windows credentials, but i keep getting "You are not
authorize to view this page" even though my domain account is a memeber of
Administrators on RS2005 server B. it happens with other XP clients as well.
Why is that? What is wrong here?
the RS2005 has its default installation base on the windows authentication
method for the virtual directories.
rs2005 settings are:
website: defaul
SSL: NO
Windows service identity: Local system
Web service identity: application pool "ap1" with my domain account (member
of local admin group)
db setup: SQL server login = 'sa'
thanks in advance
rafiOn Jan 9, 4:39 am, Rafi <R...@.discussions.microsoft.com> wrote:
> hi,
> I have installed SQL 2005 on server A and RS 2005 on server B.
> server C is the domain controller.
> Every thing works fine when i browse the virtual directories on the local
> machine (B).
> When i try to acess RS virtual directories from my XPSP2/IE7 workstation i
> am prompted for windows credentials, but i keep getting "You are not
> authorize to view this page" even though my domain account is a memeber of
> Administrators on RS2005 server B. it happens with other XP clients as well.
> Why is that? What is wrong here?
> the RS2005 has its default installation base on the windows authentication
> method for the virtual directories.
> rs2005 settings are:
> website: defaul
> SSL: NO
> Windows service identity: Local system
> Web service identity: application pool "ap1" with my domain account (member
> of local admin group)
> db setup: SQL server login = 'sa'
> thanks in advance
> rafi
Are you allowing anonymous access to the Reports and ReportServer
virtual directories? This could be the problem. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||no. anonymous access is not enabled.
only "Integrated windows auth.." is marked.
i always prompted for my domain credentials when using a browser from XP
xlient while i am loged in with my domain account
still need help!
Rafi
"EMartinez" wrote:
> On Jan 9, 4:39 am, Rafi <R...@.discussions.microsoft.com> wrote:
> > hi,
> >
> > I have installed SQL 2005 on server A and RS 2005 on server B.
> > server C is the domain controller.
> > Every thing works fine when i browse the virtual directories on the local
> > machine (B).
> >
> > When i try to acess RS virtual directories from my XPSP2/IE7 workstation i
> > am prompted for windows credentials, but i keep getting "You are not
> > authorize to view this page" even though my domain account is a memeber of
> > Administrators on RS2005 server B. it happens with other XP clients as well.
> >
> > Why is that? What is wrong here?
> >
> > the RS2005 has its default installation base on the windows authentication
> > method for the virtual directories.
> >
> > rs2005 settings are:
> > website: defaul
> > SSL: NO
> > Windows service identity: Local system
> > Web service identity: application pool "ap1" with my domain account (member
> > of local admin group)
> > db setup: SQL server login = 'sa'
> >
> > thanks in advance
> >
> > rafi
>
> Are you allowing anonymous access to the Reports and ReportServer
> virtual directories? This could be the problem. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||Check the following:
ReportServer and Reports virtual directory should set for windows
authentication.
Start a command prompt, then navigate to the C:\Inetpub\Adminscripts
folder
where the adsutil.vbs located.
Check the authentication providers with this in the command prompt:
cscript
adsutil.vbs get w3svc/NTAuthenticationProviders
If you get "The parameter "NTAuthenticationProviders" is not set at
this
node" message, then type cscript adsutil.vbs set
w3svc/NTAuthenticationProviders "NTLM" in cmd. After this try to open
the
report manager from a remote machine.
I hope this solves the problem.
Regards,
Bob
On Jan 13, 1:53=A0am, Rafi <R...@.discussions.microsoft.com> wrote:
> no. anonymous access is not enabled.
> only "Integratedwindowsauth.." is marked.
> i always prompted for my domain credentials when using a browser from XP
> xlient while i am =A0loged in with my domain account
> still need help!
> Rafi
>
> "EMartinez" wrote:
> > On Jan 9, 4:39 am, Rafi <R...@.discussions.microsoft.com> wrote:
> > > hi,
> > > I have installed SQL 2005 on server A and RS 2005 on server B.
> > > server C is the domain controller.
> > > Every thing works fine when i browse the virtual directories on the lo=cal
> > > machine (B).
> > > When i try to acess RS virtual directories from my XPSP2/IE7 workstati=on i
> > > am prompted forwindowscredentials, but i keep getting "You are not
> > > authorize to view this page" even though my domain account is a memebe=r of
> > > Administrators onRS2005server B. it happens with other XP clients as w=ell.
> > > Why is that? What is wrong here?
> > > theRS2005has its default installation base on thewindowsauthentication=
> > > method for the virtual directories.
> > >rs2005settings are:
> > > website: defaul
> > > SSL: NO
> > >Windowsserviceidentity: Local system
> > > Webserviceidentity: =A0application pool "ap1" with my domain account (=member
> > > of local admin group)
> > > db setup: SQL server login =3D 'sa'
> > > thanks in =A0advance
> > > rafi
> > Are you allowing anonymous access to the Reports and ReportServer
> > virtual directories? This could be the problem. Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant- Hide quoted text -
> - Show quoted text -

Cannot start Log Reader Agent and Snapshot Agent

I am testing peer to peer replication in our environment. I simulated a three node peer to peer topology and a local distributor.

For some wierd reason I cannot get the Log Reader Agent and snapshot agent to start. The domain account under which SQL Server Agent runs has administrator previlage on the box. I also use a domain account for SQL Server Service. (none of the passwords changed).

This is the error I am getting - "Executed as user: abc. A required privilege is not held by the client. The step failed"

Any ideas?

Also this domain account is a member of

SQLServer2005MSSQLUsers$ServerName$MSSQLSERVER

SQLServer2005MSAgentUser$ServerName$MSSQLSERVER

open the properties of each job and change the owner to sa and it should work fine.|||I tried it. No luck...it gives the same error message

Cannot re-read data in column 2

Hi,

I'm connecting to my SQL Server via Java in my Notes environment, but when I try to update my Notes-documents I get an error fra SQL Server saying that it can not re-read data from column 2.

Without being absolutely certain - I'm quite sure that the code is valid.

Does anyone know what the error means ?

Thanks in advance

Kim HansenHi,

I'm connecting to my SQL Server via Java in my Notes environment, but when I try to update my Notes-documents I get an error fra SQL Server saying that it can not re-read data from column 2.

Without being absolutely certain - I'm quite sure that the code is valid.

Does anyone know what the error means ?

Thanks in advance

Kim Hansen

there is this KB on this error:
http://support.microsoft.com/default.aspx?kbid=824106