SQL 2005 Scheduled Jobs - Which Username
Hello
I have two SQL 2005 servers, one which runs all of our database applications and is entirely my responsibility, the other which runs the back-end databases for our CTI systems and which is the responsibility of our CTI provider.
It has recently been identified that there are a number of queries being run against the CTI databases that are taking longer than 20 seconds to complete. The link between the two servers has been configured so that if the user isn't explicitly named in the Linked Server properties, a default user is used.
I need to try and set up all of my scheduled tasks so that they all run under an account that I have specified, so that I can grant explicit rights on the linked server properties. However, I can't see a way of specifying the user credentials that should be used.
Can anyone help me?
Re: SQL 2005 Scheduled Jobs - Which Username
Quote:
Originally Posted by
ianbhenderson73
Hello
I have two SQL 2005 servers, one which runs all of our database applications and is entirely my responsibility, the other which runs the back-end databases for our CTI systems and which is the responsibility of our CTI provider.
It has recently been identified that there are a number of queries being run against the CTI databases that are taking longer than 20 seconds to complete. The link between the two servers has been configured so that if the user isn't explicitly named in the Linked Server properties, a default user is used.
I need to try and set up all of my scheduled tasks so that they all run under an account that I have specified, so that I can grant explicit rights on the linked server properties. However, I can't see a way of specifying the user credentials that should be used.
Can anyone help me?
see this link
http://www.sqldbatips.com/showarticle.asp?ID=29
