Solved

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

Posted on 2011-02-17
6
334 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
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

828 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