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.

Install OpenSSL and cURL on Appserv Windows XP 32-bit

1st Step ——– Copy openssl.exe, abs.exe, openssl.conf onto [drive]:\AppServ\Apache2.2\bin 2nd Step ——– Copy mod_ssl.so onto [drive]:\AppServ\Apache2.2\modules 3rd Step ——— Copy libeay32.lib and ssleay32.lib onto C:\Windows\system32 ...

Adding front page image to Moodle page

–1st step Log in as Moodle Administrator, as you logged in you’ll see Site Administration panel at the left side of page....

SharePoint 2010: Change Preferred Name To FirstName + LastName Instead Of Domain\Username

1st step--- Log on to SharePoint Central Administration as Farm Administrator. 2nd step--- Go to Application Management > Manage service applications...

SQL Query: Adding Active Directory Users Attributes To An Existing Table Or Specified Column

use TimeTable go INSERT INTO teacher(initials,logOnID,preferredName)...

Infopath 2010: Get and Set Value of TextBox Field Using Visual C# onEvent Button Click

1st step--- Right click on your button and choose Button Properties. Click on Edit Form Code... button...

Tuesday, April 5, 2011

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

Posted by Mei Pakpahan on 2:02 PM

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.
Read more »

RSS FeedSubscribe

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