Category: DataBase

Use the Instance Name page of the SQL Server Installation Wizard to specify whether to create a default instance or a named instance of SQL Server. A default instance name is used unless you choose a named instance. Each SQL Server instance is made up of a distinct set of services with specific settings for collations and other options. The directory structure, registry structure, and service names all reflect the specific instance ID of the SQL Server instance created during SQL Server Setup. An instance is either the default instance or a named instance. The default instance name is MSSQLSERVER; […]

Scenario: When you copy a SQL DB (detach from the source server and attach on the destination server) between SQL servers running under same instances, you’ll see the SQL user login on the attached server fails with below error: The server principal “<username>” is not able to access the database “<SQL_DB>” under the current security context. Any application that attempting to connect to the DB will report the Login error as shown below:   —————————Login failed. Check the log file for details.—————————Login Error—————————OK   —————————   Additionally when you try to connect to Database via ODBC manager, it as well reports […]

  A formatted code is available at SQL Script to list all DBs Sizes in MBs.