You can change your login name via t-sql. Heres a link on it.

http://msdn.microsoft.com/en-us/library/ms189828.aspx

The ISO is probably just the first cd. You most likely wont need the second cd to do the edition upgrade and therefore done need to worry about the folder...

I have had to do an install from hard disk before. You can try these steps, but they are from SQL 2005. This should still be relevant though.

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

Just make sure...

Theres an ftp task in SSIS, but if you cannot log onto the website to download the file then another way would be to create a SQL job. You could...

to make sure the single user command works you could run this, which will rollback any transactions that are running on the database.

ALTER DATABASE [YourDbName]

SET SINGLE_USER WITH ROLLBACK IMMEDIATE;

More details...

That would be for an in-place upgrade.

I would recommend installing fresh instances of SQL 2008 on new servers and migrating the databases over. You will encounter less headaches this...

Hi,

Please explain how you are trying to connect. If from a remote server you will need to make sure tcp/ip or named pipes are turned on in the sql configuration...

My understanding of using the overwrite is the file is replaced with the restored database.

You do not need to change the policy settings for this service account. What HowardW mentioned should be all you need to do. Here are the basic steps.

1. Just log...

if you use the overwrite option during the restore then it will succeed, but the data will be overwritten. Thats the only way I could see the restore being successful....

Check the folder path that you defined in the Define Maintanence Cleanup Task window. The sql service account will need permissions to this folder. Also this path cannot be blank,...

I am talking about the second book you posted. That is a great book for this exam.

Ive used the training kits in the past for the '05 exams and they are great. Im studying right now for the 70-432 and im using the MCTS-Self-Paced-Training-70-432-Pro-Certification book. I...

It sounds like a database with that name already exists on the test server. You can choose a different name or on the Restore wizard go to options and click...

sorry didnt realize this was a dead thread...