14:58:47.76 spid7s Recovery is complete. 14:58:47.49 spid13s Service Broker manager has started. 14:58:46.91 spid13s The Database Mirroring protocol transport is disabled or not configured. 14:58:46.90 spid13s The Service Broker protocol transport is disabled or not configured. 14:58:44.38 spid10s Starting up database 'tempdb'. This is an informational message no user action is required. 14:58:41.26 Server SQL Server is now ready for client connections. Further action is only required if Kerberos authentication is required by authentication policies. Failure to register an SPN may cause integrated authentication to fall back to 14:58:41.26 Server The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service.
![sql management studio 2008 r2 fails setting file security sql management studio 2008 r2 fails setting file security](https://manage.accuwebhosting.com/kb-images/restore-mssql-db-from-ssms/01-open-sql-server-management-studio.jpg)
14:58:41.23 spid10s Clearing tempdb database. If you want to use a dedicated administrator connection, restart SQL Server using the trace flag 7806. 14:58:40.88 Server Dedicated administrator connection support was not started because it is disabled on this edition of SQL Server. 14:58:40.83 Server Server local connection provider is ready to accept connection on. 14:58:40.71 Server A self-generated certificate was successfully loaded for encryption. 14:58:40.30 spid7s Starting up database 'msdb'. 14:58:40.30 spid7s Informational: No full-text supported languages found.
![sql management studio 2008 r2 fails setting file security sql management studio 2008 r2 fails setting file security](https://i.stack.imgur.com/MmW81.png)
![sql management studio 2008 r2 fails setting file security sql management studio 2008 r2 fails setting file security](https://blog.sqlauthority.com/i/d/setup-dotnet-warning-01.jpg)
14:58:39.91 spid10s Starting up database 'model'. 14:58:35.77 spid7s The resource database build version is. 14:58:35.58 spid7s Starting up database 'mssqlsystemresource'. 14:58:34.60 spid7s SQL Trace ID 1 was started by login "sa". 14:58:31.64 spid7s FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'SQLEXPRESS'. 14:58:26.91 spid7s Recovery completed for database master (database ID 1) in 1 second(s) (analysis 350 ms, redo 170 ms, undo 545 ms.) This is an informational message only. 14:58:26.46 spid7s Recovery is writing a checkpoint in database 'master' (1). 14:58:23.79 spid7s Starting up database 'master'. This message provides a description of the NUMA configuration for this computer. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. 14:58:10.65 Server Using dynamic lock allocation. 14:58:06.24 Server SQL Server is starting at normal priority base (=7). l c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\mastlog.ldf e c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Log\ERRORLOG d c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\master.mdf 14:58:05.62 Server Registry startup parameters:
![sql management studio 2008 r2 fails setting file security sql management studio 2008 r2 fails setting file security](https://support.content.office.net/en-us/media/d5e0fca6-26fd-131e-6613-6d9d0d5a66d0.png)
This is an informational message only no user action is required. 14:58:05.27 Server Logging SQL Server messages in file 'c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Log\ERRORLOG'. 14:58:05.27 Server Authentication mode is WINDOWS-ONLY. 14:58:05.24 Server System Manufacturer: 'Dell Inc.', System Model: 'Inspiron 5558'.
Sql management studio 2008 r2 fails setting file security windows#
22 (X64)Ĭopyright (c) 1988-2008 Microsoft CorporationĮxpress Edition with Advanced Services (64-bit) on Windows NT 6.2 (Build 9200: ) C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Log