Improve company productivity with a Business Account.Sign Up

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

Help me connect to my MS SQL 2012 Server Express

I just installed MS SQL 2012 Server Express and I want to get going.
I installed SQLEXPR_x64_ENU.exe and SQLManagementStudio_x64_ENU.exe sperately and the process ran through.
Then I opened SQL Server Management Studio.
I advanced as far as the form and message below.

During installation I noticed that I got full permissions.
I have not set my Windows 7 up with a password.
Opening form and error message.
Can you direct me further please.
0
Fritz Paul
Asked:
Fritz Paul
  • 5
  • 3
1 Solution
 
Haris DjulicCommented:
Hi,

are you sure about the instance name? Since the error is related to that and not your credentials.

Try to use browse option and then select the available instance .
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Open the SQL Server Configuration Manager (menu Start/MS SQL Server/Configuration Tools) and click in SQL Server Services and post here a snapshot of that screen.
0
 
Fritz PaulAuthor Commented:
Hi,
I expanded my picture to show what I see if I "browse for more" (red box) and also on my Programs directory (green box).
The name seems correct.
Any other idea?
Instance Name
0
Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

 
Fritz PaulAuthor Commented:
Am I right to say the instance is not running?

How little can one know when you embark on a new technology? :-)

How do I start it.

Stopped
0
 
Fritz PaulAuthor Commented:
I don't get further than this stage.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Just right click in the SQL Server and chose the Start option. Do the same for the SQL Server Browser service. You can define both to start automatically when Windows starts.
SQL Server Agent is not available for SQL Express Edition so you don't need to do nothing with it.
0
 
Fritz PaulAuthor Commented:
OK, It worked with SQL Server,
but there the start option is greyed out for the SQL Server Browser service option.
Your comments please?
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Means that the service is Disabled. Right-click on it, chose Properties, go to Service tab and set the Start Mode to automatic.
Now you can try to Start it again.
0
 
Fritz PaulAuthor Commented:
Thanks,
Running now.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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