Feedback on Report Customization requirements

Hello,
I would like to get some feedback from the users/customers of SQL Server
Reporting Services and other reporting technologies on common customization
requirements for reports.
Let's assume that you have purchased a customizable business/ERP application
from an Independent Solution Vendor and that the application contains a
number of built in reports. Alternatively you could be a consultant/vendor
who customizes applications to suit specific customer requirements.
What are the common types of customizations that you are likely to implement
(or have implemented in such scenarios) on the base set of reports to tailor
them to suit your/your customer requirements prior to deploying the app in
your environment?
Some examples of customizations are:
a) Adding additional fields to a report
b) Adding additional data regions to a report (Example: Adding an Employee
Sales summary chart to an Employee details report)
c) Replacing a data region with an alternate data region (Example: Replacing
a matrix report that displays product category sales by Year with a chart
that plots Sales figures using Product Category as the Category group and
Year as the Series group)
d) Enhancing a data region (Example: Adding addition row/column groupings to
a matrix report and enabling drill down functionality)
etc...
Looking forward to hearing some feedback on this topic.
Thanks
KarthikI think the top three reasons our users want to customize the standard
reports they receive as part of the software are:
1) They want to add additional fields. Sometimes these fields are returned
by the stored procedure the report's using to gather its data, sometimes
they're not. In the case that they're not, our users are often unsuccessful
at finding where the data they need is in the database and how to do the
proper joins to get it. If the data they need repeats it's even more complex
for them to implement.
2) They want to modify the sorting, grouping, or filtering of the report.
Right now we're using Crystal Reports for our reporting product, though
we're strongly considering moving to SQL Reporting Services due to the many
problems we've had with Crystal. If users have had Crystal Reports training
they can usually modify the sort and filter criteria (though the filtering
would likely be a less efficient client-side filter rather than changing the
stored procedure), but changing the grouping is a more advanced topic that's
a little trickier to understand.
My feeling is that finding the commands for changing the sorting and
filtering in SQL Reporting Services is currently not as straightforward as
an in Crystal, mostly due to the free-form layout vs. banded report writer
paradigm shift. Grouping seems about the same in both environments. More
wizards or putting some of these tasks in a VS .Net 2005-style common tasks
menu on the right of controls might be ways to simplify things for end
users.
3) They want to change the appearance of the report (i.e. they want all
their print outs to be Times New Roman instead of Arial, add their logo,
etc.). This isn't done very commonly these days because of the effort
involved with changing close to 100 reports, and the customer would have to
repeat this effort in order to stay current when we release an update to the
standard reports. Our thought is that were we to support either of these
things going forward, it would be best to build our standard reports with
places for a logo or formulas for the text fonts that would be based on some
DB system-wide option in our software.
Jeff Davis
"Karthik Ravindran [MSFT]" <Karthik Ravindran
[MSFT]@.discussions.microsoft.com> wrote in message
news:99C32B25-9979-4120-B04E-6CDBB7B03AD3@.microsoft.com...
> Hello,
> I would like to get some feedback from the users/customers of SQL Server
> Reporting Services and other reporting technologies on common
customization
> requirements for reports.
> Let's assume that you have purchased a customizable business/ERP
application
> from an Independent Solution Vendor and that the application contains a
> number of built in reports. Alternatively you could be a consultant/vendor
> who customizes applications to suit specific customer requirements.
> What are the common types of customizations that you are likely to
implement
> (or have implemented in such scenarios) on the base set of reports to
tailor
> them to suit your/your customer requirements prior to deploying the app in
> your environment?
> Some examples of customizations are:
> a) Adding additional fields to a report
> b) Adding additional data regions to a report (Example: Adding an Employee
> Sales summary chart to an Employee details report)
> c) Replacing a data region with an alternate data region (Example:
Replacing
> a matrix report that displays product category sales by Year with a chart
> that plots Sales figures using Product Category as the Category group and
> Year as the Series group)
> d) Enhancing a data region (Example: Adding addition row/column groupings
to
> a matrix report and enabling drill down functionality)
> etc...
> Looking forward to hearing some feedback on this topic.
> Thanks
> Karthik

federated query architecture advice

I'm involved in a project building a federated query app. There is an ASP.NET web app talking to a central SQL Server 2005 db. Users input query parameters to the web ap, the request is submitted as a stored procedure to a central db, and from there it is distributed to the selected remote SQL Server 2005 db servers with similar but not necessarily identical schemas where the actual data resides.

We must wait for all servers to execute the query and return the results, then aggregate those query results and present them to the web app user.

The question is, what is the best way to design this with Server 2005? We need to be able to initiate multiple concurrent queries, then wait (up to some max timeout value) for all responses to return. What way(s) do I have with SQL Server 2005 to (1) initiate multiple queries, and (2) wait on the events (queries) to complete, up to some max timeout value?

I've looked at Service Broker some but that (maybe) seems like more than we need because all we're doing are queries. The tricky part seems to be initiating concurrent queries and waiting for all responses. Any advice or comments are appreciated.

Using SQL Server 2005 and ADO.NET 2.0 will enable you to do async queries / commands to the database. THis might be the best solution for you.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||I was hoping for a single stored procedure (sp) with a parameter naming the data sources to be queried. The sp would start multiple parallel queries, then consolidate the results into a single result set to return to the caller. Any ideas along these lines?|||

Just to get some understanding why do need to use federated searches. Are you running into scale problems?

The one solution is to use partitioned views, this enables the Query Optimiser to figure out which servers to query.

|||

We have multiple SQL Server databases with essentially identical schemas. These databases are located remotely from our central server (assuming we'll connect via vpn or...?). The idea is for a stored procedure call to be made to the central server that will in turn query the remote servers, with the consolidate / federated result set from all servers involved returned to the caller as a single result set.

Looks like I need to look into partitioned views; I presume this requires linked servers? If so, I've heard about problems with links staying "up" over extended periods when the remote servers are not connected to a LAN - any feedback on this question?

|||

Federation is for searching across multiple servers in a single location (in my opinion) not bringing remote data together.

Based on what you have said I believe you should be looking at a replication model. Each of your sites replicates data to the central point. The queries at the central point are then on local copies of the data.

Doing distributed queries when you have a poor connection is just not practical. Replication can handle this level of connectivity.

If you have Site A, Site B and SIte C and you need to have users in all sites seeing data from the other sites, you probably want to look at peer to perr transactional replication.

|||

Normal replication is not an option. Here's the scenario: we have multiple heterogeneous "source" systems (Oracle, Informix, SQL Server, etc.), each unique and different. Co-located with each source system is a SQL Server db. On a daily basis, the relevant tables from the source systems (which can be several GB's in total) will be copied into equivalent SQL Server tables using SSIS. (This is why replication to a central db is not an option; take this as a given, trust me). From the source schema, the data will be transformed (again via SSIS) into a "provider" schema on the co-located server. These provider schemas will be similar but not identical. We want to query and aggregate results from the provider schemas.

For example, if we have 4 sites (A, B, C, and D), and the user wants to query sites A and C, we want to fire-off parallel queries at site A nd site C. The rowset structure from the two sites will be identical, but the queries that produce them will not necessarily be identical. The final step is to combine the result sets from sites A and C and return the combined rowset to the stored procedure caller.

Once again, the co-located SQL Server boxes will be accessed over the Internet (via vpn?).

|||When you say trust me are you referring to office politics or are you referring to a technical problem? It appears (to me) that the co-located Sql Server databases (sources) could replicate to a single SQL Server database (target) from which querying could be performed. The target database could define a field to show the source of the data co-located Sql Server databases.

Feature request

Some of our users who may be running packages are not so adept at editing XML configuration files. It'd be nice if we could instead either:
1. Have an interface to modify the XML dtsConfig files
or 2. Have another option that would prompt via dialog box for the configuration options when the DTS package is run.
On #1, anyone know of any existing programs that would be useful (something that would ignore the markup and just edit the variables)?
Thanks for the request, Jonathan. It's on our list of things to consider for the next version, we just didn't have the time to get it into SQL Server 2005.

regards,
ash

Favorite reports

Is there any to let users have a folder of favorite reports?
I tried using "My Reports" folder, but the security required to allow a
user to see the option to create a linked report created too much of a
security risk.
Any ideas?Users could use the IE favorites, create a group there and simply add the
reports as you would any other web site...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"John Geddes" <john_g@.alamode.com> wrote in message
news:OxZbNxB9EHA.2900@.TK2MSFTNGP09.phx.gbl...
> Is there any to let users have a folder of favorite reports?
> I tried using "My Reports" folder, but the security required to allow a
> user to see the option to create a linked report created too much of a
> security risk.
> Any ideas?
>

Faster way to do this?

I want to know the # of users on our web site for each month in a given year. I'm looking for a faster way to do this--perhaps one that can leverage an index instead of reading the entire table! (My avg disk queue right now is above 7 and the query takes about 90 seconds).

Here's my current SP. Basically I'm calculating each month/year and using UNION to join them together, then pivot to rotate.

USE [TNS]

GO

/****** Object: StoredProcedure [dbo].[Unique_Login_IPs] Script Date: 05/07/2007 12:38:52 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- =============================================

-- Author: <Author,,Name>

-- Create date: <Create Date,,>

-- Description: <Description,,>

-- =============================================

ALTER PROCEDURE [dbo].[Unique_Login_IPs]

(

@.year1 int,

@.year2 int

)

AS

BEGIN

SET NOCOUNT OFF;

-- Define the years for testing purposes

set @.year1 = 2006

set @.year2 = 2007

SELECT month,[2006] as y2006,[2007] as y2007

FROM

(

SELECT @.year1 AS year, 1 AS month, COUNT(*) AS cnt

FROM (SELECT DISTINCT ipaddress

FROM servicelog

WHERE (method = 'LOGIN') AND (YEAR(logged) = @.year1) AND (MONTH(logged) = 1)) as tmpy1_1

UNION

SELECT @.year1 AS year, 2 AS month, COUNT(*) AS cnt

FROM (SELECT DISTINCT ipaddress

FROM servicelog AS servicelog_1

WHERE (method = 'LOGIN') AND (YEAR(logged) = @.year1) AND (MONTH(logged) = 2)) as tmpy1_2

UNION

SELECT @.year1 AS year, 3 AS month, COUNT(*) AS cnt

FROM (SELECT DISTINCT ipaddress

FROM servicelog

WHERE (method = 'LOGIN') AND (YEAR(logged) = @.year1) AND (MONTH(logged) = 3)) as tmpy1_3

UNION

SELECT @.year1 AS year, 4 AS month, COUNT(*) AS cnt

FROM (SELECT DISTINCT ipaddress

FROM servicelog AS servicelog_1

WHERE (method = 'LOGIN') AND (YEAR(logged) = @.year1) AND (MONTH(logged) = 4)) as tmpy1_4

UNION

SELECT @.year1 AS year, 5 AS month, COUNT(*) AS cnt

FROM (SELECT DISTINCT ipaddress

FROM servicelog

WHERE (method = 'LOGIN') AND (YEAR(logged) = @.year1) AND (MONTH(logged) = 5)) as tmpy1_5

UNION

SELECT @.year1 AS year, 6 AS month, COUNT(*) AS cnt

FROM (SELECT DISTINCT ipaddress

FROM servicelog AS servicelog_1

WHERE (method = 'LOGIN') AND (YEAR(logged) = @.year1) AND (MONTH(logged) = 6)) as tmpy1_6

UNION

SELECT @.year1 AS year, 7 AS month, COUNT(*) AS cnt

FROM (SELECT DISTINCT ipaddress

FROM servicelog

WHERE (method = 'LOGIN') AND (YEAR(logged) = @.year1) AND (MONTH(logged) = 7)) as tmpy1_7

UNION

SELECT @.year1 AS year, 8 AS month, COUNT(*) AS cnt

FROM (SELECT DISTINCT ipaddress

FROM servicelog AS servicelog_1

WHERE (method = 'LOGIN') AND (YEAR(logged) = @.year1) AND (MONTH(logged) = 8)) as tmpy1_8

UNION

SELECT @.year1 AS year, 9 AS month, COUNT(*) AS cnt

FROM (SELECT DISTINCT ipaddress

FROM servicelog

WHERE (method = 'LOGIN') AND (YEAR(logged) = @.year1) AND (MONTH(logged) = 9)) as tmpy1_9

UNION

SELECT @.year1 AS year, 10 AS month, COUNT(*) AS cnt

FROM (SELECT DISTINCT ipaddress

FROM servicelog AS servicelog_1

WHERE (method = 'LOGIN') AND (YEAR(logged) = @.year1) AND (MONTH(logged) = 10)) as tmpy1_10

UNION

SELECT @.year1 AS year, 11 AS month, COUNT(*) AS cnt

FROM (SELECT DISTINCT ipaddress

FROM servicelog

WHERE (method = 'LOGIN') AND (YEAR(logged) = @.year1) AND (MONTH(logged) = 11)) as tmpy1_11

UNION

SELECT @.year1 AS year, 12 AS month, COUNT(*) AS cnt

FROM (SELECT DISTINCT ipaddress

FROM servicelog AS servicelog_1

WHERE (method = 'LOGIN') AND (YEAR(logged) = @.year1) AND (MONTH(logged) = 12)) as tmpy1_12

UNION

SELECT @.year2 AS year, 1 AS month, COUNT(*) AS cnt

FROM (SELECT DISTINCT ipaddress

FROM servicelog

WHERE (method = 'LOGIN') AND (YEAR(logged) = @.year2) AND (MONTH(logged) = 1)) as tmpy1_1

UNION

SELECT @.year2 AS year, 2 AS month, COUNT(*) AS cnt

FROM (SELECT DISTINCT ipaddress

FROM servicelog AS servicelog_1

WHERE (method = 'LOGIN') AND (YEAR(logged) = @.year2) AND (MONTH(logged) = 2)) as tmpy2_2

UNION

SELECT @.year2 AS year, 3 AS month, COUNT(*) AS cnt

FROM (SELECT DISTINCT ipaddress

FROM servicelog

WHERE (method = 'LOGIN') AND (YEAR(logged) = @.year2) AND (MONTH(logged) = 3)) as tmpy2_3

UNION

SELECT @.year2 AS year, 4 AS month, COUNT(*) AS cnt

FROM (SELECT DISTINCT ipaddress

FROM servicelog AS servicelog_1

WHERE (method = 'LOGIN') AND (YEAR(logged) = @.year2) AND (MONTH(logged) = 4)) as tmpy2_4

UNION

SELECT @.year2 AS year, 5 AS month, COUNT(*) AS cnt

FROM (SELECT DISTINCT ipaddress

FROM servicelog

WHERE (method = 'LOGIN') AND (YEAR(logged) = @.year2) AND (MONTH(logged) = 5)) as tmpy2_5

UNION

SELECT @.year2 AS year, 6 AS month, COUNT(*) AS cnt

FROM (SELECT DISTINCT ipaddress

FROM servicelog AS servicelog_1

WHERE (method = 'LOGIN') AND (YEAR(logged) = @.year2) AND (MONTH(logged) = 6)) as tmpy2_6

UNION

SELECT @.year2 AS year, 7 AS month, COUNT(*) AS cnt

FROM (SELECT DISTINCT ipaddress

FROM servicelog

WHERE (method = 'LOGIN') AND (YEAR(logged) = @.year2) AND (MONTH(logged) = 7)) as tmpy2_7

UNION

SELECT @.year2 AS year, 8 AS month, COUNT(*) AS cnt

FROM (SELECT DISTINCT ipaddress

FROM servicelog AS servicelog_1

WHERE (method = 'LOGIN') AND (YEAR(logged) = @.year2) AND (MONTH(logged) = 8)) as tmpy2_8

UNION

SELECT @.year2 AS year, 9 AS month, COUNT(*) AS cnt

FROM (SELECT DISTINCT ipaddress

FROM servicelog

WHERE (method = 'LOGIN') AND (YEAR(logged) = @.year2) AND (MONTH(logged) = 9)) as tmpy2_9

UNION

SELECT @.year2 AS year, 10 AS month, COUNT(*) AS cnt

FROM (SELECT DISTINCT ipaddress

FROM servicelog AS servicelog_1

WHERE (method = 'LOGIN') AND (YEAR(logged) = @.year2) AND (MONTH(logged) = 10)) as tmpy2_10

UNION

SELECT @.year2 AS year, 11 AS month, COUNT(*) AS cnt

FROM (SELECT DISTINCT ipaddress

FROM servicelog

WHERE (method = 'LOGIN') AND (YEAR(logged) = @.year2) AND (MONTH(logged) = 11)) as tmpy2_11

UNION

SELECT @.year2 AS year, 12 AS month, COUNT(*) AS cnt

FROM (SELECT DISTINCT ipaddress

FROM servicelog AS servicelog_1

WHERE (method = 'LOGIN') AND (YEAR(logged) = @.year2) AND (MONTH(logged) = 12)) as tmpy2_12

) piv

PIVOT

(

SUM(cnt)

FOR year IN

([2006],[2007])

) as child

END

You didn't indicate if you were using SQL 2000 or SQL 2005.

This is an example of a 'single pass' collection and display of data -it may give you an idea of how to improve your current procedure. (This process will work in both SQL 2000 and SQL 2005. It uses the Northwind database.)

Code Snippet

IF EXISTS
( SELECT ROUTINE_NAME
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_NAME = 'spAnnualSalesByMonth'
)
DROP PROCEDURE dbo.spAnnualSalesByMonth
GO

CREATE PROCEDURE dbo.spAnnualSalesByMonth
AS
SELECT
max( dt.[Year] ) AS 'Year'
, convert( varchar(12), max( dt.Jan ), 1 ) AS 'Jan'
, convert( varchar(12), max( dt.Feb ), 1 ) AS 'Feb'
, convert( varchar(12), max( dt.Mar ), 1 ) AS 'Mar'
, convert( varchar(12), max( dt.Apr ), 1 ) AS 'Apr'
, convert( varchar(12), max( dt.May ), 1 ) AS 'May'
, convert( varchar(12), max( dt.Jun ), 1 ) AS 'Jun'
, convert( varchar(12), max( dt.Jul ), 1 ) AS 'Jul'
, convert( varchar(12), max( dt.Aug ), 1 ) AS 'Aug'
, convert( varchar(12), max( dt.Sep ), 1 ) AS 'Sep'
, convert( varchar(12), max( dt.Oct ), 1 ) AS 'Oct'
, convert( varchar(12), max( dt.Nov ), 1 ) AS 'Nov'
, convert( varchar(12), max( dt.[Dec] ), 1 ) AS 'Dec'
FROM
( SELECT
datepart( year, o.OrderDate ) AS 'Year'
, datepart( month, o.OrderDate ) AS 'Month'
, CASE when ( datepart( month, o.OrderDate )) = 1 THEN sum( od.Quantity * UnitPrice ) ELSE 0 END AS 'Jan'
, CASE when ( datepart( month, o.OrderDate )) = 2 THEN sum( od.Quantity * UnitPrice ) ELSE 0 END AS 'Feb'
, CASE when ( datepart( month, o.OrderDate )) = 3 THEN sum( od.Quantity * UnitPrice ) ELSE 0 END AS 'Mar'
, CASE when ( datepart( month, o.OrderDate )) = 4 THEN sum( od.Quantity * UnitPrice ) ELSE 0 END AS 'Apr'
, CASE when ( datepart( month, o.OrderDate )) = 5 THEN sum( od.Quantity * UnitPrice ) ELSE 0 END AS 'May'
, CASE when ( datepart( month, o.OrderDate )) = 6 THEN sum( od.Quantity * UnitPrice ) ELSE 0 END AS 'Jun'
, CASE when ( datepart( month, o.OrderDate )) = 7 THEN sum( od.Quantity * UnitPrice ) ELSE 0 END AS 'Jul'
, CASE when ( datepart( month, o.OrderDate )) = 8 THEN sum( od.Quantity * UnitPrice ) ELSE 0 END AS 'Aug'
, CASE when ( datepart( month, o.OrderDate )) = 9 THEN sum( od.Quantity * UnitPrice ) ELSE 0 END AS 'Sep'
, CASE when ( datepart( month, o.OrderDate )) = 10 THEN sum( od.Quantity * UnitPrice ) ELSE 0 END AS 'Oct'
, CASE when ( datepart( month, o.OrderDate )) = 11 THEN sum( od.Quantity * UnitPrice ) ELSE 0 END AS 'Nov'
, CASE when ( datepart( month, o.OrderDate )) = 12 THEN sum( od.Quantity * UnitPrice ) ELSE 0 END AS 'Dec'
FROM Orders o
JOIN [Order Details] od
ON o.OrderID = od.OrderID
GROUP BY
datepart( year, o.OrderDate )
, datepart( month, o.OrderDate )
) dt
GROUP BY dt.[Year]
ORDER BY dt.[Year]
GO

EXECUTE dbo.spAnnualSalesByMonth

(Output clipped for display)

Year Jan Feb Mar Apr May Jun Jul
--
1996 0.00 0.00 0.00 0.00 0.00 0.00 30,192.10
1997 66,692.80 41,207.20 39,979.90 55,699.39 56,823.70 39,088.00 55,464.93
1998 100,854.72 104,561.95 109,825.45 134,630.56 19,898.66 0.00 0.00

However, if you are using SQL 2005, there may be more efficency gained by using the new PIVOT operator. (This is untested.)

Code Snippet

DECLARE @.LogSummary table
( IPAddress varchar(15),

LogYear char(4) NOT NULL,
LogMonth char(2) NOT NULL,
)

INSERT INTO @.LogSummary
SELECT DISTINCT
IPAddress,
year( Logged),
month( Logged )
FROM ServiceLog
WHERE Method = 'LOGIN'

SELECT *
FROM @.LogSummary
PIVOT ( count( IPAddress ) FOR LogMonth
IN ( [01], [02], [03], [04], [05], [06], [07], [08], [09], [10], [11], [12] )) AS LogPivot

Failure to authendicate domain/users

I have several access databases in mind to migrate to SQL server. I installed MS SQL 2005 Express on my machine. I will have procedures to run with authorizations beyond that of a common user, such as database administrative work where server agent is not available, I may rely on users' log-on prompt to do some maintenance work. However, I cannot get the EXEC AS 'Domain\User' to work. The procedures can be created OK. But whenever they are called, the following message shows up:

Msg 15404, Level 16, State 19, Procedure XXX, Line 0
Could not obtain information about Windows NT group/user 'Domain\User', error code 0xea.

I tried to tweak with the account under which the server service is running. There are three options under built-in account: Local system, Local service, and Network Service. My understanding is that Network Service will use the log-on of the current user of the computer. I have admin right of the computer. None of the three options work. Additionally, when I specify an account (my own account), it's the same thing.

The procedure xp_logininfo always fails when I query a specific domain\user.

The ADHelper is configured to run manually.

I could not think of other ways to get a possible solution. Any help is much appreciated.

hi,

try having a look at http://support.microsoft.com/kb/834124/en-us

regards

|||

Hi, there,

I did several times. The problem is that the article does not contain an explanation of state 19. It has explanations for state 21 and above. Do you have any idea what state 19 relates to?

Thanks,

Failure installing SQL Server Express on a Pentium M device

I am currently trying to track down why one of our users is getting an error attempting to install SQL Server Express on their machine.

The symptoms are that SQL Server Express warns about the minimum hardware requirement not being met, the installation proceeds, but is not able to start the SQL Server service, and fails with the following error in the SQLSetupXXXX_MACHINENAME_Core(local).log file.

Error: Action "ReportChainingResults" threw an exception during execution.
One or more packages failed to install. Refer to logs for error details. : 1067
Error Code: 0x8007042b (1067)
Windows Error Text: The process terminated unexpectedly.

Source File Name: sqlchaining\sqlchainingactions.cpp
Compiler Timestamp: Thu Sep 1 22:23:05 2005
Function Name: sqls::ReportChainingResults::perform
Source Line Number: 3097

From all the information I can gather, this error occurs when the processor does NOT support cache prefetching, such as a Pentium II or a dubious Pentium III compatible CPU. I would have thought that Pentium M CPU's would all support cache prefetching, I am developing on a Pentium M CPU myself with NO dramas.

The CPU we are having problems with is a low-end one, Pentium M 1.4GHz, and it is an Advent laptop. Does anyone know why we would be seeing this error on this machine? Is there a way of turning cache prefetching off say in the BIOS, and would a non-technical user be likely to do that (say for preserving battery life or something like that)? Or is there another reason why SQl Server is not installing?

Any help would be appreciated.

Thanks.

Interesting thing happened today with respects to this problem.

We were originally starting an install of SQL Server Express as a pre-requisite to an InstallShield installer that installs our main application. This works fine on all the machines we've tested on.

Today I was able to successfully step our client (the one with the Pentium M on an Advent Laptop mentioned in the previous post), through downloading the SQL Express installer from the MS website, and then installing it manually (creating our specific instance, and using our particular settings etc...), and this worked fine. The user was then able to install our main application and run it successfully.

I don't understand why we got the above error (which from all I can tell is to do with cache pre-fetching), when installing it from our installer, but was able to install successfully by downloading it from MS.

Any thoughts?

|||

The core log file is really just a log of the master setup and doesn't contain specific details about why a sub-product failed. If you see an error again, you should look at the file %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\Log\summary.txt. It should give a quick summary of the install and be able to point you to the detailed log file for further information. If you then open the detailed log file, typically you can find the error by searching for the string "value 3" and then examining the 20 or so lines above and below the location that you found. Sometimes it will be an error executing a script or launching SQL Server, so you might also want to look at the ERRORLOG in %ProgramFiles%\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG. (MSSQL.1 might actually have some other number on the end, it depends on how many instances of SQL you have installed).

-Jeffrey.

|||

Thanks for the information Jeffrey, I'll go back and look through all the log files.

Cheers.

|||Scott,

Am I to understand from your post that you found a way to install SQL Express 2005 on a machine that does not support certain PIII features? I am desperately hoping to get it running on a Pentium II machine.

Thanks,

Zach First
|||

No Zach, the Pentium M is a Pentium 4 based processor, which is why I was so dismayed that I was getting the same error messages as we had seen when tracking down another clients install problem which ended up being a Pentium III compatibility issue. What Jeffrey was telling me is that I just wasn't looking at the error logs in enough detail. To be honest I still haven't found the reason why the first few attempts to install SQL Express on a pentium M machine didn't work, and with limited time and resources have moved onto other issues.

I would suggest that you give up any hope of trying to get SQL Express (or any SKU of SQL Server 2005) running on a pentium II device, The minimum hardware requirement is a pentium III for a number of reasons, one of which is cache prefetching, and without the instruction set to support it SQL Server 2005 WILL NOT RUN.

Sorry for the bad news.

Failure Audit log

We have started seeing a lot of failure audits on our sql server after we
gave a couple of domain users access to the SQL DB. The users have
permissions to read/write to certain tables in some databases. Any idea what
is causing this?
Event Type: Failure Audit
Event Source: Security
Event Category: Object Access
Event ID: 560
Date: 5/5/2005
Time: 1:08:00 PM
User: <<DOMAIN\KNOWN_USER_NAME>>
Computer: <<SERVER_NAME>>
Description:
Object Open:
Object Server: SC Manager
Object Type: SC_MANAGER OBJECT
Object Name: ServicesActive
Handle ID: -
Operation ID: {0,<<000000000>>}
Process ID: 844
Image File Name: C:\WINDOWS\system32\services.exe
Primary User Name: <<SERVER_NAME>>$
Primary Domain: SAGO
Primary Logon ID: (0x0,0x<<000>> )
Client User Name: <<KNOWN_USER_NAME>>
Client Domain: SAGO
Client Logon ID: (0x0,0x<<00000000>> )
Accesses: READ_CONTROL
Connect to service controller
Enumerate services
Query service database lock state
Privileges: -
Restricted Sid Count: 0
Access Mask: 0x20015
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.Based on my experience, this error usually occurs when a user
(DOMAIN\KNOWN_USER_NAME) makes a connection via a MMC and they do not have
the permissions to perform this action.
Can you identify what actions were performing at that time this error was
logged? In addition, is there any business impact casued by this error? Do
the domain users have any difficulty doing their job?
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Thread-Topic: Failure Audit log
>thread-index: AcVWbUHfZOaL7esET9Wrkqq2v6XWfA==
>X-WBNR-Posting-Host: 128.194.92.153
>From: "examnotes" <stech@.nospam.nospam>
>Subject: Failure Audit log
>Date: Wed, 11 May 2005 14:06:10 -0700
>Lines: 44
>Message-ID: <DA088796-FBED-4CCB-B9FC-2A2370CEACF0@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.security
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.security:4976
>X-Tomcat-NG: microsoft.public.sqlserver.security
>
>We have started seeing a lot of failure audits on our sql server after we
>gave a couple of domain users access to the SQL DB. The users have
>permissions to read/write to certain tables in some databases. Any idea
what
>is causing this?
>Event Type: Failure Audit
>Event Source: Security
>Event Category: Object Access
>Event ID: 560
>Date: 5/5/2005
>Time: 1:08:00 PM
>User: <<DOMAIN\KNOWN_USER_NAME>>
>Computer: <<SERVER_NAME>>
>Description:
>Object Open:
> Object Server: SC Manager
> Object Type: SC_MANAGER OBJECT
> Object Name: ServicesActive
> Handle ID: -
> Operation ID: {0,<<000000000>>}
> Process ID: 844
> Image File Name: C:\WINDOWS\system32\services.exe
> Primary User Name: <<SERVER_NAME>>$
> Primary Domain: SAGO
> Primary Logon ID: (0x0,0x<<000>> )
> Client User Name: <<KNOWN_USER_NAME>>
> Client Domain: SAGO
> Client Logon ID: (0x0,0x<<00000000>> )
> Accesses: READ_CONTROL
> Connect to service controller
> Enumerate services
> Query service database lock state
> Privileges: -
> Restricted Sid Count: 0
> Access Mask: 0x20015
>
>For more information, see Help and Support Center at
>http://go.microsoft.com/fwlink/events.asp.
>
>|||Wang,
You are right in that these people have a connection to our SQL server
(SQL-A) defined in MMC. But we are not sure what action they perform which
causes this to happen.
As far as actions go, users perform simple tasks like opening tables,
performing simple queires.
We even have one user who is not connected to the SQL-A server (although he
has the server registered under mmc), but he is connected to a different SQL
server through MMC, and at the same time, we have failure audits for that
person in the event log.
Looking at his MMC, I can see that he is connected to his local SQL server-
at the same time, there is a round circle with no green arrow inside for the
SQL-A server. So looks like MMC is attempting to poll SQL-A to see if it is
active but it is failing.
Looking at the event log, we have one entry every 10-15 seconds per person.
We would like for a way to stop these entries from showing up in the
security event log.
Thanks!
"William Wang[MSFT]" wrote:

> Based on my experience, this error usually occurs when a user
> (DOMAIN\KNOWN_USER_NAME) makes a connection via a MMC and they do not have
> the permissions to perform this action.
> Can you identify what actions were performing at that time this error was
> logged? In addition, is there any business impact casued by this error? Do
> the domain users have any difficulty doing their job?
> Sincerely,
> William Wang
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> --
> what
>|||This issue does not seem to be related to SQL server itself. I've seen a
similar issue before which occurs on a machine with multiple NICs
installed. If you have multiple NICs, I suggest that you temporarily
disable the unused ones for testing purpose.
If the issue persists, please check if the issue occurs with a user with
local admin right.
Because the issue occurs when users are getting Object Access Failure when
trying to access a server, you may want to use filemon/regmon (which can be
downloaded from www.sysinternals.com) to monitor the "access denied" error.
Third-Party Link Disclaimer
===========
This response contains a reference to a third-party World Wide Web site.
Microsoft is providing this information as a convenience to you. Microsoft
does not control these sites and has not tested any software or information
found on these sites; therefore, Microsoft cannot make any representations
regarding the quality, safety, or suitability of any software or
information found there. There are inherent dangers in the use of any
software found on the Internet, and Microsoft cautions you to make sure
that you completely understand the risk before retrieving any software from
the Internet.
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/te...erview/40010469
Others: https://partner.microsoft.com/US/te...upportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/defaul...rnational.aspx.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Thread-Topic: Failure Audit log
>thread-index: AcVX0ejCUeEAKnwdQfyIE+x61JsD+g==
>X-WBNR-Posting-Host: 128.194.92.153
>From: "examnotes" <stech@.nospam.nospam>
>References: <DA088796-FBED-4CCB-B9FC-2A2370CEACF0@.microsoft.com>
<xqiJe3rVFHA.460@.TK2MSFTNGXA01.phx.gbl>
>Subject: RE: Failure Audit log
>Date: Fri, 13 May 2005 08:39:11 -0700
>Lines: 118
>Message-ID: <F85CF50F-70C9-401E-92BF-F161EF680A2D@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.security
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTFEED02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA
03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.security:4995
>X-Tomcat-NG: microsoft.public.sqlserver.security
>Wang,
>You are right in that these people have a connection to our SQL server
>(SQL-A) defined in MMC. But we are not sure what action they perform which
>causes this to happen.
>As far as actions go, users perform simple tasks like opening tables,
>performing simple queires.
>We even have one user who is not connected to the SQL-A server (although
he
>has the server registered under mmc), but he is connected to a different
SQL
>server through MMC, and at the same time, we have failure audits for that
>person in the event log.
>Looking at his MMC, I can see that he is connected to his local SQL
server-
>at the same time, there is a round circle with no green arrow inside for
the
>SQL-A server. So looks like MMC is attempting to poll SQL-A to see if it
is
>active but it is failing.
>Looking at the event log, we have one entry every 10-15 seconds per
person.
>We would like for a way to stop these entries from showing up in the
>security event log.
>Thanks!
>
>"William Wang[MSFT]" wrote:
>
have[vbcol=seagreen]
was[vbcol=seagreen]
Do[vbcol=seagreen]
rights.[vbcol=seagreen]
we[vbcol=seagreen]
>

Failure Audit for SQL Server

I am getting the below Failure Audit in the SQL Server event log for 3 users.
All the users have access to a database in SQL Server with their domain
account. Below message keeps poping every second. How can I trouble shoot
this ? What is causing it ?
Thanks.
Source: Security
Type: Failure
Event ID: 560
Object Open:
Object Server:SC Manager
Object Type:SERVICE OBJECT
Object Name:MSSQLSERVER
New Handle ID:-
Operation ID:{0,1170910191}
Process ID:316
Primary User Name:DEVSERV1$
Primary Domain:CMR_PO
Primary Logon ID:(0x0,0x3E7)
Client User Name:aclint
Client Domain:CMR_PO
Client Logon ID:(0x0,0x3BAC59FE)
AccessesREAD_CONTROL
Query service configuration information
Query status of service
Enumerate dependencies of service
Query information from service
Privileges-
An event id 560 is just an open event. Check aclint's permission carefully.
Maybe ther is something he/she doesn't have access to like a particular proc
or table. Ask them if they see a message on their screen or if they are
experiencing any problems. see
http://www.microsoft.com/technet/arc...mspx?mfr=true
for more info on security event logs
"DXC" wrote:

> I am getting the below Failure Audit in the SQL Server event log for 3 users.
> All the users have access to a database in SQL Server with their domain
> account. Below message keeps poping every second. How can I trouble shoot
> this ? What is causing it ?
> Thanks.
> ----
> Source: Security
> Type: Failure
> Event ID: 560
> ----
>
> Object Open:
> Object Server:SC Manager
> Object Type:SERVICE OBJECT
> Object Name:MSSQLSERVER
> New Handle ID:-
> Operation ID:{0,1170910191}
> Process ID:316
> Primary User Name:DEVSERV1$
> Primary Domain:CMR_PO
> Primary Logon ID:(0x0,0x3E7)
> Client User Name:aclint
> Client Domain:CMR_PO
> Client Logon ID:(0x0,0x3BAC59FE)
> AccessesREAD_CONTROL
> Query service configuration information
> Query status of service
> Enumerate dependencies of service
> Query information from service
> Privileges-
>
|||My guess is that this is either EM or Service Manager which tries to see whether the service is
running.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Francis" <Francis@.discussions.microsoft.com> wrote in message
news:5844A73A-7208-480C-BDC8-8DDAADA4C86B@.microsoft.com...[vbcol=seagreen]
> An event id 560 is just an open event. Check aclint's permission carefully.
> Maybe ther is something he/she doesn't have access to like a particular proc
> or table. Ask them if they see a message on their screen or if they are
> experiencing any problems. see
> http://www.microsoft.com/technet/arc...mspx?mfr=true
> for more info on security event logs
> "DXC" wrote:
|||Thanks for the replies but I will not pursue this any longer since I can not
get any info from our developers who are having this problem in terms of what
they are trying to run/access. It seems like there is no way to find out what
they are doing from my end. I don't see anything under "Current Activity"
window either.
Windows 2000, SQL Server 2000 SE-SP4
Thanks again.
"Tibor Karaszi" wrote:

> My guess is that this is either EM or Service Manager which tries to see whether the service is
> running.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Francis" <Francis@.discussions.microsoft.com> wrote in message
> news:5844A73A-7208-480C-BDC8-8DDAADA4C86B@.microsoft.com...
>
|||Again, it is probably EM checking whether the server is running. You can check this, by asking one
of the users to stop EM, see if these events stop, and start EM again.
Also, you can uncheck the option "Display server state in console" for the server registration in EM
and see if these events disappear.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:2C1753AF-910D-4F62-A781-5870EE0C702E@.microsoft.com...[vbcol=seagreen]
> Thanks for the replies but I will not pursue this any longer since I can not
> get any info from our developers who are having this problem in terms of what
> they are trying to run/access. It seems like there is no way to find out what
> they are doing from my end. I don't see anything under "Current Activity"
> window either.
> Windows 2000, SQL Server 2000 SE-SP4
> Thanks again.
> "Tibor Karaszi" wrote:
|||In reference to SQL2000 at this site:
You may want to check if users are signed on to SQL Enterprise using
SQL logins and have 'Poll Server' checked
<Tools><Options>[Panel]General.
If this is checked, it will generate audit failures trying to
poll/acquire data using their domain account(s).
DXC wrote:
> I am getting the below Failure Audit in the SQL Server event log for 3 users.
> All the users have access to a database in SQL Server with their domain
> account. Below message keeps poping every second. How can I trouble shoot
> this ? What is causing it ?
> Thanks.
> ----
> Source: Security
> Type: Failure
> Event ID: 560
> ----
>
> Object Open:
> Object Server:SC Manager
> Object Type:SERVICE OBJECT
> Object Name:MSSQLSERVER
> New Handle ID:-
> Operation ID:{0,1170910191}
> Process ID:316
> Primary User Name:DEVSERV1$
> Primary Domain:CMR_PO
> Primary Logon ID:(0x0,0x3E7)
> Client User Name:aclint
> Client Domain:CMR_PO
> Client Logon ID:(0x0,0x3BAC59FE)
> AccessesREAD_CONTROL
> Query service configuration information
> Query status of service
> Enumerate dependencies of service
> Query information from service
> Privileges-

Failure Audit for SQL Server

I am getting the below Failure Audit in the SQL Server event log for 3 users
.
All the users have access to a database in SQL Server with their domain
account. Below message keeps poping every second. How can I trouble shoot
this ? What is causing it ?
Thanks.
----
Source: Security
Type: Failure
Event ID: 560
----
Object Open:
Object Server: SC Manager
Object Type: SERVICE OBJECT
Object Name: MSSQLSERVER
New Handle ID: -
Operation ID: {0,1170910191}
Process ID: 316
Primary User Name: DEVSERV1$
Primary Domain: CMR_PO
Primary Logon ID: (0x0,0x3E7)
Client User Name: aclint
Client Domain: CMR_PO
Client Logon ID: (0x0,0x3BAC59FE)
Accesses READ_CONTROL
Query service configuration information
Query status of service
Enumerate dependencies of service
Query information from service
Privileges -An event id 560 is just an open event. Check aclint's permission carefully.
Maybe ther is something he/she doesn't have access to like a particular proc
or table. Ask them if they see a message on their screen or if they are
experiencing any problems. see
[url]http://www.microsoft.com/technet/archive/winntas/support/usesecur.mspx?mfr=true[/u
rl]
for more info on security event logs
"DXC" wrote:

> I am getting the below Failure Audit in the SQL Server event log for 3 use
rs.
> All the users have access to a database in SQL Server with their domain
> account. Below message keeps poping every second. How can I trouble shoot
> this ? What is causing it ?
> Thanks.
> ----
> Source: Security
> Type: Failure
> Event ID: 560
> ----
>
> Object Open:
> Object Server: SC Manager
> Object Type: SERVICE OBJECT
> Object Name: MSSQLSERVER
> New Handle ID: -
> Operation ID: {0,1170910191}
> Process ID: 316
> Primary User Name: DEVSERV1$
> Primary Domain: CMR_PO
> Primary Logon ID: (0x0,0x3E7)
> Client User Name: aclint
> Client Domain: CMR_PO
> Client Logon ID: (0x0,0x3BAC59FE)
> Accesses READ_CONTROL
> Query service configuration information
> Query status of service
> Enumerate dependencies of service
> Query information from service
> Privileges -
>|||My guess is that this is either EM or Service Manager which tries to see whe
ther the service is
running.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Francis" <Francis@.discussions.microsoft.com> wrote in message
news:5844A73A-7208-480C-BDC8-8DDAADA4C86B@.microsoft.com...[vbcol=seagreen]
> An event id 560 is just an open event. Check aclint's permission carefull
y.
> Maybe ther is something he/she doesn't have access to like a particular pr
oc
> or table. Ask them if they see a message on their screen or if they are
> experiencing any problems. see
> [url]http://www.microsoft.com/technet/archive/winntas/support/usesecur.mspx?mfr=true[
/url]
> for more info on security event logs
> "DXC" wrote:
>|||Thanks for the replies but I will not pursue this any longer since I can not
get any info from our developers who are having this problem in terms of wha
t
they are trying to run/access. It seems like there is no way to find out wha
t
they are doing from my end. I don't see anything under "Current Activity"
window either.
Windows 2000, SQL Server 2000 SE-SP4
Thanks again.
"Tibor Karaszi" wrote:

> My guess is that this is either EM or Service Manager which tries to see w
hether the service is
> running.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Francis" <Francis@.discussions.microsoft.com> wrote in message
> news:5844A73A-7208-480C-BDC8-8DDAADA4C86B@.microsoft.com...
>|||Again, it is probably EM checking whether the server is running. You can che
ck this, by asking one
of the users to stop EM, see if these events stop, and start EM again.
Also, you can uncheck the option "Display server state in console" for the s
erver registration in EM
and see if these events disappear.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:2C1753AF-910D-4F62-A781-5870EE0C702E@.microsoft.com...[vbcol=seagreen]
> Thanks for the replies but I will not pursue this any longer since I can n
ot
> get any info from our developers who are having this problem in terms of w
hat
> they are trying to run/access. It seems like there is no way to find out w
hat
> they are doing from my end. I don't see anything under "Current Activity"
> window either.
> Windows 2000, SQL Server 2000 SE-SP4
> Thanks again.
> "Tibor Karaszi" wrote:
>|||In reference to SQL2000 at this site:
You may want to check if users are signed on to SQL Enterprise using
SQL logins and have 'Poll Server' checked
<Tools><Options>[Panel]General.
If this is checked, it will generate audit failures trying to
poll/acquire data using their domain account(s).
DXC wrote:
> I am getting the below Failure Audit in the SQL Server event log for 3 use
rs.
> All the users have access to a database in SQL Server with their domain
> account. Below message keeps poping every second. How can I trouble shoot
> this ? What is causing it ?
> Thanks.
> ----
> Source: Security
> Type: Failure
> Event ID: 560
> ----
>
> Object Open:
> Object Server: SC Manager
> Object Type: SERVICE OBJECT
> Object Name: MSSQLSERVER
> New Handle ID: -
> Operation ID: {0,1170910191}
> Process ID: 316
> Primary User Name: DEVSERV1$
> Primary Domain: CMR_PO
> Primary Logon ID: (0x0,0x3E7)
> Client User Name: aclint
> Client Domain: CMR_PO
> Client Logon ID: (0x0,0x3BAC59FE)
> Accesses READ_CONTROL
> Query service configuration information
> Query status of service
> Enumerate dependencies of service
> Query information from service
> Privileges -

Failure Audit for SQL Server

I am getting the below Failure Audit in the SQL Server event log for 3 users.
All the users have access to a database in SQL Server with their domain
account. Below message keeps poping every second. How can I trouble shoot
this ? What is causing it ?
Thanks.
----
Source: Security
Type: Failure
Event ID: 560
----
Object Open:
Object Server: SC Manager
Object Type: SERVICE OBJECT
Object Name: MSSQLSERVER
New Handle ID: -
Operation ID: {0,1170910191}
Process ID: 316
Primary User Name: DEVSERV1$
Primary Domain: CMR_PO
Primary Logon ID: (0x0,0x3E7)
Client User Name: aclint
Client Domain: CMR_PO
Client Logon ID: (0x0,0x3BAC59FE)
Accesses READ_CONTROL
Query service configuration information
Query status of service
Enumerate dependencies of service
Query information from service
Privileges -An event id 560 is just an open event. Check aclint's permission carefully.
Maybe ther is something he/she doesn't have access to like a particular proc
or table. Ask them if they see a message on their screen or if they are
experiencing any problems. see
http://www.microsoft.com/technet/archive/winntas/support/usesecur.mspx?mfr=true
for more info on security event logs
"DXC" wrote:
> I am getting the below Failure Audit in the SQL Server event log for 3 users.
> All the users have access to a database in SQL Server with their domain
> account. Below message keeps poping every second. How can I trouble shoot
> this ? What is causing it ?
> Thanks.
> ----
> Source: Security
> Type: Failure
> Event ID: 560
> ----
>
> Object Open:
> Object Server: SC Manager
> Object Type: SERVICE OBJECT
> Object Name: MSSQLSERVER
> New Handle ID: -
> Operation ID: {0,1170910191}
> Process ID: 316
> Primary User Name: DEVSERV1$
> Primary Domain: CMR_PO
> Primary Logon ID: (0x0,0x3E7)
> Client User Name: aclint
> Client Domain: CMR_PO
> Client Logon ID: (0x0,0x3BAC59FE)
> Accesses READ_CONTROL
> Query service configuration information
> Query status of service
> Enumerate dependencies of service
> Query information from service
> Privileges -
>|||My guess is that this is either EM or Service Manager which tries to see whether the service is
running.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Francis" <Francis@.discussions.microsoft.com> wrote in message
news:5844A73A-7208-480C-BDC8-8DDAADA4C86B@.microsoft.com...
> An event id 560 is just an open event. Check aclint's permission carefully.
> Maybe ther is something he/she doesn't have access to like a particular proc
> or table. Ask them if they see a message on their screen or if they are
> experiencing any problems. see
> http://www.microsoft.com/technet/archive/winntas/support/usesecur.mspx?mfr=true
> for more info on security event logs
> "DXC" wrote:
>> I am getting the below Failure Audit in the SQL Server event log for 3 users.
>> All the users have access to a database in SQL Server with their domain
>> account. Below message keeps poping every second. How can I trouble shoot
>> this ? What is causing it ?
>> Thanks.
>> ----
>> Source: Security
>> Type: Failure
>> Event ID: 560
>> ----
>>
>> Object Open:
>> Object Server: SC Manager
>> Object Type: SERVICE OBJECT
>> Object Name: MSSQLSERVER
>> New Handle ID: -
>> Operation ID: {0,1170910191}
>> Process ID: 316
>> Primary User Name: DEVSERV1$
>> Primary Domain: CMR_PO
>> Primary Logon ID: (0x0,0x3E7)
>> Client User Name: aclint
>> Client Domain: CMR_PO
>> Client Logon ID: (0x0,0x3BAC59FE)
>> Accesses READ_CONTROL
>> Query service configuration information
>> Query status of service
>> Enumerate dependencies of service
>> Query information from service
>> Privileges -|||Thanks for the replies but I will not pursue this any longer since I can not
get any info from our developers who are having this problem in terms of what
they are trying to run/access. It seems like there is no way to find out what
they are doing from my end. I don't see anything under "Current Activity"
window either.
Windows 2000, SQL Server 2000 SE-SP4
Thanks again.
"Tibor Karaszi" wrote:
> My guess is that this is either EM or Service Manager which tries to see whether the service is
> running.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Francis" <Francis@.discussions.microsoft.com> wrote in message
> news:5844A73A-7208-480C-BDC8-8DDAADA4C86B@.microsoft.com...
> > An event id 560 is just an open event. Check aclint's permission carefully.
> > Maybe ther is something he/she doesn't have access to like a particular proc
> > or table. Ask them if they see a message on their screen or if they are
> > experiencing any problems. see
> > http://www.microsoft.com/technet/archive/winntas/support/usesecur.mspx?mfr=true
> > for more info on security event logs
> >
> > "DXC" wrote:
> >
> >> I am getting the below Failure Audit in the SQL Server event log for 3 users.
> >> All the users have access to a database in SQL Server with their domain
> >> account. Below message keeps poping every second. How can I trouble shoot
> >> this ? What is causing it ?
> >>
> >> Thanks.
> >> ----
> >> Source: Security
> >> Type: Failure
> >> Event ID: 560
> >> ----
> >>
> >>
> >> Object Open:
> >> Object Server: SC Manager
> >> Object Type: SERVICE OBJECT
> >> Object Name: MSSQLSERVER
> >> New Handle ID: -
> >> Operation ID: {0,1170910191}
> >> Process ID: 316
> >> Primary User Name: DEVSERV1$
> >> Primary Domain: CMR_PO
> >> Primary Logon ID: (0x0,0x3E7)
> >> Client User Name: aclint
> >> Client Domain: CMR_PO
> >> Client Logon ID: (0x0,0x3BAC59FE)
> >> Accesses READ_CONTROL
> >> Query service configuration information
> >> Query status of service
> >> Enumerate dependencies of service
> >> Query information from service
> >>
> >> Privileges -
> >>
>|||Again, it is probably EM checking whether the server is running. You can check this, by asking one
of the users to stop EM, see if these events stop, and start EM again.
Also, you can uncheck the option "Display server state in console" for the server registration in EM
and see if these events disappear.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:2C1753AF-910D-4F62-A781-5870EE0C702E@.microsoft.com...
> Thanks for the replies but I will not pursue this any longer since I can not
> get any info from our developers who are having this problem in terms of what
> they are trying to run/access. It seems like there is no way to find out what
> they are doing from my end. I don't see anything under "Current Activity"
> window either.
> Windows 2000, SQL Server 2000 SE-SP4
> Thanks again.
> "Tibor Karaszi" wrote:
>> My guess is that this is either EM or Service Manager which tries to see whether the service is
>> running.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Francis" <Francis@.discussions.microsoft.com> wrote in message
>> news:5844A73A-7208-480C-BDC8-8DDAADA4C86B@.microsoft.com...
>> > An event id 560 is just an open event. Check aclint's permission carefully.
>> > Maybe ther is something he/she doesn't have access to like a particular proc
>> > or table. Ask them if they see a message on their screen or if they are
>> > experiencing any problems. see
>> > http://www.microsoft.com/technet/archive/winntas/support/usesecur.mspx?mfr=true
>> > for more info on security event logs
>> >
>> > "DXC" wrote:
>> >
>> >> I am getting the below Failure Audit in the SQL Server event log for 3 users.
>> >> All the users have access to a database in SQL Server with their domain
>> >> account. Below message keeps poping every second. How can I trouble shoot
>> >> this ? What is causing it ?
>> >>
>> >> Thanks.
>> >> ----
>> >> Source: Security
>> >> Type: Failure
>> >> Event ID: 560
>> >> ----
>> >>
>> >>
>> >> Object Open:
>> >> Object Server: SC Manager
>> >> Object Type: SERVICE OBJECT
>> >> Object Name: MSSQLSERVER
>> >> New Handle ID: -
>> >> Operation ID: {0,1170910191}
>> >> Process ID: 316
>> >> Primary User Name: DEVSERV1$
>> >> Primary Domain: CMR_PO
>> >> Primary Logon ID: (0x0,0x3E7)
>> >> Client User Name: aclint
>> >> Client Domain: CMR_PO
>> >> Client Logon ID: (0x0,0x3BAC59FE)
>> >> Accesses READ_CONTROL
>> >> Query service configuration information
>> >> Query status of service
>> >> Enumerate dependencies of service
>> >> Query information from service
>> >>
>> >> Privileges -
>> >>
>>|||In reference to SQL2000 at this site:
You may want to check if users are signed on to SQL Enterprise using
SQL logins and have 'Poll Server' checked
<Tools><Options>[Panel]General.
If this is checked, it will generate audit failures trying to
poll/acquire data using their domain account(s).
DXC wrote:
> I am getting the below Failure Audit in the SQL Server event log for 3 users.
> All the users have access to a database in SQL Server with their domain
> account. Below message keeps poping every second. How can I trouble shoot
> this ? What is causing it ?
> Thanks.
> ----
> Source: Security
> Type: Failure
> Event ID: 560
> ----
>
> Object Open:
> Object Server: SC Manager
> Object Type: SERVICE OBJECT
> Object Name: MSSQLSERVER
> New Handle ID: -
> Operation ID: {0,1170910191}
> Process ID: 316
> Primary User Name: DEVSERV1$
> Primary Domain: CMR_PO
> Primary Logon ID: (0x0,0x3E7)
> Client User Name: aclint
> Client Domain: CMR_PO
> Client Logon ID: (0x0,0x3BAC59FE)
> Accesses READ_CONTROL
> Query service configuration information
> Query status of service
> Enumerate dependencies of service
> Query information from service
> Privileges -

Failture to start Report Builder from Report manager

Dear all
I want to start report builder from report manager. I configured IIS with
integrated security. Everything seems well configured - users with access
rights can access Reporing Services, users without accessrights cannot.
But with reportbuilder I have a Authentication problem. A user from a client
machine cannot access report builder, while strangely accessing reportbuilder
from the server is possible. I assume the is a right problem, like the error
message below declares.
The weired thing is, that the user has the accessrights to the filesystem.
IIS can authenticate the user (event viewer) and I can see it also in the IIS
log. But no way to access the report builder.
Thanks for your help!
Regards,
Marc
MarcPLATFORM VERSION INFO
Windows : 5.1.2600.131072 (Win32NT)
Common Language Runtime : 2.0.50727.42
System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200)
mscorwks.dll : 2.0.50727.42 (RTM.050727-4200)
dfdll.dll : 2.0.50727.42 (RTM.050727-4200)
dfshim.dll : 2.0.50727.42 (RTM.050727-4200)
SOURCES
Deployment url :
http://10.1.10.64/ReportServer/ReportBuilder/ReportBuilderLocalIntranet.application
ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later
in the log.
* Activation of
http://10.1.10.64/ReportServer/ReportBuilder/ReportBuilderLocalIntranet.application resulted in exception. Following failure messages were detected:
+ Downloading
http://10.1.10.64/ReportServer/ReportBuilder/ReportBuilderLocalIntranet.application did not succeed.
+ The remote server returned an error: (401) Unauthorized.
COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.
WARNINGS
There were no warnings during this operation.
OPERATION PROGRESS STATUS
* [17.07.2006 14:46:13] : Activation of
http://10.1.10.64/ReportServer/ReportBuilder/ReportBuilderLocalIntranet.application has started.
ERROR DETAILS
Following errors were detected during this operation.
* [17.07.2006 14:46:25]
System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Downloading
http://10.1.10.64/ReportServer/ReportBuilder/ReportBuilderLocalIntranet.application did not succeed.
- Source: System.Deployment
- Stack trace:
at
System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
at
System.Deployment.Application.FileDownloader.Download(SubscriptionState
subState)
at
System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri&
sourceUri, String targetPath, IDownloadNotification notification,
DownloadOptions options, ServerInformation& serverInformation)
at
System.Deployment.Application.DownloadManager.DownloadDeploymentManifestDirectBypass(SubscriptionStore
subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState,
IDownloadNotification notification, DownloadOptions options,
ServerInformation& serverInformation)
at
System.Deployment.Application.DownloadManager.DownloadDeploymentManifestBypass(SubscriptionStore
subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState,
IDownloadNotification notification, DownloadOptions options)
at
System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut)
at
System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
-- Inner Exception --
System.Net.WebException
- The remote server returned an error: (401) Unauthorized.
- Source: System
- Stack trace:
at System.Net.HttpWebRequest.GetResponse()
at
System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
COMPONENT STORE TRANSACTION DETAILS
No transaction information is available.|||Hello Roger,
Thank you for post in MSDN newsgroup.
If I understand the issue correctly, a user from client cannot open report
builder while he could access report builder from local console of the RS
server. If I'm off-base, please let me know.
From the error log, it seems to be a permission issue. I suggest that you
try the following steps:
1. Get the RSWebApplication.config file located in the following folder in
most cases:
C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting
Services\ReportManager
2. Backup the RSWebApplication.config to another folder.
3. Modify the RSWebApplication.config as follows:
From:
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
To:
<ReportBuilderTrustLevel>PartialTrust</ReportBuilderTrustLevel>
You may want to restart IIS by running "iisreset" to test the sitaution.
Please let me know if this helps. If you have further question, please feel
free to let's know. I look forward to your reply.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Peter
thanks for your patience and your help with my issues. Unfortunately your
advice did not fix the problem. See the error message below :-/.
Do you have any other idea what could be wrong configured?
Regards,
Marc
PLATFORM VERSION INFO
Windows : 5.1.2600.131072 (Win32NT)
Common Language Runtime : 2.0.50727.42
System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200)
mscorwks.dll : 2.0.50727.42 (RTM.050727-4200)
dfdll.dll : 2.0.50727.42 (RTM.050727-4200)
dfshim.dll : 2.0.50727.42 (RTM.050727-4200)
SOURCES
Deployment url :
http://10.1.10.64/ReportServer/ReportBuilder/ReportBuilderLocalIntranet.application
ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later
in the log.
* Activation of
http://10.1.10.64/ReportServer/ReportBuilder/ReportBuilderLocalIntranet.application resulted in exception. Following failure messages were detected:
+ Downloading
http://10.1.10.64/ReportServer/ReportBuilder/ReportBuilderLocalIntranet.application did not succeed.
+ The remote server returned an error: (401) Unauthorized.
COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.
WARNINGS
There were no warnings during this operation.
OPERATION PROGRESS STATUS
* [18.07.2006 07:53:08] : Activation of
http://10.1.10.64/ReportServer/ReportBuilder/ReportBuilderLocalIntranet.application has started.
ERROR DETAILS
Following errors were detected during this operation.
* [18.07.2006 07:53:09]
System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Downloading
http://10.1.10.64/ReportServer/ReportBuilder/ReportBuilderLocalIntranet.application did not succeed.
- Source: System.Deployment
- Stack trace:
at
System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
at
System.Deployment.Application.FileDownloader.Download(SubscriptionState
subState)
at
System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri&
sourceUri, String targetPath, IDownloadNotification notification,
DownloadOptions options, ServerInformation& serverInformation)
at
System.Deployment.Application.DownloadManager.DownloadDeploymentManifestDirectBypass(SubscriptionStore
subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState,
IDownloadNotification notification, DownloadOptions options,
ServerInformation& serverInformation)
at
System.Deployment.Application.DownloadManager.DownloadDeploymentManifestBypass(SubscriptionStore
subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState,
IDownloadNotification notification, DownloadOptions options)
at
System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut)
at
System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
-- Inner Exception --
System.Net.WebException
- The remote server returned an error: (401) Unauthorized.
- Source: System
- Stack trace:
at System.Net.HttpWebRequest.GetResponse()
at
System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
COMPONENT STORE TRANSACTION DETAILS
No transaction information is available.|||Hello Marc,
Thank you for your update. Based on my further research, it seems the issue
is related to the file security. I suggest that you try the following steps:
Open IIS and navigate to Web Sites | Default Web Site | ReportServer |
ReportBuilder
Right click ReportBuilder.application
/ReportBuilderLocalIntranet.application
Click Properties
Click File Security
Click Edit under Authentication and Access Control
Select Integrated Windows Authentication
Uncheck Anonymouse authentication
Repeat the above steps for ReportBuilder.exe and ReportBuilder.exe.manifest
ReportBuilderLocalIntranet.exe.manifest
Please also do above step on ReportServer and ReportBuilder Virtual
directory.
Also, I'd like to know if you have tested on different client and if you
logged on as a domain user with admin rights on report server from a client
machine.
If you have any update, please feel free to let me know.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Hi Peter
Thanks for your reply. I first checked that everything is set just to
integrated windows authentication. But this did not resolve the problem. Then
I tested what happens when the files:
ReportBuilder.application
ReportBuilder.exe
ReportBulder.exe.manifest
ReportBuilderLocalIntranet.application
ReportBuilderLocalIntranet.exe.manifest
have Anonymous authentication (checked). And I granted the anonymous user
access to the files listed above.
And that gave me access to report builder!
What is strange I think, that Integrated Windows Authentication deosn't work
here. But perhaps I have a misconfiguration somewhere.
Best Regards,
Marc|||Hello Marc,
Thank you for your update. I understand that you'v resolved the issue by
granting anaonymous access to all of the files I mentioned. Though it is
not easy to find the root cause of the issue, I guess this might be related
to some issues on SRS VDs and options of web.config.
Your experience shall benefit the community. Thank you!
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================