First of all, I wasn't sure which forum to post so my apologies in advance.
I am testing out a new web server for a site with ASP front end, COM middle tier and SQL Server 2000 backend. I have changed my host file to reflect an internal IP address connecting to that site so that I may test it.
The connection strings point to the development database. I supply the username and password in the COM layer. The database strings are picked up from the registry entries which I have checked and found to be in order.
The problem is that I keep getting a "SELECT permission denied on object 'some_table_name', database 'the_dev_database', owner 'dbo'. "
I am not sure where to start looking in order to fix this.
Thanks
rsshetty.
It's always in the details.
I am testing out a new web server for a site with ASP front end, COM middle tier and SQL Server 2000 backend. I have changed my host file to reflect an internal IP address connecting to that site so that I may test it.
The connection strings point to the development database. I supply the username and password in the COM layer. The database strings are picked up from the registry entries which I have checked and found to be in order.
The problem is that I keep getting a "SELECT permission denied on object 'some_table_name', database 'the_dev_database', owner 'dbo'. "
I am not sure where to start looking in order to fix this.
Thanks
rsshetty.
It's always in the details.
