Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SqlAdmin Account  in sql 2005

Posted on 2006-10-20
3
Medium Priority
?
682 Views
Last Modified: 2008-03-06
What is SQLAdmin Account?
why the job ( Run SSIS package) is run on this account even though I crearted a job using my login credential?
0
Comment
Question by:jung1975
3 Comments
 
LVL 20

Assisted Solution

by:Sirees
Sirees earned 400 total points
ID: 17775182
<<What is SQLAdmin Account? >>

Are you talking about sa account?

0
 

Author Comment

by:jung1975
ID: 17775349
no.. I have a ccount called SQLAdmin ( generated by sql server) .. and the job that I am trying ot run ( calling SSIS package and execute) is trying to run on that account?.. and Job is keep failing..


Does the accoutn shoule be in both system administrator and SQL serrver administrator accout to be able to run the package?
0
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 1600 total points
ID: 17778148
>>What is SQLAdmin Account?<<
This is a user defined account that you or someone at your organization created.  It may have been "acquired" when you restored a database.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how the fundamental information of how to create a table.

824 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question