[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Using the SQL Server 2005 database an my ISP

Posted on 2007-10-01
Medium Priority
Last Modified: 2013-12-17
I assume I should:

1) create a database locally
2) detach the database
3) FTP it to my website

Then, how to I attach it to the database running at my ISP.  I do not have a Windows Desktop associated with my website, instead I intend to use a cheap website.  How do I detach the database from the website's SQL Server?

Once I have the database attached, then I need to create a connection string to it.

What information do I need from the ISP to connect to SQL Server?  I presume that once I create a valid connection string I'll be able to connect to my database.

Do I have it right?  What am I missing?

Question by:newbieweb
  • 2
LVL 15

Accepted Solution

danrosenthal earned 1200 total points
ID: 19995337
It will depend on the access level you have at your host. If you don't have full access, you may be able to send them the db file and have them manually attach it for you. I suggest calling your host and asking them for the best way to accomplish your goal.

Author Comment

ID: 19995356
thanks.  I would certainly want to be able to do the attaching myself.  Glad I asked before I picked an ISP.

Can you suggest one where I would have control?

Assisted Solution

ina_don earned 800 total points
ID: 19996723
I think that your ISP must have a dashboard or an SQL Script execution interface that should allow you to execute the script to create the structures in your assigned database. I doubt they'll allow you to attach because the SQL server is most likely shared by many users. Just script your entire database and run the script to create it on the host site.
LVL 15

Expert Comment

ID: 20000671
It will probably be much more expensive to have that level of control. I use GoDaddy and have no direct access to DB files, but boast a 100% data retention rate and will provide a backup DB file if you ask nicely.

If you find a better solution, let me know!


Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Suggested Courses

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question