Split_Pin
asked on
Administer Remote SQL Database from SQl Studio Express (Or Similar)
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!
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!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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!
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.
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.
ha, seemed to have crossed posts. Thank you.
ASKER
Thanks for the extra info Mr_B.
Experts exchange seems really good - wondering why I didn't join sooner!
All the best.
Experts exchange seems really good - wondering why I didn't join sooner!
All the best.
ASKER
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!