AnsweredAssumed Answered

SQL service stops inmidiatly I Start it

Question asked by geonetadmin on Jan 29, 2014
Original User: diegollamas

Hi,

I was trying to access to my geodatabase and I got an error "Faileure to access the DBMS server". So I went and check sql and notice that the service was not running or stopped [ATTACH=CONFIG]30941[/ATTACH] it started with no problem, after I check my database I got the same error. I check properties of my services and even tough my service said it is running it is not [ATTACH=CONFIG]30942[/ATTACH] [ATTACH=CONFIG]30942[/ATTACH] this happen suddenly because it was working fine.
I checked SQL server Management studio and I got this error when I try to connect to it [ATTACH=CONFIG]30943[/ATTACH]

in the log error file I got: access denied but I have administrator privileges.

Error: 17204, Severity: 16, State: 1.
2014-01-28 14:12:33.34 spid15s     FCB::Open failed: Could not open file e:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\GIS_ADM_TERRENOS.mdf for file number 1.  OS error: 5(Access is denied.).
2014-01-28 14:12:33.35 spid15s     Error: 5120, Severity: 16, State: 101.
2014-01-28 14:12:33.35 spid15s     Unable to open the physical file "e:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\GIS_ADM_TERRENOS.mdf". Operating system error 5: "5(Access is denied.)".
2014-01-28 14:12:33.40 spid6s      The resource database build version is 11.00.2100. This is an informational message only. No user action is required.
2014-01-28 14:12:33.42 spid15s     Error: 17207, Severity: 16, State: 1.
2014-01-28 14:12:33.42 spid15s     FileMgr::StartSecondaryDataFiles: Operating system error 2(The system cannot find the file specified.) occurred while creating or opening file 'e:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\VECTOR01_GIS_ADM_TERRENOS.ndf'. Diagnose and correct the operating system error, and retry the operation.
2014-01-28 14:12:33.42 spid15s     Error: 5120, Severity: 16, State: 5.
2014-01-28 14:12:33.42 spid15s     Unable to open the physical file "e:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\VECTOR01_GIS_ADM_TERRENOS.ndf". Operating system error 2: "2(The system cannot find the file specified.)".
2014-01-28 14:12:33.42 spid15s     Error: 17207, Severity: 16, State: 1.
2014-01-28 14:12:33.42 spid15s     FileMgr::StartSecondaryDataFiles: Operating system error 2(The system cannot find the file specified.) occurred while creating or opening file 'e:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\DELTA01_GIS_ADM_TERRENOS.ndf'. Diagnose and correct the operating system error, and retry the operation.
2014-01-28 14:12:33.42 spid15s     Error: 5120, Severity: 16, State: 5.
2014-01-28 14:12:33.42 spid15s     Unable to open the physical file "e:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\DELTA01_GIS_ADM_TERRENOS.ndf". Operating system error 2: "2(The system cannot find the file specified.)".
2014-01-28 14:12:33.42 spid15s     Error: 17207, Severity: 16, State: 1.
2014-01-28 14:12:33.42 spid15s     FileMgr::StartSecondaryDataFiles: Operating system error 2(The system cannot find the file specified.) occurred while creating or opening file 'e:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\RASTER01_GIS_ADM_TERRENOS.ndf'. Diagnose and correct the operating system error, and retry the operation.
2014-01-28 14:12:33.42 spid15s     Error: 5120, Severity: 16, State: 5.
2014-01-28 14:12:33.42 spid15s     Unable to open the physical file "e:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\RASTER01_GIS_ADM_TERRENOS.ndf". Operating system error 2: "2(The system cannot find the file specified.)".
2014-01-28 14:12:33.42 spid15s     Error: 17207, Severity: 16, State: 1.
2014-01-28 14:12:33.42 spid15s     FileMgr::StartLogFiles: Operating system error 2(The system cannot find the file specified.) occurred while creating or opening file 'e:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\GIS_ADM_TERRENOS_log.ldf'. Diagnose and correct the operating system error, and retry the operation.
2014-01-28 14:12:33.42 spid15s     File activation failure. The physical file name "e:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\GIS_ADM_TERRENOS_log.ldf" may be incorrect.
2014-01-28 14:12:33.43 Server      The SQL Server Network Interface library successfully registered the Service Principal Name (SPN) [ MSSQLSvc/VMS-GIS02.ADM_TERRENOS.LOCAL ] for the SQL Server service.
2014-01-28 14:12:33.43 Server      The SQL Server Network Interface library successfully registered the Service Principal Name (SPN) [ MSSQLSvc/VMS-GIS02.ADM_TERRENOS.LOCAL:1433 ] for the SQL Server service.
2014-01-28 14:12:33.50 spid6s      Starting up database 'model'.
2014-01-28 14:12:33.56 spid6s      Clearing tempdb database.
2014-01-28 14:12:33.57 spid6s      Error: 5123, Severity: 16, State: 1.
2014-01-28 14:12:33.57 spid6s      CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'e:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\tempdb.mdf'.
2014-01-28 14:12:33.57 spid6s      Error: 17204, Severity: 16, State: 1.
2014-01-28 14:12:33.57 spid6s      FCB::Open failed: Could not open file e:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\tempdb.mdf for file number 1.  OS error: 5(Access is denied.).
2014-01-28 14:12:33.57 spid6s      Error: 5120, Severity: 16, State: 101.
2014-01-28 14:12:33.57 spid6s      Unable to open the physical file "e:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\tempdb.mdf". Operating system error 5: "5(Access is denied.)".
2014-01-28 14:12:33.57 spid6s      Error: 1802, Severity: 16, State: 4.
2014-01-28 14:12:33.57 spid6s      CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
2014-01-28 14:12:33.57 spid6s      Could not create tempdb. You may not have enough disk space available. Free additional disk space by deleting other files on the tempdb drive and then restart SQL Server. Check for additional errors in the event log that may indicate why the tempdb files could not be initialized.
2014-01-28 14:12:33.57 spid6s      SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
2014-01-28 14:12:34.59 spid6s      Error: 25725, Severity: 16, State: 1.

Hope anyone can help me with this...

thanks
DLL

Attachments

Outcomes