Jan 20 2016

MsSQL Server Unknown Server Hostname Problem Solution

Category: Administration,Errors and SolutionsFatih Acar @ 12:25

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

4,467 total views, no views today

Tags: Database Administration, MsSQL Server, MsSQL Server Error and Solutions


May 26 2015

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

Category: Errors and SolutionsFatih Acar @ 13:50

Error

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

error_1053

Solution
Continue reading “SQL Server Reporting Service Start Error 1053 The Service Did Not Respond”

3,284 total views, 4 views today

Tags: MsSQL Server, MsSQL Server Error and Solutions, SQL Server Administration


Jun 05 2014

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

Category: Administration,Errors and SolutionsFatih Acar @ 09:28

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 unless these extended stored procedures are enabled regardless of the SQL Server Agent service state.

Agent XPs Possible Values

0, indicating that SQL Server Agent extended stored procedures are not available (the default).
1, indicating that SQL Server Agent extended stored procedures are available.

Show Current Value

EXEC SP_CONFIGURE ‘Agent XPs’

Reconfigure Agent XPs

EXEC SP_CONFIGURE ‘show advanced options’, 1;
GO
RECONFIGURE;
GO
SP_CONFIGURE ‘Agent XPs’, 1;
GO
RECONFIGURE
GO

After these parameter change operations you can restart agent service or sql server service to show Agent XPs enabled.

After all operations, If agent service does not start, you can try that Agent service on services.msc user change to local. That can resolve problem.

Continue reading “How to Enable Agent XPs in MsSQL Server 2008 (Agent Xps Disabled)”

189,396 total views, 10 views today

Tags: Agent XPs Disabled, Database Administration, MsSQL Server, SQL Server Administration


Feb 25 2014

Error : Cannot Open User Default Database in MsSQL Server

Category: Administration,Errors and SolutionsFatih Acar @ 17:21

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 default_database = master
2> go
3> quit

14,765 total views, 20 views today

Tags: Database Administration, MsSQL Server, SQL Server Administration