that is something I really want to include

SQL Server Management Studio

download SQL 2005 eval version.  When you run the exe file it created 2 folder: Servers and Tools.  Run the setup file in Tool folder to install...

MS KBs shows you how to move system databases in SQL 2000.  For SQL 2005 there must be a way but I haven't seen one.

To move user databases you can...

If you wants new default location at D:\Program Files\Microsoft SQL Server\MSSQL you must manually create the folder first if it doesn't exist.  I do this way every time I install SQL...

In SQL Server Management Studio, once you register and connect to the sql server, right click on the server name, click on Properties, then Database Settings.  There you will see...

thanks.

I have SQL2K SP3.  Need to confirm MS03-031 if installed and got loss in the loop on MS site. 

Deni,

If Anonymous access removed, RS uses Intergrated Windows Authentication. We have an AD. A user, usually a manager or above, who read the report must provide the ID...

it sounds a dump question!  I had a problem with installing RS dus to a bug in http://support.microsoft.com/kb/887787.   Glad to had it fixed. 

I tried removing and adding .1 but it didn't change.  Silly thing is it worked yesterday. 

ID:Q167833 is from the original string he got from internet.  It's existing also didn't make any...

I got it works.  Same configuration as in original post.  And very same setup following http://support.microsoft.com/default.aspx/kb/247931 that didn't work few days ago but now. 

I still don't have it work

Does it matter when the IIS isn't part of the AD?

Hmm, I don't see pros with that setup.  IIS and SQL in DMZ, only public info on SQL!  What happen when IIS needs to look up SSN or DOB?  There must be...

One thing: do you really want that a web user from the outside will be able to access SQL Server inside ? It may be a major security issue....

it is used mostly for IIS.  IIS and SQL boxes are sitting together at a data center.  The only VB app accessing SQL is at the HQ but on VPN when...