Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 8 of 8
  1. #1
    Regular Coder
    Join Date
    Oct 2010
    Posts
    269
    Thanks
    8
    Thanked 1 Time in 1 Post

    Help setting up sql management studio on localserver

    HI,.
    I just installed windows 7 and sql server management express 2012. When I get to login page I keep getting an error when I try to connect. I tried MSSQLSERVER, localhost, (localhost) but I keep getting the error in image below.
    How do I log into my local server and I do have xampp with apache and mysql running
    Attached Thumbnails Attached Thumbnails Help setting up sql management studio on localserver-image.png  

  • #2
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    25,184
    Thanks
    75
    Thanked 4,340 Times in 4,306 Posts
    Ummm.... What in the world does SQL Server Management Studio have to do with "I do have xampp with apache and mysql running"???

    You can't use SQL Server *anything* to talk to a MySQL database. (Well, not literally true, but it's much more complex than you even want to think about, surely.)

    If you really want to talk to MySQL, you should use MySQLWorkbench or PhpMyAdmin or PhpMySQLAdmin.
    An optimist sees the glass as half full.
    A pessimist sees the glass as half empty.
    A realist drinks it no matter how much there is.

  • #3
    Senior Coder alykins's Avatar
    Join Date
    Apr 2011
    Posts
    1,722
    Thanks
    41
    Thanked 191 Times in 190 Posts
    Do you really have SQLExpress installed? Or did you confuse the management platform as Old Pedant mentioned? Right click MyComputer -> Manage
    then expand the "services and Applications"

    If you do not have "SQL Server Configuration Manager" then you do not have MsSQLExpress or any other MSDN SQL engine. If you DO have it, then let us know- and we can move forward getting you connected.

    *See image for what you should have
    Attached Thumbnails Attached Thumbnails Help setting up sql management studio on localserver-capture.png  

    I code C hash-tag .Net
    Reference: W3C W3CWiki .Net Lib
    Validate: html CSS
    Debug: Chrome FireFox IE

  • #4
    Senior Coder
    Join Date
    Apr 2011
    Location
    London, England
    Posts
    2,120
    Thanks
    15
    Thanked 354 Times in 353 Posts
    My server name is ANDYCOMPAQ\SQLEXPRESS if it helps. That is, COMPUTERNAME\SQLEXPRESS.

    Of course, you need to start the server by going into the SQL Server Configuration Manager!! This is a separate application to the Management Studio.

    Added: And, of course, this is nothing to do with your Apache server or MySql.
    Last edited by AndrewGSW; 01-10-2013 at 11:29 PM.
    "I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.
    Validate your HTML and CSS

  • #5
    Regular Coder
    Join Date
    Oct 2010
    Posts
    269
    Thanks
    8
    Thanked 1 Time in 1 Post
    I'm in configuration manager but I don't know how to start the service?
    Attached Thumbnails Attached Thumbnails Help setting up sql management studio on localserver-image.jpg  
    Last edited by andynov123; 01-12-2013 at 06:20 PM.

  • #6
    Senior Coder alykins's Avatar
    Join Date
    Apr 2011
    Posts
    1,722
    Thanks
    41
    Thanked 191 Times in 190 Posts
    click on SQL Server Services, right click SQL Server (SQLEXPRESS) and then start. You can also configure properties and make it start auto so it will start when machine starts. As you can see in mine I have my express version stopped and set to manual, whereas my actual sql server engine is auto (I use it almost every day)
    Attached Thumbnails Attached Thumbnails Help setting up sql management studio on localserver-capture.jpg  

    I code C hash-tag .Net
    Reference: W3C W3CWiki .Net Lib
    Validate: html CSS
    Debug: Chrome FireFox IE

  • #7
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    25,184
    Thanks
    75
    Thanked 4,340 Times in 4,306 Posts
    Okay, I give up. Why do you have both SQL Server Express and SQL Server installed, Alykins?

    Just curious.
    An optimist sees the glass as half full.
    A pessimist sees the glass as half empty.
    A realist drinks it no matter how much there is.

  • #8
    Senior Coder alykins's Avatar
    Join Date
    Apr 2011
    Posts
    1,722
    Thanks
    41
    Thanked 191 Times in 190 Posts
    I wasn't paying attention when I installed :P

    I code C hash-tag .Net
    Reference: W3C W3CWiki .Net Lib
    Validate: html CSS
    Debug: Chrome FireFox IE


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •