Problem in accessing DTS in SQL SERVER 2005
I am using SQL SERVER 2005 for DTS.my front end is ASP.NET (code behind is C#.NET)
i am facing problem in accessing DTS in my site. i have created a DTS package for transfaring data from Oracle 9i to SQL Server 2005.
My database server and Web server is not same. Both are on different machine.
It was working fine before publishing the site.
After publishing the site i am facing the Error : "Login failed for user ''. the user is not associated with a trusted SQL Server Connection".
User can access other pages,which are using database.but the only problem is on the page which contain the code of DTS package.
the DTS Package is stored in msdb database and i m using the database named 'osp'. does it make any difference?
Can anyone plz help me to solve this???
Thanks in advance.