Web Wiz - Green Windows Web Hosting

  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
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 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.


Edited by jaimalleshk - 31 March 2007 at 2:30pm
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: 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.
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: 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.
 
 
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.