Hi rob,
All you gotta do is to configure the server with client connections via
tcp/ip in the server network clients utility. Then ensure you use tcp/ip
from your desktop to connect to the server (use either IP or FQDN of the
server). Also make sure you set up valid user accounts. You can set up using
either SQL security or if you want to add logging capabilities, use NT
authentication (not totally sure how this is done just yet but am in the
process of setting it up on one of our servers so will let you know once
I've cracked it)
To get further insightful info on this and virtually any other SQL 70
topics, I suggest you subscribe to the SQL7.0 mailing list over at swynk.com
Hope this points you in the right direction,
Dave
Dave Wilson
Internet Technology Manager,
BizNet Solutions
<Allaire Premier Partner>
Co-Founder CFUG Ireland
http://www.cfug.ie
224, Lisburn Road
Belfast BT9 6GE
Tel: 02890 225 776
Fax: 02890 223 223
web: http://www.biznet-solutions.com
email: [EMAIL PROTECTED]
----- Original Message -----
From: Robert M. Saxon, Jr. <[EMAIL PROTECTED]>
To: Cf-Talk <[EMAIL PROTECTED]>
Sent: Monday, June 05, 2000 8:18 PM
Subject: OT: Remote SQL Server access
> Has anyone installed the desktop version of SQL Server 7 on a workstation
> and dialed into an ISP to connect to a SQL Server. If so, how did you do
> that? I am trying to set up a telecommuting situation. I need to what
steps
> I must take to get that desktop version to communicate with a server via
> ISP.) Any help offered is already appreciated.
>
>
> Thanks,
> Rob
>
> ___________________________________________
> Robert M. Saxon, Jr. (Rob), Senior Web Developer
> Mercer University
> Department of Web Management
> TSS // 1400 Coleman Avenue // Macon, GA 31207
> 912-301-5550 voice // 912-301-5314 fax
> [EMAIL PROTECTED]
> Philippians 4:13
>
>
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
