![]() When the database is reattached, the database files permissions will be set to Login that attempts to attach the database. Theĭatabase files permissions need to be granted explicitly to allow either the DatabaseĮngine security identifier (SID) NT SERVICE\MSSQLSERVER or the Windows Permissions will be set to only the Windows login that detached the database. When a database is detached using a Windows login, the detached mdf and ldf file ![]() Some file names listed could not be created. ![]() Operating system error 5: "5(Access is denied.)".ĬREATE DATABASE failed. Unable to open the physical file "D:\SQLDATA\MSSQL13.MSSQLSERVER\MSSQL\DATA\TestDB.mdf". ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |