IIS and MSSQL

Hi!
I am using BabyWeb server and it's hunging up all the time so i decided to set up IIS. Now there is a problem because same scripts from BabyWeb arn't working on IIS
MY ASP :
@language=vbscript
DBUser = "user"
DBPSD = "password"
DBName = "Data_base_name"
DBIP = "SQL_server_ip"
on error resume next
dim connstr
dim conn
connstr = "DSN=my_DSN _AME;"
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open connstr
errormsg="error"
if err.number<>0 then
response.write "error!"
response.end
end if
_________________________________________
Doesn't work on IIS
Please help me to understand how to connect to my mssql with IIS.
Thanks

Your connection string doesn't appear to contain any authentication or connection info.

What is the given error message/exception?

Besides authentication as Phoenix mentioned, did you set up a DSN of the correct name on the IIS web server?

...Lets not forget that ODBC DSN is a Very Bad Thing now that we're in the days of OleDB. After all, SQL Server is designed for superior performance.

Why can't you connect directly to the SQL Server?