I'm having a tough time here figuring this out. I tried the asp code below to connect to my mssql server but it fails and the support people say I am trying to connect using named pipes and need to change it to tcp/ip. Can someone show me what I need to change to make it into tcp/ip connection? I would GREATLY appreciate it!


<%
function set_conn(func_opt, func_conn )
if func_opt = true then
set set_conn = createobject("adodb.connection")
set_conn.open "DRIVER={SQL Server};SERVER=sql2k.website.com;UID=myid;PWD=mypassword;DATABASE=mydb"
else
func_conn.close
set func_conn = nothing
end if
end function



Set conn = set_conn(true,null)
Set RS = server.CreateObject("adodb.recordset")
mysql = "Select userno From mytable where email = '" & trim(UN2) & "' and password = '" & trim(PW2) & "'"
RS.Open mysql, conn


And I get this error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC SQL Server Driver][Named Pipes]Access denied.



Thanks!