Solved

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

Posted on 2011-02-17
6
335 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
  • 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
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to debug a store procedure in MS SQL 2008? 3 33
Need help with a Stored Proc on Sql Server 2012 4 35
SQL Server Shrink hurting performance? 4 40
Using this function 4 42
Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

726 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