November 10, 2010 at 4:19 am
Issue: SQL Server 2008 is installed with mixedmode and user forget the password for sa account, is there any possible way to connect SQL Server, even tried with Built-in-account's no luck.
Thnaks in advance
Amar.
November 10, 2010 at 4:34 am
amar4sk (11/10/2010)
Issue: SQL Server 2008 is installed with mixedmode and user forget the password for sa account, is there any possible way to connect SQL Server, even tried with Built-in-account's no luck.Thnaks in advance
Amar.
try logging in with the account that SQL services start up with...
alternatively http://www.sqlservercentral.com/Forums/Topic988899-149-1.aspx
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 10, 2010 at 4:34 am
amar4sk (11/10/2010)
Issue: SQL Server 2008 is installed with mixedmode and user forget the password for sa account, is there any possible way to connect SQL Server, even tried with Built-in-account's no luck.Thnaks in advance
Amar.
Whats is the error did you got while connecting the Built-in-account's .
Is there any login id has sysadmin permission other than SA.
Did you delete/disabled the Built-in-account ?
Is there any local admin in your windows group ?
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
November 10, 2010 at 5:10 am
When we install SQL server we add the current user (Windows login) for login to SQL server. You can connect through the windows login from where it was installed. You can change the sa account password then.
Ryan
//All our dreams can come true, if we have the courage to pursue them//
November 10, 2010 at 9:26 am
You can also start in single user mode, connect with the DAC with a windows admin if you are stuck.
November 10, 2010 at 10:28 am
If DAC is also not an option, as Henrico suggested try connecting to the instance using startup account credentials.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply