Timeline for SQL Server 2008 R2 Express password overwrite
Current License: CC BY-SA 3.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 14, 2013 at 14:10 | answer | added | user507 | timeline score: 1 | |
| Feb 14, 2013 at 12:25 | history | edited | Mat |
edited tags
|
|
| Nov 13, 2012 at 21:12 | comment | added | Marian | @Jamie: SQL Server or Management Studio (SSMS), by itself, doesn't revert any password. Anything you do, remains done, as long as some script/other user doesn't change that. So open a Profiler and see what credentials your application is using to connect to the SQL Server. Then you'll be able to see further whom to give permissions to. | |
| Nov 13, 2012 at 19:27 | comment | added | András Váczi | This is a good advice. However, it doesn't really answer the question. | |
| Nov 13, 2012 at 19:25 | comment | added | user15311 | Create a new login, give it necessary permissions and reconfigure your application to use this new login instead of sa. | |
| Nov 12, 2012 at 21:51 | history | edited | marc_s | CC BY-SA 3.0 |
added 10 characters in body; edited tags; edited title
|
| Nov 12, 2012 at 18:59 | history | tweeted | twitter.com/#!/StackDBAs/status/268065617725235200 | ||
| Nov 12, 2012 at 17:55 | comment | added | Joel Mansford | I think you may be confusing SQL Management Studio (SSMS) with some kind of app that uses SQL Server or do you mean SSMS is starting automatically on this box? If yes, why? | |
| Nov 12, 2012 at 17:35 | history | edited | Jon Seigel | CC BY-SA 3.0 |
Really
|
| Nov 12, 2012 at 17:28 | review | First posts | |||
| Nov 12, 2012 at 17:38 | |||||
| Nov 12, 2012 at 17:12 | history | asked | Jamie | CC BY-SA 3.0 |