HomeHome Product Discus... Product Discus...SmithCartSmithCartTrying to install the 4.21 trial and failing due to SQL errorTrying to install the 4.21 trial and failing due to SQL error
Previous
 
Next
New Post
3/9/2011 11:10 AM
 

Module install reports no errors, but when attempting to add BuyNow module to page the following error occurs:

Error: Smith.BuyNow 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) ---> 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) 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.SqlHelper.ExecuteDataset(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(String connectionString, String spName, Object[] parameterValues) at Smith.DNN.Modules.BuyNow.SqlDataProvider.GetCountry() at Smith.DNN.Modules.BuyNow.ProductsController.GetCountry() at Smith.DNN.Modules.BuyNow.Settings.LoadSettings() --- End of inner exception stack trace ---

Rest of the site works fine and has no SQL access issues.

Site configuration - Server 2008, SQL Server 2005, DNN 5.6.0

Missing table possibly?

 
New Post
3/9/2011 1:27 PM
 

Freaky. But the rest of your DNN site is working, on that same SQL server?

 
New Post
3/9/2011 1:38 PM
 

Everything else works perfectly. Even tried a new clean install for the cart and same effect. I'm think it may be a table missing or provider issue. Can't think of anything else that would do this considering everything else on the site works perfectly fine. I think the connect error may be a bit bogus and it is something else, but yet SQL related.

How many tables to you actually create? I can at least check the count of the smith.nnn tables that were created to see if they match the count you believe should be installed.

 
New Post
3/9/2011 3:03 PM
 

Curious ... does the cart normally install ok in a medium trust environment?

 
New Post
3/9/2011 3:15 PM
 

Changed it to Full Trust ... made no difference. Same error as noted above.

 
New Post
3/9/2011 3:37 PM
 

... and have noticed a resources.zip.manifest gets drop at the root of DeskTopModules and does not get cleaned up / moved.

 
New Post
3/9/2011 5:13 PM
 
datamax1 wrote:

Everything else works perfectly. Even tried a new clean install for the cart and same effect. I'm think it may be a table missing or provider issue. Can't think of anything else that would do this considering everything else on the site works perfectly fine. I think the connect error may be a bit bogus and it is something else, but yet SQL related.

How many tables to you actually create? I can at least check the count of the smith.nnn tables that were created to see if they match the count you believe should be installed.



As of 4.1 there are 51 tables, what version of IIS / SQL are you running?
Thanks,
Christian
 
New Post
3/9/2011 9:27 PM
 

IIS 6 - Full trust setup

SQL Server 2005

Numerous restarts of IIS before and after reinstall of the cart, and even re-booted the server. No love ... still get the error noted above.

 
New Post
3/9/2011 10:57 PM
 

I did a little googling, and found this post on the DNN site(http://www.dotnetnuke.com/tabid/795/f...) , try the following things:

1. Go to SQL Management Studio, right-click on your server, select properties and click on Security. Ensure that Server authentication is set to "SQL Server and Windows Authentication mode".

2. In the same properties window, click on Connections. Ensure that the allow Remote Connection checkbox is ticked.

3. Also, go back to the database view in Management studio. Expand the tree under your server. Click on Security. Click on Logins. Right-click plusbay and select properties. Click on User Mapping. Ensure that your 'plusbay' account has dbowner privileges on the (empty) database you created for the DNN install.





Thanks,

Christian

 
New Post
3/10/2011 9:46 AM
 

Keep in mind ALL other SQL consuming modules on the website and the website itself use SQL connections and there are no issues, so what you recommend as a possible solution likely doesn't have any relationship. Trust me ... I've Googled this issue for hours as well. I've even tried using sa with full admin priviledges and nothing changes - the connection error remains. Do you guys have any known issues with 4.21 on DNN 5.06 which could be in any manner related to what we are seeing here? Is there a previous release which is more widely in use versus 4.21? I'll try one more install of a prior trial release if there is any merit to the effort. Sadly, if I can't get the trial to install today I'll have to move on and try another cart. Nothing personal ... just don't have the cycles to burn on chasing the issue any longer.

 
New Post
3/10/2011 10:12 AM
 

Found the problem ... your cart uses the old legacy appSettings connect string in the web.config. Turned it on and it now connects.

 
New Post
3/10/2011 11:16 AM
Accepted Answer 

We havnt have any errors like this reported before so its most likely rellated to comething in your environment. The cart runs in medium trust fine unless you are running a payment gateway that requires full trust like First Data. What is your hosting environment setup are you using a host like godaddy or hosting your own dedicated servers?

Noodling the issue the following items come to mind that may help in resolving the problem:

  • The country table is referenced in the error log you posted can you check to make sure the country table has records in it.
  • Connection timeout - increase your connection timeout on sql server
  • Make sure the sql server login is not locked out
  • Make sure your sql server is using mixed mode and your using a sql server id with db owner permissions on all tables and sprocs
  • If you are running dedicated hosting, as a test try using the "sa" account in your web config to see if it works with the god account. Make sure you change it back after testing.
  • SQL Server connections could be maxed out make sure you have unlimited sql server connections configured. If you execute the following command from query analyzer it sets your connections to unlimited. Please make sure you have a full backup of your sql server before running this command.

--'user connections' 0=unlimited, change to an integer value if you wanted, say 800 maximum
sp_configure 'user connections', 0
GO
RECONFIGURE


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
8/24/2011 7:58 AM
 

Hi Lee!

You said "...the old legacy appSettings connect string in the web.config. Turned it on and it now connects"

What exactly did you have to do to 'Turn it on'?

 

Did you just add a connection string in web.config, or did you alter some setting in Host menu?

 

Help!

 

Thanks.

 

 

 
New Post
8/24/2011 2:34 PM
 
Hello,

Which version of DNN and the Cart are you running? Also can you please provide more details about your issue?

Thanks,
 
New Post
8/24/2011 2:45 PM
 

I got it to work - I put in the proper DB connection in the legacy connection string in appSettings.

 

When will the product be updated to use the new ConnectionStrings section?

 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartTrying to install the 4.21 trial and failing due to SQL errorTrying to install the 4.21 trial and failing due to SQL error