I answered too soon. I just tested this, and I didn't have any trouble
transferring data from SS2000 Enterprise Manager to SS2005 Express. I used a
SQL Native Client connection as the target.
"Rick Byham [MS]" <rickbyh@online.microsoft.com> wrote in message
news:%23ehE91TIGHA.2696@TK2MSFTNGP14.phx.gbl...
> Enterprise Manager cannot connect to SQL Server 2005 including SQL Server
> 2005 Express Edition.
> Use SQL Server Management Studio Express. The preview is available at
>
http://www.microsoft.com/downloads/details.aspx?familyid=82AFBD59-57A4-455E-A2D6-1D4C98D40F6E&displaylang=en > --
> Rick Byham
> MCDBA, MCSE, MCSA
> Documentation Manager,
> Microsoft, SQL Server Books Online
> This posting is provided "as is" with
> no warranties, and confers no rights.
>
> "shank" <shank@tampabay.rr.com> wrote in message
> news:OMMhe4SIGHA.1312@TK2MSFTNGP09.phx.gbl...
>>I have SQL Express installed on a remote server. It installed without
>>issue. I'm trying to connect to it over the internet with Enterprise
>>Manager and failing! What I've done so far...
>>
>> 1) SQL Express is running
>> 2) SQL Browser is running
>> 3) I enabled TCP/IP and set it to listen to the machine IP address
>> 4) Set the port to 1433
>> Basically, everything appears running and enabled.
>>
>> Everytime I try to connect with EM, it fails.
>> In the end, what I would like to do is create/run a DTS package from my
>> workstation that transfers data between SQL 2000 on a shared server and
>> SQL Express on a dedicated server.
>>
>> How do I get this accomplished?
>> How do I connect to SQL Express from workstation with EM?
>>
>> thanks!
>>
>
>
