Monday, December 23, 2013

Issue with Excel - Microsoft Office Excel cannot access the file

Please refer to the below link

http://blogs.msdn.com/b/dataaccesstechnologies/archive/2012/12/19/error-microsoft-office-excel-cannot-access-the-file-while-accessing-microsoft-office-11-0-object-library-from-ssis.aspx

Solution is as below
SOLUTION:
For Windows 2008 Server x64: Create the following directory:
C:\Windows\SysWOW64\config\systemprofile\Desktop
For Windows 2008 Server x86: Create the following directory:
C:\Windows\System32\config\systemprofile\Desktop

Friday, June 28, 2013

Network share in command prompt


pushd \\server\share

This will create a temporary mapped drive automatically for you and make it your current working directory.

When you're finished on the network share enter the popd command. This will return you to the directory you were in before and delete the temporary network drive.

Monday, June 3, 2013

Change Password of the sa user in MS SQL server

USE [master]

GO

ALTER LOGIN [sa] WITH DEFAULT_DATABASE=[master],

DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=ON, CHECK_POLICY=ON

GO

USE [master]

GO

ALTER LOGIN [sa] WITH PASSWORD='password@123' MUST_CHANGE

GO

Thursday, March 14, 2013

Run backup scheduler for MS SQL


Below is the interesting link whihc gives a clear picture on how to run a scheduler to take backup for the MS SQL server

http://weblogs.asp.net/sreejukg/archive/2010/01/20/scheduling-automated-backup-using-sql-server-2008.aspx