RSS Feed
Knowledgebase : MSSQL
<?php //Code for connection on Arvixe $myServer = "localhost\SQLEXPRESS"; $myUser = "Database User Name"; // replace with your values $myPass = "Database Password"; // replace with your values $myDB = "Database Name&q...
EMS SQL Manager for SQL Server is a high performance tool for Microsoft SQL Server database development and administration. It can be used as an alternative to Microsoft SQL Server Management Studio. # Make sure you have installed "Microso...
Yes. We do allow remote access to the MSSQL. It is offered on the regular port 1433.
Yes. Please use the following connection string and fill in the necessary spots with your database's information: In some instances, the "Data Source" will need to have the Instance Name after it(sqlexpress), such as this: DBNAME is what you specif...
If, when opening Microsoft SQL Server Management Studio, you receive the following error: The server principal <username> is not able to access the database <databasename> under the current security context. (Microsoft SQL Server, Error: 916)T...
For users using Visual Studio 2005 with an SQL 2008 database, you may run into the following error: This server version is not supported. Only servers up to Microsoft SQL Server 2005 are supported. If you have a specific need Visual Studio 2005 which...
Yes. The MSSQL server is 2008 however since Helm's theme/skin does not offer a way to add MSSQL 2008, the server will show as MSSQL 2005. Please use MSSQL 2008 tools when connecting or you will receive an error.
To connect to your MSSQL database remotely, please use a client that is capable of communicating with our MSSQL 2008 server on the TCP protocol. A free client is provided by Microsoft at: http://www.microsoft.com/downloads/details.aspx?FamilyID=08e52ac2...
Please use the following connection string on our Windows 2008 servers to connect to the local MSSQL service: "Provider=SQLOLEDB;Data Source=myServerAddress;UID=myUsername; PWD=myPassword; database=myDataBase;"   Another method is to use a driver l...
Upon assisting a customer with this, the following connection string worked fine on a Windows 7, Visual Fox Pro 9.0 setup -   DRIVER=SQL Server Native Client 10.0;SERVER=SERVER.arvixe.com;UID=myuserid;PWD=mypassword;APP=Microsoft Visual FoxPro;DATABA...
In Plesk, first we create a database, and then we create a user to access that database. Both steps are outlined below: * Step 1: Create a Database * Step 2: Create a Database User STEP 1: CREATE DATABASE To create a new database in Plesk: * Cl...
95% of our servers already come with Full-Text search capabilities. If you receive an error from the below commands, please contact support to have it enabled on your server. You may use the article available at http://msdn.microsoft.com/en-us/library/...
If you are receiving the following error: System.Data.SqlClient.SqlException: Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on...
When managing a database on a Plesk control panel, how you connect will depend on the type of database you are using. If you are using an MSSQL database, you'll need to use software to manage your database remotely, however, if you use MySQL you will be a...
You will first need access to a report server which we can setup for free for BusinessClass ASP customers and can be purchased at $5.00 per month by PersonalClass ASP customers. Once you have the access setup and sent to you, to deploy a report using t...
As most Arvixe SQL Servers run SQL Server R2 2008, if you maintain your own database and often restore your backup to your own database for development purposes, you'll need to make sure that your version is also up to date. You may use the following l...
Are you getting this error when you try to change any of the information in your database? Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table t...
As of April 5th, 2012, the instance name of the MSSQL 2008 server depends on the server you are on. The majority of our clients setup previous to this date on any of our Windows accounts will be on an instance called "SQLEXPRESS". Most new customers will ...
Our latest Windows 2012 servers run Microsoft SQL 2012 Web Edition.
A detailed blog post (With screen captures) was created by us for you, here [http://blog.arvixe.com/how-to-fix-the-the-server-principal-is-not-able-to-access-the-database-error-in-microsoft-sql-server-management-studio/]. The error you are getting is a b...