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, 963👍, 0💬
How To Import One Table Back from a Dump File in Oracle? If you only want to import one table back t...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
How To Create a View on an Existing Table in SQL Server? If you want to a view on an existing table,...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...