BUILTINAdministrators Not Recognized - RsUnknownUserName
Feb 14, 2007
Hello all,
We recently moved our Team Foundation Server from one server to another, of course the reporting services was also included in that move.
On the new server, we are not able to change Reporting Services security parameters anymore, we get this error :
User or group « BUILTINAdministrators » not recognized. (rsUnknownUserName)
The old server was an english windows 2003, the new one a french version, i guess the problem is related. The BUILTINAdministrators group name on the new server is "BUILTINAdministrateurs".
Is there a way to change security params without getting this error ? How can we remove from Reporting Services this reference to BUILDTINAdministrators ? I've tried to modify the table Users directly in ReportServer DB without any success..
I have a big problem with Reporting Services 2005 working on Windows 2003 Server. RS work as Network service, on subdomain reporting.mydomain with SSL wildcard certificate *.mydomain, Anonymous access: disabled and basic authentication: enabled ReportManager and reportServer has defualt virtual folders (/reporting, /reportserver)
My problem is: 1) I can't manage security roles and site settings with report maanger. when I try assign roles to new user or group I get followng error:
"The user or group name 'BUILTINAdministrators' is not recognized. (rsUnknownUserName) Get Online Help" when i try to execute reports in report manager, parameters controls are not displayed correctly (very simple text boxes) and I can see: The selected report is not ready for viewing. The report is still being rendered or a report snapshot is not available. (rsReportNotReady)
and I can't see my report in browser (IE 6.0) but only export to PDF, Excel...
other functionality are working fine i.e upload new files, creatign folders....
2) Also my reportserver virtual folder does not work correctly. When I navigate to mydomain/reportserver I can see content of this virtual folder, than when I navigate to ReportService.soap i can see normal ReportServer view
reporting.mydomain - /Reportserver/
[To Parent Directory]
Montag, 10. April 2006 16:31 <dir> bin Dienstag, 6. September 2005 01:12 488278 Catalog.sql Dienstag, 6. September 2005 01:12 14738 CatalogTempDB.sql Freitag, 21. April 2006 19:45 10555 Copy of rsreportserver.config Freitag, 14. April 2006 17:29 76 global.asax Freitag, 15. Juli 2005 01:12 26582 ModelGenerationRules.smgl Montag, 10. April 2006 16:31 <dir> Pages Montag, 10. April 2006 16:31 <dir> ReportBuilder Montag, 13. Juni 2005 14:07 143 ReportExecution2005.asmx Montag, 13. Juni 2005 14:06 196337 ReportingServices.wsdl Montag, 13. Juni 2005 14:07 131 ReportService.asmx Montag, 13. Juni 2005 14:07 131 ReportService.soap Montag, 13. Juni 2005 14:07 139 ReportService2005.asmx Dienstag, 13. Juni 2006 20:01 10580 rsreportserver.config Montag, 13. Juni 2005 14:07 11845 rssrvpolicy.config Montag, 10. April 2006 16:31 <dir> Styles Freitag, 17. Juni 2005 01:09 2673 web.config
but me reports are not displayed correctly, I can run reports but top bar with parameters, export and print function are not displayed in correct format. (simple textboxes, and icons)
reporting.mydomain/ReportServer - /
Microsoft SQL Server Reporting Services Version 9.00.1399.00
I think it is security issue. What schould i do to solve this problems?
Hi all, i have some problem... I need give role on REPORT MANAGER, to user 'ASNETmy group' , but for this string it cant find my user because i have a space char between my and user... Problem is that all accounts in a company have this space char in name. I dont know how can i write it to roles on RS. Have anybody some idea? I will be happy if you will help mi with it. Thanx!
EDIT: I tryed ASNETmygroup, 'ASNETmy group', "ASNETmy group", ASNETmy_group,... but i cannot change all of groups to format ASNETxxx_xxx because it is about 40 groups ( big company ) and we have this acc directly wroted on our applications... RS run on 2005 sql server.
Hi, Are there any implications for removing this group from SQL Server logins? We are trying to tighten up security and this is one area we want to focus on?
As default, the BUILTINAdministrators account is created during the installation of SQL Server 7.0. The default access is to have the account in the System Administrators server role which gives them dbo access to each database.
Since I don't want my network administrators to have sa privleges within SQL but still want them to be able to access the databases, I've removed them from the System Administrators server role. The SQL Server Login Properties window still shows the account having access into each of the databases as dbo, however they are unable to view or access any objects within the databases.
Shouldn't the account still have permissions, just not as sa? Can someone please explain this to me? I've checked BOL and several of the reference books I have, but don't find any detailed information on this account.
I am using SQL 2k SP2 on Win 2K Advance server Cluster. My problem is how to remove builtinAdministrators login. Earlier when I tried it was doing failovers from one node to another and not stopping. I was not able to do anything. Any help is appriciated
This message is in reference to a previously posted SLQ Server 7 question and answer regarding the BUILTINAdministrators account (dated 11/19/2001)
Original Question: I'm using Mix-Mode 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?
Answer to above: The first thing I do after installing SQL is remove the Builtin/Administrators account for the SQL Server. Depending on how you set SQL up, this should not affect any NT users, unless you granted them access to the server through the local Administrators group. This is not the prefered way of granting access, however. This will give any administrator on the machine access to all of the data, which you may not want, depending on the confidentiality of the data.
Situation: (SQL Server using Mixed Mode Authentication). If the Builtin/Administrators is disabled or deleted, and the server rebooted, SQL Server will be initiated but, the SQL Server Agent won't be. Signing onto SQL Server as SA will not be able to restart SQL Agent nor will an NT user with administrator capability have any better luck
Question: What specifically in NT and SQL Server does one need to change to get around this situation. The SQL Server documentation is not very helpful regarding the use of this login.
While attending a SQL 2000 Administrator course, two of my colleagues were told to always delete this account but were not given any reason or explained the consequence of this action.
We need to remove the BUILTINAdministrators from reporting services. I.T. personnel do not want to be able to see restricted reports. We have two department users that have been added as Content Managers and we are running reporting services under a created domain user account that we created and not a system service. I have removed BUILTINAdministrators from the Home folder and when I check, it comes right back. Do I need to deny access to BUILTINAdministrator on SQL Server 2005 itself? I would apprecate any suggestions.
After I removed the BuiltinAdministrators Group and changed the SQL Service Account from LocalSystem to my Window account this Openrowset query fail.
select a.* from openrowset('MSOLAP', 'DATASOURCE=HODB02;Initial Catalog=POS_DM;', 'SELECT {[Measures].[SALE PRICE]} ON COLUMNS, {[Item_Type].[Description].MEMBERS }ON ROWS FROM [ONLINE SALES ANALYSIS]' ) as a
OLE DB provider "MSOLAP" for linked server "(null)" returned message "The following system error occurred: No connection could be made because the target machine actively refused it. .".
Is that relate the teh Security Account Delegation?
does someone know where to find information regarding what is accesible to a BUILTINAdministrator which is not accesible to a System Administrator?
Somewhere I have read that a System Administrator can not see the "All users' folders (i.e. the collection of "My folder"s for all users of the Report Server) but I have also experienced a behaviour which has surprised me: as a System Administrator with all permissions I cann't even see folders that a BUILTINAdministrator can.
Does it mean that a System Administrator can not really manage all the resources of a Report Server?
We have a server shared by two project teams. To tight the security, I want to remove BUILTINAdministrators off the public and sysadmin server roles. My question: any thing I should pay special attention ? I use LocalSystem to start all SQL Service. I know this is not a very good pratice yet I have no choice as our company network is a mixed of windows and novell, we do not have AD.
SQL Server 2005, Windows Server 2003: On our production db, the SA acct has been locked. I realize that I could enable mixed mode and then connect via an administrator -- but we are already running in mixed mode, and our BUILTINAdministrators account has sysadmin permissions turned off.
As it stands, the only user I can connect as does not have permission to modify any of the login info.
What recourse do I have at this point? Can I disable mixed-mode and re-enable it (via registry)? If so, will it reset the SA account or rebuild the BUILTINAdministrators login for me?
Or do I need to contact Microsoft, and if so is there anything they can do?
I need to remove full admin privs from the builtinadministrator's group in report manager.
I tried removing the builtinadmin role from report manager and SQL Server, I removed it from the Site Settings area and from each individual folder's permissions.
Yet all the members of that group still have full run of the report server...
I even made a new folder that ONLY I am listed as having permissions to, yet they can see that as well...???
Hi I am a bit new to SQL Server so please help me I am trying to run a simple task at a customer but it doesn't work. bcp isn't recognized.
I'm running this: exec xp_cmdshell 'bcp "SELECT top 10 * FROM pubs..authors " queryout "C:Temphej.txt" -c -S [ServerName] -T' and it givs me this errormess. 'bcp' is not recognized as an internal or external command,
It works fine for me when I'm running it on my computer.
Can anyone please inform me what I'm missing. I haven't got a clue. BR Ciotti
I am using MS SQL Server 2000. I am reading right off of microsofts web site under Trasact-SQL Reference, on how to use the MIN function. Yet when I try to use it, I get the error:
'min' is not a recognized function name
Here is the sql statement copied right out of Query Analyzer:
select name, count(name), min( case when not(var6 = '') then 7 else case when not(var5 ='') then 6 else case when not(var4 ='') then 5 else case when not(var3 ='') then 4 else case when not(var2 ='') then 3 else case when not(var1 ='') then 2 else 1 end end end end end end as cols ) from syitabs where dupef=0 group by name
for some reason when i use this field (incidentid.value) there is no hyperlink generated, however when i change the value to another field, the hyperlink works, what shall i be looking for, incident value is a set of number with dashes!
Just installed SQL Server 2005 Express along with the Management Studio. The Management Studio, at least what I've seen so far, seems to work fine. But when I type "sqlcmd" at the command prompt, I get "sqlcmd is not a recognized internal or external command, operable program or batch file." What gives???
HI, This is my req... i have to sum up the qty n that qty should be added to qtyonhand in other table....
Declare Qty INT Qty =SELECT SUM(Quantity) FROM InventoryLedger WHERE ITEMID=@ItemID
UPDATE IW SET IW.QtyOnHand=IW.QtyOnHand + Qty - @TAllotedQty FROM InventoryByWarehouse IW where IW.CompanyID = @CompanyID AND IW.DivisionID = @DivisionID AND IW.DepartmentID = @DepartmentID AND IW.ItemID=@ItemID
I think this error message is related to the fact that I'm using CREATE Table in my stored procedure to handle temporary table data. What can I do to declare a variable here?
CREATE PROCEDURE spTeamPORReport (@FacilityName nvarchar(50) = NULL, @CustomerTeamName nvarchar(50) = NULL, @CustomerName nvarchar(50)=NULL, @AssemblyPartNumber nvarchar(50)=NULL, @DateStart smalldatetime, @DateEnd smalldatetime) AS SET NOCOUNT ON
I am trying to run the following code in SQL Server 2005:
DECLARE @cleartext NVARCHAR(100)
DECLARE @encryptedstuff NVARCHAR(100)
DECLARE @decryptedstuff NVARCHAR(100)
SET @cleartext = 'XYZ'
SET @encryptedstuff = EncryptByPassPhrase('12345', @cleartext)
SELECT @encryptedstuff
SET @decryptedstuff = DecryptByPassphrase('12345', @encryptedstuff)
SELECT @decryptedstuff
and am recieving an error:
Msg 195, Level 15, State 10, Line 5
'EncryptByPassPhrase' is not a recognized function name.
Msg 195, Level 15, State 10, Line 7
'DecryptByPassphrase' is not a recognized function name.
It appears as though this EncryptByPassPhrase and DecryptByPassphrase as supported in 2005 T-SQL commands but when I execute this code in SQL Server Studio it errors out.
I have read all of the messages related to the above problem and none have solved the issue. We have migrated a SQL 2000 database to SQL 2005. Detached from one and attached to the other and then based on some of the conversation I also used the SQL Server 2005's copy option and copied the database. Detached the old one and renamed the new database which was created in the copy process to the old name. Basically getting back to where I started. By the way there are no triggers generated during the process (as was mentioned), nothing to delete as some of the discussion was suggesting. Big databse, lots of tables and stored procedures. All screens seem to work except when we try to update some data using a stored procedure which takes the data and updates the table. End up getting the above error during the execution. All used to work fine with SQL Server 2000. I have taken the SQL out of the stored procedure and executed manually and it worked but leaving the stored procedure alone and calling it with the updated data we get the INITCOLVS problem. The database is also set to be compatible to 90 so that suggestion also has not fixed the problem. Looking for additional suggestions and solutions. Some one was talking about making a dummy INITCOLVS function, have not done this yet but don't particularly like this suggestion, like to know the cause and the proper solution to the problem. Again in summary: Migrated SQL 2000 database to 2005 Have done the copy and attach process to make sure the whole conversion to SQL Server 2005 has taken place. Have set the compatibility of the database to 90 Updates cause the above error.
Hi,I am getting this error: String was not recognized as a valid DateTime.I'm trying to insert data into a table from a gridview, where two of the dates can be empty strings.I have set 'allow null' in the SQL Server table for the two dates, added the culture in the web.config file, and even tried converting the values to DBNull.None of which have worked, and I am still getting the error.This is the code I am using: if (e.CommandName == "EmptyInsert") { if (Page.IsValid == true) { TextBox txtVisitDateIns = GridView2.Controls[0].Controls[0].FindControl("txtVisitDateIns") as TextBox; TextBox txtNextVisitDateIns = GridView2.Controls[0].Controls[0].FindControl("txtNextVisitDateIns") as TextBox; TextBox txtVisitedByIns = GridView2.Controls[0].Controls[0].FindControl("txtVisitedByIns") as TextBox; DropDownList ddlPriorityIns = GridView2.Controls[0].Controls[0].FindControl("ddlPriorityIns") as DropDownList; TextBox txtMailshotDateIns = GridView2.Controls[0].Controls[0].FindControl("txtMailshotDateIns") as TextBox;
if (txtNextVisitDateIns.Text == "") txtNextVisitDateIns.Text = DBNull.Value.ToString(); if (txtMailshotDateIns.Text == "") txtMailshotDateIns.Text = DBNull.Value.ToString();
SPVisitsBLL visits = new SPVisitsBLL(); visits.AddVisit(Convert.ToInt32(GridView1.SelectedValue.ToString()), Convert.ToDateTime(txtVisitDateIns.Text.ToString()), Convert.ToDateTime(txtNextVisitDateIns.Text.ToString()), txtVisitedByIns.Text.ToString(), Convert.ToInt32(ddlPriorityIns.SelectedValue.ToString()), Convert.ToDateTime(txtMailshotDateIns.Text.ToString())); GridView2.DataBind(); } } I haven't checked txtVisitDateIns to see if it is an empty string as this date is required.Can anyone help?Thanks
I am passing a string to my stored procedure call where I convert it to a DateTime. I have pasted the relevant code below. My trouble is that prior to execution of the stored procedure an error is thrown "String was not recognized as a valid DateTime". The error does not get thrown when I pass it a date, it only throws it when no date is provided. The page I am using is a form to do a search. The search can allow a date to be entered or left out. How do I catch an empty value in the c# for an invalid datetime and still send the variable to the stored procedure. //////////////////////////// C# Code /////////////////////////////////// Passing the Date to a stored Procedure SqlParameter bdpDateFrom = new SqlParameter("@datefrom", SqlDbType.DateTime);bdpDateFrom.Value = Convert.ToDateTime(thisbdpDateFrom);myCommand.Parameters.Add(bdpDateFrom); ///////////////////////// Stored Procedure Code //////////////////////////////////@datefrom datetimeIF ((@datefrom IS NOT NULL) AND (@datefrom <>' '))BEGIN SET @whereclause = @whereclause + ' AND T1.c330101invoicedate_dt >= ''' + convert(varchar,@datefrom) + ''''END Thank you!
I'm trying to build a trigger with next sql statements & variables. Seems like the only way is with an EXEC sp_executesql, but even this trivial example gives "Invalid object name 'inserted'." (the more fully coded trigger can be found at http://slos.com/sql.txt
CREATE TRIGGER [ti_contacts] ON [Contacts] FOR INSERT AS EXEC sp_executesql N'SELECT * from inserted'
how to format the last part of this query which comes from Access.:
SELECT Max(TITLOC.TitleLocID) AS MaxOfTitleLocID, TITLES.TitleID, TITLES.CustLName, TITLES.CustFName, TITLES.RecDT, TITLES.TitleID FROM (TITLES_WARNING_SENT_qry RIGHT JOIN TITLES ON TITLES_WARNING_SENT_qry.TitleID = TITLES.TitleID) INNER JOIN TITLOC ON TITLES.TitleID = TITLOC.TitleID WHERE TITLES_WARNING_SENT_qry.TitleID Is Null GROUP BY TITLES.CustLName, TITLES.CustFName, TITLES.RecDT, TITLES.TitleID, TITLES.TitleID HAVING (TITLES.RecDT<Date()-31)
I am getting: 'Date' is not a recognized built-in function name.
It is probably something simple but how would I go about converting this part "HAVING (TITLES.RecDT<Date()-31)" to something SQL Server is happy with?
I am trying to pull a report with average down time and I getting the error message "Msg 195, Level 15, State 10, Line 4 'AVG' is not a recognized built-in function name." when I try to run the below query. How can I rephrase the AVG(DateDiff) line to calculate this for me?
SELECT TT.PartNumber ,AVG (TT.TimeToRepair) as [Avg Time to Repair (Hours)] ,AVG(DateDiff (hour,TT.TimeDateReported,TT.DateClosed) as [Turnaround Time(Hours)]) FROM dbo.vt_TroubleTicket TT WHERE TT.Closed = '-1' and TT.DateClosed between '1/1/2013' and '1/1/2014' and (TT.PartNumber = '12345') GROUP BY TT.PartNumber
I get a 'Specified cast is invalid' error message when I use the following query statement which has a COUNT verb in it.
SELECT DATAFIELD COUNT(DATAFIELD) AS 'Count' FROM EETABLE BY DATAFIELD
I only get this error when running the query in my C# program which is using SQL SERVER 2005 under VISTA. If I manually submit a query in Microsoft SQL Server Management Studio I receive no error. Also, I get no error if I run this program on an XP computer using SQL SERVER 2000. So where do I look for the source of the problem. Any help is appreciated. Dave
I have a problem that many reports and folders were created with my administrative account. Due to some problems with AD my account was renamed MYDOMAINmyuser1. Everything has seemed to work fine for several months. Today I started getting an errors in the logs and subscriptions won't work.
w3wp!ui!1!3/25/2008-06:03:14:: e ERROR: System.Web.Services.Protocols.SoapException: The user or group name 'MYDOMAINmyuser' is not recognized. ---> Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'MYDOMAINmyuser' is not recognized. --- End of inner exception stack trace --- at Microsoft.ReportingServices.WebServer.ReportingService2005.SetSubscriptionProperties(String SubscriptionID, ExtensionSettings ExtensionSettings, String Description, String EventType, String MatchData, ParameterValue[] Parameters) w3wp!ui!1!3/25/2008-06:03:14:: e ERROR: HTTP status code --> 200 -------Details-------- System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: The user or group name 'MYDOMAINmyuser' is not recognized. ---> Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'MYDOMAINmyuser' is not recognized. --- End of inner exception stack trace --- at Microsoft.ReportingServices.WebServer.ReportingService2005.SetSubscriptionProperties(String SubscriptionID, ExtensionSettings ExtensionSettings, String Description, String EventType, String MatchData, ParameterValue[] Parameters)
at Microsoft.ReportingServices.UI.ReportingWebControl.ShowErrorMessage(Exception e)
at Microsoft.ReportingServices.UI.SubscriptionPropertiesPage.SaveButton_Click(Object sender, EventArgs args)
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) w3wp!ui!1!3/25/2008-06:03:14:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.End() at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm) at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.End() at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm) at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) w3wp!extensionfactory!1!3/25/2008-06:03:41:: w WARN: The extension Report Server Email does not have a LocalizedNameAttribute. w3wp!extensionfactory!1!3/25/2008-06:03:41:: w WARN: The extension Report Server FileShare does not have a LocalizedNameAttribute.
I've deleted and recreated the subscriptions and I am still get these error messages. Any help resolving this is really appreciated.
Error Output: -------------------------------------------------------------------------- my new db test Server: Msg 911, Level 16, State 1, Line 1 Could not locate entry in sysdatabases for database 'my'. No entry found with that name. Make sure that the name is entered correctly. -----------------------------------------------------------------------
Any idea how to get the entire database name to be used with spaces in the database name. It prints the @DatabaseName just fine, but in the dynamic sql, it truncates after the first space.
I already tried N'my new db test' in the set statement. That didn't work. I tried using NVARCHAR when declaring the variable.
why I am getting this error on the SQl Server 2005 but not getting it on the SQL Server Express? and how to ifx?
Code Snippet
Msg 195, Level 15, State 10, Procedure sp_check_sp, Line 14 'OBJECT_SCHEMA_NAME' is not a recognized built-in function name.
this is my code:
Code Snippet
USE shefa SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: <Author,,Name> -- Create date: <Create Date,,> -- Description: <Description,,> -- ============================================= ALTER PROCEDURE [dbo].[sp_check_sp] AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON;
SELECT DB_NAME(st.dbid) DBName , OBJECT_SCHEMA_NAME(st.objectid, dbid) SchemaName , OBJECT_NAME(st.objectid, dbid) StoredProcedure , MAX(cp.usecounts) Execution_count FROM sys.dm_exec_cached_plans cp CROSS APPLY sys.dm_exec_sql_text(cp.plan_handle) st WHERE DB_NAME(st.dbid) IS NOT NULL AND cp.objtype = 'proc' GROUP BY cp.plan_handle, DB_NAME(st.dbid), OBJECT_SCHEMA_NAME(objectid, st.dbid), OBJECT_NAME(objectid, st.dbid) ORDER BY MAX(cp.usecounts) END
