Enable SQL server 2008 remote conn

Enable SQL Server 2008 Remote Connection

Using Host file to resolve computer name given IP address

After installing Team Foundation Server 2010 on my virtual machine. I try to get access from my main terminal. But i cannot open it.

At first i thought the tfs web were blocked by the my firewall. But then i try to used ip address of that virtual machine and its appear… huh then i start thinking, is there any problem with my connection to the virtual server?

I still remember i’ve been alter some file in windows to automatic resolve (to recognize) this ip address is for which server name but i cannot remember what file it is.

After googling, then i found this website . The file i’m looking for is hosts it is located under C:\Windows\System32\drivers\etc\

 

Copy hosts file on your desktop and add the desire computer name and ip address

After that, copy and paste it back to C:\Windows\System32\drivers\etc\

Then, when i refresh back the page, it appear .. :D

Regex

Regex regex = new Regex(@" ^ # anchor at the start (?=.*\d) # must contain at least one numeric character (?=.*[a-z]) # must contain one lowercase character (?=.*[A-Z]) # must contain one uppercase character .{8,10} # From 8 to 10 characters in length \s # allows a space $ # anchor at the end", RegexOptions.IgnorePatternWhitespace);

error 15023 user already exists in current database

This problem occur when i want to restore database.

error 15023 user already exists in current database


sp_change_users_login 'report'




sp_change_users_login 'update_one','[db username]','[db username]'

Conversion before save into database

This is how we want to convert datetime before we store it inside the database

DateTime.ParseExact("01/01/1900", "dd/MM/yyyy", new CultureInfo("ms-MY"));