I'm getting this error when I try to log into SSMS Error9100. Any ideas on how to solve this?

Question

I'm getting this error when I try to log into SSMS Error9100. Any ideas on how to solve this?

Eugene M Roseboro Jr 21

Hung-Chun Yu 981 Reputation points Microsoft Employee Moderator

2021-05-06T00:31:18.81+00:00

Hi

Thank you for contacting Microsoft Open Specifications. It appeared your question is not related to Open Specifications outline here https://learn.microsoft.com/en-us/openspecs/main/ms-openspeclp/3589baea-5b22-48f2-9d43-f5bea4960ddb. I removed openspecs-sqlserver tag from your original post.
CathyJi-MSFT 22,406 Reputation points Microsoft External Staff

2021-05-07T07:25:36.283+00:00

Hi @Eugene M Roseboro Jr ,

Just checking in to see if the answer(s) helped.
If an answer is helpful, please "Accept answer" or "Up-Vote" for the same which might be beneficial to other community members reading this thread.
And If you have further questions or issues please let us know.

2 answers

Your answer

Hung-Chun Yu 981 Reputation points Microsoft Employee Moderator

2021-05-06T00:31:18.81+00:00

Hi

Thank you for contacting Microsoft Open Specifications. It appeared your question is not related to Open Specifications outline here https://learn.microsoft.com/en-us/openspecs/main/ms-openspeclp/3589baea-5b22-48f2-9d43-f5bea4960ddb. I removed openspecs-sqlserver tag from your original post.
CathyJi-MSFT 22,406 Reputation points Microsoft External Staff

2021-05-07T07:25:36.283+00:00

Hi @Eugene M Roseboro Jr ,

Just checking in to see if the answer(s) helped.
If an answer is helpful, please "Accept answer" or "Up-Vote" for the same which might be beneficial to other community members reading this thread.
And If you have further questions or issues please let us know.

Answer 1

As the error message says, there is a database corruption in the database you try to connect to. Have specified a dedicated database or have your login a default database different then "master"?
You can open a DAC = "Dedicated Admin Connection" to SQL Server to analyse the problem; that works even if common login fails.
See Diagnostic Connection for Database Administrators

You should also review SQL Server ErrorLog file for more details; it's a simple text file, which you can open in any text editor.

Answer 2

Hi @Eugene M Roseboro Jr ,

>Possible index corruption detected. Run DBCC CEHCKDB (MS SQL error 9100)

Did you connect to a specific database not default master database as below screenshot?

According to your error message, the major cause of SQL error 9100 is the index corruption in the database. If you have the latest backup of this database, suggest you recover the database from backup. If you do not have the latest backup to make sure without data loss, you can change the connection database to default master database, then using DBCC CheckDB to repair the database as error message mentioned. Please refer to the blog MS SQL Server Error 9100 – ‘Possible Index Corruption Detected’! to get more.

If this is still not work, please check your SQL server error log to find more related error message , and share the information for us.

If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.

Share via

I'm getting this error when I try to log into SSMS Error9100. Any ideas on how to solve this?

2 answers

Your answer