Problem Installing Forum..
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=27313
Printed Date: 02 April 2026 at 7:08pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Problem Installing Forum..
Posted By: masson
Subject: Problem Installing Forum..
Date Posted: 01 May 2009 at 8:39pm
|
I'm attempting to install the MS SQL version of the forum, but am getting an error upon running msSQL_server_setup.asp. I'm using SQL 2005 Express. I've added "webwizforums" to my SQL database. Here's the error: Error Connecting to database on SQL Server Error Details: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. database_connection.asp looks like this strSQLServerName = "NT02/SQLEXPRESS" strSQLDBUserName = "administrator" strSQLDBPassword = "password" strSQLDBName = "webwizforums" I've also tried strSQLServerName = "192.168.1.3" Any ideas? Thanks! |
Replies:
Posted By: 123Simples
Date Posted: 02 May 2009 at 12:39pm
|
I'm not sure if I am reading this right but you need a blank database, so delete the database you have done, unless of course you have something else on it, then start again and setup a new one Procedure is to setup a new blank database on your server in which case you choose your username and password, and database name (which you can call that anything you want normally - it could be a mixture of letters, numbers but with no spaces) Be sure that you have the correct details such as your server name, then you should transfer this information into your database_connection.asp file Upload the files and then run the msSql_server_setup.asp file again and input the correct information ------------- http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design |
Posted By: WebWiz-Bruce
Date Posted: 02 May 2009 at 3:06pm
|
By default SQL Server Express only allows local trusted connections. To be able to talk to the database from ASP (which web wiz forums is written in), you need to install SQL Server in mixed mode with TCP/IP connections enabled. If the SQL Server resides on another machine then you also need to allow remote 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: masson
Date Posted: 04 May 2009 at 4:39pm
|
I did not install the forum in muli-mode, so I re-installed it in multi-mode and enabled TCP-IP. But still I'm getting the same message. Do I need to install using a windows username or one local to the SQL Server? I created a couple local to the sql server, gave them access to the database, but still no luck. I've tried every combination I can think of. When I login with a windows username, should it be domain name/username or username@domainname.com or just the username? Again I've tried all of the combinations I can think of and nothing. Here's a shot of my db setup: http://www.advlaser.net/temp/wiz1.jpg" rel="nofollow - www.advlaser.net/temp/wiz1.jpg Here's a shot of my user setup: http://www.advlaser.net/temp/wiz2.jpg" rel="nofollow - www.advlaser.net/temp/wiz2.jpg Here's a shot of protocols: http://www.advlaser.net/temp/wiz3.jpg" rel="nofollow - www.advlaser.net/temp/wiz3.jpg I also made sure to add my windows users as role: sysadmin, and mapped the user to the db as well. My current database_connection.asp looks like: strSQLServerName = "192.168.1.3" strSQLDBUserName = "ADVLASER/admin" strSQLDBPassword = "password" ' I am using the right password strSQLDBName = "webwizforumsomear" ' changed the name when I created a new one Any help would be great. I'm new to sql server. I'm sure it will be great once I get it working. |
Posted By: WebWiz-Bruce
Date Posted: 04 May 2009 at 5:05pm
|
You need to use an SQL Server user to login, not a windows account. Create a new SQL Server user in SQL Server using SQL login not windows authentication. Then give that user DBO rights over the database. If you still get stuck please give the exact error message. ------------- 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: masson
Date Posted: 04 May 2009 at 6:48pm
|
OK I added another sql local user. On the DBO, do I set this up through the user mappings as http://www.advlaser.net/temp/wiz4.jpg" rel="nofollow - here (www.advlaser.net/temp/wiz4.jpg) or is it somewhere else? And should the server role for the user be sys admin? Thanks! Here's the error message, same as before.. Error Connecting to database on SQL Server |
Posted By: Jono
Date Posted: 04 May 2009 at 7:44pm
|
Hi Masson,
You got your SQL user account to have db_denydatareader and db_denydatawriter, so... you can't read or write to your database... Just have db_owner ticked, untick everything else.
Also you appear to have used forward slashes "/" e.g. ADVLASER/admin - These should be back slashes "\".
Hope this helps.
Edit: Oh, and it shouldn't need the SysAdmin role.
|
Posted By: masson
Date Posted: 04 May 2009 at 8:42pm
|
Ok, I've update user to Database owner only checked http://www.advlaser.net/temp/wiz5.jpg" rel="nofollow - www.advlaser.net/temp/wiz5.jpg and I've changed both of them have no roles checked (unchecked sysadmin) My error is still Error Connecting to database on SQL Server. Is there a way to get a better error?
|
Posted By: Jono
Date Posted: 04 May 2009 at 10:08pm
|
Is it still the SQL Server does not exist error? If so try:
strSQLServerName = "NT02\SQLEXPRESS"
If that doesn't work try enabling "Named Pipes" (as in http://www.advlaser.net/temp/wiz3.jpg" rel="nofollow - http://www.advlaser.net/temp/wiz3.jpg )
|
Posted By: masson
Date Posted: 05 May 2009 at 1:27am
|
Still getting: Error Connecting to database on SQL Server database_connection.asp looks like strSQLServerName = "NT02/SQLEXPRESS" strSQLDBUserName = "sa_omear" strSQLDBPassword = "password" strSQLDBName = "webwizforumsomear" I'm also making sure when I run msSQL_Server_Setup.asp that I use a different SQL user name there. I really appreciate all the help. Thanks! -Marvin |
Posted By: WebWiz-Bruce
Date Posted: 05 May 2009 at 8:11am
|
Your backslash is round the wrong way:- NT02\SQLEXPRESS If using localhost you may also want to try:- localhost\SQLEXPRESS Also although TCP/IP is enabled as in Jono's picture, you should double click the TCP/IP icon and check that you have TCP/IP connections enabled for the IP address you are using. If it is a localhost check that you have 127.0.0.1 enabled for TCP/IP connections. ------------- 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: advlaser
Date Posted: 05 May 2009 at 2:58pm
|
Wow the backslash did it. I guess what threw me off was the documentation on that line uses a forward slash and that threw me off. Thanks again for all of the help!!!! ------------- Marvin Masson http://www.advlaser.com" rel="nofollow - http://www.advlaser.com |
Posted By: Jono
Date Posted: 05 May 2009 at 5:01pm
That's excellent news! It's always those small things that catch us out! 
|