I intended learn to Javascript
and got "HTTP Error 403.14 - Forbidden..." error at first try. I found the solution from a blog. Move to "C:\Program Files\IIS Express" (It may different at your computer) folder and run this command:
appcmd set config /section:system.webServer/directoryBrowse /enabled:true
23 Ocak 2015 Cuma
2 Ocak 2015 Cuma
SQL SERVER - If noone has Sysadmin rights or SA password is lost?
Go to pproperties of relates servers from SQL Server Configuration Manager. Advanced->Properties than put "-m" parameter. Carefull about you have to put ";" after last parameter and put no space! I mean ";-m" (Without quotes).
Restart to SQL Server. Server will run in single mode.
Run SQLCMD.EXE as administrator. Give Sysadmin rights to your Windows user which you use at login for your SQL Server:
EXEC sp_addsrvrolemember "myserver\myuser","sysadmin";
GO
or
EXEC sp_password NULL, 'newpwd', 'sa';
GO
Don't forget delete parameter and restart server at regular mode!..
Source:
http://blogs.msdn.com/b/raulga/archive/2007/07/12/disaster-recovery-what-to-do-when-the-sa-account-password-is-lost-in-sql-server-2005.aspx
Restart to SQL Server. Server will run in single mode.
Run SQLCMD.EXE as administrator. Give Sysadmin rights to your Windows user which you use at login for your SQL Server:
EXEC sp_addsrvrolemember "myserver\myuser","sysadmin";
GO
or
EXEC sp_password NULL, 'newpwd', 'sa';
GO
Don't forget delete parameter and restart server at regular mode!..
Source:
http://blogs.msdn.com/b/raulga/archive/2007/07/12/disaster-recovery-what-to-do-when-the-sa-account-password-is-lost-in-sql-server-2005.aspx
Kaydol:
Kayıtlar (Atom)