Hi guys,<BR><BR>Im experiencing an error when trying to connect to a web server running SQL Server/IIS.<BR><BR>Error Type:<BR>Microsoft OLE DB Provider for SQL Server (0x80004005)<BR>[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.<BR><BR>I have assigned the sa user account a password of &#039;password&#039; and have specified this within the connection string....<BR><BR>DIM calConn<BR>Set calConn = Server.CreateObject("ADODB.Connection")<BR>calConn = "Driver={SQL Server};Server=(local);Database=calendar;Uid=sa;Pw d=password"<BR><BR>How can I remedy this?