SQL password
|
From: yitiana on 4 Aug 2010 00:00 <p>Forgot or lost MS SQL Server password? This <a href="http://www.passwordunlocker.com/sql-server-password-recovery.html">MS SQL Server password recovery</a> software can instantly reset MS SQL Server and Express 2000/2005/2008 password, including SA and other users password, no matter the password is how long and complex, Only the master.mdf file is needed for resetting the password within seconds. And you do not need to reinstall MS SQL Server on your PC. Save more time and trouble.</p> Bria wrote: SQL password help 10-May-07 Hello, We are running into a problem where the sqlsrvr.exe process is using over 1GB of memory. This is causing performance issues on the server. I've come across a site that suggests adjusting the max/min memory usage settings on SQL. My problem seems to be that we do not know what the SA password is to do these adjustments. Does anyone know a way to reset the SA password on SQL server for Small Business Server 2003? Side note: anyone else experiencing the high memory usage of sqlsrvr.exe process? If so, what have you done about it? Rebooting the server seems to help, but the high usage creeps up after a few days. Thanks in advance ...Brian Previous Posts In This Thread: On Thursday, May 10, 2007 4:05 PM Bria wrote: SQL password help Hello, We are running into a problem where the sqlsrvr.exe process is using over 1GB of memory. This is causing performance issues on the server. I've come across a site that suggests adjusting the max/min memory usage settings on SQL. My problem seems to be that we do not know what the SA password is to do these adjustments. Does anyone know a way to reset the SA password on SQL server for Small Business Server 2003? Side note: anyone else experiencing the high memory usage of sqlsrvr.exe process? If so, what have you done about it? Rebooting the server seems to help, but the high usage creeps up after a few days. Thanks in advance ...Brian On Thursday, May 10, 2007 4:19 PM Bria wrote: RE: SQL password help Sorry, I meant sqlservr.exe. "Brian" wrote: On Thursday, May 10, 2007 4:22 PM Dave Nickason [SBS MVP] wrote: You can change the SA password in SQL Management Studio, but you shouldn't You can change the SA password in SQL Management Studio, but you shouldn't have to, and you shouldn't need the SA password to throttle the RAM usage. Your SQL instances are probably using Windows auth anyway. To throttle the memory usage of the SQL instances, see http://msmvps.com:80/blogs/bradley/archive/2005/02/04/34984.aspx. SQL normally grabs up all the memory it can get its hands on, similar to Exchange. That's why it's temporarily remedied by a reboot - it takes a while for it to get back up to speed. "Brian" <Brian(a)discussions.microsoft.com> wrote in message news:2812427E-C59C-4D51-89B5-02148808B165(a)microsoft.com... On Thursday, May 10, 2007 6:15 PM Leythos wrote: Re: SQL password help On Thu, 10 May 2007 13:05:02 -0700, Brian wrote: Your real problem is not SQL, that's standard, it would appear you don't have enough base memory in your server. If you have Exchange and SQL then you need 3 - 4 GB for the server to be happy. -- Leythos Igitur qui desiderat pacem, praeparet bellum. Calling an illegal alien an "undocumented worker" is like calling a drug dealer an "unlicensed pharmacist" spam999free(a)rrohio.com (remove 999 for proper email address) On Friday, May 11, 2007 4:39 AM bassplaye wrote: You need sysadmin privileges to do this. You need sysadmin privileges to do this. This is a default privilege for the Builtin\Administrators which includes your domain and admins and the sa account. You can use a domain admin account to reset your sa password as well -- MCP MCDBA MCAD MCSD MCT MCTS MCITP:DBA "Helping people grow and develop their full potential as God has plan for them" "Brian" wrote: Submitted via EggHeadCafe - Software Developer Portal of Choice Win a free Professional license of CodeSmith Generator 5.2! http://www.eggheadcafe.com/tutorials/aspnet/32aeed64-8518-4bd0-9614-e82b5d3ab3a4/win-a-free-professional-license-of-codesmith-generator-52.aspx
|
Pages: 1 Prev: About IE7 and group policy issues Next: event id 529 after password change |