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 »

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 »

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:

ALTER LOGIN sa DISABLE
GO

To enable ‘sa’ login:

ALTER LOGIN sa ENABLE
GO

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

ALTER LOGIN [sa] WITH NAME = [AdminUser]
GO

Read More »

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. 
http://www.askdavetaylor.com/how_can_i_add_a_google_search_box_to_my_web_site.html

GOOGLE Custom Search:

http://www.google.com/cse/ 
https://accounts.google.com/ServiceLoginAuth

The JavaScript Source: Forms: Option Search: 
http://javascriptsource.com/forms/option-search.html
http://www.javascriptsource.com/miscellaneous/site-search-source.html

Creating an ASP.NET Search Engine
http://www.developerfusion.com/article/4389/create-a-site-search-engine-in-aspnet/

A Search Box on Your Website

https://www.ixquick.com/eng/link-instructions.html

All-in-one Internal Site Search script

http://www.javascriptkit.com/script/script2/multi_site_search.shtml
http://www.javascriptkit.com/script/script2/google_site_search.shtml
http://www.javascriptkit.com/script/script2/google_site_search2.shtml
http://javascriptsource.com/miscellaneous/site-search.html


Search Page Javascript
http://www.hypergurl.com/searchpage.html

Some Links Where is implemented

http://www.haier.com/in/products/commercialairconditioner/
http://www.giipinfo.com/Search.aspx
http://webdesign.about.com/

Creating a simple search box

http://www.codestore.net/store.nsf/unid/DOMM-4X9LG3http://webdesign.about.com/od/examples/l/bl_searchengines.htm
http://iteslj.org/links/search.html

Free Site Search Engine
http://tools.digitalpoint.com/site_search.php

 

Read More »