Posted by Erland Sommarskog on 06/19/07 21:12

xx75vulcan (xx75vulcan@gmail.com) writes:
> I've read that particular article somewhere before, and I believe I
> have the settings/common problems correct.
> I'm wondering, do I need to setup a "Linked Server" between the SQL
> box and the web box not running SQL?

I see that you have sorted out your issue (and as I understand, the
answer was in the domain of web servers, where I know next to nothing),
but I still wanted to answer this.

No, linked servers is nothing about that. When you set up a linked server
in SQL Server, is when you want to access some other data source from
SQL Server. That data source could be another SQL Server, it could be
Oracle, it could be Excel. It could be anything that could be reached
with an OLE DB provider (and indirectly an ODBC driver). But linked servers
is nothing about access into SQL Server.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Hiding the Database list from a certain user\group
• Prev in forum: How to get the error message rather than the code error
• Thread view: Re: Web Server Can't Connect to Sql Server

[Reply to this message]