Copy Database from Remote SQL Server to Local Server Problem???

On a Windows Vista Home Premium system, I am trying to copy a database from a remote server to my local SQL server development machine.  I can connect to the two servers using SSMS and the Copy Database Wizard.  Once I complete all the Wizard screens and run the job I get the following error.  It has something to do with the Messenger Service for which is not installed on my Vista machine.  In the SQL Server Agent >>>> Alert System >>>> Mail Session, I have Enable Mail Profile Unchecked.  

Is there something else that needs to be done to disable the Alerts and mail session so the copy database job can successfully run???  I have the local server configured for local and remote connections and I can copy a local database.  It's only when I try to copy the database from the remote sql server.


10/28/2008 21:13:43,,Error,[355] The mail system failed to initialize; check configuration settings
10/28/2008 21:13:43,,Error,[260] Unable to start mail session (reason: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException: Mail configuration information could not be read from the database. ---> System.Data.SqlClient.SqlException: profile name is not valid<nl/>   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception<c/> Boolean breakConnection)<nl/>   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception<c/> Boolean breakConnection)<nl/>   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)<nl/>   a)
10/28/2008 21:13:43,,Error,[364] The Messenger service has not been started - NetSend notifications will not be sent


Thanks,

ET
LVL 19
Eric ShermanAccountant/DeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

HoggZillaCommented:
I hate these kinds of errors, very frustrating. My thought is to start the copy database from the remote server, not locally. Is that an option?
0
Eric ShermanAccountant/DeveloperAuthor Commented:
Not an option HoggZilla ...  Yes, ver frustrating considering all I want to do is copy a database.

ET
0
Eric ShermanAccountant/DeveloperAuthor Commented:
I will re-open this question and re-structure the contents.

ET
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.