Greetings!
I too am having the same issues. As a general comment it appears that you have entered the information correcly.
However, the line, strSQLServerName = "216.153.93.6" 'Holds the name of the SQL Server may not be valid since it needs to refer to the NetBIOS name of the server. I am not sure that an IP Address will work. For example, when I installed my operating systems (Windows 2003 server) I was given the option to give my computer a name. I named it "MAIN". If you are having yourforum hosted, I think you will need to know the server name provded by you ISP host. You may need to ask them this.
The other issues seem related to the SQL server. The "administrator" and password, "letmein" seem like they should work but do not -- at least in my case. I had to use the "sa" account from when I set up the SQL Server. Otherwise, the following occurs when I run the msSQL_server_setup.ASP file via the browser:
Error Connecting to database on SQL Server
Check the following is set up and correct:-
SQL Server User Name
SQL Server Password
Name of the SQL Server
Database name set up by you on the server
Empty Database set up by you on the SQL Server
Check also that you have entered the correct details in the file 'SQL_server_connection.asp' found in the admin directory.
So, once i got the ASP file to run and create the database tables, I now have an issue in getting logged into the Forum so that I can do the administration I need for users etc.