I know the SQL Server error log is correct: Login failed for user 'sa'. Reason. Password did not match.....
SQL Server 2012 Express on a Server2012
I create an connection string for my C# desktop application using a text file connect.udl. Open it up with OLE DB Core Services, enter the user ID 'myapplication' and the associated password. Test connection and Test connection succeeded. Copy the resulting connection string into my application (I am changing the app to point at a new SQL Server, this database server and connection method has been working for years pointing to the previous SQL server 2000). SSMS logins in using SQL Authentication and 'sa' and password and myapplication/password.
With the connect string as Provider=SQLOLEDB.1;Password=#$%&;User ID=myapplication.... the error message says 'sa'. So I'm not sure what else to look at - I'm not logging in as 'sa'.
SQL Configuration has Named Pipes and TCP/IP enabled. SQL Browser is running. Another database table is is working fine! Where else can I look? Is there a permission setting for my desktop application? Thanks