Deployment/copy of Db from remote server

I need to copy both schema and data from a remote db server at my ISP.
I used to use a Red Gate solution but dont have access to the proggie
anymore.
I then tried to use the import/export tool for the SQL 2005 server, but
view turned into tables and primary keys autoinc were not included.
What should I have done in order to get at complete copy. I cannot use
the backup function at the ISPs SQL server.The import/export wizard in 2005 doesn't expose the SQL Server specific ("script all objects and
then transfer the data). You find this in Integration Services, though.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"hnteknik" <Henrik.F.A.Nielsen@.gmail.com> wrote in message
news:1166181741.158144.213330@.n67g2000cwd.googlegroups.com...
>I need to copy both schema and data from a remote db server at my ISP.
> I used to use a Red Gate solution but dont have access to the proggie
> anymore.
> I then tried to use the import/export tool for the SQL 2005 server, but
> view turned into tables and primary keys autoinc were not included.
> What should I have done in order to get at complete copy. I cannot use
> the backup function at the ISPs SQL server.
>|||Tibor Karaszi skrev:
> The import/export wizard in 2005 doesn't expose the SQL Server specific ("script all objects and
> then transfer the data). You find this in Integration Services, though.
>
Thanks - I will give it a try.
Found out later that :
'The SQL Server Import and Export Wizard provides minimal
transformation capabilities. Except for setting the name, the data
type, and the data type properties of columns in new destination tables
and files, the SQL Server Import and Export Wizard supports no
column-level transformations.' :-(|||Hi John
I ran into this tool, which did the job of restoring my ISP DB as a
local DB on my server as it works both ways:
The Database Publishing Wizard enables the deployment of SQL Server
2005 databases (both schema and data) into a shared hosting environment
on either a SQL Server 2000 or 2005 server.
The tool supports two modes of deployment:
It generates a single SQL script file which can be used to recreate a
database when the only connectivity to a server is through a web-based
control panel with a script execution window.
It connects to a web service provided by your hoster and directly
creates objects on a specified hosted database
The Database Publishing Wizard provide both a graphical and a
command-line interface. In addition, it can integrate directly into
Visual Studio 2005 or Visual Web Developer 2005.
http://www.codeplex.com/sqlhost/Wiki/View.aspx?title=Database%20Publishing%20Wizard

Deployment/copy of Db from remote server

I need to copy both schema and data from a remote db server at my ISP.
I used to use a Red Gate solution but dont have access to the proggie
anymore.
I then tried to use the import/export tool for the SQL 2005 server, but
view turned into tables and primary keys autoinc were not included.
What should I have done in order to get at complete copy. I cannot use
the backup function at the ISPs SQL server.
Tibor Karaszi skrev:
> The import/export wizard in 2005 doesn't expose the SQL Server specific ("script all objects and
> then transfer the data). You find this in Integration Services, though.
>
Thanks - I will give it a try.
Found out later that :
'The SQL Server Import and Export Wizard provides minimal
transformation capabilities. Except for setting the name, the data
type, and the data type properties of columns in new destination tables
and files, the SQL Server Import and Export Wizard supports no
column-level transformations.' :-(
|||Hi
Even if you can't restore the backup, I would expect your ISP to do it for
you.
John
"hnteknik" wrote:

> I need to copy both schema and data from a remote db server at my ISP.
> I used to use a Red Gate solution but dont have access to the proggie
> anymore.
> I then tried to use the import/export tool for the SQL 2005 server, but
> view turned into tables and primary keys autoinc were not included.
> What should I have done in order to get at complete copy. I cannot use
> the backup function at the ISPs SQL server.
>
|||Hi John
I ran into this tool, which did the job of restoring my ISP DB as a
local DB on my server as it works both ways:
The Database Publishing Wizard enables the deployment of SQL Server
2005 databases (both schema and data) into a shared hosting environment
on either a SQL Server 2000 or 2005 server.
The tool supports two modes of deployment:
It generates a single SQL script file which can be used to recreate a
database when the only connectivity to a server is through a web-based
control panel with a script execution window.
It connects to a web service provided by your hoster and directly
creates objects on a specified hosted database
The Database Publishing Wizard provide both a graphical and a
command-line interface. In addition, it can integrate directly into
Visual Studio 2005 or Visual Web Developer 2005.
http://www.codeplex.com/sqlhost/Wiki/View.aspx?title=Database%20Publishing%20Wizard

Deployment/copy of Db from remote server

I need to copy both schema and data from a remote db server at my ISP.
I used to use a Red Gate solution but dont have access to the proggie
anymore.
I then tried to use the import/export tool for the SQL 2005 server, but
view turned into tables and primary keys autoinc were not included.
What should I have done in order to get at complete copy. I cannot use
the backup function at the ISPs SQL server.The import/export wizard in 2005 doesn't expose the SQL Server specific ("sc
ript all objects and
then transfer the data). You find this in Integration Services, though.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"hnteknik" <Henrik.F.A.Nielsen@.gmail.com> wrote in message
news:1166181741.158144.213330@.n67g2000cwd.googlegroups.com...
>I need to copy both schema and data from a remote db server at my ISP.
> I used to use a Red Gate solution but dont have access to the proggie
> anymore.
> I then tried to use the import/export tool for the SQL 2005 server, but
> view turned into tables and primary keys autoinc were not included.
> What should I have done in order to get at complete copy. I cannot use
> the backup function at the ISPs SQL server.
>|||Tibor Karaszi skrev:
> The import/export wizard in 2005 doesn't expose the SQL Server specific ("
script all objects and
> then transfer the data). You find this in Integration Services, though.
>
Thanks - I will give it a try.
Found out later that :
'The SQL Server Import and Export Wizard provides minimal
transformation capabilities. Except for setting the name, the data
type, and the data type properties of columns in new destination tables
and files, the SQL Server Import and Export Wizard supports no
column-level transformations.' :-(|||Hi
Even if you can't restore the backup, I would expect your ISP to do it for
you.
John
"hnteknik" wrote:

> I need to copy both schema and data from a remote db server at my ISP.
> I used to use a Red Gate solution but dont have access to the proggie
> anymore.
> I then tried to use the import/export tool for the SQL 2005 server, but
> view turned into tables and primary keys autoinc were not included.
> What should I have done in order to get at complete copy. I cannot use
> the backup function at the ISPs SQL server.
>|||Hi John
I ran into this tool, which did the job of restoring my ISP DB as a
local DB on my server as it works both ways:
The Database Publishing Wizard enables the deployment of SQL Server
2005 databases (both schema and data) into a shared hosting environment
on either a SQL Server 2000 or 2005 server.
The tool supports two modes of deployment:
It generates a single SQL script file which can be used to recreate a
database when the only connectivity to a server is through a web-based
control panel with a script execution window.
It connects to a web service provided by your hoster and directly
creates objects on a specified hosted database
The Database Publishing Wizard provide both a graphical and a
command-line interface. In addition, it can integrate directly into
Visual Studio 2005 or Visual Web Developer 2005.
http://www.codeplex.com/sqlhost/Wik...0Wizar
d

Deployment error

HI,

I am using .NET 2003 on my pc. I installed reporting services 2000 on my pc as well.

I have a remote computer (server) with sql 2000.

I created a report using the reporting services, and now I want to deploy it to the report server.

When I do it I get: " The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing"

I dont know how to configure reporting services, I know how to create reports, so i hope you can help me step by step.

For a strat I wish you can help me configure it to work om my pc (I installed sql 2000 on my pc as well)

Thanks,

Target Folder: ReportServer

TargetServerURL:http://127.0.0.1/ReportServer

Double check the datasource you are using. Go into the properties of the datasource, click edit, then 'Test Connection'. Probably a worth a check.

Deploying Reports To Remote Locations

Hello,
I am a new SQL Reporting Services developer, and have a couple of newbie
questions.
1) I understand that SQL Reporting Services (SRS) is free with every
licensed copy of SQL Server 2000. I downloaded what appears to be an
"evaluation" copy of SRS. How do you install / license SRS on a server that
has a licensed copy of SQL Server 2000? Is there a separate download
media/CD? How do you license / activate SRS properly?
2) I would like to develop a SRS report remotely for a customer, and then
deploy it on their intranet at their location. Basically all development is
off-site, and I will travel onsite to install the completed SRS report. They
do not have a licensed copy of Visual Studio .NET, so none of the
development/maintenance will be done on their server. When I go to install
SRS on their server, I will only install the Server components, not the
client components. With that said, how do go about getting the actual report
installed / deployed on their server? I can do it locally on my development
box using "deploy" from within VS.NET, but how do I do it "manually" on a box
without VS.NET? What report "files" do I need to copy from my machine, and
what needs to be setup in IIS?
Thanks!You can order a CD with RS (i.e. a non-evaluation version). MSDN has it as
well.
There are no activation that occurs, just install it. You do have to have
the correct version of SQL Server when installing.
To deploy without you can script the deployment. I believe an example of
this ships with RS.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Smit-Dog" <SmitDog@.discussions.microsoft.com> wrote in message
news:6160D0B2-2F39-4176-B2F1-D3D4AA24982C@.microsoft.com...
> Hello,
> I am a new SQL Reporting Services developer, and have a couple of newbie
> questions.
> 1) I understand that SQL Reporting Services (SRS) is free with every
> licensed copy of SQL Server 2000. I downloaded what appears to be an
> "evaluation" copy of SRS. How do you install / license SRS on a server
that
> has a licensed copy of SQL Server 2000? Is there a separate download
> media/CD? How do you license / activate SRS properly?
> 2) I would like to develop a SRS report remotely for a customer, and then
> deploy it on their intranet at their location. Basically all development
is
> off-site, and I will travel onsite to install the completed SRS report.
They
> do not have a licensed copy of Visual Studio .NET, so none of the
> development/maintenance will be done on their server. When I go to install
> SRS on their server, I will only install the Server components, not the
> client components. With that said, how do go about getting the actual
report
> installed / deployed on their server? I can do it locally on my
development
> box using "deploy" from within VS.NET, but how do I do it "manually" on a
box
> without VS.NET? What report "files" do I need to copy from my machine, and
> what needs to be setup in IIS?
> Thanks!|||Thanks for the quick reply Bruce!
I'll see if I can get the "offical" version via MSDN.
I'll check out the scripting example. Hope it's not too involved. I figured
that it would not be as straight forward as copying a few files.
- Bill
"Bruce L-C [MVP]" wrote:
> You can order a CD with RS (i.e. a non-evaluation version). MSDN has it as
> well.
> There are no activation that occurs, just install it. You do have to have
> the correct version of SQL Server when installing.
> To deploy without you can script the deployment. I believe an example of
> this ships with RS.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Smit-Dog" <SmitDog@.discussions.microsoft.com> wrote in message
> news:6160D0B2-2F39-4176-B2F1-D3D4AA24982C@.microsoft.com...
> > Hello,
> >
> > I am a new SQL Reporting Services developer, and have a couple of newbie
> > questions.
> >
> > 1) I understand that SQL Reporting Services (SRS) is free with every
> > licensed copy of SQL Server 2000. I downloaded what appears to be an
> > "evaluation" copy of SRS. How do you install / license SRS on a server
> that
> > has a licensed copy of SQL Server 2000? Is there a separate download
> > media/CD? How do you license / activate SRS properly?
> >
> > 2) I would like to develop a SRS report remotely for a customer, and then
> > deploy it on their intranet at their location. Basically all development
> is
> > off-site, and I will travel onsite to install the completed SRS report.
> They
> > do not have a licensed copy of Visual Studio .NET, so none of the
> > development/maintenance will be done on their server. When I go to install
> > SRS on their server, I will only install the Server components, not the
> > client components. With that said, how do go about getting the actual
> report
> > installed / deployed on their server? I can do it locally on my
> development
> > box using "deploy" from within VS.NET, but how do I do it "manually" on a
> box
> > without VS.NET? What report "files" do I need to copy from my machine, and
> > what needs to be setup in IIS?
> >
> > Thanks!
>
>|||The reason it is not just copying files is that your rdl files do not exist
on the server (search it, you won't find them). The reports are stored in
the database.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Smit-Dog" <SmitDog@.discussions.microsoft.com> wrote in message
news:2E52E77E-7D1E-4490-8820-B480DD3250C4@.microsoft.com...
> Thanks for the quick reply Bruce!
> I'll see if I can get the "offical" version via MSDN.
> I'll check out the scripting example. Hope it's not too involved. I
figured
> that it would not be as straight forward as copying a few files.
> - Bill
> "Bruce L-C [MVP]" wrote:
> > You can order a CD with RS (i.e. a non-evaluation version). MSDN has it
as
> > well.
> >
> > There are no activation that occurs, just install it. You do have to
have
> > the correct version of SQL Server when installing.
> >
> > To deploy without you can script the deployment. I believe an example of
> > this ships with RS.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> > "Smit-Dog" <SmitDog@.discussions.microsoft.com> wrote in message
> > news:6160D0B2-2F39-4176-B2F1-D3D4AA24982C@.microsoft.com...
> > > Hello,
> > >
> > > I am a new SQL Reporting Services developer, and have a couple of
newbie
> > > questions.
> > >
> > > 1) I understand that SQL Reporting Services (SRS) is free with every
> > > licensed copy of SQL Server 2000. I downloaded what appears to be an
> > > "evaluation" copy of SRS. How do you install / license SRS on a server
> > that
> > > has a licensed copy of SQL Server 2000? Is there a separate download
> > > media/CD? How do you license / activate SRS properly?
> > >
> > > 2) I would like to develop a SRS report remotely for a customer, and
then
> > > deploy it on their intranet at their location. Basically all
development
> > is
> > > off-site, and I will travel onsite to install the completed SRS
report.
> > They
> > > do not have a licensed copy of Visual Studio .NET, so none of the
> > > development/maintenance will be done on their server. When I go to
install
> > > SRS on their server, I will only install the Server components, not
the
> > > client components. With that said, how do go about getting the actual
> > report
> > > installed / deployed on their server? I can do it locally on my
> > development
> > > box using "deploy" from within VS.NET, but how do I do it "manually"
on a
> > box
> > > without VS.NET? What report "files" do I need to copy from my machine,
and
> > > what needs to be setup in IIS?
> > >
> > > Thanks!
> >
> >
> >|||It appears that the Report Manager browser interface allows you to upload an
RDL file from a file system directly into the Report Server database. Very
cool!
But... I imagine that since the data source info is different between the
two environments (production server versus development laptop) and since the
RDL contains the data source definition, this might not work 100%. Still need
to do some more digging. Perhaps you can change the data source for a report
once it's been uploaded into the production server.
"Bruce L-C [MVP]" wrote:
> The reason it is not just copying files is that your rdl files do not exist
> on the server (search it, you won't find them). The reports are stored in
> the database.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Smit-Dog" <SmitDog@.discussions.microsoft.com> wrote in message
> news:2E52E77E-7D1E-4490-8820-B480DD3250C4@.microsoft.com...
> > Thanks for the quick reply Bruce!
> >
> > I'll see if I can get the "offical" version via MSDN.
> >
> > I'll check out the scripting example. Hope it's not too involved. I
> figured
> > that it would not be as straight forward as copying a few files.
> >
> > - Bill
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > You can order a CD with RS (i.e. a non-evaluation version). MSDN has it
> as
> > > well.
> > >
> > > There are no activation that occurs, just install it. You do have to
> have
> > > the correct version of SQL Server when installing.
> > >
> > > To deploy without you can script the deployment. I believe an example of
> > > this ships with RS.
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > >
> > > "Smit-Dog" <SmitDog@.discussions.microsoft.com> wrote in message
> > > news:6160D0B2-2F39-4176-B2F1-D3D4AA24982C@.microsoft.com...
> > > > Hello,
> > > >
> > > > I am a new SQL Reporting Services developer, and have a couple of
> newbie
> > > > questions.
> > > >
> > > > 1) I understand that SQL Reporting Services (SRS) is free with every
> > > > licensed copy of SQL Server 2000. I downloaded what appears to be an
> > > > "evaluation" copy of SRS. How do you install / license SRS on a server
> > > that
> > > > has a licensed copy of SQL Server 2000? Is there a separate download
> > > > media/CD? How do you license / activate SRS properly?
> > > >
> > > > 2) I would like to develop a SRS report remotely for a customer, and
> then
> > > > deploy it on their intranet at their location. Basically all
> development
> > > is
> > > > off-site, and I will travel onsite to install the completed SRS
> report.
> > > They
> > > > do not have a licensed copy of Visual Studio .NET, so none of the
> > > > development/maintenance will be done on their server. When I go to
> install
> > > > SRS on their server, I will only install the Server components, not
> the
> > > > client components. With that said, how do go about getting the actual
> > > report
> > > > installed / deployed on their server? I can do it locally on my
> > > development
> > > > box using "deploy" from within VS.NET, but how do I do it "manually"
> on a
> > > box
> > > > without VS.NET? What report "files" do I need to copy from my machine,
> and
> > > > what needs to be setup in IIS?
> > > >
> > > > Thanks!
> > >
> > >
> > >
>
>|||The best way to do this is to used shared datasource. I never define a
datasource for a particular report. I might have two shared datasources in a
project though. Then you have your shared datasource be defined differently
on your development machine than it is in production. Only the name of the
shared datasource needs to stay the same.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Smit-Dog" <SmitDog@.discussions.microsoft.com> wrote in message
news:0A2723EB-5411-44CE-843C-0EEDDFDD75BF@.microsoft.com...
> It appears that the Report Manager browser interface allows you to upload
an
> RDL file from a file system directly into the Report Server database. Very
> cool!
> But... I imagine that since the data source info is different between the
> two environments (production server versus development laptop) and since
the
> RDL contains the data source definition, this might not work 100%. Still
need
> to do some more digging. Perhaps you can change the data source for a
report
> once it's been uploaded into the production server.
> "Bruce L-C [MVP]" wrote:
> > The reason it is not just copying files is that your rdl files do not
exist
> > on the server (search it, you won't find them). The reports are stored
in
> > the database.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> > "Smit-Dog" <SmitDog@.discussions.microsoft.com> wrote in message
> > news:2E52E77E-7D1E-4490-8820-B480DD3250C4@.microsoft.com...
> > > Thanks for the quick reply Bruce!
> > >
> > > I'll see if I can get the "offical" version via MSDN.
> > >
> > > I'll check out the scripting example. Hope it's not too involved. I
> > figured
> > > that it would not be as straight forward as copying a few files.
> > >
> > > - Bill
> > >
> > > "Bruce L-C [MVP]" wrote:
> > >
> > > > You can order a CD with RS (i.e. a non-evaluation version). MSDN has
it
> > as
> > > > well.
> > > >
> > > > There are no activation that occurs, just install it. You do have to
> > have
> > > > the correct version of SQL Server when installing.
> > > >
> > > > To deploy without you can script the deployment. I believe an
example of
> > > > this ships with RS.
> > > >
> > > > --
> > > > Bruce Loehle-Conger
> > > > MVP SQL Server Reporting Services
> > > >
> > > >
> > > > "Smit-Dog" <SmitDog@.discussions.microsoft.com> wrote in message
> > > > news:6160D0B2-2F39-4176-B2F1-D3D4AA24982C@.microsoft.com...
> > > > > Hello,
> > > > >
> > > > > I am a new SQL Reporting Services developer, and have a couple of
> > newbie
> > > > > questions.
> > > > >
> > > > > 1) I understand that SQL Reporting Services (SRS) is free with
every
> > > > > licensed copy of SQL Server 2000. I downloaded what appears to be
an
> > > > > "evaluation" copy of SRS. How do you install / license SRS on a
server
> > > > that
> > > > > has a licensed copy of SQL Server 2000? Is there a separate
download
> > > > > media/CD? How do you license / activate SRS properly?
> > > > >
> > > > > 2) I would like to develop a SRS report remotely for a customer,
and
> > then
> > > > > deploy it on their intranet at their location. Basically all
> > development
> > > > is
> > > > > off-site, and I will travel onsite to install the completed SRS
> > report.
> > > > They
> > > > > do not have a licensed copy of Visual Studio .NET, so none of the
> > > > > development/maintenance will be done on their server. When I go to
> > install
> > > > > SRS on their server, I will only install the Server components,
not
> > the
> > > > > client components. With that said, how do go about getting the
actual
> > > > report
> > > > > installed / deployed on their server? I can do it locally on my
> > > > development
> > > > > box using "deploy" from within VS.NET, but how do I do it
"manually"
> > on a
> > > > box
> > > > > without VS.NET? What report "files" do I need to copy from my
machine,
> > and
> > > > > what needs to be setup in IIS?
> > > > >
> > > > > Thanks!
> > > >
> > > >
> > > >
> >
> >
> >

Deploying reports to remote location

i am new in report service development.
currently I deployed reports on development server by vs.net.
I also aware about how to use report manager to deploy reports on server.
but both approaches need access to report server.
But now i have to deploy them on production server where i am not having
access.
Client ask us for some sort of setup program so that they can deploy them.
How can i do this.These is reporting webservice available at
http://<machine_name>/reportserver/reportservice.asmx
There are some functions provided by this webservice like CreateReport(),
which can be used for publishing reports. You will be required to write a
custom DLL to accomplish this and call the DLL from a setup program
Let me know if you have further queries
Bye
Sumit Pilankar
"vibha" <vibha@.discussions.microsoft.com> wrote in message
news:BD205062-FD5E-4C71-AAD4-D966428D668A@.microsoft.com...
>i am new in report service development.
> currently I deployed reports on development server by vs.net.
> I also aware about how to use report manager to deploy reports on server.
> but both approaches need access to report server.
> But now i have to deploy them on production server where i am not having
> access.
> Client ask us for some sort of setup program so that they can deploy them.
> How can i do this.

Deploying reports on remote report server

Hello all,

I am trying to deploy my rdl's to a remote report server. I have given a valid path in the properties window before deploying...https://RemoteServerName/ReportServer. Now I get the error :

Error 1 The permissions granted to user 'domain\user' are insufficient for performing this operation.

what permission do I need on the remote server for deployment?

Thanks.....

You need rights to execute the Manage Reports, Manage Data Sources, and Manage Resources tasks. The pre-defined Content Manager role will give you these rights.|||

Hello Teo,

thanks for responding. where do I set the content manager role? Could you please tell me the steps involved?

Thanks...

|||

1. Open up the Report Manager (or use SQL Server Management Studio).

2. Navigate to the folder where your reports are and go to the folder properties and then Security tab.

3. Click Edit Item Security and click OK on the dialog that follows.

4. Click New Role Assignment.

5. Type in the Windows account (domain\user) or group that you want grant permissions to and select the Content Manager checkbox. Hit OK.

|||Hi I got the same issue. I tried to follow the steps given above. This is the first time I am deploying a report. There are no prior reports. I don't know what folder I need to navigate. Do I need to create a folder in Report Manager? I tried creating a folder and go to the security tab but I didn't see any Edit Item Security...Can you please explain? Thanks...|||You specify the deployment folder on the Report Server project properties (TargetReportFolder property). If you want to have access to all folders, grant your account Content Manager rights on the root Home folder in the Report Manager.

Deploying reports on remote report server

Hello all,

I am trying to deploy my rdl's to a remote report server. I have given a valid path in the properties window before deploying...https://RemoteServerName/ReportServer. Now I get the error :

Error 1 The permissions granted to user 'domain\user' are insufficient for performing this operation.

what permission do I need on the remote server for deployment?

Thanks.....

You need rights to execute the Manage Reports, Manage Data Sources, and Manage Resources tasks. The pre-defined Content Manager role will give you these rights.|||

Hello Teo,

thanks for responding. where do I set the content manager role? Could you please tell me the steps involved?

Thanks...

|||

1. Open up the Report Manager (or use SQL Server Management Studio).

2. Navigate to the folder where your reports are and go to the folder properties and then Security tab.

3. Click Edit Item Security and click OK on the dialog that follows.

4. Click New Role Assignment.

5. Type in the Windows account (domain\user) or group that you want grant permissions to and select the Content Manager checkbox. Hit OK.

|||Hi I got the same issue. I tried to follow the steps given above. This is the first time I am deploying a report. There are no prior reports. I don't know what folder I need to navigate. Do I need to create a folder in Report Manager? I tried creating a folder and go to the security tab but I didn't see any Edit Item Security...Can you please explain? Thanks...|||You specify the deployment folder on the Report Server project properties (TargetReportFolder property). If you want to have access to all folders, grant your account Content Manager rights on the root Home folder in the Report Manager.

Deploying Reports from Development to (Remote) Production Machines

After intial development of some reports on my notebook I will need to deploy them to a production machine remote from my office. In other words I will will not be able to directly from the BI (aka VS) Studio on my notebook.

I had thought that I might be able to simply send the RDL files to the remote site and instruct them to create data sources with the same name (and in the same folders) on the local ReportServer (not the BI Studio) then use the "Upload File" option to upload the RDL files. I have tried this once so far, without success.

The next alternative that I can think of to copy the entire set BI Studio project files to the production server (which should have the BI Studio installed) and deploy normally from there, after changing the TargetServerURL naturally.

Can any one suggest any options?

Dick Campbell

I normally utilise option 2

I create several configurations (1 per environment) then when I need to, just change the configuration from the toolbar dropdown and deploy. No need to manually change the target server every time.

|||

Hi,

is the Webservice not accessible from your notebook ? If yes, you could deploy the reports with the right click on project -option Deploy, sending the RDL files via WebServervices to the Report Server. If this is not an option for you, I would suggest taking the RDL files and send them over to the guys who can install them by loading them up via the web console.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Thanks Jens,

The second option sounds like the one I am looking for. Can you describe what you mean by "loading up via the web console".

I have tried using "Upload File" from the ReportServer web page but the report would not run even after i checked that tjhere was a working Data Source with the same name on the remote computer. Pehaps i just did something wrong.

Thanks for your reply.

Dick Campbell

|||You will have to reset the datasource to the actual data source in your report server. As the data source gets a GUID during the creation, the Guid of the report datasource and the actual existing might differ.

HTH, Jens K. Suessmeyer.

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

I have set up the data source with the same name and in the same folder (with localhost and the same databasename) but I didn't realise that it was identified by a GUID so I suspect that this is where the problem lies.

Thanks again for the help.

Best regards,

Dick Campbell

|||

With regard to the data source GUID, if you are refering to the GUID in the RDL file, my mistake may have been to create the data source on the production machine (thus generating a new GUID).

Perhaps I should also upload the data source file (I can't remember what the extension for that is) thereby keeping the same GUID.

So I am thinking that the steps could be:-

1. Create the same folder structure (the first time round) on the production machine using the ReportServer UI.

2. Copy the RDL and data source files onto the machine.

3. Upload each file into the appropriate folders, inlcuding the data source (XML) files, again using the Report Server UI.

4 Change data souces to the new environment if necessary. It they are ".\DatabaseName" this may not be necessary.

Any future upgrades can then just be a matter of sending the changed RDL file and uploading over the existing one. Actyally I suppose that they would just have to be copied over the original.

Why not just copy the entire BI Studio project onto the production machine and deploy it locally? I think that this exposes some customers to the BI Studio when they don't really want to know about it and also leads to the possibility of reports being modified in more than one place.

Deploying Analysis Server Project to another domain

I am looking for a way to deploy an Analysis Server 2005 project to a remote location. I can generate and XMLA create script, FTP the script to the remote location, and execute it to create the cube database on the other server.

However, the security roles inthe XMLA file contains SIDs instead of Active Directory Security group names. The server I am moving this database to is in another Domain and so the SIDs don't correspond to the same users. However, the Active Directory group names on the remote server are exactly the same as the Active Directory group names in my local domain. (The group names are the names of companies).

I am looking for a way to deploy this project to my remote server with the SIDs converted to the Active Directory group names.

Does anyone have any ideas? This type of deployment scenario will be quite common in my development environment.

I am using SQL2005 SP2, along with Visual Studio 2005.

Have a look at the Analysis Services Deployment Wizard, it has options for either

deploying the roles in full|||

I'll throw in my two cents. If the XMLA for your role contains:

<Members>

<Member>

<Name>YOURDOMAIN\yourusername</Name>

<Sid>S-1-5-21-4211028405-896031999-4015973603-1183</Sid>

</Member>

</Members>

I believe that you can cut out the Sid entirely. The following XMLA works fine for me:

<Members>

<Member>

<Name>YOURDOMAIN\yourusername</Name>

</Member>

</Members>

As for whether you can do without YOURDOMAIN\ in the above, I'm not sure. I know that if the group is local to the computer you're, then leaving off the domain works. But if it's a domain group, I'm guessing you've got to specify the domain. Worth testing, though.

Deploying Analysis Server Project to another domain

I am looking for a way to deploy an Analysis Server 2005 project to a remote location. I can generate and XMLA create script, FTP the script to the remote location, and execute it to create the cube database on the other server.

However, the security roles inthe XMLA file contains SIDs instead of Active Directory Security group names. The server I am moving this database to is in another Domain and so the SIDs don't correspond to the same users. However, the Active Directory group names on the remote server are exactly the same as the Active Directory group names in my local domain. (The group names are the names of companies).

I am looking for a way to deploy this project to my remote server with the SIDs converted to the Active Directory group names.

Does anyone have any ideas? This type of deployment scenario will be quite common in my development environment.

I am using SQL2005 SP2, along with Visual Studio 2005.

Have a look at the Analysis Services Deployment Wizard, it has options for either

deploying the roles in full|||

I'll throw in my two cents. If the XMLA for your role contains:

<Members>

<Member>

<Name>YOURDOMAIN\yourusername</Name>

<Sid>S-1-5-21-4211028405-896031999-4015973603-1183</Sid>

</Member>

</Members>

I believe that you can cut out the Sid entirely. The following XMLA works fine for me:

<Members>

<Member>

<Name>YOURDOMAIN\yourusername</Name>

</Member>

</Members>

As for whether you can do without YOURDOMAIN\ in the above, I'm not sure. I know that if the group is local to the computer you're, then leaving off the domain works. But if it's a domain group, I'm guessing you've got to specify the domain. Worth testing, though.

Deploying a report to remote server

I would like to develop a report remotely for a customer, and then
deploy it on their intranet at their location. Basically all
development is
off-site, and I will travel onsite to install the completed SRS report.
They
do not have a licensed copy of Visual Studio .NET, so none of the
development/maintenance will be done on their server. When I go to
install
SRS on their server, I will only install the Server components, not the
client components. With that said, how do go about getting the actual
report
installed / deployed on their server? I can do it locally on my
development
box using "deploy" from within VS.NET, but how do I do it "manually" on
a box
without VS.NET? What report "files" do I need to copy from my machine,
and
what needs to be setup in IIS?
Thanks
VikramYou can use report manager to deploy a rdl file (if you don't have a lot
this would be the easiest to do.
Or you can script the deploy. You don't have to have a 3rd party tool for
this but here is a free one from Jasper Smith a SQL Server MVP.
Reporting Services Scripter
http://www.sqldbatips.com/showarticle.asp?ID=62
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<vikram.sattenapalli@.gmail.com> wrote in message
news:1140556432.452749.103260@.o13g2000cwo.googlegroups.com...
> I would like to develop a report remotely for a customer, and then
> deploy it on their intranet at their location. Basically all
> development is
> off-site, and I will travel onsite to install the completed SRS report.
> They
> do not have a licensed copy of Visual Studio .NET, so none of the
> development/maintenance will be done on their server. When I go to
> install
> SRS on their server, I will only install the Server components, not the
> client components. With that said, how do go about getting the actual
> report
> installed / deployed on their server? I can do it locally on my
> development
> box using "deploy" from within VS.NET, but how do I do it "manually" on
> a box
> without VS.NET? What report "files" do I need to copy from my machine,
> and
> what needs to be setup in IIS?
> Thanks
> Vikram
>|||Thanks a lot for the quick response. I will try using the third party
tool and see if i can actually generate the script :)
Vikram

Deploying a report to a remote server

How do I deploy are report that is not on my network?
I need to deploy my report to the production server. I have FTP access, and
I usually Remote Desktop to the machine, but its not on my network.
When I try to deploy to the remote server, I get an error saying that that
server can't be accessed.
What is the solution? How can I deploy my reports?
Thank you!!I believe all you need to do is copy the RDL to a folder accessible from the
production server, then Add the report on the production server. There's a
button to Browse that lets you pick the RDL file from a folder on the
production server.
At my company (www.icco.com) we have built a tool to deploy batches of
reports at a time. If you are interested contact me by email or phone (954)
5471293.
"Julie" wrote:
> How do I deploy are report that is not on my network?
> I need to deploy my report to the production server. I have FTP access, and
> I usually Remote Desktop to the machine, but its not on my network.
> When I try to deploy to the remote server, I get an error saying that that
> server can't be accessed.
> What is the solution? How can I deploy my reports?
> Thank you!!

Deny remote network access to MSDE

HI!
I'd like turn off remote network access for a user group in the user
manager.
Are users of this group still capable of accessing the MSDE while
working on the local machine?
What does local access mean?
Can they access the MSDE via TCP to 127.0.0.1?
Or must they access the MSDE through a named pipe?
Ciao, Michael.
If I'm not mistaken, MSDE 2000 SP3a already disables remote access by
default.
joe.
"Michael Strder" <michael@.stroeder.com> wrote in message
news:sauhi2-5k4.ln1@.nb2.stroeder.com...
> HI!
> I'd like turn off remote network access for a user group in the user
> manager.
> Are users of this group still capable of accessing the MSDE while
> working on the local machine?
> What does local access mean?
> Can they access the MSDE via TCP to 127.0.0.1?
> Or must they access the MSDE through a named pipe?
> Ciao, Michael.

Deny remote access to MSDE for some users

HI!
I'm a complete MSDE newbie but I have to clarify an open question about
access control with MSDE 2000 running on WinNT 4.0:
Is it possible to grant some admin users remote access to the MSDE but
restrict other local users to local access?
Ciao, Michael.
hi Michael,
Michael Strder wrote:
> HI!
> I'm a complete MSDE newbie but I have to clarify an open question
> about access control with MSDE 2000 running on WinNT 4.0:
> Is it possible to grant some admin users remote access to the MSDE but
> restrict other local users to local access?
yes, of course..
you have to grant the remote logins access to the MSDE instance via the
sp_grantlogin system stored procedure
(http://msdn.microsoft.com/library/de...-us/tsqlref/ts
_sp_ga-gz_8dri.asp), while you have to deny local logins via sp_denylogin...
please have a look at
http://support.microsoft.com/default...;EN-US;q325003 for futher
info about how to perform these tasks via oSql.exe, the command line tool
provided with MSDE
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Andrea,
first many thanks for the pointers.
Andrea Montanari wrote:
> hi Michael,
> Michael Strder wrote:
> you have to grant the remote logins access to the MSDE instance via the
> sp_grantlogin system stored procedure
> (http://msdn.microsoft.com/library/de...-us/tsqlref/ts
> _sp_ga-gz_8dri.asp), while you have to deny local logins via sp_denylogin...
Let's assume I use Windows authentication for MSDE. Is the whole access
control also done via Windows rights based on groups? How to disallow a
remote login for local users then?
Ciao, Michael.
|||ciao Michael,
> ..
> Let's assume I use Windows authentication for MSDE. Is the whole
> access control also done via Windows rights based on groups? How to
> disallow a remote login for local users then?
let's say you have YourDomain\theUser member of TheGroup\
you want TheGroup\ to be able to connect to MSDE, so you grant
(sp_grantlogin) it connection...
but you want YourDomain\theUser not to be able to connect to MSDE .. you
deny YourDomain\theUser connection to MSDE via sp_denylogin...
this way you have YourDomain\TheGroup able to connect and YourDomain\theUser
unable...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply