Search: Error with SQL : Login failed for ‘SA’.

25 pts.
Tags:
SQL Server 2000
SQL Server 2005
VB.NET
Visual Basic
Windows Server 2003
I'm using a softawre written in VB(.net). It runs normal on XP and 2003 server. it supports both Access and SQL 2000 and 2005. but I recently upgraded my OS to Win7+SQL 2008, and I've been having the following error anytime a call for a screen in the software"Search: Error with SQL : Login failed for 'SA'."( when I use SQL backend, but on Access) the same settings works perfect in xp and 2003. Can anyone help?

Software/Hardware used:
Windows 7 ultimate

Answer Wiki

Thanks. We'll let you know when a new response is added.

Sounds like you either have the wrong sa password, someone has changed the sa password, someone has renamed the sa account, or someone has disabled the sa account.

No software should ever use the sa account to log into the SQL Server. The sa account should be used for administrative purposes to manage the database engine only.

Discuss This Question: 5  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • PrinceBismark
    But how come the same software works well on the XP/SQL2005. without login failure, but when it gets on the WIN7/2008 it gives error?
    25 pointsBadges:
    report
  • carlosdl
    The application is the same, but the database server is not the same. All possibilities mentioned by Mrdenny refer to the database server, not the application.
    69,065 pointsBadges:
    report
  • PrinceBismark
    so what can I do to the SQL 2008 to behave/work as the SQL 2005? especially in respect of the sa log in?
    25 pointsBadges:
    report
  • carlosdl
    :-) Use the same password for the sa account. But, as previously mentioned by Mrdenny, applications should not be using the sa account to connect.
    69,065 pointsBadges:
    report
  • Danisapfirov
    Check if sa login is valid
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following