CODEWITHSUNDEEP
sql-server
ExtremeSwat
ExtremeSwat

Reputation: 824

Microsoft SQL Express localhost connection

I've been following up a tutorial (sql server 2008) and I'm a bit in a doubt. It seems like it names my localhost with my Windows username by default and I need a confirmation about this because if I try to connect to the server name either : (local), . , 127.0.0.1 I'll get an error.

enter image description here

Here's the error when I try to directly specify localhost enter image description here

I am a bit confused, sorry for the ambiguous question. It's just that I've been following up a tutorial but on sql server 2008.

Upvotes: 0

Views: 745

Answers (1)

GJKH
GJKH

Reputation: 1725

(local)\SQLEXPRESS or .\SQLEXPRESS - you need to specify the instance name.

To use just (local), the machine name or IP without an instance name you would need to have installed SQL Express as the default instance.

Upvotes: 1

Related Questions