Localization And BUILTIN Groups
Jun 28, 2006
Is there a synonym for the group BUILTINUsers which can be used for GRANT ... TO and sp_grantlogin/sp_grantdbaccess, but which will work on localized computers?
I have a number of automated unit tests I wish to run on two different computers. The process involves recreating a database if it does not exist and then granting access and privileges to the BUILTINUsers group.
The problem is that one computer is installed with a Swedish Windows XP Professional (the users group is called BUILTINAnvändare) and the other is an English WinXP MCE (the group is called BUILTINUsers) so I cannot easily script this.
An alternative is to be able to retrieve the respective name through a .NET class or the Windows API.
Is any of this possible?
Thanks,
Johan
View 8 Replies
ADVERTISEMENT
Nov 19, 2001
I'm using Mix-Moded Authentication. Can I remove the Builtin/Administrator loggin ID without cause any harm to my current Login ID user(Windows NT user)? Are will removing Builtin/Administrator what harm will this cause to my server?
View 1 Replies
View Related
Nov 5, 1999
I would like to remove the BUILTIN/Administrators group from SQL Server in
order to prevent NT Administrators from having SQL sysadmin authority.
Does anyone see any harm in doing this eg. could it affect future SQL Server
upgrades if this group no longer exists?
Any help would be appreciated.
Regards,
Ian Brennan
BT (UK)
View 1 Replies
View Related
Mar 16, 2007
I have this posted in the VFP section of the forums but the more I find out about the issue the more I think there is an SQL Server security issues.
What I am doing is trying to connect to a LinkedServer of my SQL Express 2005 database running on windows vista. I have the linked server set up to connect to a local FoxPro table using the VFPOLEDB provider. If I log in as the 'sa' account I am able to do my query. But if I log into the server using a trusted connection it doesn't work. I get the error [The OLE DB provider "VFPOLEDB" for linked server "sys" reported an error. The provider did not give any information about the error.]
So I went in and set the BUILTINUser login as the sysAdmin. I also made sure that all of the security settings in SQL server were set up the same between the trusted user and the 'sa' user.
My question is, What am I missing? Is there something that I need to set on windows or is there a setting in SQL server?
View 2 Replies
View Related
Jan 25, 2008
I have a new SQL 2005 (SP2) Reporting Services server to which I've just upgraded and deployed some SSRS 2000 reports.
I have a subreport that contains a matrix with two groups. The report data seems to be inexplicably repeating the data for the first row in the group for all rows in the group. Example:
ID1
ID2
DisplayData
1
1
A
1
2
B
1
3
C
2
1
A
2
2
B
2
3
C
Parent group is on ID1, child group is on ID2, report would show:
1
1
A
2
A
3
A
2
1
A
2
A
3
A
Is this a matrix bug in 2005 SP2, or do I need to do something differently? I can no longer pull a comparison version from an SSRS 2000 server to verify, but I believe it was working as expected before...
View 2 Replies
View Related
Jan 21, 2008
Roles Table:
RoleID, RoleName
<RoleID1>, Allow_ClientFolder
<RoleID2>, Allow_ClientReportA
<RoleID3>, Allow_ClientReportB
<RoleID4>, Allow_CompanyFolder
<RoleID5>, Allow_CompanyReportA
<RoleID6>, Allow_CompanyReportB
UsersInRoles Table:
UserID, RoleID
<UserID1>, <RoleID1>
<UserID1>, <RoleID2>
<UserID2>, <RoleID4>
<UserID2>, <RoleID5>
<UserID2>, <RoleID6>
<UserID2>, <RoleID1>
<UserID2>, <RoleID3>
e.g.
when the <UserID1> clicks on the "home" link show only "Client" folder and when <UserID1> clicks on the "Client" folder only "ClientReportA" will show.
Here is the accessable map for each user:
<UserID1>
Client
ClientReportA
<UserID2>
Client
ClientReportB
Company
CompanyReportA
CompanyReportB
Question:
What is the best way to implement CheckAccess? At first I thought I can access the item names and I can test authorization through that, but AceCollection contains operation permission of the accessing object.
View 4 Replies
View Related
Jul 20, 2015
We have a development server and someone went ahead and deleted the BuiltinAdministrators account in SSRS 2008 R2. I would like to know if, as a local admin of the server, I can recover content manager access to the SSRS instance.
View 2 Replies
View Related
Jun 24, 2007
Dear friends,
Is there any provision to make the SQL Server Reporting Services commands,returning from SQL query, instead of writing that directly in the report.
Best Regards,
Baburaj
View 3 Replies
View Related
Jul 23, 2005
Hi All,I already have a web site running with SQL Server as a backend (inenglish)For future growth, I would like to make it localized. Regardingthe database, I have come up with several approaches.1) just simply add the column in those table which needs differentlanguage.2) add additional tables to do it.3) create a new database to store different language's informationAs mentioned, my database have already been implemented, so the minimummodification is preferred. Could you guys suggest me the best way to doit?Another thing, if I alter my existing database into UTF-8 now, will itaffect the original data (ie. English).Thanks.Ice
View 7 Replies
View Related
Jul 20, 2005
Hi,I have a simple 'user' table and an ASP form that connects to it. Iwant users of all languages to be able to type in their registrationinfo, in their own language, store it that way, then have another pagethat displays it.Are there any specific settings I need in SQL Server to handle this?Thanks
View 4 Replies
View Related
May 15, 2007
How can i add resources to my report (*.rdl) at runtime depending upon the curren culture ie text ,date formats ,currency setting getting changed according to current culture.Is there any way i can define resource file for report?
View 1 Replies
View Related
Aug 20, 2007
I want to make my report in both english and spenish language.
how can I set culture for reports?
View 8 Replies
View Related
Mar 16, 2007
Hello,I am working on a Blog and a Documents systems.What I need is:1. Each blog can have various language versions.2. Each document can have various language versions.I have been thinking about this and I end up with two approaches:1. Use a structure where all tables depend on a localized table:BLOGS|---- BlogsLocalized|---- BlogsPosts|---- BlogsRatings|---- BlogsComments2. Use a structure where each table has a localized versionBLOGS|---- BlogsLocalized|---- BlogsPosts|---- BlogsPostsLocalized|---- BlogsComments|---- BlogsCommentsLocalized3. Create a simpler, without localization, in SQL and in my web sites have different versions for each language.The same approach is under thinking for DocumentsTables.Could someone give me some advice?I have been looking in internet but until no I couldn't find anything really useful.Thanks,Miguel
View 1 Replies
View Related
Jun 19, 2007
Hi.
I have distributed databases in different language versions, I am creating a stored procedure, and this problably in future is going to be migrated to other SQL Server database. the query that I have inside the stored procedure is this:
Insert Into Prueba Values(14,'31/07/1999') -------> format date of this query is in Hispanic version (this works fine)
But, If this query is migrated to other SQL Server and it's version would be in English, that query wouldn't work, the principal reason is the format date.
Solution that I have on mind is creating a stored procedure that receives three parameters the month,day and year. I want to identify the localization of that SQL Server database and use "IF" conditions and inside of these concatenate month,day and year obviously depending of the date format identified through "IF" conditions.
If somebody has an idea to solve this or somebody knows how to identify the locatization in an SQL Server database I would be thankful.
Thank you again and best regards.
Christian
View 2 Replies
View Related
Apr 30, 2007
Hello all,
I'm working on an ASP.NET with a SQL server for database. Some of the tables, for example, contain information such as different types of Fabrics (silk, cotton, etc..) . I'd like to have this table localizable (English and French for instance). Is this possible ? Is there an equivalent of resource files in SQL server ?
Or do I have to do this manually ? (have 2 separate fields in the table for those 2 locales)
View 1 Replies
View Related
Aug 17, 2006
Hi,
I am implementing a "customizable resource provider" for Globalization based on Sql Server instead of resource files. After reading the following articules:
http://msdn2.microsoft.com/en-us/library/azx5x197.aspx
http://msdn2.microsoft.com/en-us/library/9b1d2yze(en-US,VS.80).aspx
I was able to produce a library that save local resources and and retrive resources from Sql Server using "GetGlobalResourceObject() and GetLocalResourceObject()", but I am having trouble to make it work with "Intelicense".
I think that the issue is related to class derived from "System.Web.UI.Design.DesignTimeResourceProviderFactory" class.
Does anyone knows where I can get more information regarding customizable resource provider and intelicense?
Note: I do not know how to attach my code.
Thank you,
Rj3
View 1 Replies
View Related
Jul 24, 2007
Hi everybody,
I have a question does it possible to have the param prompt in the different language without doing multipe report for each language, I saw it is possible for the label, but I didn't see how to do for the prompt param.
I hope someone could help me.
Thank you.
View 2 Replies
View Related
May 31, 2007
I have written this ugly expression because I didn't know any other way. What I am trying to do is convert an English date string to a French string.
example
January 2005 ---> Janvier 2005
Thank you,
Pavel
=Switch(
Month(CDate(Fields!Month.Value) ) = 1, "Janvier" & " " & Year(CDate(Fields!Month.Value)),
Month(CDate(Fields!Month.Value) ) = 2, "Fevrier" & " " & Year(CDate(Fields!Month.Value)),
Month(CDate(Fields!Month.Value) ) = 3, "Mars" & " " & Year(CDate(Fields!Month.Value)),
Month(CDate(Fields!Month.Value) ) = 4, "Avril" & " " & Year(CDate(Fields!Month.Value)),
Month(CDate(Fields!Month.Value) ) = 5, "Mai" & " " & Year(CDate(Fields!Month.Value)),
Month(CDate(Fields!Month.Value) ) = 6, "Juin" & " " & Year(CDate(Fields!Month.Value)),
Month(CDate(Fields!Month.Value) ) = 7, "Juillet" & " " & Year(CDate(Fields!Month.Value)),
Month(CDate(Fields!Month.Value) ) = 8, "Aout" & " " & Year(CDate(Fields!Month.Value)),
Month(CDate(Fields!Month.Value) ) = 9, "September" & " " & Year(CDate(Fields!Month.Value)),
Month(CDate(Fields!Month.Value) ) = 10, "Octobre" & " " & Year(CDate(Fields!Month.Value)),
Month(CDate(Fields!Month.Value) ) = 11, "November" & " " & Year(CDate(Fields!Month.Value)),
Month(CDate(Fields!Month.Value) ) = 12, "December" & " " & Year(CDate(Fields!Month.Value))
)
View 2 Replies
View Related
Sep 17, 2007
Where can I obtain a list of the languages as used in the report language property for populating a parameter?
Currently if I put the list that is in the Language Dropdown (Ex. "French (France)") it does not work. I have to use "fr - Fr"
Thanks
BobP
View 1 Replies
View Related
Dec 19, 2006
Hello to all!
I want to translate de interface of the Report Manager to Portuguese. I'm develop a class that implements
Microsoft.Reporting.WebForms.IReportViewerMessages The class is in a file called "ReportViewerMessages.cs". The structure is like this, the project is called "PortugueseReportManager", there is a namespace named "PortugueseReportManager" and the name of the class is "ReportViewerMessages".
So far so good, but when I change de web.config file in the report manager folder I'm getting over and over this error message when I try to see a report: The type PortugueseReportManager.ReportViewerMessages, PortugueseReportManager, Version=1.612.19.1, Culture=neutral, PublicKeyToken=5cdefa29ce50bd9e does not implement IReportViewerMessages or could not be found
This is the line that I add to the config file:
<add key="ReportViewerMessages" value="PortugueseReportManager.ReportViewerMessages, PortugueseReportManager, Version=1.612.19.1, Culture=neutral, PublicKeyToken=5cdefa29ce50bd9e"/>
The version is correct and the public key token I get by strong signing the class and then run de command: "sn -T PortugueseReportManager.dll
I copy the dll file to the Bin folder of my Report Manager folder.
Please, can anyone help me in this one? I try a lot of combinations in the config file and so far I did't get any results.
Thanks in advance!
View 13 Replies
View Related
Jan 17, 2008
Hi everyone,I followed the steps below to localize the report viewer control accoring to http://msdn2.microsoft.com/en-us/library/ms251723(VS.80).aspx"
Deploying Localized Versions of ReportViewer ControlsThe ReportViewer control includes language packs for eight languages: Chinese-Simplified, Chinese-Traditional, French, German, Italian, Japanese, Korean, and Spanish. To use a localized version of the control, you must do the following:1. Run ReportViewer.exe.2. Navigate to the folder that contains the language pack you want to use. Language pack folders are located at <drive>:Program FilesMicrosoft Visual Studio 8SDKv2.0BootStrapperPackagesReportViewer<lang>.3. Run ReportViewerLP.exe."
But I could not find the ReportViewerLP.exe in the step 3. Could anyone please tell me why?Thanks a lot.Danny
View 1 Replies
View Related
Jul 15, 2015
I have a table called country that will store all the country related details in it. Below is the screenshot of my country table.
I want to localize this table to Japanese language. I googled out and found out that a new table needs to be created for storing the data in localized language.
If that's the case do we need to manually translate the text in the country table for each and every country?
Is there any automated process for that? Just like not translating the text manually for each and every rows..
This is because I have few more tables in which the text are not static. they will get loaded on a daily basis. So i will not be able to translate them every day..
View 5 Replies
View Related
Apr 14, 2008
I need to prevent domain and local administrators from having full control over our report manager. (I want them to be assigned permissions just like everyone else, some reports they can see other reports they can not.)
How can I accomplish this? I tried going into Report Manager -> Site Settings -> Configure Site Wide Security and re-assigning BUILTINAdministrators to the System User role instead of the System Administrator role. (A different set of report manager admins was given the system administrator role).
However, it appears that members of the BUILTINAdministrators group still have full control in Report Manager.
View 3 Replies
View Related
Jul 27, 2015
I work in a big project and we will begin in using reporting services as the base technique for reports and I will be responsible for this part. but I have a problem I will discuss in the following:
Currently: We use currently devexpress reports and we have 2 languages(Arabic and English). the data in tables saved in two ways (Arabic and English). when the end user change the language of the web site the report data language changed when run it.
Example:
we have table with (ID, NAME_AR, NAME_EN, JobTitle_AR, JobTitle_EN). designed report will display(ID, NAME_EN, JobTitle_EN) . but the end user change the language of the system the report will
dispaly(ID, NAME_AR, JobTitle_AR)
Hint:this done pragmatically
how to do this in reporting services.
View 7 Replies
View Related
Jan 8, 2007
I expect to get a record below with a count of 0 (and I do), but when I take the comments out (--) of lines 1 & 6 I don't understand why I get no records at all. I need to be able to see all teams in EvalAnswers even if none of the records satisfies the where clause.1 select Count(*) as cnt--, TeamID
2 from EvalAnswers
3 where CoID=@CoID
4 and EvaluatorID=@EvaluatorID
5 and (Scr0=0 and Sugg0 is NULL)
6 --group by TeamID
7
View 4 Replies
View Related
Jan 31, 2002
Hi,
I would like to create groups in SQLServer2000.Do i need to do this by roles or can i create groups for each database.I read some where that there where
no groups for SQLServer7.0. Is this option available for the latest versions.
Any help will be appreciated.
Thanks in Advance.
Ran.
View 3 Replies
View Related
Jan 8, 2001
If you have a SAN, is there any real benefit to breaking out large tables into file groups?
View 1 Replies
View Related
Nov 24, 2011
I have a Attendance table named say Attendance which has Class and Status along with some other fields.Class will have the name of the class the student is in,whereas the status will have the Absent/Present data.There is another table named say ClassMaster which is the master which will have all the classnames and there is a column of ClassTeacher which will have the EmployeeCode.This employeeCode comes from a table EmployeeMaster.My requirement is i want to get the count of Absent students in Attendance table depending on the Class.For Example if there are two class say ClassA and ClassB,then i should get the count of the Students from Attendance table that belong to Class A and Class B.How cn i do this in one Query.
View 1 Replies
View Related
Nov 3, 2007
I am looking to find out when to use file groups when backing up. When should you use this, what's the benefit over just doing a full db backup? Is it better when you are dealing with large db's?
Also this question has been on my mind for a while. Why shouldn't you shrink the db after every full backup? What is the negative in doing so?
Thanks
View 1 Replies
View Related
Jul 20, 2005
I realize the irony of asking this here, but does anyone know of any MySQLgroups where I can ask my questions?Thanks.
View 1 Replies
View Related
May 16, 2008
In my report I have 3 row groups and two column groups as follows, where measure is number of hours for a given project.
2008/05 2008/06 ........
Demand | Allocated Demand | Allocated
- Project 1 1500 1000
- Department1 500 400
- Employee1 200
- Employee2 200
- Department2 1000 600
- Employee3 300
- Employee4 300
+ Project 2 1200 1000
-------------------------------------------------------------------------------------------------------------------------
Grand Total 2700 2000
My question is, is this possible using a Matrix? I have used matrix in some of my reports but have always used automatic/generic SUM feature it provides.
Note carefully that there are no values for Employees in Demand Column Group. Basically I would have to SUM Department groupings to get the Project level total and then SUM all Project Groupings to get the grand total. The Allocation column is okay since the Employees have values in that column. Can this be done using InScope( ) or some other function rather than simply doing the Generic SUM of Rows and Columns of the matrix which would probably throw error when trying to sum a blank value in demand column.
Thanks in advance.
View 2 Replies
View Related
Apr 13, 2007
How do I put information only at the top of a page and have it change whenever a group occurs.
I want to do something like this. Have this on the top of every page:
Country: current country
State: current state
City: current city
There is a group on country, state and city. Whenever city changes the next page will display a new city. Whenever state changes the next page will display the new state in the header.
I have already put Country, State, and City into their own group headers. However, if either of them change in the middle of the page then the group header repeats. I have group header repeat on so I can see it on each page. If I choose the Page break at start then it breaks but I don't want it to break. I want it to run on the same page if it passes a group and then have the next page display relevant information for the group.
Putting it in the table header works as far as keeping them all on the top of the page but it doesn't change when a grouping ends.
Please assist me in anyway you can.
Thanks,
Sarah
View 9 Replies
View Related
Mar 17, 2008
I have my first SSRS report going, after years on Crystal and Access. It has several groups, each nested within the next...I think. I'm having a little trouble with the groups...well, grouping the way I thought I had it set up. The groups come out looking like my primary group is second instead of first, although when I look at the groups in "edit groups" it appears I have them set up correctly.
In Crystal, on the preview page you could see the groups idendified so if there was a problem in a report you could tell what group it was coming from. You could also select and change objects in preview, which made it nice to see the impact of changes. I cannot see either of these features in SSRS. I'm hoping that there's a setting I need to turn on, and also hoping that this product has these user friendly features. Any ideas on that?
Also, in Crystal, when you set up a group or a formula, it became available in the field list within the formula builder, so you could use them by picking them instead of typing the whole thing in again, and that's not available either. Or I can't find it!
Since I'm new to SSRS maybe there are features and settings I haven't found yet, but would appreciate any comments from more experienced users about the overall usability of this tool.
Thanks!
View 9 Replies
View Related
