Groups | Blog | Home
all groups > sql server programming > may 2007 >

sql server programming : SQL Express and SQL Developer allow remote connections?


William (Bill) Vaughn
5/5/2007 1:54:38 PM
All versions of SQL Server can be accessed remotely but to do so you have to
jump through some configuration hoops first...
See my whitepaper on connecting or Chapter 9 of my book for details. See
http://betav.com/blog/billva/2006/06/getting_and_staying_connected_1.html
for starters...


--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

[quoted text, click to view]

Charlie NO[at]SPAM CBFC
5/5/2007 3:43:48 PM
Can't seem to connect to these databases over a network. Doc's say... "By
default, SQL Server 2005 Express, Evaluation, and Developer editions allow
local client connections only". Does that mean setting can be overriden or
does it mean local connections only.

Thanks,
Charlie

Erland Sommarskog
5/5/2007 9:02:37 PM
Charlie@CBFC (charlie@cbfconsulting.com) writes:
[quoted text, click to view]

Yes. Look for the Surface Area Configuration tool under SQL Server in the
Start Menu.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
AddThis Social Bookmark Button