Installation, Solution

CRM installation error

Hi All,

During my CRM installation I have encountered this error:
Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\MSCRM_CONFIG.mdf".

So I look up on the net and found this solution:

  • Stop MSSQLSERVER services
  • Go to “C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA” and delete MSCRM_CONFIG.mdf and MSCRM_CONFIG_log.ldf
  • Start MSSQLSERVER services
  • Then re-run the installation.

It works!

Farrah K.

Advertisements
Installation

Setting up Active Directory

Hi All,

I have installed Windows Server 2012 RC Datacenter to one of my VMs. So now let’s see what things need to be done to set up an Active Directory.

  • First thing you’ll see once the OS is running is the Server Manager window.

2-1

  • Then go to Local Server and change the Computer name by clicking it. And the OS will be restarted. In my case, I’ve rename it to CAMP.

2-1

  • Once restarted, on the Server Manager window click on Manage > Add Roles and Features on the top right corner as shown below:

2-1

  • The wizard will starts, click Next.
  • For Installation type, choose Role-based or feature-based installation.

2-1

  • For Server Selection, let it be and click Next.
  • For Server Roles, select Active Directory Domain Services. And a wizard will shows up, just click on Add Features.

2-8

2-8

  • For Features, just click Next.
  • For AD DS, click Next.
  • Then Confirmation, click Install. Once it’s done then close it you’ll see new option is added named AS DS.

2-8


Then you’ll notice there’s a warning in yellow which telling you that there’s configuration need to be done.

So what you do is,

  • Click on the flag on the top right corner and click on Promote this server to domain controller.

2-8

  • A wizard shows up, on Deployment Configuration choose Add a new forest and fill in the root domain name e.g AD.LOCAL or CP.LOCAL (in my case).
  • For Domain Controller Options, fill in the DSRM password.
  • For DNS Options, let it be and click Next.
  • You will get NetBIOS automatically and click Next.
  • For Paths, click Next
  • For Review Options, click Next
  • For Prerequisites Check, checking will start and click Install when it’s done. (Make sure your connection is working)
  • Once it is done, you will be signed off then your server will be an Active Directory Server with installed DNS.

That’s it!

-Farrah K.

Solution

Reset Password (Win 8.1)

Hi All, There’s a time when one of your work’s mate resign and left their PC locked but you don’t want to bother them and ask for password. I bet some people use their password for all the accounts possibly they might not tell. So, format is the first thing that comes to you mind but then you need to see what’s inside that computer. So what you do is… download this

I assure you, it will works but of course as time passing by everything will be updated so I can not guarantee you that this will work in the future but for now year 2015 it works.

  • Download Lazesoft software.
  • Install it and Run it.
  • Click on Burn Bootable CD/USB Disk Now!
  • Then click Next.
  • Choose whichever you prefer to and click start.
  • And click Yes for format.

Once it is done just plug it in to the PC and click Next until you see the account you wish to unlock then that’s it. You restart the PC and you can log in to the account with password. Hope it helps. And if this doesn’t work then just plug the hard disk out.

-Farrah K.

SQL

Understand SET Operators

Hi All,

I assume you heard about SET, usually it can be heard in Mathematics and SET operators in SQL has the same meaning as that one as well for UNION and INTERSECT.

SET operators includes

  • UNION
  • INTERSECT
  • EXCEPT
  • APPLY

Union

It returns a result set of distinct rows combined from both sides. This means that it will display all the records from both table but will not show the duplicate rows, it’s like as if every record is unique.

My own concept: ((Purchasing + Sales) – Duplicates).

Capture

Union ALL

It returns a result set with all rows from both sets. Consider that it display all the records from each of the table. Duplicates will occurs here.

My own concept: (Purchasing + Sales).

Intersect

It returns only distinct rows that appear in both result sets. The results shows only exist in both table.

My own concept: (Purchasing & Sales)

Capture

Except

It returns only distinct rows that appear in the left set but not the right.

My own concept: (Sales – (Purchasing & Sales) – Purchasing)

Capture

Apply

**I have no idea how this works, do you? mind explain it to me ^.^


-Farrah K.

SQL

Understand JOIN Statements

Hi all,

Before this, I had a bit confuse on some of the SQL statement especially the JOIN statements. Ok, Let’s see…

JOIN statements

There are 3 types of JOIN:

  • Cross
  • Inner
  • Outer

Cross

It basically combines all the rows in the both tables. Meaning that if you have 20 rows in table 1 and 8 rows in table 2, therefore, the number of rows will be after cross join both of them is 20*8 = 160 rows (Cartesian Product).

Inner

Returns only rows where a match is found in both tables.  So when there is comparison between 2 tables it will only search and display the matching rows.

Outer

Returns all rows from one table and any matching rows from second table. This mean that it will display all the rows in table 1 and display only the matching rows from the table 2. (this example is the left join).

In outer join there are 3 type of outer join which they are:

  • Left

Note: It will return all the rows in the left table even if there are no matches in the right table.

  • Right

Note: It will return all the rows in the right table even if there are no matches in the left table.

  • Full

Note: It will return all the rows in the left table 1 and in the right table, If there are no matches in either of the table, those rows will be listed as well.


That’s it. Hope this helps.

– Farrah K.

Programming

First C# Application

As a programmer we have seen this ‘Hello World’ for so many times especially when we want to create a program with a new programming languages. So today I’ll be showing you the steps on creating a Hello World application using C#.

I believe there are more than one developer tool to write a C# application, as for this blog I’ll be using the Microsoft Visual Studio Ultimate 2012.

OK, here we go…

  • Open up the Microsoft Visual Studio.
  • Click New Project, select Visual C# and select Console Application as shown below.

Untitled

  • Name, HelloWorld and Click OK.
  • And you’ll see something like this:

Untitled


  • Tips: it is recommended to display the line numbers so it is easier for you to refer to.
  • To enable the Line numbers all you have to is:
    • Go to Tools > Options…
    • Expand the Text Editor > All Languages > General.
    • Select Line numbers under Display.

Untitled


Now, let’s write some code

  • Under the main method, write the code like this:

Console.WriteLine("Hello World");
Console.ReadLine();

  • To run the program, Click on the Start on the menu bar.

Untitled

  • And you’ll see:

Untitled


That’s it! You just created your Hello World using C#.

-Farrah K.

Networking

Hyper-V Connections

In the Hyper-V, there are 3 types of virtual switches:

  • External
  • Internal
  • Private

External

External virtual networks are used where you want to allow communications between

  • Virtual machine to virtual machine on the same physical server
  • Virtual machine to parent partition (and visa-versa)
  • Virtual machine to externally located servers (and visa-versa)
  • (Optional) Parent partition to externally located servers (and visa-versa)

Internal

Internal virtual networks are used where you want to allow communications between

  • Virtual machine to virtual machine on the same physical server
  • Virtual machine to parent partition (and visa-versa)

An internal network would commonly be used to build a test environment where you need network connectivity into the virtual machines from the parent partition itself.


Private

Private virtual networks are used where you want to allow communications between

  • Virtual machine to virtual machine on the same physical server

A private network would commonly be used where you need complete isolation of virtual machines from external and parent partition traffic. DMZ workloads running on a leg of a tri-homed firewall, or an isolated test domain are examples where this type of network may be useful.


-Farrah K.