CODEWITHSUNDEEP
sqlsql-server-2005sql-server-2008
Vikrant More
Vikrant More

Reputation: 5442

What is the difference between (local) and (pc-name)\SQLEXPRESS?

I am using SQL Server 2008.

What is the difference between (local) and (pc-name)\SQLEXPRESS server names?

When I create database in (local) server will it be different than when created on (pc-name-)\SQLEXPRESS??

Can you please help me to get the exact difference between these databases.

Upvotes: 1

Views: 2394

Answers (2)

rsc
rsc

Reputation: 4434

When you refer to (local) you mean SQL Server unnamed instance of local (localhost) server. Then name (pc-name)\SQLEXPRESS refers to named SQL Server instance located on given computer. Those are separate server instances.

Upvotes: 2

Alex K.
Alex K.

Reputation: 175876

If you install the server on a machine named "XXX" then on that machine only you can (for convenience) use (local)\SQLEXPRESS as an address as the server is local to that machine.

On any other machine (including XXX itself) you can use XXX\SQLEXPRESS to indicate the server is running on XXX, and that is what should be connected to.

Upvotes: 2

Related Questions