The Service Bus for the Connected Business
When I need to set someone up for Neuron locally, I usually set up their database by going to Deployment->Databases to create it.
Below is the Test connection string that is created. When I do Test connection it says it's successful and everything seems fine, and works for me. However, I've been running into issues with other people, it basically says it can't connect to the database. I usually have to take out the 1433, or change localhost the computer name, or remove some of the connection string properties to make it connect.
Data Source=localhost,1433;Initial Catalog=Neuron;Integrated Security=True;Min Pool Size=5;Max Pool Size=1000;Connect Timeout=15;Load Balance Timeout=30;Network Library=dbmssocn
Is there any settings I can check on their computer or sql to help solve the db connection from neuron to localhost db.
Thanks,
-Nick N
Views: 172
if you're swapping out localhost or the port....it may be the library reference in the connection string. dbmssocn explicitly uses TCP to connect to sql. so if you can't connect...its probably a firewall or name resolution issue. if this a local box...you could connect using named pipes...providing named pipes is enabled for sql client installed on that box. you should check the local sql server and sql client to determine which sql network libraries are enabled
Can you also provide us the exact error you're getting?
I believe enabling TCP did the trick. However when we went to create the database, it threw the following error. When we tried again, it worked.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.WriteSni()
at System.Data.SqlClient.TdsParser.TdsExecuteTransactionManagerRequest(Byte[] buffer, TransactionManagerRequestType request, String transactionName, TransactionManagerIsolationLevel isoLevel, Int32 timeout, SqlInternalTransaction transaction, TdsParserStateObject stateObj, Boolean isDelegateControlRequest)
at System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransactionYukon(TransactionRequest transactionRequest, String transactionName, IsolationLevel iso, SqlInternalTransaction internalTransaction, Boolean isDelegateControlRequest)
at System.Data.SqlClient.SqlDelegatedTransaction.Initialize()
at System.Transactions.TransactionStatePSPEOperation.PSPEInitialize(InternalTransaction tx, IPromotableSinglePhaseNotification promotableSinglePhaseNotification)
at System.Transactions.TransactionStateActive.EnlistPromotableSinglePhase(InternalTransaction tx, IPromotableSinglePhaseNotification promotableSinglePhaseNotification, Transaction atomicTransaction)
at System.Transactions.Transaction.EnlistPromotableSinglePhase(IPromotableSinglePhaseNotification promotableSinglePhaseNotification)
at System.Data.SqlClient.SqlInternalConnection.EnlistNonNull(Transaction tx)
at System.Data.ProviderBase.DbConnectionInternal.ActivateConnection(Transaction transaction)
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 Neuron.Data.NeuronDatabaseManager.UpdateDatabase(List`1 users)
at Neuron.Explorer.FormViewDatabases.backgroundWorker_DoWork(Object sender, DoWorkEventArgs e)
Neuron ESB Product Support Forums and Communities
© 2024 Created by Neuron Admin.
Powered by
