sql database on other drive
Hi all,
New to sql express here. Playing around with failing permissions on a I need to install SQL Express and Management Studio. Although the default installation is on C:, I want my database files on another drive. So on my S: drive I created a database folder.
After installing, I tested it on my workstation and got permission errors.
Back on the server, I granted NT SERVICE\MSSQL$EXPRESS full permissions on that folder. But it is not showing the NT SERVICE\MSSQL$EXPRESS, just MSSQL$EXPRESS under security.
Back to the workstation. Running the software as an elevated administrator works. Standard users do not.
So back on the server: since the AD users are in a security group called Management, I created the same group (under security) in SQL Configuration Manager and assigned it the sysadmin role.
The software starts, but… it takes 30 seconds to open. Running it as admin is fast.
I think this is a permission issue with MSSQL$EXPRESS. Can anyone advice?