Opening table in SQL Server 2005?

This ought to be easy. But I can't figure out how to do it.
Using Enterprise Manager in SQL Server 2000, I point to a table, select it,
right click and choose Open Table-> Return all rows. Now I have the table
open and I can edit to my heart's content.
How can I do the same thing in SQL Server 2005?
Hi
With Beta 2 of SQL Server 2005, that functionality is not included. It may
return in Beta 3.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"David" <David@.blackdeck.com> wrote in message
news:39F0E432-BC98-476D-8A8C-B4AAF8E76ED8@.microsoft.com...
> This ought to be easy. But I can't figure out how to do it.
> Using Enterprise Manager in SQL Server 2000, I point to a table, select
it,
> right click and choose Open Table-> Return all rows. Now I have the table
> open and I can edit to my heart's content.
> How can I do the same thing in SQL Server 2005?
|||You got to be kidding! I use that all the time! Will it definitely be in
the final release?
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> With Beta 2 of SQL Server 2005, that functionality is not included. It may
> return in Beta 3.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "David" <David@.blackdeck.com> wrote in message
> news:39F0E432-BC98-476D-8A8C-B4AAF8E76ED8@.microsoft.com...
> it,
>
>
sql

Opening a SP to modify gives incorrect name on TAB

In SQL Server Mangement Studio when I right click on stored procedure to modify the name on the tab does not have the name of the stored procedure on it.

Is there a way to turn this on? When I more than one open how do I tell where a certain sp is?

what u see in Management Studio is Schema.StoredProcedureName... u might be seeing in Summary window where u have Name first , then Schema and Then Created... Both are same ...

Madhu

|||

The tab name currently displays an autogenerated file name with server and database information (same as what a new query would do). It does not show the stored procedure name. Currently there is no way to turn this on. Please post a suggestion for this on http://connect.microsoft.com/sqlserver. Suggestions filed on this site go directly to our internal issue tracking system and are especially taken into consideration by the team while prioritizing the future work.

Thanks,
Kuntal

Open URL in New Browser

My report has a table that when I click on a cell it jumps to URL and open
it in the same browser window. How to open the URL in a new browser instead
of current browser window?
Thanks.You didn't ask about Excel but this response of mine to another post will
answer you question:
Depending on how you design your reports you can do the following to export
to Excel. Or, what I do sometimes is make a copy of the report and clean it
up for data export and then hide it in list view. If you export from Report
Manager it puts CSV data in unicode which Excel puts all in one column. If
you export in ASCII then Excel does just as you want. To prevent a problem
with cells (Excel will object to sorting the data) you need to remove any
textboxes you have (for instance with a title, showing the parameters run
etc) and instead add additional header rows, merge the cells and put your
text in there instead. I add a link at the top of the report that says
Export Data. With RS 2005 you will be able to configure it to use ASCII
instead of Unicode.
Here is an example of a Jump to URL link I use. This causes Excel to come up
with the data in a separate window:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"ME" <ME@.mail.com> wrote in message
news:OPWXUKT%23GHA.2408@.TK2MSFTNGP05.phx.gbl...
> My report has a table that when I click on a cell it jumps to URL and open
> it in the same browser window. How to open the URL in a new browser
> instead of current browser window?
> Thanks.
>|||Bruce,
The report I am viewing is in SQL 2000. I replaced your example with my
server name and parameter, it didn't work.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:e38AxLT%23GHA.4268@.TK2MSFTNGP02.phx.gbl...
> You didn't ask about Excel but this response of mine to another post will
> answer you question:
> Depending on how you design your reports you can do the following to
> export to Excel. Or, what I do sometimes is make a copy of the report and
> clean it up for data export and then hide it in list view. If you export
> from Report Manager it puts CSV data in unicode which Excel puts all in
> one column. If you export in ASCII then Excel does just as you want. To
> prevent a problem with cells (Excel will object to sorting the data) you
> need to remove any textboxes you have (for instance with a title, showing
> the parameters run etc) and instead add additional header rows, merge the
> cells and put your text in there instead. I add a link at the top of the
> report that says Export Data. With RS 2005 you will be able to configure
> it to use ASCII instead of Unicode.
> Here is an example of a Jump to URL link I use. This causes Excel to come
> up with the data in a separate window:
>
> ="javascript:void(window.open('" & Globals!ReportServerUrl &
> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "ME" <ME@.mail.com> wrote in message
> news:OPWXUKT%23GHA.2408@.TK2MSFTNGP05.phx.gbl...
>> My report has a table that when I click on a cell it jumps to URL and
>> open it in the same browser window. How to open the URL in a new browser
>> instead of current browser window?
>> Thanks.
>|||Use exactly what I have. Do not put in your server name. Replace just the
folder, report and parameters.
Even better, do a test with a report that is without parameters so you know
that is not a problem.
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" &
Parameters!ParamName.Value','_blank'))"
One last point, you cannot test this in the development environment, you
have to deploy it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"ME" <ME@.mail.com> wrote in message
news:O66gRCU%23GHA.3860@.TK2MSFTNGP02.phx.gbl...
> Bruce,
> The report I am viewing is in SQL 2000. I replaced your example with my
> server name and parameter, it didn't work.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:e38AxLT%23GHA.4268@.TK2MSFTNGP02.phx.gbl...
>> You didn't ask about Excel but this response of mine to another post will
>> answer you question:
>> Depending on how you design your reports you can do the following to
>> export to Excel. Or, what I do sometimes is make a copy of the report and
>> clean it up for data export and then hide it in list view. If you export
>> from Report Manager it puts CSV data in unicode which Excel puts all in
>> one column. If you export in ASCII then Excel does just as you want. To
>> prevent a problem with cells (Excel will object to sorting the data) you
>> need to remove any textboxes you have (for instance with a title, showing
>> the parameters run etc) and instead add additional header rows, merge the
>> cells and put your text in there instead. I add a link at the top of the
>> report that says Export Data. With RS 2005 you will be able to configure
>> it to use ASCII instead of Unicode.
>> Here is an example of a Jump to URL link I use. This causes Excel to come
>> up with the data in a separate window:
>>
>> ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
>> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "ME" <ME@.mail.com> wrote in message
>> news:OPWXUKT%23GHA.2408@.TK2MSFTNGP05.phx.gbl...
>> My report has a table that when I click on a cell it jumps to URL and
>> open it in the same browser window. How to open the URL in a new
>> browser instead of current browser window?
>> Thanks.
>>
>|||It worked finally. Thanks
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:eXGqvGU%23GHA.3456@.TK2MSFTNGP02.phx.gbl...
> Use exactly what I have. Do not put in your server name. Replace just the
> folder, report and parameters.
> Even better, do a test with a report that is without parameters so you
> know that is not a problem.
> ="javascript:void(window.open('" & Globals!ReportServerUrl &
> "?/SomeFolder/SomeReport&ParamName=" &
> Parameters!ParamName.Value','_blank'))"
> One last point, you cannot test this in the development environment, you
> have to deploy it.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "ME" <ME@.mail.com> wrote in message
> news:O66gRCU%23GHA.3860@.TK2MSFTNGP02.phx.gbl...
>> Bruce,
>> The report I am viewing is in SQL 2000. I replaced your example with my
>> server name and parameter, it didn't work.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:e38AxLT%23GHA.4268@.TK2MSFTNGP02.phx.gbl...
>> You didn't ask about Excel but this response of mine to another post
>> will answer you question:
>> Depending on how you design your reports you can do the following to
>> export to Excel. Or, what I do sometimes is make a copy of the report
>> and clean it up for data export and then hide it in list view. If you
>> export from Report Manager it puts CSV data in unicode which Excel puts
>> all in one column. If you export in ASCII then Excel does just as you
>> want. To prevent a problem with cells (Excel will object to sorting the
>> data) you need to remove any textboxes you have (for instance with a
>> title, showing the parameters run etc) and instead add additional header
>> rows, merge the cells and put your text in there instead. I add a link
>> at the top of the report that says Export Data. With RS 2005 you will be
>> able to configure it to use ASCII instead of Unicode.
>> Here is an example of a Jump to URL link I use. This causes Excel to
>> come up with the data in a separate window:
>>
>> ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
>> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "ME" <ME@.mail.com> wrote in message
>> news:OPWXUKT%23GHA.2408@.TK2MSFTNGP05.phx.gbl...
>> My report has a table that when I click on a cell it jumps to URL and
>> open it in the same browser window. How to open the URL in a new
>> browser instead of current browser window?
>> Thanks.
>>
>>
>

Open Table with Query to modify data

In Enterprise Manager, I would right click on the table, choose Open Table and Query where I could select specific records and (most importantly) could alter data in a record by deleting the text, adding or over-typing.

In 2005 Server Management Studio I just cannot figure how to do this. I'm guessing that I need the 'Script Table as' option but then what?

I have managed to open selected data using the New Query and then Design Query in Editor, but the results only appear in a kind of view form and I cannot seem to alter any of the data entries, I get dotted lines around the selected field.

Please help, it seemed so much easier in 2000!

(1) Open the database folder for the database that contains the target table; (2) locate the target table within the database; (3) right click on the target table; (4) select the "Open Table" option; (5) the table is opened and can now be edited.

See if this also works for you.

|||

Hi

Thanks for your reply, my problem is that the table we open most often in order to edit/change fields, has over 1.5 million record rows! So we're not keen on opening the whole table. The problem with using a query is that the results can't be edited.

|||YOu can, but it is sort of hidden in the toolbox pane. Use Open table > Stop the processing of the data rows (as you do not want to wait for 1,5M rows) using the red square at the bottom of the page. Switch on the SQL Pane using the little tool in the left corner (Show SQL Pane) > Modify your query to limit the results > Execute again > You should now be able to edit the data in the results pane.

Jens K. Suessmeyer

http://www.sqlserver2005.de
|||

Hi

Have done that and it works however, with more complex queries we prefer to use the Query Editor, selecting the field names and criteria in the grid and allowing the system to write the sql. Even with seemingly simple things like specifying a date time we are having to write the Convert DateTime instruction which is time consuming and somewhat frustrating.

I have worked out a stop gap solution in that I

1. open a New Query and then click the icon for Design Query in Editor

2. use the editor to write the query, copy the generated sql

3. open the table, stop the run of all records

4. Show the SQL pane and paste the query sql into it and run in order to get results that I can edit

It's not perfect and I have the problem that if I want to go back and adjust the query, I cannot open the original selection in Query Editor as it closes down after you have used it. I have to open up another new one and start again!

You could do all this in one window in Enterprise Manager, run a query, get 'editable' results and go back to the query to adjust it if need be, again getting 'editable' results.

Why have they removed this in 2005 and is it going to be resolved because I've now found other threads from users with the same problem.

Thanks

Annie

|||Well post it as a connect suggestion on http://connect.microsoft.com/sqlserver/Feedback :-)

Jens K. Suessmeyer

http://www.sqlserver2005.de
|||

Thanks Jens

Sorry we have only just set up the 2005 server and I am new to the forum so wasn't aware of the Connect site, but I will do that now.

Thanks again for the help

Open Table with Query to modify data

In Enterprise Manager, I would right click on the table, choose Open Table and Query where I could select specific records and (most importantly) could alter data in a record by deleting the text, adding or over-typing.

In 2005 Server Management Studio I just cannot figure how to do this. I'm guessing that I need the 'Script Table as' option but then what?

I have managed to open selected data using the New Query and then Design Query in Editor, but the results only appear in a kind of view form and I cannot seem to alter any of the data entries, I get dotted lines around the selected field.

Please help, it seemed so much easier in 2000!

(1) Open the database folder for the database that contains the target table; (2) locate the target table within the database; (3) right click on the target table; (4) select the "Open Table" option; (5) the table is opened and can now be edited.

See if this also works for you.

|||

Hi

Thanks for your reply, my problem is that the table we open most often in order to edit/change fields, has over 1.5 million record rows! So we're not keen on opening the whole table. The problem with using a query is that the results can't be edited.

|||YOu can, but it is sort of hidden in the toolbox pane. Use Open table > Stop the processing of the data rows (as you do not want to wait for 1,5M rows) using the red square at the bottom of the page. Switch on the SQL Pane using the little tool in the left corner (Show SQL Pane) > Modify your query to limit the results > Execute again > You should now be able to edit the data in the results pane.

Jens K. Suessmeyer

http://www.sqlserver2005.de
|||

Hi

Have done that and it works however, with more complex queries we prefer to use the Query Editor, selecting the field names and criteria in the grid and allowing the system to write the sql. Even with seemingly simple things like specifying a date time we are having to write the Convert DateTime instruction which is time consuming and somewhat frustrating.

I have worked out a stop gap solution in that I

1. open a New Query and then click the icon for Design Query in Editor

2. use the editor to write the query, copy the generated sql

3. open the table, stop the run of all records

4. Show the SQL pane and paste the query sql into it and run in order to get results that I can edit

It's not perfect and I have the problem that if I want to go back and adjust the query, I cannot open the original selection in Query Editor as it closes down after you have used it. I have to open up another new one and start again!

You could do all this in one window in Enterprise Manager, run a query, get 'editable' results and go back to the query to adjust it if need be, again getting 'editable' results.

Why have they removed this in 2005 and is it going to be resolved because I've now found other threads from users with the same problem.

Thanks

Annie

|||Well post it as a connect suggestion on http://connect.microsoft.com/sqlserver/Feedback :-)

Jens K. Suessmeyer

http://www.sqlserver2005.de
|||

Thanks Jens

Sorry we have only just set up the 2005 server and I am new to the forum so wasn't aware of the Connect site, but I will do that now.

Thanks again for the help

Open table + NULLs

In SQL Management studio, if I right-click on a table and click "Open table", it brings up the table, similar to return all rows in 2000. But if I go to the last row, and edit data in a cell and the word "NULL" is that cell because there is a Null value there, it actually keeps the word null in there as in "NULLnewdata".

Am I doing something wrong?My first suggestion would be to use an UPDATE statement to modify data, not the resultset. After that, make sure you have highlighted the word "NULL" before you start typing... wrote in message news:1305c385-434d-4f39-8ee2-993fecab5184@.discussions.microsoft.com...
> In SQL Management studio, if I right-click on a table and click "Open
> table", it brings up the table, similar to return all rows in 2000. But
> if I go to the last row, and edit data in a cell and the word "NULL" is
> that cell because there is a Null value there, it actually keeps the
> word null in there as in "NULLnewdata". >
> Am I doing something wrong?
>|||

Those are nice work arounds, but it seems to me like this is not the behavior that should be happening in the UI.

|||Well, I think part of the problem is your method. When I highlight a NULL value in Management Studio, it highlights the word. When I start typing, it replaces the word altogether. I can only reproduce your behavior if I highlight the cell, then click again. And I think had I happened upon that behavior naturally, I would have just remembered to not do it again. Sure, it's not the most intuitive thing in the world. But based on the number of people who are going to do it, my gut tells me that it will stay that way. You should still be using DML statements for modifying data, rather than relying on a GUI that is imperfect. Just because I can ride my tricycle to work doesn't make it the best choice. A wrote in message news:c9dd504e-ee88-4d2e-a773-24ae795050a5@.discussions.microsoft.com...
> Those are nice work arounds, but it seems to me like this is not the
> behavior that should be happening in the UI. >
>|||"Correct" method or not, I am just confirming that this is a bug and someone else is having the same issue, and it was not because I have an old build or something.
(They did have 5 years to test it) :)|||To be quite honest, I'm not sure how much usability testing went into these parts of the tools... most of them are holdovers from Enterprise Manager, with a different look and feel. I was going to say prettier but I think the jury is still out on that one. wrote in message news:bc733a59-8d05-452c-ab75-9b9e0d570fa7@.discussions.microsoft.com...
> "Correct" method or not, I am just confirming that this is a bug and
> someone else is having the same issue, and it was not because I have an
> old build or something.
> (They did have 5 years to test it) :)
>|||

I don't think there is a code defect here. I think it's just the way the grid metaphor works. We tried to make sure our grid controls work the same as other Microsoft grids so that whatever learning people have invested in other Microsoft products applies to SQL Server and Visual Studio. The same thing you're describing here happens to me occasionally in other grid-centric products, such as the grid in Microsoft Excel. I've just had to learn to make sure the cell contents are completely highlighted before I start typing to replace them.

In the case of the open table editor, once you change the cell contents, the open table editor replaces the DBNull value in the data set with whatever the cell contains. The open table editor doesn't know what you mean to have in the cell, so if you edit the cell contents to say "NULLnewdata", then that's what it changes the field data to.

|||

I see that this thread is ancient (in internet time!) but I have a highly similar question: I want to go the other way. That is, I want to NULLify a cell in the grid. Deleting the cell contents doesn't work (unless it's a char field) and typing 'NULL' doesn't work either (incorrect data type, or I get the string 'NULL' stored in the field). Is there any way to have a true NULL 'inserted' into a cell, through the grid control? Or can this only be done through DML?

Thanks,

Tom

|||

Tom,

I don't think you can enter NULL values into a cell by typing something. However, there is a trick. You can either find another NULL value in the grid or go to the very last row of the grid where a bunch of NULLs are listed. Then just hit CTRL+C to copy the value and CTRL+V to paste it to the cell you want to add NULL to.

Thanks!

|||Three things.
1.) Ctrl-0 (read control-zero) = NULL
2.) Saying that that's the expected behavior is a cheap Cop-out. Enterprise Manager 2000 did it just fine. There is NO REASON that the "new" "improved" product can't clear out a cell with a null value as soon as it has the focus. I know it's Friday, but c`mon.
3.) One thing I've noticed is that Management Studio was obviously written *by* and *for* Visual Studio .NET programmers. All other developers (VB6, ASP, C, C++, SQL, MS Access...) got screwed. The one thing enterprise manager 2000 was good at was building queries. It did a good job. SQL Mgmt. Studio sucks at that. It does a horrible job. It takes me 20-30% longer to write queries in the new software. Let me run enterprise manager against SQL Server 2005 to build queries and I'll be a happy man.

Open table + NULLs

In SQL Management studio, if I right-click on a table and click "Open table", it brings up the table, similar to return all rows in 2000. But if I go to the last row, and edit data in a cell and the word "NULL" is that cell because there is a Null value there, it actually keeps the word null in there as in "NULLnewdata".

Am I doing something wrong?My first suggestion would be to use an UPDATE statement to modify data, not

the resultset.

After that, make sure you have highlighted the word "NULL" before you start

typing...

wrote in message

news:1305c385-434d-4f39-8ee2-993fecab5184@.discussions.microsoft.com...

> In SQL Management studio, if I right-click on a table and click "Open

> table", it brings up the table, similar to return all rows in 2000. But

> if I go to the last row, and edit data in a cell and the word "NULL" is

> that cell because there is a Null value there, it actually keeps the

> word null in there as in "NULLnewdata".

>

> Am I doing something wrong?

>|||

Those are nice work arounds, but it seems to me like this is not the behavior that should be happening in the UI.

|||Well, I think part of the problem is your method. When I highlight a NULL

value in Management Studio, it highlights the word. When I start typing, it

replaces the word altogether. I can only reproduce your behavior if I

highlight the cell, then click again. And I think had I happened upon that

behavior naturally, I would have just remembered to not do it again.

Sure, it's not the most intuitive thing in the world. But based on the

number of people who are going to do it, my gut tells me that it will stay

that way.

You should still be using DML statements for modifying data, rather than

relying on a GUI that is imperfect. Just because I can ride my tricycle to

work doesn't make it the best choice.

A

wrote in message

news:c9dd504e-ee88-4d2e-a773-24ae795050a5@.discussions.microsoft.com...

> Those are nice work arounds, but it seems to me like this is not the

> behavior that should be happening in the UI.

>

>|||"Correct" method or not, I am just confirming that this is a bug and someone else is having the same issue, and it was not because I have an old build or something.
(They did have 5 years to test it) :)|||To be quite honest, I'm not sure how much usability testing went into these

parts of the tools... most of them are holdovers from Enterprise Manager,

with a different look and feel. I was going to say prettier but I think the

jury is still out on that one.

wrote in message

news:bc733a59-8d05-452c-ab75-9b9e0d570fa7@.discussions.microsoft.com...

> "Correct" method or not, I am just confirming that this is a bug and

> someone else is having the same issue, and it was not because I have an

> old build or something.

> (They did have 5 years to test it) :)

>|||

I don't think there is a code defect here. I think it's just the way the grid metaphor works. We tried to make sure our grid controls work the same as other Microsoft grids so that whatever learning people have invested in other Microsoft products applies to SQL Server and Visual Studio. The same thing you're describing here happens to me occasionally in other grid-centric products, such as the grid in Microsoft Excel. I've just had to learn to make sure the cell contents are completely highlighted before I start typing to replace them.

In the case of the open table editor, once you change the cell contents, the open table editor replaces the DBNull value in the data set with whatever the cell contains. The open table editor doesn't know what you mean to have in the cell, so if you edit the cell contents to say "NULLnewdata", then that's what it changes the field data to.

|||

I see that this thread is ancient (in internet time!) but I have a highly similar question: I want to go the other way. That is, I want to NULLify a cell in the grid. Deleting the cell contents doesn't work (unless it's a char field) and typing 'NULL' doesn't work either (incorrect data type, or I get the string 'NULL' stored in the field). Is there any way to have a true NULL 'inserted' into a cell, through the grid control? Or can this only be done through DML?

Thanks,

Tom

|||

Tom,

I don't think you can enter NULL values into a cell by typing something. However, there is a trick. You can either find another NULL value in the grid or go to the very last row of the grid where a bunch of NULLs are listed. Then just hit CTRL+C to copy the value and CTRL+V to paste it to the cell you want to add NULL to.

Thanks!

|||Three things.

1.) Ctrl-0 (read control-zero) = NULL

2.) Saying that that's the expected behavior is a cheap Cop-out.

Enterprise Manager 2000 did it just fine. There is NO REASON that

the "new" "improved" product can't clear out a cell with a null value

as soon as it has the focus. I know it's Friday, but c`mon.

3.) One thing I've noticed is that Management Studio was obviously

written *by* and *for* Visual Studio .NET programmers. All other

developers (VB6, ASP, C, C++, SQL, MS Access...) got screwed. The

one thing enterprise manager 2000 was good at was building

queries. It did a good job. SQL Mgmt. Studio sucks at

that. It does a horrible job. It takes me 20-30% longer to

write queries in the new software. Let me run enterprise manager

against SQL Server 2005 to build queries and I'll be a happy man.sql

Open Query File dialog box

Hi,
SQL2K+SP4
When I load up Query Analyzer and click File -> Open to open up a query
file, the open file dialog is always sorted by - i don't know
alphabetically.
How can I set the default to open up with files ordered alphabetically?
Thanks
HelenaQuery Analyzer uses the default directory order for the system, which is set from a registry entry somewhere in the bowels of Windows itself. The default order can be changed for all of the applications on a machine, but I don't remember how.

-PatP|||in the open file dialog, you can view by "details" and then sort by name, size, type, or modified date.|||Pat, thanks for replay

"Query Analyzer uses the default directory order for the system"

The files in Explorer / Outlook Insert File dialog box are in alphabetic order.
Its only in QA the order is wrong.

Thanks,
Helena|||Jezemines answer is the one to go with. There's no point fussing over this imo!|||I know to order the files in the box but I'm handling big number of scripts and I each time I want to open file I need to sort it first - its annoying

Helena|||Just in case somebody has the same problem, here is the solution:

http://support.microsoft.com/kb/229070

Thanks
Helena|||You've GOT to be kidding|||I missed the part about her using Windows 98, although I remember the problem from back then too. This became a registry fix starting with Windows 2000, but I don't remember the registry key or the values anymore because I haven't needed it for years.

-PatP

Open New Window for Action

I wonder if I can automatically pop-up a new window if I click Action
(hyperlink) in a report. Any suggestion will be welcomed. Thank You.
--
Regards,
Jono Indrawijaya
PT eBiz Cipta Solusi - Indonesia
Microsoft Certified PartnerIf you are running RS 2000 with SP1, you can use an expression for the
hyperlink like this:
="javascript:void(window.open('http://www.xyz.com"','_blank'))"
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jono Indrawijaya" <JonoIndrawijaya@.discussions.microsoft.com> wrote in
message news:9A19E3D3-500F-44F6-9120-402629ADE350@.microsoft.com...
>I wonder if I can automatically pop-up a new window if I click Action
> (hyperlink) in a report. Any suggestion will be welcomed. Thank You.
> --
> Regards,
> Jono Indrawijaya
> PT eBiz Cipta Solusi - Indonesia
> Microsoft Certified Partner|||Did you mean, this:
="javascript:void(window.open('http://www.xyz.com','_blank'))"
I omit one extra double-quote. I've tried this, but it run the link in the
same window, plus with "The page cannot be displayed" error.
Where does my mistake? Thanks for Your Help
--
Regards,
Jono Indrawijaya
PT eBiz Cipta Solusi - Indonesia
Microsoft Certified Partner
"Robert Bruckner [MSFT]" wrote:
> If you are running RS 2000 with SP1, you can use an expression for the
> hyperlink like this:
> ="javascript:void(window.open('http://www.xyz.com"','_blank'))"
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Jono Indrawijaya" <JonoIndrawijaya@.discussions.microsoft.com> wrote in
> message news:9A19E3D3-500F-44F6-9120-402629ADE350@.microsoft.com...
> >I wonder if I can automatically pop-up a new window if I click Action
> > (hyperlink) in a report. Any suggestion will be welcomed. Thank You.
> >
> > --
> > Regards,
> > Jono Indrawijaya
> > PT eBiz Cipta Solusi - Indonesia
> > Microsoft Certified Partner
>
>

Open new window (URL)

Hi All

I tried to use the "="java script:void(window.open('http://www.microsoft.com','_blank'))"

in the URL (Action option), when I click on it, nothing happen (The cursor show that there is a link, changes into a hand).

Thank you

http://www.codeprof.com/dev-archive/10/19-82-107438.shtm

You almost had it!

Open a report in new window

Hi!

In Report Manager, when you click a report, Is it possible to open it in a new window?

Thanks!

Destry

There is no setting for this. You need to use right click 'Open in new Window'

-Daniel

Open a new report in a new window from existing

Hello all:
I need to open a new RS report from an existing RS report when the user
selects a distinct week # field.
I realize I right click the field / Properties / Advanced / Navigation I
believe I need to use the jump to URL.
I suspect I need a java script to create the new window with the report.
Can someone provide for me an example of the Java script necessary and
clarify my directions.
Also, does anyone know if this is explained WHERE I can find it in the
Hitchhikers Guide to Reporting Services - I have a copy and can not find the
resolution. I understand it is in Teo's book MS RS in Action; which I dont
own. All suggestions are welcome.
Thanks you in advance
Stuart
inventoryguy@.hotmail.comThis was introduced with SP1 which might be why it is not in your book. Here
is the syntax:
Here is an example of a Jump to URL link I use. This causes Excel to come up
with the data in a separate window:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
If you remove the format and encoding it will come up in HTML (the default
format if nothing is specified)
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stuart@.ICS" <inventory@.inventory.com> wrote in message
news:%23mau5rd9FHA.2792@.TK2MSFTNGP11.phx.gbl...
> Hello all:
> I need to open a new RS report from an existing RS report when the user
> selects a distinct week # field.
> I realize I right click the field / Properties / Advanced / Navigation I
> believe I need to use the jump to URL.
> I suspect I need a java script to create the new window with the report.
> Can someone provide for me an example of the Java script necessary and
> clarify my directions.
> Also, does anyone know if this is explained WHERE I can find it in the
> Hitchhikers Guide to Reporting Services - I have a copy and can not find
> the resolution. I understand it is in Teo's book MS RS in Action; which I
> dont own. All suggestions are welcome.
> Thanks you in advance
> Stuart
> inventoryguy@.hotmail.com
>|||Hello Bruce:
I get a URI Scheme is not valid error when I test the report.
My goal to to have a link off a field in report 1 when clicked open another
RS report in a new window.
The line I used is:
"javascript:void(window.open("https://server/ReportServer?%2fPRJfolder%2fRPTname"
& "&rs:Command=Render", "_blank",
"location=no,toolbar=no,left=100,top=100,height=600,width=800"))"
We have SP1 loaded.
Can you tell me where we have errored in our code?
If we need to pass parameters how would the line be different, I the
similances of that in your code but would like to make certain of all your
suggestions.
Again, thank you for the help.
Stuart
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:eKs5Vbf9FHA.1844@.TK2MSFTNGP11.phx.gbl...
> This was introduced with SP1 which might be why it is not in your book.
> Here is the syntax:
> Here is an example of a Jump to URL link I use. This causes Excel to come
> up with the data in a separate window:
> ="javascript:void(window.open('" & Globals!ReportServerUrl &
> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
> If you remove the format and encoding it will come up in HTML (the default
> format if nothing is specified)
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Stuart@.ICS" <inventory@.inventory.com> wrote in message
> news:%23mau5rd9FHA.2792@.TK2MSFTNGP11.phx.gbl...
>> Hello all:
>> I need to open a new RS report from an existing RS report when the user
>> selects a distinct week # field.
>> I realize I right click the field / Properties / Advanced / Navigation I
>> believe I need to use the jump to URL.
>> I suspect I need a java script to create the new window with the report.
>> Can someone provide for me an example of the Java script necessary and
>> clarify my directions.
>> Also, does anyone know if this is explained WHERE I can find it in the
>> Hitchhikers Guide to Reporting Services - I have a copy and can not find
>> the resolution. I understand it is in Teo's book MS RS in Action; which
>> I dont own. All suggestions are welcome.
>> Thanks you in advance
>> Stuart
>> inventoryguy@.hotmail.com
>>
>|||One thing I suggest, try it without any report first. Open up another web
page, google or whatever. Then you can make sure that you are using it
properly. Then open a report. One thing I am not sure of is the syntax you
you for location etc).
Looking at you have done, you are not doing what I did. I have single quotes
in places where you modified it to use double quotes. You are assembling a
string here. I use double quotes only between strings and then I have and &
concatenating the string. Look at mine closely, it was a working example.
The only place double quotes are used will have an ampersand either before
it or after it depending on whether I am starting a new string or ending it.
Looking at yours (not even worrying about what you have actual put there)
but without a doubt it is totally wrong just because of your use of double
quotes.
One easy thing to do, have a text box in a report. No dataset. Just a report
with a single text box. Set the source of the textbox to this expression so
you can see the result. Until you get the quotes correct it will keep
erroring out. Then once you have that correct you can see what your
resulting string looks like.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stuart@.ICS" <inventory@.inventory.com> wrote in message
news:%23TDOQ0f9FHA.3804@.TK2MSFTNGP14.phx.gbl...
> Hello Bruce:
> I get a URI Scheme is not valid error when I test the report.
> My goal to to have a link off a field in report 1 when clicked open
> another RS report in a new window.
> The line I used is:
> "javascript:void(window.open("https://server/ReportServer?%2fPRJfolder%2fRPTname"
> & "&rs:Command=Render", "_blank",
> "location=no,toolbar=no,left=100,top=100,height=600,width=800"))"
> We have SP1 loaded.
> Can you tell me where we have errored in our code?
> If we need to pass parameters how would the line be different, I the
> similances of that in your code but would like to make certain of all your
> suggestions.
> Again, thank you for the help.
> Stuart
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:eKs5Vbf9FHA.1844@.TK2MSFTNGP11.phx.gbl...
>> This was introduced with SP1 which might be why it is not in your book.
>> Here is the syntax:
>> Here is an example of a Jump to URL link I use. This causes Excel to come
>> up with the data in a separate window:
>> ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
>> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
>> If you remove the format and encoding it will come up in HTML (the
>> default format if nothing is specified)
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Stuart@.ICS" <inventory@.inventory.com> wrote in message
>> news:%23mau5rd9FHA.2792@.TK2MSFTNGP11.phx.gbl...
>> Hello all:
>> I need to open a new RS report from an existing RS report when the user
>> selects a distinct week # field.
>> I realize I right click the field / Properties / Advanced / Navigation I
>> believe I need to use the jump to URL.
>> I suspect I need a java script to create the new window with the report.
>> Can someone provide for me an example of the Java script necessary and
>> clarify my directions.
>> Also, does anyone know if this is explained WHERE I can find it in the
>> Hitchhikers Guide to Reporting Services - I have a copy and can not find
>> the resolution. I understand it is in Teo's book MS RS in Action; which
>> I dont own. All suggestions are welcome.
>> Thanks you in advance
>> Stuart
>> inventoryguy@.hotmail.com
>>
>>
>

Open / Read / Split / Insert / Repeat

Right now I have a web page that when you click on the only button on the page it opens a text file, reads a line from the text file, splits the comma separated line and stores it in to an array 'strData' and then moves on to the next line and repeats this process.

What I want to do before it goes to the next line is insert that strData in to a SQL DB.

This is my InsertCommand for my SqlDataSource1:
InsertCommand="INSERT INTO [Numbers] ([WTN], [DSL_Qualified], [DSL_Qualified_Date], [Equip_1MM], [Line_Trouble], [Sync_Rate], [Res_Bus], [Host_Remote]) VALUES (@.WTN, @.DSL_Qualified, @.DSL_Qualified_Date, @.Equip_1MM, @.Line_Trouble, @.Sync_Rate, @.Res_Bus, @.Host_Remote)"

Plus the <InsertParameters>:
<InsertParameters>
<asp:Parameter Name="WTN" Type="Int32" />
<asp:Parameter Name="DSL_Qualified" Type="String" />
<asp:Parameter Name="DSL_Qualified_Date" Type="DateTime" />
<asp:Parameter Name="Equip_1MM" Type="String" />
<asp:Parameter Name="Line_Trouble" Type="String" />
<asp:Parameter Name="Sync_Rate" Type="String" />
<asp:Parameter Name="Res_Bus" Type="String" />
<asp:Parameter Name="Host_Remote" Type="String" />
</InsertParameters
So I'm not sure exactly what to do after this:

while (file.Peek() > -1)
{
string strCSVData = file.ReadLine();

string [] strData = strCSVData.Split(',');

// somehow get strData in to the SqlDataSource1.Insert method??

}

Any help would be appreciated.

Thanks.

DataSource controls are meant to be databound to other controls. You can programmatically control them, but they can be a bit touchy if you do.

This is what you want:

(Written in vb.net, sorry)

Dim conn as new sqlconnection("{Your connect string here}") ' or pull from web.config

dim cmd as new sqlcommand("INSERT INTO [Numbers] ([WTN], [DSL_Qualified], [DSL_Qualified_Date], [Equip_1MM], [Line_Trouble], [Sync_Rate], [Res_Bus], [Host_Remote]) VALUES (@.WTN, @.DSL_Qualified, @.DSL_Qualified_Date, @.Equip_1MM, @.Line_Trouble, @.Sync_Rate, @.Res_Bus, @.Host_Remote)",conn)

cmd.parameters.add("@.WTN",int)

cmd.parameters.add("@.DSL_Qualified",varchar)

cmd.parameters.add("@.DSL_Qualified_Date",datetime)

{add rest of parameters here}

conn.open;

while (file.Peek() > -1)
{
string strCSVData = file.ReadLine();

string [] strData = strCSVData.Split(',');

// somehow get strData in to the SqlDataSource1.Insert method??

cmd.parameters("@.WTN").value=strData[0];

cmd.parameters("@.DSL_Qualified").value=strData[1];

{Set rest of parameters here}

cmd.executenonquery;

}

conn.close;

Your other choices if you really want to continue with the sqldatasource control, is to set the parameters using the default values, then call the .insert method of the datasource control. If that doesn't work, then you can make strData class scoped variable (Private member for C#?), call the .insert method, and catch the datasource_Inserting event, and set the sqlcommand parameters there via e.command.parameters.

Only able to access Report Manager as Administrator

Hi,

I have Reporting Services set up with the permissions (via Right Click Server/Permisions in SSMS or System Role Assignments in Report Manager) set as follows:

BUILTIN\Administrators - System Administrator

When logged in as an administrator I am able to access Report Manager, no problem.

However, I want to add a new group so that non-administrators can access Report Manager. However, whatever new item I add in the permissions appears to have no effect. For instance, if I add a permission for Users, i.e. :

BUILTIN\Administrators - System Administrator

BUILTIN\Users - System Administrator

I can still only access Report Manager as an administrator.. Any other user just gets the blank page.

I have tried creating a custom group, Report Users, with the same result.

I checked IIS to ensure anonymous access was turned off (this was an issue I had earlier on in my setup - it was turned on, but is now firmly off).

I don't know much about IIS, but I guess the problem is there somewhere. Does anybody have any idea what the problem could be and how I get around it?

Thanks very much in advance

Andy

Hi Andy! Reporting Services is Active Directory (AD) aware. If an AD group has been created (ex: reportusers), you can grant access to that group by going to the Home Folder in Report Manager and clicking on properties and then "New Role Assignment" where you would put something like this: DomainName\GroupID (ex: mydomain\reportusers).

If you are not using Active Directory, then please explain where (Report Manager or SQL Server Management Studio) you are creating your groups and how you have added security and we'll go from there.

|||

Hi Chuck,

Thank you so much for your reply.

I have to confess to not being an expert at Windows Server configuration.. and I'm not sure whether the server I am using employs Active Directory.. How can I tell?

I am creating the users in Admin Tools/Computer Management/Local Users and Groups.

I now have a user (MyUser) which is a member of a group (Report Users).

I have added this group in Management Studio (Right Click server/Permissions) as a System User. I am also able to add it via Report Manager/Site Security, it has the same effect.

What is interesting is that if I allow this group System Administrator access in Man. Studio, and I then log on as that user, I appear to have full access as I do for actual administrator users, but only within Management Studio. I still get the standard blank page (i.e. just "Home" bar but no visible reports) in Internet Explorer when connecting to Report Manager!

So there would appear to be some mismatch between what permissions I have within Report Manager versus Management Studio. My guess (and it's only a guess) is that there's either some IIS configuration that's wrong, or something in the security setup is blocking access via a web interface.

Hope this sheds some light on things.

Thanks again for your interest

Andy

|||

There are three types of Authentification in Reporting Services:

1) Integrated Windows Authentification (Active Directory aware) is the default authentification method for the Report Server and Report Manager virtual directories.

2) Anonymous access (only suggested if used with security extensions). Anonymous access limites your ability to vary role assignment because all users will access the Report Server under the Anonymous user account.

3) Basic Authentification, which should only be used with a Secure Sockets Layer (SSL) connection because Basic Authentification sends username and passwords to the server in clear text, which could be picked up with a network sniffer.

The Integrated Windows Authentification method is preferred and widely used. Your network administrator can setup Active Directory groups on the Domain Controller, which you can then grant those groups access to Reporting Services. If you network users have Unix, Mac, Novell or Linux accounts (non-Windows accounts) then you will need to go with Forms Authentification. Forms Authentification directs a request from an unauthenticated user to an HTML form, where they are prompted to enter a username and password. I have not used this method but many in this forum have and a quick search of the forum should return several useful posts.

|||

Hi Chuck,

Thanks very much for the information,

I am using Integrated Windows Authentication. The users I am dealing with are local to this server, it does not appear to be a domain server or to be part of a domain.

I can understand that my problem is to do with the security setup, but I can't get my head around what the difference is between accessing from Internet Explorer and accessing via Management Studio. It must, surely, be something to do with security for IIS rather than Reporting Services itself?

If so, can you give me any clues as to which permissions I should check and where? I can't tell whether it's withing IIS or some local policy on the server that is blocking the access.

Thanks again for your help and interest.

Regards,

Andy

|||

I eventually found out what this was..

It was nothing to do with Windows authentication - as I suspected because the access I granted worked in SSMS, but not via the web interface.

It was just that I had to add Browser access for my users via the Report Manager web interface .. on the home page/properties/New Role Assignment .. Once I did that everything worked as I had hoped.

A previous installation I carried out didn't require this.. I suspect that all users were granted Browser access by default, which wasn't the case here.

Thanks for your interest Chuck!

Andy

|||

Andy, I'm sorry I didn't suggest to verify the users had rights to the home page properties section first as this is required before giving them rights to any sub-folders you may create. I'm glad you figured this out and hope you enjoy reporting services as much as I have.

Only able to access Report Manager as Administrator

Hi,

I have Reporting Services set up with the permissions (via Right Click Server/Permisions in SSMS or System Role Assignments in Report Manager) set as follows:

BUILTIN\Administrators - System Administrator

When logged in as an administrator I am able to access Report Manager, no problem.

However, I want to add a new group so that non-administrators can access Report Manager. However, whatever new item I add in the permissions appears to have no effect. For instance, if I add a permission for Users, i.e. :

BUILTIN\Administrators - System Administrator

BUILTIN\Users - System Administrator

I can still only access Report Manager as an administrator.. Any other user just gets the blank page.

I have tried creating a custom group, Report Users, with the same result.

I checked IIS to ensure anonymous access was turned off (this was an issue I had earlier on in my setup - it was turned on, but is now firmly off).

I don't know much about IIS, but I guess the problem is there somewhere. Does anybody have any idea what the problem could be and how I get around it?

Thanks very much in advance

Andy

Hi Andy! Reporting Services is Active Directory (AD) aware. If an AD group has been created (ex: reportusers), you can grant access to that group by going to the Home Folder in Report Manager and clicking on properties and then "New Role Assignment" where you would put something like this: DomainName\GroupID (ex: mydomain\reportusers).

If you are not using Active Directory, then please explain where (Report Manager or SQL Server Management Studio) you are creating your groups and how you have added security and we'll go from there.

|||

Hi Chuck,

Thank you so much for your reply.

I have to confess to not being an expert at Windows Server configuration.. and I'm not sure whether the server I am using employs Active Directory.. How can I tell?

I am creating the users in Admin Tools/Computer Management/Local Users and Groups.

I now have a user (MyUser) which is a member of a group (Report Users).

I have added this group in Management Studio (Right Click server/Permissions) as a System User. I am also able to add it via Report Manager/Site Security, it has the same effect.

What is interesting is that if I allow this group System Administrator access in Man. Studio, and I then log on as that user, I appear to have full access as I do for actual administrator users, but only within Management Studio. I still get the standard blank page (i.e. just "Home" bar but no visible reports) in Internet Explorer when connecting to Report Manager!

So there would appear to be some mismatch between what permissions I have within Report Manager versus Management Studio. My guess (and it's only a guess) is that there's either some IIS configuration that's wrong, or something in the security setup is blocking access via a web interface.

Hope this sheds some light on things.

Thanks again for your interest

Andy

|||

There are three types of Authentification in Reporting Services:

1) Integrated Windows Authentification (Active Directory aware) is the default authentification method for the Report Server and Report Manager virtual directories.

2) Anonymous access (only suggested if used with security extensions). Anonymous access limites your ability to vary role assignment because all users will access the Report Server under the Anonymous user account.

3) Basic Authentification, which should only be used with a Secure Sockets Layer (SSL) connection because Basic Authentification sends username and passwords to the server in clear text, which could be picked up with a network sniffer.

The Integrated Windows Authentification method is preferred and widely used. Your network administrator can setup Active Directory groups on the Domain Controller, which you can then grant those groups access to Reporting Services. If you network users have Unix, Mac, Novell or Linux accounts (non-Windows accounts) then you will need to go with Forms Authentification. Forms Authentification directs a request from an unauthenticated user to an HTML form, where they are prompted to enter a username and password. I have not used this method but many in this forum have and a quick search of the forum should return several useful posts.

|||

Hi Chuck,

Thanks very much for the information,

I am using Integrated Windows Authentication. The users I am dealing with are local to this server, it does not appear to be a domain server or to be part of a domain.

I can understand that my problem is to do with the security setup, but I can't get my head around what the difference is between accessing from Internet Explorer and accessing via Management Studio. It must, surely, be something to do with security for IIS rather than Reporting Services itself?

If so, can you give me any clues as to which permissions I should check and where? I can't tell whether it's withing IIS or some local policy on the server that is blocking the access.

Thanks again for your help and interest.

Regards,

Andy

|||

I eventually found out what this was..

It was nothing to do with Windows authentication - as I suspected because the access I granted worked in SSMS, but not via the web interface.

It was just that I had to add Browser access for my users via the Report Manager web interface .. on the home page/properties/New Role Assignment .. Once I did that everything worked as I had hoped.

A previous installation I carried out didn't require this.. I suspect that all users were granted Browser access by default, which wasn't the case here.

Thanks for your interest Chuck!

Andy

|||

Andy, I'm sorry I didn't suggest to verify the users had rights to the home page properties section first as this is required before giving them rights to any sub-folders you may create. I'm glad you figured this out and hope you enjoy reporting services as much as I have.

Only able to access Report Manager as Administrator

Hi,

I have Reporting Services set up with the permissions (via Right Click Server/Permisions in SSMS or System Role Assignments in Report Manager) set as follows:

BUILTIN\Administrators - System Administrator

When logged in as an administrator I am able to access Report Manager, no problem.

However, I want to add a new group so that non-administrators can access Report Manager. However, whatever new item I add in the permissions appears to have no effect. For instance, if I add a permission for Users, i.e. :

BUILTIN\Administrators - System Administrator

BUILTIN\Users - System Administrator

I can still only access Report Manager as an administrator.. Any other user just gets the blank page.

I have tried creating a custom group, Report Users, with the same result.

I checked IIS to ensure anonymous access was turned off (this was an issue I had earlier on in my setup - it was turned on, but is now firmly off).

I don't know much about IIS, but I guess the problem is there somewhere. Does anybody have any idea what the problem could be and how I get around it?

Thanks very much in advance

Andy

Hi Andy! Reporting Services is Active Directory (AD) aware. If an AD group has been created (ex: reportusers), you can grant access to that group by going to the Home Folder in Report Manager and clicking on properties and then "New Role Assignment" where you would put something like this: DomainName\GroupID (ex: mydomain\reportusers).

If you are not using Active Directory, then please explain where (Report Manager or SQL Server Management Studio) you are creating your groups and how you have added security and we'll go from there.

|||

Hi Chuck,

Thank you so much for your reply.

I have to confess to not being an expert at Windows Server configuration.. and I'm not sure whether the server I am using employs Active Directory.. How can I tell?

I am creating the users in Admin Tools/Computer Management/Local Users and Groups.

I now have a user (MyUser) which is a member of a group (Report Users).

I have added this group in Management Studio (Right Click server/Permissions) as a System User. I am also able to add it via Report Manager/Site Security, it has the same effect.

What is interesting is that if I allow this group System Administrator access in Man. Studio, and I then log on as that user, I appear to have full access as I do for actual administrator users, but only within Management Studio. I still get the standard blank page (i.e. just "Home" bar but no visible reports) in Internet Explorer when connecting to Report Manager!

So there would appear to be some mismatch between what permissions I have within Report Manager versus Management Studio. My guess (and it's only a guess) is that there's either some IIS configuration that's wrong, or something in the security setup is blocking access via a web interface.

Hope this sheds some light on things.

Thanks again for your interest

Andy

|||

There are three types of Authentification in Reporting Services:

1) Integrated Windows Authentification (Active Directory aware) is the default authentification method for the Report Server and Report Manager virtual directories.

2) Anonymous access (only suggested if used with security extensions). Anonymous access limites your ability to vary role assignment because all users will access the Report Server under the Anonymous user account.

3) Basic Authentification, which should only be used with a Secure Sockets Layer (SSL) connection because Basic Authentification sends username and passwords to the server in clear text, which could be picked up with a network sniffer.

The Integrated Windows Authentification method is preferred and widely used. Your network administrator can setup Active Directory groups on the Domain Controller, which you can then grant those groups access to Reporting Services. If you network users have Unix, Mac, Novell or Linux accounts (non-Windows accounts) then you will need to go with Forms Authentification. Forms Authentification directs a request from an unauthenticated user to an HTML form, where they are prompted to enter a username and password. I have not used this method but many in this forum have and a quick search of the forum should return several useful posts.

|||

Hi Chuck,

Thanks very much for the information,

I am using Integrated Windows Authentication. The users I am dealing with are local to this server, it does not appear to be a domain server or to be part of a domain.

I can understand that my problem is to do with the security setup, but I can't get my head around what the difference is between accessing from Internet Explorer and accessing via Management Studio. It must, surely, be something to do with security for IIS rather than Reporting Services itself?

If so, can you give me any clues as to which permissions I should check and where? I can't tell whether it's withing IIS or some local policy on the server that is blocking the access.

Thanks again for your help and interest.

Regards,

Andy

|||

I eventually found out what this was..

It was nothing to do with Windows authentication - as I suspected because the access I granted worked in SSMS, but not via the web interface.

It was just that I had to add Browser access for my users via the Report Manager web interface .. on the home page/properties/New Role Assignment .. Once I did that everything worked as I had hoped.

A previous installation I carried out didn't require this.. I suspect that all users were granted Browser access by default, which wasn't the case here.

Thanks for your interest Chuck!

Andy

|||

Andy, I'm sorry I didn't suggest to verify the users had rights to the home page properties section first as this is required before giving them rights to any sub-folders you may create. I'm glad you figured this out and hope you enjoy reporting services as much as I have.

Only able to access Report Manager as Administrator

Hi,

I have Reporting Services set up with the permissions (via Right Click Server/Permisions in SSMS or System Role Assignments in Report Manager) set as follows:

BUILTIN\Administrators - System Administrator

When logged in as an administrator I am able to access Report Manager, no problem.

However, I want to add a new group so that non-administrators can access Report Manager. However, whatever new item I add in the permissions appears to have no effect. For instance, if I add a permission for Users, i.e. :

BUILTIN\Administrators - System Administrator

BUILTIN\Users - System Administrator

I can still only access Report Manager as an administrator.. Any other user just gets the blank page.

I have tried creating a custom group, Report Users, with the same result.

I checked IIS to ensure anonymous access was turned off (this was an issue I had earlier on in my setup - it was turned on, but is now firmly off).

I don't know much about IIS, but I guess the problem is there somewhere. Does anybody have any idea what the problem could be and how I get around it?

Thanks very much in advance

Andy

Hi Andy! Reporting Services is Active Directory (AD) aware. If an AD group has been created (ex: reportusers), you can grant access to that group by going to the Home Folder in Report Manager and clicking on properties and then "New Role Assignment" where you would put something like this: DomainName\GroupID (ex: mydomain\reportusers).

If you are not using Active Directory, then please explain where (Report Manager or SQL Server Management Studio) you are creating your groups and how you have added security and we'll go from there.

|||

Hi Chuck,

Thank you so much for your reply.

I have to confess to not being an expert at Windows Server configuration.. and I'm not sure whether the server I am using employs Active Directory.. How can I tell?

I am creating the users in Admin Tools/Computer Management/Local Users and Groups.

I now have a user (MyUser) which is a member of a group (Report Users).

I have added this group in Management Studio (Right Click server/Permissions) as a System User. I am also able to add it via Report Manager/Site Security, it has the same effect.

What is interesting is that if I allow this group System Administrator access in Man. Studio, and I then log on as that user, I appear to have full access as I do for actual administrator users, but only within Management Studio. I still get the standard blank page (i.e. just "Home" bar but no visible reports) in Internet Explorer when connecting to Report Manager!

So there would appear to be some mismatch between what permissions I have within Report Manager versus Management Studio. My guess (and it's only a guess) is that there's either some IIS configuration that's wrong, or something in the security setup is blocking access via a web interface.

Hope this sheds some light on things.

Thanks again for your interest

Andy

|||

There are three types of Authentification in Reporting Services:

1) Integrated Windows Authentification (Active Directory aware) is the default authentification method for the Report Server and Report Manager virtual directories.

2) Anonymous access (only suggested if used with security extensions). Anonymous access limites your ability to vary role assignment because all users will access the Report Server under the Anonymous user account.

3) Basic Authentification, which should only be used with a Secure Sockets Layer (SSL) connection because Basic Authentification sends username and passwords to the server in clear text, which could be picked up with a network sniffer.

The Integrated Windows Authentification method is preferred and widely used. Your network administrator can setup Active Directory groups on the Domain Controller, which you can then grant those groups access to Reporting Services. If you network users have Unix, Mac, Novell or Linux accounts (non-Windows accounts) then you will need to go with Forms Authentification. Forms Authentification directs a request from an unauthenticated user to an HTML form, where they are prompted to enter a username and password. I have not used this method but many in this forum have and a quick search of the forum should return several useful posts.

|||

Hi Chuck,

Thanks very much for the information,

I am using Integrated Windows Authentication. The users I am dealing with are local to this server, it does not appear to be a domain server or to be part of a domain.

I can understand that my problem is to do with the security setup, but I can't get my head around what the difference is between accessing from Internet Explorer and accessing via Management Studio. It must, surely, be something to do with security for IIS rather than Reporting Services itself?

If so, can you give me any clues as to which permissions I should check and where? I can't tell whether it's withing IIS or some local policy on the server that is blocking the access.

Thanks again for your help and interest.

Regards,

Andy

|||

I eventually found out what this was..

It was nothing to do with Windows authentication - as I suspected because the access I granted worked in SSMS, but not via the web interface.

It was just that I had to add Browser access for my users via the Report Manager web interface .. on the home page/properties/New Role Assignment .. Once I did that everything worked as I had hoped.

A previous installation I carried out didn't require this.. I suspect that all users were granted Browser access by default, which wasn't the case here.

Thanks for your interest Chuck!

Andy

|||

Andy, I'm sorry I didn't suggest to verify the users had rights to the home page properties section first as this is required before giving them rights to any sub-folders you may create. I'm glad you figured this out and hope you enjoy reporting services as much as I have.

online book "script error-object doesn't support this property or

When I click some link of book online, then an "Internet explorer Script
Error" comes out:
Line 1
char 1
Error: Object doesn't support this property or method
code 0
URL: ..
It works fine before. I don't know why this error show.vollen,
Can you reapply the latest Internet Explorer service pack? This should
fix it.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
vollen wrote:
> When I click some link of book online, then an "Internet explorer Script
> Error" comes out:
> Line 1
> char 1
> Error: Object doesn't support this property or method
> code 0
> URL: ..
>
> It works fine before. I don't know why this error show.