Hard time to connect web wiz forum to SQL
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz NewsPad
Forum Description: Support forum for the Web Wiz NewsPad application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=23020
Printed Date: 28 March 2026 at 7:16am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Hard time to connect web wiz forum to SQL
Posted By: jaimalleshk
Subject: Hard time to connect web wiz forum to SQL
Date Posted: 30 March 2007 at 3:01pm
|
Hi All,
I downloaded forum and news pad. There is no problem with ms access version.
But I want to use SQL Server Express 2005. I need to run set up. I followed instructions.
Still I cannot get through the set up. It says wrong SQL server User Name and password.
Can anyboy help me please ?
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 30 March 2007 at 4:30pm
|
SQL Server 2005 Express Edition installs with the default instance of 'SQLEXPRESS' This means when connecting to the SQL Server on a localhost you would use:- localhost/SQLEXPRESS The SQLEXPRESS part needs to be in capital letters. You also need to ensure that you have created a database on the SQL Sever using SQL Management Studio. You then ought to create a user for that database and give that user DBO (Database Owner) rights on the database. Once this is done you should have all the information you need to connect to and setup all the tables etc. on the SQL Server. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: jaimalleshk
Date Posted: 30 March 2007 at 4:50pm
|
Thanks for your reply.
In database connection file, I have set connections as follows:
'Enter the details of your Microsoft SQL Server or MySQL Server and database below
'********************************************************************************* strSQLServerName = "MYCOMP\SQLEXPRESS" 'Holds the name of the SQL Server (This is the name/location or IP address of the SQL Server) strSQLDBUserName = "DBO" 'Holds the user name (for SQL Server Authentication) strSQLDBPassword = "mysys" 'Holds the password (for SQL Server Authentication) strSQLDBName = "MYCOMP\SQLEXPRESS\Databases\forums" 'Holds the name of the database ----------------------------------------------------------------
Where, MYCOMP is name of my server.
With Management studio, I have created a blank database called forums
I try creating set up using Server User name: MYCOMP\SQLEXPRESS
and password : mysys ( My NT login password).
But it fails
|
Posted By: j172
Date Posted: 30 March 2007 at 5:10pm
I was also trying to connect to an sql 2005 database and also had trouble, so i gave up and used the access version 
It kept giving me an error cant remeber what it was something like unable to connect or error in write permissons (will find out and post it here)
My forum is using sql so i know that it does work with my host and cross checked the settings but still not luck. Anyway will try again and let you know
Joel
|
Posted By: WebWiz-Bruce
Date Posted: 30 March 2007 at 5:14pm
|
The username looks incorrect, you should not have a user on the SQL server with the username DBO Create a user on SQL server called say 'forumuser' then give it DBO permissions on the blank forum database you have created, then in the connection file give forumuser as the username and use the password you setup for this user on the SQL server. Also the name of your database looks wrong, you don't put in the path with SQL server just the database name:- strSQLServerName = "localhost\SQLEXPRESS" 'Holds the name of the SQL Server (This is the name/location or IP address of the SQL Server) strSQLDBUserName = "forumuser" 'Holds the user name (for SQL Server Authentication) strSQLDBPassword = "your_password_here" 'Holds the password (for SQL Server Authentication) strSQLDBName = "forums" 'Holds the name of the database ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: jaimalleshk
Date Posted: 30 March 2007 at 10:15pm
|
Thank you so much. I will try and get back to you. However, I have one question. What is the maximum capacity of SQL Server Express 2005 ?
For MS Acces it is 1 GB.
How about SQL Server Express Edition ?
|
Posted By: jaimalleshk
Date Posted: 31 March 2007 at 6:04am
|
Oh, it did not work !!
The steps I followed:
strSQLServerName = "localhost\SQLEXPRESS" 'Holds the name of the SQL Server (This is the name/location or IP address of the SQL Server)
strSQLDBUserName = "forumuser" 'Holds the user name (for SQL Server Authentication) strSQLDBPassword = "1forum" 'Holds the password (for SQL Server Authentication) strSQLDBName = "forums" 'Holds the name of the database - I have created a empty database called forums.
- I have created a new user under security folder in SQL Server Express 2005 called "forumuser".
The password I gave is 1forum
Now I right clicked on the empty database "forumuser" and went to properties.
In properties I selected user mapping. Here I checked option for forums database.
Pressed OK
Now in msSQL_server_setup.asp page:
I selected user name: forumuser
password: 1forum
Now pressed Submit.
But it did not work !!!
Thanks for helping me.
Please do the needful.
|
Posted By: User123
Date Posted: 31 March 2007 at 6:45am
When you installed SQL Express did you specify mixed security (Integrated + SQL Authentication) or just integrated security? If you selected SQL authentication then you had to specify a password for the SQL admin account "sa". Assuming you did, I would try using the sa account, at least temporarily for testing purposes, to log in. Something like:
If you chose integrated security only then you'll need to enable SQL authentication. Since IIS runs under a guest internet account it's a bit more complicated to use integrated security. |
Posted By: jaimalleshk
Date Posted: 31 March 2007 at 2:28pm
|
Still Hard time. I dont understand why it is so difficult to connect to a great database like sql server.
It is so simple using MS Access but till date I was never able to connect to sql server.
I have used Integrated authentication. And steps followed are as listed below using SQL Server Express Edition 2005 Advanced. I have created Database using Management Studio.
I do not know the password of sa to try above steps. Also may know how to enable SQL Server Authentication?
The steps I followed: strSQLServerName = "localhost\SQLEXPRESS" 'Holds the name of the SQL Server (This is the name/location or IP address of the SQL Server) strSQLDBUserName = "forumuser" 'Holds the user name (for SQL Server Authentication) strSQLDBPassword = "1forum" 'Holds the password (for SQL Server Authentication) strSQLDBName = "forums" 'Holds the name of the database - I have created a empty database called forums. - I have created a new user under security folder in SQL Server Express 2005 called "forumuser". The password I gave is 1forum Now I right clicked on the empty database "forumuser" and went to properties. In properties I selected user mapping. Here I checked option for forums database. Pressed OK Now in msSQL_server_setup.asp page: I selected user name: forumuser password: 1forum Now pressed Submit. But it did not work !!! Thanks for helping me. Please do the needful. |
Posted By: WebWiz-Bruce
Date Posted: 31 March 2007 at 3:05pm
|
When you install SQL Server to connect to it from ASP you need to set it up in mixed mode. It sounds like you have only set it up with windows integrated authentication If you don't have it running in mixed mode with TCP/IP connections allowed it won't work. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: jaimalleshk
Date Posted: 02 April 2007 at 12:55am
|
THANK YOU.
THIS TIME IT WORKED !!!
I reinstalled SQL Server 2005 with mixed mode enabled. Later I followed same steps as above. It worked.
Hope I will purchase your softwares after I test completely
Thank you so much for helping me.
|