Logout takes 20 minutes?

I have a problem where our middle tier and all clients connected to it stops
responding for 5 to 20 minutes once or twice a day.
I now did a Profiler trace and saw that there is an Audit Logout entry with
the following data:
EventClass:Audit Logout
CPU:3641
Reads:203866
Writes:0
Duration:1272060
Can anybody tell my why this sometimes take so long, and how to stop it?
Thanx,
ErrolThe logout event duration is the amount of time the user was logged in and
is not directly related to your problem.
Check for rpc completed and batch completed events for exceptionally long
durations. The symptoms you describe may be related to blocking so check
for blocked processing using sp_who2.
Hope this helps.
Dan Guzman
SQL Server MVP
"Errol Terblanche" <Errol Terblanche@.discussions.microsoft.com> wrote in
message news:54DCBF8F-DBFC-41D5-9062-78D64DA01799@.microsoft.com...
>I have a problem where our middle tier and all clients connected to it
>stops
> responding for 5 to 20 minutes once or twice a day.
> I now did a Profiler trace and saw that there is an Audit Logout entry
> with
> the following data:
> EventClass:Audit Logout
> CPU:3641
> Reads:203866
> Writes:0
> Duration:1272060
> Can anybody tell my why this sometimes take so long, and how to stop it?
> Thanx,
> Errol
>|||Also check for any processes that are in rollback state. You might have
uncommitted transactions that are rolling back.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:Ou9V1enwEHA.1192@.tk2msftngp13.phx.gbl...
> The logout event duration is the amount of time the user was logged in and
> is not directly related to your problem.
> Check for rpc completed and batch completed events for exceptionally long
> durations. The symptoms you describe may be related to blocking so check
> for blocked processing using sp_who2.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Errol Terblanche" <Errol Terblanche@.discussions.microsoft.com> wrote in
> message news:54DCBF8F-DBFC-41D5-9062-78D64DA01799@.microsoft.com...
>|||I have looked for blocks in the Process Info window, but there where none.
I will get a more complete trace to see if i can see anything else.
There are no Batches that took more that 170ms.
I'm starting to think it might be ADO as the middle tier sets up the
connection but it hangs at the connection.connect statement. When this
happens all users that connect gets a connection assigned to them but they
all hang at the connection.connect statement. The connection is set up to
timeout after 15 seconds, but this doesn't happen so i don't think it is
truely a connection problem. After some time all the pending connections
suddenly open, practically all at once.
I have also set up a second middle tier connecting to the same database and
it runs fine and connects promptly even when the first middle tier is
hanging...
Any advice?
Thanx,
Errol
"Mike Epprecht (SQL MVP)" wrote:

> Also check for any processes that are in rollback state. You might have
> uncommitted transactions that are rolling back.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:Ou9V1enwEHA.1192@.tk2msftngp13.phx.gbl...
>
>

logon window

Hi,
Whenever I click on a report to open it, it asks me for my Windows user ID
and password. I am connected to my desktop using my domain account and
report server is installed on SQL Server (domain controller as well).
The report is using NT authentication method.
Does anybody know how can I get rid of the login information window?
ThanksHi,
If You are using a shared datasource then rightclick on the datasource
->open
In the credentials tab check what is the option selected it should be "Use
Windows Authentication(integrated security)" If you have windows
authentication for you Sql server. If the option selected in this tab is
"Prompt for credentials" then the report promt for user credentials every
time it launches.
Incase u are not using shared datasource then u canget the above tab from
the data tab of the reportdesigner and then browsing on the datasource
dropdown.
Leme know if this solves ur problem
Thanks,
siaj
"Alex" wrote:
> Hi,
> Whenever I click on a report to open it, it asks me for my Windows user ID
> and password. I am connected to my desktop using my domain account and
> report server is installed on SQL Server (domain controller as well).
> The report is using NT authentication method.
> Does anybody know how can I get rid of the login information window?
> Thanks
>
>|||Make sure that your IE and IIS settings are correct. Within IE go to tools
internet options and then security. You will want to make sure the RS web
site is in your local intranet zone. Once it is there, make sure that the
"User Authentication" section of the settings are set to "Automatic logon
with current username and password." This tells IE to send the username and
password to the server. On IIS make sure that "Integrated Windows
authentication" is checked for the web site and uncheck the remaining boxes.
"Alex" wrote:
> Hi,
> Whenever I click on a report to open it, it asks me for my Windows user ID
> and password. I am connected to my desktop using my domain account and
> report server is installed on SQL Server (domain controller as well).
> The report is using NT authentication method.
> Does anybody know how can I get rid of the login information window?
> Thanks
>
>|||Thanks. This one solved my problem.
"MAGrimsley" <MAGrimsley@.discussions.microsoft.com> wrote in message
news:11CE3B20-F0A0-4A9C-84D2-2DDDA6B3C226@.microsoft.com...
> Make sure that your IE and IIS settings are correct. Within IE go to tools
> internet options and then security. You will want to make sure the RS web
> site is in your local intranet zone. Once it is there, make sure that the
> "User Authentication" section of the settings are set to "Automatic logon
> with current username and password." This tells IE to send the username
and
> password to the server. On IIS make sure that "Integrated Windows
> authentication" is checked for the web site and uncheck the remaining
boxes.
>
> "Alex" wrote:
> > Hi,
> >
> > Whenever I click on a report to open it, it asks me for my Windows user
ID
> > and password. I am connected to my desktop using my domain account and
> > report server is installed on SQL Server (domain controller as well).
> > The report is using NT authentication method.
> > Does anybody know how can I get rid of the login information window?
> >
> > Thanks
> >
> >
> >|||I have the same problem... and tried your suggestions with no luck.
Administrators and users can browse the Reports application. Administrators
can view the reports, but users get an authentication prompt.
Both the Reports and ReportServer application use Windows Integrated Auth
and have Anonymous disabled.
What would the difference be if the user can view Reports but not
ReportServer? (I tried https://{server}/ReportServer and still got the prompt)
There's got to be some difference between
"Alex" wrote:
> Thanks. This one solved my problem.
> "MAGrimsley" <MAGrimsley@.discussions.microsoft.com> wrote in message
> news:11CE3B20-F0A0-4A9C-84D2-2DDDA6B3C226@.microsoft.com...
> > Make sure that your IE and IIS settings are correct. Within IE go to tools
> > internet options and then security. You will want to make sure the RS web
> > site is in your local intranet zone. Once it is there, make sure that the
> > "User Authentication" section of the settings are set to "Automatic logon
> > with current username and password." This tells IE to send the username
> and
> > password to the server. On IIS make sure that "Integrated Windows
> > authentication" is checked for the web site and uncheck the remaining
> boxes.
> >
> >
> > "Alex" wrote:
> >
> > > Hi,
> > >
> > > Whenever I click on a report to open it, it asks me for my Windows user
> ID
> > > and password. I am connected to my desktop using my domain account and
> > > report server is installed on SQL Server (domain controller as well).
> > > The report is using NT authentication method.
> > > Does anybody know how can I get rid of the login information window?
> > >
> > > Thanks
> > >
> > >
> > >
>
>|||I had to set up the user/group in question with permissions to Reports and
ReportServer in IIS.
"Peter Capazzi" wrote:
> I have the same problem... and tried your suggestions with no luck.
> Administrators and users can browse the Reports application. Administrators
> can view the reports, but users get an authentication prompt.
> Both the Reports and ReportServer application use Windows Integrated Auth
> and have Anonymous disabled.
> What would the difference be if the user can view Reports but not
> ReportServer? (I tried https://{server}/ReportServer and still got the prompt)
> There's got to be some difference between
> "Alex" wrote:
> > Thanks. This one solved my problem.
> >
> > "MAGrimsley" <MAGrimsley@.discussions.microsoft.com> wrote in message
> > news:11CE3B20-F0A0-4A9C-84D2-2DDDA6B3C226@.microsoft.com...
> > > Make sure that your IE and IIS settings are correct. Within IE go to tools
> > > internet options and then security. You will want to make sure the RS web
> > > site is in your local intranet zone. Once it is there, make sure that the
> > > "User Authentication" section of the settings are set to "Automatic logon
> > > with current username and password." This tells IE to send the username
> > and
> > > password to the server. On IIS make sure that "Integrated Windows
> > > authentication" is checked for the web site and uncheck the remaining
> > boxes.
> > >
> > >
> > > "Alex" wrote:
> > >
> > > > Hi,
> > > >
> > > > Whenever I click on a report to open it, it asks me for my Windows user
> > ID
> > > > and password. I am connected to my desktop using my domain account and
> > > > report server is installed on SQL Server (domain controller as well).
> > > > The report is using NT authentication method.
> > > > Does anybody know how can I get rid of the login information window?
> > > >
> > > > Thanks
> > > >
> > > >
> > > >
> >
> >
> >