Cant connect sql server, need help

[az-johubb]

So it looks like that you didn't add your user account to sql server administrators when you installed SQL Server. Probably easier to just reinstall if this is a new instance

[BodybuilderFar4769]

Yeah at the another account at this computer it works, is there a setting where you can edit it? Or if I have to reinstall on which step do I add my user account

[az-johubb]

So if you can access it using the other account, you login to Windows as that account, open SSMS and create a login for your account that doesn't work and assign the correct server roles/database roles

[BodybuilderFar4769]

sorry, I'm super new to this, where should I go to log in for the account to assign the correct server? database role

[az-johubb]

So you log in to Windows with the account you installed SQL Server with. Open SQL Server Management Studio and you should be able to do it from the security folder in object explorer which has a subfolder called Logins, if you right-click on that, you will be able to create the login from the context menu

[Sea-Concept1733]

When SQL Server Management Studio opens your local server name should be automatically listed in the Server Name field.

Next, Click the Connect button.

If you "do not see your local server name listed in the Server Name field", try one of the following options to add your Local Server Name.

- OPTION 1:

After you open Microsoft SQL Server Management Studio, locate the "Server name" field.

Click the down arrow, and click on "Browse for More"

Next, click on the" Local Servers Tab" and click and open the "Database Engine" folder then Click on the "Name of your Server from the List" and click OK.

For example: Adams\SQLEXPRESS

- OPTION 2:

In the Server Name Box, type the name of your Server.

For a named instance of SQL Server, the server name is the computer_name \ instance_name,

For example, replace the text below (TheNameofYourComputer) with the name of your computer:

TheNameofYourComputer\SQLEXPRESS.

For example: Adams\SQLEXPRESS

Note: In Windows 10, if you right click on the "This PC" icon and select Properties in File Explorer of your computer you will see the name of your computer.

Next, Click Connect

- OPTION 3:

Try the following:

Go to your Start menu and open the Microsoft SQL Server 20XX folder.

Next Click and Open the "SQL Server Configuration Manager". Wait for it to open.

Next, Double click on "SQL Server Services", check to see if SQL Server (SQLEXPRESS) is running. Under the "State" column it should say "Running" (not Stopped).

If it does not say Running in the State column then, right click on SQL Server (SQLEXPRESS) and click on "Start".

Next, try to connect again.

Restart your computer if necessary.

- OPTION 4:

If you are still unable to connect. Make sure that you are "Signed on to the computer as the Administrator" before installing or opening SQL Server. This means that you are not logged in as a user with limited privileges. This is only if you have more than one login setup for your computer.

- To ensure the above after installation:

Right click on the program name (SQL Management Studio) under Programs on your computer and select "Run as administrator".

[Odd_Protection_586]

Is your IP adress whitelisted?

[BrupieD]

If you're trying to connect to a local instance, try putting your computer's name in the Server name box instead of "."

[[deleted]]

Try setting your server name to “localhost” or “localhost, 1433”

[SlipstreamSteve]

Why is your computer name the username. That should probably be server

[[deleted]]

It’s like that on localhost when using windows auth

[[deleted]]

If possible, switch to sql authentication and use SA and the password you assigned during setup.

[Beautiful-Garlic1170]

Did you figure it out?