Installing WWF: Stuck at "msSQL_server_setup
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=24366
Printed Date: 06 April 2026 at 3:46pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Installing WWF: Stuck at "msSQL_server_setup
Posted By: Flapjack
Subject: Installing WWF: Stuck at "msSQL_server_setup
Date Posted: 07 September 2007 at 10:18pm
|
I am currently stuck at the "Web Wiz Forums Database Microsoft SQL Server Setup" page. - I have installed both MS SQL Server Express and the MS SQL Server Management Studio Express. - I have created a database called "Forums". - I have created a user under Security > Logins also called "forums". - I have added the user "forums" to the Database I built under Security > Users. After adding the user, I went into it's properties and set "dbo" as the default schema. - For the two boxes underneath, I have checked every schema/role that seemed relevant. - Under IIS, I created a virtual directory called "forums" and set the IUSR_MACHINENAME permissions for both read and write. Which takes me to where I'm stuck. I enter http://localhost/forums/msSQL_server_setup.asp into the address bar and the Web Wiz setup page comes up. I have tried just about every kind of login combo I can think of. I've even replaced "DBO" with the user I created in SQL Server. Depending on how I set the database_connection.asp file, I get two different error messages. with the strSQLServerName set as: "COS-SITESRV\SQLEXPRESS", I get the following error message INSTANTLY: Error Connecting to database on SQL Server "Login failed for user 'forums'. The user is not associated with a trusted SQL Server connection." With the strSQLServerName set at just "SQLEXPRESS", I get the following error message within 30 seconds: Error Connecting to database on SQL Server [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Here is my config file, with the password and server name changed. strSQLServerName = "FORUMSERVER\SQLEXPRESS" 'Holds the name of the SQL Server (This is the name/location or IP address of the SQL Server) strSQLDBUserName = "forums" 'Holds the user name (for SQL Server Authentication) strSQLDBPassword = "password" 'Holds the password (for SQL Server Authentication) strSQLDBName = "Forums" |
Replies:
Posted By: dj air
Date Posted: 07 September 2007 at 10:35pm
|
make sure the forums username is attached and allow access to that database also make sure it have permissions to access and do all actions on the database. i had a simular issue then worked it out as that. |
Posted By: Flapjack
Date Posted: 07 September 2007 at 10:50pm
| Not sure what you mean by "make sure the forums username is attached"..... |
Posted By: Flapjack
Date Posted: 07 September 2007 at 10:51pm
|
If I right-click the "forums" database, hit properties, and go under "Permissions", the "forums" user is in there, with every box under "Grant" checked. |
Posted By: dj air
Date Posted: 07 September 2007 at 11:07pm
|
right ok, thats good you need ot go to the main /default section and under security and then logins make sure the username "Forum" or one used is attached to the Forum database, is usually a check box of the databases it can use etc |
Posted By: WebWiz-Bruce
Date Posted: 08 September 2007 at 9:51am
|
To me the error:- Error Connecting to database on SQL Server "Login failed for user 'forums'. The user is not associated with a trusted SQL Server connection." Suggests that you didn't install SQL Server in mixed mode, and so only trusted connections are permitted. You need to install SQL Server in mixed mode, allowing TCP/IP connections to 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: Flapjack
Date Posted: 17 September 2007 at 4:59am
|
Thanks for the reply. Sorry it took so long for me to get back to this thread, but I got it a motorcycle accident on the way home and have been at home healing a bit. I broke both my hands in several places, and my wrist needed to be put back together with a plate and screws. I'm working again with the help of Dragon Naturally Speaking and the few good fingers I have left. So, is there any way to find out if I did not install SQL in mixed mode? I don't remember that option, but it's been awhile since I installed it.
|
-boRg- wrote:Posted By: Flapjack
Date Posted: 17 September 2007 at 4:14pm
|
Ok, using this page, I was able to switch modes without a reinstall. http://msdn2.microsoft.com/en-us/library/ms188670.aspx Back to the forums setup. Hope that helped! |
Posted By: Flapjack
Date Posted: 17 September 2007 at 4:19pm
|
It looks like that worked! Thanks!! For security reasons, security please now delete this file. |