Collections:
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?
✍: FYIcenter.com
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, 2235👍, 0💬
Popular Posts:
How To Create an Multi-Statement Table-Valued Function in SQL Server Transact-SQL? To create a multi...
What is mscorsvw.exe - Process - Microsoft .NET Framework NGEN in SQL Server? Process mscorsvw.exe i...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...