Friday, April 29, 2011

Cluster network name resource SQL Network Name{} failed to create its associated computer object in domain{}

I got an error while installing SQL Server 2008 R2 Clustering which the error is :
"Cluster network name resource SQL Network Name{} failed to create its associated computer object in domain{} for the follwoing reason:Unable to update password for computer account. The text for teh associated error code is :Access is denied."



so if you see the error in the first image you will see also the suggestion solution to sovle this error and this problem so you have to do the following before install SQL Server Clustering :
  1. Go to Active Directory Users and Computers
  2. Right Click on SQL Cluster Name (Computer Object name)
  3. Go to Properties
  4. Go to Security Tab
  5. Add Windows Cluster Name (Computer Object name) with Full Control
  6. Apply and OK.
then remove the current installation and reinstall SQL Server 2008 R2 from begining.

Friday, April 8, 2011

SharePoint Central Administration (SPCA)


These are good articles related to SharePoint Central Administration every SharePoint Administrator or DBA must know :


SharePoint Central Administration: High Availability, Load Balancing, Security & General Recommendations

http://www.harbar.net/articles/spca.aspx



Easy access to SharePoint Central Administration for developers
http://blog.mastykarz.nl/easy-access-sharepoint-central-administration-developers/


How to change the URL for SharePoint Central Administration site
http://blogs.objectsharp.com/cs/blogs/max/archive/2008/11/14/how-to-change-the-url-for-sharepoint-central-administration-site.aspx


Change the Central Administration Web site port number (SharePoint Server 2010)
http://technet.microsoft.com/en-us/library/cc298580.aspx


Monday, April 4, 2011

Msg 3271, Level 16, State 1, Line 1 A nonrecoverable I/O error occurred on file

Today while I trying to perform backup for one database using script or SQL Server 2008 management studio I got this error

BACKUP DATABASE [SCTA_ORG] TO  DISK = N'E:\SQL 2008 DBs\MSSQL10.SQL2008\MSSQL\Backup\sct_org_4.bak' 
WITH NOFORMAT, NOINIT,  
NAME = N'SCTA_ORG-Full Database Backup', 
SKIP, NOREWIND, NOUNLOAD,  STATS = 10
GO

this is the error

Msg 3271, Level 16, State 1, Line 1
A nonrecoverable I/O error occurred on file "E:\SQL 2008 DBs\MSSQL10.SQL2008\MSSQL\Backup\sct_org_4.bak:" 112(failed to retrieve text for this error. Reason: 1815).
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is termina
ting abnormally.


Solution:
this error related to Disk space of Backup drive so to perform the backup successfully just increase the space of disk drive where the backup will be save it.