I really would like to use this tool, but when I try to import a database, all I get is the error message "Object reference not set to an instance of an object."
I'm working on a 2000 database (sp3a if that matters) where I have sysadmin privileges.
I just don't understand why this isn't working. Any help out there?
For CTP 3 we aren't supported except when running as a local administrator.
However, something you might try: Make your normal user account a system administrator in your sql express instance. To do that, log in with visual studio, Management Studio, or query analyzer, and run this query when connected to your (local)\sqlexpress instance:
CREATE LOGIN [yourwindowsdomain\username] from Windows
exec sp_addsrvrolemember [yourwindowsdomain\username], 'dbcreator'
you can also try 'sysadmin' instead of 'dbcreator' if that doesn't work.
This isn't tested yet nor supported for CTP 3 but may work.
I had already made that user sysadmin because of another error encountered earlier.
Thanks for the info about the CTP. At least now I know to just use it with the admin login and I won't spend time thrashing about with the other.
