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

  New Posts New Posts RSS Feed - Can't get started with SQL Express
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Can't get started with SQL Express
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
Fuzzy View Drop Down
Newbie
Newbie
Avatar

Joined: 27 July 2011
Status: Offline
Points: 7 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Fuzzy Quote  Post ReplyReply Direct Link To This Post Topic: Can't get started with SQL Express
    Posted: 27 July 2011 at 9:42pm
ok, we've been using Web Wiz Forums for eons.  (ok, since 2003)

We started on Access, and never moved off it.  I made an attempt a while back, and failed.

OK, so we're moving the company's web site to Amazon EC2... good chance to finally upgrade.

I've got a Windows Server DataCenter 2008  SP2 (32 bit) up and running.  IIS 7.0.
I've enabled SQL Express.  created an SA password, enabled login

first task: just do a clean install of 10.01 on my new EC2 system and create a clean (new) forum and get that working with SQL Express.

Install Web Wiz (10.01).  
create a new database in SQL Express called WebWiz
set the /database folder security (for both Users and IIS_IUSRS)  to allow modify.
go to http://127.0.0.1/forum/  and get the installation wizard
pick "new installation"
pick SQL Server 2005/2008.
  server = .\SQLEXPRESS
  db name = WebWiz
  sa / password

Test DB connection = Successful

Click Next >>

... no error... bounces me back to forum/setup.asp  -- select installation type.

I've tried both 9.74 and get the same behavior.

Help!
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: 28 July 2011 at 8:09am
You should not give the IIS_IUSRS group permission on the SQL Server as this could leave you open to being hacked.

Instead you need to install SQL Server in mixed mode to allow TCP/IP connections to the SQL Server and then create a user in SQL Server giving that used DBO (Database Owner) rights on the database.

Also is there any reason why you choose Windows Server DataCenter 2008 SP2 (32 bit)? I personally would have gone for 2008 R2 which is 64 bit only as it is much better with what you are running on the server.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
Fuzzy View Drop Down
Newbie
Newbie
Avatar

Joined: 27 July 2011
Status: Offline
Points: 7 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Fuzzy Quote  Post ReplyReply Direct Link To This Post Posted: 28 July 2011 at 12:24pm
A couple of questions then...

why does the "test connection" work if I have an SQL connection problem?
why isn't there an error message?
why don't you write this stuff down somewhere?  I spent hours on this yesterday.

on EC2, 32 bit is cheaper.  and we don't run a big enough site to need 64 bits.
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: 28 July 2011 at 1:00pm
You may be able to connect to the database but it does not mean that you have the correct rights to create tables or other database schema.

How you setup SQL Server is beyond the scope of our support. There are lots of books and dedicated websites  available on SQL server and how to set it up, many of which are 1,000's of pages long and so would not be possible to cover ourselves.

The other thing you may want to check is that you have read, write, and modify permissions enabled on the forums database directory, so that the install wizard can write to this folder. I suspect that you may have missed out this part of the install instructions at part 6 below:-

http://www.webwiz.net/web-wiz-forums/kb/sql-server-install.htm
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
Fuzzy View Drop Down
Newbie
Newbie
Avatar

Joined: 27 July 2011
Status: Offline
Points: 7 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Fuzzy Quote  Post ReplyReply Direct Link To This Post Posted: 28 July 2011 at 3:56pm
OK... I was using Internet Explorer on the Server (using Remote Desktop to connect), connecting via http://localhost/forum/.

on a whim, I thought... maybe I'll get a better error message if I connect to the forum remotely.

so, I went to Google Chrome on my laptop, typed in the http://<real ip address>/forum, went through the configuration steps, and when I clicked "Next", I got:

Congratulations, Web Wiz Forums Database setup is now complete

I didn't change a thing on the server.

so... who knows?  at least now I can make progress.    hopefully this thread saves someone else some pain.

thanks Bruce.
Back to Top
 Post Reply Post Reply

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.