'Enter the details of your SQL server below
strSQLServerName = "localhost" 'Holds the name of the SQL Server
strSQLDBUserName = "yourusername" 'Holds the user name (for SQL Server Authentication)
strSQLDBPassword = "yourpassword" 'Holds the password (for SQL Server Authentication)
strSQLDBName = "databasename" 'Holds name of a database on the server
Thats all there is to it.
'localhost" is the name of the SQL Server
'yourusername' is the name you have been given by the database adminstrator for access to your database. Ditto with 'yourpassword'
'databasename' is the name given to the database you have already had created for you by the database adminstrator. The setup scripts dont create the database ... just the tables.
When you run the file 'msSQL_server_setup.asp' it will (from memory) ask you for user details of an account which has permissions to create tables. This may be the same as the details above, or something else. If you are on a shared hosting server, then your provider should have given you db_owner privs for your database.
Edited by thekiwi