question

MichelMouckomey-7644 avatar image
0 Votes"
MichelMouckomey-7644 asked AmeliaGu-msft commented

SSMS Server Name

Hello,

I recently installed SSMS as part of a school assignment, but I can't figure out my server or instance name to begin using SSMS. I've tried entering my computer name but that didn't work.

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @MichelMouckomey-7644,
How are things going?
Did the answers help you?
Please feel free to let us know if you have any other question.
If you find any post in the thread is helpful, you could kindly accept it as answer.
Best Regards,
Amelia

0 Votes 0 ·
ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

It could be that your school has a common SQL Server instance which are you are supposed to use. In that case, you will need to ask your teacher.

It could also be the case that you were supposed to download and install SQL Server on your own computer. SSMS is just the query tool and is useless without an SQL Server instance to connect to.

I could give you download links, but what would be a bad idea, if the school is providing you with an instance, so again I recommend that you ask your teacher.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

Hi @MichelMouckomey-7644,

I've tried entering my computer name but that didn't work.

Have you or your teacher installed SQL Server default instance on your computer?
If you have not, then you need to install SQL Server first, as SSMS is GUI Administration Tool for SQL Server. Please refer to SQL Server installation guide and Step By Step Installation Guide which might help.
If you have installed the SQL Server instance, could you please share us the detailed error massage? Please make sure the SQL Server instance is running in the SQL Server configuration Manager.

Best Regards,
Amelia


If the answer is helpful, please click "Accept Answer" and upvote it.
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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.