The "Copy Database Wizard" that comes with SQL Server 2005 has a major problem. When reaching the step where listing all source databases available, it tries to connect to each one using the source credentials. That's bad!It should only list the names, and try the connection later on the ones I check.
My site is hosted on HostMySite with a shared hosting plan. That means my database is one of a thousand on their SQL Server. Showing the list of databases in SQL Server Management Studio takes only a few seconds. Only if I try to open another database will I get a login error. But the damn wizard tries a connection on every database. Worse, someone at HostMySite may be wondering who's IP is this trying (and failing) to login to every database.
At least, with SQL Server SP2, it does not stop and display an error on the first database it can't connect to... I'll just have to wait.