A New Beginning

I've been absent posting on my blog for the past few months. Life is getting hard since i committed to master's course in Computational Science. I think from now on, i'll find some time to post more resources on this blog. Thanks for visiting and keep the spirit of learning and curiosity! Regards, Drekend...

Read more »

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...

Read more »

SharePoint 2010 Error: domain/my Cannot be found

So, this morning i was trying to access my personal site and my profile pages in our new SharePoint farm. But what i got was the HTML 404 The Page Cannot be Found. After spent hours looking for the solution of this issue, finally found the way to figure this out! Yippi! 1st step--- Log on to your Central Administration > Application Management > Create Site Collection 2nd step--- Point to Web Site Address and click on the link Define Managed Paths. 3rd step--- Add a new path 1. my, choose the type Explicit inclusion, Add Path2. my/personal, choose the type Wildcard inclusion, Add Path 3rd step--- Go back to Create Site Collection page. Put...

Read more »

SQL Server 2008 R2: Connect to Different Domain and Server Name

Have struggled with this problem almost all day. I couldn't connect to another domain server using SQL Management Studio 2008 R2. Precisely, my other domain server is using Hyper-V and i called the server name as DOMAIN1. In this case i couldn't get access easily by using the server name but what i need is connect using the IP Address of DOMAIN1. In this case i defined the IP address of DOMAIN1 as 192.168.0.11 1st step--- Make sure you can connect to DOMAIN1, add another IP Address. In this case, i am using IP 192.168.0.* so i can connect. For example i defined the IP address of my SQL Server computer as 192.168.0.9 2nd step--- Check the DOMAIN1...

Read more »

SharePoint 2010: Specify the Default Database Server

If you have look at my posts before this, this post is connected to Migrating SharePoint 2010 Databases from SQL Server 2008 Express Edition to SQL Server 2008 R2 Enterprise Edition. After detach and attach all MOSS 2010 databases from SQL Server Express, now we have  to go back to SharePoint Central Administration.  1st step---Log on to your Central Administration as farm administrator. 2nd step---In the SharePoint 2010 Central Administration Page go to Application Management > Databases > Specify the default database server.3rd step---In the default database server page, fill in the Domain\SHAREPOINT_DB_Instance of the SQL Server...

Read more »

SharePoint 2010 : Detach SharePoint databases from SQL Server Express Edition & Attach to SQL Server Enterprise Edition

As default on the new installation, Microsoft Office SharePoint Server (MOSS) 2010 using SQL Server Express Edition to store the databases. To migrate MOSS 2010 databases to SQL Server Enterprise edition, you need to install SQL Server Management Studio first so you can manage all Database Engine easily. Before you do databases detach, please read this article carefully from Microsoft official site. According to the information and requirements provided by Microsoft you will need to stop some of the SharePoint services. You can manage by using Administrative Tool > Services, but i'm using a very quick tool from CodePlex called SharePoint 2010...

Read more »

SQL Server 2008 Express Edition Error: Cannot show requested dialog. ADDITIONAL INFORMATION: Parameter name: nColIndex Actual value was -1. (Microsoft.SqlServer.GridControl)

This morning i have found the way to detach SharePoint databases from SQL Server 2008 Express Edition and then attach all databases to our new SQL Server 2008 R2 Enterprise edition. But then i found problem on re-attach the databases to SQL Server Express edition. It returns me an error as shown on the image below. TITLE: Microsoft SQL Server Management Studio------------------------------ Cannot show requested dialog. ------------------------------ ADDITIONAL INFORMATION: Parameter name: nColIndex Actual value was -1. (Microsoft.SqlServer.GridControl) ------------------------------ BUTTONS: OK ------------------------------ Then...

Read more »

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

I've been working on InfoPath 2010 since a week ago (i'm totally new on it). This was something that i needed to do, and after few hours testing and googling it, finally i could figure out how it works in InfoPath. 1st step---Right click on your button and choose Button Properties. Click on Edit Form Code... button. 2nd step---Find the function for the button event. In this case mine is as shown below.public void updateButton_Clicked(object sender, ClickedEventArgs e){    //write your code here} 3rd step---Put this codes below //scripts to get value of Infopath field XPathNavigator Period1 = this.MainDataSource.CreateNavigator().SelectSingleNode("//my:myFields/my:period_1",...

Read more »

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

OK, here it is, i was trying to create a timetable SharePoint webpart for our school, and using SQL Server Database. And i want the timetable appears as the domain user logged on to SharePoint. So my first step to create this webpart was creating the database and tables. From the previous topic i have explained how to get the Active directory users and attributes, and so i improved the sql query to copy all my AD retrieval results into my 'teacher' table.Below is the query that i ran: use TimeTable go INSERT INTO teacher(initials,logOnID,preferredName) SELECT initials,samAccountName, displayName FROM OPENQUERY(ADSI,'SELECT initials, samAccountName,...

Read more »

SQL Query: Retrieve Active Directory Users List

Today i was struggling getting the active directory users list from our domain, but finally it worked. Here's the query. 1st step---Thanks to Alina from MSDN blog (http://blogs.msdn.com/b/alina/archive/2009/04/16/ldap-query-to-get-a-user-memberships-in-sql.aspx) for this awesome SQL script: EXEC master.dbo.sp_addlinkedserver @server = N'ADSI', @srvproduct=N'Active Directory Services', @provider=N'ADsDSOObject', @datasrc=N'bisdragons.com' GO Note: Change @datasrc=N'your_domain.com'  2nd step--- Run this query:SELECT samAccountName, givenName [First Name], sn [Last Name],mail FROM OPENQUERY(ADSI,'SELECT samAccountName,givenName, sn, mail FROM ''LDAP://OU=Teaching Faculty,OU=Staff,DC=BISDRAGONS,DC=COM'' WHERE objectClass=''Person'' AND objectClass = ''User'' ORDER BY samAccountName')...

Read more »

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

In this tutorial i would like to share how to change your account preferred name in SharePoint Server 2010. 1st step--- Log on to SharePoint Central Administration as Farm Administrator. 2nd step--- Go to Application Management > Manage service applications. 3rd step--- Scroll down to User Profile Service Application and click on the hyperlink. 4th step--- Go to  Manage User Profiles. 6th step--- Put the username that you would like to change its profiles on to Find profiles textbox. Then click Find. Once it shows the result, rollover to the Account Name and click the little arrow, choose Edit My Profile. 5th step--- Now you...

Read more »

SharePoint 2010 Error: Requested registry access is not allowed

Did you find this error? Well i just did few hours ago, and after struggling many hours, i think i finally have found what the problem is. The first issue came because i did repair my SharePoint site, because i did a mistake by changing the farm account and suddenly my SharePoint Central Administration page can not be accessed. So, after i repaired my SharePoint using SharePoint Server 2010 installation CD, my Central Administration worked fine. But wait, it wasn't fine at some pages, like i couldn't access Security > General Security > Configure managed accounts. It returned me an error : Error: Requested registry access is not allowed and not even that i couldn't delete or edit any of my web applications, and i couldn't access all my SharePoint site or web applications, it says my...

Read more »

Install OpenSSL and cURL on Appserv Windows XP 32-bit

What i want to share here is something that you might have tried hard and didn’t return you any success. I’ve tried to understand and install it onto my Windows XP and thank God it works after a long. First you need these kind of files : 1. openssl.exe 2. openssl.conf 3. abs.exe 4. mod_ssl.so 5. libeay32.lib 6. ssleay32.lib 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 4th Step ——– Open httpd-ssl.conf which is located in [drive]:\AppServ\Apache2.2\conf\extra...

Read more »

Enable mod_rewrite in Apache

What does mod_rewrite do? If you have heard about htaccess (extension : .htaccess), then you might need it. Mod_rewrite has to be enable first if you want to use htaccess file on your website.In this tutorial, i am using Appserv as my web server. But actually it won’t have a significant differences with other type of web servers (e.g XAMPP, LAMP, WAMP etc). –1st stepFind http.conf file which is located in [drive]:\AppServ\Apache2.2\conf –2nd stepOpen http.conf in notepad. Find #LoadModule rewrite_module modules/mod_rewrite.so –3rd stepRemove sharp (#) from #LoadModule rewrite_module modules/mod_rewrite.so then it supposed to be just LoadModule...

Read more »

Adding front page image to Moodle page

Howdy! This time i want to give tutorial for adding image on the front page of Moodle. –1st stepLog in as Moodle Administrator, as you logged in you’ll see Site Administration panel at the left side of page. –2nd stepGo to Front Page and choose Front Page settings.  –3rd stepFind Include a topic section, there’s a note If selected, a topic section will be displayed on the site’s front page, check the checkbox. And then Save Changes.  –4th stepReturn to your Moodle front page. Turn Editing On. Click on the Edit Summary icon (it looks like a pencil icon). –5th stepIn the summary site editor, Insert image, and Save changes...

Read more »

Assign users as any role in Moodle course

I decided to write this tutorial, some people may think it’s a silly tutorial or not even worth to be called as tutorial, but believe me, i decided to write it because i kept getting this question from some people : How to assign or add students to Moodle course? So, let’s start it. –1st stepLog on to your Moodle page. And go to your course. Remember, you can only do this tutorial successfully if your role is Administrator or Course Creator and Teacher. –2nd stepOnce you get into your course, click on button  ‘Turn Editing On‘. And click on Assign role icon. Assign role –3rd stepClick on any type of role, for example Student....

Read more »

Welcome to Drekendrop

Hello! I am the author of Drekendrop. Drekendrop is taken from the words 'drag and drop' and it is pronounced in Indonesian as 'drekendrop', that's the reason why must 'Drekendrop'. In this blog i would like to share some tutorials about web including the database systems, programming, design, and administration, based on my experiences, all those matters that has stressed me out are here. Haha...do not hesitate to contact me by email or write comment on this blog. Thank you for visiting and good luck on your learning! Regards,Mei Note: Drekendrop's author is as known as Jump2TheJAM | sofdadesign and Offdadesi...

Read more »