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
And if you get the null value or the old value, use the followings to update the same
exec Sp_DropServer ‘OldName’
exec Sp_Addserver ‘NewName’, ‘local’
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
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.
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.
” 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
“Xp internet security 2011” is a rogue malware will produce fake protection alerts and deny you from acess or download antimalware programs
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
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 !!!!!!!!
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