Showing posts with label cause. Show all posts
Showing posts with label cause. Show all posts

Friday, March 9, 2012

Open an existing report

Hi
Is it possible to connect to an existing project of reports?
cause i have made some reports on my workstation, deployed them on the
server and now some of the others from the office wants to connect to the
reports and tweak them a bit.
How do we do that?
/ChristianUse source control or a file share to share the reports projects (or reports
themselves and any corresponding shared datasources.) Once the reports are
modified, you'll need to publish them again.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Christian Larsen" <ChristianLarsen@.discussions.microsoft.com> wrote in
message news:E1BE650A-2812-4FEA-9AFD-FFB23304E40E@.microsoft.com...
> Hi
> Is it possible to connect to an existing project of reports?
> cause i have made some reports on my workstation, deployed them on the
> server and now some of the others from the office wants to connect to the
> reports and tweak them a bit.
> How do we do that?
> /Christian|||"Christian Larsen" <ChristianLarsen@.discussions.microsoft.com> wrote in message news:<E1BE650A-2812-4FEA-9AFD-FFB23304E40E@.microsoft.com>...
> Hi
> Is it possible to connect to an existing project of reports?
> cause i have made some reports on my workstation, deployed them on the
> server and now some of the others from the office wants to connect to the
> reports and tweak them a bit.
> How do we do that?
> /Christian
Hello Christian,
I'm using visual studio .net. There is the button "new element"
klicking an holding down the button gives you two choices: "add new
element" and "add existing element". They should select "add existing
element". Then a window opens up and they should be able to browse to
the destination where you delivered your report and then they should
be able to import the report. (This report displays on the end of
their list in the projectfolder explorer.)
Sorry when some buttons have similar names because i'm using a german
version and i don't know how these buttons or things are called in
english.
Hope i could help.
bye
Jens

Saturday, February 25, 2012

Only Administrator May Connect

What would cause a SQL Server 2000 Clustered server to
output the error message listed below. This is a Windows
2000 Advanced Server. The error was pulled out of the SQL
Server Errorlog.
Error Message:
Login failed for user 'DALLAS\BLKSDRRT'. Only
administrators may connect at this time.
Thank You,
Dan
You may have the database access restricted to members of db_owner, dbcreator or sysadmins. Administrators can set this using either SQL Enterprise Manager or the sp_dboptions '[database name]','dbo use only' TSQL command. If you run the previous comman
d (and you are in the sysadmin role or db_owner role) it will tell you if it is "ON" or "OFF".
|||This can also occur if SQL Server it self has been set to single user mode.
Rand
This posting is provided "as is" with no warranties and confers no rights.