Even though I have already published the article about the sa password recovery, this Part 2 adds some interesting stuff. This time everything is done via command line interface
We have recently migrated one of our IIS applications with SQL database on background from Windows 2003 to Windows 2008 R2. And it stopped talking to database. Same ports opened, same ODBC connector created, but no data in any fields in web application
Since I’m not a DBA, I do not remember it by heart
dump transaction <database_name> with truncate_only
dbcc shrinkdatabase(<database_name>, 10)
During the SQL Server 2008 installation on Windows 2008 Cluster the following error occurs:
There was an error setting private property ‘RequireKerberos’ to value ‘1’ for resource ‘SQL Network Name (SQL-SERVER-NAME)’. Error: Value does not fall within the expected range.
SQL Server 2000
- Login to Server using Local Administrator user
- Login to Query Analyzer using Windows Authentication.
- Use this procedure to change the SA password:sp_password null,’newpassword’,sa Read the rest of this entry »