Glad it worked out!!  Good luck and have fun!

 I don't know if this helps, but my email admin installed CRM, Reporting Services, enabled IIS and MS SQL Server 2000 backend all on one Server..  not a good...

CRM part was easy, just use the deployment manager to repoint to the new Server.  Reporting Services was more of a challenge

Take a look at this link...

http://msdn2.microsoft.com/en-us/library/ms162837.aspx

To...

Thank you so much!!!  I didn't realize that I had to install the Reporting Services Designer component on my local machine!!!!  

I am installing Visual Studio.net ENterprose Architect 2003 from...

Thank you!!!   I was just nervous about Installing a Default Instance on a box that already has 3 (Production) named Instances..  I didn't want to blow it up!  I don't...

I have used this method for moving User Databases between Instances with great success:

First I Copy the Users (with same SID and Password) using the sp_help_revlogin Stored Procedure -...

use master

go

exec sp_detach_db 'YourDB'

go

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

Move the data and log files to their new locations.

use master

go

exec sp_attach_db 'YourDB'

   , 'PATH_TO_YourDB_DATAFILE\YourDB_datafile.mdf'

, 'PATH_TO_YourDB_LOGFILE\YourDB_logfile.ldf'

go

You can find lots...

I still can't figure out where to get Reporting Services that will work with out SQL Server 2000 Standard Edition Production Install.   Someone posted a link where you can order...

On our MSDN Disk I found 2000 Reporting Services 2000 Developer Edition....

Is this what I would use in our Production environment????????  Or is there another version that I would run...

Thank you  : )

In my experience with Active/Passive Clusters running SQL Server,  I would reboot the Passive Node first.   then I would go into the Cluster Administrator and do a 'move group' over...

Thank you.   I have 3 GB of memory in this Server.   Should be sufficient..  SQL Server will only use up to 2GB (I think)

I have never shrinked this DB.  It just kind of plugs along.. It's always been slow.. and now it's getting more sluggish.   my boss called the Vendor and they said...

Thanks!  That article discusses shrinking the TEMPDB database.  Is that the same as shrinking a User DB that is set to Simple Recovery mode.?

Thank you!!!   I missed that post in my search.  It has alot of good links and I have alot of reading to do!!!!

From what I've read so far, It looks...