|
||
|
|
||
 |
If you use the Enterprise Manager wizard to Export your database and you select "Copy Object and Data between SQL Server databases", the wizard will fail because you do not have Alter Database permission. Alter database can become a security issue by customers using it to cause instability in the SQL server, other hosting companies allow it and run that risk but we do not, we provide you with these role permissions ( db_securityadmin, db_ddladmin, db_backupoperator, db_datareader and db_datawrite ) with these roles you are able to perform the most common SQL tasks.
Now, the question is how can i transfer my database to TJ-Hosting SQL Server? TJ-Hosting recommends the following option:
Generate an SQL Script of your local SQL database using Enterprise Manager, then run the transact-sql script using SQL Query Analyzer or use the Web-Based SQL manager (https://sqladmin.merchantsecure.com ) against ISQsolutions.com SQL server, now that you have created the structure of your SQL database in TJ-Hosting SQL server you are ready to use the Enterprise Manager wizard to export your data to the server-side.
Be sure to select "Copy table(s) and view(s) from the source database" this way you will avoid the alter database error and you are done.
TJ-Hosting would like to provide db_owner to avoid support, but we believe it is more important to minimize the risks related to SQL server and providing db_owner.
We support MySQL, Microsoft SQL 2000 Server and MS Access directly. Please contact us if you want to check a specific format.
The maximum connection is set to 50 per user. This limit is set as a safety net limit, not a recommended or guaranteed level of service.
If your application requires more connections, we recommend you to change the application to use persistent connections or pooled database connections, consult the proper documentation of the technology you use to develop the application.
TJ-Hosting policy requires us to close port 1433 of MS SQL Server to inbound connections from outside of our network.
To connect to the MS SQL 2000 Server through enterprise manager, please follow these steps:
- Open SQL Server Client Network Utility
- Click 'Alias'
- Click 'Add'
- In Network Library select 'TCP/IP'
- server Alias type the desire name. (ISQ-SQL)
- server name type the host address of the SQL server listed in the hosting manager under databases main tab
- Un-check Dynamically determine port and then type 3434 as port.
- click 'OK', click 'Apply', Click 'OK'.
Now open the SQL Enterprise Manager
- right click 'SQL Server Group' and select 'New SQL Server registration'
- click 'Next'
- select the alias server listed and click 'Add'
- select SQL login and complete the wizard.
* Be aware that this policy only affect inbound connections from outside of our network, your application web can connect to the SQL server through the standard port (1433).
TJ-Hosting policy requires us to close port 1433 of MS SQL Server to inbound connections from outside of our network.
To connect to the MS SQL 2005 Server through SQL Server Management Studio, please follow these steps:
- Open SQL Server Management Studio
- click 'File' and select 'Connect Object Explorer'
Server type: Database Engine
Server Name: sql2k5-001.isqsolutions.com,3434
Authentication: SQL Server Authentication
Login: Username of the SQL database
Password: the username password
* Be aware that this policy only affect inbound connections from outside of our network, your application web can connect to the SQL server through the standard port (1433).
* For information about SQL Server Management Studio check related articles in this post.
We assume that the ms access database in located in the database folder outside of your web root directory, which is recommend for security reasons.
<%
*** Phisycal path of your web root folder
rootPath = Server.MapPath("/")
dbPath = Replace(rootPath, "\www", "\database")
dbPath = dbPath & "\filename.mdb"
connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & Cstr( dbPath ) & ";"
set Conn=Server.CreateObject("ADODB.Connection")
Conn.open connectionString,"",""
Conn.close
%>
These examples may not work for you without certain modifications.
The purpose of the examples is to give you a general idea on the topic.
<%
Set cn = CreateObject("ADODB.Connection")
cn.Provider = "sqloledb"
cn.Properties("Data Source").Value = "sql1.isqsolutions.com"
cn.Properties("Initial Catalog").Value = "dbname"
cn.Properties("User ID").Value = "dbusername"
cn.Properties("Password").Value = "password"
cn.Open()
cn.close
%>
These examples may not work for you without certain modifications.
The purpose of the examples is to give you a general idea on the topic.
<%
dbName = "dbName"
mysqlServer = "mysql101.isqsolutions.com"
mysqlUsername = "dbUsername"
mysqlPassword = "password"
MySQLConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" &_
"server=" & mysqlServer & ";" &_
"user=" & mysqlUsername & ";" &_
"password=" & mysqlPassword & ";" &_
"database="& dbName &";"
Set MySQLConn = CreateObject("ADODB.Connection")
MySQLConn.ConnectionString = MySQLConnectionString
MySQLConn.Open
%>
These examples may not work for you without certain modifications.
The purpose of the examples is to give you a general idea on the topic.
We assume that the ms access database in located in the database folder outside of your web root directory, which is recommended for security reasons.
<code>
string databaseName = "YourDatabaseName.mdb"
string pathDB = Server.MapPath("/") + @"..\database\" + databaseName;
string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
strConnection += @"Data Source=" + pathDB;
OleDbConnection objConnection;
objConnection = new OleDbConnection(strConnection);
</code>
These examples may not work for you without certain modifications.
The purpose of the examples is to give you a general idea on the topic.
The following code example demonstrates how to create and open a connection to a SQL Server (version 7.0 or later) database.
[Visual Basic]
Dim nwindConn As SqlConnection = New SqlConnection("database=yourDBname;server=sql1.isqsolutions.com;" & _
"User Id=yourDBusername;Password=correctPassword")
nwindConn.Open()
[C#]
SqlConnection nwindConn = new SqlConnection("database=yourDBname;server=sql1.isqsolutions.com;" +
"User Id=yourDBusername;Password=correctPassword;"); nwindConn.Open();
[connectionString key]
These examples may not work for you without certain modifications.
The purpose of the examples is to give you a general idea on the topic.
807-966 Inverhouse Dr., Mississauga-ON, L5J4B6 - contact@tj-hosting.com
Phone: 905-919-9949 - Fax: 905-823-5895 - Toll-Free: 1-866-818-3162
© 2004-2007 TJ-Hosting - All Rights Reserved.