Creative Commons License
Drekendrop | Blog of Tutorial by Mei Pakpahan is licensed under a Creative Commons Attribution-ShareAlike 3.0 Unported License.
Based on a work at drekendrop.blogspot.com.
Permissions beyond the scope of this license may be available at http://softdadesign.co.nr.

Tuesday, April 5, 2011

SQL Server 2008 Express Edition : Connect remotely from another server using SQL Management Studio

So, this time we're going to connect to SQL Server Express edition remotely from another server. As we know if we install SQL Server Express Edition it doesn't come up with SQL Management Studio Express on it, and that means we won't be able to manage the SQL Server Express Edition. In this case, we're gonna connect to SQL Server Express Edition by using SQL Management Studio in the separated server. All you need to is enable the remote connection from the SQL Server Configuration Manager of your Express Edition.

1st step---
Open SQL Server Configuration Manager and point to SQL Server Services.


2nd step---
Right click on SQL Server Browser > Properties
On the Service Status, click Start button, and then Apply then OK.

3rd step---
Notice that the SQL Server Browser is now running.

Now you can try to connect to the SQL Server Express from any different server using SQL Management Studio.

Thanks to Linglom for sharing this.

1 comments:

gadxi said...

Betway Casino Review and Welcome Bonus Code | KTMHub
Betway Casino Review 서귀포 출장샵 당진 출장안마 Betway 양산 출장샵 offers an excellent collection of 계룡 출장샵 games and services from the largest eGaming industry companies. Rating: 4.9 · ‎Review by KTM 서산 출장샵 Hub

Post a Comment

 
Design by Free WordPress Themes | Bloggerized by Lasantha - Premium Blogger Themes | Grants For Single Moms