TDS SQL Based Software Error and Solution

While Open TDS Deductions at source it may show the warning message as Registration failed. ..Contact RMS J Jalandhar

Solution

1. Download attached TDS Software from PoTools.
2. Replace the already available version.
3. Just Ignore the message as file already in use

Download

Download

INSTALL SQL SERVER 2008 R2 IN WINDOWS 2008 SERVER / SEVEN

SQL 2008 Server R2 Installation

An evaluation copy of SQL Server 2008 R2 can be downloaded from here.

Download SQL 2008 R2

Recommendations Before Installing SQL Server 2008 R2

• Use NTFS file system.
• Do no try to install SQL Server 2008 R2 on a compressed drive, because setup will block the installation.
• Do not install SQL Server on a Domain Controller. 
• Configure your firewall to allow SQL Server access. 
• The user account that is running SQL Server Setup must have administrative privileges on the computer.
• Verify Windows Management Instrumentation service (Control Panel -> Administrative Tools -> Services) is running.
• The computer where you are planning to install should be connected to the Internet.
• Do not install SQL Server 2008 R2 side-by-side with SQL Server 7, because it is not supported.

Software Requirements

• .Net Framework 3.5 SP1 is needed.
• Windows Installer 4.5 or later is required.
• Internet Explorer 6 SP1 is required.

Hardware Requirements

• At least 2.0 GB of available hard disk space
• Supported Operating Systems: Windows Server 2008 ; Windows Server 2003 Service Pack 2; Windows Server 2003 Small Business Server R2; Windows Vista; Windows XP Service Pack 2
• 1024 x 768 video resolution

Installation Instruction

Run SQL Server 2008 R2 setup. First, setup checks to determine software requirements are installed. If not, you will be prompted to install

• Install .Net 3.5 and Windows Installer 4.5

In SQL 2008 R2 Installation > New Installation / Add features to an existing Installation.

The following is a new page on SQL Server setup, its name is Setup Role. Here you have three options:

• Choose "SQL Server feature installation" to install SQL Server Database Engine, Analysis Services, Integration Services, Reporting Services.
• Choose "Analysis Services with SharePoint Integration" if you want SQL Server setup to add PowerPivot for SharePoint to a SharePoint farm.
• Choose "All Features With Defaults" to install all features of SQL Server in one box.

The page below belongs to the second set of Setup Support Rules.

This page is just for the purpose of reviewing disk usage. Click on the "Next" button to continue setup.

It is recommended to create a local user or domain user account to start SQLServer services, the next page setup will display is all about SQL Server service accounts.

If the computer is not part of a domain, use a local user account without Windows administrator permissions. You can create this account using Control Panel -> User Accounts.

Use a Domain User Account if the service must interact with network services or access domain resources. This account should be pre-created by a domain administration in your environment.

On the Database Engine Configuration page, choose the authentication mode to use for your SQL Server installation.

Enter and confirm the password for the (sa) login when you choose Mixed Mode Authentication.

CANNOT CONNECT TO BPRO DATABASE : SANCHAY POST

Sanchay Post BPRO Database Problem And Solution

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

Cannot Connect to BPRO Database

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

Database 'BPRO' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.

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

OK 

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

Solution

1. Check Drive Space(BPRO Database configured drive). it should be minimum 1GB
2. Check Log file of BPRO, clear Log of BPRO using below method.

• Download Latest DB Analyzer:
• Goto DB Utilities > Clear Log 
• Click each database of Sanchay Post then click Update to Clear Log File.

Download DBA Latest Version

DB Tool For Clear Database Log

• Download DB tools from PoTools.
• Enter SQL Information.
• Clear all database Log for better performance

Download

SQL DATABASE ERROR : SUB ACCOUNT DAY BEGIN ERROR

Sub Account Day Begin Issues And Solution

While day begin into Subaccount it may show the error message like below due to corruption of tables in SQL databases.

Solution

• Running CHECKDB with REPAIR_ALLOW_DATA_LOSS will definitely be able to fix this issue - but to for this error it will simply delete the broken page. In this case, the page is a data page so will definitely lose data.

• If you have a backup, you should restore from it to avoid losing data.

SQL DATA BASE RECOVERY TOOL FOR POST OFFICE

DB Recovery Tool By Dinesh

A handy tool to recover your corrupt database using queries!

It helps you to recover you corrupt SQL database using queries mentioned in it. A backup is obviously preferred but if that doesn't work, this tool may help you! Click here to download it or click here for latest updates.

• Click Config Button to configure your Server details and restart the application. 
• Then select any of the Database listed below or check "None of Below DB" to enter database name manually. 
• First Check the status of database clicking Status and Check Button (using DBCC Check Command). 
• Then click Recover button to recover database. All the queries have been given in About form (Click About Link). 
• Various database status has been explained under "?" button and for SQL proficient User advance mode has also given if none of the other options in tools recover the database. 
• Write me back if you find it useful.

Download DB Recovery Tool

Download

Developed by Dinesh Kumar Asotra, System Manager Una

SQL SERVER QUERY ANALYZER FOR SQL 2005 / 2008

Following may be very simple to some and helpful to other type of question

SQL SERVER 2005/2008 Query Analyzer

SQL SERVER 2005 has combined Query Analyzer and Enterprise Manager into one Microsoft SQL SERVER Management Studio (MSSMS). To see the familiar Query Analyzer Window follow the image below.

MSDTC on server 'servername' is unavailable

By default, when a stand-alone instance of Microsoft SQL Server exists in a cluster environment, the SQL Server-based instance is set to start automatically. If the host node is rebooted, you may receive the following error message when you issue commands that are related to distributed transactions:

ERROR: MSDTC on server 'servername' is unavailable.

RESOLUTION On the server where the trigger resides, you need to turn the MSDTC service on. You can this by clicking START > SETTINGS > CONTROL PANEL > ADMINISTRATIVE TOOLS > SERVICES. Find the service called 'Distributed Transaction Coordinator' and RIGHT CLICK (on it and select) > Start. 

( or Change the Startup type into Automatic and Right Click and Restart the service )

To do this, type the following command at a command prompt, and then press ENTER:

net start msdtc

Verify that a message is displayed that indicates that the MSDTC service was started successfully.

SQL 2000 Installation Problem

A previous program installation created pending file operations on the installation machine. You must restart the computer before running setup.

You don't rally have to restart your machine - at least i did'n't have too! I have to close out all  my apps and reboot (are you listening Microsoft?) for a sample install like this. Are you getting this error message "A previous program installation created pending file operations on the installation machine. You must restart the computer before running setup."when attempting to install the SQL Server Enterprise Tools on your workstation? Hopefully this will help.

Exit the installer and then do this;

Click START, RUN type regedit
surf to following key:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager

Delete Pending  File Rename Operations
Start the install process again.
Souce:- if the above doesn't work, try the other items mentioned at the bottom of this Microsoft Support article.  

How to Repair a SQL Suspected Database

Sometimes when you connect to your database server, you may find it in suspect mode. Your database server won’t allow you to perform any operation on that database until the database is repaired.

A database can go in suspect mode for many reasons like improper shutdown of the database server, corruption of the database files etc.

To get the exact reason of a database going into suspect mode can be found using the following query

DBCC CHECKDB (‘YourDBname’) WITH NO_INFOMSGS, ALL_ERRORMSGS

Output of the above query will give the errors in the database.

To repair the database, run the following queries in Query Analyzer,

EXEC sp_resetstatus ‘yourDBname’;

ALTER DATABASE yourDBname SET EMERGENCY

DBCC checkdb(‘yourDBname’)

ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE

DBCC CheckDB (‘yourDBname’, REPAIR_ALLOW_DATA_LOSS)

ALTER DATABASE yourDBname SET MULTI_USER

     You should keep one thing in mind while using the above queries that the repair mode used here , REPAIR_ALLOW_DATA_LOSS, is a one way operation i.e. once the database is repaired all the actions performed by these queries can’t be undone. There is no way to go back to the previous state of the database. So as a precautionary step you should take backup of your database before executing above mentioned queries.

SQL 2008 Express Editions and Service Packs

Microsoft® SQL Server® 2008 Express with Advanced Services 

Microsoft® SQL Server® 2008 Express Edition Service Pack 1 

Microsoft SQL Server2008 R2 RTM - Express with Advanced Services 

Microsoft SQL Server 2008 SP2 Express Edition Service Pack 2 

SQL Server 2005 Backward Compatibility-1

SQL Server 2005 Backward Compatibility-2

(Click on the option for download page in Microsoft Site)

Error in Opening database - Tables ( SQL 2000)

Re-register the following DLLs by using Regsvr32.exe, and then restart the computer:

C:\Program files\Common Files\System\ADO\Msado15.dll
C:\Program files\Common Files\System\Ole Db\Oledb32.dll
C:\Program files\Common Files\System\Ole Db\Sqloledb.dll
C:\WINNT\System32\Atl.dll

Use Regsvr32.exe to register the preceding DLLs.

For example, at the command prompt type (or) copy & paste and Enter OK

C:\>regsvr32 C:\Program Files\Common Files\System\ADO\Msado15.dll
C:\>regsvr32 C:\Program Files\Common Files\System\Ole Db\Oledb32.dll
C:\>regsvr32 C:\Program files\Common Files\System\Ole Db\Sqloledb.dll
C:\>regsvr32 C:\WINNT\System32\Atl.dll

How To Change the Default Backup Path in SQL Server

When installing SQL Server you also set up the default backup folder, but how can this folder be changed later?
In SQL Server 2005 and before there is no built-in mechanism.
In SQL Server 2005 or before, this information is saved in the registry. So you need to change the registry. It will be saved in
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQLServer
In the above registry, the BackupDirectory string value is the place where the default backup directory is stored.

After changing this, you do not need to restart the SQL Server.
In SQL Server 2008 and onwards, there is an option to change this.
In SQL Server Management Studio, right click the server and select Facets,

Under the Server Facet, you can change BackupDirectory.