SQL error 26 - D-Tools Forum

John@OnyxTheaters · 05-14-2010, 05:08 PM

When I am trying to check in or check out a project, it lags for a moment and then gives me an error. I look at the error details and it has SQL error 26 in it. Anyone have a solution for this? I am connecting through VPN at my office to the server at home.

Thanks.

John@OnyxTheaters · 05-14-2010, 05:22 PM

Description: 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)
Email:
User Message:
Details: Error: SqlException ErrorCode=-2146232060 (DTools.SystemIntegrator.BusinessManager.DAL.Proje ctDataSetTableAdapters.tblProjectClientInformation TableAdapter.GetProject) (DTools.SystemIntegrator.SDK.ProjectFactory.GetDat a) (DTools.SystemIntegrator.BusinessManager.Schedulin g.TaskHelper.getSDKProject) (DTools.SystemIntegrator.BusinessManager.Views.Ord erShell.ActiveProject_PropertyChanged) (DTools.FileManager.Data.ProjectInfo.SendPropertyC hanged) (DTools.FileManager.Data.ProjectInfo.set_CheckOutU serName) (DTools.FileManager.ProjectInfoExtensions.UpdateFr om) (DTools.FileManager.ProjectService.updateBindingLi st) (DTools.FileManager.ProjectService.CheckinProject) (DTools.SystemIntegrator.Navigator.NavigatorShell. OnCheckInProject) (DTools.SystemIntegrator.Navigator.CommandManageme nt.Command.Execute) (DTools.SystemIntegrator.Navigator.CommandManageme nt.LinkLabelCommandExecutor.linkLabel_Click) V5.5.0.0

Source: .Net SqlClient Data Provider

Stacktrace:
at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(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.Att emptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.Log inNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at System.Data.SqlClient.SqlInternalConnectionTds.Ope nLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ct or(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateC onnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.Creat ePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateOb ject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCrea teRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConne ction(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection, ConnectionState& originalState)
at System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at DTools.SystemIntegrator.BusinessManager.DAL.Projec tDataSetTableAdapters.tblProjectClientInformationT ableAdapter.GetProject(String ProjectGUID)
at DTools.SystemIntegrator.SDK.ProjectFactory.GetData (String ProjectGUID)
at DTools.SystemIntegrator.BusinessManager.Scheduling .TaskHelper.getSDKProject(String projectGUID)
at DTools.SystemIntegrator.BusinessManager.Views.Orde rShell.ActiveProject_PropertyChanged(Object sender, PropertyChangedEventArgs e)
at System.ComponentModel.PropertyChangedEventHandler. Invoke(Object sender, PropertyChangedEventArgs e)
at DTools.FileManager.Data.ProjectInfo.SendPropertyCh anged(String propertyName)
at DTools.FileManager.Data.ProjectInfo.set_CheckOutUs erName(String value)
at DTools.FileManager.ProjectInfoExtensions.UpdateFro m(ProjectInfo proj, ProjectInfo source, Boolean updateFiles, Boolean updateAllProperties)
at DTools.FileManager.ProjectService.updateBindingLis t(IProjectInfo proj)
at DTools.FileManager.ProjectService.CheckinProject(G uid id)
at DTools.SystemIntegrator.Navigator.NavigatorShell.O nCheckInProject(Command cmd)
at DTools.SystemIntegrator.Navigator.CommandManagemen t.Command.Execute()
at DTools.SystemIntegrator.Navigator.CommandManagemen t.LinkLabelCommandExecutor.linkLabel_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.Label.WndProc(Message& m)
at System.Windows.Forms.LinkLabel.WndProc(Message& msg)
at System.Windows.Forms.Control.ControlNativeWindow.O nMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.W ndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Errors=System.Data.SqlClient.SqlErrorCollection
Class=20 (0x14)
LineNumber=0 (0x0)
Number=-1 (0xFFFFFFFF)
Server=
State=0 (0x0)
ErrorCode=-2146232060 (0x80131904)
Message=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)
Data=System.Collections.ListDictionaryInternal

**Dave Kirn** · 05-14-2010, 11:01 PM

This would be a question for tech support

D-Tools Inc. - D-Tools Support Home