Print Page | Close Window

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
Check the following is set up and correct:- 
SQL Server User Name
SQL Server Password
Name of the SQL Server
Database name set up by you on the server
Empty Database set up by you on the SQL Server
Check also that you have entered the correct details in the file 'database_connection.asp' found in the 'database' directory.
Detailed Error Message: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
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

Check the following is set up and correct:- 

SQL Server User Name
SQL Server Password
Name of the SQL Server
Database name set up by you on the server
Empty Database set up by you on the SQL Server

Check also that you have entered the correct details in the file 'database_connection.asp' found in the 'database' directory.

Detailed Error Message:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

Error Details:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.


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

Enabled Named Pipes protocol and started and stopped SQLEXPRESS. I also switched the sqlserver name.

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! Smile



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net