question

SaniaFatimi-2246 avatar image
0 Votes"
SaniaFatimi-2246 asked FrankKamara-9732 published

I have downloaded sql server 18.9.2 version and trying to connect to local host server. But unable to connect.

HI All,

I have downloaded sql server 18.9.2 version and trying to connect to local host server. But unable to connect. I tried to check if my MSSQL is in running state. But unable to do so, as I am unable to find the "Tools/Binn" ; in c drive - C:\Program Files\Microsoft SQL Server\110\Tools\Binn\

sql-server-generalsql-server-transact-sql
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
1 Vote"
AmeliaGu-msft answered

Hi SaniaFatimi-2246,

Welcome to Microsoft Q&A.
Have you installed SQL Server?
If you have installed SQL Server, please go to SQL Server Configuration Manager or Services in your machine to check if the instance is running. In SQL Server Configuration Manager, on the left pane, click SQL Server Services. The right pane lists several services that are related to SQL Server. If the Database Engine is installed, the Database Engine service is listed as SQL Server (MSSQLSERVER) if it is the default instance; or SQL Server (<instance_name>), if the Database Engine is installed as a named instance. Please refer to Determine Whether the Database Engine Is Installed and Started which might help.

118868-image.png

In addition, please share us the detailed error message which is located at Program Files\Microsoft SQL Server\MSSQL1x.\ MSSQL\Log\ERRORLOG.

If you have not installed SQL Server, please download and install it first. You can download it from here.
And here is a tutorial about SQL Server installation which might help.
If you have any question, please feel free to let us know.

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.



image.png (26.6 KiB)
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.

FrankKamara-9732 avatar image
0 Votes"
FrankKamara-9732 answered FrankKamara-9732 published

Thank you, this worked for me.

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.

DanGuzman avatar image
1 Vote"
DanGuzman answered

I have downloaded sql server 18.9.2 version

18.9.2 is a SQL Server Management Studio version. SSMS is only a client tool and does not include the SQL Server database engine. You need to separately install SQL Server, such as the Developer or Express edition for local development


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.