all groups > sql server reporting services > august 2006 >
You're in the

sql server reporting services

group:

User Credential Logon Information


User Credential Logon Information Praveen Chand
8/1/2006 7:16:01 AM
sql server reporting services:
Hello,
We have the following configuration:
1. Windows 2003
2. SQL Server 2000 Standard Edition
3. We don't have the domain setup.
4. We are using the Data sources option "Credentails Stored securely in the
report server".

Currently RS reports are working fine in Windows 2000 environment with user
authentication prompt. When we deployed the reports in Windows 2003 the
reports prompts for the user authentication.

We don't want the user authentication prompt.

Can anyone please share the knowledge how we could avoid the user
authentication prompt and why we are facing this problem in Windows 2003
environment only?

Let us know if you need more information.

RE: User Credential Logon Information David Bienstock
8/24/2006 9:10:02 AM
I found http://support.microsoft.com/kb/896861/ but it didn't work for me on
the server side... I haven't tried it on the XP-SP2 side.

Did you get yours fixed?
--
"Everyone knows something you don't know"


[quoted text, click to view]
Re: User Credential Logon Information David Bienstock
8/24/2006 10:03:01 AM
Unfortunately since 2003-SP1 it occasionally does it... and for me, we are
using a fixed IP load balanced configuration
--
"Everyone knows something you don't know"


[quoted text, click to view]
Re: User Credential Logon Information Bruce L-C [MVP]
8/24/2006 11:32:12 AM
Here is something I wrote awhile back: I had a case where the issue was that
the server (it was a test server) was using DHCP (dynamic tcpip address
instead of fixed). When I went to a fixed IP address the probelm went away.
Obscure but thought I would mention it.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

AddThis Social Bookmark Button