Can someone help me out please...

Thanks and Regards,

Ravichandra.

Thanks GailShaw !!

Can you suggest me on the below please

http://www.sqlservercentral.com/Forums/Topic1030483-146-1.aspx

Regards,

Ravichandra.

Thanks for your reply.

I think, this could be due to worker threads not available to process the incoming login.

select max_workers_count from sys.dm_os_sys_info -- 288 [ it has been set to...

Dear All,

Kindly advise me on this.

Thanks and Regards,

Ravichandra.

Thanks Pradeep.

Can you clear this up for me please.

Regards,

Ravichandra.

Thanks Pradeep,

Iam facing the below error after changing the Max Worker Threads Setting from 500 to 0.

In Event viewer and SQLServerLog

Error: 18456, Severity: 14, State: 27.Login failed for user...

Dear All,

Can some one help me out please

Please find the some more information.

-------------------------------------------------------

CPU Usage -- 100 % and Physical memory -- 89% and Nework utilization -- 0.06%.

OS -> ...

Dear All,

Can someone please help me out.

For your information:

-------------------------

CPU Usage -- 100 % and Physical memory -- 89% and Nework utilization -- 0.06%.

O/s -- ->Microsoft(R) Windows(R) Server 2008,...

Can someone advise me on this.

Your quick response is much appreciated.

Thanks and Regards,

Ravichandra.

Dear Jason,

Please find the information.

Maximum number of councurrent connections -- > 0 [ server properites]

Memory -->32 GB

Minimum Server memory --> 10240 MB

Maximum Server memory --> 30720 MB

Thanks and Regards,

Ravichandra.

Thanks Jason,

But I can see hotfix is for SP2 in "http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=937745&kbln=en-us"

Our environment

------------------

SQLServer2005 -- Standard Edition X86 platform

select serverproperty('productlevel') ---> SP3

select serverproperty('productversion') --->9.00.4053.00

Please advise.

Thanks and Regards,

Ravichandra

Can someone help me out on this please

Thanks and Regards,

Ravichandra.

Dear All,

Please advise on the below errors.

Your quick response is much appreciated.

ERROR:1

-----------------

2010-11-29 10:10:55.08 Logon Login failed for user 'xxxxxx'. [CLIENT: 192.168.30.180]

2010-11-29...

Dear Pradeep,

Thanks.

When I ran a the below query on two different servers I got the below result.

Please advise why it's showing different product versions for SQLServer 2005 ServicePack 3? and...

Thanks Jason.

Even I got the same solution from Google;but,I want to know what is the cause behind this issue.

Please advise.

Regards,

Ravichandra.