DTS Access denied on the server
Posted on 2001-09-05
I have 2 SQL servers (2 machines), A test server and a prod server. Everything runs well on both. The only thing is I cannot access the dts packages on the prod server from the prod server. If I am physically at the prod server machine, and I try to access a dts with the enterprise manager, I get an access denied error. I cannot create a new one, run an existing one, or run a job that runs a DTS (which is what I ultimately want to do). I can register my test server on the prod server, but still cannot access the test server DTS packages. From my client machine and the test server, I can however register the prod server and access it's DST's. It is as if only my prod server cannot access any DTS package from any server.
My prod server happens to be a BDC, and is logged as Administrator in NT. The domain administrator has SA rights in my DB. I cannot access it with the SA account either. Everything else seems to be working but this.