Showing posts with label internet. Show all posts
Showing posts with label internet. Show all posts

Sunday, March 25, 2012

Configuing SQLServer Express for internet access

Could someone point me to an article that shows how to configure SQLServer express so I can connect to it over the lan and Internet?

Thanks

These articles should help guide you.

Configuration -Configure SQL Server 2005 to allow remote connections
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277
http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

Configuration -Connect to SQL Express from "downlevel clients"
http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx

Configuration -Connect to SQL Express and ‘Stay Connected’
http://betav.com/blog/billva/2006/06/getting_and_staying_connected.html

Configuration - Guideline for Connectivity Question Posting
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=362498&SiteID=1

Thursday, March 22, 2012

Conecting over the Internet for getting data from clients.

I want to connect over the internet to get data from clients.What would
be the easiest method and the most stable methos to do it

1.Use a Point to Point prtotcol from the client pc and then upload the
data to our sql server
2.Export the data from the clint pc in XML format and then Enter it in
our computer.
3.Have all clienst ftp the data in a dirctory and then upload the xml
files from the directory?

Thanking you in anticipation.Would love it if we could discuss and
distribute our thoughts on this.

AjayFTP seems like the obvious choice unless you need the data continuously
available online.

--
David Portas
SQL Server MVP
--