MsSQL Server Unknown Server Hostname Problem Solution

When you try to connect MsSQL Server database, you can get an error that is Unknown Server Hostname or similar sometimes. You can resolve this problem with a few operation. Suggest If you use SERVERNAME\INSTANCENAME statement, you can try SERVERNAME;instance=INSTANCENAME statement 7,537 total views, no views today

7,537 total views, no views today

SQL Server Reporting Service Start Error 1053 The Service Did Not Respond

Error Reporting Server Error 1053: The service did not respond to the start or control request in a timely fashion. Solution 5,731 total views, 4 views today

5,731 total views, 4 views today

How to Enable Agent XPs in MsSQL Server 2008 (Agent Xps Disabled)

I upgraded MsSQL database version from MsSQL Server 2008 Express Edition to MsSQL Server 2008 Enterprise Edition. After upgrade operation, Agent XPs was disabled and MsSQL Server Agent servis could not start. I reconfigured Agent XPs configuration. The problem resolved. Management Studio Object Explorer does not display the contents of the SQL Server Agent node […]

193,603 total views, no views today

Error : Cannot Open User Default Database in MsSQL Server

If you delete default database of user, users of default database can not connect to database. You have to connect with sqlcmd on master database. After you have to change default database of user. Error Cannot open user default database. Login failed. Solution Open CMD prompt C:\>sqlcmd -E -d master 1> alter login [domain\LoginUser] with […]

18,235 total views, 20 views today