November 30, 2005 at 11:16 am
I set up DTS package in MSDE just like in SQL server 2000.
But it doesn't as I expected. When I open sql server agent-jobs. All scheduled tasked are labled with 'cross and red background'. When I look at Job history, it shows details:
cmc_testDTSpackage failed.
Non-SysAdmins have been denied permission to run CmdExec job steps. The step failed.
Does that mean I have to set up administrator account to run this schedule?
Can you tell me how?
Betty
November 30, 2005 at 11:34 am
November 30, 2005 at 11:48 am
I used sql server user name and password.
I tried to use sa, but it gave me the sa login failed, don't how to reset sa account.
Betty
November 30, 2005 at 11:53 am
Check the account permissions for the SQL Server account you are using. It must have sysadmin priviledges assigned to it.
If you need to reset your sa password, any sysadmin account can to this.
November 30, 2005 at 1:46 pm
Hi Johnrowan,
In enterprise manager, Under Sql server group, we have two sql server instances, one is MSDE and one is sql server 2000.
When msde sql server groupe was registered, the sa password was not used.
That's why any sysadmin permission is not there, not even click on property of MSDE server, it will pop up message like "only members of sysadmin role can access this feature."
Does that mean I have to delete the registration and re-register this MSDE server? If I forgot my sa password, what should I do, no other sysadmin account is available now.
Thanks
Betty
November 30, 2005 at 2:04 pm
You do not need to delete and re-register the MSDE Server. If you right-click on the MSDE server, it will let you edit your registration data, including your authentication mode and user name. This will not help you; however, if you do not have a valid account that you can use on the MSDE server. The reason you can't even pull up the server properties is that the account you are using is failing authentication/privileges checks.
Are you the administrator for the MSDE server? Anyone who is in the Windows Administrators group on the MSDE server should have rights to either add you as a sysadmin, or reset your 'sa' password for you. I am not very familiar with MSDE, but this sounds more like a authentication/privileges issue that a MSDE issue.
November 30, 2005 at 2:20 pm
Yes, unfortunately, I am the administrator(entry level) in a very small company.
and I am this windows administrator too. I am just a programmer and don't know much about this set up thing.
Betty
November 30, 2005 at 2:55 pm
I assume that you have MSDE running on a server or a workstation somewhere? Are you the network admin too? Have your network admin make sure that you're domain account is set up in the Windows Administrators group on the MSDE box. Then edit your registration settings via Enterprise Manager to use your Windows account. This should allow you to access MSDE via Enterprise Manager. Again, I am not very familiar with MSDE, but this approach should straighten out your authentication issues.
November 30, 2005 at 10:08 pm
Hi johnrowan,
Finally I figured out what went wrong. On Jobs-->DTS package-->General tab
There is select box for selecting owner, it somehow default to the user I used login. I changed the owner for SA or server administrator. The scheduled the task runs and the red cross label was gone.
I am really appreicated that you gave me so many ideas and clues to make me think a way to deal with my problem.
Sincerely
Betty
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply