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.

Share This

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.

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