Credentials / Permissions NT Login Name 1

[Tinkerers]

Hi,

I fought with the permissions in SQL Server 2005 to get the permissions correct to execute an SSIS package. Eventually I ended up creating a credential with my NT login name, like domain\Paul. I also had to type in and save my NT login password. All is working perfectly now.

However, when I get prompted in 30 days to change my NT password, looks like I will also need to change it in SQL Server as well, so that my automated jobs continue to execute. Is there some other way to set up the credential so that I won't need to change my password inside that credential to match my network domain password?

I tried every other way I could think of and the only way to get the proper permissions to execute my file reading/writing SSIS packages was to use my NT login and password.

Thanks for any help,
Psul

 

[mrdenny]

If you need to use a credential you have to specify the username and password within the SQL Server.

Setup a windows account which is to be used specifically for running the SSIS package. Setup this account as a credential. When you setup the domain account set it up to not require the password to be changed.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[Tinkerers]

The only way I can get the proper permissions to execute the SSIS package is to use my own Network login, such as domain\Paul. A windows account I could create doesn't provide me the necessary read/write permissions across different servers.

I guess I was hoping to somehow set up my NT login and password inside SQL Server, so that it will somehow stay synchronized with my actual Network password. That way I wouldn't need to keep changing the password in SQL Server, whenever my network password changed.

 

[mrdenny]

There is no way to do that with a Credential. As I said above you'll need to create a domain account for the packages to run under and give that domain account the network rights which it needs.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog