Connection Problems

Hi,

I have a problem with my forum, my host has recently upgraded to sql 2008 from 2005. With 2005 it was working fine but since the upgrade i get the error:


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
[DBNETLIB][ConnectionOpen (Invalid Instance()).]Invalid connection.


I tried a complete new install with a fresh database but get the error:

Detailed Error Message:
[DBNETLIB][ConnectionOpen (Invalid Instance()).]Invalid connection.

Error Details:
[DBNETLIB][ConnectionOpen (Invalid Instance()).]Invalid connection.

I have upgraded to the lastest version of webwiz forums with a clean install but still no luck. Is there something i need to do?

Many Thanks
Joel

 I have asked my host and they have now sorted the problem. The solution was to add the port number in the server name in the database_connection.asp file

i.e.

strSQLServerName = "sql01,1433"

Hope this helps anyone in the future