Copying a Datbase between two different servers

Hello Everyone,

I am new to SQl Server 2005. I have created a database on one machine and I tried copying it on to another machine where SQL Server 2005 is installed. Both machines have SQL Server 2005 installed. When I tried copying using copy database wizard its asking for the destination server. I have given the name of the destination server but its giving me error msg saying tht it cant connect. How to chk whether my destination server is online? If it is not how to make it online? Any help would be appreciated.

Srividya.

Remote connections are disabled by default for SQL Server. YOu will have to enable them first. For more information see my screencast on my site which covers the "Enable of remote connections for SQL Server 2005".

HTH; Jens K. Suessmeyer.

http://www.sqlserver2005.de