Solved

Administer Remote SQL Database from SQl Studio Express (Or Similar)

Posted on 2011-02-17
6
337 Views
Last Modified: 2012-05-11
Hi everyone,

This maybe more of a general advice question than specific technical issue but...

Can I use Microsoft SQL Server 2008 R2 to connect to and manage a remote database (specifically a SQL 2008 database hosted by discountasp.net)

I am just trying to build some skills relevant to my workplace. Sql Server Studio 2005 is used at my work and the package seems similar, whereas the web based littleadmin program provided by discountasp is not.

In the long run, I would like to play with DTS or SISS packages as used by some of the tech guys at my work.

If it can be done, please give me a hint how to set it up, if it cannot be done, appreciate any suggestion for a good alternative that would suit my needs. As this is just a learning thing, I could even change providers if that is the best option.

Thank you!
0
Comment
Question by:Split_Pin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 2

Accepted Solution

by:
Darran Brown earned 125 total points
ID: 34914643
You can use SQL Server Management Studio 2008 which is a Tool  that can be installed from your SQL CD. You don't need to install/create a SQL server.
Once you have Management Studio installed you would then need the name of the SQL server that your database is on and some method of being able to connect to that server e.g a VPN.
For practise i wouldn't connect to your your live databses though and you probably won't be allowed to anyway. Create a test SQL server and some test databases and use management studio to find your way around and run some tests.  
0
 

Author Comment

by:Split_Pin
ID: 34914711
Many thanks Mr_B for such a quick response, what you say makes perfect sense.
SQL Server Management Studio Express seems to be installed and working correctly. I have a test database with a few dummy tables sitting in discountasp's server (I can view these in the database explorer in visual web studio and pull the data into gridviews etc).

I had not thought of using VPN - the options in SQL Studio I can see are Default, Shared Memory, TCP/IP and Named Pipes (I have no idea what the difference is!)
I was hoping maybe I could use my connection string from web studio to access via server studio.

I am rather naively hoping there is somewhere on the program I can just enter the address of the db e.g. sql2k80x.discountasp.net and username and password and it will all just work...

Thank you again!
0
 

Author Closing Comment

by:Split_Pin
ID: 34914736
Um I feel a little silly - I just tried again and it all seemed to work. Thank you for the encouragement! Points to you Mr_B!
0
Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

 
LVL 2

Expert Comment

by:Darran Brown
ID: 34914773
Hi
The VPN side of things would need to be setup by your network team unfortunately. Its not a SQL setting just a method of connecting your network to discountasp's network. It may have already been done and the above server name migth work without the http:// , but I doubt it will.
If you have a SQL cd or setup files anywhere, try installing the full version of management studio, I don't think it will heklp your specific connection issue but it;s good to get used to the full version.

Hopefully someone may reply with some more ideas for how to connect to the web address but i imagine it will all depend on what discountasp have setup and what hey allow. It might be worth a call to them for advice, they will probably have done it all before. Good luck, more poeple will reply in time.



0
 
LVL 2

Expert Comment

by:Darran Brown
ID: 34914778
ha, seemed to have crossed posts. Thank you.
0
 

Author Comment

by:Split_Pin
ID: 34914821
Thanks for the extra info Mr_B.
Experts exchange seems really good - wondering why I didn't join sooner!
All the best.
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

631 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