Unexpected error - SQL Server 2005

Also get "The current datasource is unavailable
Cannot find the object "Connects" because it does not exist or you do not have permissions." when I switch to that connection view using the bottom drop down box.

Hi,
Are you administrator of the SQL Server ? Also, you must enable Mixed Mode authentification in SQL Server.

David Hervieux
Devolutions inc.

Also, what user name are you using ?

David Hervieux
Devolutions inc.

I have tried with both a user called "userRemoteDesktopManager" as well as the sa login. on the datasource setup screen it says it can connect (you can view the other database etc) but then when I switch to is with the sa user i get can not login msg... I not sure if i am in mixed mode or not, I think that has caused us issues in the past with other application (issue being it did not like mixed mode!)

Cheers fo you quick response.

Jack

It is running in mixed mode.

Does it just use standard SQL ports?

Yes it does. Can you check in the application log, located in the help menu... maybe there is more details about your error. Can you also check directly with Management studio, if the database and the tables are really created. Just a quick question, do you use the version 5.5 or 5.0 ?

Thank you

David Hervieux
Devolutions.

Version 5.5.0.0
.Net Runtime v2.0.50727
Remote Desktop: 6.0.6001.18000





Logs:


----------------------------------------------
When switchign to the sql view
----------------------------------------------
Info[12/06/2009 15:22] Upgrading database with version 3
ERROR[12/06/2009 15:22] System.Data.OleDb.OleDbException: Cannot find the object "Connections" because it does not exist or you do not have permissions.
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.ExecuteNonQuery(String aSQL, OleDbTransaction aOleDbTransaction, OleDbParameter[] aParameters)
at Devolutions.RemoteDesktopManager.Managers.DatabaseUpgradeAction.Execute()
at Devolutions.RemoteDesktopManager.Managers.DatabaseUpgradeManager.Upgrade()
at Devolutions.RemoteDesktopManager.Managers.ConnectionManager.LoadConnectionsFromDatabase(BaseConnectionDataSource aConnectionDataSource)


----------------------------------------------
Adding a user:
----------------------------------------------

ERROR[12/06/2009 15:22] System.Data.OleDb.OleDbException: Invalid object name 'UserGroupInfo'.
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet 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 Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.GetData(String aSQL, OleDbParameter[] aParameters)
at Devolutions.RemoteDesktopManager.Managers.SecurityManager.GetUserGroupInfos(Guid aUserInfoID)
at Devolutions.RemoteDesktopManager.Forms.FrmSecurityManagement.butAddUserInfo_Click(Object sender, EventArgs e)
at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
at System.Windows.Forms.ToolStripButton.OnClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ToolStrip.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
edited by jack on 6/12/2009
edited by jack on 6/12/2009

Database tables are created, I have also manually added a user in the database and it shows in the application . There are no SP.
Althoguh there does not seem to be a Connections table I have:
dbo.DatabaseInfo
dbo.GroupInfo
dbo.UserInfo

Sorted. You seem to need the application to create the DB (ie. setup up a usert that can create a database and let it do it....) if you create a database it will not create all the tables.
Bit of a bug....

Cheers

Jack

The problem that I saw, it's fail running the upgrade script :

Info[12/06/2009 15:22] Upgrading database with version 3
ERROR[12/06/2009 15:22] System.Data.OleDb.OleDbException: Cannot find the object "Connections" because it does not exist or you do not have permissions.

That the causes of all the problem.

Maybe you can try create a new database with the user "sa"...

David hervieux
Devolutions inc.