Connecting to an SQL Server

[simonm]

My attempt to conenct to an SQL database when I click on a 'submit' button on my ASPX page fails with the following error: "[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied."

Here is my ASP code:

<script runat="server">
	Sub submit(sender As Object, e As EventArgs)
		dim dbconn
		dbconn=New OleDbConnection("Provider=SQLOLEDB.1;Data Source=ex1;Initial Catalog=TOPS;User ID=sa;Password=XXXX")
		dbconn.Open()
	End Sub
</script>

The SQL server is on another machine in the network (not the machine running IIS) and I know for a fact that the connection string and login details are correct because they work fine if I open a connection from anywhere else. It is only from within my ASPX page that it fails...