Category: DataBase

Many applications that communicate to the SQL DB located on a remote SQL server will at times report an unexpected error ‘Login failed for user ‘<domainname><computername>$’’. Analysis: The error usually indicates logon failure for the reported user account for the specified DB on the respective server. Usually there should be a SQL/Domain user id that may attempt to login, but if it’s a computer name instead then that indicates probably System account or ASP.Net accounts attempts for that login. Possible Cause: The most possible case I noticed is that application get configured to use “Built-in ASP.Net” account. Possible Fix: Make […]

Creating or Installing SQL named Instance in SQL Server 2008 Launch the “Microsoft SQL Server 2008” Installer setup.exe and follow the steps in below screens: Choose “Installation” section   Choose “new SQL Server stand-alone installation or add features to an existing installation” option Choose to run the setup.exe Click ‘OK’ on Support Rules Setup upon successful status Click “Install” for “Setup Support Files” Click ‘next’   Select “Perform a new installation of SQL Server 2008” and click Next Provide the product key and click Next Accept the license and click “next” Select the “Database Engine Services” for the instance creation […]

A single SQL Anywhere database engine can manage access to several databases simultaneously. You can start and stop databases from database administration tools or client applications, and you may connect to any of the currently running databases on a database engine. Which is similar to MS SQL Server running a DB instance. Under each DB instance you have have ‘N’ number of DB attached and running. When a database server or engine is started, it is assigned a server name or engine name . The server or engine name is entirely distinct from the name of the database engine program […]