Ошибка входа пользователя гость

Hi go9189,

According to your description, you come across the error that User ‘guest’ does not have permission to run DBCC checkprimaryfile. This issue could happen when the login account doesn’t have CREATE DATABASE, CREATE ANY DATABASE,
or ALTER ANY DATABASE permission in SQL Server instance, or that the login account has no access to the mdf and ldf files when attaching database, so SQL Server recognize the login account as a «Guest».

To solve the issue, you could pay attention to the points below.

1. Ensure that the login account has at least CREATE DATABASE, CREATE ANY DATABASE, or ALTER ANY DATABASE permission. You could grant the fixed server role ‘dbcreator’ or ‘sysadmin’ to the login account following the steps below.

a. Connect to SQL Server instance with the login account which has sysadmin fix server role.

b. Expand the folder ‘Security’, right click the login, and select Properties.

c. In the Server Roles tab, check the checkbox for ‘dbcreator’ or ‘sysadmin’.

2. Make sure that the the login account has full control permission on the mdf and ldf files. For how to grant the login account with full control permission on the mdf and ldf files, please refer to the steps in the following article:
http://msdn.microsoft.com/en-us/library/bb727008.aspx

There is a similar thread for your reference:
https://social.technet.microsoft.com/Forums/en-US/e463df4c-8d26-46cf-aa2e-bddd97c7a9b8/user-guest-does-not-have-permission-to-run-dbcc-checkprimaryfile?forum=sqlgetstarted

Regards,
Michelle Li

• Edited by

  Tuesday, January 20, 2015 2:18 PM

• Proposed as answer by
  Michelle Li
  Friday, January 23, 2015 1:47 AM
• Marked as answer by
  Lydia ZhangMicrosoft contingent staff
  Tuesday, January 27, 2015 3:49 AM

Hi go9189,

According to your description, you come across the error that User ‘guest’ does not have permission to run DBCC checkprimaryfile. This issue could happen when the login account doesn’t have CREATE DATABASE, CREATE ANY DATABASE,
or ALTER ANY DATABASE permission in SQL Server instance, or that the login account has no access to the mdf and ldf files when attaching database, so SQL Server recognize the login account as a «Guest».

To solve the issue, you could pay attention to the points below.

1. Ensure that the login account has at least CREATE DATABASE, CREATE ANY DATABASE, or ALTER ANY DATABASE permission. You could grant the fixed server role ‘dbcreator’ or ‘sysadmin’ to the login account following the steps below.

a. Connect to SQL Server instance with the login account which has sysadmin fix server role.

b. Expand the folder ‘Security’, right click the login, and select Properties.

c. In the Server Roles tab, check the checkbox for ‘dbcreator’ or ‘sysadmin’.

2. Make sure that the the login account has full control permission on the mdf and ldf files. For how to grant the login account with full control permission on the mdf and ldf files, please refer to the steps in the following article:
http://msdn.microsoft.com/en-us/library/bb727008.aspx

There is a similar thread for your reference:
https://social.technet.microsoft.com/Forums/en-US/e463df4c-8d26-46cf-aa2e-bddd97c7a9b8/user-guest-does-not-have-permission-to-run-dbcc-checkprimaryfile?forum=sqlgetstarted

Regards,
Michelle Li

• Edited by

  Tuesday, January 20, 2015 2:18 PM

• Proposed as answer by
  Michelle Li
  Friday, January 23, 2015 1:47 AM
• Marked as answer by
  Lydia ZhangMicrosoft contingent staff
  Tuesday, January 27, 2015 3:49 AM