You can find registration steps above link: http://www.konsys-international.com/doc/energymanagement/AVReporterRegistration.swf
I re-installed AVR (and .Net and SQL files), but I am still not able to link to the SMS database. Here is error message. TITLE: Microsoft SQL Server Management Studio Express ------------------------------ An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo) ------------------------------ ADDITIONAL INFORMATION: Cannot open backup device 'D:\SMS Database\SMS_AR_Report.bak'. Operating system error 5(Accès refusé.). RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3201) For help, click: http://go.microsoft.com/fwlink?Prod...35&EvtSrc=MSSQLServer&EvtID=3201&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ =================================== An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo) ------------------------------ Program Location: at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteWithResults(String sqlCommand) at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteWithResults(String query) at Microsoft.SqlServer.Management.Smo.BackupRestoreBase.ExecuteSqlWithResults(Server server, String cmd) at Microsoft.SqlServer.Management.Smo.Restore.ReadBackupHeader(Server srv) at Microsoft.SqlServer.Management.SqlManagerUI.SqlRestoreDatabaseGeneral.buttonSelectDevice_Click(Object sender, EventArgs e) at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Button.OnClick(EventArgs e) at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ButtonBase.WndProc(Message& m) at System.Windows.Forms.Button.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) =================================== Cannot open backup device 'D:\SMS Database\SMS_AR_Report.bak'. Operating system error 5(Accès refusé.). RESTORE HEADERONLY is terminating abnormally. (.Net SqlClient Data Provider) ------------------------------ For help, click: http://go.microsoft.com/fwlink?Prod...35&EvtSrc=MSSQLServer&EvtID=3201&LinkId=20476 ------------------------------ Server Name: WXFR050063L\KONSYS Error Number: 3201 Severity: 16 State: 2 Line Number: 1 ------------------------------ Program Location: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.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(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteWithResults(String sqlCommand)
First let me summarize (just to know, where you are currently on the stup process): You installed all AVR modules and SQL server 2005 and now you're trying to restore the database I sent From the error message you sent it looks like the SQL server does not have access rights to the path in your D drive (D:\SMS Database\). My suggestion: copy the backup (bak) file to the default SQL backup directory in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\ (this path is correct only if you have installed the SQL server into the default directory) - it is always accessible for the SQL server process, and try to restore the database from there. If it still does not work, I'll send You a restored database (2 files) - the restoring process from them is different, and a little bit shorter and easier... Relating to your last email: MS SQL Prerequisites: you don't have to install them unless your MS SQL Server setup requires a component, or you would like to manage your server with management studio (so most of the cases you don't need anything of them - because your Windows already contains them, or you don't want to manage the SQL server) changing the button color after installation is a good (and not expensive) idea we'll include it into the next installer package .NET setup: same situation than SQL prerequisites: if you don't have .NET installed, the AVR setup modules won't start, and will force you to install it; and if you already have .NET installed, and you click to the .NET installer button, the setup application will notify you that you already have it, and you don't need to reinstall (but if you would like you may do it)
