Category Archives: Uncategorized

SQL 2005 and 2008 connectivity Issues After Changing the System Name (Computer Name)


Hi All,

In My  experience I have faced so many SQL issue due to the Change of System Name (Computer Name) after installed and configured SQL server .Some of the issues are like the followings

  • Not able to login with the Instance Name
  • Not able to create or edit publications

When we tried to work with publication we might get the following errors

“SQL Server is unable to connect to server ‘ServerName’

Additional information: SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternate name are not supported. Specify the actual server name, ‘Server Name’. (Replication. Utilities)”

So when Ever we need a change in the name of the System which we installed SQL Server

Use the following Query and stored procedure to update in in the SQL schema

Query to check the current System Name with SQL

Select @@servername

And if you get the null value or the old value, use the followings to update the same

Use Master
go
exec Sp_DropServer ‘OldName’
go
Use Master
go
exec Sp_Addserver ‘NewName’, ‘local’
go

Or Just use it as simple

Type   Sp_DropServer ‘OldName’

and press Execute or F5

Type  Sp_Addserver ‘NewName’, ‘local’

and press Execute or F5

Then stop and Start SQL Services

Cheers…!!!

Advertisements

Leave a comment

Filed under SQL, Uncategorized

Windows update services missing in XP


Note able to run Microsoft windows update service as usual I go to services.msc to start the services that require run updates

1 Automatic updates

2 Background intelligence transfer service

But the Automatic updates service is not available there

Then to install the service

Go to inf directory in the system root folder normally c:\windows ,by default its  a hidden folder then you need to check off hide system folder option in Folder options

Right click “ au” in inf folder and “install

Click Browse. Locate and then click the %windir%\ServicePackFiles\i386 folder if the following conditions are true:

  • You installed Windows XP SP2 from a Windows XP SP2 CD that included SP2 as part of the base installation.
  • You downloaded and installed Windows XP SP2 from the Microsoft Web site.
  • Windows XP SP2 was included with the computer.

Note If the ServicePackFiles folder is not present on the computer, you can copy the files from a slipstreamed Windows XP SP2 installation CD.

Click OK to copy the files.

Note:

Change the setting on the computer not to display hidden files and folders. To do this, follow these steps:

On the Tools menu, click Folder Options, and then click the View tab.

In the Advanced settings list, click Do not show hidden files and folders under Hidden files and folders.

Click Apply, and then click OK.

Restart the computer.

2 Comments

Filed under Uncategorized

Endian Firewall Community Edition ( Free proxy and firewall )


” Endian Firewall Community Edition” is what am currently working with , Endian has both UTM devices for enterprise organizations and community edition for small bussieness

its a simply great product Now am using two features of endian

Endian Squid proxy and Firewall

Endian is one of the best free  Poxy and Firewall i suggest

Just Try..!!

Leave a comment

Filed under Uncategorized

Active Directory Lightweight Directory Services (ADLDS)


For installing and configuring AD LDS Instance in windows 2008 Server follow the links

http://technet.microsoft.com/en-us/library/cc754486%28WS.10%29.aspx

http://sharepoint-2010-world.blogspot.com/2011/03/installing-active-directory-lightweight.html

Leave a comment

Filed under Uncategorized

Xp internet security 2011 -Malware removal


“Xp internet security 2011” is a rogue malware will produce fake protection alerts and deny you from acess or download antimalware programs

Removal steps

This malware /virus would block you to run anti malware programs So we need to stop the virus processess first So….

1 . Download rkill from http://www.bleepingcomputer.com/download/anti-virus/rkill

2. save it in to desktop

3. double click the exe to run rkill

rkill will stop all the process related with “Xp internet security 2011”

Do not restart the machine after rinning rkill

4. Dowload latest version of Malwarebytes from http://www.malwarebytes.org

5. install and update malwarebytes

6.give a full scan

7. Remove detected treats after scan and restart the machine

Leave a comment

Filed under Uncategorized

Exchange public folder uses to share Outlook Local address book and create common calendar


With the help of exchange public folder features we can do different things that will satisfy your clients (users) daily needs

Recently I have use this features to share local address book of one user to others and also I have created Global calendars also that every one in the organization can view and edit the calendar

In this scenario We  have Exchange server and client outlook 2007

To create Global calendar

 

  • 1. Log into your mailbox using Outlook, navigate to Public Folders > All Public

Folders and locate the necessary Top-Level Public Folder. Right-click on it and             select New Folder in the pop-up menu.

  • Type in a name for the Shared Calendar, select Calendar Items in the Folder Contains drop-down list and hit OK.

2.  In order to set up the subfolder as a Shared Calendar, you will need

to assign client  permissions for this folder:

  • Right-click the Shared Calendar folder, select Properties.
  • Go to Permissions tab.
  • Hit Add and choose users and/or groups you wish to grant access permissions to.
  • Select required permissions level in the appropriate drop-down list and hit OK.

 

To Share the local address book of a user

Go through the same way above

Remember to select contacts as the Folder contains in step 2

Then open your Local address book and drag the contacts to new contacts foder uner public folder >> all public folder

 

Looks fine na !!!!!!!!

Leave a comment

Filed under Uncategorized

Simple port scanning using linux


To scan the open ports in a remote machine or server we can use a linux command that is

root]# nmap -v -P0  < your remote ip or Domain name >

The result will give you list of opened ports

Leave a comment

Filed under Uncategorized