Login failed for user '(null)'

I'm getting the following error:
An error has occurred during report processing.
Cannot create a connection to data source 'MyReports-ReportServer-PHX'.
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
This is only for data sources that use integrated authenticaiton. This is
on a fresh install of SQL Server 2005 and Reporting Services 2005 using
Visual Studio 2005. Per several articles/disuccsions, I've configured IIS
directory secruity to NOT allow anonymous access and to allow the Integrated
Windows Authentication exactly as I have on my other database server. This
is Windows Server 2003 IIS 6.0 and my other server is Windows 2000, IIS 5.0.
Any help would be GREATLY appreciated. Does this have something to do with
the IIS_WPG group not having correct permissions? The users do have the
correct permissions in my environment.Here's the stack trace as well from the reporting services error log...lots
of errors about the connection pool?
-- End of inner exception stack trace --
w3wp!webserver!1!01/24/2006-15:04:38:: e ERROR: Reporting Services error
Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has
occurred during report processing. -->
Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An
error has occurred during report processing. -->
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
Cannot create a connection to data source 'MyReports-ReportServer-PHX'. -->
System.Data.SqlClient.SqlException: Login failed for user '(null)'. Reason:
Not associated with a trusted SQL Server connection.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean
enlistOK)
at
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection
owningObject, SqlConnectionString connectionOptions, String newPassword,
Boolean redirectedUserInstance)
at
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity
identity, SqlConnectionString connectionOptions, Object providerInfo, String
newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions
options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection
owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper.Open()
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ReportRuntimeDataSourceNode.OpenConnection(DataSource
dataSourceObj, ReportProcessingContext pc)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ReportRuntimeDataSourceNode.Process()
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSourceNode.ProcessConcurrent(Object threadSet)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessingContext.AbortHelper.ThrowAbortException(Int32 reportUniqueName)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessingContext.CheckAndThrowIfAborted()
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.Merge.Process(ParameterInfoCollection parameters, Boolean mergeTran)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessReport(Report report, ProcessingContext pc, ProcessingContext context)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessReport(Report
report, ProcessingContext pc, Boolean snapshotProcessing, Boolean
processWithCachedData, GetReportChunk getChunkCallback, ErrorContext
errorContext, DateTime executionTime, CreateReportChunk cacheDataCallback,
ProcessingContext& context)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension
renderer, DateTime executionTimeStamp, GetReportChunk
getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc,
CreateReportChunk cacheDataCallback, Boolean& dataCached)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime
executionTimeStamp, GetReportChunk getCompiledDefinitionCallback,
ProcessingContext pc, RenderingContext rc)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext
reportContext, ItemProperties properties, ParameterInfoCollection
effectiveParameters, Guid reportId, ClientRequest session, String
description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection
thisReportDataSources, Boolean cachingRequested, Warning[]& warnings,
ReportSnapshot& resultSnapshotData, DateTime& executionDateTime,
RuntimeDataSourceInfoCollection& alldataSources, UserProfileState&
usedUserProfile)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
rs, CatalogItemContext reportContext, ClientRequest session, JobType type,
Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]&
secondaryStreamNames)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()

Login failed for user '<<domain>>\<<server>>$'.

I am working on asp application which basically is an interface to the report server. I am currently unable to determine the source of the problem so it may have nothing to do with reporting services.

Currently the back in off this application consists of a reports and web server on a machine named tango and a SQL database server on a machine named tango.

The SQL logs show a failed login for user organization\polo$ (organization is a made up domain as i don’t what to give away where I work). There is no logon in SQL for the user polo$ and as far as I can see there is no user polo$ in the domain.

Has anyone seen this before? Can anyone account for the user polo$?

Could this be caused by reporting services trying to login to the two databases (ReportServer, ReportServerTempDB) that reporting services needs. These to databases are not on the report server. They are on tango.

Thanks in advanced

Is there a computer in the domain with the name "polo"? Network resources are accessed using the ASP.NET machine account on Windows Server 2003(BUILTIN\Network Service). The machine account name is DOMAIN\ComputerName$. The $ at the end hides it in normal views.

|||polo is the web/report server for the application.|||DOMAIN\polo$ is the name of the machine account for the web/report server. You need to grant access to ReportServer and ReportServerTempDB to DOMAIN\polo$.|||

Where can I get more information on this asp.net machine account? I don’t understand why it would be trying to access the database.

Secondly when I give it access to the database other user accounts stop working. It is like the asp.net machine account took precedence over the permissions I had set for a normal user.

|||This article (http://www.awprofessional.com/articles/article.asp?p=357694&seqNum=2&rl=1) explains the accounts that various Reporting Services components run under on Windows 2000 Server, Windows XP, and Windows Server 2003. I suspect that you selected service account for accessing the SQL Server hosting the Reporting Services databases. You can change that option to a domain account using the rsconfig utility from the command line.|||

I was after information on SQL and ASP.NET machine account.

Because as I give the ASP.NET machine account access to the databases other user accounts stop working. It is like the ASP.NET machine account took precedence over the permissions I had set for other users.

Is this behavior normal for the ASP.NET Machine account.

|||I've honestly never seen other logins stop working when you enable the machine account. SQL Server just sees the incoming access token (DOMAIN\pogo$, DOMAIN\MyName, or whatever) and grants the appropriate permissions. Adding a user shouldn't affect the permissions for other users. Can you query using Query Analyzer and/or Enterprise Manager? Both those tools would be running under your current account. What exactly do you mean when you say the other user accounts stop working? What is the exact error message that you receive both before and after adding the DOMAIN\pogo$ account?|||After giving the machine account access to all stored procedures and databases...
Our application threw a stored procedure can not be executed user has insuffiecent privleages or something like that. When looking at the stored procedure the user did have premission to execute the stored procedure in question.

What im intersted in finding out though is why when i create a connection in my asp.net code do i get 2 logins occur One of the asp.net machine account and one of the user i am impersonating. In the sql error logs i get a login failure for the asp.net machine account. I want to know why the asp.net machine account is tyring to log on to sql in the first place when the asp.net application is impersonating a diffrent user.

I see you have read my other post at http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=66810. Which pretty much explain what i have just said. Please write all posts concerning this problem into the above mentioned thread. Thanks for you help so far.

I dont belive this to be a reporting services error anymore.

Regards

Dean Dalby

Login box when starting Report Builder

I'm new in SSRS so hopefully this will be an easy question.

I want to create a report model based on a cube. I have created a data source for the cube. Now when I click on Report Builder I get a login box titled "Microsoft Report Server Login".

When I enter the local admin account and password I get:

No report server was found at http://crossdatabase/ReportServer

When I enter that URL in IE I get:

crossdatabase/ReportServer - /

---

zondag 16 september 2007 23:24 <ds> Crossdatabase

Microsoft SQL Server Reporting Services Version 9.00.1399.00 What am I doing wrong? I already found some explanation about adding the Report Builder role so in home I now have:

EditBUILTIN\AdministratorsContent Manager, Report Builder

Anyone got any ideas?
Thanks,Stijn Verrept.

Please review the link below and let us know if this fixes your issue.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1697246&SiteID=1

|||I won't have access to the machine till later on, but this post is about users not seeing the Report Builder button. I'm admin, I see the button but when I click it I get the login box.|||

I tried but still get the same login box after clicking on the Report Builder button.

This is the login box that I get:

http://www.caresolutions.be/login.jpg

|||

According to your log above, you are running SQL Server 2005 RTM (Version 9.00.1399.00 ). You need to apply Service Pack 2 which should get you to Version 9.00.3042.00 and may fix your problem.

|||

This indeed fixed my problem, I now have another one however, but I'll post this in a new thread. Thanks.

Logging NT Events

Hi,
Is it possbile to retrieve all the Event Id's of a registerd source
(Ex. MSSQLSERVER)? If it possible then can we retrieve the description
of those Event Id's and can we generate the NT Event with the above NT
Event and the desc for that?
Some how I retrieve all the Event Id's of SQL Server application and
then for each Event ID retrieve the Event Id Description and gererate
the same NT Event.
SMGENIE.EXE from MS Resource kit do the same.
Can anyone please let me know if its possible.
Thanks in advance,
Regards,
PramodHi
You don't say which version of SQL server you are using! With SQL 2005 you
can use SSIS to do this, alternatively you could write your own WMI scripts
or write your own xp.
To write to the event log you can use xp_logevent, or the LOG option of
RAISERROR, but you will not have a great deal flexibility.
John
"ipramod@.gmail.com" wrote:
> Hi,
> Is it possbile to retrieve all the Event Id's of a registerd source
> (Ex. MSSQLSERVER)? If it possible then can we retrieve the description
> of those Event Id's and can we generate the NT Event with the above NT
> Event and the desc for that?
>
> Some how I retrieve all the Event Id's of SQL Server application and
> then for each Event ID retrieve the Event Id Description and gererate
> the same NT Event.
>
> SMGENIE.EXE from MS Resource kit do the same.
>
> Can anyone please let me know if its possible.
>
> Thanks in advance,
> Regards,
> Pramod
>|||Hi John,
I am using SQL Server 2000. Is there any WMI Class that gives all the
event Id's and their description?
Thanks for replying,
Regards,
Pramod Ingle
John Bell wrote:
> Hi
> You don't say which version of SQL server you are using! With SQL 2005 you
> can use SSIS to do this, alternatively you could write your own WMI scripts
> or write your own xp.
> To write to the event log you can use xp_logevent, or the LOG option of
> RAISERROR, but you will not have a great deal flexibility.
> John
> "ipramod@.gmail.com" wrote:
> > Hi,
> >
> > Is it possbile to retrieve all the Event Id's of a registerd source
> > (Ex. MSSQLSERVER)? If it possible then can we retrieve the description
> > of those Event Id's and can we generate the NT Event with the above NT
> > Event and the desc for that?
> >
> >
> > Some how I retrieve all the Event Id's of SQL Server application and
> > then for each Event ID retrieve the Event Id Description and gererate
> > the same NT Event.
> >
> >
> > SMGENIE.EXE from MS Resource kit do the same.
> >
> >
> > Can anyone please let me know if its possible.
> >
> >
> > Thanks in advance,
> > Regards,
> > Pramod
> >
> >|||Hi
You may want to start from these examples:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/wmi_tasks__event_logs.asp
John
"ipramod@.gmail.com" wrote:
> Hi John,
> I am using SQL Server 2000. Is there any WMI Class that gives all the
> event Id's and their description?
> Thanks for replying,
> Regards,
> Pramod Ingle
>
> John Bell wrote:
> > Hi
> >
> > You don't say which version of SQL server you are using! With SQL 2005 you
> > can use SSIS to do this, alternatively you could write your own WMI scripts
> > or write your own xp.
> >
> > To write to the event log you can use xp_logevent, or the LOG option of
> > RAISERROR, but you will not have a great deal flexibility.
> >
> > John
> >
> > "ipramod@.gmail.com" wrote:
> >
> > > Hi,
> > >
> > > Is it possbile to retrieve all the Event Id's of a registerd source
> > > (Ex. MSSQLSERVER)? If it possible then can we retrieve the description
> > > of those Event Id's and can we generate the NT Event with the above NT
> > > Event and the desc for that?
> > >
> > >
> > > Some how I retrieve all the Event Id's of SQL Server application and
> > > then for each Event ID retrieve the Event Id Description and gererate
> > > the same NT Event.
> > >
> > >
> > > SMGENIE.EXE from MS Resource kit do the same.
> > >
> > >
> > > Can anyone please let me know if its possible.
> > >
> > >
> > > Thanks in advance,
> > > Regards,
> > > Pramod
> > >
> > >
>|||Hi John,
The link you specified does not indicate how to get all event id's of a
registered source and also does not specify how to write events.
Thanks for your suggestion. Expecting more help :-)
Regards
Pramod
John Bell wrote:
> Hi
> You may want to start from these examples:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/wmi_tasks__event_logs.asp
> John
> "ipramod@.gmail.com" wrote:
> > Hi John,
> >
> > I am using SQL Server 2000. Is there any WMI Class that gives all the
> > event Id's and their description?
> >
> > Thanks for replying,
> > Regards,
> > Pramod Ingle
> >
> >
> > John Bell wrote:
> > > Hi
> > >
> > > You don't say which version of SQL server you are using! With SQL 2005 you
> > > can use SSIS to do this, alternatively you could write your own WMI scripts
> > > or write your own xp.
> > >
> > > To write to the event log you can use xp_logevent, or the LOG option of
> > > RAISERROR, but you will not have a great deal flexibility.
> > >
> > > John
> > >
> > > "ipramod@.gmail.com" wrote:
> > >
> > > > Hi,
> > > >
> > > > Is it possbile to retrieve all the Event Id's of a registerd source
> > > > (Ex. MSSQLSERVER)? If it possible then can we retrieve the description
> > > > of those Event Id's and can we generate the NT Event with the above NT
> > > > Event and the desc for that?
> > > >
> > > >
> > > > Some how I retrieve all the Event Id's of SQL Server application and
> > > > then for each Event ID retrieve the Event Id Description and gererate
> > > > the same NT Event.
> > > >
> > > >
> > > > SMGENIE.EXE from MS Resource kit do the same.
> > > >
> > > >
> > > > Can anyone please let me know if its possible.
> > > >
> > > >
> > > > Thanks in advance,
> > > > Regards,
> > > > Pramod
> > > >
> > > >
> >
> >|||Hi
The last example show you almost everything that you need to do, it is not a
great step to work out how to limit the sourcename by changing the where
clause in the query or specifying specific EventCode values. If you can't
then the following explains how to use WQL
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/querying_with_wql.asp
See also
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/win32_nteventlogfile.asp
for more information on what the Win32_NTLogEvent class contains
"ipramod@.gmail.com" wrote:
> Hi John,
> The link you specified does not indicate how to get all event id's of a
> registered source and also does not specify how to write events.
> Thanks for your suggestion. Expecting more help :-)
> Regards
> Pramod
>
>
> John Bell wrote:
> > Hi
> >
> > You may want to start from these examples:
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/wmi_tasks__event_logs.asp
> >
> > John
> >
> > "ipramod@.gmail.com" wrote:
> >
> > > Hi John,
> > >
> > > I am using SQL Server 2000. Is there any WMI Class that gives all the
> > > event Id's and their description?
> > >
> > > Thanks for replying,
> > > Regards,
> > > Pramod Ingle
> > >
> > >
> > > John Bell wrote:
> > > > Hi
> > > >
> > > > You don't say which version of SQL server you are using! With SQL 2005 you
> > > > can use SSIS to do this, alternatively you could write your own WMI scripts
> > > > or write your own xp.
> > > >
> > > > To write to the event log you can use xp_logevent, or the LOG option of
> > > > RAISERROR, but you will not have a great deal flexibility.
> > > >
> > > > John
> > > >
> > > > "ipramod@.gmail.com" wrote:
> > > >
> > > > > Hi,
> > > > >
> > > > > Is it possbile to retrieve all the Event Id's of a registerd source
> > > > > (Ex. MSSQLSERVER)? If it possible then can we retrieve the description
> > > > > of those Event Id's and can we generate the NT Event with the above NT
> > > > > Event and the desc for that?
> > > > >
> > > > >
> > > > > Some how I retrieve all the Event Id's of SQL Server application and
> > > > > then for each Event ID retrieve the Event Id Description and gererate
> > > > > the same NT Event.
> > > > >
> > > > >
> > > > > SMGENIE.EXE from MS Resource kit do the same.
> > > > >
> > > > >
> > > > > Can anyone please let me know if its possible.
> > > > >
> > > > >
> > > > > Thanks in advance,
> > > > > Regards,
> > > > > Pramod
> > > > >
> > > > >
> > >
> > >
>|||Thanks John,
Actually I want to write SQLServer events to Application Log. Is there
any way to that?
Regards,
Pramod
John Bell wrote:
> Hi
> The last example show you almost everything that you need to do, it is not a
> great step to work out how to limit the sourcename by changing the where
> clause in the query or specifying specific EventCode values. If you can't
> then the following explains how to use WQL
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/querying_with_wql.asp
> See also
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/win32_nteventlogfile.asp
> for more information on what the Win32_NTLogEvent class contains
> "ipramod@.gmail.com" wrote:
> > Hi John,
> >
> > The link you specified does not indicate how to get all event id's of a
> > registered source and also does not specify how to write events.
> >
> > Thanks for your suggestion. Expecting more help :-)
> >
> > Regards
> > Pramod
> >
> >
> >
> >
> > John Bell wrote:
> > > Hi
> > >
> > > You may want to start from these examples:
> > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/wmi_tasks__event_logs.asp
> > >
> > > John
> > >
> > > "ipramod@.gmail.com" wrote:
> > >
> > > > Hi John,
> > > >
> > > > I am using SQL Server 2000. Is there any WMI Class that gives all the
> > > > event Id's and their description?
> > > >
> > > > Thanks for replying,
> > > > Regards,
> > > > Pramod Ingle
> > > >
> > > >
> > > > John Bell wrote:
> > > > > Hi
> > > > >
> > > > > You don't say which version of SQL server you are using! With SQL 2005 you
> > > > > can use SSIS to do this, alternatively you could write your own WMI scripts
> > > > > or write your own xp.
> > > > >
> > > > > To write to the event log you can use xp_logevent, or the LOG option of
> > > > > RAISERROR, but you will not have a great deal flexibility.
> > > > >
> > > > > John
> > > > >
> > > > > "ipramod@.gmail.com" wrote:
> > > > >
> > > > > > Hi,
> > > > > >
> > > > > > Is it possbile to retrieve all the Event Id's of a registerd source
> > > > > > (Ex. MSSQLSERVER)? If it possible then can we retrieve the description
> > > > > > of those Event Id's and can we generate the NT Event with the above NT
> > > > > > Event and the desc for that?
> > > > > >
> > > > > >
> > > > > > Some how I retrieve all the Event Id's of SQL Server application and
> > > > > > then for each Event ID retrieve the Event Id Description and gererate
> > > > > > the same NT Event.
> > > > > >
> > > > > >
> > > > > > SMGENIE.EXE from MS Resource kit do the same.
> > > > > >
> > > > > >
> > > > > > Can anyone please let me know if its possible.
> > > > > >
> > > > > >
> > > > > > Thanks in advance,
> > > > > > Regards,
> > > > > > Pramod
> > > > > >
> > > > > >
> > > >
> > > >
> >
> >|||Hi
Have you looked at RAISERROR or xp_logevent? Failing that you could call
xp_cmdshell with the a script that takes parameters.
John
"ipramod@.gmail.com" wrote:
> Thanks John,
> Actually I want to write SQLServer events to Application Log. Is there
> any way to that?
> Regards,
> Pramod
> John Bell wrote:
> > Hi
> >
> > The last example show you almost everything that you need to do, it is not a
> > great step to work out how to limit the sourcename by changing the where
> > clause in the query or specifying specific EventCode values. If you can't
> > then the following explains how to use WQL
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/querying_with_wql.asp
> >
> > See also
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/win32_nteventlogfile.asp
> > for more information on what the Win32_NTLogEvent class contains
> >
> > "ipramod@.gmail.com" wrote:
> >
> > > Hi John,
> > >
> > > The link you specified does not indicate how to get all event id's of a
> > > registered source and also does not specify how to write events.
> > >
> > > Thanks for your suggestion. Expecting more help :-)
> > >
> > > Regards
> > > Pramod
> > >
> > >
> > >
> > >
> > > John Bell wrote:
> > > > Hi
> > > >
> > > > You may want to start from these examples:
> > > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/wmi_tasks__event_logs.asp
> > > >
> > > > John
> > > >
> > > > "ipramod@.gmail.com" wrote:
> > > >
> > > > > Hi John,
> > > > >
> > > > > I am using SQL Server 2000. Is there any WMI Class that gives all the
> > > > > event Id's and their description?
> > > > >
> > > > > Thanks for replying,
> > > > > Regards,
> > > > > Pramod Ingle
> > > > >
> > > > >
> > > > > John Bell wrote:
> > > > > > Hi
> > > > > >
> > > > > > You don't say which version of SQL server you are using! With SQL 2005 you
> > > > > > can use SSIS to do this, alternatively you could write your own WMI scripts
> > > > > > or write your own xp.
> > > > > >
> > > > > > To write to the event log you can use xp_logevent, or the LOG option of
> > > > > > RAISERROR, but you will not have a great deal flexibility.
> > > > > >
> > > > > > John
> > > > > >
> > > > > > "ipramod@.gmail.com" wrote:
> > > > > >
> > > > > > > Hi,
> > > > > > >
> > > > > > > Is it possbile to retrieve all the Event Id's of a registerd source
> > > > > > > (Ex. MSSQLSERVER)? If it possible then can we retrieve the description
> > > > > > > of those Event Id's and can we generate the NT Event with the above NT
> > > > > > > Event and the desc for that?
> > > > > > >
> > > > > > >
> > > > > > > Some how I retrieve all the Event Id's of SQL Server application and
> > > > > > > then for each Event ID retrieve the Event Id Description and gererate
> > > > > > > the same NT Event.
> > > > > > >
> > > > > > >
> > > > > > > SMGENIE.EXE from MS Resource kit do the same.
> > > > > > >
> > > > > > >
> > > > > > > Can anyone please let me know if its possible.
> > > > > > >
> > > > > > >
> > > > > > > Thanks in advance,
> > > > > > > Regards,
> > > > > > > Pramod
> > > > > > >
> > > > > > >
> > > > >
> > > > >
> > >
> > >
>|||No, can you give me the link
Regards,
Pramod
John Bell wrote:
> Hi
> Have you looked at RAISERROR or xp_logevent? Failing that you could call
> xp_cmdshell with the a script that takes parameters.
> John
> "ipramod@.gmail.com" wrote:
> > Thanks John,
> >
> > Actually I want to write SQLServer events to Application Log. Is there
> > any way to that?
> >
> > Regards,
> > Pramod
> >
> > John Bell wrote:
> > > Hi
> > >
> > > The last example show you almost everything that you need to do, it is not a
> > > great step to work out how to limit the sourcename by changing the where
> > > clause in the query or specifying specific EventCode values. If you can't
> > > then the following explains how to use WQL
> > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/querying_with_wql.asp
> > >
> > > See also
> > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/win32_nteventlogfile.asp
> > > for more information on what the Win32_NTLogEvent class contains
> > >
> > > "ipramod@.gmail.com" wrote:
> > >
> > > > Hi John,
> > > >
> > > > The link you specified does not indicate how to get all event id's of a
> > > > registered source and also does not specify how to write events.
> > > >
> > > > Thanks for your suggestion. Expecting more help :-)
> > > >
> > > > Regards
> > > > Pramod
> > > >
> > > >
> > > >
> > > >
> > > > John Bell wrote:
> > > > > Hi
> > > > >
> > > > > You may want to start from these examples:
> > > > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/wmi_tasks__event_logs.asp
> > > > >
> > > > > John
> > > > >
> > > > > "ipramod@.gmail.com" wrote:
> > > > >
> > > > > > Hi John,
> > > > > >
> > > > > > I am using SQL Server 2000. Is there any WMI Class that gives all the
> > > > > > event Id's and their description?
> > > > > >
> > > > > > Thanks for replying,
> > > > > > Regards,
> > > > > > Pramod Ingle
> > > > > >
> > > > > >
> > > > > > John Bell wrote:
> > > > > > > Hi
> > > > > > >
> > > > > > > You don't say which version of SQL server you are using! With SQL 2005 you
> > > > > > > can use SSIS to do this, alternatively you could write your own WMI scripts
> > > > > > > or write your own xp.
> > > > > > >
> > > > > > > To write to the event log you can use xp_logevent, or the LOG option of
> > > > > > > RAISERROR, but you will not have a great deal flexibility.
> > > > > > >
> > > > > > > John
> > > > > > >
> > > > > > > "ipramod@.gmail.com" wrote:
> > > > > > >
> > > > > > > > Hi,
> > > > > > > >
> > > > > > > > Is it possbile to retrieve all the Event Id's of a registerd source
> > > > > > > > (Ex. MSSQLSERVER)? If it possible then can we retrieve the description
> > > > > > > > of those Event Id's and can we generate the NT Event with the above NT
> > > > > > > > Event and the desc for that?
> > > > > > > >
> > > > > > > >
> > > > > > > > Some how I retrieve all the Event Id's of SQL Server application and
> > > > > > > > then for each Event ID retrieve the Event Id Description and gererate
> > > > > > > > the same NT Event.
> > > > > > > >
> > > > > > > >
> > > > > > > > SMGENIE.EXE from MS Resource kit do the same.
> > > > > > > >
> > > > > > > >
> > > > > > > > Can anyone please let me know if its possible.
> > > > > > > >
> > > > > > > >
> > > > > > > > Thanks in advance,
> > > > > > > > Regards,
> > > > > > > > Pramod
> > > > > > > >
> > > > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> >
> >|||Hi
Both are documented in Books Online.
John
"ipramod@.gmail.com" wrote:
> No, can you give me the link
> Regards,
> Pramod
>
> John Bell wrote:
> > Hi
> >
> > Have you looked at RAISERROR or xp_logevent? Failing that you could call
> > xp_cmdshell with the a script that takes parameters.
> >
> > John
> >
> > "ipramod@.gmail.com" wrote:
> >
> > > Thanks John,
> > >
> > > Actually I want to write SQLServer events to Application Log. Is there
> > > any way to that?
> > >
> > > Regards,
> > > Pramod
> > >
> > > John Bell wrote:
> > > > Hi
> > > >
> > > > The last example show you almost everything that you need to do, it is not a
> > > > great step to work out how to limit the sourcename by changing the where
> > > > clause in the query or specifying specific EventCode values. If you can't
> > > > then the following explains how to use WQL
> > > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/querying_with_wql.asp
> > > >
> > > > See also
> > > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/win32_nteventlogfile.asp
> > > > for more information on what the Win32_NTLogEvent class contains
> > > >
> > > > "ipramod@.gmail.com" wrote:
> > > >
> > > > > Hi John,
> > > > >
> > > > > The link you specified does not indicate how to get all event id's of a
> > > > > registered source and also does not specify how to write events.
> > > > >
> > > > > Thanks for your suggestion. Expecting more help :-)
> > > > >
> > > > > Regards
> > > > > Pramod
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > John Bell wrote:
> > > > > > Hi
> > > > > >
> > > > > > You may want to start from these examples:
> > > > > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/wmi_tasks__event_logs.asp
> > > > > >
> > > > > > John
> > > > > >
> > > > > > "ipramod@.gmail.com" wrote:
> > > > > >
> > > > > > > Hi John,
> > > > > > >
> > > > > > > I am using SQL Server 2000. Is there any WMI Class that gives all the
> > > > > > > event Id's and their description?
> > > > > > >
> > > > > > > Thanks for replying,
> > > > > > > Regards,
> > > > > > > Pramod Ingle
> > > > > > >
> > > > > > >
> > > > > > > John Bell wrote:
> > > > > > > > Hi
> > > > > > > >
> > > > > > > > You don't say which version of SQL server you are using! With SQL 2005 you
> > > > > > > > can use SSIS to do this, alternatively you could write your own WMI scripts
> > > > > > > > or write your own xp.
> > > > > > > >
> > > > > > > > To write to the event log you can use xp_logevent, or the LOG option of
> > > > > > > > RAISERROR, but you will not have a great deal flexibility.
> > > > > > > >
> > > > > > > > John
> > > > > > > >
> > > > > > > > "ipramod@.gmail.com" wrote:
> > > > > > > >
> > > > > > > > > Hi,
> > > > > > > > >
> > > > > > > > > Is it possbile to retrieve all the Event Id's of a registerd source
> > > > > > > > > (Ex. MSSQLSERVER)? If it possible then can we retrieve the description
> > > > > > > > > of those Event Id's and can we generate the NT Event with the above NT
> > > > > > > > > Event and the desc for that?
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > Some how I retrieve all the Event Id's of SQL Server application and
> > > > > > > > > then for each Event ID retrieve the Event Id Description and gererate
> > > > > > > > > the same NT Event.
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > SMGENIE.EXE from MS Resource kit do the same.
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > Can anyone please let me know if its possible.
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > Thanks in advance,
> > > > > > > > > Regards,
> > > > > > > > > Pramod
> > > > > > > > >
> > > > > > > > >
> > > > > > >
> > > > > > >
> > > > >
> > > > >
> > >
> > >
>