Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ - Connecting SQL Server Management Studio Express To a SQL Server

By: FYIcenter.com

(Continued from previous topic...)

How to connect SQL Server Management Studio Express to SQL Server 2005 Express?

Once you have SQL Server 2005 Express installed and running on your local machine, you are ready to connect SQL Server Management Studio Express to the server:

Click Start > Programs > Microsoft SQL Server 2005 > SQL Server Management Studio Express to launch SQL Server Management Studio Express.

The "Connect to Server" box shows up. The Server Name field has a default value of "LOCALHOST\SQLEXPRESS". So don't change it. Select "SQL Server Authentication" as the Authentication. Enter enter "sa" as the Login, and "FYIcenter" as the Password.
SQL Server 2005 Connect Window.

Click the Connect button, you should see the SQL Server Management Studio Express window comes up.

(Continued on next topic...)

  1. What is Microsoft SQL Server?
  2. How to download Microsoft SQL Server 2005 Express Edition?
  3. What are the requirements to install SQL Server 2005 Express Edition?
  4. Why I am getting "The Microsoft .Net Framework 2.0 in not installed" message?
  5. How to download and install Microsoft .NET Framework Version 2.0?
  6. What is mscorsvw.exe - Process - Microsoft .NET Framework NGEN?
  7. How to install SQL Server 2005 Express Edition?
  8. How do you know if SQL Server is running on your local system?
  9. What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS)
  10. How to download and install Microsoft SQL Server Management Studio Express?
  11. How to connect SQL Server Management Studio Express to SQL Server 2005 Express?
  12. How to run Queries with SQL Server Management Studio Express?
  13. How to download and install SQL Server 2005 Books Online?
  14. How to run SQL Server 2005 Books Online on your local system?

Related Articles:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...