Solved

Help me connect to my MS SQL 2012 Server Express

Posted on 2014-12-10
9
97 Views
Last Modified: 2014-12-10
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
Comment
Question by:Fritz Paul
  • 5
  • 3
9 Comments
 
LVL 15

Expert Comment

by:Haris Djulic
ID: 40490972
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
 
LVL 48

Expert Comment

by:Vitor Montalvão
ID: 40490993
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
 

Author Comment

by:Fritz Paul
ID: 40490996
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
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 

Author Comment

by:Fritz Paul
ID: 40491009
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
 

Author Comment

by:Fritz Paul
ID: 40491076
I don't get further than this stage.
0
 
LVL 48

Expert Comment

by:Vitor Montalvão
ID: 40491101
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
 

Author Comment

by:Fritz Paul
ID: 40491283
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
 
LVL 48

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 40491290
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
 

Author Closing Comment

by:Fritz Paul
ID: 40491535
Thanks,
Running now.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question