Connecting to SQL

I'm trying to connect to a sql server database. I use the
same connection string that I have millions of times. The
only difference is I'm connection to a different server
with sql. Do I need to ensure that the IUSR account has
rights on that machine? The webserver and database are on
different machines so it seems like the IUSR account point
would be void. When I try to connect, I receive this
error:

Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]Specified SQL
server not found.
newconn.inc, line 7

Here is my connection string:

cs = "provider=SQLOLEDB; network=DBMSSOCN;
server=myipaddress;"
cs = cs & "database=mydatabase; uid=user; pwd=pass;"
set ADODBConn = Server.CreateObject
("ADODB.Connection")
ADODBConn.open cs
' ...

Re: Connecting to SQL

On Mon, 1 Nov 2004 07:34:55 -0800, "Jimmy Smity"
wrote:

>I'm trying to connect to a sql server database. I use the
>same connection string that I have millions of times. The
>only difference is I'm connection to a different server
>with sql. Do I need to ensure that the IUSR account has
>rights on that machine? The webserver and database are on
>different machines so it seems like the IUSR account point
>would be void. When I try to connect, I receive this
>error:
>
>Microsoft OLE DB Provider for SQL Server error '80004005'
>[DBNETLIB][ConnectionOpen (Connect()).]Specified SQL
>server not found.
>newconn.inc, line 7

See:

Why do I get database-related 80004005 errors?
http://www.aspfaq.com/show.asp?id=2009

HOWTO: IIS and SQL Server on Separate Machines with Trusted
Connection:
http://support.microsoft.com/default.aspx?scid=kb;en-us;q176 379

Jeff