Reputation: 49

No SQL Server Name

Today I installed Microsoft SQL Server Management Studio (SSMS) to install the sample database Northwind. After installing the program, I opened it and at the startup page under "Connect to server" there was a field called "Server name". I am totally new to databases so I couldn't figure out what I should do. I did a quick search on the internet and tried "SQLCMD -L" command in cmd to see available servers but instead, it returned;

;UID:Login ID=?;PWD:Password=?;Trusted_Connection:Use Integrated Security=?;*APP:Ap pName=?;*WSID:WorkStation ID=?;

So it seems like I don't have a database (at least as I understand it so).

Can you help me to install this sample in SMSS?

P.S.: I use Windows 7

Upvotes: 1

Answers (3)

Joel Coehoorn

Reputation: 416121

it seems like I don't have a database

Correct. SQL Server Management Studio is not a database. It doesn't host or process any databases on it's own. Instead, it's a tool that lets you connect to and work with a database server, including MS SQL Server.

You need to install the database server as a separate application, and you probably want SQL Server Express Edition.

P.S.: I use Windows 7

That's a problem now, because recent versions of SQL Server will refuse to install on Windows 7, as Windows 7 is fully out of support to the degree it no longer even gets critical security patches (this is a BIG DEAL).

Upvotes: 0

Rebwar

Reputation: 413

To determine the name of the instance of the Database Engine

1-Log into Windows as a member of the Administrators group, and open Management Studio.

2-In the Connect to Server dialog box, click Cancel.

3-If Registered Servers is not displayed, on the View menu, click Registered Servers.

4-With Database Engine selected on the Registered Servers toolbar, expand Database Engine, right-click Local Server Groups, point to Tasks, and then click Register Local Servers. Expand Local Server Groups to see all the instances of the Database Engine installed on the computer displayed. The default instance is unnamed and is shown as the computer name. A named instance displays as the computer name followed by a backward slash () and then the name of the instance. For SQL Server Express, the instance is named \sqlexpress unless the name was changed during setup.