OK, got it. I added a specific web server account to SQL Server config and
then entered that info into the CF Admin page and it verifies properly.
Thanks!
John
-----Original Message-----
From: Bob Silverberg [mailto:[EMAIL PROTECTED]]
Sent: Saturday, October 28, 2000 3:02 PM
To: CF-Talk
Subject: RE: Upsizing to SQL Server from Access
Yes, if you specify a valid SQL Server logon and password (i.e., one that is
setup within SQL Server) in the CF Administrator (under the CF Settings >>
area), it shouldn't matter which account the CF Server is running under.
Bob
-----Original Message-----
From: John Fix 3rd [mailto:[EMAIL PROTECTED]]
Sent: Saturday, October 28, 2000 2:35 PM
To: CF-Talk
Subject: RE: Upsizing to SQL Server from Access
After going around in circles a bit, I got it to work by changing the logged
in user for the Cold Fusion server service. I had it starting under the
system account before, but now it's running under a user name that is valid
for the SQL server. The datasource verifies, but is this a valid security
setup to use? Should I be able to get the connection working WITHOUT having
CFServer run under a user account?
Thanks!
John
-----Original Message-----
From: Brian bouldernet [mailto:[EMAIL PROTECTED]]
Sent: Saturday, October 28, 2000 2:28 PM
To: CF-Talk
Subject: Re: Upsizing to SQL Server from Access
We went through this once before:
Questions:
Have you changed and usernames or passwords?
Are you Connecting through TCPip?
----- Original Message -----
From: John Fix 3rd <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Saturday, October 28, 2000 11:22 AM
Subject: Upsizing to SQL Server from Access
> I'm in the process of moving my databases from Access 2000 to SQL
> Server
7.
> I've got SQL running on a different machine than my web/CF server, and
> I upsized my Access databases to SQL successfully. I also added a
> System
DSN
> via the ODBC control panel and connected successfully to the
> datasource. However, the Cold Fusion admin ODBC tab cannot verify the
> datasource. Any idea why?
>
> Thanks!
>
> John
> www.cornells.com
>
> ----------------------------------------------------------------------
> ----
----------------------
> Archives: http://www.mail-archive.com/[email protected]/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
> send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>
----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
