Jump to content
AIDA64 Discussion Forum

Recommended Posts

Please, help.

How to create a database for aida64 using .sql files stored in the SQL schema folder?

We have a SQL server 2008 R2 installed.

Thank you in advance.

Share this post


Link to post
Share on other sites

You can initialize the database using SQL Server Management Studio. You need to use the SQL schema file DB - SQL Server.sql that you can find in the AIDA64 installation ZIP package or its installation folder.

Regards,

Fiery

Share this post


Link to post
Share on other sites

The file opens with SQL management studio but what should be done next? It must be just executed? Does it require a preconfigured database?

Please, give some directions.

Share this post


Link to post
Share on other sites

The schema will initialize the database, so all you need is create an empty database (name it e.g. aida64), and then run the script. You may need to remove the first two dash characters to make sure the script would use the right database.

Please note that the SQL module of AIDA64 is designed for experienced SQL users -- that's why it's not documented too much :) If you're unsure about how to configure a SQL Server, then you may want to switch to creating CSV reports and use the Audit Manager and Change Manager based on CSV reports. It may be an easier way to collect and sort out reports.

Share this post


Link to post
Share on other sites

Thank you so much! That's exactly what I needed i.e. these two dashes at the beginning were the point I was stuck at.

My SQL database now runs OK.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

  • Similar Content

    • By wow
      We are trying to use the audit report with SQL to collect information about our systems...
      When configuring the GPO (linked to ALL OU in our forest) the results are showing only the servers and/or Domain Admin users
      All regular workstations and domain users are left out!
      This is the command line (as directed by the user guide):
      GPO > User Conf \ Pol \ Win Set \ Scr \ Logon
      Name = %servershare%\aida64be.exe | Parameters = /r /database /audit /safe /silent
      The connection to the DB is tested successfully and all SERVERS in the network are showing to the report, but none of the other computers/users do!
      It's also common to have the user logging in and the AIDA64 app report crashing, but that is another issue that I have no idea why is happening (including the servers)...
      Any help would be greatly appreciated!
       
    • By Kyle.Davies
      Hi i need some help i have installed SQL and set it up on a test VM, when i run Aida64 from command line to insert into the database it gives me this error: Warning: Error occured during report generation process
       
      SQL is installed on a windows 7 pr 32bit VM, and i tried aida on XP, Win7, Win8.
       
      Please i need help

×
×
  • Create New...