How can i get admin access in sql server express

Robert Lalyko 0 Reputation points
2024-03-19T06:09:26.4933333+00:00

In my freshly installed sql server expressI can not administrate the server!

How can I get admin of my sql server express instance?

SQL Server Other
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 47,436 Reputation points
    2024-03-19T06:33:10.6833333+00:00

    You post is not very clear.

    During SQL Server installation you had to define one or more Windows accounts as admin; so use one of them to logon.

    And if you installed it in "Mixed mode", then you had to define a password for the SysAdmin account "sa"; then use that one.

    0 comments No comments

  2. Anonymous
    2024-03-20T06:34:17.4433333+00:00

    Hi @Robert Lalyko ,

    The information in your post is not very clear. You can't connect to the server or you don't have the administrator rights?

    Best regards,

    Lucy Chen


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    https://docs.microsoft.com/en-us/answers/support/email-notifications

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.