This is a discussion on SQL Server: beginner: "Login failed for user 'sa'." within the SQL Server forums, part of the Microsoft SQL Server category; --> Hello, (Sorry for my English first...) Could you help me please with SQL Server problem? I suspect that my ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hello, (Sorry for my English first...) Could you help me please with SQL Server problem? I suspect that my problem has simple solution but I have little experience. I have installed SQL Server 2005 and I am installing some application using it - unfortunatelly setup fails because I cannot logon to SQL Server in SQL Server Authentication, account sa, password sa. Thus I checked SQL Server Management Studio Express: I have 'sa' account, password 'sa' (because I had prepared it), unfortunatelly I cannot logon in SQL Server Authentication (sa/sa) because of: Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection (Microsoft SQL Server, Error: 18452). Could you help me plase... Thank you very much. /RAM |
| ||||
| If you want to use the "sa" account which uses SQL Server authentication, you have to setup your server for mixed authentication, unless you do this you are only allowed to use Windows (Integrated) Authentication. HTH, Jens Suessmeyer. |
| Thread Tools | |
| Display Modes | |
|
|