How to configure SQL Server 2005 to allow remote connections

Enable remote connections for SQL Server 2005 Express or SQL Server 2005 Developer Edition

You must enable remote connections for each instance of SQL Server 2005 that you want to connect to from a remote computer. To do this, follow these steps:

1.	Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Surface Area Configuration.
2.	On the SQL Server 2005 Surface Area Configuration page, click Surface Area Configuration for Services and Connections.
3.	On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Remote Connections, click Local and remote connections, click the appropriate protocol to enable for your environment, and then click Apply. Note Click OK when you receive the following message: Changes to Connection Settings will not take effect until you restart the Database Engine service.
4.	On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Service, click Stop, wait until the MSSQLSERVER service stops, and then click Start to restart the MSSQLSERVER service. Enable the SQL Server Browser service If you are running SQL Server 2005 by using an instance name and you are not using a specific TCP/IP port number in your connection string, you must enable the SQL Server Browser service to allow for remote connections. For example, SQL Server 2005 Express is installed with a default instance name of Computer Name\SQLEXPRESS. You are only required to enable the SQL Server Browser service one time, regardless of how many instances of SQL Server 2005 you are running. To enable the SQL Server Browser service, follow these steps. Important These steps may increase your security risk. These steps may also make your computer or your network more vulnerable to attack by malicious users or by malicious software such as viruses. We recommend the process that this article describes to enable programs to operate as they are designed to, or to implement specific program capabilities. Before you make these changes, we recommend that you evaluate the risks that are associated with implementing this process in your particular environment. If you choose to implement this process, take any appropriate additional steps to help protect your system. We recommend that you use this process only if you really require this process. 1. Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Surface Area Configuration. 2. On the SQL Server 2005 Surface Area Configuration page, click Surface Area Configuration for Services and Connections. 3. On the Surface Area Configuration for Services and Connections page, click SQL Server Browser, click Automatic for Startup type, and then click Apply. Note When you click the Automatic option, the SQL Server Browser service starts automatically every time that you start Microsoft Windows. 4. Click Start, and then click OK. Create exceptions in Windows Firewall These steps apply to the version of Windows Firewall that is included in Windows XP Service Pack 2 (SP2) and in Windows Server 2003. If you are using a different firewall system, see your firewall documentation for more information. If you are running a firewall on the computer that is running SQL Server 2005, external connections to SQL Server 2005 will be blocked unless SQL Server 2005 and the SQL Server Browser service can communicate through the firewall. You must create an exception for each instance of SQL Server 2005 that you want to accept remote connections and an exception for the SQL Server Browser service. SQL Server 2005 uses an instance ID as part of the path when you install its program files. To create an exception for each instance of SQL Server, you must identify the correct instance ID. To obtain an instance ID, follow these steps: 1. Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Configuration Manager. 2. In SQL Server Configuration Manager, click the SQL Server Browser service in the right pane, right-click the instance name in the main window, and then click Properties. 3. On the SQL Server Browser Properties page, click the Advanced tab, locate the instance ID in the property list, and then click OK. To open Windows Firewall, click Start, click Run, type firewall.cpl, and then click OK. Create an exception for SQL Server 2005 in Windows Firewall To create an exception for SQL Server 2005 in Windows Firewall, follow these steps: 1. In Windows Firewall, click the Exceptions tab, and then click Add Program. 2. In the Add a Program window, click Browse. 3. Click the C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe executable program, click Open, and then click OK. Note The path may be different depending on where SQL Server 2005 is installed. MSSQL.1 is a placeholder for the instance ID that you obtained in step 3 of the previous procedure. 4. Repeat steps 1 through 3 for each instance of SQL Server 2005 that needs an exception. Create an exception for the SQL Server Browser service in Windows Firewall To create an exception for the SQL Server Browser service in Windows Firewall, follow these steps: 1. In Windows Firewall, click the Exceptions tab, and then click Add Program. 2. In the Add a Program window, click Browse. 3. Click the C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe executable program, click Open, and then click OK. Note The path may be different depending on where SQL Server 2005 is installed.

Server failed to load application ( WIndows )

The server failed to load application '/LM/W3SVC/1/Root/'. The error was 'The server process could not be started because the configured identity is incorrect. Check the username and password'


there are 2 ways to resolve the issue.

1)

Give "Logon as a batch job" rights to the IWAM_MACHINENAME and IUSR_MACHINENAME accounts. To do this, follow these steps: 1. On the Administrative Tools menu, expand Local Security Policies.
2. Select User Rights Assignment.
3. Select the IWAM_MACHINENAME and IUSR_MACHINENAME accounts.NOTE: If domain level policy settings are defined, they override local policy settings. Make sure that the Effective Policy Setting is also selected (this setting is dimmed). Contact your domain administrator if this setting is not selected


2 ) Resetting the application in IIS

Go to Sites properties and on home directory tab, set app process from high to low and click apply, then set back to high and click apply


All set.

Restore Corrupted DHCP DB

The DHCP database is contained in the Dhcp.mdb file located in the %SystemRoot%\System32\Dhcp folder. The DHCP server uses this file to record and store information concerning active leases and reservations. Most of this information is also contained in the following registry key:
Windows NT 4.0:
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\DHCPServer\Configuration

Windows 2000:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DhcpServer\Configuration
Whenever the DHCP service shuts down correctly, it makes a backup copy of both the database file (Dhcp.mdb) and the registry key. The backup information from the registry is contained in the file Dhcpcfg. For Windows NT 3.51, the file Dhcp.mdb is located in the %SystemRoot%\System32\Dhcp\Backup\Jet folder. In Windows NT 4.0, the file Dhcp.mdb is located in the %SystemRoot%\System32\Dhcp\Backup\Jet\New folder. Both versions of Windows NT store the Dhcpcfg file in the %SystemRoot%\System32\Dhcp\Backup folder.

To recover a corrupted DHCP database, use one of the following methods:
• Restore a backup copy of the database file, Dhcp.mdb

- or-
• Generate a new database file using the DHCP Configuration registry key.
Restoring a backup copy of the database file is the recommended method because you will not lose information when you use it.

After you recover your database file using one of the methods mentioned earlier, you must reconcile the information between the database file and the registry information.

NOTE: The following steps assume that your DHCP server will not start because of a corrupted DHCP database. If your DHCP server starts, but the database is corrupted, you have to start by stopping the service.

To stop the DHCP server service, type the following at a command prompt:
net stop dhcpserver

Back to the top
Restoring a Backup Copy of the Database
Warning If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.
1. Move the files from your existing DHCP folder to a different location, being careful to keep the DHCP folder structure intact. For example, type the following at a command prompt and press ENTER after each line:
md c:\Olddhcp move %SystemRoot%\system32\DHCP\*.* C:\Olddhcp
2. Remove the corrupted database file.
3. Copy the backup database file into the DHCP folder by typing the following at a command prompt, and then pressing ENTER:
• Windows NT 3.51

copy %SystemRoot%\system32\dhcp\backup\jet\dhcp.mdb %SystemRoot%\system32\dhcp\dhcp.mdb
• Windows NT 4.0

copy %SystemRoot%\system32\dhcp\backup\jet\new\dhcp.mdb %SystemRoot%\system32\dhcp\dhcp.mdb
If your computer is running Microsoft Windows 2000, modify the following registry key to restore the DHCP server:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\DHCPServer\Parameters
Change the RestoreFlag REG_DWORD value in this registry key to 1.

You may also choose to restore the Dhcp.mdb file to the %SystemRoot%\System32\Dhcp folder from a tape backup or other backup media.

Because you are using an existing database file, whether you restore it from backup media or the backup folder, you must use the Jetpack utility to compress it.

For additional information, click the article number below to view the article in the Microsoft Knowledge Base:
145881 (http://support.microsoft.com/kb/145881/EN-US/) How to Use Jetpack.exe to Compact a WINS or DHCP Database
The above procedure should allow the service to start, but if your scope information is missing, you must use a backup copy of the Dhcpcfg registry file to restore your scope and reservation information. See steps 5 through 11 in the "From the New DHCP Server" section of the following article:

For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
130642 (http://support.microsoft.com/kb/130642/) How to Move a DHCP Database to Another Windows Server

Back to the top
Generating a New Database File
1. Move the files in your existing DHCP folder to a different location, being careful to keep the DHCP folder structure intact. For example, type the following at a command prompt, pressing ENTER after each line:
md c:\olddhcp move %SystemRoot%\system32\dhcp\*.* c:\olddhcp
2. Select the next step from the following list, depending on which version of Windows NT Server you are using:

Windows NT Server 3.51:

Expand a new copy of System.mdb from the original Windows NT Server source media by inserting your original Windows NT Server 3.51 CD into your CD-ROM drive. To do so, type the following at a command prompt, and then press ENTER:
expand D:\I386\System.md_ %SystemRoot%\System32\Dhcp\System.mdb

where D: is your CD-ROM drive and i386 is your platform.

Windows NT Server 4.0:

Restart the DHCP server with an empty DHCP folder. Windows NT 4.0 and Windows 2000 do not use a System.mdb file.
The above procedure should allow the service to start, but if your scope information is missing, you must use a backup copy of the Dhcpcfg registry file to restore your scope and reservation information. See steps 5 through 11 in the "From the New DHCP Server" section of the following article:

Install php 4.x on windows

Howto: Install PHP on Windows 2003 Web Edition

1) Download latest version of PHP from www.php.net
2) Unzip contents to c:php
3) Copy all files from c:phpdlls to c:windowssystem32
4) Copy all files from c:phpsapi to c:windowssystem32
5) Copy c:phpphp.ini to c:windowsphp.ini

6) Open IIS, and add a "Web Service Extension"
7) Call the extension "PHP"
8) set the path as c:windowssystem32php4isapi.dll
9) set the status to "allow"
10) Right click the "Web Sites" folder, and select properties
11) On the "Home Directory" tab, select "Configuration"
12) Click "Add", then browse to c:windowssystem32php4isapi.dll, set the extension as .php, and deselect "Verify that the file exists".
13) Click Okay
14) Apply the setting to all sites.
15) Restart IIS


if the sites runs temp. sessions then we will need to provide the everyone write access
just add the every one to the ACL and give it write permission.

Php Issues with Windows

Notice: Undefined offset: 3 in D:\webspace\iconres\familydoctor\familydoctor.co.in\www\includes\sites.php on line 45

Notice: Undefined offset: 3 in D:\webspace\iconres\familydoctor\familydoctor.co.in\www\includes\sites.php on line 45


Put this in sites.php on the top




// Report all errors except E_NOTICE
error_reporting(E_ALL ^ E_NOTICE);

Mysql on windows

had the problem with "*ERROR 2003: Can't
connect to MySQL server on 'localhost' (10061)*"
and here is how I resolved the issue. I thought I
would share my solution with you...

1. Uninstalled mysql (I guess my first installation
was corrupted).

2. c:\mysql\bin>mysqld-nt.exe --install or run it from GUI.
if mysqld-nt.exe does not work run mysqld-max-nt.exe

3. Reboot (not necessary)

4. Now, check the task manager and mysqld-nt.exe
should be running at the background. If not, there is
something wrong with the install -- I believe
it was my problem.

5. C:\mysql\bin>mysql -u root mysql

6. mysql> set password for
root@localhost=PASSWORD("funfun");

7. mysql> update user set password=PASSWORD
("funfun") where user='root';

8. mysql> flush privileges;

Note that funfun is my password

Microsoft uninstaller utility

Not able to remove or uninstall an application in Windows XP using either the Uninstall option or the Add/Remove Programs tool? Try using the Windows Installer CleanUp Utility. As long as you installed the application using the Windows Installer, this utility will remove all the folders, files, registry keys, and entries from your system and allow you to start over with a clean slate.

Here's how:

Download the Windows Installer CleanUp Utility from the Microsoft Download Center.
Locate and run msicuu2.exe to install the Windows Installer CleanUp Utility.
Locate and launch the Windows Installer CleanUp Utility on the Start menu.
From the Windows Installer CleanUp Utility window, locate the application in the list and click the Remove button.
Once the application has been removed, click the Exit button to close the utility.
You may now reinstall the application.

Mail Enable Issue account asking for password

There was an issue with mail enable on a windows server

when client is trying to access the mails through outlook
outlook was constantly asking for password.

it was a dedicated windows mail server have mail enable as a mail client.

as per Rajashree what I have done. is

I went to C://program files / mail enable / configs/ auth.tab

auth.tab is a file where all the username and passwords are saved.but it was clear

there was one more file auth.sav these file also contains the same info.
I rename the auth.tab with auth3.tab and save as the auth.sav as auth.tab
and issue resolved.
`

Issue with Lsass.exe with windows

Issue with lsass.exe on windows server 2003

can be resolved as follows. -

IF you are getting lsass.exe is terminated unexpectedly and server shutting down now.
the issue can be resolved as follows.

The main reason behind that is the virus attack as trojan and worms.due lack of update the antivirus.

lsass.exe - its a important system process that should be stable on the server ,
"lsass.exe" is the Local Security Authentication Server. It verifies the validity of user logons to your PC/Server. It generates the process responsible for authenticating users for the Winlogon service. This process is performed by using authentication packages such as the default Msgina.dll. If authentication is successful, Lsass generates the user's access token, which is used to launch the initial shell. Other processes that the user initiates inherit this token. More info

Note: The lsass.exe file is located in the C:\Windows\System32 folder. In other cases, lsass.exe is a virus, spyware, trojan or worm! Check this with Security Task Manager.

The .exe file can be trying to use files and functions that aren't working properly. This can be a cause of EXE errors.

you will find Here are some of the processes running. These are the infected processes.

1. avserve.exe
2. avserve2.exe
3. hognubn.exe
4. rundll32 cwcprops

Update your existing ativirus. or scan the server with norton or Mcaffe.


Use a firewall. This can be as simple as turning on the Internet Connection Firewall included in Windows XP, to purchasing and installing hardware devices such as a NAT router. Either of these solutions will likely protect you from Sasser and many other types of non-email-based threats.

Install the patch. This patch for your operating system can be found with Microsoft Security Bulletin MS04-011.

Remove the virus. There are several Sasser removal tools floating around, Microsoft's What You Should Know About the Sasser Worm and Its Variants has one.

Update and run your Anti-Virus software. Make sure that both of those steps happen automatically in the future as well. For example, my virus scanner is configured to check for updates and run a scan nightly.

Stay up-to-date. There are several options, but I endorse running Windows Automatic Update for Windows XP. My preference is to have it download and notify me of changes that are ready to install. In addition - or, if you prefer, instead - you should also visit Windows Update on a regular basis for additional updates to your system. I probably visit once a month.

Jmail mailer ASP error issue

There was an issue with a contact us page of the site

it was throwing the error

like

Server object error 'ASP 0178 : 80070005'

Server.CreateObject Access Error

The call to Server.CreateObject failed while checking permissions. Access is denied to this object.

when I checked I found jmail as the mail component on the server

First I checked for all the ASP use permission , it was right
then checked for Default SMTP server permission
added IIS_WPG user to it and then checked but no luck
then after searching on google I got a forum link on swsoft
and the resolution was to find the .dll file for that mailer component
like jmail.dll for jmail . I found it and as per solution I gave full permissions to everyone user and issue resolved.

Installing,Configuring ISAPI on windows

Installing ISAPI Filters
Like ISAPI extensions, ISAPI filters are programs that respond when the Web server receives an HTTP request. They are different from applications in that they are driven by Web server events rather than by a client request. You can associate an ISAPI filter with a particular Web server event; the filter is then notified every time its associated event occurs. For example, a filter could be notified when a Read or Write event occurs and then encrypt the raw data to be returned to the client.

You can install filters for all sites on a server (global filters), and you can install filters for individual Web sites. If you install both global filters and site filters, the two filter lists are merged for the site.

When several filters have registered for the same event, they are called sequentially. Filters with a higher priority are run before filters with a lower priority. If several filters have the same priority, global filters set in the master properties are run before filters set at the site level. Filters with the same priority at the same inheritance level are run according to the order in which they were loaded. You can change the filter load order on the property sheets for the Web server or Web site.

Unlike ISAPI extensions, ISAPI filters are always run in the server process.

To add a filter to a Web server or Web site

In the Internet Information Services snap-in, select the Web server or Web site and open its property sheets.
Click the ISAPI Filters tab.
Note If you are adding filters to a Web site, you will not see any global filters inherited from the Web server's master properties. You will see only the filters installed for the Web site, even though both sets of filters are run.

Click the Add button.
Type the name of the filter in the Filter Name box and either type or browse for the DLL file in the Executable box.
Click OK.
To change the load order of a filter, use the arrows.
Note You can only change the load order of filters with the same priority.

If you have added or changed a global filter, you must stop and restart the Web server to load the new filters into memory. A filter added at the Web site level is automatically loaded when you add it.
Note If an HTTP request triggers an event for which the filter is registered, the filter will receive the data contained in the request regardless of whether the request is for a file, a CGI application, or an ISAPI extension.

Create IP security policy

How to Create an IPSec Filter List

To create an IPSec filter list that applies to both inbound TCP port 80 and TCP port 25:
1. Click Start, point to Programs, point to Administrative Tools, and then click Local Security Policy.
2. Click to expand Security Settings.
3. Right-click IP Security Policies in the left pane, and then click Manage IP filter.
4. Click the Manage IP Filter Lists tab in the Manage IP filter lists and filter actions dialog box, and then click Add.
5. Type Inbound TCP 80 and 25 in the Name box, and then type Allows inbound traffic to TCP ports 80 and 25 in the Description box.
6. Click to clear the Use Add Wizard check box, and then click Add to add a new filter list entry.
7. Click the Addressing tab.
8. Click Any IP Address in the Source address box.
9. Click My IP Address in the Destination addressbox. This configuration indicates that the filter will be applied to inbound packets.
10. Click to clear the Mirrored check box.
11. Click the Protocol Tab.
12. Click TCP in the Select a protocol type box.
13. Click From any port, and then click To this port.
14. In the To this port box, type 80.
15. Click Apply, and then click OK.
16. Click Add in the IP Filter List dialog box.
17. Click the Addressing tab.
18. Click Any IP Address in the Source address box.
19. Click My IP Address in the Destination address box. This configuration indicates that the filter will be applied to inbound packets.
20. Click to select the Mirrored check box. When you do this, a filter with the opposite source and destination IP address is created.
21. Click the Protocol tab.
22. Click TCP in the Select a protocol type box.
23. Click From any port, and then click To this port.
24. Type 25 in the To this port box.
25. Click Apply, and then click OK.
26. Click Close in the IP Filter List dialog box.

How to Create an IPSec Policy That Is Based on the Filter List

To create an IPSec policy that is based on the filter list:
1. Right-click IP Security Policies in the left pane, and then click Create IP Security Policy.
2. In the Welcome to the IP Security Policy Wizard, click Next.
3. In the IP Security Policy Name dialog box, type Permit Inbound TCP 80 and 25 in the Name box, and then click Next.
4. Click to clear the Activate the default response rule check box, and then click Next.
5. In the Completing the IP Security Policy Wizard dialog box, click to select the Edit properties check box if it is not already selected, and then click Finish.

6. Click the Rules tab.
7. Click to clear the Use Add Wizard check box, and then click Add.
8. Click the IP Filter List tab.
9. Click Option that is to the left of Inbound TCP 80 and 25 IP Filter List.
10. Click the Filter Action tab.
11. Click Option that is to the left of Permit.
12. Click Apply, and then click OK.
13. The Inbound TCP 80 and 25 Filter List check box is selected. Click Close.

The IPSec policy checks for packets that are destined for TCP port 80 and TCP port 25 on the local interface, and then matches those packets to the Permit filter action, which allows the packets through the interface.

Backup IIS configuration

To back up your IIS configuration, follow these steps: 1. In the IIS snap-in on the local computer, click the Computer icon under Internet Information Services.
2. Click Action and select Backup/Restore Configuration.
3. Click Create backup, choose a name for your backup file, and then click OK.

NOTE: The default location of the backup is the %SystemRoot%\system32\inetsrv\MetaBack folder. If you want to save your backup file to another location, you can copy the file from this default location to another location. Keep a copy in the default location to allow for an easy restoration. Note that by default, C:\Winnt is the %SystemRoot% folder in Microsoft Windows 2000.

Enable IP routing

To enable IP routing
1. Click Start, click Run, type regedit.exe, and then click OK.
2. In the registry editor, navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters
3. Select the IPEnableRouter entry.
4. Click Edit, and then click Modify.
5. Under Value data, set the value of this field to 1, to enable IP routing for all network connections installed and used by this computer.
6. Close the registry editor.

Assign or unassign IPsec policy for local computer

To assign or unassign IPSec policy for local computer policy
1. Click Start, click Run, type MMC, and then click OK.
2. Click File, click Add/Remove Snap-in, and then click Add.
3. Click Group Policy Object Editor, and then click Add.
4. Click Finish, click Close, and then click OK.
5. In the Group Policy console tree, click IP Security Policies on Local Computer.

Disable TCP / IP Packet Filtering

To disable TCP/IP packet filtering
1. In Control Panel, double-click Network Connections.
2. Right-click the connection, and then click Properties.
3. Select Internet Protocol (TCP/IP), and then click the Properties tab.
4. Click Advanced, and then click the Options tab.
5. Under Optional Settings, click TCP/IP Filtering, and then click Properties.
6. Clear the Enable TCP/IP Filtering (All adapters) check box, and then click OK.

Internet Explorer can not open the site on server itself

the issue -

Internet explorer not able to browse the site , throwing up the error message as "Invalid Syntax error" though all the things like DNS , network , IP resolution working fine
here are the steps




RESOLUTION
To resolve this problem in Internet Explorer, follow these steps:
1. Quit all programs that are running.
2. Click Start, and then click Run.
3. Type regsvr32 urlmon.dll, and then click OK.
4. When you receive the "DllRegisterServer in urlmon.dll succeeded" message, click OK.
If this does not resolve the problem, repeat steps 2 through 4 for each of the following files (in step 3, replace Urlmon.dll with each of the file names below):
• Shdocvw.dll
• Actxprxy.dll
• Oleaut32.dll
• Mshtml.dll
• Browseui.dll
• Shell32.dll

Truncate SQL Log Files

How to truncate the sql database on the sql server.

1) login to sql server on which the datebase is hosted.
2) Open the enterprise manager >> select the database >> opent the properties for it.
3) check the size.
4) Open the query analyzer select the database and fire the following query.

BACKUP LOG "DATABASE_NAME" WITH TRUNCATE_ONLY
DBCC SHRINKFILE ('database-name_Log', 1) it means that you are truncating the database at 1 mb.You can specify the size whatever you want.

Active Directory authorative restoration

Restart the domain controller (DC) of interest.
When you see the menu to select the OS, press F8.
From the Windows Advanced Options Menu, select Directory Services Restore Mode, then press Enter.
Select the Windows 2003 OS, then press Enter.
Use the restore mode password and log on as the administrator.
Click OK to the confirmation that Windows is running in Safe mode.
Start the Windows Backup application (go to Start, Programs, Accessories, System Tools, and click Backup).
Select the Restore option, then select the media where the backup is stored and ensure that the System State is selected.
Click OK to close any warning dialog boxes.
After the AD recovery is complete, click Close to the displayed dialog box and click Yes to restart the computer.

When the machine restarts, you need to specify which parts of the restoration will be authoritative by performing the following steps:

When you see the menu to select the OS, press F8.
From the Windows Advanced Options Menu, select Directory Services Restore Mode, then press Enter.
Select the Windows 2003 OS, then press Enter.
Use the restore mode password to log on as the administrator.
Click OK to the confirmation that Windows is running in Safe mode.
Open a command prompt--go to Start, Run and type
cmd
Start the Ntdsutil utility.
To access the authoritative restore mode, type
ntdsutil: authoritative restore
If you want to mark the entire database as authoritative, type
authoritative restore: restore database
If you want to mark only a certain object as authoritative (e.g., an organizational unit--OU), type
authoritative restore: restore subtree name--DN--of subtree, e.g. OU=sales,DC=savilltech,DC=com>
To exit Ntdsutil, type
quit
Restart the DC as usual.

If you perform an authoritative restoration of a backup that's more than 14 days old, some trust relationships might be broken because the passwords used by the trust would have been changed twice (the directory stores both the current and previous password, which changes every 7 days). So, for example, when restoring NT LAN Manager (NTLM) trusts, you would have to break the trust, then recreate it.



--------------------------------------------------------------------------------

Helm License Issues

Helm Issue with windows server,

was facing the issue while login in to the control panel.


Error message

" Unable to login to the control panel configuration error , please contact support "


solution -


there may be the issue with the license , you can check the error logs on the server
at /Helm / logs / errors

if you got the error like license expired

click on start >>Helm>>helm license tool

click on update.it will update the license for the CP issue resolved.

but while accessing that tool I was getting the error message of invalid Pic.
that tool is a third party tool of Helm and can be downloaded manually .
the I call Ganesh

in the helm folder we found the .exe file of that tool and it was renamed
we renamed it to proper name and access the tool
update that license and got the issue resolved.

Dynamic Disks ( Raid 0 , 1 )

Dynamic disks
Dynamic disks support new features and sport new terminology. Here's a look at the different types of volumes you can create with a dynamic disk:

Simple volumes use space from a single disk or a hardware array volume.
Spanned volumes are non-fault-tolerant disk sets that use free space from multiple disks in the system.
Striped volumes are non-fault-tolerant disk sets (RAID 0) that stripe data across multiple disks in the system.
Mirrored volumes are fault-tolerant disk sets (RAID 1) that mirror data from one disk to another.
RAID 5 volumes are fault-tolerant disk sets that stripe data across three or more disks and include parity information.

Diskusage Utility in Windows Server

The Windows Server 2003 Resource Kit includes the User Disk Usage tool (Diskuse.exe), a command-line utility that monitors disk space usage on a per-user basis.

This utility offers a number of parameters. For a complete list of these parameters, enter diskuse /? at the command line.

Here are some of the most useful parameters of this utility:


/s: This returns results for the current directory and all subdirectories.
/t: This returns the output in a tabular format.
/f:: This writes the results to the specified file, which you can import into Excel for analysis.

DDOS potection on Windows Server

SUMMARY
Denial of service (DoS) attacks are network attacks that are aimed at making a computer or a particular service on a computer unavailable to network users. Denial of service attacks can be difficult to defend against. To help prevent denial of service attacks, you can use one or both of the following methods: • Keep your computer updated with the latest security fixes. Security fixes are located on the following Microsoft Web site:
http://www.microsoft.com/security (http://www.microsoft.com/security)
• Harden the TCP/IP protocol stack on your Windows Server 2003 computers. The default TCP/IP stack configuration is tuned to handle standard intranet traffic. If you connect a computer directly to the Internet, Microsoft recommends that you harden the TCP/IP stack against denial of service attacks.

Back to the top

TCP/IP Registry Values That Harden the TCP/IP Stack
Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall your operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.
The following list explains the TCP/IP-related registry values that you can configure to harden the TCP/IP stack on computers that are directly connected to the Internet. All of these values should be created under the following registry key, unless otherwise noted:


HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services
NOTE: All values are in hexadecimal unless otherwise noted. • Value name: SynAttackProtect
Key: Tcpip\Parameters
Value Type: REG_DWORD
Valid Range: 0,1
Default: 0

This registry value causes Transmission Control Protocol (TCP) to adjust retransmission of SYN-ACKS. When you configure this value, the connection responses time out more quickly during a SYN attack (a type of denial of service attack).

The following parameters can be used with this registry value: • 0 (default value): No SYN attack protection
• 1: Set SynAttackProtect to 1 for better protection against SYN attacks. This parameter causes TCP to adjust the retransmission of SYN-ACKS. When you set SynAttackProtect to 1, connection responses time out more quickly if the system detects that a SYN attack is in progress. Windows uses the following values to determine whether an attack is in progress: • TcpMaxPortsExhausted
• TCPMaxHalfOpen
• TCPMaxHalfOpenRetried


Note In Windows Server 2003 Service Pack 1, the default value for the SynAttackProtect registry entry is 1.

• Value name: EnableDeadGWDetect
Key: Tcpip\Parameters
Value Type: REG_DWORD
Valid Range: 0, 1 (False, True)
Default: 1 (True)

The following list explains the parameters that you can use with this registry value: • 1: When you set EnableDeadGWDetect to 1, TCP is permitted to perform dead-gateway detection. When dead-gateway detection is enabled, TCP may ask the Internet Protocol (IP) to change to a backup gateway if a number of connections are experiencing difficulty. Backup gateways are defined in the Advanced section of the TCP/IP configuration dialog box in the Network tool in Control Panel.
• 0: Microsoft recommends that you set the EnableDeadGWDetect value to 0. If you do not set this value to 0, an attack may force the server to switch gateways and cause it to switch to an unintended gateway.

• Value name: EnablePMTUDiscovery
Key: Tcpip\Parameters
Value Type: REG_DWORD
Valid Range: 0, 1 (False, True)
Default: 1 (True)

The following list explains the parameters that you can use with this registry value: • 1: When you set EnablePMTUDiscovery to 1, TCP tries to discover either the maximum transmission unit (MTU) or the largest packet size over the path to a remote host. TCP can remove fragmentation at routers along the path that connect networks with different MTUs by discovering the path MTU and limiting TCP segments to this size. Fragmentation adversely affects TCP throughput.
• 0: Microsoft recommends that you set EnablePMTUDiscovery to 0. When you do so, an MTU of 576 bytes is used for all connections that are not hosts on the local subnet. If you do not set this value to 0, an attacker may force the MTU value to a very small value and overwork the stack.

Important Setting EnablePMTUDiscovery to 0 negatively affects TCP/IP performance and throughput. Even though Microsoft recommends this setting, it should not be used unless you are fully aware of this performance loss.

• Value name: KeepAliveTime
Key: Tcpip\Parameters
Value Type: REG_DWORD-Time in milliseconds
Valid Range: 1-0xFFFFFFFF
Default: 7,200,000 (two hours)

This value controls how frequently TCP tries to verify that an idle connection is still intact by sending a keep-alive packet. If the remote computer is still reachable, it acknowledges the keep-alive packet. Keep-alive packets are not sent by default. You can use a program to configure this value on a connection. The recommended value setting is 300,000 (5 minutes).
• Value name: NoNameReleaseOnDemand
Key: Netbt\Parameters
Value Type: REG_DWORD
Valid Range: 0, 1 (False, True)
Default: 0 (False)

This value determines whether the computer releases its NetBIOS name when it receives a name-release request. This value was added to permit the administrator to protect the computer against malicious name-release attacks. Microsoft recommends that you set the NoNameReleaseOnDemand value to 1.

Back to the top

Troubleshooting
When you change the TCP/IP registry values, you may affect programs and services that are running on the Windows Server 2003-based computer. Microsoft recommends that you test these settings on nonproduction workstations and servers to confirm that they are compatible with your business environment.

Install Clamav on cpanel server

Download the latest stable ClamAV distribution from http://www.clamav.net
Expand the distribution and cd into the resultant directory and build ClamAV using:

tar -xzf clamav-*

cd clamav*

./configure

make

make install

Create an empty log file for clamav updates:

touch /var/log/clam-update.log

chown clamav:clamav /var/log/clam-update.log

At this point you can setup ClamAV only in:

pico -w /usr/mailscanner/etc/MailScanner.conf

Virus Scanners = clamav

Then restart MailScanner with:

service MailScanner restart

Or you can install the more efficient Mail::ClamAV module. You'll need to install some perl modules first (all on one line):

/scripts/perlinstaller /scripts/perlinstaller Net::CIDR Archive::Zip

Compress::Zlib Convert::BinHex Inline::C

Then install the ClamAV perl module:

/scripts/perlinstaller Mail::ClamAV

Then setup clamavmodule:

pico -w /usr/mailscanner/etc/MailScanner.conf

Virus Scanners = clamavmodule

Then restart MailScanner with:

service MailScanner restart

You can now set what domains you want scanned for viruses in:

/usr/mailscanner/etc/rules/virus.scanning.rules

Operation must use an updateable query. Database Issue

Error name - Debug messages: Operation must use an updateable query.

Soln. -


CAUSE
This problem may occur if the following conditions are true: • You used the Database Interface Wizard in Microsoft Office FrontPage 2003 to create the database interface Web page.
• You set ASP.NET as the technology to use to connect to the database.
• The database is on a Microsoft Windows Server 2003-based Internet Information Server (IIS).
• A Microsoft Access Database (MDB) is used as the database source.
This problem occurs when a Microsoft Access database file is used as your database source because you must grant write access to both the default worker process identity and the authenticated user. By default, both Internet Information Server version 5.0 and Internet Information Server version 6.0 typically grant write access to both the default worker process identity and the authenticated user. However, when you use an MDB file as your database, these permissions must be granted by an administrator on the server that hosts the Web site.




WORKAROUND
To work around this problem, grant write access permission for the MDB file to both the IIS_WPG group and the Network Service. To do this, follow these steps:1. Log on as an administrator to the Microsoft Windows Server 2003-based computer that hosts your Web site.
2. Click Start, right-click My Computer, and then click Explore.
3. Expand the folder tree to the location of your Web site database file. For example, this file may be located in the following location:
C:\Documents and Settings\Administrator\My Documents\My Web Sites\Your_Web_Site_Name\fpdb
4. Right-click Your_Web_Site_Database_Name.mdb, and then click Properties.
5. Click the Security tab, and then click Add.
6. In the Enter the object names to select box, type IIS_WPG, and then click OK.
7. In the Group or user names list, click IIS_WPG.
8. In the Permissions for IIS_WPG list, click to select the Allow check box that is next to Write.
9. Click Add.
10. In the Enter the object names to select box, type Network Service, and then click OK.
11. In the Group or user names list, click Network Service.
12. In the Permissions for Network Service list, click to select the Allow check box that is next to Write.
13. Click Apply, and then click OK.



Some server does not supports to the IIS_WPG users in this case you should check for the NETWORK user to grand the proper permissions.

Database errors on a site , windows

There was an issue with the site

URL - kaws.org/costshare/index.asp

afer filling up the info it was giving the error like

Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access 97 Driver] Operation must use an updateable query. ...

the resolution was to add everyone user to the folder where the access DB file resides
the .mdb file and needs the write permission to only that folder where the DB is

Note - do not inherit the permission to other folders just means do not go to advance tab
just set the write permission to that folder only.

thats all .

Configure the ASP Web Application

Configure the ASP Web Application
1. In the Internet Information Services window, right-click Example, and then click Properties.
2. Click the Home Directory tab.
3. Under Application Settings, click Create.

NOTE: If the Create button is not present, a default application has already been specified. In this case, click Remove to remove the default application, and then click Create.
4. Clear the contents of the Application name box, and then type Example.
5. Click the Documents tab, and then click Add.
6. In the Default Document Name box, type Input.htm, and then click OK.
7. In the document list, click Input.htm, and then click Move up until Input.htm is at the top of the list.
8. Click OK.

Configure ASP Web Application on windows

How to Configure an ASP Web Application
Certain properties can be set for each ASP application that you have created. To configure an ASP application, follow these steps:
1. Start IIS Manager or open the IIS snap-in.
2. Expand ServerName, where ServerName is the name of the server, and then expand Web Sites.
3. Right-click the Web site or the starting-point directory of the application that you want, and then click Properties.
4. Depending on the starting-point directory that you selected, click the Home Directory, Virtual Directory, or Directory tab.
5. Under Application Settings, click Configuration, and then click the Options tab.
6. Click to select the Enable session state check box if you want ASP to create a session for each user who accesses an ASP application.
7. Click to select the Enable buffering check box if you want ASP to collect all output that is generated by the ASP page before the output is sent to the requesting Web browser.
8. Click to select the Enable parent paths check box if you want ASP to use relative paths to the parent directory of the current directory (paths using the .. syntax).

NOTE: If you select this option, do not grant Execute permissions in the parent directories. This is to prevent a script in a subdirectory from running an unauthorized program in a parent directory.
9. In the Default ASP language box, type the language that you want to use.

This box specifies the language that is used to process commands in the ASP delimiters (<% and %>). Note that VBScript is the default ASP language.

NOTE: You can override the default language in your ASP page by using the <%@LANGUAGE%> directive.
10. In the ASP Script timeout box, type the length of time that want the ASP to allow a script to run.

NOTE: You can set the time-out period to a value ranging from 1 to 2147483647.
11. Click OK two times to save your changes and return to the Internet Information Services window.
12. Quit IIS Manager or close the IIS snap-in.

Install CDONTS on windows

Install CDONTS Windows 2003
As you should know, on Windows 2003 Server, CDONTS was deprecated and CDOSYS is the new one Microsoft email sender component (read more on Microsoft Website)

However, some ASP scripts will require CDONTS and customers can need CDONTS install.

So, to install CDONTS

1) First, install MailEnable or other SMTP server. Make sure it is running.
2) Download and unzip cdonts.dll to C:WindowsSystem32 folder
3) Register the CDONTS.DLL component on your server by clicking start >> run >> type :
regsvr32 c:winntsystem32cdonts.dll >> ENTER

Block IP address on windows server

1. Create a Filter list and assign an action

Right-click on IP Security Policies on Local Computer
Click Manage IP filter lists and filter actions
On the Manage IP Filter Lists tab, click Add
Check 'Use Add Wizard'
Type 'Banned Ips' in the Name field and click add
Click 'Next'
Check 'Mirrored'
Click 'Next'
Select 'My IP Address' for the Source Address
Click 'Next'
Select "A specific IP Address' and type in the ip you would like to block
*note you can also select 'A specific IP Subnet' if you know the subnet for the range
Click 'Next'
Select 'Any' for the protocol type
Click 'Next'
Uncheck 'Edit Properties'
Click 'Finish'
Click 'Ok'
Repeat the previous step for any additional IPs
Click the 'Manage Filter Actions' tab at the top
Check use Add Wizzard
Click 'Add'
Click 'Next'
Type 'Banned IPs - Deny'
Click 'Next'
Select Block
Click 'Next'
Uncheck 'Edit Properties'
Click 'Finish'

2. Apply the rule to the Security Policy

Right-click 'IP Security Policies on Local Computer'
Click 'Create IP Security Policy'
Click 'Next'
Type 'Banned IPs'
Click 'Next'
Uncheck 'Activate the default response rule'
Check 'Edit Properties"
Click 'Finish'
On the Rules Tab, check 'Use Add Wizard'
Click 'Add'
Click 'Next'
Select 'This rule does not specify a tunnel'
Click 'Next'
Select 'Local area network (LAN)'
Click 'Next'
Dot 'Banned Ips'
Click 'Next'
Dot 'Banned Ips - Deny'
Click 'Next'
Click 'Finish'
Click 'Ok'
Click 'Ok'
Right-click the New Policy 'Banned IPs'
Click 'Assign'

Awstats issue on Hosting Controller

Hello,

The stats work now . You can check the same at

http://telanganaonline.com/stats/awstats.pl?config=telanganaonline.com&update=1

The problem was

1. The Awstats link was asking for a username/password , set the password for the domain to its IUSR password which was in the directory security.

2 The second error was service unavailable. For this changed the pool from hcpool to default pool.

3 The next error was then page cannot be displayed. Perl extensions were prohibited under webservice extensions in IIS , enabled it.

4. Then there was a permission problem . Granted permission to conf file under awstats/data folder and stats worked

ASP.NET Tab disappeared in Home Directory Tab

When you retrieve the properties for a virtual directory in Microsoft Internet Information Services (IIS) Manager, the ASP.NET tab of IIS Manager does not appear. Alternatively, the Edit Configuration button on the ASP.NET tab is disabled.

This problem occurs when any one of the following conditions is true:
• You are using the 32-bit version of IIS Manager on a 64-bit computer.
• You are using IIS in Microsoft Windows-32-on-Windows-64 (WOW64) mode.
• You have set the Enable32bitAppOnWin64 property to True in IIS. This setting lets IIS run in 32-bit mode on a 64-bit computer.
Note WOW64 is an emulation layer that enables 32-bit Windows-based applications to run seamlessly on 64-bit computers.


CAUSE
This problem occurs because the 32-bit version of IIS Manager is incompatible with 64-bit computers that use Microsoft ASP.NET.

This problem can also occur because the 64-bit version of IIS Manager cannot load the 32-bit Aspnet_isapi.dll file as a native 64-bit file. Additionally, the 64-bit version of IIS Manager cannot load this file in WOW64 32-bit mode.

To work around this problem, use the 64-bit version of IIS Manager. Also, do not use IIS Manager in WOW64 mode.you can download it from Microsoft site.

Configure ASP Upload on a Windows server

Problem Description

This article outlines the steps necessary to make AspUpload work under the Microsoft ASP.NET framework. It also describes some of the problems and issues associated with using AspUpload under .NET.

Solution

1. Enable classic ASP compatibility mode

AspUpload 3.0 is not a native ASP.NET component. It was written specifically for classic ASP, and it uses many intrinsic ASP objects such as Request. Therefore, you must enable the classic ASP compatibility mode for all pages using AspUpload by setting the aspCompat attribute of the @Page directive to True:

<%@ Page aspCompat="True" other attributes%>

Failure to do so will result in the run-time error

There is no MTS object context

2. Place ASPUPLOADLib.dll under \bin directory of your app

Create a \bin subdirectory under your ASP.NET application and place the wrapper assembly ASPUPLOADLib.dll in it. Alternatively, you can place this file in the Global Assembly Cache.

The file ASPUPLOADLib.dll is included in the download given below. You may also re-create this file using the command-line utility TLBIMP.

3. Use ASPUPLOADLib.IUploadManager type to declare Upload object

Declare and instantiate the main Upload Manager object as follows:

VBScript:

Dim objUpload As ASPUPLOADLib.IUploadManager
objUpload = New ASPUPLOADLib.UploadManager

C#:

ASPUPLOADLib.IUploadManager objUpload;
objUpload = new ASPUPLOADLib.UploadManager();

4. In C#, use Missing.Value for optional arguments

AspUpload's main "workhorse" Save method takes 3 optional arguments. In many cases you will be using only the first argument (path) or none at all (if saving to memory).

C# requires all three arguments to be specified. Use the expression Missing.Value for arguments you do not wish to use:

objUpload.Save("c:\\upload", Missing.Value, Missing.Value);

You must import the namespace System.Reflection to use the Missing object:

<%@ Import Namespace="System.Reflection" %>

4. In C#, shortcuts won't work

A VBscript expression such as

txtName = Upload.Form("name")

must be fully expanded in C#, as follows:

txtName = objUpload.Form.Item("Name").Value;

5. In C#, use + instead of & to concatenate strings

A VBscript expression such as

txtLine = File.Name & "= " & File.Path & " (" & File.Size &" bytes)
"

must be rewritten in C# as follows:

txtLine = objFile.Name + "= " + objFile.Path + " (" + objFile.Size + " bytes)
";

6. Adjust maxRequestLength in web.config if necessary

The upload limit is set to 4MB (4096) by the httpRuntime section of the machine.config file. You can change this setting to affect all applications on your site, or you can override the settings in your application-specific web.config as follows:





7. Review code samples

We have rewritten the code samples Form1.asp/UploadScript1.asp, Form2.asp/UploadScript2.asp, and Form3.asp/UploadScript3.asp in C#. Click on the following link to download the .aspx versions of these code samples, along with the wrapper assembly ASPUPLOADLib.dll:

ASP Time Outs Issue

very Intresting Issue

Getting ASP timed outs error , the site name was see.com.pk

1) Site properties ( Default site )
2) check for asp time outs on home directory tab
3) change it to the relevant time
4) will see a list of sites select the site to which you wan to apply the change.
to resolve the issue I just go to properties of the site and reset the asp timouts from home directory after it works but again the site was throwing the same issue.

Allow file downloads (including .exe) on IIS 6.0

Vishwas - If you are trying to run an .exe on IIS 6.0 then you obviously need to:
1. Enable "Scripts and Executables" Execute permission for the URL
2. Make sure that .exe does NOT have an application mapping
3. [IIS6 only] Have Web Service Extension for the EXE

I think you probably have a mistaken setting of #2 somewhere; similar to Jason also having a mistaken setting of #2 that prevents the right thing from happening.

Jason - if .old tries to execute, it means that you have an application mapping for .old AND you have "Scripts" Execute Permissions.

Similar to .exe, you either:
1. Change to "None" Execute Permissions. This prevents application mappings from taking effect
2. Remove the application mapping for .old

I suspect you accidentally set up a .old application mapping, so I suggest #2 first.

Adding Subdomains Through IIS

Please go through the following steps for adding the subdomains :

1.Please access your billing control panel.
2.Click on "Add DNS A Record" Link.

If suppose , you want to create "mahesh.listtrendy.com" subdomain, then type :

Name = mahesh , TTL = 86400 , Data = 206.51.236.124 -> Click on Submit Button.

Now , please Login to your server:

1.Create "mahesh.listtrendy.com" directory under C:\
2.Create "www" directory under "mahesh.listtrendy.com" directory.
3.Open IIS
3.Right Click on website - > New - > website
4.Go ahead.

Qmail Handle Admin

qmHandle, a perl script which gives you greater functionality - allows you to view and manage the 'qmail' message queue.

It can be install by excuting the following commands
cd /usr/bin
wget -O - "http://easynews.dl.sourceforge.net/sourceforge/qmhandle/qmhandle-1.2.0.tar.gz" | tar xzf

Following commands are useful to manage the queue

# List emails by subject wise:
qmHandle -l |awk '/Subject/ {print}'|sort | more

#qmHandle -tX 'string' ( delete all messages with matching headers, where string to match and X specifies:

'f' : Who the message is from,

't' : Who the message is to; or,

's' : What the message's subject is

#qmHandle -M ( delete all msgs in the queue from MAILER-DAEMON@hostname)


# Forcefully send emails.
qmHandle -a

# List message queues
qmHandle -l

# delete all messages in the queue
qmHandle -D

# list local message queue
qmHandle -L

# list remote message queue
qmHandle -R

# display message number N
qmHandle -mN

# delete message number N
qmHandle -dN

# delete all messages that contain text as Subject
qmHandle -Stext

# delete all messages that contain text as From email address
qmHandle -Ftext

# delete all messages that contain text as To email address
qmHandle -Ttext

Might be some of you know about it or don't need it, then please ignore it.

SQL server Connect

1) Go to Start/Programs/Microsoft SQL Server/Client Network Utility
2) Make sure TCP/IP is in the Enabled list and on top
3) Click on the ALIAS tab
4) Click ADD
5) Enter 'yourdatabasename' for the Alias
6) Select TCP/IP for the Network Library
7) Change Server Name under Connection Parameters to "sqldb.domain.com" (This depends on your server configuration)
(use your domain name), Click OK
8) Click OK again to Close Client Network Utility
9) Go to Start/Programs/Microsoft SQL Server/Enterprise Manager
10) Expand Microsoft SQL Servers
11) Right click on SQL Server Group
12) Select New SQL Server Registration
13) Click Next
14) Highlight 'yourdatabasename' Alias and click ADD
15) Click Next
16) Under Connect Using select SQL Server Login, click Next
17) Enter your username
18) Enter your password
19) Click Next, Click Next again, Click Finish, Click Close

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q265808&sd=tech (Client network)


sql2k5 = tim/abc123 = login details.

Restore DB from Log Files , SQL server

The scenario

A coworker calls you in a panic because he accidentally deleted some production data, and he wants you to restore the lost records.

If you are lucky, you have a data auditing system in place, and you can restore these records from an audit table. If you do not have a tool that will read a transaction log so that you can to undo transactions, you will likely need to restore the altered database to a certain point in time on the same or separate server than the server hosting the current database instance.
The restoration process

Note that, for the purpose of this article, I am assuming that your database recovery mode is set to FULL.

The first step in the process is to perform a tail-log backup. You want to perform this type of backup before a database restore to ensure that any records that have changed since the last backup are available to be included in the restore process.

Next you should locate where the database backup files are stored on the machine or the network. It may be a good idea to copy these files to your target server if you are going to be restoring the database on a different server. In the backup file location, find the very last full database backup that was completed (these files usually end with the extension .bak); you need to restore this full backup. The script below applies the full backup file to the NewDatabase database:

RESTORE DATABASE NewDatabase
FROM DISK = 'D: \BackupFiles\TestDatabaseFullBackup.bak'
WITH
MOVE 'PreviousDatabase' TO 'D:\DataFiles \TestDatabase.mdf',
MOVE 'PreviousDatabase_log' TO 'D:\DataFiles \TestDatabase_Log.ldf',
NORECOVERY

The code specifies that the location of the full backup file is on your server’s D drive and that you are restoring the file to the database named NewDatabase. The statement moves the data file and the log file from the full backup to new files for my TestDatabase database. The last statement in the script, NORECOVERY, is very crucial. The NORECOVERY mode is one of three available options, which are outlined below.

* NORECOVERY: Tells SQL Server that you are not finished restoring the database and that subsequent restore files will occur. While the database is in this state, the database is not yet available, so no connections are allowed.
* RECOVERY: Tells SQL Server that you are finished restoring the database, and it is ready to be used. This is the default option, and it is by far the one that is used most often.
* STANDBY: Tells SQL Server that the current database is not yet ready to be fully recovered and that subsequent log files can be applied to the restore. You can use this option so that connections are available to the restore database if necessary. However, future transaction logs can only be applied to the database if no current connections exist.

Once you restore the full backup using the NORECOVERY option, you can begin applying the transaction log backups or the differential backup.

Differential backup
A differential backup is a backup of any changes to the database that have occurred since the last full database backup. If you have multiple differential backups, you will only need to restore the very last one taken. In this situation, there are no differential backups, so you can move directly to the transaction log backups.

Transaction log backups
A transaction log backup keeps track of all transactions that have occurred since the last transaction log backup; it also allows you to restore your database to a point in time before a database error occurred. Transaction log backups occur in sequence, creating a chain. When restoring a sequence of transaction log backups to a point in time, it is required that the transaction log files are restored in order.

When you use a database maintenance plan to create the transaction log backups, a time indicator is typically included in the transaction log file name. The script below applies three transaction log backups using the NORECOVERY option, and the last statement restores the database to availability to the time frame at the very end of the last transaction log file.

RESTORE LOG NewDatabase
FROM DISK = ''D: \BackupFiles\TestDatabase_TransactionLogBackup1.trn'
WITH NORECOVERY

RESTORE LOG NewDatabase
FROM DISK = ''D: \BackupFiles\ TestDatabase_TransactionLogBackup2.trn'
WITH NORECOVERY

RESTORE LOG NewDatabase
FROM DISK = ''D: \BackupFiles\ TestDatabase_TransactionLogBackup3.trn'
WITH NORECOVERY

RESTORE LOG NewDatabase
FROM DISK = ''D: \BackupFiles\ TestDatabase_TransactionLogBackup4.trn'
WITH RECOVERY

Restoring to a point in time
In the example above, you restore the database to the end of the last transaction log. If you want to recover your database to a specific point in time before the end of the transaction log, you must use the STOPAT option. The script below restores the fourth transaction log in the log sequence to 4:01 PM — just before the database mishap occurred.

RESTORE LOG NewDatabase
FROM DISK = ''D: \BackupFiles\ TestDatabase_TransactionLogBackup4.trn'
WITH STOPAT = N'6/28/2007 4:01:45 PM', RECOVERY

Now that you have the database restore to a point where you need it to be, it is time to decide how to help the developers in order to make their situation a little bit easier. My suggestion is to copy the table the developers need to a separate table on the server so that you or they can correct the data problem.
Be prepared

Restoring your database to a point in time is one of those things that you never want to have to use, but you need to be able to complete it if necessary. I took an overview approach as to how to restore your SQL Server database using transaction logs for a certain circumstance. It’s important to note that companies use different approaches for backing up data, so it is very important to be thoroughly involved in your company’s database backup process. Be sure to test restores and restore situations often so that you are ready when a disaster does occur.

Truncate SQL DB log Files

How to truncate the sql database on the sql server.

1) login to sql server on which the datebase is hosted.
2) Open the enterprise manager >> select the database >> opent the properties for it.
3) check the size.
4) Open the query analyzer select the database and fire the following query.

USE Master database
BACKUP LOG "DATABASE_NAME" WITH TRUNCATE_ONLY;

use the original database
DBCC SHRINKFILE ('database-name_Log', 1) it means that you are truncating the database at 1 mb.You can specify the size whatever you want.

How to Enable a table for full text indexing , SQL server

How to enable a table for full-text indexing

In Microsoft SQL Server 2005, all user created databases are full-text enabled by default. However, individual tables within a database need to be enabled for full-text indexing.

To enable a table for full-text indexing

Expand the server group, expand Databases, expand User Databases, and expand the database that contains the table you want to enable for full-text indexing.

Right-click the table that you want to enable for full-text indexing.

Select Full-Text index, and then click Enable Full-Text indexing.


After that you will need to fire the following queries

USE myevilt_main ( database name )
sp_fulltext_database 'enable'
sp_addrolemember 'dbo' , 'myevilt_chopper'

Fire the queries seperately. in query analyzer.

Data Transmission , SQL server

how to create data transformation services package in SQL Server

thru DTS wizard
Hivelocity - Vaibhav says:
ok
Hivelocity - Vaibhav says:
How can we access it
Aress PC - Chetan says:
righ click database - all tasks - export
Aress PC - Chetan says:
if you want to export the db to another database which is online on either the same server or

a different server
Hivelocity - Vaibhav says:
ok
Hivelocity - Vaibhav says:
and what i need to do to get the packaged scheduled for execution once it is created
Aress PC - Chetan says:
you can choose either right away or at a pre scheduled time
Hivelocity - Vaibhav says:
ok
Hivelocity - Vaibhav says:
so thats all Sir

Connecting to SQL DB

If you have an SQL database set up with your web host, a useful tip to know is how to connect to your SQL database via Enterprise Manager. The advantage of knowing how to do this is that you will be able to manage your SQL Server database via Enterprise Manager over TCP/IP, yourself.

You can obtain Enterprise Manager by downloading MSDE (Microsoft Data Engine) from http://msdn.microsoft.com/vstudio/msde/default.asp.

Before creating the connection to your SQL database ensure your web host has created an SQL user for you and also make sure you know the IP Address of the server your SQL database is located on.

When creating an SQL connection using SQL Server you will need to:

Configure the server alias
-Create the SQL connection.
-Configure the Server alias
-Open SQL Server Client Network Utility.
-When Client Network Utility opens, click on the Alias tab.
-Click on the Add button.
-In the Server Alias text box enter a name for your SQL connection.
-Select TCP/IP under Network libraries
-Enter the IP address of the Server your SQL database is located on, in the Server name text box.
-Click on the OK button.
-Your Server alias will now be configured, click on the Apply button.
-Click on the OK button.

Create Connection
-Open SQL Server Enterprise Manager
-When Enterprise Manager opens, right click SQL Server Group and select New SQL Server Registration.
-The Register SQL Server wizard will now open.
-Click on the Next button.
-From the Available Servers drop down menu, select the server alias you created earlier.
-Click on the Add button.
The server should now be listed under Added servers, click on the Next button.
When the next dialog box appears select ‘The SQL Server login information that was assigned to me by the system administrator’ (see above).
-Click on the Next button.
-Enter your Login name and Password – this will be used every time you connect to your SQL server.
-Click on the Next button.
-Ensure that ‘Add the SQL Server(s) to an existing SQL Server group’ is selected and ‘SQL Server Group’ is selected for Group name.
-Click on the Next button.
-When the next dialog box opens you can click on the Finish button.
Your SQL Connection will now be created.

My.cnf

cat /root/.my.cnf

fire the above command to view the root mysql password of the server ( Cpanel server )

Mysql DB permission and Repair

GRANT ALL PRIVILEGES

GRANT ALL PRIVILEGES ON admin_test.* TO admin_test123@'%' IDENTIFIED BY 'test123';

Mysql Backup

mysqldump -u root -p mixmaker_mixdb > dbbackup.sql

DB repair
mysqlcheck -p -auto-repair -mixmaker_mixdb;

Login to Mysql

mysql -p - to login to mysql


mysql -p -u username - to login to mysql with different username

Reset root pass for mysql on windows

Log on to your system as Administrator.

Stop the MySQL server if it is running. For a server that is running as a Windows service, go to the Services manager:

Start Menu -> Control Panel -> Administrative Tools -> Services
Then find the MySQL service in the list, and stop it.

If your server is not running as a service, you may need to use the Task Manager to force it to stop.

Create a text file and place the following command within it on a single line:

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPassword');
Save the file with any name. For this example the file will be C:\mysql-init.txt.

Open a console window to get to the DOS command prompt:

Start Menu -> Run -> cmd
We are assuming that you installed MySQL to C:\mysql. If you installed MySQL to another location, adjust the following commands accordingly.

At the DOS command prompt, execute this command:

C:\> C:\mysql\bin\mysqld-nt --init-file=C:\mysql-init.txt
The contents of the file named by the --init-file option are executed at server startup, changing the root password. After the server has started successfully, you should delete C:\mysql-init.txt.

If you install MySQL using the MySQL Installation Wizard, you may need to specify a --defaults-file option:

C:\> "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt.exe"
--defaults-file="C:\Program Files\MySQL\MySQL Server 5.0\my.ini"
--init-file=C:\mysql-init.txt
The appropriate --defaults-file setting can be found using the Services Manager:

Start Menu -> Control Panel -> Administrative Tools -> Services
Find the MySQL service in the list, right-click on it, and choose the Properties option. The Path to executable field contains the --defaults-file setting.

Stop the MySQL server, then restart it in normal mode again. If you run the server as a service, start it from the Windows Services window. If you start the server manually, use whatever command you normally use.

You should be able to connect using the new password.

Creating Mysql DB

Note:
To login into Northbeach server use
username as root and password
and for all other servers username and password is same as plesk login info
===============================================
mysql path
/var/lib/mysql

===================================
Restart mysql

/etc/rc.d/init.d/mysql stop
/etc/rc.d/init.d/mysql start


===================================
mysql -u TYPEUSERNAMEHERE -p

username is "admin" (same as plesk) and password "chtnta0e" (plesk password)

=========================================
Grant previligaes and enable remotehost login etc.
Always use this one
GRANT ALL PRIVILEGES ON bCo.* TO nan@'%' IDENTIFIED BY 'weenie';
bCo is Databse name
nan is username
weenie is password
so in general form

GRANT ALL PRIVILEGES ON dbname.* TO username@'%' IDENTIFIED BY 'password';

===============================
Solutiuon
Posted by [name withheld] on December 30 2003 1:15pm [Delete] [Edit]

Your second example, in which you claim MySQL is wrong in their documentation, will not work because you are trying to use a backquote (`) instead of the single quote ('). They look similar but are completely different. Thus your example:

GRANT ALL PRIVILEGES ON testData.* TO jts@'%' IDENTIFIED BY 'lwr5021' WITH GRANT OPTION;

does not work because nan@'%` is not properly quoted. It should read nan@'%' instead which is fine. This works as expected:

GRANT ALL PRIVILEGES ON bCo.* TO nan@'%' IDENTIFIED BY 'weenie' WITH GRANT OPTION;


Posted by Mike Barrett on January 7 2004 10:52am [Delete] [Edit]

I wanted to create a use who can

1) login with a password either locally or from within our local 10.*.*.* network

2) do anything they want to their own database

3) see what other databases are on the server, but not do anything to them (to facilitate requests for additional access).

This seemed to do the trick:
GRANT SHOW DATABASES ON *.* TO hubert@localhost IDENTIFIED BY 'password';
GRANT SHOW DATABASES ON *.* TO hubert@'10.%' IDENTIFIED BY 'password';
GRANT ALL ON hubertsdb.* TO hubert;

==============================================
Reset or set password

SET PASSWORD FOR 'mynewuser'@'localhost' = PASSWORD('newpwd');


====================================================
Create Database
Log into Mysql as root:

mysql -u root -p

(On a Windows server, go start>>run type "command", and it is d:\mysql\bin\mysql -u root -p')

2. Create the database:

create database DATABASENAME;

3. Create the user and grant privileges for the database:

grant select,insert,update,delete,create,drop,alter on DATABASENAME.* to MYSQLUSERNAME@'%' identified by 'PASSWORD';

4. Send new MySQL database email to customer.


=======================================================
To Administrar the mysql processes
Logged in to mysql as root:

show processlist;

Or not logged into mysql, to get a running view:

watch mysqladmin processlist -u admin -pPASSWRD
==================================================

To flush the cache command is :

mysqladmin flush-hosts -uadmin -pchtnta0e

Reset root password for mysql

UPDATE mysql.user SET password=PASSWORD( 'fe9371' ) WHERE user='root'



ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost'

Adding Mysql DB

To create the mysql DB use following way

Create the database:

control_mysql add DB_NAME

Create the database user for this domain:

control_mysql adduser USER_NAME

Set the new user's password:

control_mysql password USER_NAME

At this point, the new user exists, but has no permissions. Your default MySQL user must

GRANT permissions to this new user.


flush previleges ;

fire the above query to refresh the permissions.

Reconstructing Mail Box

Reconstructing a sample mailbox

In my example, I’m moving test.user from one server to another. I have created a new account on the target server, redirected incoming mail to that server/account, created an archive of the user’s mailbox on the old server, transferred that archive, checked its integrity (MD5), and then unpacked it in to the correct location on the target server.

So, how do we recover and reconstruct the mailbox? There are two ways: either from the cyradm console or using the reconstruct tool. I tend to use the latter.

First, we need to switch from root to the cyrus user:

# su - cyrus
cyrus@mail:~>

Next locate the ‘reconstruct’ tool, it should be in the default path of the cyrus user but if not use ‘find’ or ‘locate’. Mine lives in /usr/lib/cyrus/bin/.

The usage of ‘reconstruct’ is reasonably straightforward. I generally use the -r and -f flags. The -r flag tells the reconstruct tool to recursively reconstruct sub-mailboxes (mailbox subfolders) and the -f flag instructs it to examine the filesystem underneath the mailbox and add any directory containing a cyrus.header file. The -f flag is generally used when restoring a mailbox from backup or moving data from one mailbox to another.

cyrus@mail:~> reconstruct -r -f user/test.user

user/test.user
user/test.user/Sent
user/test.user/Spam
user/test.user/Trash

Before testing the account, it’s recommended to fix the quotas:

cyrus@mail:~> quota -f
cyrus@mail:~> exit

Log on to the IMAP account via your preferred agent (Webmail, Outlook, Thunderbird) and you should be able to see all of the messages and subfolders. If you can’t see any of the subfolders check that your client is subscribed to them.

553 sorry, that domain isn't allowed to be relayed thru this MTA (#5.7.1)

553 sorry, that domain isn't allowed to be relayed thru this MTA (#5.7.1)
Probably mail server does not accept mail for greatnztravel.com and recognizes this as relay attempt.
Some of your MX do not work properly



to fix this issue

add the the domain in rcpthosts file

cd /var/qmail
nano rcpthosts

Upgrading Zend

Upgradin Zend.....Opt.


1) Locate the php.ini file and remove all the zend entries for Zend like [zend] that is for old version of Zend.

2) cd /root

3) wget http://downloads.zend.com/optimizer/2.5.10/ZendOptimizer-2.5.10a-linux-glibc21-i386.tar.gz

where 2.5.10 is the version you can change it as per client's need.

4) tar zxvf ZendOptimizer-2.5.10a-linux-glibc21-i386.tar.gz

5) ZendOptimizer-2.5.10a-linux-glibc21-i386/install

6) rm -rf ZendOptimizer-2.5.10a-linux-glibc21-i386*


done all set....

Upgrade PHP issues

Generally while upgrading php on a centOs direct admin server
it creates the issues with libxml2 installation cause php is not able to find the libxml 2 on the server.

you have to fire the following command to install the libxml 2

yum install libxml2 - for installing libxml 2
yum install libxml2-devel to install devel.

Reinstalling Exim

mv /etc/exim.conf /etc/exim.conf.old

yum install exim


above are the steps to reinstall the exim on a non cpanel server


to install exim on cpanel server

1) mv /etc/exim.conf /etc/exim.conf.old

2) /scripts/exim up --force

Installing Zend on Cpanel servers

Installing Zend Optimizer for Cpanel servers.

/scripts/installzendopt/

http://downloads.zend.com/optimizer/2.5.10/ZendOptimizer-2.5.10-linux-glibc21-i386.tar.gz

just go on hitting Enter key.

and lastly

restart apache


For other servers. This needs to be done manually.

cd /root
deltree -f Zend*
wget http://downloads.zend.com/optimizer/3.0.1/ZendOptimizer-3.0.1-linux-glibc21-i386.tar.gz
tar -xzvf ZendOptimizer-3.0.1-linux-glibc21-i386.tar.gz
cd Zend*
./install.sh

Installing Ioncube

1)cd /root;

2) wget http://downloads.ioncube.com/loader_downloads/ioncube_loaders_lin_x86.tar.gz;

3) tar -xvzf ioncube_loaders_lin_x86.tar.gz; mv ioncube /usr/local; pico /usr/local/lib/php.ini

4) Insert this line in php.ini file on the server on exactly above where Zend lines are located. "zend_extension = /usr/local/ioncube/ioncube_loader_lin_4.4.so"

restart the apache service


all set.

GD installation

Installing GD through WHM

under software on the left menu in WHM
click on Load previous modules
so that it does not loose then
click update apache
click GD


It will compile the apache .

Installing Fantastico WHM

FatNetMark: rm -rf /var/netenberg/
rm -rf /usr/local/cpanel/whostmgr/docroot/cgi/fantastico/
rm -rf /usr/local/cpanel/3rdparty/fantastico*
rm -rf /usr/local/cpanel/base/frontend/*/fantastico
rm -f /usr/local/cpanel/base/frontend/x/cells/fantastico.html
FatNetMark: Now do these:

cd /usr/local/cpanel/whostmgr/docroot/cgi
wget -N http://www.netenberg.com/files/free/fantastico_whm_admin.tgz
tar -xzpf fantastico_whm_admin.tgz
rm -rf fantastico_whm_admin.tgz

One by one in shell

After that go to whm and :

Now go to WHM, login as root and follow the link

WHM -> Add-Ons -> Fantastico De Luxe WHM Admin (scroll down the left menu).



Installing fantastico from WHM

1) In the left pane at the bottom search for Fantastico De linux WHM admin
2) In the right pane you will see the message of install it.
3) First change the permission of /usr/bin/wget to 755
chmod 755 /usr/bin/wget
4) and then in whm select the skins you want to install.
5) Specify a email address at the end in order to update the client the updates of the fantastico.
6) all set .

Exim Admin

1) Print a count of the messages in the queue:

root@localhost# exim -bpc

2) Print a listing of the messages in the queue (time queued, size, message-id, sender, recipient):

root@localhost# exim -bp

3) Print a summary of messages in the queue (count, volume, oldest, newest, domain, and totals):

root@localhost# exim -bp | exiqsumm

4) Generate and display Exim stats from a logfile:

root@localhost# eximstats /path/to/exim_mainlog

5) Generate and display Exim stats from a logfile, with less verbose output:

root@localhost# eximstats -ne -nr -nt /path/to/exim_mainlog

6) Generate and display Exim stats from a logfile, for one particular day:

root@localhost# fgrep 2007-02-16 /path/to/exim_mainlog | eximstats

7) Print what Exim is doing right now:

root@localhost# exiwhat

8) To delete frozen emails

exim -bp | awk '$6~"frozen" { print $3 }' | xargs exim -Mrm

9) To deliver emails forcefully

exim -qff -v -C /etc/exim.conf &

Change port for Exim

open up the exim.conf
search for the line

daemon_smtp_port = 25

change the value to 26

done.

Cpanel awstats Issue

Error :
Error: LogFile parameter is not defined in config/domain file Setup ('/home/user/tmp/awstats/awstats.domain.com.conf' file, web server or permissions) may be wrong. See AWStats documentation in 'docs' directory for informations on how to setup awstats.

Usually this means that the account has exceeded their disk quota and the awstats.domain.com.conf file cannot be created.

This could also mean that the /home/user/tmp doesn't have the correct permissions, you should ensure that this is set to 700, you can do this via the cPanel file editor, or ftp program.

The stats will not run until the accounts disk quota has been increased or /home/user/tmp permissions have been fixed. You also might have to wait up to 24 hours for logs to run again, or you can force logs to run with this command if you own the server:

/scripts/runlogsnow

or if you would like to run only one account:

/scripts/runweblogs

Searching for the hidden domains in Cpanel

as per the rule, each and every account should be seen in whm
if it is not visible, then there is a conflict in thier settings
run /scripts/updateuserdomains
and you will get to see the error
if no error then there is no as such hidden stuffs
but if a client has added any parked or addon domain, then it will be not visisble in the LIST ACCOUNTs section

ADDON DOMAIN will be vissble only in subdomain section


There was an issue , the client have transferred the account from the external server to HV server
but when were trying to list the accounts the domain was not showing in the list.
well as usual I think the resolutions should be as above but it was not working.
Amol ugale was with me , he checked the issue at the end we found the the domain didnt have any entry in httpd.conf file , the entry was with another domain , we edit the httpd.conf file with replacing that domain name with correct domain , and we got the issue resolved.

Change mail server IP on Cpanel

Changing Outgoing mail server's IP on cpanel server

1) vi /etc/exim.conf
2) search for 'remote_smtp', you will find more than 1, but you need to search
for one ie. having driver = smtp
3) add the following line below driver = smtp
interface = newIP
4) save & exit
5) service exim restart

Cpanel SSL service issue

Starting cPanel services: [ OK ]
Starting cPanel Log services: [ OK ]
Starting pop3 services: [ OK ]
Starting cPanel Chat services: [ OK ]
Starting Melange Chat services: [ OK ]
Starting cPanel ssl services: [FAILED]


Resolution -

ps aux | grep stunnel

kill -9 stunnel_pid

service restart cpanel


Fixed

Cpanel Site Issue

Intresting issue =

for this site I was getting this error
myspacecomedy.com

it was on a dedicated server the error was the page of the cpanel there no site configured on this IP

well the solution was needs to configure the proper nameservers in WHM
also the httpd was not running

we edit the httpd.conf file
look for the virtual host entry in the file.
found the virtual host entry with wrong IP.
we set the proper IP for it

and get it done.

------------------------------------------------------------------------------------------------------------------------------

Same issue

edited httpd.conf as follows

add a server alias manually as below , the total line

ServerAlias igeva.com.br www.igeva.com.br
and deleted the www suffix from server name = www.geva.com.br
so it was only geva.com.br.

Cpanel not showing accounts

There was an intersting issue with the cpanel
a client rebooted the server and messed up with the domain and the accounts on the sever
after reboot he was not able to view the list of the accounts

he had WHM on the server.

go with the following script.

/scripts/updateuserdomains

Cpanel License Expire

If problem for cpanel - Licence File Error

First check the IP of server at following link
http://layer1.cpanel.net/verify/

or

http://verify.cpanel.net/

If is is active Run following script

/usr/local/cpanel/cpkeyclt


cpanel Licence :

http://verify.cpanel.net/index.cgi?ip=69.46.24.82



root@server [/etc/sysconfig]# date
Thu Jan 3 00:47:49 EST 2002


Barry says:
ntpdate time.apple.com will set it



Try running the program /usr/local/cpanel/cpkeyclt
to re-initialize the license again if you encounter any other licensing errors.


Please also check the following as one of it might be the case for invalid Lic. for Cpanel/WHM

1. Is the license expired?
2. Is the server's hostname a fully qualified domain name?
has address xxx.xxx.xxx
3. Does the server's hostname resolve locally and remotely?
4. Does cpkeyclt report a problem?
5. Is there a firewall blocking connections to the licensing server?
6. Is the license IP address bound directly to the interface and not an IP alias?
7. Does the licensing server think the server's query is coming from the proper IP address?

Cpanel can not add User or Account

WWWAcct 10.0 (c) 1997-2005 cPanel, Inc.

+===================================+
| New Account Info |
+===================================+
| Domain: benstar.com
| Ip: 65.110.53.*** (n)
| HasCgi: y
| UserName: benscom
| PassWord: ********
| CpanelMod: x2
| HomeRoot: /home
| Quota: 50 Meg
| NameServer1: ns1.****.net
| NameServer2: ns2.****.net
| NameServer3:
| NameServer4:
| Contact Email: ***@***.com
+===================================+
Unable to add the user benscom

================================================== ===

Do following steps for solving "Unable to add user "----" "problem :

1) check /usr/local/cpanel/logs/error_log for the error when trying to create an account
2) chmod +w passwd,v ( cd /etc)
3) ll /etc/group*
-rw-r--r-- 1 root root 6336 Nov 16 21:40 /etc/group
-rw------- 1 root root 6359 Nov 16 21:39 /etc/group-
4)chattr -i /etc/group
5) mv /etc/gshadow /etc/gsahdow.corrupted
And run grpconv to rebuild the file.You should be able to create accounts now. Please verify that everything is running fine.

Some IMP. URLs

1)http://www.microsoft.com/downloads/details.aspx?FamilyID=61a41d78-e4aa-47b9-901b-cf85da075a73&displaylang=en server performance monitoring tool from microsoft the easiest way to analyze the reports.

2)http://msdn.microsoft.com/library/default.asp?url=/library/en-us/iissdk/html/5d8a5d43-66f9-4185-8270-804d1dc4d4ca.asp


3)http://www.windowsnetworking.com/articles_tutorials/Windows_2003/

4) http://support.acmeinternet.com/

5) IIS.net