Moving Forum
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums Modifications
Forum Description: Mod's and Add-on's for Web Wiz Forums.
URL: https://forums.webwiz.net/forum_posts.asp?TID=26566
Printed Date: 29 March 2026 at 7:46pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Moving Forum
Posted By: brian_billington
Subject: Moving Forum
Date Posted: 21 November 2008 at 9:09am
|
I am moving my company intranet and forum to a new server I have copied the forum directory accross to the new box but cant get it to work the SQL database is still on the same box and has not changed This is the error i am getting Server Error in Forum Application An error has occurred while connecting to the database. Please contact the forum administrator. Support Error Code:- err_SQLServer_db_connection File Name:- common.asp Error details:- Microsoft OLE DB Provider for SQL Server [DBNMPNTW]Access denied. |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 21 November 2008 at 10:01am
|
Looks like your SQL Server login to your database is denied. Check your database login and that you have permission to access the SQL Server from the new servers location. ------------- 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: brian_billington
Date Posted: 21 November 2008 at 11:14am
| but its a copy of the forum site - just copied to the new server - no login details have changed |
Posted By: MortiOli
Date Posted: 21 November 2008 at 11:44am
| But has the server name changed? Or the IP address of the server? |
Posted By: Scotty32
Date Posted: 21 November 2008 at 12:10pm
|
Was the website originally on the same server as the database? If so, check that you have not got "localhost" as the database location. Also, check that the server the website is currently on has access to the server with the database. ------------- S2H.co.uk - http://www.s2h.co.uk/wwf/" rel="nofollow - WebWiz Mods and Skins For support on my mods + skins, please use http://www.s2h.co.uk/forum/" rel="nofollow - my forum . |
Posted By: brian_billington
Date Posted: 21 November 2008 at 12:18pm
|
The Web site (Intranet) and forum was on one box The SQL server was on another Box The Web site and Forum was moved to a new box - and forum was just copied accross The SQL server is unchanged still on the same box |
Posted By: WebWiz-Bruce
Date Posted: 21 November 2008 at 2:29pm
|
Check any firewalls you may have running and the connection itself as it may not let you connect to the SQL Server from your new web 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: 123Simples
Date Posted: 21 November 2008 at 6:54pm
|
Sorry if I sound thick, but is the SQL database and the forum software running on the same "box" as you put it? If not, then it must be a database connection issue ie. incorrect path to your database that is giving you this error Surely  ------------- http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design |
Posted By: Scotty32
Date Posted: 21 November 2008 at 11:17pm
|
TWS, He used to have them on the same "box". Hes recently moved the website files to a different box, and kept the Database on the original box. He now can not connect to the database. ------------- S2H.co.uk - http://www.s2h.co.uk/wwf/" rel="nofollow - WebWiz Mods and Skins For support on my mods + skins, please use http://www.s2h.co.uk/forum/" rel="nofollow - my forum . |
Posted By: brian_billington
Date Posted: 24 November 2008 at 3:00pm
|
This is correct
SQL same box
Web site - new box - same O/S and no firewalls running
 |
Posted By: 123Simples
Date Posted: 24 November 2008 at 6:51pm
|
Well surely the database connection file needs ammending then to point to the new location or am I just missing the whole point?
------------- http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design |
Posted By: WebWiz-Bruce
Date Posted: 25 November 2008 at 8:30am
|
By default many versions of SQL Server have remote connections disabled by default. You need to enable TCP/IP connections to the SQL Server on the IP address you want to use to connect to your SQL Server. You can use the SQL Server Configuration Manager on the server that SQL Server is installed to enable this. ------------- 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 |