/* ------------------------ My Meta Content Here SEO ------------------------ */


Main Menu

Thursday, January 19, 2012

SQL SERVER: The server principal is not able to access the database

SQL Databases not showing up . . .

If you accessing MSSQL 2005 with MSSQL 2008 management studio, you might getting error of The server principal is not able to access the database when log into the database server.


To fix it,
1. Connect to SQL Server Management Studio.
2. Connect to the SQL server.
3. Click “View” and then select on the “Object Explorer Details”. (This step could be done from shortcut F7)
4. Double click on the “Databases” folder.
5. Right click on the column header “Policy Health State”.
6. Untick the option “Collation”.
7. Refresh it and you have done.
Read More »

Wednesday, January 11, 2012

ASP.NET - javascript popup message box

//javascript popup message box

public void ShowPop(string Message)


ClientScript.RegisterStartupScript(this.GetType(), "OhCrap", String.Format("alert('{0}');", Message.Replace("'", "\'")), true);


Read More »

Sunday, January 8, 2012

How to configure SQL Server 2005 to allow remote connections

To enable remote connections on the instance of SQL Server 2005 and to turn on the SQL Server Browser service, use the SQL Server 2005 Surface Area Configuration tool. The Surface Area Configuration tool is installed when you install SQL Server 2005.

Enable remote connections for SQL Server 2005 Express or SQL Server 2005 Developer

Editionmust enable remote connections for each instance of SQL Server 2005 that you want to connect to from a remote computer. To do this, follow these steps:
  1. Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Surface Area Configuration.
  2. On the SQL Server 2005 Surface Area Configuration page, click Surface Area Configuration for Services and Connections.
  3. On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Remote Connections, click Local and remote connections, click the appropriate protocol to enable for your environment, and then click Apply.

    Note Click OK when you receive the following message:
    Changes to Connection Settings will not take effect until you restart the Database Engine service.
  4. On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Service, click Stop, wait until the MSSQLSERVER service stops, and then click Start to restart the MSSQLSERVER service.
Read More »

SQL SERVER – Enable Login – Disable Login in SQL Server 2005

SQL SERVER – Enable Login – Disable Login using ALTER LOGIC – Change name of the ‘SA’. 
In SQL SERVER 2005, all the login (including ‘sa’ ) can be enabled and disabled using ALTER LOGIN command.

To disable ‘sa’ login:


To enable ‘sa’ login:


Also for additional security (prevent educated guess from hackers) the name of the ‘sa’ account can be changed.

ALTER LOGIN [sa] WITH NAME = [AdminUser]
Read More »

Thursday, January 5, 2012

Site Search, Google Site Search, Google Custom Search

Google search box to my Web site?

Search your entire site or search the entire Google database, all without leaving that page!

The basic technique involved here is to be able to manipulate one of the variables handed to the Google search engine, a variable called sitesearch. Set it to a null value and you're searching the entire World Wide Web, but set it to a specific domain and it's constrained exactly as if you had typed in the Google special notation site:domain.

Here are some nice links that explain how to implement it. 

GOOGLE Custom Search:

The JavaScript Source: Forms: Option Search: 

Creating an ASP.NET Search Engine

A Search Box on Your Website

All-in-one Internal Site Search script

Search Page Javascript

Some Links Where is implemented

Creating a simple search box

Free Site Search Engine

Read More »

My Blog List