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

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

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

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

Read More »