MSSQL Server - MSSQL Server - Knowledgebase - AccuWebHosting

10 Articles MSSQL Video Tutorials

This video tutorial catagory include videos about MSSQL related guides and tips.

Articles

Can I connect to MSSQL server on two machines with the same user? Yes, you can. But in that case, you will need to have both your PC on different network. It won't... Can I create unlimited MS SQL databases with unlimited database size? Shared/Reseller Hosting: In Windows Shared/ Windows Reseller hosting you can create MS SQL... Choosing Between SQL Server 2012 and SQL Server 2014 If you are running SQL Server 2008 R2, you might be looking to upgrade your SQL server to... Comparison of MS SQL Server 2008 V/s. MS SQL Server 2012 Following is a feature comparison between MS SQL Server 2008 and MS SQL Server 2012. We don't... Comparison of MS SQL Server 2014 Express Edition V/s. MS SQL Server 2014 Web Edition Following is a brief comparison between MSSQL Server 2014 Express Edition and MSSQL Server 2014... Comparison of MS SQL Server 2016 Express Edition V/S. MS SQL Server 2016 Web Edition Following is a brief comparison between MSSQL Server 2016 Express Edition and MSSQL Server 2016... Do you offer SQL schedule job? Windows Shared HostingWe do not offer SQL server schedule job in our Windows shared hosting... Fix - Microsoft SQL Server, error: 10053 - An established connection was aborted by the software in your host machine One of our Windows VPS customers received following error while connecting to MS SQL server.... Fix : Server Unable to load user-specified certificate. The server will not accept a connection You may encounter this error when you attempt to start the MSSQL service. This error occurs when... Fix :: Reporting Service Error After Upgrade From MS SQL server from 2008 to 2012 Error Message Throwing Microsoft.ReportingServices.Diagnostics.Utilities.... How do I close active connections in MSSQL Server? Please refer to the following steps to close active connections in the MS SQL server. Open the... How do I connect to MSSQL Server 2008 from SQL Server Management Studio? This article will guide you on how to connect to MS SQL Server 2008 from SQL Server Management... How do I connect to MSSQL Server 2012 from SQL Server Management Studio? This article will guide you on how to connect to MS SQL Server 2012 from SQL Server Management... How do I place my database on your server? Will my primary keys, stored procedures and constraints be preserved or destroyed? All you have to do is to take a full backup of your database on your local machine and place a... How to Backup MSSQL Database from SQL Server Management Studio? To take MS SQL database backup, first you need to connect to MS SQL Server through SQL Server... How to Change MS SQL Database Recovery Model? This article describes how to to change recovery model of a MS SQL database through SQL Server... How to Create MS SQL Database Through SQL Server Management Studio? This article will assist you to create MS SQL database through SQL Server Management Studio.... How to Fix Error "Could not allocate space for object 'X' in database"? Error Message Could not allocate space for object 'dbo.ABC_XYZ_XYZ'.'AB__ABC_XYZ__XYZ' in... How to Increase the MS SQL Remote Query Timeout? MS SQL Server has an option called Remote Query Timeout to specify the time (in seconds), a... How to Install Advanced Features on Existing Instance of MS SQL Server? If you have chosen MS SQL Server to be installed in Windows VPS while placing an order, you'll... How to Restore SQL Server 2012 Database Backup to SQL Server 2008? Ideally, there is no way you can restore MS SQL Server 2012 database to SQL Server 2008 even if... How to Shrink Transaction Logs of Database in MS SQL? This article will assist you to shrink/truncate the transaction logs of database in MS SQL... How to Verify MSSQL Server Edition? Please refer to the following steps to verify the exact MSSQL edition. We have prepared these... How to add db_owner role to newly created users? From Plesk version 12, MSSSQL users created from the Plesk panel will not have the db_owner... How to assign particular permissions to SQL server database user from SQL Server Management Studio? We can restrict SQL database users to fire some critical queries, e.g. Update, Delete, etc.... How to change Database Collation in MsSQL Server? Collation is a configuration level setting in the MSSQL. It directs how the character data will... How to change Database User's schema to DBO in MSSQL. Login to SQL Server with Database User Credential. Right Click on Database and select New... How to change database language in MS SQL 2012 server? Following article will guide you to change database language in MS SQL 2012 server. Login to... How to change password for MS SQL admin user? Following tutorial will guide you to reset the MS SQL server sa user password. We assume that you... How to change port for MSSQL Server 2008? In Windows VPS, 1533 is the default port for MSSQL Server. Following steps will guide you to... How to change user access mode in MSSQL Server? MSSQL Server provides a feature to restrict your Database access for users. It can be performed... How to check active connections on your MS-SQL Database ? To check active database connection in the MS SQL server please follow the below steps. Open... How to configure MSSQL server default language configuration option? Recently, we faced strange issue wherein one of our customers was capturing error messages coming... How to create a Database in MSSQL Server? If you have a Windows VPS / Dedicated server with MSSQL Server and WebsitePanel installed, you... How to create a user and assign permission from SSMS? Login into the SSMS with the respective user Go to the Object Explorer section and click on... How to create login, user, role and Assign permission from SSMS? In this article, we will guide you on how to create login, user, role, and assign permission from... How to create or export BACPAC file using SSMS? BACPAC (Backup package) contains schema and data for SQL Server database. We can export the... How to disable/prevent remote access of MSSQL database server? How to enable MS SQL server access in php? The Microsoft Drivers for PHP are the PHP extensions that allows for reading and writing of SQL... How to fix "Upgrade Error - Valid Database compatibility level and successful connection rule"? One of our Windows VPS customers wanted to upgrade SQL Server from SQL Server 2008 R2 to SQL... How to fix an error "change password failed for login sa"? Sometimes you receive following error while trying to reset MS SQL sa password via SQL Management... How to fix “Reporting Services Catalog Database File Existence” error while installing SQL Server? You may receive the below error while installing the SQL server on your windows system. This... How to identify and fix the orphan users in MSSQL Server? Orphaned user in MSSQL means that a user who is present at the database level but the relevant... How to import or restore BACPAC file from SSMS? BACPAC (Backup package) contains schema and data for SQL Server database. We can export the... How to install MS SQL Server 2016? Microsoft® SQL Server® 2016 is the latest version of Microsoft's relational database management... How to install SQL Server Reporting Service (SSRS) on MSSQL 2014 Express Edition? SQL Server Reporting Services is used for creating, publishing, and managing reports, and... How to resolve ODBC error 80004005? ODBC(Open Database connectivity) is used to create dynamic web apps. Sometimes these apps fail... How to restore MSSQL database from SQL Server Management Studio? This article will guide you on how to restore MSSQL database from SQL Server Management Studio.... How to set database size limit on MSSQL Server? Please refer to the following steps to set the database size limit for Microsoft SQL Server.... How to setup MSSQL database mirroring? Following are the steps to set up database mirroring using certificate-based authentication. You... How to shrink MSSQL Database? Important Note: We don't recommend to shrink your database. You can involve your Database... How to take MSSQL database offline or bring it online? Sometimes, you come across to a situations when you are required to physically move the database... How to upgrade SQL Enterprise Evaluation edition to SQL Developer edition? If you have installed the MSSQL Evaluation edition, you can easily upgrade it to the Developer... How to use MSSQL Activity Monitor to find the most expensive query? A slow and long running SQL query execution consumes much processor, memory, and disk of your... Is there any limitation in Table Numbers in Microsoft SQL Server database? Depending on SQL server edition and environment, there will be limitation. Please refer to the... MS Access :: Do you have sample connection strings for DSN Less Connection and DSN Based Connection? MS-Access Database Connection ASP code: DSN Less Connection: Dim strConnSet strConn =... Microsoft OLE DB Provider for ODBC Drivers error '80040e10' [Microsoft][ODBC Microsoft Access 97 Driver] Too few parameters. Expected 1 This error occurs because the field name that you used in the query syntax does not exist. Often... Microsoft SQL Server 2012 Recommendation Microsoft SQL Server 2012 Express is a feature-rich yet FREE data management system. It is far... Microsoft SQL Server 2014 Recommendation The SQL Server 2014 Express is yet another feature-rich data management system from Microsoft.... Microsoft SQL Server 2016 Recommendation The SQL Server 2016 Express is the latest data management system from the Microsoft. Like the... Operation must use an updateable query Microsoft OLE DB Provider for ODBC Drivers error '80004005' .[Microsoft] [ODBC Microsoft Access Driver] This error usually occurs when you try to insert or update data in MS Access database i.e. you do... The server principal “username” is not able to access the database “databasename” under the current security context. (Microsoft SQL Server, Error: 916) We may receive following error when login to our database from SQL Server Management Studio (2008... Unable to launch SQL Server Configuration Manager – Invalid class [0x80041010] You may receive the below image while you access the server configuration manager on your windows... What is the database connection string for my website? It is recommended that you take the help of your web developer to define the database connection... Where is the database folder for MS-Access database? 'db' folder created along with the 'www' or 'wwwroot' folder is the recommended folder for .mdb... vs shell installation has failed with exit code 1638. You may receive the following error while installing MSSQL 2017 on Windows 2012 R2 Server VPS or...