It all depends on how you installed the SQL Server. To make it simple to connect from the IIS on the local PC, my SQL Server is a 'local' with Windows authentiation. Then I created a DSN for SQL Server database (see PP. 488 to 492). Finally, code objConn.Open "DSN=SQLdsnName" , instead of a strConnect/DataStore.asp SSI connection.
It worked well for me on Movie2000 SQL Server database, which I imported from the Access Movie2000.
C. Jeffrey Wang