Connecting SQL Server Management Studio Express To a SQL Server in SQL Server
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server?
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.
Click the Connect button, you should see the SQL Server Management Studio Express window comes up.
2016-12-04, 312👍, 0💬
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
How do you know if SQL Server is running on your local system in SQL Server? After installing SQL Se...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
How To Recreate an Existing Index in SQL Server? If you want to change the definition of an existing...