Knowledgebase: MSSQL
|
Connecting to Microsoft SQL Server 2008 R2 Express via EMS SQL Manager for SQL Server
Posted by Abner Myloth on 23 July 2010 11:53 PM
|
|
|
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 "Microsoft ® SQL Server ® 2008 R2 Native Client" to download this link http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=ceb4346f-657f-4d28-83f5-aae0c5c83d52 The Microsoft® SQL Server® 2008 R2 Feature Pack is a collection of stand-alone packages which provide additional value for Microsoft® SQL Server® 2008 R2. Microsoft SQL Server 2008 R2 Native Client (SQL Server Native Client) is a single dynamic-link library (DLL) containing both the SQL OLE DB provider and SQL ODBC driver. It contains run-time support for applications using native-code APIs (ODBC, OLE DB and ADO) to connect to Microsoft SQL Server 2000, 2005, or 2008. SQL Server Native Client should be used to create new applications or enhance existing applications that need to take advantage of new SQL Server 2008 R2 features. This redistributable installer for SQL Server Native Client installs the client components needed during run time to take advantage of new SQL Server 2008 R2 features, and optionally installs the header files needed to develop an application that uses the SQL Server Native Client API. | |
 (47 vote(s)) Helpful Not helpful |
Comments (17)
Ken Brocx
26 November 2010 10:03 PM
Info should be posted on how to connect to a sql server on arvixe.com.
Arvand Sabetian
27 November 2010 01:26 AM
http://blog.arvixe.com/how-to-use-microsoft-sql-server-2008-to-connect-to-your-database/ can be used to learn how to connect to the sql server using mssql management studio.
Clark Kurtz
08 December 2010 01:28 PM
Is there a knowledgebase article that gives the steps to port my local SQLExress database to your server? I have created a database on the stie using the control panel, and think I have the connection string ok. But how do I actually get the aspnetdb.mdf database file that is on my local computer up to the website and attached to MyDatabaseName there?
I have actually ftp'd it to the App_data folder on the website but that isnt enough --
I have actually ftp'd it to the App_data folder on the website but that isnt enough --
Henry Sphinct
07 January 2011 11:42 AM
I'm also trying to upload my DB over to arvixe. Seems like there's no straight forward way to do this... would like to just use the SQL Publishing wizard in VS2010 to do this, but no info on the knowledge base on what web service address to use, what account criteria to use... does anyone else know how to do this?
Arvand Sabetian
10 January 2011 09:23 PM
The most straight forward way is creating a .bak file and restoring it through the control panel. Usually a web service address is required for web deploy and its just your domain.com . But for the credentials, you'd use the ones you set for Remote Management inside the control panel. You'll also need to supply your database name, username and password credentials at some point.
Wilson Lim
18 January 2011 06:36 PM
if i have a database named mydb in MS sqlserver 2005 in my local server, and the backup name is mydb.bak, can i restore to MS sqlserver 2008 in the website through the control panel.
Arvand Sabetian
31 January 2011 01:38 AM
Yes.
Loc Pham
08 March 2011 07:00 PM
Restoring .bak file via Control Panel had given me errors all the time. I used both methods to restore the files: From "Uploaded File" and from "Hosting Space File". The first method gave me connection reset error. The later did not yield any error, but the database restore was incomplete; only partial of the data was restored; some stored procedure were not there either. I had to submit a help ticket and ask the support tech to restore the .bak file...
Arvand Sabetian
11 March 2011 03:26 AM
Depending on the complexity of the database, it may be possible that the restore fails. In any case, we would be more than happy to restore the .bak manually for you and in many cases, SSMS may identify the error that was causing issues for the control panel .bak restore as well.
Chris Calenda
17 March 2011 01:43 PM
I have identical issues regarding errors during backup restore via the Control Panel. I attempted to do it via SSMS and EMS SQL, but I don't believe my account has permissions. Is there a way to grant permissions to my user account to make backups/restores to my own database? I consistently need to make changes to my database, and it's not really feasible to have to put in a help desk ticket every time a restore is necessary.
Arvand Sabetian
20 March 2011 01:13 PM
Unfortunately, the only way to do a restore of your databases is through the control panel. This is a limitation that we have to enforce on our shared accounts. On a VPS or a Dedicated server, you will have the ability to set your own permissions if you'd like.
alan
24 March 2011 12:31 AM
i found out that i can not directly amend my MSsql database inside my CP,
if i really need how do i go about?
remark : if in godaddy.com CP i can do it.
if i really need how do i go about?
remark : if in godaddy.com CP i can do it.
Arvand Sabetian
31 March 2011 01:39 AM
I'm not sure what you mean. You can restore your .bak file through the control panel under the databases section.
jk
18 May 2011 08:56 PM
So how to open or connect MS SQL Server 2008 using EMS SQL Manager 2010?
Thanks.
Thanks.
Arvand Sabetian
02 June 2011 11:16 PM
http://blog.arvixe.com/using-ems-sql-server-manager-to-manage-your-arvixe-databases/
Michael Stalker
14 March 2012 10:32 PM
I need to open a ODBC connect to my database from a PERL script on my website and I can not connect. Can any one help?
Here is a sample of my connection call:
use DBI;
use DBI::ODBC;
sub Output_Data
{
my $user = "username";
my $pass = "password";
my $db = "database name";
my $server = "dodder.arvixe.com\\SQLEXPRESS";
my $DSN = "DBI:ODBC:Driver={SQL Server};Server=".$server.";Database=".$db;
my $dbh = DBI->connect($DSN,$user,$pass)
Here is the error I am getting:
DBI connect('Driver={SQL Server};Server=dodder.arvixe.com\SQLEXPRESS;Database=database name','username',...) failed: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. (SQL-08001) [state was 08001 now 01000]
Here is a sample of my connection call:
use DBI;
use DBI::ODBC;
sub Output_Data
{
my $user = "username";
my $pass = "password";
my $db = "database name";
my $server = "dodder.arvixe.com\\SQLEXPRESS";
my $DSN = "DBI:ODBC:Driver={SQL Server};Server=".$server.";Database=".$db;
my $dbh = DBI->connect($DSN,$user,$pass)
Here is the error I am getting:
DBI connect('Driver={SQL Server};Server=dodder.arvixe.com\SQLEXPRESS;Database=database name','username',...) failed: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. (SQL-08001) [state was 08001 now 01000]
Arvand Sabetian
16 March 2012 04:58 PM
I would try without the 2 slashes after dodder. I would also try with just 'localhost' as the server or 'localhost\SQLEXPRESS'. It is also a possibility that the username and password are incorrect. So make sure to test those remotely using SQL Server Management Studio.