RSS Feed
Knowledgebase : MSSQL Server
You receive an error when you Right Click on any table and choose "Edit Top 200 rows" Error - Invalid prefix or suffix characters. (MS Visual Database Tools) This is known issue with SQL Server 2008 R2 Management Studio while connecting to SQL Se...
To change the "sa" password, login to your computer using an administrator account. Open your SQL Server and log in using Windows Authentication. Open a new query window and type in the following command: SP_PASSWORD @NEW = 'new_password', @logina...
If you want to change the default settings to allow you to edit more than the 200 rows at a time, or select more than 1000 rows, which are the default settings for Microsoft SQL Server. To modify "Edit Top 200 Rows" or "Select Top 1000 Rows" settings d...
Once you have installed SQL Server Management Studio Express 2008 you can use this tool to connect to, and administer, your MS SQL database. Before you connect to your database you will need the following details. * Database IP address * ...
If the log file has grown do to being in full recovery mode then set it to simple before going any further. This should immediately stop the log from growing. ENTERPRISE MANAGER: Right click on the database, properties, Options, set model to simple, ...
TO BACK UP A TRANSACTION LOG 1. After connecting to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree. 2. Expand DATABASES, and, depending on the database, ei...
Often, when restoring a database from a remote machine on my local development machine, my user logins no longer work for that database. The problem lies with the fact that while the user name is the same from machine to machine, the underlying GUID th...
IF THE DATABASE ALREADY EXISTS AND YOU ONLY NEED TO RESTORE ITS CONTENTS: * Go to DOMAINS > DOMAIN NAME > Backup Manager > DATABASE BACKUP REPOSITORY, select the required backup file from the list and click RESTORE SELECTED. If you do not have t...
You can back up and subsequently restore the databases, database user accounts and data used by domains hosted on your server. You can: * Back up your domain databases with all data and user accounts * Restore databases from backup files * Do...
Windows 2008 server R2 x64, Plesk 9.x, SQL Server 2008 and R2, Framework 2.xx When you try to access ASP.NET Application the system shows you an error. _Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) _ _Description: An un...
After Upgrading to a diffrent version of DotNetNuke, you may get the following error _"Could not load RadEditor. Invalid tools file. Check provider settings in the web.config: ~/Providers/HtmlEditorProviders/Telerik/Config/ToolsDefault.xml"_ SOLU...
SYMPTOMS: When you trry to connect to database servers where you are not in full control over all databases, or where some of your databases are ever offline (or auto-closed), the new version of Management Studio that is shipping with SQL Server 200...
If you have a Dedicated or Virtual Server with DNN4Less, Login to your server using (RDP) Remote Desktop Protocol. * Click on Start * Click Run. * Type "Services.msc", press Enter. * Look for "SQL Full-text Filter Daemon Launcher". * Right...
If the log file has grown do to being in full recovery mode then set it to simple before going any further. This should immediately stop the log from growing. ENTERPRISE MANAGER: Right click on the database, properties, Options, set model to si...
Before this make sure there are free entries by setting the recovery model to simple or backing up the log. ENTERPRISE MANAGER: Right click on the database, All tasks, Shrink database, Files, Select log file, Click OK. T-SQL dbcc shrin...
The default instance of the Database Engine listens on port 1433; therefore, you do not have to configure a fixed port. However, named instances including SQL Server 2005 Express Edition listen on dynamic ports. Before you can open a port in the firewa...
Following code always shrinks the Truncated Log File to minimum size possible. Use one of the following two procedures. PROCEDURE 1 USE DatabaseName GO DBCC SHRINKFILE(, 1) BACKUP LOG WITH TRUNCATE_ONLY DBCC SHRINKFILE(, 1) GO PROCEDURE...
Connection to a named instance of SQL server 2005/2008 should be made using the format 'VirtualServer\Instancename'. if the IP address of a machine running a named SQL server instance (ONE)is 192.141.128.140, you can connect to the named instance using...
Check your web.config file for the following: connectionString="Data Source=.\\SQLSERVER;Initial Catalog=Northwind_db_;Integrated Security=True" The problem is "Data Source=.\\SQLSERVER;" - It's the double \\. That's an escape sequence in C#. Swi...
The following article explains how to backup your MS SQL Server 2005/2008/2008 R2 database using Micsrosoft SQL Server Management Studio. The backup can then be used at a later date to restore the database if information is lost. The backup file needs ...
If you get the following error, while trying to access MS-SQL server, "Error: Test connection to the database server has failed because of network problems: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied." Follo...
You receive an error when you restore a SQL Server database from a Database Backup file (databasename.bak). _System.Data.SqlClient.SqlError: The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateT...
Error: _DotNetNuke.Services.Exceptions.ModuleLoadException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. _ ERROR DETAIL: Error: UsersOnline is currently unavailable. DotNetNuke.Services.Excepti...
When you access your MSSQL database through MSSQL Server Eeterprise Manager from Parallels Plesk Control Panel or a web browser you get following error. _"405 - HTTP verb used to access this page is not allowed._ _The page you are looking for cannot...
As the error says the particular login is Disabled. Thus, we need to enable the user. Follow these steps to enable the user. * Go to start -> programs. * Open Sql server management studio * Login to the SQL server (using windows authentication). ...
You are attempting to install the SQL Server 2008 R2 instance when you receive the following error message: _"Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes." _ This error can occur if a Micros...
When you try to perform MSSQL Database backup in DNN4Less Control Panel you receive the following error: _Error: Cannot open user default database. Login failed. Login failed for user 'xxxxxxxxxxxxx'._ _Source: .Net SqlClient Data Provider_ SOLU...
* Run SQL Server Configuration Manager. * Go to SQL Server Network Configuration > Protocols for SQLEXPRESS. * Make sure TCP/IP is enabled. Extra Steps: * Right-click on TCP/IP and select PROPERTIES. * Verify that, under IP2, the IP Addres...