After a  long time failing to find a solution to the MSSQL Server 2005
Reporting Services not working on a Windows Server 2008/IIS 7, I was eager to
test MSSQL 2008. It worked like a charm!
Unfortunately I'm deadlocked with this message when I want to add features:

i am getting an unusual number of failed anonymous logon entries in a cloned
vmware image of a sqlserver 2005 installation on windows 2003 server.
is there anything i can do to terminate or get rid of these messages? i've
already changed machine name and all the anonymous user ...

I have recently upgraded from SQL 05 Workgroup to Standard and now want to
install the Reporting Services.
Unfortunately the installer still warns me that I am running Workgroup
despite me being able to confirm standard is installed using:

Hi I have a 2005 sql database that I have been logging into using windows
authentication.  I now can not log in, get the server error 18456.   My
password changed to log onto my machine (windows authentication) so wondering
if something needs to be reset in SQL or would it ...

Does anyone know how to determine what components and options were installed
for a SQL server 2000/2005 instance.
Sure this is written to some output files during the setup process, but they
might be long gone.

I have been using SQL2005 on my local machine for some time without any
problems.  For some reason I get access denied when I go to the control panel
services, SQLServer and try to stop the service.  This may be related to my
previous post, server error 18456, thanks!

Are there any guidelines available on how best to allocate RAM on a Win2008
Ent. x64 server with 64GB RAM and SQL 2005 Ent. x64?
Specifically, is it best to leave it dynamic or to reserve some for the OS
by limiting the maximum for SQL Server?

I have Windows 2003 Server x64 machine with SQL Server 2005 Express Edition
with Advanced Services with Service Pack 2 installed. I want to upgrade it
to SQL Server 2005 Standard Edition x64.
Yet, this upgrade is disabled. The Express Edition is 32bit and has Service

I think I'm having a problem with a cluster install of SQL Server 2005.  I
have two drives on a raid array. Array 1 is designated as Drive G and the
second array is Drive H.  I want the log files to go to Drive G and the
database files to go to Drive H.  During the install, if I ...

I am hoping someone can give me some advice about the performance difference
between Multi-Channel Raid vs SAN storage.
My basic question has to do with Performance and optimization.
Assuming I have the same spec drives (size, speed, throughput, ets...) is

Would you dare to make this updating automatic ?
I just got a new job and can see that the server has not been updated for a
long time.
Best regards

We have a 4 node active SQL 2000 cluster.  Each server is running a seperate
instance of SQL.  We are in the process of finalizing our Diaster Recovery
solution.  Unfortunately I have limited resources in our DR site.  I would be
scaling down to a single SQL server at our DR site ...

Im new to the group, i require some assistance on a SQL 2005 STD Edt
installation on a windows server 2003 SP2 R2 image.
I have assigned the image 1024GB of ram. Every time i run the SQL
2005