https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 06 Apr 2026 19:09:22 +0000 Mon, 17 Sep 2007 16:19:09 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=24366 https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ https://forums.webwiz.net/installing-wwf-stuck-at-mssql-server-setup_topic24366_post127699.html#127699 Author: Flapjack
Subject: 24366
Posted: 17 September 2007 at 4:19pm

It looks like that worked!  Thanks!!


Congratulations, the SQL Server Forum database is set up and Ready to Go :)

For security reasons, security please now delete this file.

Edited by Flapjack - 17 September 2007 at 4:19pm]]> Mon, 17 Sep 2007 16:19:09 +0000 https://forums.webwiz.net/installing-wwf-stuck-at-mssql-server-setup_topic24366_post127699.html#127699 https://forums.webwiz.net/installing-wwf-stuck-at-mssql-server-setup_topic24366_post127697.html#127697 Author: Flapjack
Subject: 24366
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!  
]]> Mon, 17 Sep 2007 16:14:05 +0000 https://forums.webwiz.net/installing-wwf-stuck-at-mssql-server-setup_topic24366_post127697.html#127697 https://forums.webwiz.net/installing-wwf-stuck-at-mssql-server-setup_topic24366_post127674.html#127674 Author: Flapjack
Subject: 24366
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: 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.

]]> Mon, 17 Sep 2007 04:59:41 +0000 https://forums.webwiz.net/installing-wwf-stuck-at-mssql-server-setup_topic24366_post127674.html#127674 https://forums.webwiz.net/installing-wwf-stuck-at-mssql-server-setup_topic24366_post127397.html#127397 Author: WebWiz-Bruce
Subject: 24366
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.
]]> Sat, 08 Sep 2007 09:51:04 +0000 https://forums.webwiz.net/installing-wwf-stuck-at-mssql-server-setup_topic24366_post127397.html#127397 https://forums.webwiz.net/installing-wwf-stuck-at-mssql-server-setup_topic24366_post127393.html#127393 Author: dj air
Subject: 24366
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
]]> Fri, 07 Sep 2007 23:07:23 +0000 https://forums.webwiz.net/installing-wwf-stuck-at-mssql-server-setup_topic24366_post127393.html#127393 https://forums.webwiz.net/installing-wwf-stuck-at-mssql-server-setup_topic24366_post127392.html#127392 Author: Flapjack
Subject: 24366
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.   

]]> Fri, 07 Sep 2007 22:51:38 +0000 https://forums.webwiz.net/installing-wwf-stuck-at-mssql-server-setup_topic24366_post127392.html#127392 https://forums.webwiz.net/installing-wwf-stuck-at-mssql-server-setup_topic24366_post127391.html#127391 Author: Flapjack
Subject: 24366
Posted: 07 September 2007 at 10:50pm

Not sure what you mean by "make sure the forums username is attached".....]]> Fri, 07 Sep 2007 22:50:12 +0000 https://forums.webwiz.net/installing-wwf-stuck-at-mssql-server-setup_topic24366_post127391.html#127391 https://forums.webwiz.net/installing-wwf-stuck-at-mssql-server-setup_topic24366_post127390.html#127390 Author: dj air
Subject: 24366
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.]]> Fri, 07 Sep 2007 22:35:06 +0000 https://forums.webwiz.net/installing-wwf-stuck-at-mssql-server-setup_topic24366_post127390.html#127390 https://forums.webwiz.net/installing-wwf-stuck-at-mssql-server-setup_topic24366_post127389.html#127389 Author: Flapjack
Subject: 24366
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" 

Edited by Flapjack - 07 September 2007 at 10:19pm]]> Fri, 07 Sep 2007 22:18:51 +0000 https://forums.webwiz.net/installing-wwf-stuck-at-mssql-server-setup_topic24366_post127389.html#127389