Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Additional SQL Server 5123 database reported error     - Git Rebase Tutorial: Using Git Rebase turn back the clock (Linux)

- Use smartmontools view the health status of hard disk (Linux)

- installation process of Matlab 2012a under Ubuntu 14.04 (Linux)

- How to fix Not Enough Free Disk Space On / boot on Ubuntu (Linux)

- ld.so.conf.d profile (Linux)

- Fedora 19/20 and Debian Jessie / Sid users to install FFmpeg 2.3.2 (Linux)

- How to fix apt-get update can not add a new CD-ROM error (Linux)

- Android Touch message passing mechanism analysis (Programming)

- Additional SQL Server 5123 database reported error (Database)

- Linux Tutorial ---- fundamentals of data traffic redirection (Linux)

- Linux System Getting Started Tutorial: Five image processing software (Linux)

- Those things packaged using Gradle to Android (Programming)

- How do you prevent other users from accessing your home directory in Linux (Linux)

- Ubuntu disable graphics card (Linux)

- CentOS 6.6 command-line automatic completion (Linux)

- Java synchronization mechanism: synchronized, wait, notify (Programming)

- Oracle 12c of the auto-increment Identity Columns (Database)

- Example of use WebSocket (Programming)

- Oracle 10g after the failure to start the upgrade (Oracle instance terminated. Disconnection forced) (Database)

- CentOS 6.x systems installation + NIC driver installation (Realtek PCIe GBE Family Controller for Linux) (Linux)

 
         
  Additional SQL Server 5123 database reported error
     
  Add Date : 2018-11-21      
         
         
         
  Recent home computers from WIN7 upgraded to WIN10. After installing the software and commonly used SQL SERVER, some additional test database

figure-1: Use SSMS additional database file error

Try to use the script, while being given:

figure-2: Additional database files using SQL script error

Tips from the wrong point of view, it is estimated to insufficient permissions operated by a user for file access. But whether you use windows authentication login or sa login, all reported the same mistake. Strange, their computers are using administrator privileges. Go check the database file permissions, found that:

figure-3: security attributes of the database file

Not even administrators do not have read access to this file! Click the "Advanced" option:

figure-4: security attributes of the database file - Advanced


Then I have the impression, it should be the owner of the file before another user is the administrator (you must specify a user WIN10 install), I got used to using the administrator user, after installing I delete a user created during installation , and instead use the administrator. So the owner of the file is amended as administrator, and Sql Server Configuration Manager to modify the startup user:

figuer-5: Sql Server Configuration Manager-Log On

Then restart the instance, using windows authentication to attach the database, a success. Sa retest using additional databases, but also successful. Although the problem is solved, but for SQL SERVER, it depends on the security configuration on windows security permissions great program that he is not very skilled and thorough understanding in this regard
     
         
         
         
  More:      
 
- Justniffer installed on Ubuntu 15.04 (Linux)
- RHEL5 establish a local yum source (Linux)
- About Linux backdoor (Linux)
- Mount NFS network file system (Linux)
- Ubuntu system grub repair method (Linux)
- No password on Oracle and MySQL login (Database)
- PHP 7.0 Upgrade Notes (Linux)
- Spring AOP (Programming)
- Linux scheduling summary (Linux)
- How SSHfs mount a remote file system on Linux (Linux)
- Oracle Character Set Summary (Database)
- Linux command ls (Linux)
- GNU / Linux enable Intel Rapid Start (Linux)
- Oracle 11g principle study Dataguard (Database)
- Oracle TAF Analysis (Database)
- Python3 multi-thread download codes (Programming)
- Ubuntu Server security risk checks (Linux)
- To add the Oracle JDBC driver in Maven repository (Linux)
- iOS in the event delivery and the responder chain (Programming)
- Win7 + Ubuntu Kylin + CentOS 6.5 installed three systems (Linux)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.