|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL Server AccessIs it possible to access an SQL server db from a web site when the
actual db sits on another server at another host? Thanks Brett Absolutely yes. SQL Server (and for that matter all major DBMSs) are designed
for access over a network. Linchi Show quote "Brett_A" wrote: > Is it possible to access an SQL server db from a web site when the > actual db sits on another server at another host? > > Thanks > > Brett > > Not only that, but if you're running a web server on the same hardware as
the database server, someone in your organization is being really, really cheap! Show quote "Linchi Shea" <LinchiS***@discussions.microsoft.com> wrote in message news:AD915A25-06F8-420A-B019-107B6DF8739F@microsoft.com... > Absolutely yes. SQL Server (and for that matter all major DBMSs) are > designed > for access over a network. > > Linchi > > "Brett_A" wrote: > >> Is it possible to access an SQL server db from a web site when the >> actual db sits on another server at another host? >> >> Thanks >> >> Brett >> >> Linchi and Jay,
Neither of you seemed concerned by the "at another host" issue. I took that to mean located at a different web hosting service than the web server. Would you consider that a standard configuration? Roy Harvey Beacon Falls, CT Interesting interpretation of the OP. You may very well be right.
I see so much poorly formed english on the boards that I frequently transform the question in my mind to reflect what I think the OP is asking. Upon careful reading (and assuming you are correct and we are wrong) I will change my answer. Opening a database server to the internet is, of course, bad (all that work to stop SQL injection attacks down the tubs). However, if connecting a web server to a database over a wide-area private network, I would be concerned with the throughput between the servers, the networks reliability and that it be on a private network. Normally, I wouldn't consider it a great idea, but there could easily be reasons to separate the servers. Frankly, I've always considered the database and web servers to be a pair and like to see 100 Mbit adapters and Gbit backbones at a minimum. Internet speeds that high cost $$$, so I wouldn't expect to see them split up very often. One thought over here was to do it over a VPN. Not sure about that, supose I should know, but ... Jay Show quote "Roy Harvey (SQL Server MVP)" <roy_har***@snet.net> wrote in message news:86nmj3577nh1gpp8idhdcu54ikh9dmhmcd@4ax.com... > Linchi and Jay, > > Neither of you seemed concerned by the "at another host" issue. I > took that to mean located at a different web hosting service than the > web server. Would you consider that a standard configuration? > > Roy Harvey > Beacon Falls, CT "Brett_A" <brettat***@gmail.com> wrote in message news:1195063285.451360.239380@i13g2000prf.googlegroups.com... > Is it possible to access an SQL server db from a web site when the > actual db sits on another server at another host? > > Thanks > > Brett >
Show quote
On Nov 14, 6:18 pm, "Jay" <nos...@nospam.org> wrote: Okay,> Interesting interpretation of the OP. You may very well be right. > > I see so much poorly formed english on the boards that I frequently > transform the question in my mind to reflect what I think the OP is asking. > > Upon careful reading (and assuming you are correct and we are wrong) I will > change my answer. > > Opening a database server to the internet is, of course, bad (all that work > to stop SQL injection attacks down the tubs). However, if connecting a web > server to a database over a wide-area private network, I would be concerned > with the throughput between the servers, the networks reliability and that > it be on a private network. Normally, I wouldn't consider it a great idea, > but there could easily be reasons to separate the servers. > > Frankly, I've always considered the database and web servers to be a pair > and like to see 100 Mbit adapters and Gbit backbones at a minimum. Internet > speeds that high cost $$$, so I wouldn't expect to see them split up very > often. > > One thought over here was to do it over a VPN. Not sure about that, supose I > should know, but ... > > Jay > > "Roy Harvey (SQL Server MVP)" <roy_har***@snet.net> wrote in messagenews:86nmj3577nh1gpp8idhdcu54ikh9dmh***@4ax.com... > > > Linchi and Jay, > > > Neither of you seemed concerned by the "at another host" issue. I > > took that to mean located at a different web hosting service than the > > web server. Would you consider that a standard configuration? > > > Roy Harvey > > Beacon Falls, CT > "Brett_A" <brettat***@gmail.com> wrote in message > > news:1195063285.451360.239380@i13g2000prf.googlegroups.com... > > > Is it possible to access an SQL server db from a web site when the > > actual db sits on another server at another host? > > > Thanks > > > Brett Here is the exact situation. DB sits on a dedicated SQL Server box at host AAA Development site sits on server at host BBB Given a valid connection string, why shouldn't I be able to access the DB? How is this setup different from accessing the DB from Management Studio or from a web server at host AAA that sits on a different box? Anyway, I don't know why, but setting up a Testing site on host CCC works when connecting to the DB , but the same connection string produces the following error when trying to connect to DB from host BBB. [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. Thanks for the help. Brett On Mon, 19 Nov 2007 09:40:48 -0800 (PST), Brett_A
<brettat***@gmail.com> wrote: Show quote >Okay, One problem might be that vendor BBB is blocking ports, while CCC is> >Here is the exact situation. > >DB sits on a dedicated SQL Server box at host AAA > >Development site sits on server at host BBB > >Given a valid connection string, why shouldn't I be able to access the >DB? How is this setup different from accessing the DB from Management >Studio or from a web server at host AAA that sits on a different box? > >Anyway, I don't know why, but setting up a Testing site on host CCC >works when connecting to the DB , but the same connection string >produces the following error when trying to connect to DB from host >BBB. > >[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist >or access denied. > >Thanks for the help. > >Brett not. Roy Harvey Beacon falls, CT Are you connecting over a local network, a private WAN, or the internet?
Just saying "host" doesn't really help, as they are all hosts. Show quote "Brett_A" <brettat***@gmail.com> wrote in message news:3603a4c0-3db7-4ad4-8beb-0c1efebba78b@e6g2000prf.googlegroups.com... > On Nov 14, 6:18 pm, "Jay" <nos...@nospam.org> wrote: >> Interesting interpretation of the OP. You may very well be right. >> >> I see so much poorly formed english on the boards that I frequently >> transform the question in my mind to reflect what I think the OP is >> asking. >> >> Upon careful reading (and assuming you are correct and we are wrong) I >> will >> change my answer. >> >> Opening a database server to the internet is, of course, bad (all that >> work >> to stop SQL injection attacks down the tubs). However, if connecting a >> web >> server to a database over a wide-area private network, I would be >> concerned >> with the throughput between the servers, the networks reliability and >> that >> it be on a private network. Normally, I wouldn't consider it a great >> idea, >> but there could easily be reasons to separate the servers. >> >> Frankly, I've always considered the database and web servers to be a pair >> and like to see 100 Mbit adapters and Gbit backbones at a minimum. >> Internet >> speeds that high cost $$$, so I wouldn't expect to see them split up very >> often. >> >> One thought over here was to do it over a VPN. Not sure about that, >> supose I >> should know, but ... >> >> Jay >> >> "Roy Harvey (SQL Server MVP)" <roy_har***@snet.net> wrote in >> messagenews:86nmj3577nh1gpp8idhdcu54ikh9dmh***@4ax.com... >> >> > Linchi and Jay, >> >> > Neither of you seemed concerned by the "at another host" issue. I >> > took that to mean located at a different web hosting service than the >> > web server. Would you consider that a standard configuration? >> >> > Roy Harvey >> > Beacon Falls, CT >> "Brett_A" <brettat***@gmail.com> wrote in message >> >> news:1195063285.451360.239380@i13g2000prf.googlegroups.com... >> >> > Is it possible to access an SQL server db from a web site when the >> > actual db sits on another server at another host? >> >> > Thanks >> >> > Brett > > Okay, > > Here is the exact situation. > > DB sits on a dedicated SQL Server box at host AAA > > Development site sits on server at host BBB > > Given a valid connection string, why shouldn't I be able to access the > DB? How is this setup different from accessing the DB from Management > Studio or from a web server at host AAA that sits on a different box? > > Anyway, I don't know why, but setting up a Testing site on host CCC > works when connecting to the DB , but the same connection string > produces the following error when trying to connect to DB from host > BBB. > > [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist > or access denied. > > Thanks for the help. > > Brett  |
|||||||||||||||||||||||
Other interesting topics