When i am connecting to MSQL server my application it raising this error instead of connecting.
login failed for user 'sa' Reason associated with a trusted SQL Server connection.
Anybody can help me regarding above error.
Thanx in Advance.
SABIs the message really
login failed for user 'sa' Reason NOT associated with a trusted SQL Server connection.
It will be because you have set your connection up to use nt security but trying to connect with a username and password.
Decide if you want to use sql server or NT security
If sql server
Make sure that the server allows mixed security
Make sure the connection allows it (connection string, odbc datasource...)
If NT security then don't pass sa as the user name.
(It's a very very bad idea to use sa as an application user).
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment