Archive

Posts Tagged ‘SQL Server’

Reporting Server Error 1053: The service did not respond to the start or control request in a timely fashion


If you have problems starting Reporting Services, the problem may be that the service times out when trying to start.
To fix this problem follow the guide below:

1.  Click Start, click Run, type regedit, and then click OK.
2. Locate and then click the following registry subkey:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control

3. In the right pane, locate the ServicesPipeTimeout entry.

Note If the ServicesPipeTimeout entry does not exist, you must create it. To do this, follow these steps:

a. On the Edit menu, point to New, and then click DWORD Value.
b. Type ServicesPipeTimeout, and then press ENTER.
4. Right-click ServicesPipeTimeout, and then click Modify.
5. Click Decimal, type 60000, and then click OK.

This value represents the time in milliseconds before a service times out.

6. Restart the computer.

Reset SA password from Command Promt with OSQL


If SQL server is installed without an instance:
Start command promt as administrator and type the following:
osql -E
If SQL server is installed with an instance (IE. SQLExpress):
Start command promt as administrator and type the following:
osql -S (local)\SQLExpress -E
Then the following command:
sp_password NULL,’nytt passord’,’SA’
GO

%d bloggers like this: