Hi all,
I am running the ITW against several trace files that were created from a single trace file. I only have the following problem when attempting to save the script file from the analysis of any one of the multiple trace files. I have used the ITW against single trace files with no problem.
Here's the problem:
Everything works fine until I select the "Save Script File" option. After selecting this option, designating a file name to save to, and then clicking the "Next" button, the application appears to hang up. It displays an hourglass pointer, as though it is working, but just sits there forever. Also, when I look at the task manager this application reports that it is "not responding". I have allowed it to sit there in this state for several hours before finaly killing the process. Is there some additional configuration or method required to analyze multiple trace files from a single trace session?
Any suggestions would be greatly appreciated.
Thanks,
RickThis could be a bug. You might want to contact PSS.
Showing posts with label created. Show all posts
Showing posts with label created. Show all posts
Friday, March 30, 2012
ITW Errors
Hi,
I'm trying to use the ITW for one of our German servers. I have created an
input file using Profiler that captures the SQL:BatchCompleted and the
RPC:Completed events. When I run the ITW using the input file I recieve the
following error:
"The workload does not contain any events or queries that can be tuned
against the current database. Check to see that the trace contains valid
events or that the SQL script contains valid queries and you are tuning
against the right database"
If I select only certain tables to analyze I recieve the following error:
"There are no events in the workload. Either the trace file contained no
SQL batch or RPC events or the SQL script contained no SQL queries.
I have run a broad trace and a narrow trace using the specific database id
as a filter.
Both using a file and a table return the same errors.
If I use the Query Analyzer Selection option with the ITW with a specific
query from the input file then the ITW does work properly. Also, the size
of the input file is < 100 rows (just a test at this point).
It looks as though the ITW has an issue with the code of one or more of the
statements in the input file. Is this an accurate assumption? Does anyone
know how to resolve this issue so that I can use ITW with many statements as
opposed to using only a few at a time?
Thanks
Jerry
Jerry Spivey wrote:
> Hi,
> I'm trying to use the ITW for one of our German servers. I have
> created an input file using Profiler that captures the
> SQL:BatchCompleted and the RPC:Completed events. When I run the ITW
> using the input file I recieve the following error:
> "The workload does not contain any events or queries that can be tuned
> against the current database. Check to see that the trace contains
> valid events or that the SQL script contains valid queries and you
> are tuning against the right database"
> If I select only certain tables to analyze I recieve the following
> error:
> "There are no events in the workload. Either the trace file
> contained no SQL batch or RPC events or the SQL script contained no
> SQL queries.
> I have run a broad trace and a narrow trace using the specific
> database id as a filter.
> Both using a file and a table return the same errors.
> If I use the Query Analyzer Selection option with the ITW with a
> specific query from the input file then the ITW does work properly.
> Also, the size of the input file is < 100 rows (just a test at this
> point).
> It looks as though the ITW has an issue with the code of one or more
> of the statements in the input file. Is this an accurate assumption?
> Does anyone know how to resolve this issue so that I can use ITW with
> many statements as opposed to using only a few at a time?
> Thanks
> Jerry
There used to be a problem with SQL Server 7.0 with running the ITW on a
client PC using a different locale than the one on the server. Have you
tried running the ITW on the server itself (off-hours)?
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||David,
I saw the KB article that referenced that issue but it looked as though it
was fixed in SP1 of Version 7. We're running SP3 of Version 2000. I used
the client utilities from a separate client machine here in the states. I
had a colleague remote desktop to the SQL Server itself running the tools on
the local SQL Server and he received the same errors that I'm getting.
Jerry
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:uMu8ZbIjFHA.3784@.tk2msftngp13.phx.gbl...
> Jerry Spivey wrote:
> There used to be a problem with SQL Server 7.0 with running the ITW on a
> client PC using a different locale than the one on the server. Have you
> tried running the ITW on the server itself (off-hours)?
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
|||Jerry Spivey wrote:
> David,
> I saw the KB article that referenced that issue but it looked as
> though it was fixed in SP1 of Version 7. We're running SP3 of
> Version 2000. I used the client utilities from a separate client
> machine here in the states. I had a colleague remote desktop to the
> SQL Server itself running the tools on the local SQL Server and he
> received the same errors that I'm getting.
> Jerry
>
Have you examined the contents of the workload file to see what was
actually captured? If so, what happens if you copy one of the commands
and tune is manually from Query Analyzer. Does it work? How many
workload queries did you tell the ITW to examine in the workload file?
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||Yea that is my approach right now. I'm copy and pasting individual
statements into QA using the QAS option. Haven't found the culprit yet -
about 90 left to go.
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:eOlxUkIjFHA.2904@.tk2msftngp13.phx.gbl...
> Jerry Spivey wrote:
> Have you examined the contents of the workload file to see what was
> actually captured? If so, what happens if you copy one of the commands and
> tune is manually from Query Analyzer. Does it work? How many workload
> queries did you tell the ITW to examine in the workload file?
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
sql
I'm trying to use the ITW for one of our German servers. I have created an
input file using Profiler that captures the SQL:BatchCompleted and the
RPC:Completed events. When I run the ITW using the input file I recieve the
following error:
"The workload does not contain any events or queries that can be tuned
against the current database. Check to see that the trace contains valid
events or that the SQL script contains valid queries and you are tuning
against the right database"
If I select only certain tables to analyze I recieve the following error:
"There are no events in the workload. Either the trace file contained no
SQL batch or RPC events or the SQL script contained no SQL queries.
I have run a broad trace and a narrow trace using the specific database id
as a filter.
Both using a file and a table return the same errors.
If I use the Query Analyzer Selection option with the ITW with a specific
query from the input file then the ITW does work properly. Also, the size
of the input file is < 100 rows (just a test at this point).
It looks as though the ITW has an issue with the code of one or more of the
statements in the input file. Is this an accurate assumption? Does anyone
know how to resolve this issue so that I can use ITW with many statements as
opposed to using only a few at a time?
Thanks
Jerry
Jerry Spivey wrote:
> Hi,
> I'm trying to use the ITW for one of our German servers. I have
> created an input file using Profiler that captures the
> SQL:BatchCompleted and the RPC:Completed events. When I run the ITW
> using the input file I recieve the following error:
> "The workload does not contain any events or queries that can be tuned
> against the current database. Check to see that the trace contains
> valid events or that the SQL script contains valid queries and you
> are tuning against the right database"
> If I select only certain tables to analyze I recieve the following
> error:
> "There are no events in the workload. Either the trace file
> contained no SQL batch or RPC events or the SQL script contained no
> SQL queries.
> I have run a broad trace and a narrow trace using the specific
> database id as a filter.
> Both using a file and a table return the same errors.
> If I use the Query Analyzer Selection option with the ITW with a
> specific query from the input file then the ITW does work properly.
> Also, the size of the input file is < 100 rows (just a test at this
> point).
> It looks as though the ITW has an issue with the code of one or more
> of the statements in the input file. Is this an accurate assumption?
> Does anyone know how to resolve this issue so that I can use ITW with
> many statements as opposed to using only a few at a time?
> Thanks
> Jerry
There used to be a problem with SQL Server 7.0 with running the ITW on a
client PC using a different locale than the one on the server. Have you
tried running the ITW on the server itself (off-hours)?
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||David,
I saw the KB article that referenced that issue but it looked as though it
was fixed in SP1 of Version 7. We're running SP3 of Version 2000. I used
the client utilities from a separate client machine here in the states. I
had a colleague remote desktop to the SQL Server itself running the tools on
the local SQL Server and he received the same errors that I'm getting.
Jerry
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:uMu8ZbIjFHA.3784@.tk2msftngp13.phx.gbl...
> Jerry Spivey wrote:
> There used to be a problem with SQL Server 7.0 with running the ITW on a
> client PC using a different locale than the one on the server. Have you
> tried running the ITW on the server itself (off-hours)?
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
|||Jerry Spivey wrote:
> David,
> I saw the KB article that referenced that issue but it looked as
> though it was fixed in SP1 of Version 7. We're running SP3 of
> Version 2000. I used the client utilities from a separate client
> machine here in the states. I had a colleague remote desktop to the
> SQL Server itself running the tools on the local SQL Server and he
> received the same errors that I'm getting.
> Jerry
>
Have you examined the contents of the workload file to see what was
actually captured? If so, what happens if you copy one of the commands
and tune is manually from Query Analyzer. Does it work? How many
workload queries did you tell the ITW to examine in the workload file?
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||Yea that is my approach right now. I'm copy and pasting individual
statements into QA using the QAS option. Haven't found the culprit yet -
about 90 left to go.
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:eOlxUkIjFHA.2904@.tk2msftngp13.phx.gbl...
> Jerry Spivey wrote:
> Have you examined the contents of the workload file to see what was
> actually captured? If so, what happens if you copy one of the commands and
> tune is manually from Query Analyzer. Does it work? How many workload
> queries did you tell the ITW to examine in the workload file?
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
sql
ITW Errors
Hi,
I'm trying to use the ITW for one of our German servers. I have created an
input file using Profiler that captures the SQL:BatchCompleted and the
RPC:Completed events. When I run the ITW using the input file I recieve the
following error:
"The workload does not contain any events or queries that can be tuned
against the current database. Check to see that the trace contains valid
events or that the SQL script contains valid queries and you are tuning
against the right database"
If I select only certain tables to analyze I recieve the following error:
"There are no events in the workload. Either the trace file contained no
SQL batch or RPC events or the SQL script contained no SQL queries.
I have run a broad trace and a narrow trace using the specific database id
as a filter.
Both using a file and a table return the same errors.
If I use the Query Analyzer Selection option with the ITW with a specific
query from the input file then the ITW does work properly. Also, the size
of the input file is < 100 rows (just a test at this point).
It looks as though the ITW has an issue with the code of one or more of the
statements in the input file. Is this an accurate assumption? Does anyone
know how to resolve this issue so that I can use ITW with many statements as
opposed to using only a few at a time?
Thanks
JerryJerry Spivey wrote:
> Hi,
> I'm trying to use the ITW for one of our German servers. I have
> created an input file using Profiler that captures the
> SQL:BatchCompleted and the RPC:Completed events. When I run the ITW
> using the input file I recieve the following error:
> "The workload does not contain any events or queries that can be tuned
> against the current database. Check to see that the trace contains
> valid events or that the SQL script contains valid queries and you
> are tuning against the right database"
> If I select only certain tables to analyze I recieve the following
> error:
> "There are no events in the workload. Either the trace file
> contained no SQL batch or RPC events or the SQL script contained no
> SQL queries.
> I have run a broad trace and a narrow trace using the specific
> database id as a filter.
> Both using a file and a table return the same errors.
> If I use the Query Analyzer Selection option with the ITW with a
> specific query from the input file then the ITW does work properly.
> Also, the size of the input file is < 100 rows (just a test at this
> point).
> It looks as though the ITW has an issue with the code of one or more
> of the statements in the input file. Is this an accurate assumption?
> Does anyone know how to resolve this issue so that I can use ITW with
> many statements as opposed to using only a few at a time?
> Thanks
> Jerry
There used to be a problem with SQL Server 7.0 with running the ITW on a
client PC using a different locale than the one on the server. Have you
tried running the ITW on the server itself (off-hours)?
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||David,
I saw the KB article that referenced that issue but it looked as though it
was fixed in SP1 of Version 7. We're running SP3 of Version 2000. I used
the client utilities from a separate client machine here in the states. I
had a colleague remote desktop to the SQL Server itself running the tools on
the local SQL Server and he received the same errors that I'm getting.
Jerry
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:uMu8ZbIjFHA.3784@.tk2msftngp13.phx.gbl...
> Jerry Spivey wrote:
>> Hi,
>> I'm trying to use the ITW for one of our German servers. I have
>> created an input file using Profiler that captures the
>> SQL:BatchCompleted and the RPC:Completed events. When I run the ITW
>> using the input file I recieve the following error:
>> "The workload does not contain any events or queries that can be tuned
>> against the current database. Check to see that the trace contains
>> valid events or that the SQL script contains valid queries and you
>> are tuning against the right database"
>> If I select only certain tables to analyze I recieve the following
>> error:
>> "There are no events in the workload. Either the trace file
>> contained no SQL batch or RPC events or the SQL script contained no
>> SQL queries.
>> I have run a broad trace and a narrow trace using the specific
>> database id as a filter.
>> Both using a file and a table return the same errors.
>> If I use the Query Analyzer Selection option with the ITW with a
>> specific query from the input file then the ITW does work properly. Also,
>> the size of the input file is < 100 rows (just a test at this
>> point).
>> It looks as though the ITW has an issue with the code of one or more
>> of the statements in the input file. Is this an accurate assumption?
>> Does anyone know how to resolve this issue so that I can use ITW with
>> many statements as opposed to using only a few at a time?
>> Thanks
>> Jerry
> There used to be a problem with SQL Server 7.0 with running the ITW on a
> client PC using a different locale than the one on the server. Have you
> tried running the ITW on the server itself (off-hours)?
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com|||Jerry Spivey wrote:
> David,
> I saw the KB article that referenced that issue but it looked as
> though it was fixed in SP1 of Version 7. We're running SP3 of
> Version 2000. I used the client utilities from a separate client
> machine here in the states. I had a colleague remote desktop to the
> SQL Server itself running the tools on the local SQL Server and he
> received the same errors that I'm getting.
> Jerry
>
Have you examined the contents of the workload file to see what was
actually captured? If so, what happens if you copy one of the commands
and tune is manually from Query Analyzer. Does it work? How many
workload queries did you tell the ITW to examine in the workload file?
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Yea that is my approach right now. I'm copy and pasting individual
statements into QA using the QAS option. Haven't found the culprit yet -
about 90 left to go.
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:eOlxUkIjFHA.2904@.tk2msftngp13.phx.gbl...
> Jerry Spivey wrote:
>> David,
>> I saw the KB article that referenced that issue but it looked as
>> though it was fixed in SP1 of Version 7. We're running SP3 of
>> Version 2000. I used the client utilities from a separate client
>> machine here in the states. I had a colleague remote desktop to the
>> SQL Server itself running the tools on the local SQL Server and he
>> received the same errors that I'm getting.
>> Jerry
> Have you examined the contents of the workload file to see what was
> actually captured? If so, what happens if you copy one of the commands and
> tune is manually from Query Analyzer. Does it work? How many workload
> queries did you tell the ITW to examine in the workload file?
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
I'm trying to use the ITW for one of our German servers. I have created an
input file using Profiler that captures the SQL:BatchCompleted and the
RPC:Completed events. When I run the ITW using the input file I recieve the
following error:
"The workload does not contain any events or queries that can be tuned
against the current database. Check to see that the trace contains valid
events or that the SQL script contains valid queries and you are tuning
against the right database"
If I select only certain tables to analyze I recieve the following error:
"There are no events in the workload. Either the trace file contained no
SQL batch or RPC events or the SQL script contained no SQL queries.
I have run a broad trace and a narrow trace using the specific database id
as a filter.
Both using a file and a table return the same errors.
If I use the Query Analyzer Selection option with the ITW with a specific
query from the input file then the ITW does work properly. Also, the size
of the input file is < 100 rows (just a test at this point).
It looks as though the ITW has an issue with the code of one or more of the
statements in the input file. Is this an accurate assumption? Does anyone
know how to resolve this issue so that I can use ITW with many statements as
opposed to using only a few at a time?
Thanks
JerryJerry Spivey wrote:
> Hi,
> I'm trying to use the ITW for one of our German servers. I have
> created an input file using Profiler that captures the
> SQL:BatchCompleted and the RPC:Completed events. When I run the ITW
> using the input file I recieve the following error:
> "The workload does not contain any events or queries that can be tuned
> against the current database. Check to see that the trace contains
> valid events or that the SQL script contains valid queries and you
> are tuning against the right database"
> If I select only certain tables to analyze I recieve the following
> error:
> "There are no events in the workload. Either the trace file
> contained no SQL batch or RPC events or the SQL script contained no
> SQL queries.
> I have run a broad trace and a narrow trace using the specific
> database id as a filter.
> Both using a file and a table return the same errors.
> If I use the Query Analyzer Selection option with the ITW with a
> specific query from the input file then the ITW does work properly.
> Also, the size of the input file is < 100 rows (just a test at this
> point).
> It looks as though the ITW has an issue with the code of one or more
> of the statements in the input file. Is this an accurate assumption?
> Does anyone know how to resolve this issue so that I can use ITW with
> many statements as opposed to using only a few at a time?
> Thanks
> Jerry
There used to be a problem with SQL Server 7.0 with running the ITW on a
client PC using a different locale than the one on the server. Have you
tried running the ITW on the server itself (off-hours)?
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||David,
I saw the KB article that referenced that issue but it looked as though it
was fixed in SP1 of Version 7. We're running SP3 of Version 2000. I used
the client utilities from a separate client machine here in the states. I
had a colleague remote desktop to the SQL Server itself running the tools on
the local SQL Server and he received the same errors that I'm getting.
Jerry
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:uMu8ZbIjFHA.3784@.tk2msftngp13.phx.gbl...
> Jerry Spivey wrote:
>> Hi,
>> I'm trying to use the ITW for one of our German servers. I have
>> created an input file using Profiler that captures the
>> SQL:BatchCompleted and the RPC:Completed events. When I run the ITW
>> using the input file I recieve the following error:
>> "The workload does not contain any events or queries that can be tuned
>> against the current database. Check to see that the trace contains
>> valid events or that the SQL script contains valid queries and you
>> are tuning against the right database"
>> If I select only certain tables to analyze I recieve the following
>> error:
>> "There are no events in the workload. Either the trace file
>> contained no SQL batch or RPC events or the SQL script contained no
>> SQL queries.
>> I have run a broad trace and a narrow trace using the specific
>> database id as a filter.
>> Both using a file and a table return the same errors.
>> If I use the Query Analyzer Selection option with the ITW with a
>> specific query from the input file then the ITW does work properly. Also,
>> the size of the input file is < 100 rows (just a test at this
>> point).
>> It looks as though the ITW has an issue with the code of one or more
>> of the statements in the input file. Is this an accurate assumption?
>> Does anyone know how to resolve this issue so that I can use ITW with
>> many statements as opposed to using only a few at a time?
>> Thanks
>> Jerry
> There used to be a problem with SQL Server 7.0 with running the ITW on a
> client PC using a different locale than the one on the server. Have you
> tried running the ITW on the server itself (off-hours)?
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com|||Jerry Spivey wrote:
> David,
> I saw the KB article that referenced that issue but it looked as
> though it was fixed in SP1 of Version 7. We're running SP3 of
> Version 2000. I used the client utilities from a separate client
> machine here in the states. I had a colleague remote desktop to the
> SQL Server itself running the tools on the local SQL Server and he
> received the same errors that I'm getting.
> Jerry
>
Have you examined the contents of the workload file to see what was
actually captured? If so, what happens if you copy one of the commands
and tune is manually from Query Analyzer. Does it work? How many
workload queries did you tell the ITW to examine in the workload file?
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Yea that is my approach right now. I'm copy and pasting individual
statements into QA using the QAS option. Haven't found the culprit yet -
about 90 left to go.
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:eOlxUkIjFHA.2904@.tk2msftngp13.phx.gbl...
> Jerry Spivey wrote:
>> David,
>> I saw the KB article that referenced that issue but it looked as
>> though it was fixed in SP1 of Version 7. We're running SP3 of
>> Version 2000. I used the client utilities from a separate client
>> machine here in the states. I had a colleague remote desktop to the
>> SQL Server itself running the tools on the local SQL Server and he
>> received the same errors that I'm getting.
>> Jerry
> Have you examined the contents of the workload file to see what was
> actually captured? If so, what happens if you copy one of the commands and
> tune is manually from Query Analyzer. Does it work? How many workload
> queries did you tell the ITW to examine in the workload file?
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
ITW Errors
Hi,
I'm trying to use the ITW for one of our German servers. I have created an
input file using Profiler that captures the SQL:BatchCompleted and the
RPC:Completed events. When I run the ITW using the input file I recieve the
following error:
"The workload does not contain any events or queries that can be tuned
against the current database. Check to see that the trace contains valid
events or that the SQL script contains valid queries and you are tuning
against the right database"
If I select only certain tables to analyze I recieve the following error:
"There are no events in the workload. Either the trace file contained no
SQL batch or RPC events or the SQL script contained no SQL queries.
I have run a broad trace and a narrow trace using the specific database id
as a filter.
Both using a file and a table return the same errors.
If I use the Query Analyzer Selection option with the ITW with a specific
query from the input file then the ITW does work properly. Also, the size
of the input file is < 100 rows (just a test at this point).
It looks as though the ITW has an issue with the code of one or more of the
statements in the input file. Is this an accurate assumption? Does anyone
know how to resolve this issue so that I can use ITW with many statements as
opposed to using only a few at a time?
Thanks
JerryJerry Spivey wrote:
> Hi,
> I'm trying to use the ITW for one of our German servers. I have
> created an input file using Profiler that captures the
> SQL:BatchCompleted and the RPC:Completed events. When I run the ITW
> using the input file I recieve the following error:
> "The workload does not contain any events or queries that can be tuned
> against the current database. Check to see that the trace contains
> valid events or that the SQL script contains valid queries and you
> are tuning against the right database"
> If I select only certain tables to analyze I recieve the following
> error:
> "There are no events in the workload. Either the trace file
> contained no SQL batch or RPC events or the SQL script contained no
> SQL queries.
> I have run a broad trace and a narrow trace using the specific
> database id as a filter.
> Both using a file and a table return the same errors.
> If I use the Query Analyzer Selection option with the ITW with a
> specific query from the input file then the ITW does work properly.
> Also, the size of the input file is < 100 rows (just a test at this
> point).
> It looks as though the ITW has an issue with the code of one or more
> of the statements in the input file. Is this an accurate assumption?
> Does anyone know how to resolve this issue so that I can use ITW with
> many statements as opposed to using only a few at a time?
> Thanks
> Jerry
There used to be a problem with SQL Server 7.0 with running the ITW on a
client PC using a different locale than the one on the server. Have you
tried running the ITW on the server itself (off-hours)?
David Gugick
Quest Software
www.imceda.com
www.quest.com|||David,
I saw the KB article that referenced that issue but it looked as though it
was fixed in SP1 of Version 7. We're running SP3 of Version 2000. I used
the client utilities from a separate client machine here in the states. I
had a colleague remote desktop to the SQL Server itself running the tools on
the local SQL Server and he received the same errors that I'm getting.
Jerry
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:uMu8ZbIjFHA.3784@.tk2msftngp13.phx.gbl...
> Jerry Spivey wrote:
> There used to be a problem with SQL Server 7.0 with running the ITW on a
> client PC using a different locale than the one on the server. Have you
> tried running the ITW on the server itself (off-hours)?
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com|||Jerry Spivey wrote:
> David,
> I saw the KB article that referenced that issue but it looked as
> though it was fixed in SP1 of Version 7. We're running SP3 of
> Version 2000. I used the client utilities from a separate client
> machine here in the states. I had a colleague remote desktop to the
> SQL Server itself running the tools on the local SQL Server and he
> received the same errors that I'm getting.
> Jerry
>
Have you examined the contents of the workload file to see what was
actually captured? If so, what happens if you copy one of the commands
and tune is manually from Query Analyzer. Does it work? How many
workload queries did you tell the ITW to examine in the workload file?
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Yea that is my approach right now. I'm copy and pasting individual
statements into QA using the QAS option. Haven't found the culprit yet -
about 90 left to go.
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:eOlxUkIjFHA.2904@.tk2msftngp13.phx.gbl...
> Jerry Spivey wrote:
> Have you examined the contents of the workload file to see what was
> actually captured? If so, what happens if you copy one of the commands and
> tune is manually from Query Analyzer. Does it work? How many workload
> queries did you tell the ITW to examine in the workload file?
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
I'm trying to use the ITW for one of our German servers. I have created an
input file using Profiler that captures the SQL:BatchCompleted and the
RPC:Completed events. When I run the ITW using the input file I recieve the
following error:
"The workload does not contain any events or queries that can be tuned
against the current database. Check to see that the trace contains valid
events or that the SQL script contains valid queries and you are tuning
against the right database"
If I select only certain tables to analyze I recieve the following error:
"There are no events in the workload. Either the trace file contained no
SQL batch or RPC events or the SQL script contained no SQL queries.
I have run a broad trace and a narrow trace using the specific database id
as a filter.
Both using a file and a table return the same errors.
If I use the Query Analyzer Selection option with the ITW with a specific
query from the input file then the ITW does work properly. Also, the size
of the input file is < 100 rows (just a test at this point).
It looks as though the ITW has an issue with the code of one or more of the
statements in the input file. Is this an accurate assumption? Does anyone
know how to resolve this issue so that I can use ITW with many statements as
opposed to using only a few at a time?
Thanks
JerryJerry Spivey wrote:
> Hi,
> I'm trying to use the ITW for one of our German servers. I have
> created an input file using Profiler that captures the
> SQL:BatchCompleted and the RPC:Completed events. When I run the ITW
> using the input file I recieve the following error:
> "The workload does not contain any events or queries that can be tuned
> against the current database. Check to see that the trace contains
> valid events or that the SQL script contains valid queries and you
> are tuning against the right database"
> If I select only certain tables to analyze I recieve the following
> error:
> "There are no events in the workload. Either the trace file
> contained no SQL batch or RPC events or the SQL script contained no
> SQL queries.
> I have run a broad trace and a narrow trace using the specific
> database id as a filter.
> Both using a file and a table return the same errors.
> If I use the Query Analyzer Selection option with the ITW with a
> specific query from the input file then the ITW does work properly.
> Also, the size of the input file is < 100 rows (just a test at this
> point).
> It looks as though the ITW has an issue with the code of one or more
> of the statements in the input file. Is this an accurate assumption?
> Does anyone know how to resolve this issue so that I can use ITW with
> many statements as opposed to using only a few at a time?
> Thanks
> Jerry
There used to be a problem with SQL Server 7.0 with running the ITW on a
client PC using a different locale than the one on the server. Have you
tried running the ITW on the server itself (off-hours)?
David Gugick
Quest Software
www.imceda.com
www.quest.com|||David,
I saw the KB article that referenced that issue but it looked as though it
was fixed in SP1 of Version 7. We're running SP3 of Version 2000. I used
the client utilities from a separate client machine here in the states. I
had a colleague remote desktop to the SQL Server itself running the tools on
the local SQL Server and he received the same errors that I'm getting.
Jerry
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:uMu8ZbIjFHA.3784@.tk2msftngp13.phx.gbl...
> Jerry Spivey wrote:
> There used to be a problem with SQL Server 7.0 with running the ITW on a
> client PC using a different locale than the one on the server. Have you
> tried running the ITW on the server itself (off-hours)?
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com|||Jerry Spivey wrote:
> David,
> I saw the KB article that referenced that issue but it looked as
> though it was fixed in SP1 of Version 7. We're running SP3 of
> Version 2000. I used the client utilities from a separate client
> machine here in the states. I had a colleague remote desktop to the
> SQL Server itself running the tools on the local SQL Server and he
> received the same errors that I'm getting.
> Jerry
>
Have you examined the contents of the workload file to see what was
actually captured? If so, what happens if you copy one of the commands
and tune is manually from Query Analyzer. Does it work? How many
workload queries did you tell the ITW to examine in the workload file?
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Yea that is my approach right now. I'm copy and pasting individual
statements into QA using the QAS option. Haven't found the culprit yet -
about 90 left to go.
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:eOlxUkIjFHA.2904@.tk2msftngp13.phx.gbl...
> Jerry Spivey wrote:
> Have you examined the contents of the workload file to see what was
> actually captured? If so, what happens if you copy one of the commands and
> tune is manually from Query Analyzer. Does it work? How many workload
> queries did you tell the ITW to examine in the workload file?
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
Wednesday, March 28, 2012
It's Urgent Please Help....
Hi, I've created one mailing label report with
2 Across Than 3 down.But it displays the data
like
1 4
2 5
3 6
Is there a way to change the default orientation from Down then Across
to Across and then down like this ?
1 2
3 4
5 6
Thanks & Regards
MalkeshOne idea ist to add a counter to your view and select only the datarows with
1, 3 ,5 ,7 ,9 ... and out them into ´1st column.
Then insert a subreport next to 1st column as col 2 and use the 2, 4, 6 ,8
... data rows from view.
Markus Pöhler
netpoint-edv gmbh
Germany
"Malkesh" wrote:
> Hi, I've created one mailing label report with
> 2 Across Than 3 down.But it displays the data
> like
> 1 4
> 2 5
> 3 6
> Is there a way to change the default orientation from Down then Across
> to Across and then down like this ?
> 1 2
> 3 4
> 5 6
>
>
> Thanks & Regards
> Malkesh|||Thanks,
But I'm Sorry, i need to explain the actual problem rather
giving you the layout.
Actually we have Event Badge Report with Badge Info is on Top
Left side and Receipt Info is On Top right side fro the event, and after that
as many tickets as individual is registered for shouls be print from next row.
So i need to layout the report Across tha Down.
How can i achieve this task ?
--
Thanks & Regards
Malkesh
"MarkusPoehler" wrote:
> One idea ist to add a counter to your view and select only the datarows with
> 1, 3 ,5 ,7 ,9 ... and out them into ´1st column.
> Then insert a subreport next to 1st column as col 2 and use the 2, 4, 6 ,8
> ... data rows from view.
>
> Markus Pöhler
> netpoint-edv gmbh
> Germany
>
> "Malkesh" wrote:
> > Hi, I've created one mailing label report with
> > 2 Across Than 3 down.But it displays the data
> > like
> > 1 4
> > 2 5
> > 3 6
> >
> > Is there a way to change the default orientation from Down then Across
> > to Across and then down like this ?
> >
> > 1 2
> > 3 4
> > 5 6
> >
> >
> >
> >
> > Thanks & Regards
> > Malkesh|||If you are doing this with a table. there is a property called writing-mode
lr-tb or tb-lr...
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Malkesh" <Malkesh@.discussions.microsoft.com> wrote in message
news:8CFA0F60-3BF8-47D2-894E-58B370C6D9C4@.microsoft.com...
> Thanks,
> But I'm Sorry, i need to explain the actual problem rather
> giving you the layout.
> Actually we have Event Badge Report with Badge Info is on Top
> Left side and Receipt Info is On Top right side fro the event, and after
> that
> as many tickets as individual is registered for shouls be print from next
> row.
> So i need to layout the report Across tha Down.
> How can i achieve this task ?
> --
> Thanks & Regards
> Malkesh
>
> "MarkusPoehler" wrote:
>> One idea ist to add a counter to your view and select only the datarows
>> with
>> 1, 3 ,5 ,7 ,9 ... and out them into ´1st column.
>> Then insert a subreport next to 1st column as col 2 and use the 2, 4, 6
>> ,8
>> ... data rows from view.
>>
>> Markus Pöhler
>> netpoint-edv gmbh
>> Germany
>>
>> "Malkesh" wrote:
>> > Hi, I've created one mailing label report with
>> > 2 Across Than 3 down.But it displays the data
>> > like
>> > 1 4
>> > 2 5
>> > 3 6
>> >
>> > Is there a way to change the default orientation from Down then Across
>> > to Across and then down like this ?
>> >
>> > 1 2
>> > 3 4
>> > 5 6
>> >
>> >
>> >
>> >
>> > Thanks & Regards
>> > Malkesh
2 Across Than 3 down.But it displays the data
like
1 4
2 5
3 6
Is there a way to change the default orientation from Down then Across
to Across and then down like this ?
1 2
3 4
5 6
Thanks & Regards
MalkeshOne idea ist to add a counter to your view and select only the datarows with
1, 3 ,5 ,7 ,9 ... and out them into ´1st column.
Then insert a subreport next to 1st column as col 2 and use the 2, 4, 6 ,8
... data rows from view.
Markus Pöhler
netpoint-edv gmbh
Germany
"Malkesh" wrote:
> Hi, I've created one mailing label report with
> 2 Across Than 3 down.But it displays the data
> like
> 1 4
> 2 5
> 3 6
> Is there a way to change the default orientation from Down then Across
> to Across and then down like this ?
> 1 2
> 3 4
> 5 6
>
>
> Thanks & Regards
> Malkesh|||Thanks,
But I'm Sorry, i need to explain the actual problem rather
giving you the layout.
Actually we have Event Badge Report with Badge Info is on Top
Left side and Receipt Info is On Top right side fro the event, and after that
as many tickets as individual is registered for shouls be print from next row.
So i need to layout the report Across tha Down.
How can i achieve this task ?
--
Thanks & Regards
Malkesh
"MarkusPoehler" wrote:
> One idea ist to add a counter to your view and select only the datarows with
> 1, 3 ,5 ,7 ,9 ... and out them into ´1st column.
> Then insert a subreport next to 1st column as col 2 and use the 2, 4, 6 ,8
> ... data rows from view.
>
> Markus Pöhler
> netpoint-edv gmbh
> Germany
>
> "Malkesh" wrote:
> > Hi, I've created one mailing label report with
> > 2 Across Than 3 down.But it displays the data
> > like
> > 1 4
> > 2 5
> > 3 6
> >
> > Is there a way to change the default orientation from Down then Across
> > to Across and then down like this ?
> >
> > 1 2
> > 3 4
> > 5 6
> >
> >
> >
> >
> > Thanks & Regards
> > Malkesh|||If you are doing this with a table. there is a property called writing-mode
lr-tb or tb-lr...
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Malkesh" <Malkesh@.discussions.microsoft.com> wrote in message
news:8CFA0F60-3BF8-47D2-894E-58B370C6D9C4@.microsoft.com...
> Thanks,
> But I'm Sorry, i need to explain the actual problem rather
> giving you the layout.
> Actually we have Event Badge Report with Badge Info is on Top
> Left side and Receipt Info is On Top right side fro the event, and after
> that
> as many tickets as individual is registered for shouls be print from next
> row.
> So i need to layout the report Across tha Down.
> How can i achieve this task ?
> --
> Thanks & Regards
> Malkesh
>
> "MarkusPoehler" wrote:
>> One idea ist to add a counter to your view and select only the datarows
>> with
>> 1, 3 ,5 ,7 ,9 ... and out them into ´1st column.
>> Then insert a subreport next to 1st column as col 2 and use the 2, 4, 6
>> ,8
>> ... data rows from view.
>>
>> Markus Pöhler
>> netpoint-edv gmbh
>> Germany
>>
>> "Malkesh" wrote:
>> > Hi, I've created one mailing label report with
>> > 2 Across Than 3 down.But it displays the data
>> > like
>> > 1 4
>> > 2 5
>> > 3 6
>> >
>> > Is there a way to change the default orientation from Down then Across
>> > to Across and then down like this ?
>> >
>> > 1 2
>> > 3 4
>> > 5 6
>> >
>> >
>> >
>> >
>> > Thanks & Regards
>> > Malkesh
Monday, March 26, 2012
iterate through a view?
Hello everybody,
obviously, I'm a newbie, so please forgive me for using the wrong terms accidently.
I have created a view that looks like this:
ID Disc Cut
------
1 11 25
1 5 34
2 1 67
3 8 54
4 5 14
4 1 12
...
ID is a bigint, Disc & Cut ar varchars
As you can see, the ID is not the primary key.
Still, what I need is only the record of the first occurance of each ID,
like this:
ID Disc Cut
------
1 11 25
2 1 67
3 8 54
4 5 14
...
Is there a way that I can iterate through the view and compare one record to
the previous or next?
(I didn't find anything in the Microsoft Library yet...)
Thanks!
NinaHave you tried SELECT DISTINCT ID FROM ...|||Originally posted by grahamt
Have you tried SELECT DISTINCT ID FROM ...
That wouldn't work because these rows:
1 11 25
1 5 34
are not distinct but I need only one of them.|||There is no such thing as "First" in SQL server unless you specify a sort order. You obviously have your data sorted by ID, but after that SQL Server make no guarantee as to the order in which your data will be returned.
It could easily be returned like this on some subsequent execution:
ID Disc Cut
------
1 11 25
1 5 34
2 1 67
3 8 54
4 1 12
4 5 14
You will need to specify a secondary sort order in order to select between duplicate ID values.|||Maybe something like:
USE Northwind
GO
SELECT * FROM Orders l
INNER JOIN (SELECT OrderId, MAX(OrderDate) AS OrderDate
FROM Orders
GROUP BY OrderId) AS r
ON l.OrderId = r.OrderId
AND l.OrderDate = r.OrderDate|||...that'll work if he can specify a secondary sort order.
obviously, I'm a newbie, so please forgive me for using the wrong terms accidently.
I have created a view that looks like this:
ID Disc Cut
------
1 11 25
1 5 34
2 1 67
3 8 54
4 5 14
4 1 12
...
ID is a bigint, Disc & Cut ar varchars
As you can see, the ID is not the primary key.
Still, what I need is only the record of the first occurance of each ID,
like this:
ID Disc Cut
------
1 11 25
2 1 67
3 8 54
4 5 14
...
Is there a way that I can iterate through the view and compare one record to
the previous or next?
(I didn't find anything in the Microsoft Library yet...)
Thanks!
NinaHave you tried SELECT DISTINCT ID FROM ...|||Originally posted by grahamt
Have you tried SELECT DISTINCT ID FROM ...
That wouldn't work because these rows:
1 11 25
1 5 34
are not distinct but I need only one of them.|||There is no such thing as "First" in SQL server unless you specify a sort order. You obviously have your data sorted by ID, but after that SQL Server make no guarantee as to the order in which your data will be returned.
It could easily be returned like this on some subsequent execution:
ID Disc Cut
------
1 11 25
1 5 34
2 1 67
3 8 54
4 1 12
4 5 14
You will need to specify a secondary sort order in order to select between duplicate ID values.|||Maybe something like:
USE Northwind
GO
SELECT * FROM Orders l
INNER JOIN (SELECT OrderId, MAX(OrderDate) AS OrderDate
FROM Orders
GROUP BY OrderId) AS r
ON l.OrderId = r.OrderId
AND l.OrderDate = r.OrderDate|||...that'll work if he can specify a secondary sort order.
Friday, March 23, 2012
Issuse with Landscape printing
I created a landscape report using the VS 2005 Sql reporting. I have edited my margins to be 1 in all around on the top bottom right and left. I have also set my width to 11in and hieght to 8.5 inches. I set the interactivesort to 11 in width X 0 height for lanscape every thing prints out in landscape and all colums are viewable. I have verified the width of my tables, headers and footers not to be over 8in. I am having a two fold problem Problem 1 is I am getting a blank page that includes the header after each page with data this is doubling the print job size fro 10 pages to 20 pages. I need to understand what I may have wrong and how to fix this. The second issue is the report view only show 3 pages in its listing instead of the 10 it should show or the 20 pages if blankpages are included. Please explain why and what needs to be corrected.
hey , I think you set the margin but you Report Body width didn't correctly configured ,
set your Report Body width to 9inch because you set the margin to 1 inch , it mean you should set your body to 9 inch 11 - 1 - 1 = 9
;)
|||I print my report in portrait only. But I can give u sm tips which might be of use. My reports' interactive size is 8.5" x 11.5 " the margins are 0.5",0",0",0'
The body height however is of no imp just check the width, mine is 8"(8.5-0.5) but the height is 14.5" in order to accomodate all my rpt items.
To debug, colour the background of your report to check where it spills over. Sometimes an extra space after a ctrl will result in a blank page.
As for your second issue the reportviewer only breaks after a physical page break not with a soft break.
Hope this helps
................................................................................................
remember toMark as Answer if the post helped you
Monday, March 12, 2012
Issues
Hi,
I've installed SQL Express as the default 'SQLExpress' install (windows
authentication) and while I can connect fine to my created databases from VS
Web Edition 2005 (using the test server) I cannot get access to the database
s
from IIS http://localhost/test.aspx for example. I've worked through variou
s
issues to get to this point and I now just want to use a connection string
i.e. string strConn = "Initial Catalog=Pandora; Integrated Security=True;
Database=Pandora; Server=WireslessBliss;"; to connect to my database and
while it doesn't initially throw an error as soon as I run the
objConn.Open(); line:
SqlConnection objConn = new SqlConnection(strConn);
SqlCommand objCommand = new SqlCommand("SELECT * FROM CatInfo2;", objConn);
objConn.Open();
(using the namespaces <%@. Import Namespace="System.Data"%>
<%@. Import Namespace="System.Data.SqlClient"%> )
it says this...Exception Details: System.Data.SqlClient.SqlException:
Timeout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding. And points to the objConn.Open()
;
line.
I am really frustrated by this as all I am trying to do is connect so I can
do a little hand coding without VS to get more of a feel for whats going on
with dotNet. I am just starting SQL Express as a move up from Access
Can someone PLEASE help!!
Thanks in advance.
AlexTry this one:
Dim cn As ADODB.Connection
Set cn = New Connection
cn.ConnectionString = "Provider=SQLNCLI.1;Integrated Security=SSPI;" & _
"Persist Security Info=False;" & _
"AttachDBFileName=" & App.Path & "\BDatos.mdf;Data
Source=servidor\sqlexpress"
73
"Alex" <Alex@.discussions.microsoft.com> escribi en el mensaje
news:40FA2342-7D46-44B4-A18A-3626B4C06541@.microsoft.com...
> Hi,
> I've installed SQL Express as the default 'SQLExpress' install (windows
> authentication) and while I can connect fine to my created databases from
> VS
> Web Edition 2005 (using the test server) I cannot get access to the
> databases
> from IIS http://localhost/test.aspx for example. I've worked through
> various
> issues to get to this point and I now just want to use a connection string
> i.e. string strConn = "Initial Catalog=Pandora; Integrated Security=True;
> Database=Pandora; Server=WireslessBliss;"; to connect to my database and
> while it doesn't initially throw an error as soon as I run the
> objConn.Open(); line:
> SqlConnection objConn = new SqlConnection(strConn);
> SqlCommand objCommand = new SqlCommand("SELECT * FROM CatInfo2;",
> objConn);
> objConn.Open();
> (using the namespaces <%@. Import Namespace="System.Data"%>
> <%@. Import Namespace="System.Data.SqlClient"%> )
> it says this...Exception Details: System.Data.SqlClient.SqlException:
> Timeout expired. The timeout period elapsed prior to completion of the
> operation or the server is not responding. And points to the
> objConn.Open();
> line.
> I am really frustrated by this as all I am trying to do is connect so I
> can
> do a little hand coding without VS to get more of a feel for whats going
> on
> with dotNet. I am just starting SQL Express as a move up from Access
> Can someone PLEASE help!!
> Thanks in advance.
> Alex
I've installed SQL Express as the default 'SQLExpress' install (windows
authentication) and while I can connect fine to my created databases from VS
Web Edition 2005 (using the test server) I cannot get access to the database
s
from IIS http://localhost/test.aspx for example. I've worked through variou
s
issues to get to this point and I now just want to use a connection string
i.e. string strConn = "Initial Catalog=Pandora; Integrated Security=True;
Database=Pandora; Server=WireslessBliss;"; to connect to my database and
while it doesn't initially throw an error as soon as I run the
objConn.Open(); line:
SqlConnection objConn = new SqlConnection(strConn);
SqlCommand objCommand = new SqlCommand("SELECT * FROM CatInfo2;", objConn);
objConn.Open();
(using the namespaces <%@. Import Namespace="System.Data"%>
<%@. Import Namespace="System.Data.SqlClient"%> )
it says this...Exception Details: System.Data.SqlClient.SqlException:
Timeout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding. And points to the objConn.Open()
;
line.
I am really frustrated by this as all I am trying to do is connect so I can
do a little hand coding without VS to get more of a feel for whats going on
with dotNet. I am just starting SQL Express as a move up from Access
Can someone PLEASE help!!
Thanks in advance.
AlexTry this one:
Dim cn As ADODB.Connection
Set cn = New Connection
cn.ConnectionString = "Provider=SQLNCLI.1;Integrated Security=SSPI;" & _
"Persist Security Info=False;" & _
"AttachDBFileName=" & App.Path & "\BDatos.mdf;Data
Source=servidor\sqlexpress"
73
"Alex" <Alex@.discussions.microsoft.com> escribi en el mensaje
news:40FA2342-7D46-44B4-A18A-3626B4C06541@.microsoft.com...
> Hi,
> I've installed SQL Express as the default 'SQLExpress' install (windows
> authentication) and while I can connect fine to my created databases from
> VS
> Web Edition 2005 (using the test server) I cannot get access to the
> databases
> from IIS http://localhost/test.aspx for example. I've worked through
> various
> issues to get to this point and I now just want to use a connection string
> i.e. string strConn = "Initial Catalog=Pandora; Integrated Security=True;
> Database=Pandora; Server=WireslessBliss;"; to connect to my database and
> while it doesn't initially throw an error as soon as I run the
> objConn.Open(); line:
> SqlConnection objConn = new SqlConnection(strConn);
> SqlCommand objCommand = new SqlCommand("SELECT * FROM CatInfo2;",
> objConn);
> objConn.Open();
> (using the namespaces <%@. Import Namespace="System.Data"%>
> <%@. Import Namespace="System.Data.SqlClient"%> )
> it says this...Exception Details: System.Data.SqlClient.SqlException:
> Timeout expired. The timeout period elapsed prior to completion of the
> operation or the server is not responding. And points to the
> objConn.Open();
> line.
> I am really frustrated by this as all I am trying to do is connect so I
> can
> do a little hand coding without VS to get more of a feel for whats going
> on
> with dotNet. I am just starting SQL Express as a move up from Access
> Can someone PLEASE help!!
> Thanks in advance.
> Alex
Issues
Hi,
I've installed SQL Express as the default 'SQLExpress' install (windows
authentication) and while I can connect fine to my created databases from VS
Web Edition 2005 (using the test server) I cannot get access to the databases
from IIS http://localhost/test.aspx for example. I've worked through various
issues to get to this point and I now just want to use a connection string
i.e. string strConn = "Initial Catalog=Pandora; Integrated Security=True;
Database=Pandora; Server=WireslessBliss;"; to connect to my database and
while it doesn't initially throw an error as soon as I run the
objConn.Open(); line:
SqlConnection objConn = new SqlConnection(strConn);
SqlCommand objCommand = new SqlCommand("SELECT * FROM CatInfo2;", objConn);
objConn.Open();
(using the namespaces <%@. Import Namespace="System.Data"%>
<%@. Import Namespace="System.Data.SqlClient"%> )
it says this...Exception Details: System.Data.SqlClient.SqlException:
Timeout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding. And points to the objConn.Open();
line.
I am really frustrated by this as all I am trying to do is connect so I can
do a little hand coding without VS to get more of a feel for whats going on
with dotNet. I am just starting SQL Express as a move up from Access
Can someone PLEASE help!!
Thanks in advance.
Alex
Try this one:
Dim cn As ADODB.Connection
Set cn = New Connection
cn.ConnectionString = "Provider=SQLNCLI.1;Integrated Security=SSPI;" & _
"Persist Security Info=False;" & _
"AttachDBFileName=" & App.Path & "\BDatos.mdf;Data
Source=servidor\sqlexpress"
73
"Alex" <Alex@.discussions.microsoft.com> escribi en el mensaje
news:40FA2342-7D46-44B4-A18A-3626B4C06541@.microsoft.com...
> Hi,
> I've installed SQL Express as the default 'SQLExpress' install (windows
> authentication) and while I can connect fine to my created databases from
> VS
> Web Edition 2005 (using the test server) I cannot get access to the
> databases
> from IIS http://localhost/test.aspx for example. I've worked through
> various
> issues to get to this point and I now just want to use a connection string
> i.e. string strConn = "Initial Catalog=Pandora; Integrated Security=True;
> Database=Pandora; Server=WireslessBliss;"; to connect to my database and
> while it doesn't initially throw an error as soon as I run the
> objConn.Open(); line:
> SqlConnection objConn = new SqlConnection(strConn);
> SqlCommand objCommand = new SqlCommand("SELECT * FROM CatInfo2;",
> objConn);
> objConn.Open();
> (using the namespaces <%@. Import Namespace="System.Data"%>
> <%@. Import Namespace="System.Data.SqlClient"%> )
> it says this...Exception Details: System.Data.SqlClient.SqlException:
> Timeout expired. The timeout period elapsed prior to completion of the
> operation or the server is not responding. And points to the
> objConn.Open();
> line.
> I am really frustrated by this as all I am trying to do is connect so I
> can
> do a little hand coding without VS to get more of a feel for whats going
> on
> with dotNet. I am just starting SQL Express as a move up from Access
> Can someone PLEASE help!!
> Thanks in advance.
> Alex
I've installed SQL Express as the default 'SQLExpress' install (windows
authentication) and while I can connect fine to my created databases from VS
Web Edition 2005 (using the test server) I cannot get access to the databases
from IIS http://localhost/test.aspx for example. I've worked through various
issues to get to this point and I now just want to use a connection string
i.e. string strConn = "Initial Catalog=Pandora; Integrated Security=True;
Database=Pandora; Server=WireslessBliss;"; to connect to my database and
while it doesn't initially throw an error as soon as I run the
objConn.Open(); line:
SqlConnection objConn = new SqlConnection(strConn);
SqlCommand objCommand = new SqlCommand("SELECT * FROM CatInfo2;", objConn);
objConn.Open();
(using the namespaces <%@. Import Namespace="System.Data"%>
<%@. Import Namespace="System.Data.SqlClient"%> )
it says this...Exception Details: System.Data.SqlClient.SqlException:
Timeout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding. And points to the objConn.Open();
line.
I am really frustrated by this as all I am trying to do is connect so I can
do a little hand coding without VS to get more of a feel for whats going on
with dotNet. I am just starting SQL Express as a move up from Access
Can someone PLEASE help!!
Thanks in advance.
Alex
Try this one:
Dim cn As ADODB.Connection
Set cn = New Connection
cn.ConnectionString = "Provider=SQLNCLI.1;Integrated Security=SSPI;" & _
"Persist Security Info=False;" & _
"AttachDBFileName=" & App.Path & "\BDatos.mdf;Data
Source=servidor\sqlexpress"
73
"Alex" <Alex@.discussions.microsoft.com> escribi en el mensaje
news:40FA2342-7D46-44B4-A18A-3626B4C06541@.microsoft.com...
> Hi,
> I've installed SQL Express as the default 'SQLExpress' install (windows
> authentication) and while I can connect fine to my created databases from
> VS
> Web Edition 2005 (using the test server) I cannot get access to the
> databases
> from IIS http://localhost/test.aspx for example. I've worked through
> various
> issues to get to this point and I now just want to use a connection string
> i.e. string strConn = "Initial Catalog=Pandora; Integrated Security=True;
> Database=Pandora; Server=WireslessBliss;"; to connect to my database and
> while it doesn't initially throw an error as soon as I run the
> objConn.Open(); line:
> SqlConnection objConn = new SqlConnection(strConn);
> SqlCommand objCommand = new SqlCommand("SELECT * FROM CatInfo2;",
> objConn);
> objConn.Open();
> (using the namespaces <%@. Import Namespace="System.Data"%>
> <%@. Import Namespace="System.Data.SqlClient"%> )
> it says this...Exception Details: System.Data.SqlClient.SqlException:
> Timeout expired. The timeout period elapsed prior to completion of the
> operation or the server is not responding. And points to the
> objConn.Open();
> line.
> I am really frustrated by this as all I am trying to do is connect so I
> can
> do a little hand coding without VS to get more of a feel for whats going
> on
> with dotNet. I am just starting SQL Express as a move up from Access
> Can someone PLEASE help!!
> Thanks in advance.
> Alex
Issue working with symmetric key for encryption
Please be gentle...I am very new to working with SQL.
I have the need to encrypt my columns in SQL 2005. I have created a symmetric key 'SecureKey' as well as a secure certificate 'SecureCert'
I have ran the script to create the key and the certificate successfully. When I run "select * sys.symmetic_keys;" the key shows up...when I run "select * sys.certificates;" the cert shows up.
Here is my issue, in the security folder under my database, these two things do not show up in the appropriate folders. Also when I run my encryption scripts, I am getting an error of
"msg 15151, Level 16, State 1, Line 3
cannot find the symmetric key 'SecureKey', because it does not exist or you do not have permission"
Am I missing something?
Thanks
Did you open the symmetric key before you encrypt data? If the symmetric key is not opened you wont be able to work with it ... anyway here's how it's supposed to be done: (I'm in work so i cant test if code is true but if something is screwed up go to this site:
http://blogs.msdn.com/lcris/search.aspx?q=encryption+sql+server+2005&p=1
this is where i got most of info when i started)
create database demo;
use demo;
-- create the database master key
--since you created certificate already then master key must be set already
create master key encryption by password = 'Pufd&s@.))%';
-- create a simple employee table
create table t_employees (id int primary key, name varchar(300), salary varbinary(300));
-- create a certificate to protect the symmetric key that will encrypt the data
-- the certificate will be encrypted by the database master key
create certificate cert_sk_admin with subject = 'Certificate for accessing symmetric keys - for use by admin';
-- create a key to protect the employee sensitive data, in this case - the salary
create symmetric key sk_employees with algorithm = triple_des encryption by certificate cert_sk_admin;
-- open the key so that we can use it
open symmetric key sk_employees decryption by certificate cert_sk_admin;
-- verify key was opened
select * from sys.openkeys;
-- insert some data
-- we will use the id as an authenticator value to tie the salary to the employee id
insert into t_employees(id, name,salary) values ( 1,'Alice Smith', encryptbykey(key_guid('sk_employees'), '$200000'));
insert into t_employees(id,name,salary) values (2, 'Bob Jones', encryptbykey(key_guid('sk_employees'), '$100000'));
-- see the result; salary is encrypted
select * from t_employees;
-- create a view to automatically do the decryption
-- note that when decrypting we specify that the id should be used as authenticator
create view v_employees as select id, name, convert(varchar(10), decryptbykey(salary)) as salary from t_employees;
-- create another view for charles that will automatically open the key using his certificate and do the decryption
create view v_employees_auto as select id, name, convert(varchar(10), decryptbykeyautocert(cert_id('cert_sk_charles'), salary)) as salary from t_employees;
-- see the result, the decrypted data is available
select * from v_employees;
-- now close the key
close all symmetric keys;
-- verify key was closed
select * from sys.openkeys;
-- use the view that will automatically open the key
select * from v_employees_auto;
-- note that the key is also automatically closed by the above query
-- it is only opened for the duration of the query
select * from sys.openkeys;
Something I have recently learned: if you are testing as a low privileged user, then you must grant privileges to that use to see the key and cert. Something like:
GRANT CONTROL ON CERTIFICATE::[cert_SecretTable_SecretData_Key] TO [user_low_priv]
GRANT VIEW DEFINITION ON SYMMETRIC KEY::[SecretTable_SecretData_Key] TO [user_low_priv]
I have read it is better to use a view, but am having some problems of my own...
this snippet is from
http://blogs.technet.com/keithcombs/archive/2005/11/24/415079.aspx
|||Thanks for the replies...I now have the key and cert where they belong and they have started working...after I installed SP2.
NOW, I have issues with my decryption. I have ran my scripts to encrypt the data and it is working. I also ran the script to decrypt, and it worked once. I have tried to repeat the process, but with no luck... when I run the decrypt scipt it returns nothing...not a null or anything. I don't understand.
Here is my encryption
I open the key and the certificate
SELECT * FROM dbo.database
GO
UPDATE database
SET Value = EncryptByKey(Key_GUID('KeyName'), Value);
GO
close symmetric key KeyName;
Now to decrypt
SELECT Value
AS 'Encrypted Value',
CONVERT(varchar, DecryptByKey(Value))
AS 'Decrypted Value'
FROM database;
CLOSE SYMMETRIC KEY KeyName;
|||Hi, it looks like you are closing your symmetric key after the encryption, which is good practice. To perform the decryption, however, you will need to re-open your symmetric key. Thus before you perform your SELECT, you should once again run the OPEN SYMMETRIC KEY ... statement.
Please let us know if you run into any trouble with this and we will try to answer any questions you have.
Thanks,
Sung
|||Sung,
Thanks for the reply...I am sorry, I just forgot to put that part of the script in there. I am opening and closing the Key on the decrypt also.
Ron
|||In:
SELECT Value
AS 'Encrypted Value',
CONVERT(varchar, DecryptByKey(Value))
AS 'Decrypted Value'
FROM database;
you need to specifi length of varchar like this:
CONVERT(varchar(50), DecryptByKey(Value))
or something...
Issue with URL Encoding report's hyperlink value.
Hello,
I've created a hyperlink in a report. The hyperlink action is 'Jump to URL' The URL is http://ServerName/SomePage.aspx?AccountCode=####&InvoiceLevel=1
The hyperlink works just fine in the designer, it's value becomes http://ServerName/SomePage.aspx?AccountCode=%23%%23%%23%%23&InvoiceLevel=1, however when I run from the web the report's URL is not properly URL encoded. It's value is http://ServerName/SomePage.aspx?AccountCode=#%23%23%23&InvoiceLevel=1 which is incorrect since the browser now treats the # as a hash.
I've tried explicitly URL Encoding the #### in the function but the report returns an error. "http://ServerName/SomePage.aspx?AccountCode=" + System.Web.HttpUtility.UrlEncode(####) + "&InvoiceLevel=1"
I've tried it in RS2000 & RS2005, same results.
Help..
Robert.
It looks like the first pound sign (number sign, hash, tic-tac-toe, octothrope... call it what you will) is being interpreted as a URL anchor symbol.
Is the "access" param always literally "####"? If so it should work if you URLEncode yourself by typing "%23%23%23%23".
If the access param is dynamic and may or may not begin with a #, you could use the Replace function in an expression to encode any #'s.
-Chris|||
Thanks for your reply,
The AccountCode parameter value is dynamic and for the most part as meaningful data, however the data originates from the mainframe so there are values that start with #. I could encode it using the replace however the Accountcode could contain all possible characters. Any other suggestions.
Robert.
|||
Try using the UrlEncode function on the argument value, e.g.:
=Globals!ReportServerUrl+ "?" & Globals!ReportFolder & "/Report&Parameter=" &
System.Web.HttpUtility.UrlEncode(Fields!AccountID.Value)
See also MSDN:
http://msdn2.microsoft.com/en-us/library/system.web.httputility.urlencode.aspx
-- Robert
|||
I tried using System.Web.HttpUtility.UrlEncode. Look at my first post. It works in the designer but not in Report Manager. It's very easy to recreate. Here are the steps:
Add a new blank report to a project.
Drop on a text box and set the expression to System.Web.HttpUtility.UrlEncode("####")
click report properties, click the reference tag and add System.web.
Preview the report in the designer. It works just fine.
Deploy the report and then view it in Report Manager. It displays #errror. I suspected the Report Server is not able to find System.web.dll
Robert.
|||
Did you ever resolve this problem, as I've just hit it!
Issue with URL Encoding report's hyperlink value.
Hello,
I've created a hyperlink in a report. The hyperlink action is 'Jump to URL' The URL is http://ServerName/SomePage.aspx?AccountCode=####&InvoiceLevel=1
The hyperlink works just fine in the designer, it's value becomes http://ServerName/SomePage.aspx?AccountCode=%23%%23%%23%%23&InvoiceLevel=1, however when I run from the web the report's URL is not properly URL encoded. It's value is http://ServerName/SomePage.aspx?AccountCode=#%23%23%23&InvoiceLevel=1 which is incorrect since the browser now treats the # as a hash.
I've tried explicitly URL Encoding the #### in the function but the report returns an error. "http://ServerName/SomePage.aspx?AccountCode=" + System.Web.HttpUtility.UrlEncode(####) + "&InvoiceLevel=1"
I've tried it in RS2000 & RS2005, same results.
Help..
Robert.
It looks like the first pound sign (number sign, hash, tic-tac-toe, octothrope... call it what you will) is being interpreted as a URL anchor symbol.
Is the "access" param always literally "####"? If so it should work if you URLEncode yourself by typing "%23%23%23%23".
If the access param is dynamic and may or may not begin with a #, you could use the Replace function in an expression to encode any #'s.
-Chris|||
Thanks for your reply,
The AccountCode parameter value is dynamic and for the most part as meaningful data, however the data originates from the mainframe so there are values that start with #. I could encode it using the replace however the Accountcode could contain all possible characters. Any other suggestions.
Robert.
|||
Try using the UrlEncode function on the argument value, e.g.:
=Globals!ReportServerUrl+ "?" & Globals!ReportFolder & "/Report&Parameter=" &
System.Web.HttpUtility.UrlEncode(Fields!AccountID.Value)
See also MSDN:
http://msdn2.microsoft.com/en-us/library/system.web.httputility.urlencode.aspx
-- Robert
|||
I tried using System.Web.HttpUtility.UrlEncode. Look at my first post. It works in the designer but not in Report Manager. It's very easy to recreate. Here are the steps:
Add a new blank report to a project.
Drop on a text box and set the expression to System.Web.HttpUtility.UrlEncode("####")
click report properties, click the reference tag and add System.web.
Preview the report in the designer. It works just fine.
Deploy the report and then view it in Report Manager. It displays #errror. I suspected the Report Server is not able to find System.web.dll
Robert.
|||
Did you ever resolve this problem, as I've just hit it!
issue with update
Hello,
I have the following PERFORMANCE issue:
I have created a job that fill and update a database from a source db with same structure.
The problem is that at the beginning performance was good, now the source db and destination db are very large and time to import/update is to big.
INSERT code is made up comparing the pk column in the source and dest db, the missed ones are filled in the destination.
UPDATE: check col by col, if any change value exists, updated is performed with the following statement for any tables in the DB
UPDATE tableADest
SET col1=source.Col1, col2=source.col2, ... coln=source.coln
FROM tableASource source
INNER JOIN tableAdest dest
ON dest.colpk = source.colpk.
The main problem is that I cannot identify the row update in the souce db, everytime I have to compare the whole equivalent tables (source and dest db), because there are not timestamp, updated cols or any cols usefuls, to have a subset of data and find any new or upadeted rows.
How can I increase performance and reduce time of importing?
Thank
You can try the replication service instead of doing it manually, it will be faster than the DTS job.
If you want to it manually do the following operations,
1. Delete
2. Update
3. Insert
|||Hello,
thank, but at the beginning we tried with replication but there are some problems, so we decides to use other methods such as the above one.
Now, I am thinking to create a trigger on each big tables to identify what record is inserted new or updated. The trigger populate a table that represent only these pk. In this way I can make a subset of record that are only new or updated.
Issue with subscription and List
Hello,
I have created a report that includes a table within a list. The report
always renders correctly and as expected when accessed through a url. The
report never renders or gets emailed if rendered through a subscription. In
the log file I noticed the following error "The processing of group
expression for the list 'list1' cannot be performed. The comparison failed.
Please check the data type returned by group expression." If I remove the
List control, the report gets rendered correctly and emailed.
Can anyone shed some light on this problem?If you can create a sample report with this behavior based on either pubs or
northwind, we can take a look at it. You can send it to me (remove online
from my address)
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"JohnG" <JohnG@.discussions.microsoft.com> wrote in message
news:A209CD95-6710-4F72-B606-19ADA9CABE4B@.microsoft.com...
> Hello,
> I have created a report that includes a table within a list. The report
> always renders correctly and as expected when accessed through a url. The
> report never renders or gets emailed if rendered through a subscription.
> In
> the log file I noticed the following error "The processing of group
> expression for the list 'list1' cannot be performed. The comparison
> failed.
> Please check the data type returned by group expression." If I remove the
> List control, the report gets rendered correctly and emailed.
> Can anyone shed some light on this problem?
I have created a report that includes a table within a list. The report
always renders correctly and as expected when accessed through a url. The
report never renders or gets emailed if rendered through a subscription. In
the log file I noticed the following error "The processing of group
expression for the list 'list1' cannot be performed. The comparison failed.
Please check the data type returned by group expression." If I remove the
List control, the report gets rendered correctly and emailed.
Can anyone shed some light on this problem?If you can create a sample report with this behavior based on either pubs or
northwind, we can take a look at it. You can send it to me (remove online
from my address)
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"JohnG" <JohnG@.discussions.microsoft.com> wrote in message
news:A209CD95-6710-4F72-B606-19ADA9CABE4B@.microsoft.com...
> Hello,
> I have created a report that includes a table within a list. The report
> always renders correctly and as expected when accessed through a url. The
> report never renders or gets emailed if rendered through a subscription.
> In
> the log file I noticed the following error "The processing of group
> expression for the list 'list1' cannot be performed. The comparison
> failed.
> Please check the data type returned by group expression." If I remove the
> List control, the report gets rendered correctly and emailed.
> Can anyone shed some light on this problem?
Friday, March 9, 2012
Issue with OLE DB Command while writing to DB2 database
Hi,
I have created a package which uses the OLE DB Command as the target where I write the sql command to insert data into the table. The issue which I am facing is, while at the OLE DB COmmand , the package fails. I notices that it is not able to get the input columns which are mapped to the target columns.
The same package works fine when the target is on Oracle database or a SQL Server database.
For DB2, i have tried using the Microsoft OLE DB Driver for Db2, as the IBM DB2 Driver doesnt work for insert properly.
Any suggestion regarding this would be really helpful.
Thanks,
Manish
Some thoughts on this:
1. It is better to use the OLE DB Destination to insert data into a table instead of the OLE DB Command with an insert statement. You should give that a try.
2. Are you using the Microsoft OLE DB provider for DB2 from our SQL Server 2005 Feature Pack? That's the provider that's been tested with SSIS.
3. I don't understand what you mean by not able to get input columns. What are the error messages when the package fails?
|||Yes, I am using the Microsoft DB2 drivers only. Using the OLE DB Destination, it worls only for insert. But, I wanted to simulate a scenario, where we do, both insert and update to the target table. So, we used OLE DB Command, and wrote the insert/update query.
The same works fine on Oracle and SQL Server target database. But on DB2, it doesnt work, as in the OLE DB command, we need to map the input columns to the parameters value. The drivers are not able to fetch the input data, and everytime, it insert NULL as it is not able to get the input values.
Let me know if you need any more information on the same.
Issue with Index for Temp Table
Hi,
I have created a SP which uses # temp table.
i created Index for this temp table. The issue is first time when i run the sp it is slow and if i run seccond time the same sp with the same range as previous one the speed increases drastically.
has anybody encountered same problem.
can u pls help
TIAThe most likely answer is that on the first call the server has to load all of the requested data from the hard drives. on the 2nd call the data is most likely in the data cache for SQL server, in the drive array controller cache or some combination of both.
There is all so a procedure cach. If the proc hasn't been run recently SQL Server might have to load the code from the hard drives, on the 2nd call the proc is probably still in the procedure cache.
I have created a SP which uses # temp table.
i created Index for this temp table. The issue is first time when i run the sp it is slow and if i run seccond time the same sp with the same range as previous one the speed increases drastically.
has anybody encountered same problem.
can u pls help
TIAThe most likely answer is that on the first call the server has to load all of the requested data from the hard drives. on the 2nd call the data is most likely in the data cache for SQL server, in the drive array controller cache or some combination of both.
There is all so a procedure cach. If the proc hasn't been run recently SQL Server might have to load the code from the hard drives, on the 2nd call the proc is probably still in the procedure cache.
Wednesday, March 7, 2012
Issue with cursor
Hi
I have created a cursor with the following syntax: "DECLARE costs_cursor CURSOR SCROLL DYNAMIC FOR SELECT RegNumber, FirstName, LastName, Assessment, Catering, Travel, Accommodation, Other from dbo.T_Course_Data ORDER BY LastName OPEN costs_cursor" which works.
What I don't understand is why, when I attempt to update a value in the cursor, irrespective of whether I use the 'FOR UPDATE' option or not, I get the error message to the effect that the cursor cannot be updated because it is READ ONLY. Clearly (to my mind anyway) the cursor wasn't created as read only. My update statement is "Update dbo.T_Course_Data set Assessment='222' WHERE CURRENT OF costs_cursor"
The odd thing is I have another cursor in my app using the exact same statements and it doesn't give this error.
Please help if you can.
Neil
I beleive, the answer's here: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_con_07_66sz.asp|||The link in the other post explains the cursor conversions. Below is the SQL Server 2005 Books Online topic link:
http://msdn2.microsoft.com/en-us/library/ms190641.aspx
You can use the TYPE_WARNING option in the DECLARE CURSOR statement to detect these conversions in SQL Server 2005. See link below for more details:
http://msdn2.microsoft.com/en-us/library/ms180169.aspx
The best thing will be however to eliminate the use of cursor altogether to get better performance, cleaner code and maintainability. So post an example of what you are doing with the cursor and it will be easier to suggest a set-based solution.
|||Hi
Thanks. Your previous answers helped me find the answer. I didn't have a unique index on the table and adding this has solved the issue.
Regards
Neil
Issue while using Transfer Sql Server Objects tasks
Hi
I am trying to use Transfer SQL Server Object task to transfer various
DB objects from a Source DB to a newly created Destination DB. The
Destination DB is blank before this attempted transfer.
Now our source Db contains various SPs and views which internally
reference other SPs/Views of the same DB (source DB). For example we
have 2 SPs - SP1 and SP2. Now SP1 internally executes SP2. Whie using
transfer objects task, if we try to transfer all SPs only, we get an
error saying that SP2 does not exist while creating SP1. It seems SSIS
compiles objects while transfering them. We tried to set the
DelayValidation property of the entire package as well as the task to
True, but this didnt help either.
It would be great if someone could suggest some mechanism to prevent
compilation of objects, or any other method using which we can avoid
the problem that we are facing.
Thanks
Regards,
Piyush
I would redirect any failure to a logging table or other, or even ignore
errors.
On 1st pass sp1 will fail, but sp2 should still be created, correct? Then
perform a second pass which will cause sp2 to fail because already exists,
however sp1 will compile and create fine since dependency now exists...
You will get a quicker response if you post to dts group for ssis questions.
good luck.
ChrisB MCDBA
MSSQLConsulting.com
"whirlwnd" wrote:
> Hi
> I am trying to use Transfer SQL Server Object task to transfer various
> DB objects from a Source DB to a newly created Destination DB. The
> Destination DB is blank before this attempted transfer.
> Now our source Db contains various SPs and views which internally
> reference other SPs/Views of the same DB (source DB). For example we
> have 2 SPs - SP1 and SP2. Now SP1 internally executes SP2. Whie using
> transfer objects task, if we try to transfer all SPs only, we get an
> error saying that SP2 does not exist while creating SP1. It seems SSIS
> compiles objects while transfering them. We tried to set the
> DelayValidation property of the entire package as well as the task to
> True, but this didnt help either.
> It would be great if someone could suggest some mechanism to prevent
> compilation of objects, or any other method using which we can avoid
> the problem that we are facing.
> Thanks
> Regards,
> Piyush
>
I am trying to use Transfer SQL Server Object task to transfer various
DB objects from a Source DB to a newly created Destination DB. The
Destination DB is blank before this attempted transfer.
Now our source Db contains various SPs and views which internally
reference other SPs/Views of the same DB (source DB). For example we
have 2 SPs - SP1 and SP2. Now SP1 internally executes SP2. Whie using
transfer objects task, if we try to transfer all SPs only, we get an
error saying that SP2 does not exist while creating SP1. It seems SSIS
compiles objects while transfering them. We tried to set the
DelayValidation property of the entire package as well as the task to
True, but this didnt help either.
It would be great if someone could suggest some mechanism to prevent
compilation of objects, or any other method using which we can avoid
the problem that we are facing.
Thanks
Regards,
Piyush
I would redirect any failure to a logging table or other, or even ignore
errors.
On 1st pass sp1 will fail, but sp2 should still be created, correct? Then
perform a second pass which will cause sp2 to fail because already exists,
however sp1 will compile and create fine since dependency now exists...
You will get a quicker response if you post to dts group for ssis questions.
good luck.
ChrisB MCDBA
MSSQLConsulting.com
"whirlwnd" wrote:
> Hi
> I am trying to use Transfer SQL Server Object task to transfer various
> DB objects from a Source DB to a newly created Destination DB. The
> Destination DB is blank before this attempted transfer.
> Now our source Db contains various SPs and views which internally
> reference other SPs/Views of the same DB (source DB). For example we
> have 2 SPs - SP1 and SP2. Now SP1 internally executes SP2. Whie using
> transfer objects task, if we try to transfer all SPs only, we get an
> error saying that SP2 does not exist while creating SP1. It seems SSIS
> compiles objects while transfering them. We tried to set the
> DelayValidation property of the entire package as well as the task to
> True, but this didnt help either.
> It would be great if someone could suggest some mechanism to prevent
> compilation of objects, or any other method using which we can avoid
> the problem that we are facing.
> Thanks
> Regards,
> Piyush
>
Friday, February 24, 2012
Issue when exporting to Excel
Hello
I have created a SRS report which I export to Excel.
I have noticed that Excel has added additional columns and the data appears to be overlapping. (link to screenshot below).
When I attempt to create a pivot table from this data, I receive the error:
"The pivot table name is not valid. To create a pivot table report, you must
use data that is organized as a list with labelled columns. If you are changing the name of a pivot table field, you must type a new name for the field.
What have I done wrong?
http://www.adlibsoftware.com/KATHY/excel_output.bmp
I think the problem is related to merged cells.
When exporting, the Excel renderer tries to recreate the report visually as closely as possible. To arrange the various bits of your reports it often needs to merge cells.
I've been battling with this for a while and haven't found a foolproof way of dealing with it. Try to align and size your heading so that it lines up with the table cells. That should minize the amount of cell merging it does.
Issue in Domain User Accessing Report
Hello All,
I have created Reporting Services Report and I had given a user Browser
permissions to browse the report. But he is not able to get to the report.
The browser asks for userid and password and when typed it does not take it.
Only when I put the user in the local administrator group, the user is able
to see the report and all the reports.
I checked the app pool and it is running under network service and the
network service is in the local administrator group. Could anybody help?
Thanks!
--
SaravananOne thing you could try (and really is easier than adding user by user
browser permissions). Create a local group (I called mine Reports). Add all
users and groups of users to this report. Then add this group to the browser
role of Home. Everything inherits permissions from the Home directory.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
news:84A3066B-05BB-4360-8A8E-DCE0DFF6E50D@.microsoft.com...
> Hello All,
> I have created Reporting Services Report and I had given a user Browser
> permissions to browse the report. But he is not able to get to the report.
> The browser asks for userid and password and when typed it does not take
> it.
> Only when I put the user in the local administrator group, the user is
> able
> to see the report and all the reports.
> I checked the app pool and it is running under network service and the
> network service is in the local administrator group. Could anybody help?
> Thanks!
> --
> Saravanan|||Thanks Bruce for your response. I am starting to test with a user now and
that I would be putting the users in groups and assign permissions to the
group. My concern is that, whether the users needs to be on the local admin
group?. Am I missing anything?
--
Saravanan
"Bruce L-C [MVP]" wrote:
> One thing you could try (and really is easier than adding user by user
> browser permissions). Create a local group (I called mine Reports). Add all
> users and groups of users to this report. Then add this group to the browser
> role of Home. Everything inherits permissions from the Home directory.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
> news:84A3066B-05BB-4360-8A8E-DCE0DFF6E50D@.microsoft.com...
> > Hello All,
> > I have created Reporting Services Report and I had given a user Browser
> > permissions to browse the report. But he is not able to get to the report.
> > The browser asks for userid and password and when typed it does not take
> > it.
> >
> > Only when I put the user in the local administrator group, the user is
> > able
> > to see the report and all the reports.
> >
> > I checked the app pool and it is running under network service and the
> > network service is in the local administrator group. Could anybody help?
> >
> > Thanks!
> > --
> > Saravanan
>
>|||No, definitely not. Do not put the user in the local admin group. I think
what you are missing is the process of adding to a role. Click on the home
directory, details, security (on the left panel). Then add a role and use
the new group that you have and give it browsing rights).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
news:5A61A957-3E8B-464D-8E0F-D1DD886ADA39@.microsoft.com...
> Thanks Bruce for your response. I am starting to test with a user now and
> that I would be putting the users in groups and assign permissions to the
> group. My concern is that, whether the users needs to be on the local
> admin
> group?. Am I missing anything?
> --
> Saravanan
>
> "Bruce L-C [MVP]" wrote:
>> One thing you could try (and really is easier than adding user by user
>> browser permissions). Create a local group (I called mine Reports). Add
>> all
>> users and groups of users to this report. Then add this group to the
>> browser
>> role of Home. Everything inherits permissions from the Home directory.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
>> news:84A3066B-05BB-4360-8A8E-DCE0DFF6E50D@.microsoft.com...
>> > Hello All,
>> > I have created Reporting Services Report and I had given a user Browser
>> > permissions to browse the report. But he is not able to get to the
>> > report.
>> > The browser asks for userid and password and when typed it does not
>> > take
>> > it.
>> >
>> > Only when I put the user in the local administrator group, the user is
>> > able
>> > to see the report and all the reports.
>> >
>> > I checked the app pool and it is running under network service and the
>> > network service is in the local administrator group. Could anybody
>> > help?
>> >
>> > Thanks!
>> > --
>> > Saravanan
>>|||Thanks for the patience to answer me Bruce.
Before adding into the local administrators group, I tried that option too.
I included the group onto the Browser Role on the Home of Reporting Services,
then created the folder and I selected assign specific rights to the folder
I uploaded the reports , went to the security tab of the folder and included
the group into the Browser Role. As it did not work, I included the group
into local admin.
Thanks!
--
Saravanan
"Bruce L-C [MVP]" wrote:
> No, definitely not. Do not put the user in the local admin group. I think
> what you are missing is the process of adding to a role. Click on the home
> directory, details, security (on the left panel). Then add a role and use
> the new group that you have and give it browsing rights).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
> news:5A61A957-3E8B-464D-8E0F-D1DD886ADA39@.microsoft.com...
> > Thanks Bruce for your response. I am starting to test with a user now and
> > that I would be putting the users in groups and assign permissions to the
> > group. My concern is that, whether the users needs to be on the local
> > admin
> > group?. Am I missing anything?
> > --
> > Saravanan
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> One thing you could try (and really is easier than adding user by user
> >> browser permissions). Create a local group (I called mine Reports). Add
> >> all
> >> users and groups of users to this report. Then add this group to the
> >> browser
> >> role of Home. Everything inherits permissions from the Home directory.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
> >> news:84A3066B-05BB-4360-8A8E-DCE0DFF6E50D@.microsoft.com...
> >> > Hello All,
> >> > I have created Reporting Services Report and I had given a user Browser
> >> > permissions to browse the report. But he is not able to get to the
> >> > report.
> >> > The browser asks for userid and password and when typed it does not
> >> > take
> >> > it.
> >> >
> >> > Only when I put the user in the local administrator group, the user is
> >> > able
> >> > to see the report and all the reports.
> >> >
> >> > I checked the app pool and it is running under network service and the
> >> > network service is in the local administrator group. Could anybody
> >> > help?
> >> >
> >> > Thanks!
> >> > --
> >> > Saravanan
> >>
> >>
> >>
>
>|||When you assigned specific rights to the folder you overwrote the inherited
rights to Home. All the folders inherit from Home. First, try and get this
working without doing anything to the new folder.
Do this:
1. Add a user to a local group
2. Can they see Home (even if you don't have any folders)
3. Add a folder
4. Can they see this folder?
5. Add a report to the folder.
Again, don't touch any of the rights on the folder you should have to. The
only time to do this is if you want them in some folders and not others. In
that case you can give browsing rights to the folder and not to home and
then a link that brings them directly to the folder in question.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
news:7FF767C5-2371-4CFB-BAD9-120049766893@.microsoft.com...
> Thanks for the patience to answer me Bruce.
> Before adding into the local administrators group, I tried that option
> too.
> I included the group onto the Browser Role on the Home of Reporting
> Services,
> then created the folder and I selected assign specific rights to the
> folder
> I uploaded the reports , went to the security tab of the folder and
> included
> the group into the Browser Role. As it did not work, I included the group
> into local admin.
> Thanks!
> --
> Saravanan
>
> "Bruce L-C [MVP]" wrote:
>> No, definitely not. Do not put the user in the local admin group. I think
>> what you are missing is the process of adding to a role. Click on the
>> home
>> directory, details, security (on the left panel). Then add a role and use
>> the new group that you have and give it browsing rights).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
>> news:5A61A957-3E8B-464D-8E0F-D1DD886ADA39@.microsoft.com...
>> > Thanks Bruce for your response. I am starting to test with a user now
>> > and
>> > that I would be putting the users in groups and assign permissions to
>> > the
>> > group. My concern is that, whether the users needs to be on the local
>> > admin
>> > group?. Am I missing anything?
>> > --
>> > Saravanan
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> One thing you could try (and really is easier than adding user by user
>> >> browser permissions). Create a local group (I called mine Reports).
>> >> Add
>> >> all
>> >> users and groups of users to this report. Then add this group to the
>> >> browser
>> >> role of Home. Everything inherits permissions from the Home directory.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
>> >> news:84A3066B-05BB-4360-8A8E-DCE0DFF6E50D@.microsoft.com...
>> >> > Hello All,
>> >> > I have created Reporting Services Report and I had given a user
>> >> > Browser
>> >> > permissions to browse the report. But he is not able to get to the
>> >> > report.
>> >> > The browser asks for userid and password and when typed it does not
>> >> > take
>> >> > it.
>> >> >
>> >> > Only when I put the user in the local administrator group, the user
>> >> > is
>> >> > able
>> >> > to see the report and all the reports.
>> >> >
>> >> > I checked the app pool and it is running under network service and
>> >> > the
>> >> > network service is in the local administrator group. Could anybody
>> >> > help?
>> >> >
>> >> > Thanks!
>> >> > --
>> >> > Saravanan
>> >>
>> >>
>> >>
>>|||Hi Bruce,
Thanks for the step by step instructions. This is what I did
1. Created a Usergroup named ReportUsers
2. Included a Domain User into it (who does not have any access on the
machine)
3. I went to the Reporting services home and selected Properties > Security
and provided this group a role of Browser
4. I asked the user to go into the home page as
http://machinename/reports/Pages/Folder.aspx
5. The user is prompted with the a userid and password dialog box with the
machinename.domain.com in the dialog box above the userid text box.
Please let me know, if this makes sense.
Thanks for your support
--
Saravanan
"Bruce L-C [MVP]" wrote:
> When you assigned specific rights to the folder you overwrote the inherited
> rights to Home. All the folders inherit from Home. First, try and get this
> working without doing anything to the new folder.
> Do this:
> 1. Add a user to a local group
> 2. Can they see Home (even if you don't have any folders)
> 3. Add a folder
> 4. Can they see this folder?
> 5. Add a report to the folder.
> Again, don't touch any of the rights on the folder you should have to. The
> only time to do this is if you want them in some folders and not others. In
> that case you can give browsing rights to the folder and not to home and
> then a link that brings them directly to the folder in question.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
> news:7FF767C5-2371-4CFB-BAD9-120049766893@.microsoft.com...
> > Thanks for the patience to answer me Bruce.
> >
> > Before adding into the local administrators group, I tried that option
> > too.
> > I included the group onto the Browser Role on the Home of Reporting
> > Services,
> > then created the folder and I selected assign specific rights to the
> > folder
> >
> > I uploaded the reports , went to the security tab of the folder and
> > included
> > the group into the Browser Role. As it did not work, I included the group
> > into local admin.
> > Thanks!
> > --
> > Saravanan
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> No, definitely not. Do not put the user in the local admin group. I think
> >> what you are missing is the process of adding to a role. Click on the
> >> home
> >> directory, details, security (on the left panel). Then add a role and use
> >> the new group that you have and give it browsing rights).
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >>
> >> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
> >> news:5A61A957-3E8B-464D-8E0F-D1DD886ADA39@.microsoft.com...
> >> > Thanks Bruce for your response. I am starting to test with a user now
> >> > and
> >> > that I would be putting the users in groups and assign permissions to
> >> > the
> >> > group. My concern is that, whether the users needs to be on the local
> >> > admin
> >> > group?. Am I missing anything?
> >> > --
> >> > Saravanan
> >> >
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> One thing you could try (and really is easier than adding user by user
> >> >> browser permissions). Create a local group (I called mine Reports).
> >> >> Add
> >> >> all
> >> >> users and groups of users to this report. Then add this group to the
> >> >> browser
> >> >> role of Home. Everything inherits permissions from the Home directory.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
> >> >> news:84A3066B-05BB-4360-8A8E-DCE0DFF6E50D@.microsoft.com...
> >> >> > Hello All,
> >> >> > I have created Reporting Services Report and I had given a user
> >> >> > Browser
> >> >> > permissions to browse the report. But he is not able to get to the
> >> >> > report.
> >> >> > The browser asks for userid and password and when typed it does not
> >> >> > take
> >> >> > it.
> >> >> >
> >> >> > Only when I put the user in the local administrator group, the user
> >> >> > is
> >> >> > able
> >> >> > to see the report and all the reports.
> >> >> >
> >> >> > I checked the app pool and it is running under network service and
> >> >> > the
> >> >> > network service is in the local administrator group. Could anybody
> >> >> > help?
> >> >> >
> >> >> > Thanks!
> >> >> > --
> >> >> > Saravanan
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||When prompted can they do this:
domainname\username put into the userid box and then their password?
I had this happen to me before and tore my hair out resolving it. For me the
issue was that the server did not have a fixed IP address, it was using
DHCP. Once I made it a fixed IP address then the problem went away.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
news:0C759E42-7D5E-4CD0-872E-E7F1619884DE@.microsoft.com...
> Hi Bruce,
> Thanks for the step by step instructions. This is what I did
> 1. Created a Usergroup named ReportUsers
> 2. Included a Domain User into it (who does not have any access on the
> machine)
> 3. I went to the Reporting services home and selected Properties >
> Security
> and provided this group a role of Browser
> 4. I asked the user to go into the home page as
> http://machinename/reports/Pages/Folder.aspx
> 5. The user is prompted with the a userid and password dialog box with the
> machinename.domain.com in the dialog box above the userid text box.
> Please let me know, if this makes sense.
> Thanks for your support
> --
> Saravanan
>
> "Bruce L-C [MVP]" wrote:
>> When you assigned specific rights to the folder you overwrote the
>> inherited
>> rights to Home. All the folders inherit from Home. First, try and get
>> this
>> working without doing anything to the new folder.
>> Do this:
>> 1. Add a user to a local group
>> 2. Can they see Home (even if you don't have any folders)
>> 3. Add a folder
>> 4. Can they see this folder?
>> 5. Add a report to the folder.
>> Again, don't touch any of the rights on the folder you should have to.
>> The
>> only time to do this is if you want them in some folders and not others.
>> In
>> that case you can give browsing rights to the folder and not to home and
>> then a link that brings them directly to the folder in question.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
>> news:7FF767C5-2371-4CFB-BAD9-120049766893@.microsoft.com...
>> > Thanks for the patience to answer me Bruce.
>> >
>> > Before adding into the local administrators group, I tried that option
>> > too.
>> > I included the group onto the Browser Role on the Home of Reporting
>> > Services,
>> > then created the folder and I selected assign specific rights to the
>> > folder
>> >
>> > I uploaded the reports , went to the security tab of the folder and
>> > included
>> > the group into the Browser Role. As it did not work, I included the
>> > group
>> > into local admin.
>> > Thanks!
>> > --
>> > Saravanan
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> No, definitely not. Do not put the user in the local admin group. I
>> >> think
>> >> what you are missing is the process of adding to a role. Click on the
>> >> home
>> >> directory, details, security (on the left panel). Then add a role and
>> >> use
>> >> the new group that you have and give it browsing rights).
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >>
>> >> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
>> >> news:5A61A957-3E8B-464D-8E0F-D1DD886ADA39@.microsoft.com...
>> >> > Thanks Bruce for your response. I am starting to test with a user
>> >> > now
>> >> > and
>> >> > that I would be putting the users in groups and assign permissions
>> >> > to
>> >> > the
>> >> > group. My concern is that, whether the users needs to be on the
>> >> > local
>> >> > admin
>> >> > group?. Am I missing anything?
>> >> > --
>> >> > Saravanan
>> >> >
>> >> >
>> >> > "Bruce L-C [MVP]" wrote:
>> >> >
>> >> >> One thing you could try (and really is easier than adding user by
>> >> >> user
>> >> >> browser permissions). Create a local group (I called mine Reports).
>> >> >> Add
>> >> >> all
>> >> >> users and groups of users to this report. Then add this group to
>> >> >> the
>> >> >> browser
>> >> >> role of Home. Everything inherits permissions from the Home
>> >> >> directory.
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >>
>> >> >> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
>> >> >> news:84A3066B-05BB-4360-8A8E-DCE0DFF6E50D@.microsoft.com...
>> >> >> > Hello All,
>> >> >> > I have created Reporting Services Report and I had given a user
>> >> >> > Browser
>> >> >> > permissions to browse the report. But he is not able to get to
>> >> >> > the
>> >> >> > report.
>> >> >> > The browser asks for userid and password and when typed it does
>> >> >> > not
>> >> >> > take
>> >> >> > it.
>> >> >> >
>> >> >> > Only when I put the user in the local administrator group, the
>> >> >> > user
>> >> >> > is
>> >> >> > able
>> >> >> > to see the report and all the reports.
>> >> >> >
>> >> >> > I checked the app pool and it is running under network service
>> >> >> > and
>> >> >> > the
>> >> >> > network service is in the local administrator group. Could
>> >> >> > anybody
>> >> >> > help?
>> >> >> >
>> >> >> > Thanks!
>> >> >> > --
>> >> >> > Saravanan
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||Hi Bruce,
Thanks for your ideas.
Even if they put their Domain userid and password it is not letting them in.
I checked the IP configuration and I can see that the IP has been assigned
static
--
Saravanan
"Bruce L-C [MVP]" wrote:
> When prompted can they do this:
> domainname\username put into the userid box and then their password?
> I had this happen to me before and tore my hair out resolving it. For me the
> issue was that the server did not have a fixed IP address, it was using
> DHCP. Once I made it a fixed IP address then the problem went away.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
> news:0C759E42-7D5E-4CD0-872E-E7F1619884DE@.microsoft.com...
> > Hi Bruce,
> > Thanks for the step by step instructions. This is what I did
> > 1. Created a Usergroup named ReportUsers
> > 2. Included a Domain User into it (who does not have any access on the
> > machine)
> > 3. I went to the Reporting services home and selected Properties >
> > Security
> > and provided this group a role of Browser
> > 4. I asked the user to go into the home page as
> > http://machinename/reports/Pages/Folder.aspx
> > 5. The user is prompted with the a userid and password dialog box with the
> > machinename.domain.com in the dialog box above the userid text box.
> >
> > Please let me know, if this makes sense.
> > Thanks for your support
> > --
> > Saravanan
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> When you assigned specific rights to the folder you overwrote the
> >> inherited
> >> rights to Home. All the folders inherit from Home. First, try and get
> >> this
> >> working without doing anything to the new folder.
> >> Do this:
> >> 1. Add a user to a local group
> >> 2. Can they see Home (even if you don't have any folders)
> >> 3. Add a folder
> >> 4. Can they see this folder?
> >> 5. Add a report to the folder.
> >>
> >> Again, don't touch any of the rights on the folder you should have to.
> >> The
> >> only time to do this is if you want them in some folders and not others.
> >> In
> >> that case you can give browsing rights to the folder and not to home and
> >> then a link that brings them directly to the folder in question.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
> >> news:7FF767C5-2371-4CFB-BAD9-120049766893@.microsoft.com...
> >> > Thanks for the patience to answer me Bruce.
> >> >
> >> > Before adding into the local administrators group, I tried that option
> >> > too.
> >> > I included the group onto the Browser Role on the Home of Reporting
> >> > Services,
> >> > then created the folder and I selected assign specific rights to the
> >> > folder
> >> >
> >> > I uploaded the reports , went to the security tab of the folder and
> >> > included
> >> > the group into the Browser Role. As it did not work, I included the
> >> > group
> >> > into local admin.
> >> > Thanks!
> >> > --
> >> > Saravanan
> >> >
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> No, definitely not. Do not put the user in the local admin group. I
> >> >> think
> >> >> what you are missing is the process of adding to a role. Click on the
> >> >> home
> >> >> directory, details, security (on the left panel). Then add a role and
> >> >> use
> >> >> the new group that you have and give it browsing rights).
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >>
> >> >> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
> >> >> news:5A61A957-3E8B-464D-8E0F-D1DD886ADA39@.microsoft.com...
> >> >> > Thanks Bruce for your response. I am starting to test with a user
> >> >> > now
> >> >> > and
> >> >> > that I would be putting the users in groups and assign permissions
> >> >> > to
> >> >> > the
> >> >> > group. My concern is that, whether the users needs to be on the
> >> >> > local
> >> >> > admin
> >> >> > group?. Am I missing anything?
> >> >> > --
> >> >> > Saravanan
> >> >> >
> >> >> >
> >> >> > "Bruce L-C [MVP]" wrote:
> >> >> >
> >> >> >> One thing you could try (and really is easier than adding user by
> >> >> >> user
> >> >> >> browser permissions). Create a local group (I called mine Reports).
> >> >> >> Add
> >> >> >> all
> >> >> >> users and groups of users to this report. Then add this group to
> >> >> >> the
> >> >> >> browser
> >> >> >> role of Home. Everything inherits permissions from the Home
> >> >> >> directory.
> >> >> >>
> >> >> >>
> >> >> >> --
> >> >> >> Bruce Loehle-Conger
> >> >> >> MVP SQL Server Reporting Services
> >> >> >>
> >> >> >> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
> >> >> >> news:84A3066B-05BB-4360-8A8E-DCE0DFF6E50D@.microsoft.com...
> >> >> >> > Hello All,
> >> >> >> > I have created Reporting Services Report and I had given a user
> >> >> >> > Browser
> >> >> >> > permissions to browse the report. But he is not able to get to
> >> >> >> > the
> >> >> >> > report.
> >> >> >> > The browser asks for userid and password and when typed it does
> >> >> >> > not
> >> >> >> > take
> >> >> >> > it.
> >> >> >> >
> >> >> >> > Only when I put the user in the local administrator group, the
> >> >> >> > user
> >> >> >> > is
> >> >> >> > able
> >> >> >> > to see the report and all the reports.
> >> >> >> >
> >> >> >> > I checked the app pool and it is running under network service
> >> >> >> > and
> >> >> >> > the
> >> >> >> > network service is in the local administrator group. Could
> >> >> >> > anybody
> >> >> >> > help?
> >> >> >> >
> >> >> >> > Thanks!
> >> >> >> > --
> >> >> >> > Saravanan
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||> > > 5. The user is prompted with the a userid and password dialog box with the
> > > machinename.domain.com in the dialog box above the userid text box.
>
This sounds to me like it is related to permissions required to access
the report manager website (permissions set in IIS) rather than
permissions to access the reports via report manager. You may need to
give the user/group permission to read the actual folder where the
report server website is installed (should be similar to 'C:\Program
Files\Microsoft SQL Server\MSSQL\Reporting Services\'). Check to
ensure the user has these privileges.
Rowen|||Unless IIS permissions have been changed from outside of RS there is never a
need to do anything with IIS permissions. However, if anyone has been
changing permissions with IIS then there could be a problem with a mismatch
between the two.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rowen" <rowenmcd@.gmail.com> wrote in message
news:1170200769.300637.219980@.h3g2000cwc.googlegroups.com...
>> > > 5. The user is prompted with the a userid and password dialog box
>> > > with the
>> > > machinename.domain.com in the dialog box above the userid text box.
> This sounds to me like it is related to permissions required to access
> the report manager website (permissions set in IIS) rather than
> permissions to access the reports via report manager. You may need to
> give the user/group permission to read the actual folder where the
> report server website is installed (should be similar to 'C:\Program
> Files\Microsoft SQL Server\MSSQL\Reporting Services\'). Check to
> ensure the user has these privileges.
> Rowen
>|||Thanks Rowen and Bruce. No body changed the permissions on the server, but
when I followed Rowen's idea it worked. Now the users are able see the report
without Admin priveliges on the report server machine.
Again! Thanks a lot
--
Saravanan
"Bruce L-C [MVP]" wrote:
> Unless IIS permissions have been changed from outside of RS there is never a
> need to do anything with IIS permissions. However, if anyone has been
> changing permissions with IIS then there could be a problem with a mismatch
> between the two.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Rowen" <rowenmcd@.gmail.com> wrote in message
> news:1170200769.300637.219980@.h3g2000cwc.googlegroups.com...
> >
> >> > > 5. The user is prompted with the a userid and password dialog box
> >> > > with the
> >> > > machinename.domain.com in the dialog box above the userid text box.
> >>
> >
> > This sounds to me like it is related to permissions required to access
> > the report manager website (permissions set in IIS) rather than
> > permissions to access the reports via report manager. You may need to
> > give the user/group permission to read the actual folder where the
> > report server website is installed (should be similar to 'C:\Program
> > Files\Microsoft SQL Server\MSSQL\Reporting Services\'). Check to
> > ensure the user has these privileges.
> >
> > Rowen
> >
>
>|||On Feb 1, 5:32 am, Saravanan <Sarava...@.discussions.microsoft.com>
wrote:
> Thanks Rowen and Bruce. No body changed the permissions on the server, but
> when I followed Rowen's idea it worked. Now the users are able see the report
> without Admin priveliges on the report server machine.
> Again! Thanks a lot
> --
> Saravanan
> "Bruce L-C [MVP]" wrote:
> > Unless IIS permissions have been changed from outside of RS there is never a
> > need to do anything with IIS permissions. However, if anyone has been
> > changing permissions with IIS then there could be a problem with a mismatch
> > between the two.
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> > "Rowen" <rowen...@.gmail.com> wrote in message
> >news:1170200769.300637.219980@.h3g2000cwc.googlegroups.com...
> > >> > > 5. The user is prompted with the a userid and password dialog box
> > >> > > with the
> > >> > > machinename.domain.com in the dialog box above the userid text box.
> > > This sounds to me like it is related to permissions required to access
> > > the report manager website (permissions set in IIS) rather than
> > > permissions to access the reports via report manager. You may need to
> > > give the user/group permission to read the actual folder where the
> > > report server website is installed (should be similar to 'C:\Program
> > > Files\Microsoft SQL Server\MSSQL\Reporting Services\'). Check to
> > > ensure the user has these privileges.
> > > Rowen
Glad to hear this solved the problem. It may have been there since
reporting services was installed (particularly when using reporting
services 2003, which often requires manual configuration after
installation).
Rowen
I have created Reporting Services Report and I had given a user Browser
permissions to browse the report. But he is not able to get to the report.
The browser asks for userid and password and when typed it does not take it.
Only when I put the user in the local administrator group, the user is able
to see the report and all the reports.
I checked the app pool and it is running under network service and the
network service is in the local administrator group. Could anybody help?
Thanks!
--
SaravananOne thing you could try (and really is easier than adding user by user
browser permissions). Create a local group (I called mine Reports). Add all
users and groups of users to this report. Then add this group to the browser
role of Home. Everything inherits permissions from the Home directory.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
news:84A3066B-05BB-4360-8A8E-DCE0DFF6E50D@.microsoft.com...
> Hello All,
> I have created Reporting Services Report and I had given a user Browser
> permissions to browse the report. But he is not able to get to the report.
> The browser asks for userid and password and when typed it does not take
> it.
> Only when I put the user in the local administrator group, the user is
> able
> to see the report and all the reports.
> I checked the app pool and it is running under network service and the
> network service is in the local administrator group. Could anybody help?
> Thanks!
> --
> Saravanan|||Thanks Bruce for your response. I am starting to test with a user now and
that I would be putting the users in groups and assign permissions to the
group. My concern is that, whether the users needs to be on the local admin
group?. Am I missing anything?
--
Saravanan
"Bruce L-C [MVP]" wrote:
> One thing you could try (and really is easier than adding user by user
> browser permissions). Create a local group (I called mine Reports). Add all
> users and groups of users to this report. Then add this group to the browser
> role of Home. Everything inherits permissions from the Home directory.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
> news:84A3066B-05BB-4360-8A8E-DCE0DFF6E50D@.microsoft.com...
> > Hello All,
> > I have created Reporting Services Report and I had given a user Browser
> > permissions to browse the report. But he is not able to get to the report.
> > The browser asks for userid and password and when typed it does not take
> > it.
> >
> > Only when I put the user in the local administrator group, the user is
> > able
> > to see the report and all the reports.
> >
> > I checked the app pool and it is running under network service and the
> > network service is in the local administrator group. Could anybody help?
> >
> > Thanks!
> > --
> > Saravanan
>
>|||No, definitely not. Do not put the user in the local admin group. I think
what you are missing is the process of adding to a role. Click on the home
directory, details, security (on the left panel). Then add a role and use
the new group that you have and give it browsing rights).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
news:5A61A957-3E8B-464D-8E0F-D1DD886ADA39@.microsoft.com...
> Thanks Bruce for your response. I am starting to test with a user now and
> that I would be putting the users in groups and assign permissions to the
> group. My concern is that, whether the users needs to be on the local
> admin
> group?. Am I missing anything?
> --
> Saravanan
>
> "Bruce L-C [MVP]" wrote:
>> One thing you could try (and really is easier than adding user by user
>> browser permissions). Create a local group (I called mine Reports). Add
>> all
>> users and groups of users to this report. Then add this group to the
>> browser
>> role of Home. Everything inherits permissions from the Home directory.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
>> news:84A3066B-05BB-4360-8A8E-DCE0DFF6E50D@.microsoft.com...
>> > Hello All,
>> > I have created Reporting Services Report and I had given a user Browser
>> > permissions to browse the report. But he is not able to get to the
>> > report.
>> > The browser asks for userid and password and when typed it does not
>> > take
>> > it.
>> >
>> > Only when I put the user in the local administrator group, the user is
>> > able
>> > to see the report and all the reports.
>> >
>> > I checked the app pool and it is running under network service and the
>> > network service is in the local administrator group. Could anybody
>> > help?
>> >
>> > Thanks!
>> > --
>> > Saravanan
>>|||Thanks for the patience to answer me Bruce.
Before adding into the local administrators group, I tried that option too.
I included the group onto the Browser Role on the Home of Reporting Services,
then created the folder and I selected assign specific rights to the folder
I uploaded the reports , went to the security tab of the folder and included
the group into the Browser Role. As it did not work, I included the group
into local admin.
Thanks!
--
Saravanan
"Bruce L-C [MVP]" wrote:
> No, definitely not. Do not put the user in the local admin group. I think
> what you are missing is the process of adding to a role. Click on the home
> directory, details, security (on the left panel). Then add a role and use
> the new group that you have and give it browsing rights).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
> news:5A61A957-3E8B-464D-8E0F-D1DD886ADA39@.microsoft.com...
> > Thanks Bruce for your response. I am starting to test with a user now and
> > that I would be putting the users in groups and assign permissions to the
> > group. My concern is that, whether the users needs to be on the local
> > admin
> > group?. Am I missing anything?
> > --
> > Saravanan
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> One thing you could try (and really is easier than adding user by user
> >> browser permissions). Create a local group (I called mine Reports). Add
> >> all
> >> users and groups of users to this report. Then add this group to the
> >> browser
> >> role of Home. Everything inherits permissions from the Home directory.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
> >> news:84A3066B-05BB-4360-8A8E-DCE0DFF6E50D@.microsoft.com...
> >> > Hello All,
> >> > I have created Reporting Services Report and I had given a user Browser
> >> > permissions to browse the report. But he is not able to get to the
> >> > report.
> >> > The browser asks for userid and password and when typed it does not
> >> > take
> >> > it.
> >> >
> >> > Only when I put the user in the local administrator group, the user is
> >> > able
> >> > to see the report and all the reports.
> >> >
> >> > I checked the app pool and it is running under network service and the
> >> > network service is in the local administrator group. Could anybody
> >> > help?
> >> >
> >> > Thanks!
> >> > --
> >> > Saravanan
> >>
> >>
> >>
>
>|||When you assigned specific rights to the folder you overwrote the inherited
rights to Home. All the folders inherit from Home. First, try and get this
working without doing anything to the new folder.
Do this:
1. Add a user to a local group
2. Can they see Home (even if you don't have any folders)
3. Add a folder
4. Can they see this folder?
5. Add a report to the folder.
Again, don't touch any of the rights on the folder you should have to. The
only time to do this is if you want them in some folders and not others. In
that case you can give browsing rights to the folder and not to home and
then a link that brings them directly to the folder in question.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
news:7FF767C5-2371-4CFB-BAD9-120049766893@.microsoft.com...
> Thanks for the patience to answer me Bruce.
> Before adding into the local administrators group, I tried that option
> too.
> I included the group onto the Browser Role on the Home of Reporting
> Services,
> then created the folder and I selected assign specific rights to the
> folder
> I uploaded the reports , went to the security tab of the folder and
> included
> the group into the Browser Role. As it did not work, I included the group
> into local admin.
> Thanks!
> --
> Saravanan
>
> "Bruce L-C [MVP]" wrote:
>> No, definitely not. Do not put the user in the local admin group. I think
>> what you are missing is the process of adding to a role. Click on the
>> home
>> directory, details, security (on the left panel). Then add a role and use
>> the new group that you have and give it browsing rights).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
>> news:5A61A957-3E8B-464D-8E0F-D1DD886ADA39@.microsoft.com...
>> > Thanks Bruce for your response. I am starting to test with a user now
>> > and
>> > that I would be putting the users in groups and assign permissions to
>> > the
>> > group. My concern is that, whether the users needs to be on the local
>> > admin
>> > group?. Am I missing anything?
>> > --
>> > Saravanan
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> One thing you could try (and really is easier than adding user by user
>> >> browser permissions). Create a local group (I called mine Reports).
>> >> Add
>> >> all
>> >> users and groups of users to this report. Then add this group to the
>> >> browser
>> >> role of Home. Everything inherits permissions from the Home directory.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
>> >> news:84A3066B-05BB-4360-8A8E-DCE0DFF6E50D@.microsoft.com...
>> >> > Hello All,
>> >> > I have created Reporting Services Report and I had given a user
>> >> > Browser
>> >> > permissions to browse the report. But he is not able to get to the
>> >> > report.
>> >> > The browser asks for userid and password and when typed it does not
>> >> > take
>> >> > it.
>> >> >
>> >> > Only when I put the user in the local administrator group, the user
>> >> > is
>> >> > able
>> >> > to see the report and all the reports.
>> >> >
>> >> > I checked the app pool and it is running under network service and
>> >> > the
>> >> > network service is in the local administrator group. Could anybody
>> >> > help?
>> >> >
>> >> > Thanks!
>> >> > --
>> >> > Saravanan
>> >>
>> >>
>> >>
>>|||Hi Bruce,
Thanks for the step by step instructions. This is what I did
1. Created a Usergroup named ReportUsers
2. Included a Domain User into it (who does not have any access on the
machine)
3. I went to the Reporting services home and selected Properties > Security
and provided this group a role of Browser
4. I asked the user to go into the home page as
http://machinename/reports/Pages/Folder.aspx
5. The user is prompted with the a userid and password dialog box with the
machinename.domain.com in the dialog box above the userid text box.
Please let me know, if this makes sense.
Thanks for your support
--
Saravanan
"Bruce L-C [MVP]" wrote:
> When you assigned specific rights to the folder you overwrote the inherited
> rights to Home. All the folders inherit from Home. First, try and get this
> working without doing anything to the new folder.
> Do this:
> 1. Add a user to a local group
> 2. Can they see Home (even if you don't have any folders)
> 3. Add a folder
> 4. Can they see this folder?
> 5. Add a report to the folder.
> Again, don't touch any of the rights on the folder you should have to. The
> only time to do this is if you want them in some folders and not others. In
> that case you can give browsing rights to the folder and not to home and
> then a link that brings them directly to the folder in question.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
> news:7FF767C5-2371-4CFB-BAD9-120049766893@.microsoft.com...
> > Thanks for the patience to answer me Bruce.
> >
> > Before adding into the local administrators group, I tried that option
> > too.
> > I included the group onto the Browser Role on the Home of Reporting
> > Services,
> > then created the folder and I selected assign specific rights to the
> > folder
> >
> > I uploaded the reports , went to the security tab of the folder and
> > included
> > the group into the Browser Role. As it did not work, I included the group
> > into local admin.
> > Thanks!
> > --
> > Saravanan
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> No, definitely not. Do not put the user in the local admin group. I think
> >> what you are missing is the process of adding to a role. Click on the
> >> home
> >> directory, details, security (on the left panel). Then add a role and use
> >> the new group that you have and give it browsing rights).
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >>
> >> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
> >> news:5A61A957-3E8B-464D-8E0F-D1DD886ADA39@.microsoft.com...
> >> > Thanks Bruce for your response. I am starting to test with a user now
> >> > and
> >> > that I would be putting the users in groups and assign permissions to
> >> > the
> >> > group. My concern is that, whether the users needs to be on the local
> >> > admin
> >> > group?. Am I missing anything?
> >> > --
> >> > Saravanan
> >> >
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> One thing you could try (and really is easier than adding user by user
> >> >> browser permissions). Create a local group (I called mine Reports).
> >> >> Add
> >> >> all
> >> >> users and groups of users to this report. Then add this group to the
> >> >> browser
> >> >> role of Home. Everything inherits permissions from the Home directory.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
> >> >> news:84A3066B-05BB-4360-8A8E-DCE0DFF6E50D@.microsoft.com...
> >> >> > Hello All,
> >> >> > I have created Reporting Services Report and I had given a user
> >> >> > Browser
> >> >> > permissions to browse the report. But he is not able to get to the
> >> >> > report.
> >> >> > The browser asks for userid and password and when typed it does not
> >> >> > take
> >> >> > it.
> >> >> >
> >> >> > Only when I put the user in the local administrator group, the user
> >> >> > is
> >> >> > able
> >> >> > to see the report and all the reports.
> >> >> >
> >> >> > I checked the app pool and it is running under network service and
> >> >> > the
> >> >> > network service is in the local administrator group. Could anybody
> >> >> > help?
> >> >> >
> >> >> > Thanks!
> >> >> > --
> >> >> > Saravanan
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||When prompted can they do this:
domainname\username put into the userid box and then their password?
I had this happen to me before and tore my hair out resolving it. For me the
issue was that the server did not have a fixed IP address, it was using
DHCP. Once I made it a fixed IP address then the problem went away.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
news:0C759E42-7D5E-4CD0-872E-E7F1619884DE@.microsoft.com...
> Hi Bruce,
> Thanks for the step by step instructions. This is what I did
> 1. Created a Usergroup named ReportUsers
> 2. Included a Domain User into it (who does not have any access on the
> machine)
> 3. I went to the Reporting services home and selected Properties >
> Security
> and provided this group a role of Browser
> 4. I asked the user to go into the home page as
> http://machinename/reports/Pages/Folder.aspx
> 5. The user is prompted with the a userid and password dialog box with the
> machinename.domain.com in the dialog box above the userid text box.
> Please let me know, if this makes sense.
> Thanks for your support
> --
> Saravanan
>
> "Bruce L-C [MVP]" wrote:
>> When you assigned specific rights to the folder you overwrote the
>> inherited
>> rights to Home. All the folders inherit from Home. First, try and get
>> this
>> working without doing anything to the new folder.
>> Do this:
>> 1. Add a user to a local group
>> 2. Can they see Home (even if you don't have any folders)
>> 3. Add a folder
>> 4. Can they see this folder?
>> 5. Add a report to the folder.
>> Again, don't touch any of the rights on the folder you should have to.
>> The
>> only time to do this is if you want them in some folders and not others.
>> In
>> that case you can give browsing rights to the folder and not to home and
>> then a link that brings them directly to the folder in question.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
>> news:7FF767C5-2371-4CFB-BAD9-120049766893@.microsoft.com...
>> > Thanks for the patience to answer me Bruce.
>> >
>> > Before adding into the local administrators group, I tried that option
>> > too.
>> > I included the group onto the Browser Role on the Home of Reporting
>> > Services,
>> > then created the folder and I selected assign specific rights to the
>> > folder
>> >
>> > I uploaded the reports , went to the security tab of the folder and
>> > included
>> > the group into the Browser Role. As it did not work, I included the
>> > group
>> > into local admin.
>> > Thanks!
>> > --
>> > Saravanan
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> No, definitely not. Do not put the user in the local admin group. I
>> >> think
>> >> what you are missing is the process of adding to a role. Click on the
>> >> home
>> >> directory, details, security (on the left panel). Then add a role and
>> >> use
>> >> the new group that you have and give it browsing rights).
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >>
>> >> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
>> >> news:5A61A957-3E8B-464D-8E0F-D1DD886ADA39@.microsoft.com...
>> >> > Thanks Bruce for your response. I am starting to test with a user
>> >> > now
>> >> > and
>> >> > that I would be putting the users in groups and assign permissions
>> >> > to
>> >> > the
>> >> > group. My concern is that, whether the users needs to be on the
>> >> > local
>> >> > admin
>> >> > group?. Am I missing anything?
>> >> > --
>> >> > Saravanan
>> >> >
>> >> >
>> >> > "Bruce L-C [MVP]" wrote:
>> >> >
>> >> >> One thing you could try (and really is easier than adding user by
>> >> >> user
>> >> >> browser permissions). Create a local group (I called mine Reports).
>> >> >> Add
>> >> >> all
>> >> >> users and groups of users to this report. Then add this group to
>> >> >> the
>> >> >> browser
>> >> >> role of Home. Everything inherits permissions from the Home
>> >> >> directory.
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >>
>> >> >> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
>> >> >> news:84A3066B-05BB-4360-8A8E-DCE0DFF6E50D@.microsoft.com...
>> >> >> > Hello All,
>> >> >> > I have created Reporting Services Report and I had given a user
>> >> >> > Browser
>> >> >> > permissions to browse the report. But he is not able to get to
>> >> >> > the
>> >> >> > report.
>> >> >> > The browser asks for userid and password and when typed it does
>> >> >> > not
>> >> >> > take
>> >> >> > it.
>> >> >> >
>> >> >> > Only when I put the user in the local administrator group, the
>> >> >> > user
>> >> >> > is
>> >> >> > able
>> >> >> > to see the report and all the reports.
>> >> >> >
>> >> >> > I checked the app pool and it is running under network service
>> >> >> > and
>> >> >> > the
>> >> >> > network service is in the local administrator group. Could
>> >> >> > anybody
>> >> >> > help?
>> >> >> >
>> >> >> > Thanks!
>> >> >> > --
>> >> >> > Saravanan
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||Hi Bruce,
Thanks for your ideas.
Even if they put their Domain userid and password it is not letting them in.
I checked the IP configuration and I can see that the IP has been assigned
static
--
Saravanan
"Bruce L-C [MVP]" wrote:
> When prompted can they do this:
> domainname\username put into the userid box and then their password?
> I had this happen to me before and tore my hair out resolving it. For me the
> issue was that the server did not have a fixed IP address, it was using
> DHCP. Once I made it a fixed IP address then the problem went away.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
> news:0C759E42-7D5E-4CD0-872E-E7F1619884DE@.microsoft.com...
> > Hi Bruce,
> > Thanks for the step by step instructions. This is what I did
> > 1. Created a Usergroup named ReportUsers
> > 2. Included a Domain User into it (who does not have any access on the
> > machine)
> > 3. I went to the Reporting services home and selected Properties >
> > Security
> > and provided this group a role of Browser
> > 4. I asked the user to go into the home page as
> > http://machinename/reports/Pages/Folder.aspx
> > 5. The user is prompted with the a userid and password dialog box with the
> > machinename.domain.com in the dialog box above the userid text box.
> >
> > Please let me know, if this makes sense.
> > Thanks for your support
> > --
> > Saravanan
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> When you assigned specific rights to the folder you overwrote the
> >> inherited
> >> rights to Home. All the folders inherit from Home. First, try and get
> >> this
> >> working without doing anything to the new folder.
> >> Do this:
> >> 1. Add a user to a local group
> >> 2. Can they see Home (even if you don't have any folders)
> >> 3. Add a folder
> >> 4. Can they see this folder?
> >> 5. Add a report to the folder.
> >>
> >> Again, don't touch any of the rights on the folder you should have to.
> >> The
> >> only time to do this is if you want them in some folders and not others.
> >> In
> >> that case you can give browsing rights to the folder and not to home and
> >> then a link that brings them directly to the folder in question.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
> >> news:7FF767C5-2371-4CFB-BAD9-120049766893@.microsoft.com...
> >> > Thanks for the patience to answer me Bruce.
> >> >
> >> > Before adding into the local administrators group, I tried that option
> >> > too.
> >> > I included the group onto the Browser Role on the Home of Reporting
> >> > Services,
> >> > then created the folder and I selected assign specific rights to the
> >> > folder
> >> >
> >> > I uploaded the reports , went to the security tab of the folder and
> >> > included
> >> > the group into the Browser Role. As it did not work, I included the
> >> > group
> >> > into local admin.
> >> > Thanks!
> >> > --
> >> > Saravanan
> >> >
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> No, definitely not. Do not put the user in the local admin group. I
> >> >> think
> >> >> what you are missing is the process of adding to a role. Click on the
> >> >> home
> >> >> directory, details, security (on the left panel). Then add a role and
> >> >> use
> >> >> the new group that you have and give it browsing rights).
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >>
> >> >> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
> >> >> news:5A61A957-3E8B-464D-8E0F-D1DD886ADA39@.microsoft.com...
> >> >> > Thanks Bruce for your response. I am starting to test with a user
> >> >> > now
> >> >> > and
> >> >> > that I would be putting the users in groups and assign permissions
> >> >> > to
> >> >> > the
> >> >> > group. My concern is that, whether the users needs to be on the
> >> >> > local
> >> >> > admin
> >> >> > group?. Am I missing anything?
> >> >> > --
> >> >> > Saravanan
> >> >> >
> >> >> >
> >> >> > "Bruce L-C [MVP]" wrote:
> >> >> >
> >> >> >> One thing you could try (and really is easier than adding user by
> >> >> >> user
> >> >> >> browser permissions). Create a local group (I called mine Reports).
> >> >> >> Add
> >> >> >> all
> >> >> >> users and groups of users to this report. Then add this group to
> >> >> >> the
> >> >> >> browser
> >> >> >> role of Home. Everything inherits permissions from the Home
> >> >> >> directory.
> >> >> >>
> >> >> >>
> >> >> >> --
> >> >> >> Bruce Loehle-Conger
> >> >> >> MVP SQL Server Reporting Services
> >> >> >>
> >> >> >> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
> >> >> >> news:84A3066B-05BB-4360-8A8E-DCE0DFF6E50D@.microsoft.com...
> >> >> >> > Hello All,
> >> >> >> > I have created Reporting Services Report and I had given a user
> >> >> >> > Browser
> >> >> >> > permissions to browse the report. But he is not able to get to
> >> >> >> > the
> >> >> >> > report.
> >> >> >> > The browser asks for userid and password and when typed it does
> >> >> >> > not
> >> >> >> > take
> >> >> >> > it.
> >> >> >> >
> >> >> >> > Only when I put the user in the local administrator group, the
> >> >> >> > user
> >> >> >> > is
> >> >> >> > able
> >> >> >> > to see the report and all the reports.
> >> >> >> >
> >> >> >> > I checked the app pool and it is running under network service
> >> >> >> > and
> >> >> >> > the
> >> >> >> > network service is in the local administrator group. Could
> >> >> >> > anybody
> >> >> >> > help?
> >> >> >> >
> >> >> >> > Thanks!
> >> >> >> > --
> >> >> >> > Saravanan
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||> > > 5. The user is prompted with the a userid and password dialog box with the
> > > machinename.domain.com in the dialog box above the userid text box.
>
This sounds to me like it is related to permissions required to access
the report manager website (permissions set in IIS) rather than
permissions to access the reports via report manager. You may need to
give the user/group permission to read the actual folder where the
report server website is installed (should be similar to 'C:\Program
Files\Microsoft SQL Server\MSSQL\Reporting Services\'). Check to
ensure the user has these privileges.
Rowen|||Unless IIS permissions have been changed from outside of RS there is never a
need to do anything with IIS permissions. However, if anyone has been
changing permissions with IIS then there could be a problem with a mismatch
between the two.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rowen" <rowenmcd@.gmail.com> wrote in message
news:1170200769.300637.219980@.h3g2000cwc.googlegroups.com...
>> > > 5. The user is prompted with the a userid and password dialog box
>> > > with the
>> > > machinename.domain.com in the dialog box above the userid text box.
> This sounds to me like it is related to permissions required to access
> the report manager website (permissions set in IIS) rather than
> permissions to access the reports via report manager. You may need to
> give the user/group permission to read the actual folder where the
> report server website is installed (should be similar to 'C:\Program
> Files\Microsoft SQL Server\MSSQL\Reporting Services\'). Check to
> ensure the user has these privileges.
> Rowen
>|||Thanks Rowen and Bruce. No body changed the permissions on the server, but
when I followed Rowen's idea it worked. Now the users are able see the report
without Admin priveliges on the report server machine.
Again! Thanks a lot
--
Saravanan
"Bruce L-C [MVP]" wrote:
> Unless IIS permissions have been changed from outside of RS there is never a
> need to do anything with IIS permissions. However, if anyone has been
> changing permissions with IIS then there could be a problem with a mismatch
> between the two.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Rowen" <rowenmcd@.gmail.com> wrote in message
> news:1170200769.300637.219980@.h3g2000cwc.googlegroups.com...
> >
> >> > > 5. The user is prompted with the a userid and password dialog box
> >> > > with the
> >> > > machinename.domain.com in the dialog box above the userid text box.
> >>
> >
> > This sounds to me like it is related to permissions required to access
> > the report manager website (permissions set in IIS) rather than
> > permissions to access the reports via report manager. You may need to
> > give the user/group permission to read the actual folder where the
> > report server website is installed (should be similar to 'C:\Program
> > Files\Microsoft SQL Server\MSSQL\Reporting Services\'). Check to
> > ensure the user has these privileges.
> >
> > Rowen
> >
>
>|||On Feb 1, 5:32 am, Saravanan <Sarava...@.discussions.microsoft.com>
wrote:
> Thanks Rowen and Bruce. No body changed the permissions on the server, but
> when I followed Rowen's idea it worked. Now the users are able see the report
> without Admin priveliges on the report server machine.
> Again! Thanks a lot
> --
> Saravanan
> "Bruce L-C [MVP]" wrote:
> > Unless IIS permissions have been changed from outside of RS there is never a
> > need to do anything with IIS permissions. However, if anyone has been
> > changing permissions with IIS then there could be a problem with a mismatch
> > between the two.
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> > "Rowen" <rowen...@.gmail.com> wrote in message
> >news:1170200769.300637.219980@.h3g2000cwc.googlegroups.com...
> > >> > > 5. The user is prompted with the a userid and password dialog box
> > >> > > with the
> > >> > > machinename.domain.com in the dialog box above the userid text box.
> > > This sounds to me like it is related to permissions required to access
> > > the report manager website (permissions set in IIS) rather than
> > > permissions to access the reports via report manager. You may need to
> > > give the user/group permission to read the actual folder where the
> > > report server website is installed (should be similar to 'C:\Program
> > > Files\Microsoft SQL Server\MSSQL\Reporting Services\'). Check to
> > > ensure the user has these privileges.
> > > Rowen
Glad to hear this solved the problem. It may have been there since
reporting services was installed (particularly when using reporting
services 2003, which often requires manual configuration after
installation).
Rowen
Subscribe to:
Posts (Atom)