Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Cancel
- Home
- :
- All Communities
- :
- Products
- :
- Data Management
- :
- Data Management Questions
- :
- SQL service stops inmidiatly I Start it
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
SQL service stops inmidiatly I Start it
Subscribe
1627
0
01-29-2014 08:23 AM
by
Anonymous User
Not applicable
01-29-2014
08:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
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
0 Replies