Feb 26, 2008
If your SQL Server 200 had been initially installed using Windows Authentication ( Windows only ) option as above figure, you may have hard to to connect via Odbc or Sql Management Studio 2005.
You might get the error bellow.
Solution might be getting windows authentication before you connect your machine to sql 2000 server.
You can type in machine name or IP and try to key in the sql2000 server administrator and password ( authenticated user ) for sql 2000.
Then you will able to attach the sql server 2000 on your sql server management 2005.