exciting office web apps for SharePoint 2010

No need of office installation on client machines, instead integrate web app bunch with Sharepoint 2010.

saves client licensing (CALs) cost or for those who needs to extend the office feature on the web browser. Clients can open office documents from anywhere outside office network like from Airport or from public internet zone using authorized connection. For better performance install Silverlight on client computers.

installation reference:

installing office web-apps for sharepoint 2010

How to change SQL Server Name or Instance Name

applies to all SQL ver including Denali.

i. Open SQL Server Management Studio and click New Query.

ii. Type Select @@ServerName to verify that the server name. In this example, Windows 2003 from WIN2K3R2EE to SQL Server is used. If windows hostname is changed doesn't mean that SQL Server 2005 name will be automatically changed. It will still return the old name. Let's fix it.

3. Next, type sp_dropserver 'WIN2K3R2EE'

4. You are now ready to add the correct name by typing sp_addserver 'SQLSERVER'. local

at this point if you need to change instance name, execute the below query:

sp_dropserver 'Server Name\old_Instance_name'

go 

sp_addserver 'ServerName\New Instance Name','local'

go

5. Restart sql server and the sql server agent by opening a command prompt and typing net stop mssqlserver and net start msssqlserver. To stop and start the sql server agent, type net stop or start sqlserveragent.

6. Click New Query in SQL Server Management Studio and type select @@servername to verify everything is correct and you have successfully changed the sql server name.

high availability moss 2007 development and production environment

I attained the below infrastructure from scratch (a mix of windows 2003 R2 Ent 32bit and 64bit) for our team during mid of 2010

2 Tier MOSS2007 Architecture for both development and production environment

recent: refer also 3Tier Architecture for SP2010

hide special user accounts from windows 7 display screen

How to Create Hidden User Account (Hide User Account from Welcome Screen) in Windows

Windows operating system including Windows7, Windows Vista and Windows XP allows multiple user accounts to be created on the computer, be it administrators or standard users. When there is more than one user accounts been defined and created on the PC, Windows will display Welcome Screen, with all available user accounts listed so that user can click and login.

However, showing and displaying of user accounts on the Welcome Screen is probably a weakness in the security point of view, more so if the user account is intended to be a hidden or backup user account. In fact, there is trick to make user account or administrator account that normally been listed on the Welcome Screen to be hidden from view.

In order to hide a user account (which also means create a hidden user account) in Windows XP, Vista, or Windows 7, just go to Control Panel User module and create an additional user as usually do (Control Panel -> User Accounts and Family Safety -> User Accounts in Windows 7 and Windows Vista). If you already have an existing user that wants to be made hidden, invisible or disappeared from Welcome Screen, then go straight to guide below.

1. Run Registry Editor (RegEdit.exe).
2. Navigate to the following registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon \SpecialAccounts\UserList

Note: If SpecialAccounts and UserList is not found, create new sub-key and name them accordingly.

3. Select UserList, and in the right pane, right click any blank space, and point to New -> DWORD (32-bit) Value.

4. Name the new DWORD registry value name as the exact same name that match the name of the user account to be hidden.

For example, if the user ID of the user account is John, the name the registry value as John.

5. Double click on DWORD registry value, and set the value data to 0 in oder to hide the account from Welcome Screen.

Tip: To display the user account on Welcome Screen again so that it's visible again, delete the

registry entry, or set the value data to 1.

6. Exit Registry Editor.

7. Log off or restart computer to make the change effective.

Tip: In order to login into Windows using an user account that has made hidden and invisible, just press Ctrl+Alt+Del to bring up Windows Logon dialog, and then type in the user name and password manually.

SQL 2008 R2 'Cluster Name' registration failure .. event ID 1196 and Event ID 1119

this is important for setting up SQL 2008 fail-over cluster.

Check evenlog for the event id 1196 or 1119. 

cause : 

while creating static record the option "allow any authenticated user to update DNS records with the same owner" was not selected. So, cluster nodes (active node) who will own the cluster name resource won't be able to register this resource record to the DNS database.  

Solution:

Go to DNS, find the record ( A & Pointer record) for the cluster name resource.

-right click

-go to properties

-select security make sure the "Authenticated users" are included

-make sure it has "Write: rights and Special permissions

-click Advance, locate authenticated users, and click edit

-make sure, Write all properties, Read permissions, All Validated Writes are selected

-click okay three times to exit

check backup and restore progress in SQL Server

The below script may be helpful in checking the status of huge database activity. The below script will work for any backup or restore that is currently running regardless of which method was used to run the backup or restore.

SELECT session_id as SPID, command, a.text AS Query, start_time, percent_complete, dateadd(second,estimated_completion_time/1000, getdate()) as estimated_completion_time

FROM sys.dm_exec_requests r CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) a

WHERE r.command in ('BACKUP DATABASE','RESTORE DATABASE')

percentage of database activity completion and estimated time taken to complete.

Join Citrix (CAG) database to different farm

Move the citrix access gateway server to a different farm retaining the same database:

simplified..

Step 1: Migrate citrix (CAG) database from SQL 2005 version to SQL 2008 R2

Step 2: 
check the farm database server and database name.. in this case database name is qdc-ctx-aac

we need to delete an entry from registry. so go to registry (regedit)

and delete the selected citrixAGEServer registry folder.

IMP: before deleting CitrixAGEServer foler from registry, select citrixAGEServer registry folder and export the file to a safe location.

now we need to chage the server configured value to 0 from 1

before changing MSAM value from registry, take a backup; export the file to a safe location.

double click serverconfigured name change the existing value from 1 to 0.

close registry.

Now its time to move the database to a new server.

Select Programs>>Citrix>>Access Gateway>>Server Configuration

at this instance you will be taken to CAG advanced edition server configuration wizard..

select join an existing access server farm

enter the credentials who has permission to the citrix database server.

enter the new FARM database server name followed by database name.

if you have a separate database server instance, mention for ex.: XYZ-SVR\instance name

access server farm name is the database name itself.

click next

click Next >> Next and Finish the server configuration wizard.

now select Citrix>>Access Gateway>>Server Configuration

you will now see that the farm database server name is joined to the specified new farm.

Move the citrix access gateway server to a NEW access server farm