Hi All,
While deploying reports on the reports server, it is asking to supply user name and password. When I entered the same, it didn't accept them. What do I need to do? Is there any specific setting which I need to configure?
An immediate reply will be highly appreciated.
Thanks
Sekhar
I am creating a new application and just created a new database
Application: VB.net 2005/ ASP.net
Database: Sql Server 2005 with four tables
I need to set the userid and password on the database. How do I do that?
I want to be able to create a SQL connection object in my code and I have something like the following:
<CODE>
Dim objcon As New SqlConnection("server=serverName;uid=;pwd=;database=SomeDatabase")
</CODE>
but the "uid" and the "pwd" are not set on my database. what is an easy way to do this? thanks
I use DTSRun /Uuserid /Ppassword /Sservername .... in a batch process.
I always get the error message to run with a trusted connection. I can run the same batch process from a command line under my own domain id and it runs as if it had a trusted connection.
Will DTSRun run only with a trusted connection? Do I need to set something in the package to get SQL Server to run with a userid and password? Why does it always default to using a trusted connection. I need to know what I have to set to tell it that I am using a userid and password. I have included an example of how it's coded in the BAT file.
Example:
DTSRun /S"myserver" /Umyuser /Pmypass /N"Load_Data" /L "c:mylogsLoad_Data.log" /W"0"
When I tried to browse the reportserver url. The IE 7.0 asks me for Username and password. I feel, its some settings related to security. But other sites created are working fine. The virtual directories created using Repoting services configuration manager only ask me username and password.
Any suggestions.
Murali.
Hi,
I am using the sql server for creating the database. I want to create the database which is having userid and password. This I require since I wanted to restrict acces to database and also only authorise user to database can use the userid and password created at time of creation of database.
So how can I create the database which is having userid and password?
Hi,
I have started using SQL Server 2005 Reporting Services. I am using SQl Server authentication where user has to supply username and password .I want to know can I Pass the SQL authentication username and password in the URL as a parameter to report.
Nikhil Jahagirdar
I want to set userID and Password for perticular database without affecting sql server userid and password in sql server 2000 :)
View 3 Replies View RelatedMy PC is Window XP Pro and I'm using Microsoft SQL Server 2005 Express and Microsoft SQL Server Management Studio Express.
My question is how to create a login userid and password under "SQL Server Authentication"? (as shown in http://www.findingsteve.net/print_screen.jpg)
Any tutorial about this I can read?
Hello,
I have some reports running CRM data. It's basically a sales dashboard that shows each user their pipeline values. Since each user has rights to see more than just the opportunities they own, I had a filter on the report in the SQL WHERE clause. It said
WHERE
@UserID = systemuser.DomainName.
The @UserID parameter's value was
=User!UserID, which brought back the logged-in user's domain name, which matched the field in my WHERE clause.
Now, in CRM 4.0, to eliminate the need for a VPN to access reports, everyone who accesses a report is logged in as NT Authority Network Service. Does anyone know if there's still a way to access the person's domain identity?
Thanks,
Andy
Just wondering what people do when they deploy sub reports and what is the 'best practise' for this. I'm just deploying them to the same folder as the main report and hiding them.
This is, to say the least, messy. As a user has to click 'Show Details' and they can see the sub report.
Is there a better way?
Thanks
I have created a report, and want to now deploy it to the Report Server. Each time I try to do that, I get a Reporting Services Log In screen. I have no idea what to input, having tried my windows authentication and sa account without sucess. Is there something else that I need to set up so I can deploy my reports? Thanks in advance!
View 1 Replies View RelatedHi All,
I want to programatically deploy the report in VS2005 environment,ie.from an asp.net page if i click deploy report Button ,the report should be deployed into the report server automatically.So that i can view the report in report server.
the input to the asp page would be the.rdl file...
If anyone could help then it would be good.
thankyou.
I have installed SSRS on my local machine with all default settings. Report manager and report server and reportserver data base and reportservertempDB all are in my local machine. Now I have already created few reports. but now the company wants to deploy them to the main server. Now can I do this? Do I have to chage the report configuration settings. Does it effect to my current reports?
If this is possible, can anyone tell me how to do this please?
Thanks
Hi,
I have two aquestions.
1. How do I select data ovewrite option in SSRS? When I deploy a report i got a following error message.
Warning : Cannot deploy data source mydatasource to the server because it already exists and OverwriteDataSources is not specified.
2. When I try to snapshot a report on report manager, I get a error message.
"Credentials used to run this report are not stored
Then I went to Management Studio and selected the data source and open the report data source property box. I gave a login name and a password under credential stored securely on the server. Can this login name and password be random ones or do they come from smwhere else? Even After I did this still i get the error.
Thanks
I have a standard package of reports that need to be deployed by an installer (InstallShield) to an SSRS Server for use with our custom application. We are not in control of the environments where these reports will be deployed as this is a "commerical" application that gets deployed directly to customer sites. The installer may or may not be run on a machine that has SSRS installed on it therefore there is no guarantee that the deployment tools are available. What is the reccomended approach for deploying a "Standard Reports" package using an installer like InstallShield? I can't seem to find anything out there that deals with this kind of situation. Is anyone doing this?
View 2 Replies View RelatedHi all,
I am trying create the script which is from net but now able to deploy reports using that script.
I am,using following script:
rs -i c:PublishReports.rss -s http://servername/Reportserver -v filePath="filePath" -v sqlServerName="SQLServerTest" -v parentFolder="target Folder"
I am getting following error:
C:e9usc6ik.1.vb(38) : error B
C30035: Syntax error.
/*PublishReport("Report1")
~
C:\e9usc6ik.1.vb(43) : error B
C30035: Syntax error.
*/
~
The specified script failed to compile with the following errors:
C:\Temp
mmy_1lg.1.vb(38) : error B
C30035: Syntax error.
/*PublishReport("Report1")
~
C:\Temp
mmy_1lg.1.vb(43) : error B
C30035: Syntax error.
*/
~
thanks
for the help!!!
Hi ,
I am trying to deploy reports through visual studio. In the Target server URL, specified the url of the report server as http://<localhost>:<portnumber>/reportserver/Shared Documents/. But
When i deploy it asks for username and password. when i provide them, again login screen appears. Finally deployment fails when i press cancel.
Did anybody face this kind of problem ?
Thanks & Regards,
Kiran Kumar
I have found many references to this issue on the forum, but no solution that works in my case. I believe that I am lacking a fundamental understanding of a security issue so I will attempt to provide as much up front information as possible. I can publish SSRS reports from BIDS to my local computer but when I try and publish the same reports to a production server, I get a login dialog (which I cannot get passed). Here are the particulars. My environment is a home office. I have my computer (which works with the localhost designation) running on a workgroup network (not domain based). My server is another machine on the network (named €œserverone€?). Both machines are running Windows XP Professional. The BIDS project €œDebug€? property page has the TargetServerURL set to http://localhost/ReportServer. The €œProduction€? property page has the TargetServerURL set to http://serverone/ReportServer. I am logged on as an administrator but I cannot publish to the remote server (serverone) from my machine (localhost). I have also tried using the actual TCIP address of the server in place of the serverone name to no avail. I believe that my problem is related to authentication between the two SQL Server 2005 instances running on separate machines on a workgroup based network rather than a domain based network but I cannot find any information that might be useful under these circumstances. Now, here is my workaround (but this seems very wrong). From the logon dialog generated in BIDS, the user ID name was blank. When I attempted to remotely access the Report Manager on the server from my machine, IE tried to logon using the €œserverone/guest€? account. I added an administrator role to the guest account on the server and everything works as expected. As I mentioned before, this seems very wrong. Currently, both machines were set to use the €œlocal system€? account during setup, but I am not even sure what that means. I tried setting the server to use the €œNetwork Service€? account as suggested in one of the forum threads but that did not work. Any help here would be greatly appreciated as I am sure that allowing the €œGuest€? account to have €œAdministrator€? privileges is a bad idea.
View 1 Replies View Related
I have created some reports in BIDS and saved them to a folder in my m/c (without deploying them) . i want to deploy that to the report server through C# code.
i can deploy that onto any Report Server. For that I will have to change the datasource connection string.
Is there a way to achieve this. Please let me know if it is there.
Regards...
Girija Shankar
hello experts,
i need help with deployment of reports (SSRS 2005). we need to deploy many reports (more then 100) on the production everytime we make changes in them.
"the problem is we cannot install visual studio on the server to open the project and use the deploy option from it" i tried using the script - PublishSampleReports.rss
but everytime i run i need to go and manully configure the report to map the shared datasource to it. any way to pass the information in the script itself, or is there any smart way to deploy on production.
/chandresh soni
I have seem many messages about this, mostly over a year old, with no satisfying answer.
I have a set or reports that jump between each other, passing parameters, that work fine in VS 2005. (They are mostly based on sql server 2005 stored procedures).
When the reports are deployed, the one that jumps without a parameter works. The ones that pass parameters do not even 'activate'- that is, the text box to be clicked does not allow the user to click.
If I go to the report directly through the browser, it lists the missing parameters and the report does not render.
I am using IE7. All SP on IE and SQL are current.
Microsoft- will you be making this feature work anytime soon?
Thanks
Hello,
I wonder if anyone can help me save the few remaining hairs on my head? I am trying to deploy reports created in SQL Server Business Intelligence Development Studio to SharePoint running SQL Server 2005 Reporting Services in SharePoint integrated mode. Whenever I try to deploy a report, the Reporting Services Login window pops up no matter which user/password I provide it won't accept any. I have the Reporting Services database set up to use Windows credentials and my Domain adminstrator account so I presume that this is user that I should be providing when prompted when deploying.
Can anyone give me any clues?
Thanks,
Michael
I am trying to figure out Reporting Services and to to deploy results -- and really don't know what I'm doing. I'm going through some books and it looks like our TargetServerURL would either be http://SERVER NAME/reports or http://SERVER NAME/reportserver.
Either one will give me a prompt for user & pswd. When I enter my network user & password, I get this message: "You are not authorized to view this page" (It's set up for Windows authentication.) Any suggestions?
Hi All,
we are changing some reports from English to German...some of the reports that we have changed generate the message 'An internal error occurred on the report server. See the error log for more details.'
We go to
C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFiles
On the machine but we cannot find any more detailed error messages...
Does anyone have any idea as to whether the messages migh be written somewhere else?
Thanks and Best Regards
Hi all,
We have many domain users who develop/deploy reports using VS2003 to our remote server at https://server/reportserver with no problems at all.
A single workstation on the domain that been used to develop reports cannot deploy though. The message looks fairly simple to diagnose "no report server was found at https://server/reportserver". I have checked dns and the servername resolves no problem. I have manaully edited and added the server to the hosts file also. I have updated and service packed all VS elements (VS2003 7.1.6030).
The server is contactable in all ways on this workstation, all ip/dns settings are the same as other domain workstations.
Can anyone point me in the direction of log files to look at, or if i am missing any basic options in VS. I have checked all deployment settings from other workstations.
Many Thanks!
Alex
Hi
I have two questions:
1)
I need to deploy reports to a server in Spain, which I do not have direct access to. Is there any way that I can simply deploy the reports to a server here, that I have access to, and then copy the reports to the server in Spain??? Or is there any other way? I cannot expect the customers in Spain to be able to use Microsoft Visual Studio 2005 themselves to deploy reports (they do not even have access to the tool).
2)
How do I set up reporting services on a clustered server? I have configured reporting services on both clusters, but somehow I cannot initialize both of them. Only on will be initialized at a time. Does anyone have experience with this?
Thanx :-)
I have two questions -
1. I have deployed the reports on our webserver. When I access the link http://servername/Reports from IE it asks me for a username and password the first time. I tried all the passwords including admin user/pwd but the dialog remains there. I close IE and start again I can access the reports. For your information, the checkbox 'Save my password' is checked in the reports. Does anyone know why the username/password dialog appears the first time?
2. Sometimes some of us get a 'Page cannot be displayed' while the others can access it. I have to start Reporting services and everyone can access the reports. Any ideas?
Thanks!!
Hi,
When I call certain reports from an ASP application, some prompt for password and some are not.
I wonder why is this happen?
Under the Directory Security of Reports under IIS 6, I already enable Anonymous Access for IUSR_XXXX with the correct password.
I also assign IUSR_XXXX as Browser in Report Manager of Reporting Services.
The enviroment is Windows Server 2003 standard edition, IIS 6, SQL Server 2005.
Thanks in advance.
Best regards,
Pop
Hi. I changed the Administrators Login password on my web & data base servers, both of which are hosted on Windows Server 2003 and run iis6. This caused the reports (I'm using 2005 Reporting services) to stop running. Rather I get the error: "The request failed with HTTP status 401: Unauthorized"
I made the necessary adjustments to the web.config and the reports just won't run. I have been struggling over this all day. Can anyone offer me some advice?
Thanks
HP
Ideally, I'd like to have the reports use windows authentication, ie grab current user/password so long as user does not have to enter it manually. If that is not possible, then how do I make it so user does not have to enter this info manually? My theory is that I have IIS set up incorrectly for doing this, but I'm not familiar enough with either reporting services or IIS to find out.
View 1 Replies View RelatedIn my site, when a user registers, I need to create rows in additional tables besides aspnet_Users. So, I need to be able to pass the generated userId guid to subsequent SqlCommands. I'm having a terrible time with this. What's the correct way to set up a SqlParameter so that it will accept a guid? I keep getting this error: "Conversion failed when converting from a character string to uniqueidentifier."
I've tried creating the parameter both with and without a SqlDbType.
cmd.Parameters.AddWithValue(paramName, guid);
and
SqlParameter p = new SqlParameter(paramName);p.SqlDbType = SqlDbType.Guid;cmd.Parameters.Add(p);
and I get the same error either way.
Driving me nuts! Any help appreciated.
Hi,
how to deploy the shared datasource and the related rdl files from test server to the client server.i am currently using Sql Server 2005.
Thanks in advance
Jai
I have connected to Database using my credentials by checking remember password option. After few days I forgot my password. How can I recover the password as SQL remember it. Is there any way to recover my password instead of resetting it.
View 3 Replies View Related