1

Topic: Broad gulls on MS SQL 2014

I try to look at broad gulls (Logs) on MS SQL 2014
I come under SA in Management Studio
Control - SQL Server Log
The error jumps out

wrote:

===================================
It was not possible to obtain the data on this request. (Microsoft. SqlServer. Management. Sdk. Sfc)
------------------------------
To receive help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft SQL Server&LinkId=20476
------------------------------
Program layout:
In Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.Process (Object connectionInfo, Request request)
In Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.NavigableItemBuilderDataReader.RunQuery ()
In Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.NavigableItemBuilderDataReader.Process ()
In Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.NavigableItemBuilderDataReader.get_PropertyNames ()
In Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItemWithQuery (IList ` 1 nodes, INodeInformation source, INavigableItem sourceItem, String urnQuery, Boolean registerBuilder, Boolean registerBuiltItems)
In Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItem (IList ` 1 nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider filter)
In Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.Build (IList ` 1 nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider filter)
In Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.RequestChildren (IGetChildrenRequest request)
In Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ExplorerHierarchyNode.BuildChildren (WaitHandle quitEvent)
===================================
At instruction or packet Transact-SQL performance there was an exception. (Microsoft. SqlServer. ConnectionInfo)
------------------------------
Program layout:
In Microsoft.SqlServer.Management.Common.ServerConnection.GetExecuteReader (SqlCommand command)
In Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteReader (String sqlCommand, SqlCommand& command)
In Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataReader (String query, SqlCommand& command)
In Microsoft.SqlServer.Management.Smo.DataProvider.SetConnectionAndQuery (ExecuteSql execSql, String query)
In Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider (StringCollection query, Object con, StatementBuilder sb, RetriveMode rm)
In Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillData (ResultType resultType, StringCollection sql, Object connectionInfo, StatementBuilder sb)
In Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillDataWithUseFailure (SqlEnumResult sqlresult, ResultType resultType)
In Microsoft.SqlServer.Management.Smo.SqlObjectBase.BuildResult (EnumResult result)
In Microsoft.SqlServer.Management.Smo.SqlObjectBase.GetData (EnumResult erParent)
In Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData ()
In Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData (Request req, Object ci)
In Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.GetData (Object connectionInfo, Request request)
In Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.Process (Object connectionInfo, Request request)
===================================
At performance of a current command there was a hard error. In the presence of results they should be voided. (.Net SqlClient Data Provider)
------------------------------
To receive help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft SQL Server&ProdVer=12.00.2000&EvtSrc=MSSQLServer&EvtID=0&LinkId=20476
------------------------------
Server name: (local)
Error number: 0
Gravity: 11
State: 0
------------------------------
Program layout:
In Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql (ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
In Microsoft.SqlServer.Management.Common.ServerConnection.GetExecuteReader (SqlCommand command)

I can not understand - that does not suffice it?

2

Re: Broad gulls on MS SQL 2014

And it is simple xp_readerrorlog plows?
If yes, studio troubles.
The studio version what? a servers?

3

Re: Broad gulls on MS SQL 2014

o-o wrote:

and it is simple xp_readerrorlog plows?

?

o-o wrote:

the studio version what? a servers?

MS SQL 2014
Microsoft SQL Server Management Studio, 12.0.2000.8
Client means of services of Microsoft Analysis Services, 12.0.2000.8
Data access components (MDAC), 6.1.7601.17514
Microsoft MSXML, 3.0 5.0 6.0
Microsoft Internet Explorer, 9.11.9600.18097
. NET FRAMEWORK Microsoft, 4.0.30319.34209
Operating system, 6.1.7601

4

Re: Broad gulls on MS SQL 2014

And how to launch xp_readerrorlog directly?

5

Re: Broad gulls on MS SQL 2014

982183 wrote:

And how to launch xp_readerrorlog directly?

Open window Query Window, in it type xp_readerrorlog, press F5

6

Re: Broad gulls on MS SQL 2014

982183 wrote:

it is passed...
?
it is passed...
MS SQL 2014
Microsoft SQL Server Management Studio, 12.0.2000.8
Client means of services of Microsoft Analysis Services, 12.0.2000.8
Data access components (MDAC), 6.1.7601.17514
Microsoft MSXML, 3.0 5.0 6.0
Microsoft Internet Explorer, 9.11.9600.18097
. NET FRAMEWORK Microsoft, 4.0.30319.34209
Operating system, 6.1.7601

Where the server version?
Publish result select @@ version

7

Re: Broad gulls on MS SQL 2014

wrote:

the Message 22004, level 16, a state 1, a line 0
It was not possible to open connection with closing on itself. Additional convergence see in the event log.
The message 22004, level 16, state 1, line 0
Error log layout is not found.

8

Re: Broad gulls on MS SQL 2014

982183 wrote:

it is passed...

1. To open  pens (notepad) and to read there errors
2. To publish already the server version,  RTM

9

Re: Broad gulls on MS SQL 2014

o-o wrote:

where the server version?
Publish result select @@ version

Microsoft SQL Server 2014 - 12.0.2000.8 (INTELS X86)
Feb 20 2014 7:20:46 PM
Copyright (c) Microsoft Corporation
Express Edition on Windows NT 6.1 <X86> (Build 7601: Service Pack 1)

10

Re: Broad gulls on MS SQL 2014

o-o wrote:

1. To open  pens (notepad) and to read there errors

And it is valid...
That I a nonsense suffer.

11

Re: Broad gulls on MS SQL 2014

982183 wrote:

it is passed...
Microsoft SQL Server 2014 - 12.0.2000.8 (INTELS X86)
Feb 20 2014 7:20:46 PM
Copyright (c) Microsoft Corporation
Express Edition on Windows NT 6.1 <X86> (Build 7601: Service Pack 1)

So RTM.
That studio that the server.
Though problems at the server.
SP2 For a long time quitted
-----
And in  that?

12

Re: Broad gulls on MS SQL 2014

Fresh anything is not present in
From the recent

wrote:

2017-09-27 09:50:33.51 spid66 Attempting to load library ' xpstar.dll ' into memory. This is an informational message only. No user action is required.
2017-09-27 09:50:33.79 spid66 Using ' xpstar.dll ' version ' 2014.120.2000 ' to execute extended stored procedure ' xp_enumerrorlogs'. This is an informational message only; no user action is required.
2017-09-27 10:06:35.17 spid71 Attempting to load library ' xplog70.dll ' into memory. This is an informational message only. No user action is required.
2017-09-27 10:06:35.22 spid71 Using ' xplog70.dll ' version ' 2014.120.2000 ' to execute extended stored procedure ' xp_msver '. This is an informational message only; no user action is required.

13

Re: Broad gulls on MS SQL 2014

In the event log
,,,,,,,, log, the Process identifier, the Identifier of a mail element, the security account Identifier, change Date, It is changed
09/27/2017 11:11:36, MSSQLSERVER, the Error, Identifier declaration of event 17052 from source MSSQLSERVER it is not found. Or the component <c/> caused event <c/> is installed not on the local computer <c/> or setting is damaged. Install or  a component on the local computer., (2), 17052, server3;

14

Re: Broad gulls on MS SQL 2014

09/27/2017 11:11:36 AM
,MSSQLSERVER
,Error
,Identifier declaration of event 17052 from source MSSQLSERVER is not found. Or the component <c/> caused event <c/> is installed not on the local computer <c/> or setting is damaged. Install or  a component on the local computer
.,(2)
,17052

15

Re: Broad gulls on MS SQL 2014

Saw. The data is, but the system cannot simply "visualize" them.
Gave a command on update.
Let's look that turns out.

16

Re: Broad gulls on MS SQL 2014

982183 wrote:

Fresh anything is not present in
From the recent
it is passed...

Give already last lines, instead of as it there dll sinkers.
And your server  it is necessary, I speak, SP2 for a long time after it cries

17

Re: Broad gulls on MS SQL 2014

Is not present further anything except Starting UP database

18

Re: Broad gulls on MS SQL 2014

o-o wrote:

and your server  it is necessary, I speak, SP2 for a long time after it cries

Yes not mine it.
I with 2008 yet tears.
And this without supervision of year two stood.

19

Re: Broad gulls on MS SQL 2014

982183;
Well so  not the, he to you tells thanks.
Problems are not present with the rights.
Time  climb from studio to look;
Means sysadmin.
For first of all sp_readerrorlog checks membership in system administrators

20

Re: Broad gulls on MS SQL 2014

Yes I heard about SP2 c the big.
Already gave a command to the responsible person.
It is necessary to coordinate with the developer of an application-oriented software,  on the doubler, to select a window.
.

21

Re: Broad gulls on MS SQL 2014

o-o wrote:

it is passed...
So RTM.

And unless not SP1?

22

Re: Broad gulls on MS SQL 2014

Saw
Really 12.0.2000.8 RTM
Whence then (Build 7601: Service Pack 1)
Or it SP to Build

23

Re: Broad gulls on MS SQL 2014

982183 wrote:

Saw
Really 12.0.2000.8 RTM
Whence then (Build 7601: Service Pack 1)
Or it SP to Build

It to Windows

24

Re: Broad gulls on MS SQL 2014

982183;
It already windows

25

Re: Broad gulls on MS SQL 2014

It was updated.
Did not help.