Articles
Configure SQL Server Express to allow remote tcp/ip connections on port 1433?
Configure SQL Server Express to allow remote tcp/ip connections on port 1433?
Run SQL Server...
Configure SQL Server to listen on a specific port
Configure SQL Server to listen on a specific port
The default instance of the Database Engine...
Error - Invalid prefix or suffix characters. (MSSQL Server)
Error - Invalid prefix or suffix characters. (MSSQL Server)
You receive an error when you...
Error - Invalid prefix or suffix characters. (MSSQL Server)
Error - Invalid prefix or suffix characters. (MSSQL Server)
You receive an error when you...
Error 916 When Connecting SQL Server Management Studio To SQL Server
Error 916 When Connecting SQL Server Management Studio To SQL Server
SYMPTOMS:
When you trry...
Error: "Wait on the Database Engine recovery handle failed..." When Attempting to Install Microsoft® SQL Server® 2008 R2
Error: "Wait on the Database Engine recovery handle failed..." When Attempting to Install...
Error: Cannot open user default database. Login failed.
Error: Cannot open user default database. Login failed.
When you try to perform MSSQL Database...
Export a MySQL Database in phpMyAdmin
Export a MySQL Database in phpMyAdmin
This article goes over exporting a database in...
How can I connect to my Database using SQL Server Management Studio Express ?
How can I connect to my Database using SQL Server Management Studio Express
Once...
How can I shrink the transaction log file (.ldf)
How can I shrink the transaction log file (.ldf)
Before this make sure there are free entries by...
How can I stop the transaction log file (.ldf) from growing
How can I stop the transaction log file (.ldf) from growing
If the log file has grown do to...
How do I backup my MS SQL Server database using Management Studio?
How do I backup my MS SQL Server database using Management Studio?
The following article...
How to Back Up a Transaction Log in MS SQL Server Management Studio
How to Back Up a Transaction Log in MS SQL Server Management Studio
To back up a transaction...
How to Backup and Restore MySQL Databases
How to Backup and Restore MySQL Databases
How to Export or Backup or Dump A MySQL Database...
How to Edit More than 200 Rows in SQL Server Management Studio
How to Edit More than 200 Rows in SQL Server Management Studio
If you want to change the...
How to change SQL Server “sa” password?
How to change SQL Server “sa” password?
To change the “sa” password, login to your computer...
How to enable MSSQL Server Full-Text Indexing services
How to enable MSSQL Server Full-Text Indexing services
If you have a Dedicated or Virtual...
Import MySQL dump file from phpMyAdmin
Import MySQL dump file from phpMyAdmin
You can import your backup .sql files through...
Instance Failure MSSQL Server in C# ASP.NET - DotNetNuke
Instance Failure MSSQL Server in C# ASP.NET - DotNetNuke
Check your web.config file for the...
Login failed for user 'sa'. Reason: The account is disabled. SQL Server
Login failed for user 'sa'. Reason: The account is disabled. SQL Server
As the error says the...
Recovering Orphaned Database Users
Recovering Orphaned Database Users
Often, when restoring a database from a remote machine on...
Restore failed for Server 'server\sqlexpress'. (Microsoft.SqlServer.Express.Smo)
Restore failed for Server 'server\sqlexpress'. (Microsoft.SqlServer.Express.Smo)
You receive...
SQL Server Database connection error with modules
SQL Server Database connection error with modules...
Shrinking Truncate SQL SERVER Log File
Shrinking Truncate SQL SERVER Log File
Following code always shrinks the Truncated Log File to...
WebAdmin: 405 - HTTP verb used to access this page is not allowed.
WebAdmin: 405 - HTTP verb used to access this page is not allowed.
When you access your MSSQL...
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
If you get...
