Another database transfer question
Ray Watson
This is a super simple problem I am sure.
I was playing with the DTS Import/Export tool to see if I could transfer and
entire database between two computers.
It seemed to work ok until the very end, when it gave a message saying it
could not find
[Microsoft][ODBC SQL Server Driver][SQL Server] Windows NT user or group
'FROMCOMPUTERNAME\UserName' NOT FOUND. Check the name again
I am not sure what it is trying to tell me
Any thoughts would be very much appreciated
Cheers
Ray
Simon Hayes
'FROMCOMPUTERNAME\UserName' is a local user account on the source
computer, so it's unknown on the target computer, and therefore cannot
be referenced in SQL Server. You may be able to ignore this, if
everything else has been copied OK - just give database access to
'TARGETCOMPUTERNAME\UserName' for example.
If you have a lot of object permissions to grant, you could generate a
script with only the object permissions from the source DB using
Enterprise Manager. Then do a find and replace to replace the account
name, and run the script on the target server.
Simon
Ray Watson
Thanks for that Simon
I think that I understood that it was asking for the source computers
user name. I guess that I wondered why it should care.
I had an inspiration later that it might be something to do with ROLES,
and maybe Usernames there are "hardcoded", hence the confusion.
At first I thought that the error had stopped the transfer, as the
database didnt show up in the Enterprise manager after i refreshed, but
after I exited EP and came back in, it was there OK.
I will check the roles soon and see if that was the problem.
Too bad if they ever invent truly usefull error messages like "Couldnt
import a role, as ther is no user ..."
Cheers
Ray
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!