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
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.
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.
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.
__________________
"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
Last edited by AndrewGSW; 01-10-2013 at 11:29 PM..
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)
Before you post, read our: 
