Post reply

Address a sql server 2000 db from an asp page on a different server

  • May 26, 2006 at 8:08 am

    #366273

    I currently have a sql server 2000 db and several websites on the same physical server. I now want to be able to access the db from web pages on another server. I want to restrict access to just stored procedures so there is no direct access to the data tables or to sql analyser etc. What is the best way to go about this? I am terrificly ignorant on this area and would appreciate any help. For example say i have a stored proc called GETBALANCE on a db with a data source name of MYDB001 how do i address it from a different server. I would really appreciate any guidance on this!

    Thanks

    Mike

  • May 29, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • May 30, 2006 at 5:32 pm

    #640812

    You should create a SQL Server login that has access permissions to only the procedures you want to access. Then connect to SQL with that login. There may be a problem, though, with reporting services if it requires extended permissions to SQL.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply