Cannot connect to new SQL server db

[OceanDesigner]

I am in the process of migrating from Access to SQL Server. My current configuration is a web server on one machine that hosts all of the web pages and the Access DB. My new configuration has a partition. The same machine now has a web server that has all of the web pages, and a SQL Server that hosts my database. I am having trouble connecting to the new SQL Server DB via the web pages.

I believe I have the DB, SQL Server and my connection string (on the web page) set up right, but I guess one of those three is done incorrectly. After some testing, my IT guys say that the server is not even is not even receiving the connection request from the web page. So maybe this is more of an ASP or IIS problem. Any ideas on what to look for would be very much appreciated. The three connection strings I tried are as follows:

'OPEN CONNECITON
Set myConnection = Server.CreateObject("ADODB.Connection&quot

' DSN ODBC 1 TO NEW SQL SERVER DB (Error: "No data source provider&quot
' myConnection.ConnectionString = "Provider=MSDASQL;DSN='WebAp';" &_
' "UID='website';PWD='qL8dN3';"

' DSN ODBC 2 (AS GENERATED USING MS DATA LINK WIZARD) (Error: "No data source provider&quot
' myConnection.ConnectionString = "Provider=MSDASQL.1;Persist Security Info=False;User ID=website;Data Source=WebAp;Mode=ReadWrite;Initial Catalog=Defender"

' OLE DB TO NEW SQL SERVER DB (Error: "Access Denied&quot
myConnection.ConnectionString = "Provider=sqloledb;Data Source=Babylon;" &_
"Initial Catalog=Defender;User ID=website;Password=qL8dN3"

' OPEN CONNECTION
response.write myConnection.ConnectionString
myConnection.Open
myConnection.close

Thanks, Jeff

 

[OceanDesigner]

My IT dept found a glitch in the server settings (not sure what exactly. I am connected now.