Thanks, Jacob. You just crashed my Outlook window due to some math
overflow error...
-Original Message-
From: Jacob [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 15, 2008 2:40 PM
To: CF-Talk
Subject: RE: "Login failed for user 'sa'
+ 1
+ 1000
-Original Message-
From: Ricardo Russon [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 15, 2008 1:28 AM
To: CF-Talk
Subject: Re: "Login failed for user 'sa'
sa is the default MSSQL admin user.CF Should not be using this user accoun
Hmm.. really want to use "sa" for your SQL login?
-Original Message-
From: Orlini, Robert [mailto:[EMAIL PROTECTED]
Sent: Monday, July 14, 2008 8:50 AM
To: CF-Talk
Subject: "Login failed for user 'sa'
Some of our CF programs are generating this SQL error.
[Macromedia][SQLServer JDBC Dri
> Some of our CF programs are generating this SQL error.
>
> [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed
> for user 'sa'
>
> Any ideas pls?
First, you should NEVER EVER use the sa account from an application, or for
any purpose other than database management. Ideally, you'd use i
Well, it kinda tells you right there. The DSN tried to login to SQL
Server with username SA and some password and it failed. So have you
tried updating the password?
On Mon, Jul 14, 2008 at 10:50 AM, Orlini, Robert <[EMAIL PROTECTED]> wrote:
> Some of our CF programs are generating this SQL error.
The password changed? Check the DSN in CFAdmin...
On Mon, Jul 14, 2008 at 11:50 AM, Orlini, Robert <[EMAIL PROTECTED]> wrote:
> Some of our CF programs are generating this SQL error.
>
> [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'sa'
>
> Any ideas pls?
~~
"sa" is the default username for the administrator of the SQLServer.
Perhaps the admin has changed the admin password for security reasons
and now your datasource can't log in.
I would suggest you set up a user for each database that is used only
by the coldfusion datasource. Perhaps something l
> [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'sa'
Sounds like you have your CF data sources set up to use the SA (sysadmin) ID
and password. That's a bit odd, but it will work. However, you'd generally
set up another admin user for CF and use that... sa has too much author
008 8:51 AM
> To: 'cf-talk@houseoffusion.com'
> Subject: RE: "Login failed for user 'sa'
>
> > [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'sa'
>
Not to mention the worst, you could have already been hacked. I'd get a
for
>Some of our CF programs are generating this SQL error.
>
>[Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'sa'
>
>Any ideas pls?
>
>RO
Hello,
http://www.fusioncube.net/index.php/...server-express
Those are the instructions that I used to set up my 'sa' user along with other
I replied before... but don't see it on the list. Here it is again.
-Original Message-
From: Robert Harrison [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 15, 2008 8:51 AM
To: 'cf-talk@houseoffusion.com'
Subject: RE: "Login failed for user 'sa'
> [
Yeah,
Never, EVER, under any circumstances, use the SA login for your web apps!!
Create a new login in SQL Server, and change your datasources to use that.
Thanks,
Eric
Orlini, Robert wrote:
> Some of our CF programs are generating this SQL error.
>
> [Macromedia][SQLServer JDBC Driver][SQLSe
sa is the default MSSQL admin user.CF Should not be using this user account.
Perhaps the Database administrator changed the password because they noticed
a higher than normal connection count for this user?
Either way, you should be creating a new user with only the
required privileges and changi
Robert,
This error is generated because the password that is being supplied to
access the database is incorrect.
The password is supplied either directly through the cfquery tag or set in
the datasource in the CF Administrator. You need to find out what the sa
password is and update it in whiche
On Monday 14 Jul 2008, Orlini, Robert wrote:
> [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'sa'
> Any ideas pls?
Something somewhere is silly enough to allow users to choose what user
they connect to the database as
If I'm right, you need to remove that right now (how lon
>Some of our CF programs are generating this SQL error.
>
>[Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'sa'
>
>Any ideas pls?
>
>RO
Here is the directions I used to set up the 'sa' user.
http://www.fusioncube.net/index.php/...server-express
Those are excellent direction
16 matches
Mail list logo
