Protect your Lenovo Server
Contact WhatsApp
Search Results – Bison Knowledgebase

🔍 Results for “Tick ERP SQL issue”

Fixing SQL Server Express Remote Connection Issues for Tick ERP Using Static TCP Port Configuration

Tick ERP and many similar accounting or ERP applications rely on Microsoft SQL Server Express as their backend database. A common real-world issue faced in LAN environments is that…

SQL Server Backup and Restore Using NoSky Cloud Backup Solution – Technical Knowledge Base

Databases are among the most critical assets in any IT environment. Microsoft SQL Server hosts transactional and operational data that must be protected against accidental deletion…

What Is SQL? Origin, Purpose, Benefits, and the Organizations Behind It

SQL (Structured Query Language) is the standard language used to store, retrieve, manage, and manipulate data in relational database systems. It is a foundational technology in IT,…

Fix Error 20599 “Cannot Open SQL Server” in VB6 / Crystal Reports Applications – Complete Troubleshooting Guide

The error “Error Number: 20599 – Cannot open SQL server” is a common issue in legacy business applications built using VB6, ODBC, and Crystal Reports. This error typically occurs w…

Fixing SQL Server “Incorrect Syntax Near ')'” Error in SQL Server Express 2019 (Step-by-Step Technical Guide)

SQL Server errors can be frustrating, especially when they occur inside applications using dynamic queries. One common error faced by developers and system administrators is:Error:…

Complete Technical Guide to Crystal Reports Runtime Requirements for SQL Express-Based ERP Systems

Modern ERP applications such as Tick ERP rely heavily on reporting engines to generate invoices, MIS reports, stock summaries, and financial documents. One of the most widely used …

Windows Server 2019 Security Hardening & Post-RDP Intrusion Remediation

This Knowledge Base article documents a real-world Windows Server 2019 security hardening and incident remediation scenario involving: An attempted RDP intrusion Partial Hy…

Resolving Tally Export Error 10061 in Tick Software (Crystal Reports + SQL Server via ODBC)

Many legacy business applications—especially those built on VB6, Crystal Reports, and SQL Server—integrate with Tally Prime for accounting automation. A common issue faced during t…

Fix: “Tally is not running. Error no: 10061” While Exporting Data from TICK Production ERP to Tally Prime

When exporting accounting or inventory data from TICK Production ERP to Tally Prime, users may encounter the error: “Tally is not running. Error no: 10061” This error typically a…

Microsoft Enterprise Software & Cloud Platforms – Overview of Microsoft Products and Services

Microsoft provides one of the most comprehensive enterprise software ecosystems globally, covering operating systems, productivity tools, cloud infrastructure, databases, ERP/CRM p…

How to Take SQL Data Backup of Busy Accounting Software

Article Summary This article explains the step-by-step process for taking an SQL data backup of Busy Accounting Software. It includes the prerequisites and best practices to ensure…

How to Take Backup of SQL Database in Hostinger – Complete Step-by-Step Guide (2025 Edition)

How to Take Backup of SQL Database in Hostinger – Complete Step-by-Step GuideBacking up your SQL database is one of the most important tasks for maintaining the security and stabil…

B2B ERP & CRM Software in India: Vendors, Registration Norms, Procurement Grounds, and GST/Compliance Claim Process (2026 Knowledge Base)

B2B software such as ERP (Enterprise Resource Planning) and CRM (Customer Relationship Management) is commonly purchased in India as: SaaS subscription (cloud, monthly/annual) …

Knowledge Base Articles Not Showing Publicly: Root Cause Analysis and Permanent Resolution

A common issue in custom Knowledge Base (KB) systems is a mismatch between articles visible in the database and articles displayed on the public KB pages. This typically occurs due…

Oracle Enterprise Databases, ERP & Cloud Platforms – Overview of Oracle Products and Services

Oracle is a leading provider of enterprise-grade database systems, ERP applications, and cloud platforms. Its solutions are widely deployed in mission-critical environments such as…

Can Tally Use Multiple ODBC Ports? Server vs Client Mode Explained with Practical Workarounds

In modern accounting integrations, many businesses rely on third-party applications such as CRM systems, reporting tools, and database-driven software to interact with TallyPrime u…

FocusLyte ERP & Accounting Software – Technical Knowledge Base Guide

FocusLyte is an integrated ERP and accounting solution developed by Focus Softnet Private Limited. It is designed to support financial accounting, inventory management, GST complia…

Meta Verified on WhatsApp Business: Complete Verification Guide

Meta Verified on WhatsApp Business is a verification mechanism provided by Meta for WhatsApp Business accounts. It confirms the authenticity of a business, helps customers identify…

Fix MySQL Error #1050: Table Already Exists – Causes, Solutions & Best Practices for Database Design

When working with MySQL databases, especially during development or deployment of applications like license management systems, you may encounter the error:#1050 - Table 'licenses'…

Complete Guide to Creating and Changing Financial Year in Marg ERP

Financial year management in Marg ERP is a crucial accounting process that ensures smooth transition of data, accurate reporting, and compliance with taxation systems like GST.Unli…

Windows Web Hosting: Architecture, Features, Use Cases, and Implementation Guide

Windows Web Hosting is a web hosting model where websites and web applications run on Microsoft Windows Server using Microsoft’s web and application stack. It is commonly used for …

Cygnet FACE – GST Compliance, Reconciliation & Automation Platform | Technical Knowledge Base

Cygnet FACE is an enterprise-grade GST compliance and reconciliation platform developed by Cygnet Infotech Private Limited. FACE (Fully Automated Compliance Engine) is designed to …

How to Recover Tally.ERP Company Data When You Forget Username and Password

Forgetting the username or password of your Tally.ERP company data can be stressful, especially when you have crucial business entries and financial data stored. Fortunately, there…

Complete Step-by-Step Guide to Restore an Old WordPress Website Backup on a New Hosting Server

Migrating your old WordPress website to a new hosting provider might seem challenging, but with the right steps, it’s easy and smooth. If you’ve already taken a full website backup…

Mobile Number Verification & WhatsApp Business API – Complete Guide

Meta Verified for WhatsApp Business is Meta’s official verification framework that confirms a business identity using a mobile number and business credentials. It is designed to im…

Automated Software Installation Control on Windows Server 2019 Using AppLocker, SRP, and PowerShell

In production server environments—especially accounting, ERP, database, and application servers—unauthorized software installation is one of the leading causes of malware infection…

Finance Software in India (Accounting & Payroll): Vendors, Registration Norms, Procurement, Compliance & Claim Guide

Finance software—specifically Accounting and Payroll systems—is essential for accurate financial management, statutory compliance, reporting, and payroll processing across Indian b…

How to Send Invoices from Tally Using Gmail – Step-by-Step Setup Guide

Sending invoices directly from Tally using Gmail helps you share bills quickly, professionally, and without any manual attachment work. Once Gmail and Tally are configured properly…

Overcoming Tally ODBC Single-Port Limitation: Multi-Instance Hack Using Tally Gold License

Integration with third-party applications using ODBC is a common requirement for businesses using TallyPrime. However, one of the most frequent technical limitations faced is:? Tal…

Understanding RAMMap: Report Decoding & Advanced Memory Analysis in Windows

Modern Windows systems manage memory dynamically using complex mechanisms like paging, caching, and compression. When performance issues arise—such as high RAM usage, slow applicat…

Understanding LST_XXX.dat Files in TallyPrime Data Folder: Structure, Purpose, and Best Practices

In TallyPrime, company data is not stored in a single database file like traditional SQL systems. Instead, Tally uses a proprietary file-based data architecture, where multiple fil…

GSTN-Empanelled Free Accounting & Billing Software - Complete Technical Guide to Government-Approved Solutions for Small Taxpayers

To support small taxpayers and MSMEs, the GST Network (GSTN) has empanelled selected Accounting and Billing Software solutions that are made available free of cost to eligible busi…

NIC Speed Lock & Continuous Monitoring on Windows Server (PowerShell Guide)

Network performance issues such as unexpected NIC speed fallback (1 Gbps → 100 Mbps) are common in enterprise and SMB environments. These issues often arise from cabling problems, …

Amazon Web Services (AWS): Detailed Technical Overview, Core Features, and Practical Examples

Amazon Web Services (AWS) is a comprehensive cloud computing platform that provides on-demand infrastructure, platforms, and managed services over the internet. Instead of buying a…

Best High-Commission Topics for Google Ads (High CPC Niches – India & Global)

In Google Ads, the term “best commission” generally refers to topics with high Cost-Per-Click (CPC) and strong advertiser competition. For publishers, bloggers, news portals, and …

How to Configure Dual Internet with a Load Balancer in an Office Network

Many offices today use two internet connections to ensure continuous connectivity and better speed. A load balancer such as the TP-Link TL-ER605 VPN Router allows both internet lin…

CaptainBiz GST Accounting & Compliance Software – Technical Knowledge Base Guide

CaptainBiz is a GST-focused accounting, invoicing, and compliance software developed by IRIS Business Services Limited. It is designed primarily for small and medium businesses (SM…

Virtual Private Server (VPS): What It Is, Benefits, Techniques & Why It Is Ideal for Tally / Busy on Cloud

A Virtual Private Server (VPS) is a smart hosting solution where a physical server is divided into multiple independent virtual machines. Each VPS gets its own dedicated resources …

Build Your Own Secure Live Stock Market Dashboard in PHP (India NSE/BSE Guide)

Build a Secure Live Stock Market Dashboard in PHP & MySQL Using API (India NSE/BSE, Futures & Options Tracking)IntroductionRetail traders and IT professionals often rely on…

Building a Secure PHP Admin Panel with Session Authentication, TinyMCE Editor, and Smart Slug Generation for a Content Management System

Building a lightweight custom Content Management System (CMS) in PHP is still a practical solution for many small websites, blogs, and digital publications. While large platforms l…

Smart Autocomplete Dropdown System for AMC Management Using PHP, MySQL and jQuery UI

Administrative systems like AMC (Annual Maintenance Contract) management often suffer from inconsistent data entry when users repeatedly type similar values such as service types o…

Google AppSheet: What It Is, Benefits, Techniques & How It Empowers No-Code App Development

Google AppSheet is a no-code application development platform that allows users to build powerful mobile and web apps without writing any programming code. It leverages data from G…

E-Way Bill Not Printing as Second Page with Tally Invoice – Technical Troubleshooting Guide

This Knowledge Base article provides a technical diagnostic and resolution framework for cases where an E-Way Bill (EWB) is generated successfully but does not print as a second pa…

Reversing an Old Service Invoice Using a Debit Note (India – GST & Accounting Guide)

In real-world business operations—especially in IT services, AMC contracts, and subscription-based services—it is common to encounter scenarios where an invoice raised earlier must…

Amazon Seller Fee Calculator (Excel & JSON) – India

Selling on Amazon India involves multiple fee components such as referral fees, closing fees, shipping charges, fulfillment fees, and GST.An Amazon Seller Fee Calculator helps sell…

Saral Accounts – Accounting & GST Software | Technical Knowledge Base Guide

Saral Accounts is a desktop-based accounting and GST-compliant business software developed by Relyon Softech Limited. It is designed for small and medium businesses (SMBs) to manag…

Complete Guide to Filling “Application-cum-Declaration as to Physical Fitness” for Driving License (India)

When applying for a Driving License in India through the Parivahan portal or offline RTO process, applicants must complete a mandatory Application-cum-Declaration as to Physical Fi…

How to Play a Video in Reverse Using Filmora (Easy Guide)

Sometimes you may want a video to play backwards—for fun effects, creative reels, or simple edits. Wondershare Filmora makes this easy, even if you’ve never edited a video before. …

Bulletin Board System (BBS) Services in the 1990s: History, Benefits, and Whether They Still Exist

In the 1990s, BBS services (Bulletin Board Systems) were a major part of the IT and “online” ecosystem—especially before the public internet became cheap and common. Users connecte…

How to Download Balance Sheet, Annual Return & ROC Documents of Any Company in India from MCA Portal – Step-by-Step Guide

In India, every registered company is required to file its statutory documents with the Ministry of Corporate Affairs (MCA).These filings include balance sheets, profit & loss …