Knowledgebase
(16)Domains
(17)Getting Started
Downloads
(34)Mail
(7)SSL
(36)cPanel/WHM/Linux
(31)Pre-Sales Questions
(5)PHP
(45)WebsitePanel / Helm / Windows
(7)MySQL
(20)MSSQL
(20)General
(8)Connection/Site Viewing Issues
(39)ASP .NET / ASP
(33)Third Party Applications
(6)Billing
(3)PHP
(7)eNom
(24)Windows - Plesk
<?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...