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 directions...
On Monday 14 Jul 2008, Orlini, Robert wrote:
[Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'sa'
Any ideas pls?
guessSomething somewhere is silly enough to allow users to choose what user
they connect to the database asguess
If I'm right, you need to remove that right now
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
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
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
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'
[Macromedia][SQLServer JDBC Driver
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
'
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
forensic analysis performed if your DBA said they did not do anything with
the sa login
[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
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
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?
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.
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 it
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
+ 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 account.
Perhaps
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'
+ 1000
16 matches
Mail list logo