Cant connect Web Server to SQl Server

I have a web server with Advanced server 2003 on it and its name is WEB that is trying to get data off of the SQL 2000 server (SQL). They are only on a local area network right now because we are just testing before we put them into production. They used to be on the same machine so linking them was never a problem. I've created a ODBC connection from the web to the sql and named it "SQL". The Databae that i'm trying to access is Dept_Data. This is the same code we had for the old connection i just changed the source name to SQL.

<%
Dim MM_connDept_Data_STRING
MM_connDept_Data_STRING = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Dept_Data;Data Source=SQL"
%>

I've messed around with this for the past two days and can't figure it out, i'm not all that familar with it but i hope someone can help me out. I kind of think it is a permissions or a login issue. Is this enough info. Help!Try...

"DRIVER=SQL Server;SERVER=SQL;Database=dept_data;UID=userlogon ;PWD=userpassword"|||What logon and password is it the one to get into the Database or the what?|||Logon and Pwd for the Database.|||when put the login and password in it asks me to log into the web server for some reason. The code that we put in is in an asp file that is included in the asp file that we want displayed. Do we need to configure an anounomous account?|||The WEB site has to allow anonymous access. That's set by right-clicking the site in IIS Manager, selecting security, and checking the Allow Anonymous Access box. Also make sure you have installed the SQL Server Client Network Utilities on the WEB Server. In the string I gave you, where it says

SERVER=SQL;

I assume SQL is the name of the SQL server box.|||Is this what i need to download on my advanced server 2003 web machine? http://www.microsoft.com/downloads/details.aspx?FamilyID=9032F608-160A-4537-A2B6-4CB265B80766&displaylang=en
And yes the 2000 sql server is named SQL.|||Part of the installation of SQL Server 2000 asks what you want to install. You have a choice of installing the server of just the client side stuff. Run the install on your WEB server and pick the client tools from the menu.