We have a SQL Server 7 database on our WEB site.
Our site is Hosted by another company.
I can run the DTS packages manually, by right clicking on them and clicking "Execute Package" They run perfect an update the parts on the WEB site just fine.
Some one said I need to create a local user on our SQL Server and give them rights or permissions to the WEB site using its login and password.
And run the DTS packages under that new users context.
Can someone tell me a detail how to do this and where???
TIA
DougP, MCP
Visit my WEB site to see how Bar-codes can help you be more productive
Our site is Hosted by another company.
I can run the DTS packages manually, by right clicking on them and clicking "Execute Package" They run perfect an update the parts on the WEB site just fine.
Some one said I need to create a local user on our SQL Server and give them rights or permissions to the WEB site using its login and password.
And run the DTS packages under that new users context.
Can someone tell me a detail how to do this and where???
TIA
DougP, MCP
Visit my WEB site to see how Bar-codes can help you be more productive