samiam41
asked on
SQL Express 2008 DB error
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:
server01
E:\Program Files (x86)\Microsoft SQL Server\
named instance: SQLEXPRESS
instance ID: SQLEXPRESS
instance root dir: E:\Program Files (x86)\Microsoft SQL Server\
service accounts
SQL Server Database Engine: NT Authority\system
startup type: automatic
SQL Server Browser: NT Authority\local service
startup type: disabled
Account Provisioning
Authentication Mode: Windows
SQL Server admin: local\administrator
I appreciate any assistance you can provide with this!
[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:
server01
E:\Program Files (x86)\Microsoft SQL Server\
named instance: SQLEXPRESS
instance ID: SQLEXPRESS
instance root dir: E:\Program Files (x86)\Microsoft SQL Server\
service accounts
SQL Server Database Engine: NT Authority\system
startup type: automatic
SQL Server Browser: NT Authority\local service
startup type: disabled
Account Provisioning
Authentication Mode: Windows
SQL Server admin: local\administrator
I appreciate any assistance you can provide with this!
I guess that the user for LANguard should have SysAdmin role in the SQL Server instance.
ASKER
Thank you for the reply. Where would I add the user to the SQL Server instance? {I have about an hour of SQL experience)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the help!