Trying to install application to server

My problem is I want to install a program called webwizforums which uses
sqlexpress as its db. Here are the creators directions:

1.. Create a database on the SQL Server or use an existing one.
2.. Edit, with a text editor, the file 'database_connection.asp' found in
the 'database' directory entering, where indicated, your SQL Server name,
your SQL Server Authentication details, and the name of the empty database
you have created for the Forum on the SQL Server.
3.. Run the file 'msSQL_server_setup.asp' found in the main folder of the
Forum in your web browser. This file will create all the tables, relations,
and default values in the empty database you have created on the SQL Server.
It is highly recommend for security purposes that you delete this file from
the Web Server once the database is fully created.
4.. The Forum database should now be created and you can now use the
Forum.
I have installed sqlexpress, done all the above. My created database is
MedDir_Forum

The file "database_connection.asp" wants the following so here is the script
and what I have put in:

'Enter the details of your Microsoft SQL Server or MySQL Server and
database below
'********************************************************************************* strSQLServerName = "Internet06/sqlexpress" 'Alternately I have used theinternal IP address (192.168.1.6) Holds the name of the SQL Server (This isthe name/location or IP address of the SQL Server) strSQLDBUserName = "Terry" 'Holds the user name (for SQL ServerAuthentication) strSQLDBPassword = "MyPassword" 'Holds the password (for SQL ServerAuthentication) strSQLDBName = "MedDir_Forum" 'Holds the name of the databaseHere is the error I am getting: 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'database_connection.asp' found in the 'database' directory. Does anyone have an idea what I need to do to connect to this databaseI've created and let this script create all the tables I need for thisapplication? Thanks, Terry

.

Relevant Pages

  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Word 2003/Access2000/SQLSVR
    ... SQL server being where the data is held and this is accessed through a MS ... entire database and that may be say a record for Berkshire. ... "Peter Jamieson" wrote: ... replaced with the first record on the table in use. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: MS Access DAO -> ADO.NET Migration
    ... full SQL Server and I see the logic you explained in a multi user ... allow two users to access the same database file Read/Write at any given ... The book was a pleasure to read after the gibberish that Microsoft 'puts ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: MS Access DAO -> ADO.NET Migration
    ... For that it is much harder to handle the incremental identifier, ... database but although they have the data, they are not connected at the same ... The book was a pleasure to read after the gibberish that Microsoft 'puts ... SQL Server Management Studio is nowhere to be found on my ...
    (microsoft.public.dotnet.framework.adonet)