Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
under2811
Constraint Violating Yak Guru
366 Posts |
 Posted - 2006-03-08 : 09:50:09
|
| hi!I transfered my one database from one server to another server.now i wanna to transfer logins on that DB to another machine (server)..we have server 2000 (both)...i used for this DTS Logins Transfer Task..now my question is we have windows as well as sql server authentication....when i opend task that is asking me for source i selected my local server that time it gives me error that your SQL Server Service is running under the local system account.you need to change your SQL Server service account to have the rights to copy files over the network.so shall i change the account to option [This Account] in SERVICES ..n if i do that then will that affect other settings?????or for time being i will change???Any help in that will be valued....T.I.AShashank |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-03-08 : 10:21:56
|
| As long as it has administrato9r rights on the local machine and access to the networked servers drives, then this will be fine.. |
 |
|
|
under2811
Constraint Violating Yak Guru
366 Posts |
Posted - 2006-03-08 : 10:43:06
|
| hi..i am not able to change the radio button in SERVICES to option [This account]how do i do this????T.I.APapillon |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-03-09 : 07:19:54
|
| Log on as an Administrator, if you can't change it, you obviously aren't one.. |
|
|
|
|
|
|
DTS Transfer Logins Task error :(