How to Connect to MS SQL 2005 over the Internet
Re-invent ASP.NET Hosting Community
Home       Members    Calendar    Who's On
Welcome Guest ( Login | Register )
        

Home » Web Site Development / Design » SQL 2008/2005/2000 and MS Access Database » How to Connect to MS SQL 2005 over the...

How to Connect to MS SQL 2005 over the... Expand / Collapse
Author
Message
Posted 7/28/2006 5:13:00 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 7/31/2006 8:28:00 AM
Posts: 3, Visits: 1

Hello. How Can I connect from my home desktop SQL Server Management Studio to my sql2005.reinventinc.com Database.  I have my username and password. I know in order to connect to MS SQL 2000 You need to VPN in first, and then You should be able to connect. Which options are You offering regarding connection to sql2005.reinventinc.com ?  Thanks
Post #338
Posted 7/28/2006 5:22:00 PM
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Administrators
Last Login: 12/30/2008 9:51:24 AM
Posts: 170, Visits: 469

Hello,

The best way is using SQL Server Management Studio (http://www.microsoft.com/sql) with which you can administer your database remotely.

SQL Management Studio Express is also available --- see http://www.microsoft.com/sql/editions/express/default.mspx.

You can perform most common database management tasks with SQL Management Studio Express.

Additionally, Visual Studio 2005 and Visual Web Developer also have Database Explorer tools to connect and administer your database.

Visual Web Developer Express is free at: http://www.asp.net/downloads/essential.aspx?tabid=62

If we can be of further assistance, just let us know.


 

Paul B

Re-invent Technologies LLC
http://www.re-invent.com

Innovative ASP.NET 3.5/2.0 Hosting
Now with Windows 2008 Hosting and SQL 2008
Celebrating 10 Years in Business!
Post #339
Posted 7/28/2006 5:26:00 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 7/31/2006 8:28:00 AM
Posts: 3, Visits: 1
Thanks. I do understand that. I have SQL Server Management Studio on my machine, but I'm unable to remote connect to sql2005.reinventinc.com from my PC.
Post #340
Posted 7/28/2006 5:29:00 PM
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Administrators
Last Login: 12/30/2008 9:51:24 AM
Posts: 170, Visits: 469
Check to make sure you are not blocking port 1433 on your computer.    Also make sure TCP/IP is selected for connecting over the Internet.

Paul B

Re-invent Technologies LLC
http://www.re-invent.com

Innovative ASP.NET 3.5/2.0 Hosting
Now with Windows 2008 Hosting and SQL 2008
Celebrating 10 Years in Business!
Post #341
Posted 7/31/2006 8:29:00 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 7/31/2006 8:28:00 AM
Posts: 3, Visits: 1
Thanks. It was port issue.
Post #343
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 1 (1 guest, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Administrator, Re-invent (Paul), Re-invent (Nick)

Permissions Expand / Collapse

All times are GMT -5:00, Time now is 12:50am

Powered By InstantForum.NET v4.1.4 © 2009
Execution: 0.031. 13 queries. Compression Disabled.

Copyright 2007 Re-invent Technologies LLC All Rights Reserved.