Hi, unfortunatly you need to download the bits you need individually so scroll down until you find the .msi files for Uupgrade Advisor (its about half way down the page),...

You can get SSMS for Express Edition

2008r2 Edition @ http://www.microsoft.com/download/en/details.aspx?id=22985

2008 @ http://www.microsoft.com/download/en/details.aspx?id=7593

Its the same for all, a domain accout with the minimum privlages, the account needs to be able to run as a service if you apply restricted group policies accross...

here you go http://www.microsoft.com/download/en/details.aspx?id=16978

opps sorry for re-posting the same thing :-p

sp_help_revlogin maybe what your looking for see this for more details:

http://support.microsoft.com/kb/246133

other option for logins is to use sp_help_revlogin

Think the index rebuild will cause your DB files to grow again

take a look at this, http://support.microsoft.com/kb/955725, clustering may be an issues as advised above but on the whole I don't see any issues

you need SQL Server Upgrade advisor, you can download it here:

http://www.microsoft.com/download/en/details.aspx?id=16978

Try this:

DBCC SHRINKDATABASE(iedb, 10);

Go

I usually find specifying the % free size works the best

The error your getting normally only occurs if your trying to connect using SQL authentication when it is not enabled.

Are you trying to connect to a named or the default...

here are a couple of things that i've found when setting this up....

1. Use FQDN's when specifying your service object e.g. setspn -A MSSQLSvc/Server_Name.sub_domain.root_domain.org.com:port domain\SQL_Service_Accont

2. MSDTC Configuration

On each SQL...

With Snapshot replication snapshots get taken at whatever interval has been setup, look at the SQL Agent job to find this. I'd personally only use this when you have...

One reason to change the port number is if your named instance needs to use kerberos delegation there's many others when you'd need to do it. My personal preference...