You need to register the SQL Server that you are connecting to in Enterprise
Manager.
Just click Action/New SQL Server Registration
Type the IP address of the isp's SQL Server into Available Server's and
click Add
Use the SQL Server login and type in the Username and Password the isp gives
you.
Most isp's will not let you create a database though. You need to call them
and have them create it and give you a username and password. Then you can
log in and create your tables or whatever you want.
SQL Server Developers Edition is free for developers. So no you dont have to
buy it ;-)
jon
----- Original Message -----
From: "Chad Gray" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, March 06, 2001 10:23 AM
Subject: Remote Modifying MS SQL
> I searched the FAQ, and Archives, and did not see anything obvious.
>
> How do i connect to a remote SQL server so i can create a new DB? I
played
> with the demo version of MS SQL, and it came with a client to connect to a
> remote SQL server. Do i have to buy this client?
>
> I will be using a comma delimited file supplied by the client, and i need
> to get this file into the MS SQL server at our web host.
>
> Thanks,
> Chad
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
