Gday all,
Probably the wrong forum...I have a proprietary database with proprietary DSN software which creates a User DSN. No option to create a System DSN.
I have logged in to my PC as an account which SQL Agent is using to log on with. It's not logging on with Local System.
This allows me to create a DTS package with the owner being the SQL Agent logon account. It uses the User DSN to import data from the database into SQL Server.
I then log onto the PC with my normal account, but because the DSN which the package uses isn't visible to me, it fails.
Is it possible to fiddle with the registry somewhere or do some other change to change the DSN from a user DSN to a System DSN?
Cheers, Danster
Probably the wrong forum...I have a proprietary database with proprietary DSN software which creates a User DSN. No option to create a System DSN.
I have logged in to my PC as an account which SQL Agent is using to log on with. It's not logging on with Local System.
This allows me to create a DTS package with the owner being the SQL Agent logon account. It uses the User DSN to import data from the database into SQL Server.
I then log onto the PC with my normal account, but because the DSN which the package uses isn't visible to me, it fails.
Is it possible to fiddle with the registry somewhere or do some other change to change the DSN from a user DSN to a System DSN?
Cheers, Danster