dtswizard login problem?

Hey, i'm trying to use the dtswizard.exe program in MS SQL Server Express 2005 to move a database from one computer on my home network to another.

- Both SQL servers are using Windows Authentication.

-I've turned off all firewalls

-I've done all the Surface Area Config stuff and enabled both types of remote connections

But i'm still getting a "Login Failed for user 'BASEMENT/Guest'. (Microsoft SQL Native Client)" error.

Any ideas?

Thanks!

There is no DTS in Express and why are you using the guest account SQL Server's guest account is off limits to human users because SQL Sever services use it. Problems with the guest account can make your SQL Server shut down. And in one network the normal way is to register one with the other so you can manage both in one place. Hope this helps.

http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx

|||

There is a DTS, it's just hidden (C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe).

Is there some documentation somewhere for how to do this register thing??

|||Try to add the BASEMENT\Guest account to the SQL logins on both SQL2000 and SQL Express.|||

I'm not using SQL2000. Both computers are on express...

|||

Sorry for misunderstanding, but you can try the same thing on both SQL Express. You can download Management Studio Express to manage your SQL Express Servers:

http://msdn.microsoft.com/vstudio/express/sql/download/

|||

Ya i have that already. I can see both SQL servers through that. But when i try to access the remote one i get a "login failed for user" error. They're both using Windows Authentication, perhaps this is a problem?

|||

I tracked down the detailed error message, not much more help:

"Valid login but server access failure"

|||

There is no DTS in Express a lot of needed components is not in Express, you could use the eval version of the full one then buy the developer edition it is under $40. Try the link below for a full comparison of all SQL Server editions. Hope this helps.

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

|||

Ya it is, i'm using it as we speak.

Figured it out. Right click on the Management Studio (on the remote machine), right click on the database, pick permissions and grant them all to the public login. Not sure how secure this makes your database, but since it's just for testing anyway...