Error 18488 Sql
Contents |
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » sql error 18456 SQL Server 2005 » Backups » How to resolve: The password of the sql error 15128 account... How to resolve: The password of the account must be changed Rate Topic Display Mode Topic Options
Sql Server Error 18488 Password Must Be Changed
Author Message JuLs-706900JuLs-706900 Posted Thursday, April 17, 2008 8:40 AM Forum Newbie Group: General Forum Members Last Login: Thursday, March 12, 2009 5:20 AM Points: 5, Visits: 18 Please help I
The Password Of The Account Has Expired Sql Server 2008
am just new to SQL 2005.I restored a backup copy of Sql 2000 DB to another PC which is running on SQL 2005 it all work fine and then I am having a login issue problem in this. What I do is I Delete the user at the Database level. Create the user at the Server Level and give my DB sql reason the password of the account must be changed database permissions under the User Mapping section. Now after that I try to connect with my front end client or login page I get the below error message[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(UID)'. Reason: The password of the account must be changedPlease advised what is wrong.Thank you so much. Post #486497 Greg CharlesGreg Charles Posted Thursday, April 17, 2008 5:01 PM SSCarpal Tunnel Group: General Forum Members Last Login: Friday, October 7, 2016 11:51 AM Points: 4,066, Visits: 5,750 When you created the login, did you specify the MUST_CHANGE option of CREATE LOGIN or, if you used Management Studio, did you leave the box checked that says, "User must change password at next login"? If you did, that's what's wrong. Change the password and you'll be back in business. Greg Post #486849 JuLs-706900JuLs-706900 Posted Saturday, April 19, 2008 8:02 AM Forum Newbie Group: General Forum Members Last Login: Thursday, March 12, 2009 5:20 AM Points: 5, Visits: 18 Greg,Thank you for your tips... Yes I am using Management Studio, I delete the user and then I created again and the
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of
Sql Server Error 15128
this site About Us Learn more about Stack Overflow the company Business Learn sql server password expired how to reset more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database the password of the account has expired sql server 2012 Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a http://www.sqlservercentral.com/Forums/Topic486497-357-1.aspx minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top HeidiSQL solution for SQL Server error 18488? up vote 0 down vote favorite I'm connecting to a remote database using HeidiSQL client but looks like the administrator has activated the enforce password change policy (Error 18488). Is there http://dba.stackexchange.com/questions/140129/heidisql-solution-for-sql-server-error-18488 a workaround to solve this with HeidiSQL? Or I need to download and install SQL Server Management Studio? sql-server tools sql-server-tools share|improve this question edited Jun 1 at 19:02 marc_s 5,41632743 asked Jun 1 at 15:01 raziel 11 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote You can change the password from sqlcmd using -z or -Z: -z new_password Change password: sqlcmd -U someuser -P s0mep@ssword -z a_new_p@a$$w0rd -Z new_password Change password and exit: sqlcmd -U someuser -P s0mep@ssword -Z a_new_p@a$$w0rd share|improve this answer answered Jun 2 at 7:40 Remus Rusanu 41.4k360133 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Not the answer you're looking for? Browse other questions tagged sql-server tools sql-server-tools or ask your own question. asked 4 months ago viewed 37 times active 4 months ago Related 6Impact of Redgate SQL Search on Server5Recommended too
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies http://stackoverflow.com/questions/16730409/change-expired-password-without-password-expired-dialog-box of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges https://support.microsoft.com/en-us/kb/168001 Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a sql server minute: Sign up Change expired password without “Password Expired dialog box” up vote 15 down vote favorite 3 I'm logging on my application using Sql Server Database logon account. However, when a user's password is expired, i can only catch the error message using "error:18488" and display a message to user. When I login using Sql Server Management Studio with an account the password of with expired password, a dialog box requiring me to change password appears. Is there a way to allow my application to change the expired password with something like T-Sql statement? c# .net sql-server share|improve this question edited May 24 '13 at 8:14 asked May 24 '13 at 8:08 Nikko Reyes 2,62711033 add a comment| 3 Answers 3 active oldest votes up vote 7 down vote accepted +50 I've found the solution here, I used SqlConnection.ChangePassword(). Here's the code: class Program { static void Main(string[] args) { System.Data.SqlClient.SqlConnection.ChangePassword( "Data Source=a_server;Initial Catalog=a_database;UID=user;PWD=old_password", "new_password"); } } Hope it helps others too. :) share|improve this answer answered May 27 '13 at 7:31 Nikko Reyes 2,62711033 How about in oracle? :) –Christian Mark May 27 '13 at 7:45 Sorry, but i have no idea about oracle. I am using .Net and 'SQL Server 2008` so I only got the solution from MSDN. –Nikko Reyes May 27 '13 at 7:47 add a comment| up vote 2 down vote You can change a user login using ALTER LOGIN. ALTER LOGIN [userName] WITH PASSWORD=N'StrongPassword' Another option is to
360 games PC games Windows games Windows phone games Entertainment All Entertainment Movies & TV Music Business & Education Business Students & educators Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft