We recently had an issue where reports deployed under an account that was modified would no longer run subscriptions without deleting the reports and redeploying under a different account.
Is there a way to change the owner of all reports on the server? scripting or web service tips would be fine.
Thanks
I'm trying to see the properties of a database and I'm getting the following error, even when trying to connect as sa.
Property Owner is not available for Database '[EPro]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights.
any ideas? thanks in advance
It has been suggested by our DBA group that all developers whenworking on objects within a database create objects not under the DBOowner but under individual owners eginstead ofdbo.sp_getUsernamethe stored procedure would besmithJ.sp_getUserNameI have never seen this used before in sequel development although Ibelieve it is a method used by other database ingress/oracle ?I have never seen any one do this and can't see any benefit accept inmaking the developers life more complex as the stored procedures,tables etc would need to be renamed to belong to the dbo group oncethey were moved onto our production server. In addtion code callingthem would need to be modified after testing as we prefix our .Netcalling with the dbo prefixeg command.CommandText = "dbo.[usp_UpdateSavedSearchId]"Has any one followed this owner convention and are their any pros andcon's with it.
View 2 Replies View RelatedHi Forum,
Can a DataBase have more than one DBOwner?
If so, is there a query to return the list of DBOwners(dbo)?
Regards,
Naveen
Hello,
I once bookmarked an EXCELLENT script, using SQL-DMO to monitor disk space on this site. I unfortunately didn't cut and paste it, and when I went back to it, the link comes up blank.
Is there anyway to reactivate it? Or if anyone has it, please, PLEASE, post it! It was better than xp_fixeddrives, and I need it asap on a project.
Here is the link under SCRIPTS on this site, DISK SPACE ALERT:
http://www.databasejournal.com/scripts/article.php/1470811
Thank you much!
Hi everybody!
I create my database by restore from server’s backup. Every object there is owned by dbo77 user. I want to execute stored procedure in following way: exec sp1 and not – exec dbo77.sp1, when I connect with the same user. I create new Login – dbo77 in Securities folder of my server (LOCAL). And when I connect by this user to that database, I still can’t use syntax: exec sp1.
An error says that my login dbo77 does not have an associated user name. When I try to mark that database in dbo77 ->property->Database_Access it writes an error that dbo77 already exists.
How can I make this db work with syntax exec sp1, if I login with same login name as the owner of sp1?
Hi,
I've been asked to sort out a mess as follows:
two dbs on one server...
first db has a user called 'bob'.. that's the login on the server and also the login name on the db in question.
this db has several SP's owned by 'bob' which need to copied to the second db.
Here's where the problem starts.
Somehow, this second db has the standard users it needs, however the db User has a LoginName of 'bob'..
So basically if I try and create a user of 'bob' on the second server which will then allow me to copy these SP's across it says it already exists.. but if I just go ahead and try and copy the SP's it says the User does not exist.
Just to clarify what I mean..
I go into the 2nd db using EM.
go to users:
the visual that appears shows me several users in order with their
Name | Login Name | DB Access
the dbo user is set as:
dbo | bob | 2nd db
basically what I need (I think) is for that login Name to be removed from the dbo user and applied to specific user called bob...
how do I do that?
I want to get all databases with it's owner Name ,I think I need to join following script result with sys.databases or sys.sysdatabases.I want a result set  like this:
DatabaseName   db_Owner
master          sa
pubs           valia
pubs           eli
pubs           maryam
AdentureWork    eli
this script get all owners of the database that is in use:
Use DatabaseName
GO
SELECT  members.name MemberName, roles.name RoleName,roles.type_desc,members.type_desc
I would like to modify some of the properties of a ServerReport entity from a desktop app using the ReportViewer control. In particular, I would like to have the document map displayed as expanded, and make some changes to the group toggle items based on the user's parameter selection.
Can someone please point me in the right direction? How do I get access programmatically to the ServerReport layout?
Thx
Hi All
Can I change the name of a report depends on the parameters selected by end user?
Can you give me a similar expression?
Thanks
The report has many multi-valued parameter collection. Each parameter has its own dataset attached to it and each parameter has got a list of many values.
All parameters have a single default value dataset to return a DEFAULT value.
Now when the user selects value for each parameter, the reporting services takes times(atleast 5secs) to repaint/reload the whole page.
Could you please let me know how to resolve this.
thanks.
Hi,
Does anyone know how to change the Appearance of the Report Manager Homepage
i.e http://Localhost/Reports
Basically I want to add some Images instead of the Blank SQL Server RS Homepage.
Thanks in Advance for your Help,
Regards,
Sundar
Hi
I have a strange problem that basically consists of showing a report in Internet Explorer and then using the same Internet Explorer window to show an asp.net page that contains some form where the user can enter some data. In this scenario, the form won't be processed on the server. I really need to know why and how I can work around this problem.
Precisely the problem can be reproduced like this:
Environment: Server: Windows 2003 Standard Server SP1 (German), IIS 6, Client: Windows XP SP2, Internet Explorer 6
First I open a new Internet Explorer Window and let it show me a Reporting Services Report (by entering its url into the address bar). Everything works. Then I change the address to a simple web application's address that is built with asp.net (.net 1.1). The application contains only a form with a submit-button, a text box and a label, that shows the textbox' text after submit was clicked. But when I click the submit button, although the form seems to have been sent to the server (the green progress bar in the status bar is flickering), it's reset. So the label does not show the value I have entered into the the textbox and the textbox itself is cleared. This only happens when the browser was first showing a Report from Reporting Services, so when I open a new Browser Window and go directly to the web app, everything works fine.
It does not happen when I open the Browser directly on the server.
Thank you
Christian
I am currently creating a report with SQL Server Reporting Service 2005 and have run into an issue where the user can change the value in a drop down and the report will reload without any data. Data will not show untill the "View Report" button is clicked. Is there any way to avoid the page reloading like this so that the user is not confuesed by the lack of data ans just thinks that nothing was suppose to show up?
Thanks in advance.
Hello all!
Does anybody know, if it is possilbe to dynamically change grouping in a table report?
I mean, is it possible to provide the enduser the capability to group data in a table on whatever column he would like?
The second question is related:
Is it possible to make a usersort on a grouped table, in such way, that ALL the rows would be sorted ascended regardless of the group they belong to? (For now the only way I see to do this is to give the enduser possibility to turn off grouping manually)
Hi @ all,
I work on a german Windows environment and use the Report Builder. For showing details in their it is necessary to switch the German interface in Report Builder into English.
I already tried to change my environment into English but it even after a restart it did not change the Report Builder interface....
I also tried to search all the XML-files for a language setting - with no success....
Does anyone know how to do this? Would be very helpful....!
Thanks in advance,
Jochen
I have a report I want to modify and when I go to deploy it I get:
Changing the report parameters or data sources to the values you specified is not allowed. The report is configured to run unattended. Using the specified values would prevent the unattended processing of this report
Now I understand the error, it is because on the report server's web management interface I entered credentials for the report to run that point to a custom datasource and supplied the appropriate credentials to run the report.
However, I don't want to have to reconfigure that just to deploy a slightly modified version of the report.
How can I get around this? Or what is the proper work around? I just want to change the background color from dark gray to light gray on a header column....
Thanks!
When I am working on an Integrations Services project and I open a Reporting Services file, it displays it in the Code view. Is there a way to display it in the Design view? Or do I have to close the project and open up a Reporting Services project?
Fred
We are getting frequently blocking in Report server database.
Is it ok to change isolation level to RCSI for report server database?
I want to be able to open URLs in a new window in my SSRS report, and the URLs keep changing in every record. The problem is these links are not the only things present in the record, and there is other data present. I keep seeing examples where they are considering only a link to be present in the record with no other data.
Also the data in the record includes HTML tags and I checked the option that says "HTML - Interpret HTML tags as styles" on the placeholder properties window.
Example of data in the record:
Hello! Welcome to google, the most used search engine.
Click on www.google.com to go the website
So when I click on the www.google.com URL, it should open in a new window.Â
SQL server 2005 express reporting problem.
error message:
This feature "remote access to report data sources and/or the report server database" is not supported in this edition of reporting service
I got this error message when I try to connect to database hosted in another PC running SQL server 2000.
Is it true that SQlL server Express can only use Local Database Engine to host the database?
I just created a report builder. I have a main report and i wanted to create a sub report. why i cant or i cant view the path or the folder of my .rdl file to be use as my sub report.
View 5 Replies View RelatedAfter I use the report builder to create a generic report, how do I actually get that report into the report designer so that I can modify it more effectivly?
The issue that I have now is that the file on the report server is not a .rdl file and if I simply save it as one and then bring it into VS to modify it the code file is a html structure rater than a XML file type.
Any suggestions would be appreciated. Thanks
How do I jump to another report based on a value in my current report. The report that I am jumping from has no parameters, just values.
View 7 Replies View Related
Hi,
When i select datasource in Report Builder, i am able to see all the available DataSources.
Eg: I have selected one datasource from the list and which has 3 tables(table1, table2, table3) associated to that datasource.
when i drag and drop table1 fields to report, i am not able to see the other 2 tables(table2 & table3)
Is there any property or relationship do i need to maintain?
Thanks,
SR.
A college forgot to change the data root when installing a developer server. My question is can this be changed whitout reinstalling the server and restoring the developer databases.
I found sqldataroot under [HKEY_LOCAL_MACHINESoftwareMicrosoftMSSQLServerSetu pSQLDataRoot]
If I stop the sql server and change this value and move the *.mdb and *.ldf files. Would I risk currupting the databases and do I need to change something else? For example would changeing this value change the default path for backupdevices?
I have a problem where our developers would like to change the passwords of the SQL Logins without knowing the users old password.
The only way they can use the below syntax is that they must be a member of the SYSAdmin Server Role.
sp_password NULL, 'newpassword',Max
I need a way to allow them to change the passwords without making a user a member of the SYSAdmin Server Role.
Any thoughts would be greatly apprecitated. Thanks in advance.
Max
I need to change my security settings from "Windows NT Only" to "SQL Server and Windows NT". Does anyone know of any issues with doing this? Does this subtract anything or does it only add access??
View 1 Replies View RelatedIs there a way to change the license key after installation of SQL7.0?
View 1 Replies View Relatedhi, I have created a database in sql server 2000. I need to duplicate the database under different name, how can I do that?
Also, can I rename a database name?
thanks
Ali
Hi all,
I need to change the NT Server computer name (and the SQL Server name). I know how to do it in NT, but how would I go about changing the SQL Server name. Can anyone help me with this? Is this an easy process?
Thanks,
LC
Someone is changing permissions on our production sql databases frequently which is causing big problems..any idea how to know who is changing and when? Any code that can be written to capture such activity?
thanks,
dbfan.
I`m running SQL 6.5 with standard security. We`re running NT 4.0. I am a member of the NT Admin group - which, of course, has sa privileges in SQL Server. I changed the sa password (via Enterpise Manager on my client machine); and it worked. I tested the password change by connecting to ISQL/w - both on my client machine and at the server machine.
However, when I attempted to connect to the server via Enterprise Manager (SEM) - on my client machine - my login attempt failed. But at the server machine, I connected just fine.
Somehow, even though we`re using standard security, I`m getting locked out of SEM because of the new password. Changing the sa password back to what it had been resolved the problem; but the old password was only meant to be temporary.
Any suggestions or explanations?