Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
viviang
Starting Member
2 Posts |
 Posted - 2006-08-07 : 13:49:23
|
| I'm hoping someone has an idea on how to help me with this.We brought over an ASP.net / MS SQL server application from one server to another.We used a backup of the original database and restored it to the new server.Now when I try to view the pages, I get the following error:Login failed for user 'sa'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'sa'.After researching possible causes of the problem, I tried making the ODBC source use mixed verification (ODBC Data Source Manager, System DSN tab, selected the db in question and hit configure, changed "How should SQL Server verify the authenticity of the login ID?' to "With SQL Server authentication using a login ID and password entered by the user.")When I try to click next, I get the following error:Connection failed:SQLState: '28000'SQL Server Error: 18456[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'.I've verified the user sa does exist and does have permission to my database.The only other possible explanation I've found so far is that because the database was brought over from another server, there is a permissions conflict, but I can't figure out how to check for that or fix it if that's the case. |
|
|
viviang
Starting Member
2 Posts |
Posted - 2006-08-07 : 17:05:59
|
| Never mind, I got it to work. I just created a new login that used SQL server authentication. |
 |
|
|
|
|
|
Database permissions problem