Web Wiz Support and Community Forums : Setting up SQL... help!!! https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 08 Apr 2026 03:34:21 +0000 Tue, 17 Feb 2004 19:15:55 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=9909 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Setting up SQL... help!!! : &#039;Enter the details of your...]]> https://forums.webwiz.net/setting-up-sql-help_topic9909_post53431.html#53431 Author: thekiwi
Subject: 9909
Posted: 17 February 2004 at 7:15pm

'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]]> Tue, 17 Feb 2004 19:15:55 +0000 https://forums.webwiz.net/setting-up-sql-help_topic9909_post53431.html#53431 <![CDATA[Setting up SQL... help!!! : I&#039;m new to setting up software...]]> https://forums.webwiz.net/setting-up-sql-help_topic9909_post53428.html#53428 Author: ecollier
Subject: 9909
Posted: 17 February 2004 at 6:55pm

I'm new to setting up software on Windows, let alone SQL.  I am having a problem getting this to work properly.  I'm following the installation documentation, but I don't think I'm entering the information correctly in the SQL connection section.  Is there anyone out there that can paste a copy of what they did so I can duplicate it? 

 

Thanks a ton,

 

Eric

]]> Tue, 17 Feb 2004 18:55:52 +0000 https://forums.webwiz.net/setting-up-sql-help_topic9909_post53428.html#53428