Invenmanager User Forum

Hi,
I bought and Installed The Facility Booking Module but when I Put the mdule on the page I get the following error(s):


Error: Appointment Booking is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) ---> System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at FacilityBooking.Data.SqlDataProvider.ListActiveFB_Facility(Int32 moduleID) at FacilityBooking.FB_FacilityController.ListActive(Int32 moduleID) at FacilityBooking.ViewByDate.DisplayBookingInfo() at FacilityBooking.ViewByDate.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---


The installation of the Module was successfull.. I even checked my DNN Database to make sure the Tables and The Stored Proc are created successfuly....

My DNN Version is: 4.8.4
I am using SQL Server 2005 ....
FB version is: 2.1.2..


So please Let me know what could be the problem....


Thanks,

Sam Bitar

Can you send me a copy of your web.config file? You can blank out the password and SQL server name for your connection string.

I think it is because of that.

Hi,
I sent my Web.config almost couple of weeks ago and I am not getting any solution for the problem I am having... the Tech support is not responding back to my E-mails.... Is there anyone looking after This problem ???

Please, Let me know as soon as possible.

Thanks,

Sam Bitar
sbitar@aacs.ca

Sam, we did not receive any web.config file from you, which email did you send to?

You can send to support@invenmanager.com

We guarantee response within 24 hours, usually it is within hours, even minutes.

Hi,
I sent it to support@invenmanager.com
May be went to Spam or something ???

Sam

No, did not receive it.
Can you zip it up and then post it here? I suppose it is not confidential once you blank out the server name and password.?

Hi,
I attached the web.config as a Zip File.. Let me know what you think the problem..

Sam Bitar

I am sorry, but I could not find a way to attach my File After posting my Previous Message... Let me know if you want me to Cut/Paste the Web.config in here ...

Thanks,

Sam bitar

When you click on Add Reply, you will see three file upload below the message text box, upload the file in zip format. Thanks

Hi,
The file attachment wasnt available before.. did you give me certain permission to upload files ??

the web.config is in zip format....

please let me know what happens...

Sam

1. Do you have same problem with other modules?

2. You have specified the server connection to SQL server at two lines, (one is kept to make it compatible with legacy modules), so I suppose this is correct. Can you also make sure the both server, password are specified correctly at your environment?

Hi,
1) all other modules are working correctly with my current web.config without any problem as I see with your Module..

2) Password / server are fine on both lines because they are the same and all the other modules are working fine with them Except your Module...

Can you send me the source code So I can have a look at it and probably help you fix this problem ?? I am a DNN Developer as well...

Thanks,

Sam Bitar

Hi, Sam, I tried your web.config at our environment and it works just fine.

So I am not sure what could be wrong, I can send you the source codes, please send an mail to gary@invenmanager.com and I will reply you with the source codes.

Thanks.