Greetings Experts! I have a Windows 2012 R2 server that is running GFI LANguard which uses a MS SQL 2008 database to retain the search results and other information. After a restart, I opened up LANguard and am getting these error messages which relate to the database:
[CREATE DATABASE permission denied in database 'master'.]
I select OK and then the app opens but is empty of all data (I'm assuming this is because the DB isn't loaded). I downloaded and installed the SQL Server Management Studio but I have no idea what I'm doing with it. At this point, I just want to get a database (it can even be a new database at this point) to be used by the app so I can deploy Windows and 3rd party updates/patches.
I took down as much info as I could when I installed LANguard when it came to the SQL install portion. Here are the notes I have:
E:\Program Files (x86)\Microsoft SQL Server\
named instance: SQLEXPRESS
instance ID: SQLEXPRESS
instance root dir: E:\Program Files (x86)\Microsoft SQL Server\
SQL Server Database Engine: NT Authority\system
startup type: automatic
SQL Server Browser: NT Authority\local service
startup type: disabled
Authentication Mode: Windows
SQL Server admin: local\administrator
I appreciate any assistance you can provide with this!