Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Accessing SQL Server from a web site on a remote machine

Status
Not open for further replies.
mikelawrence

mikelawrence

Programmer
Sep 19, 2001
68
GB
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 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 name of MYDB001 how do i address it from a different server. I would really appreciate any guidance on this!

Thanks

Mike
 
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
SQL Server in Windows
Replies
1
Views
773
pjw001
pjw001
CodeWell
  • Locked
  • Question
SQL Server 2017 Install Issue - Database Not in Configuration Manager
Replies
0
Views
649
CodeWell
CodeWell
TheBugSlayer
  • Locked
  • Question
High Availability - insert fails on primary replica but runs on secondary after failover.
Replies
0
Views
462
TheBugSlayer
TheBugSlayer
JScannell
  • Locked
  • Question
SQL login on Classic ASP localhost site
Replies
0
Views
501
JScannell
JScannell
bethabernathy
  • Locked
  • Question
Front End Access 365 Database dsn Connection Fails when attempting to link to 2016 SQL server
Replies
1
Views
542
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top