Sql Server 2000 Connection Fail

Hi group,

being pretty new to setting up sql server, I am stuck.

Have installed sql 2000 server on Win 2000 server, IIS 5.0. I try to connect via ASP script that looks like this:

<%
Set Conn = Server.CreateObject("ADODB.Connection")
ConStr = "PROVIDER=SQLOLEDB; DATA SOURCE=192.168.1.99"
ConStr = ConStr & ";UID=someUser;PWD=somePassword"
ConStr = ConStr & ";initial catalog=myDatabaseName;network library=DBMSSOCN"
Conn.Open ConStr
Conn.Close

Set Conn = Nothing
%>

The IP number is the webserver my router points to on port 80.

But get an HTTP 500 error and "The page cannot be displayed"

Any suggestions as to what I am doing wrong here, would be very much appreciated.

I have run applications for a long time that operate Access databases, but starting a new, an big project, forces me to upgrade to sql databases.

Best wishes
FCH