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 |
|
trusted4u
Posting Yak Master
109 Posts |
 Posted - 2003-04-01 : 05:21:09
|
| Hello : I am trying to change the SQLServerAgent Service login, at present the LOCAL SYSTEM ACCOUNT option is selected. I want to change the login to Win NT administrator login but it does not allow to do so. Pls Need a SOLUTION VERY URGENTLY.- Marjo. |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2003-04-01 : 05:43:34
|
| Alright - where are you trying to change this ?EM - SQL Agent , right click, properties, tick radio button THIS ACCOUNT, and then enter required account. Note it will need to be able to run the services.Alternatively, you can do it in the services section on the OS, right click , go to log on tab and choose THIS ACCOUNT. (I have win 2000)What error are you getting, or are you not abl to change the radio button ?If not, you might not be signed on with a user that has sufficient rights to do this ...HTH*#&#* *#&#* *#&#* *#&#* Chaos, Disorder and Panic ... my work is done here! |
 |
|
|
trusted4u
Posting Yak Master
109 Posts |
Posted - 2003-04-01 : 06:43:13
|
YESSSS !! GOT IT.  The administrator gave me that login for SqlServerAgent which didn't had administrative previliges. Since morning I am trying with that damn account but invain. Just now I tried it using administrative account for the SqlSeriveAgent and it worked perfectly. Tommorrow I will schedule it once again properly and confirm.Wanderer I have another doubt related to packages. I tried to copy a package from one server to another by using save as option. When I open the package from the same pc that I used to copy the package it works properly but when I try opening the package from the Server it displays - The System Cannot Find The File Specified. Why it does not work on the server ?One more doubt, I have a db - Raywood that uses 2 filegroups. I have done Filegroup backup for Raywood by selecting both. While restoring the db on a different server using the restore type as filegroup and by specifying the name of the 1st filegroup i.e PRIMARY it gives an error. " Could not locate entry in sysdatabases for database 'Raywood'. No entry found with that name. Make sure that the name is entered correctly. Backup or restore operation terminating abnormally. "Thanks- Marjo |
|
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2003-04-01 : 08:06:30
|
| Problem (1):Sounds like you have a reference to a specific file or directory structure on the original server that doesn't exists on the other machine. Review the code in the package to see if that might be the case.Problem (2):Could also be a directory problem. Could you post the restore script you used ?Personally, I move DB's via backups all the time, and I don't play around with filegroup backups - no reason they shouldn't work though.Why not simply create a share on your second machine (target) then backup from source server to target server. Something like this:******************0.create backup_share directory on TARGET server.share directory (I usually name is DIRECTORY_NAME$, so in this case it would be backup_share$)1.Connect to Source Server2. Backup database Raymond_dbto disk = '\\TAREGET\backup_share$\ray_db.bakwith init,stats=1go3. SP_helpdb raymond_db(just to get the filenames - assume datafile1, datafile2 and logfile)4. Connect to Target Server5.Restore Database Raymond_dbfrom disk = 'd:\backup_share\ray_db.bak'with move 'datafile1' to 'd:\data\ray_db_file1.mdf',move 'datafile2' to 'd:\data\ray_db_file2.ndf',move 'logfile' to 'd:\log\ray_db_log.ldf',replace,stats=1************************************Note - check where your data drives and log drives would be ... The above assumes youi can network and map between the 2 machines ...HTH .....*#&#* *#&#* *#&#* *#&#* Chaos, Disorder and Panic ... my work is done here!Edited by - wanderer on 04/01/2003 08:12:48 |
|
|
|
trusted4u
Posting Yak Master
109 Posts |
Posted - 2003-04-01 : 09:02:34
|
| Can't we do the restore in EM ? |
|
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2003-04-01 : 09:41:23
|
| You can ... BUT , refer to all the problems that have been experienced with EM, I generally try to avoid it where possible. Also, if you know the T-SQL syntax, you are more likely to understand what is actually happening.With EM - Hmmm - you'll probably need to map the network drive, so that EM can access it. Then from the target server, do a backup to the network drive. After that, go to the target server in EM, and right-click northwind, choose all tasks, and the restore. NB - 1st thing - change DB name, before you start browsing to do the restore from file etc.HTH*#&#* *#&#* *#&#* *#&#* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
|
|
|
|
|
Changing SQLServerAgent Service Login !