I am using Windows 2012 R2 Edition with Plesk Obsidian. Hosted 100+ Websites with mssql 2008, 2012 and 2014. Now i cant create MSSQL2008 Databases on this server. When i am trying to creating a new mssql2008 databases, it will show a popup error.
Error: Connection to the database server has failed because the supplied account does not possess administrative privileges: Failed to create new database 'zrackzo1_56hhff': SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]A file activation error occurred. The physical file name '\zrackzo1_56hhff.mdf' may be incorrect. Diagnose and correct additional errors, and retry the operation.
This error only for mssql 2008
Error: Connection to the database server has failed because the supplied account does not possess administrative privileges: Failed to create new database 'zrackzo1_56hhff': SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]A file activation error occurred. The physical file name '\zrackzo1_56hhff.mdf' may be incorrect. Diagnose and correct additional errors, and retry the operation.
This error only for mssql 2008