I have a DTS to transfer logins from one server to a another server. I have put the syslogins.dat file in the share directory. But this DTS is giving 'Unspecified Error'. Any help would be appreciated.
ThanksI would not try copying a dat file. Use tranfer SQL Objects.|||I guess, the dat file has nothing to do with this DTS. Because, the transfer logins task takes just the source and destination servers. I'm not sure how it transfers the logins and why it should give 'Unspecified error'.|||Are you saying you are not copying the dat? And the DTS is trying to transfer the logins?
What about permissions on both servers?|||I'm not copying the dat file.
What permissions should I check. I ran this DTS from Enterprise Manager. The logins are same in source and destination server.
I just tried to run it through a job and it failed with error 2147467259 (80004005).|||I just tried SQL Server Authentication instead of Windows Authentication and it still gives the same problem. I don't know what the heck this 'Unspecified error' means and this is driving me crazy|||If you have not tried this...
Change the task to something that should have no trouble completeing.
In other words does any work with that DTS?|||Yes. All the other DTS packages execute properly. I just tried 'create table','delete table', 'connection to excel'..etc. and everything just completed fine.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment