?
Solved

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

Posted on 2011-02-17
6
Medium Priority
?
338 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 500 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

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

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

718 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