There are two ways to allow CF to talk to SQL Server. One is by providing a valid SQL Server login and password. That is what has been suggested thus far. The login that you are attempting to use is "SA". By default, the SA password is blank, not the letters "SA". So you could try a username of "SA" and a password of "". If that works, you should immediately change your SA password to something else, as it is incredibly dangerous to have an SA password of "". Imagine having a Windows NT Administrator password of ""!
The other method of connecting is via a trusted connection. This will work if both CF and SQL are on the same machine, or the same network. In the ODBC configuration screen for SQL Server, there should be a checkbox that says "Use Trusted Connection" - try checking that. Ideally, you should set-up a login specifically for CF using SQL Server's Enterprise Manager, and then use that login and password to allow CF to talk to SQL Server (that would be the first method above, but with a different login than SA). Bob > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of carina cojeen > Sent: Tuesday, 22 January 2002 7:00 a.m. > To: [EMAIL PROTECTED] > Subject: Re: [CFTALKTor] SQL Database Activation > > > some programs disguise the actual number of password characters that > were typed in. I guess they do that so that it's harder to guess a > password if you don't really know how long it was. > > So I think the "more than 2 characters" MIGHT be not as wacky as it > seems. > > however, that still leaves you with the original problem and sorry, I > don't know anything else about SQL! > > carina > > - > You are subscribed to the CFUGToronto CFTALK ListSRV. > This message has been posted by: carina cojeen <[EMAIL PROTECTED]> > To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ > Manager: Kevin Towes ([EMAIL PROTECTED]) > http://www.CFUGToronto.org/ > This System has been donated by Infopreneur, Inc. > (http://www.infopreneur.net) > - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "Bob Silverberg" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
