I cant access into database

Question

I cant access into database

Salman Almalki 20

Olaf Helper 47,616 Reputation points

2024-02-08T11:01:54.3966667+00:00

And now we have to guess the rest of the story? You have to provide much more details, like what for training, what for database, which error you get and so on.
anand 235 Reputation points

2024-02-08T11:22:47.85+00:00
Hi Salman Almalki,

Your assistance in pinpointing the exact location of the error within the Learn Path/Module framework is pivotal for our troubleshooting process. Please ensure that all privacy details are concealed before posting any information. Kindly follow the steps:

open Management Studio

connect to the database server the database is on and look for the Security node in Object Explorer.

Expand the Security node and look for the name of the user in the list of Logins. The user's name should be the same as the user's Windows login if you are using Windows Authentication DOMAIN\Username format.

If the user is there, you will need to grant that user appropriate permissions to the database (read, execute SPs, etc.).

If the user isn't there you will need to add them.

Open up SQL Server Configuration Manager

Click on "SQL Server Services"

Locate the Instance in the right pane and double-click for its properties

In the "Log On" tab, notice the "Log on as:" radio button option is set to "Built-in account".

Change the option to "This account" and add your Windows Authentication account with your domain and username and enter your password.

Click "Apply". Click "Yes" when it asks you if you want to restart the instance.

This will automatically add your windows Authentication user account (Active Directory or local user) to the SQL Server instance. You will now be able to connect right away to the selected instance. As best practice, reset the settings back to the Built-in user account (most likely Network Service). That's it! Please inform us if the problem persists, and we'll be happy to offer further assistance.

Thank you.
pnaroju 3,170 Reputation points Microsoft External Staff Moderator

2024-02-08T11:41:40.8766667+00:00

Hi Salman Almalki,

Thank you for reaching out to us on the Microsoft Q&A forum.

Could you kindly specify the exact Learn Path/Module name/Exercise link where you are encountering the error message along with the screenshots for reference. Your assistance will help us in providing you with more effective support.

Thank you.

1 answer

Your answer

Olaf Helper 47,616 Reputation points

2024-02-08T11:01:54.3966667+00:00

And now we have to guess the rest of the story? You have to provide much more details, like what for training, what for database, which error you get and so on.
anand 235 Reputation points

2024-02-08T11:22:47.85+00:00

Hi Salman Almalki,

Your assistance in pinpointing the exact location of the error within the Learn Path/Module framework is pivotal for our troubleshooting process. Please ensure that all privacy details are concealed before posting any information. Kindly follow the steps:

open Management Studio

connect to the database server the database is on and look for the Security node in Object Explorer.

Expand the Security node and look for the name of the user in the list of Logins. The user's name should be the same as the user's Windows login if you are using Windows Authentication DOMAIN\Username format.

If the user is there, you will need to grant that user appropriate permissions to the database (read, execute SPs, etc.).

If the user isn't there you will need to add them.

Open up SQL Server Configuration Manager

Click on "SQL Server Services"

Locate the Instance in the right pane and double-click for its properties

In the "Log On" tab, notice the "Log on as:" radio button option is set to "Built-in account".

Change the option to "This account" and add your Windows Authentication account with your domain and username and enter your password.

Click "Apply". Click "Yes" when it asks you if you want to restart the instance.

This will automatically add your windows Authentication user account (Active Directory or local user) to the SQL Server instance. You will now be able to connect right away to the selected instance. As best practice, reset the settings back to the Built-in user account (most likely Network Service). That's it! Please inform us if the problem persists, and we'll be happy to offer further assistance.

Thank you.
pnaroju 3,170 Reputation points Microsoft External Staff Moderator

2024-02-08T11:41:40.8766667+00:00

Hi Salman Almalki,

Thank you for reaching out to us on the Microsoft Q&A forum.

Could you kindly specify the exact Learn Path/Module name/Exercise link where you are encountering the error message along with the screenshots for reference. Your assistance will help us in providing you with more effective support.

Thank you.

Answer 1

AmaranS 7,290 Microsoft External Staff

Hi Salman Almalki,

Thank you for reaching out to Microsoft Q&A forum.

Here are the general steps to address your concern.

It seems like you're having trouble accessing the database. To resolve this, ensure that your credentials are correct, and that the database server is running.

Please review the document as it may assist you in resolving your concern: https://learn.microsoft.com/en-us/office/troubleshoot/access/database-unexpected-state

Please provide the specific Learn Path/Module name/Exercise for a more precise resolution of your issue.

Please inform us if the problem persists, and we'll be happy to offer further assistance.

Thank you.

AmaranS 7,290 Reputation points Microsoft External Staff

2024-02-09T11:13:50.9533333+00:00

Hi Salman Almalki, Just checking in to see if you had got a chance to see the previous Response . Kindly let us know if the issue still persists, we'll be glad to assist you further. If the information is helpful, please accept the answer by clicking the "Accept Answer" on the post. If you are still facing any issue, please let us know in the comments. We are happy to help you.

Share via

I cant access into database

1 answer

Your answer