Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Hard time to connect web wiz forum to SQL
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Forum LockedHard time to connect web wiz forum to SQL
 Post Reply Post Reply Page  12>
Author
  Topic Search Topic Search  Topic Options Topic Options
jaimalleshk View Drop Down
Newbie
Newbie


Joined: 30 March 2007
Location: India
Status: Offline
Points: 9 		Post Options Post Options   Thanks (0) Thanks(0)   Quote jaimalleshk Quote  Post ReplyReply Direct Link To This Post Topic: Hard time to connect web wiz forum to SQL
    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 ?
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
jaimalleshk View Drop Down
Newbie
Newbie


Joined: 30 March 2007
Location: India
Status: Offline
Points: 9 		Post Options Post Options   Thanks (0) Thanks(0)   Quote jaimalleshk Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
j172 View Drop Down
Newbie
Newbie
Avatar

Joined: 24 August 2006
Status: Offline
Points: 38 		Post Options Post Options   Thanks (0) Thanks(0)   Quote j172 Quote  Post ReplyReply Direct Link To This Post 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 Tongue
 
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
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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
 



Edited by -boRg- - 30 March 2007 at 5:18pm
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
jaimalleshk View Drop Down
Newbie
Newbie


Joined: 30 March 2007
Location: India
Status: Offline
Points: 9 		Post Options Post Options   Thanks (0) Thanks(0)   Quote jaimalleshk Quote  Post ReplyReply Direct Link To This Post 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 ?
Back to Top
jaimalleshk View Drop Down
Newbie
Newbie


Joined: 30 March 2007
Location: India
Status: Offline
Points: 9 		Post Options Post Options   Thanks (0) Thanks(0)   Quote jaimalleshk Quote  Post ReplyReply Direct Link To This Post 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.
 
 
Back to Top
User123 View Drop Down
Newbie
Newbie


Joined: 11 March 2007
Status: Offline
Points: 38 		Post Options Post Options   Thanks (0) Thanks(0)   Quote User123 Quote  Post ReplyReply Direct Link To This Post 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:
strSQLServerName = "localhost\SQLEXPRESS" 'Holds the name of the SQL Server (This is the name/location or IP address of the SQL Server)
strSQLDBUserName = "sa" 'Holds the user name (for SQL Server Authentication)
strSQLDBPassword = "sapasswordhere" 'Holds the password (for SQL Server Authentication)
strSQLDBName = "forums"  'Holds the name of the database


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.
Back to Top
 Post Reply Post Reply Page  12>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.