[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 121
  • 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
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

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

 
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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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