How to Deploy Report on Remote Server..

Hi,

I m getting following error while deploying report on remote server...

Error 3 The permissions granted to user 'ZENITH\BalwantPatel' are insufficient for performing this operation. 0 0

The following setting i have on my remote server.

Configure Report Server:

Report Server Virtual Directory: Default

Report Manager Virtual Directory: Default

Windows Service Identity:
Service Name: Report Server
Service Account: Domain\Administrator

Windows Account: Domain\Administrator.

Web Service Identity : ASP.NET Service Account: ServerName\ASPNET

I m creating Report on my local machine as Domain\Balwant Patel. and Trying to deploy on other server on the same domain....

I dont know What settings do need to change on webserver or on my local machine.

Thank you,

Ballu.

hello,

I see u have not configured ur report server. Go to "start" -- "sql server 2005" -- "configuration tools" -- "reporting services configuration". Go thru it step by step and configure it. Once you have done it, you should have "content manager" permission to deploy on the remote server. Needlesss to say, I am assuming you have given the correct target URL for deploment. For "content manager" persmission settings, read http://msdn2.microsoft.com/en-us/library/aa337491.aspx.

I hope it helps...

Regards..

|||

Hi AsianIndian,

Thank you very much for your response....The Link That u give me is very useful...Now I get The Idea How to setup permission on SQL Server Reporting Service...I configured Report Server fine...but I don't know how to setup permission through SQL Server Management Studio...I have one problem when I m trying to connection to my Report Server Through SQL Server Management Studio... Initially when i m trying to connection Report Server on my local machine...i m getting the error that there is not enough permission on C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files this folder to machine\ASP.NET...So I give full permission to ASP.NET user....so I thought the same problem may occure on my deplyoment server...but I get different error...the error was internal server and the error and even the error was not shown correctly...but I found somewhere on the forums that I have to remove <configuration xmlns> attribute from the configuration node from Drive:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config.

Regards,

Balwant Patel.

How to deploy msde database in web matrix

Dear Sir,
How do I deploy database to remote server in web matrix. It does not have enterprise manager.
I have to use osql.exe command line that runs msde statements that are exuceted against database. Can you
please let me know how to use osql.exe.
Regards,
Farhan

Web Matrix is free so is MSDE so you can buy the Developer edition for $37 to manage MSDE or test drive SQL Server 2005 from the first link below. I would do the former. Hope this helps.
http://www.microsoft.com/sql/downloads/trial-software.mspx

http://www.provantage.com/buy-22053391-microsoft-backoffice-sql-server-2000-developer-edition-shopping.htm

How to deploy assembly from remote system, without using VS.NET

Hi

I'm developing a tool to deploy the CLR objects from any where to the server

But I'm unable to deploy from remote system to the server.

I'm getting the error like

CREATE ASSEMBLY failed because it could not open the physical file 'D:\Working\DBS2005V2\GL\GLREPORTS\DBS.GL.RM.SQL\bin\Debug\sample.dll': 3(The system cannot find the path specified.).

when I try to deploy using

EXEC dbo.sp_executesql @.statement = N' CREATE ASSEMBLY [DBS.GL.RM.SQL]

FROM ''D:\Working\DBS2005V2\GL\GLREPORTS\DBS.GL.RM.SQL\bin\Debug\sample.dll''

WITH PERMISSION_SET = SAFE'

can anybody tell how to generate assembly_bits for assembly

the VS.NEt is generating assembly bits instead of physical path to deploy the assembly on the remote server.

as

CREATE ASSEMBLY [sample]

AUTHORIZATION [dbo]

FROM 0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD215 ..

WITH PERMISSION_SET = SAFE

But nothing is provided reg this in MSDN.

will u help me in handle this please

Thank u

See http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=288119&SiteID=1 for code that will allow you to generate the assembly bits string.

HOW TO DEPLOY A PROJECT TO REMOTE SERVER(starve for)

hi ,i want to deploy an project(BI) which is been deployed successful on my computer to remote server,the server name is boco-ace.i do not kown how to do?could you give me an solution?if you give an example,i cannot bear to appreciate.

Several ways:

First.
Right click on your project name in the BI Dev Studio select "Properties". Click on "Deployment" node on the left and you will see the name of the server you deploying to. By default it is "localhost" , change it to boco-ace

Second.
Open SQL Management Studio. Right Click on your database name->Script database to->Create ...
Send resulting script to your new server. Make sure you process your database after creating it.

Third.
Run MigrationWizard application and point it to the project files. At some point it will ask you which server you'd like to deploy it to.

I am sure I can come up with some more.. Like Sync , Backup/Restore, ...

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||the first way i did ,but it dap an error "systerm error:no mapping is completed between account and security id",why?|||

i think maybe because i built roles,so i delete the role.but it daps another error"login failed for user"NT AUTHORITY\ANONYMOUS LOGON"",i do not know how to correct it?

thanks.

database's login mode is SQL's security

|||

You should use windows integrated security when connecting to Analysis Server.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

HOW TO DEPLOY A PROJECT TO REMOTE SERVER

hi ,i want to deploy an project(BI) which is been deployed successful on my computer to remote server,the server name is boco-ace.i do not kown how to do?could you give me an solution?if you give an example,i cannot bear to appreciate.

Several ways:

First.
Right click on your project name in the BI Dev Studio select "Properties". Click on "Deployment" node on the left and you will see the name of the server you deploying to. By default it is "localhost" , change it to boco-ace

Second.
Open SQL Management Studio. Right Click on your database name->Script database to->Create ...
Send resulting script to your new server. Make sure you process your database after creating it.

Third.
Run MigrationWizard application and point it to the project files. At some point it will ask you which server you'd like to deploy it to.

I am sure I can come up with some more.. Like Sync , Backup/Restore, ...

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||the first way i did ,but it dap an error "systerm error:no mapping is completed between account and security id",why?|||

i think maybe because i built roles,so i delete the role.but it daps another error"login failed for user"NT AUTHORITY\ANONYMOUS LOGON"",i do not know how to correct it?

thanks.

database's login mode is SQL's security

|||

You should use windows integrated security when connecting to Analysis Server.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.