Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 522
  • Last Modified:

Log-in to SQL Server

Last year, I installed SQL Server 2008R with pretty much the default settings so I can easily log-in and connect to database engine easily. I guess I used windows authentication to do so.
Lately, while SQL Server was open, I installed some iTune updates…, the open programs was forced closed in order to restart the laptop.
Now, when I try to connect to database engine, I get the following message:


TITLE: Connect to Server
------------------------------

Cannot connect to (local).

------------------------------
ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476

------------------------------
BUTTONS:

OK

Apparently, I need to enter another another server name than the default "Local".

Question: Where can I find the server names in my computer? So that I could browse replace the "Local" option it gives as default?

Thank you.


------------------------------


SQL-Server-log-in.png
0
Mike Eghtebas
Asked:
Mike Eghtebas
  • 4
  • 3
2 Solutions
 
Kevin CrossChief Technology OfficerCommented:
Look under services. Check for the SQL Server service and see what is in the braces. MSSQLSERVER is the default instance and would be connected to as just the {system name}. If SQLEXPRESS or any other name is listed, that would mean you have a "named instance" and would be connected to by {machine name}\{instance name}.
0
 
John_ArifinCommented:
Have you checked that the server already run?
If it is, try to use .  (period) instead of (local) .
0
 
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
mwvisa1,

re> Look under services.

Where? How?

John_Arifin,

re:> ,,, server already run?

Was not running. I tried after the computer was booted up.  ans use of . instead of local didn't work.

Mike
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Kevin CrossChief Technology OfficerCommented:
Look under services. Check for the SQL Server service and see what is in the braces. MSSQLSERVER is the default instance and would be connected to as just the {system name}. If SQLEXPRESS or any other name is listed, that would mean you have a "named instance" and would be connected to by {machine name}\{instance name}.

Open up Windows Services (Start > Run > Services.msc)
Look for the SQL Server service(s)
Next to SQL Server, you will see (MSSQLSERVER) or (INSTANCENAME).
Whatever is in the () will be the value you have to use while connecting to the sever as the INSTANCENAME unless it is MSSQLSERVER which represents default and as such does not need to be included.
0
 
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
I have an image of "Services" included below. FYI, I am running Windows 7 professional.

For server name in "Connect to server" screen, I have replaced (Local) with the following but hasn't work so far:

SQLEXPRESS
MSSQLSERVER
MSSQL

I hope I don't have to re-install SQL Server again.

Thanks for the help.

Mike
0
 
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
I forgot to upload the image. Here it is:
LogginError.png
0
 
Kevin CrossChief Technology OfficerCommented:
Okay. Look in the image you posted. The Name of the SQL service is "SQL Server (SQLEXPRESS)". That means that the instance name is SQLEXPRESS. Therefore, you need to connect as YourComputerName\SQLEXPRESS or .\SQLEXPRESS.
0
 
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
.\SQLEXPRESS

Works. I wonder why it had been replaced by (Local).

And also, this was suppose full version of 2008R not express.

One possibility is that after one year (student use) its setting changes from 2008R to 2008Express?

Thanks a lot.

Mike
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now