SQL Server / MSDE Installation Tip
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=20586
Printed Date: 09 April 2026 at 2:10pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: SQL Server / MSDE Installation Tip
Posted By: FalconRime
Subject: SQL Server / MSDE Installation Tip
Date Posted: 07 July 2006 at 5:14pm
Had a problem trying to get the SQL configuation script to work. Eventually tracked it down to the fact that my SQL Server instance was set to only allow Windows Authentication and not username / password authentication.
To switch on username / password authentication, go to Enterprise Manager, right click on the SQL Server Group, choose Properties. On the Security tab select the "SQL Server and Windows" radio button (not the "Windows only" radio button).
Hope this helps someone else.
Falcon.
PS Any work been done on an Oracle install?
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 07 July 2006 at 9:10pm
It is something that is worth considering now that a free version on Oracle is available, but as most ASP and ASP.NET developers use SQL Server it may not be worth the time doing the conversion as most will be hard pushed to use or have any benefit in using Oracle.
Also, for SQL Server users you now have SQL Server 2005 Express, which has the same limitations as the free version of Oracle, which is simply it can only use one CPU and a 4 gig limit on database size, non of which would effect the running of software like Web Wiz Forums.
-------------
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: WebWiz-Bruce
Date Posted: 07 July 2006 at 9:12pm
By the way when you setup SQL Server it's best to select to have the instance running in 'mixed mode' so you don't run into the problem that you mention.
I would also suggest using SQL Server 2005 Express rather than MSDE which had too many limitations and is now superseded by the much improved SQL Server Express.
-------------
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: FalconRime
Date Posted: 08 July 2006 at 8:01pm
Agreed about SQL Server Express - it was just that I already had access to MSDE on the development environment so it was a quick and easy way to get started.
You are probably right about the Oracle version not being that popular. But in my case all my software is ASP/Oracle for historical reasons. Being able to run the forums (and more importantly integrate the user directory) in the same DBMS would have been good.
|
Posted By: WebWiz-Bruce
Date Posted: 10 July 2006 at 9:35am
An Oracle version is something that I am yet to look into but now that there is a free version of Oracle it will be something that will be looked into to see if there would be any difficulties in implementing it and gauge if people want an Oracle version.
-------------
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
|
|