Server Properties (Permissions Page) Grayed Out
Jul 25, 2007
I am running SQL Server 2005 Workgroup Edition with Reporting Services and would like to assign a user on the system to be a System User in Reporting Services through SQL Server Management Studio so that they can run Report Builder but the window for the Reporting Services Server Properties Permissions Page has been grayed out so I cannot add new users to make this role assignment. I can add users and perform normal role (non system roles) assignments by right clicking on the folders underneath the Reporting Services Server with no problem.
Is it due to the edition of SQL Server that I am unable to do this?
Is there another way for a user to gain access to the Report Builder application using some other authentication process?
View 1 Replies
ADVERTISEMENT
Jun 10, 2007
In SSMSE, if I open Server Properties and then Permissions, I can highlight a user or user group and click the 'Effective Permissions' button.
For entries like 'BUILTINUsers' or 'BUILTINAdminsitrators' I get the following error message. I don't understand what it's telling me - can anyone explain?
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Cannot show requested dialog.
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
Cannot execute as the server principal because the principal "BUILTINUsers" does not exist, this type of principal cannot be impersonated, or you do not have permission. (Microsoft SQL Server, Error: 15406)
Notes: as fara as I know, BUILTINUsers does exist, and I do have permission.
View 1 Replies
View Related
Jan 12, 2007
Hi,
in one of our team projects users whom are members of the reporting services €œcontent manager€? role are not able to get onto the €œsql server€™s reporting services€? properties page of their team project. Instead of that page they receive the following error message:
The permissions granted to user '<UserName>' are insufficient for performing this operation. (rsAccessDenied)
With four eyes we double checked that the users really have the content manager role, we also tried all kinds of role combinations with no success.
The interesting thing is that as soon as they €˜only€™ in the Browser role they have access to that particular page €“ but as expected are unable to administer their team projects reporting services.
The reporting services forum doesn€™t really offer any answers to this problem, neither did goolge nor this forum.
Could anyone explain this behavior to me?
Pls let me know if you need additional information on this.
Thanks,
Tom
View 4 Replies
View Related
Mar 16, 2015
I have an ODBC connection string that is working fine with the following properties:
Database="XXXXXXX",Network="YYYYYY"; strangely no server is specified in the string, but it is specified in the ODBC Connection file.
I am trying to do a new server registration in SSMS for this database.However, I don't understand where the network spec is placed.
Under Registered server name I've tried:
YYYYYYXXXXX
When I browse the server for the database instance list, I receive "network path was not found".
I even tried:"XXXXXXX",Network="YYYYYY" for the registered server name.Same error message.
What am I doing wrong ?
View 1 Replies
View Related
Jan 22, 2007
Hi,
We have an issue with our replication configuration when viewed through replication monitor. Parameterised Filters and joined filters don't appear in the gui. However, when we script the publication all the filters are present.
This issue only seems to occur when we have a remote distributor.
I should also point out that we have a merge push topology that uses a custom RMO synchronisation component on a separate server to either the publisher or the distributor. Also all the databases in the topology are called the same name. This has caused us other issues relating to this topology in particular so I raise it here as well although I don't expect it to be the case in this instance.
Any help would be greatly appreciated in clarifying this matter.
View 1 Replies
View Related
Mar 4, 2008
In have installed SQL Server 2005 on server. My problem is, i cannot find Permissions Page on Server Properties Window. Its missing. I cannot grant permissions. Please help.
View 4 Replies
View Related
Aug 11, 2006
I have a mystery that I need a little help with. I am trying to install SQL Server 2005 Std Ed. into a two node failover cluster running on top of Windows Server 2003 Enterprise Ed.. I have the cluster up and running. It consists of an IP address, cluster name, a shared drive (E:), and an MSDTC resource. When I run the SQL Server 2005 setup, the failover cluster option is always grayed out. I have tried installing from the active node and from the cluster virtual server. The result is always the same, no option to install a failover cluster. Some suggestions would be appreciated. I have read all the online docs I could find related to SQL 2005 failover clusters and found no clue.
Thanks,
VARiflesmith
View 2 Replies
View Related
Dec 12, 2007
I am building a report with several search parameters; three of which are dropdown boxes each populated by a data set. I wanted something more user-friendly than the default "(Null)" in the dropdown, so for each data set, it returns a result set UNIONed with " N/A" to show up first as the default.
For some reason, when the report loads, the first dropdown populates just fine and does indeed have the default value " N/A" but the other two dropdowns are grayed-out. Until you change the first dropdown (to anything, apparently it doesn't matter what you change it to) the other two stay grayed-out. When the first is changed, the other two are populated and default to the desired " N/A" default value.
Why would it do this, when it didn't do it before; i.e. when the default for all of them was simply null. The dropdowns are not dependent on each other; they don't depend on other parameters for their values. Any help would be appreciated.
View 2 Replies
View Related
Aug 6, 2006
Every time I try to edit a Control flow or Data flow task I am getting the following error. My toolbox options are all grayed out also.
TITLE: Microsoft Visual Studio
------------------------------
The service System.Windows.Forms.Design.IUIService could not be located.
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.DataTransformationServices.Design.SR&EvtID=UnableToLocateService&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
Any help is appreciated
Gulden
View 4 Replies
View Related
Nov 10, 2015
I have a Tabular data model and I'm returning a measure that counts employees (each row is an employee) and then a calculated column in the model that gets SeniorityInMonths.
So if an employee was hired exactly 1 year ago, they would have 12 in this column.
I want to group these into bins, but the Group option is grayed out.
View 6 Replies
View Related
Mar 29, 2015
I am trying to learn building SSAS tabular model. While following a tutorial I need to add a column to an existing table but for some reason the ADD Column option (insert column in other menu is also not appearing) is greyed out.
View 4 Replies
View Related
Aug 2, 2007
I'm trying to connect to a SQL Server 2005 database engine on a local network server. When I am presented with the Connect to Server dialog box, if I select Windows Authentication from the Authentication drop-down, the User name & Password area is grayed out and unusable. The domain user account I'm authenticated with is visible, but grayed out, and the password field is blank and unusable. I'd like to be able to connect as described in help:
User name
Enter the user name to connect with. This option is only available if you have selected to connect using Windows Authentication.
I can connect with either SQL Server or Windows authentication... but with Windows Authentication I'd love to be able to type a specific user name to select with :-)
View 4 Replies
View Related
Sep 21, 2006
Hi, I wanted to know that can we access a webpagefrom a store procedure in sql server 2000 like we run a exe file from sql server. Bye.
View 1 Replies
View Related
Jun 17, 2015
I tried to open mdf file without any success. Then, all database files icon were changed or grayed out. How can i repair or replace the file to it's original file? ex... the file named "event.mdf" has now a wrong icon not a database icon like before.
View 11 Replies
View Related
Mar 12, 2015
I have a report with tablix. when tablix returns no rows Footer is coming all the way up . How to display the footer at the bottom of the page all time.
View 0 Replies
View Related
Nov 11, 2015
I have created one reports but all the records are displaying on one page.find a solution to display the records page by page. I created the same report without group so the records are displaying in page by page.
View 3 Replies
View Related
Oct 11, 2002
Hello!
We are having problems with a single SQL Server where the Server properties will not save, and always revert to the default.
It occurs only on those tabs with "configured" and "running" options at the bottom. Other tabs will keep the settings we custom.
The big problem is with the memory and processor tabs which even when we've made only a single change and stopped and started the service, reverts back to a default.
Any clues - we are logged in as "sa" and have not removed the SA priviledges.
Thanks for any help,
Simon
View 1 Replies
View Related
Dec 7, 2006
Help;Im New with a company and the sql server ismaxing out the cpu'sWe have 3 web servers load balanced....large volume of datathe current PropertiesComputer:4 amd 2.88 processors4 g MememoryRecomendations of good sql setupmemory, cpu etcThank youmike
View 6 Replies
View Related
Aug 17, 2006
Hi -
This is a newbie question. For some reason when I view the contents of tables I have created on my SQL Server (version 7) database, the sort buttons in the "Data in Table" window are grayed out.
Do I need more permissions? How do I fix this?
Thanks.
View 1 Replies
View Related
Mar 22, 2000
Is there no longer a graphic interface for the parameters that are output with sp_configure?
There are many options that are settable that are not in the Sql Server Propreties, but
these items were in the 6.5 graphic interface through EM ex. number of open objects.
Is there a script to save these settings so the installation can be recreated?
View 1 Replies
View Related
Jun 19, 2008
DECLARE@Stage TABLE
(
RowID INT IDENTITY(0, 1) PRIMARY KEY CLUSTERED,
Data VARCHAR(90),
Section INT
)
INSERT@Stage
(
Data
)
EXECxp_cmdshell 'ipconfig /all'
DECLARE@Section INT
SET@Section = 0
UPDATE@Stage
SET@Section = Section =CASE
WHEN ASCII(LEFT(Data, 1)) > 32 THEN @Section + 1
ELSE @Section
END
SELECTMAX(CASE WHEN x.minRowID IS NULL THEN NULL ELSE s.Data END) AS Header,
MAX(CASE WHEN s.Data LIKE '%Host Name%' THEN RTRIM(SUBSTRING(s.Data, 45, 90)) END) AS HostName,
MAX(CASE WHEN s.Data LIKE '%Media State%' THEN RTRIM(SUBSTRING(s.Data, 45, 90)) END) AS MediaState,
MAX(CASE WHEN s.Data LIKE '%Description%' THEN RTRIM(SUBSTRING(s.Data, 45, 90)) END) AS [Description],
MAX(CASE WHEN s.Data LIKE '%IP Address%' THEN RTRIM(SUBSTRING(s.Data, 45, 90)) END) AS IPaddress,
MAX(CASE WHEN s.Data LIKE '%Physical Address%' THEN RTRIM(SUBSTRING(s.Data, 45, 90)) END) AS PhysicalAddress
FROM@Stage AS s
LEFT JOIN(
SELECTMIN(RowID) AS minRowID
FROM@Stage
GROUP BYSection
) AS x ON x.minRowID = s.RowID
WHEREs.Section > 0
GROUP BYs.Section
E 12°55'05.25"
N 56°04'39.16"
View 2 Replies
View Related
Apr 3, 2007
I'm logged in as 'sa' and I'm using Microsoft Sql Server Mgmt Studio. I've established a Linked Server using Provider MSDASQL, and I'm able to retrieve data from the linked server. However, when I attempt to set the properties for my linked server, I get the following error message.
Adhoc updates to system catalogs are not allowed. (Microsoft SQL Server, Error: 259)
I'm not directly accessing the system catalogs (as far as I can tell), I'm actually using the Linked Server Properties user dialog to change the Server Options. Any help is appreciated.
View 3 Replies
View Related
Jan 9, 2005
Does anyone know how to display the properties of a column / data field in ASP? Thanks!
View 6 Replies
View Related
Jul 28, 2004
This problem concerns files FTP'd (using True64) from an AIX app, to an WIN server
These files can't be loaded into the SQL Server DB using BCP (String data, right truncation) nor into an ACCESS DB ("Overflow"), (but can be loaded into Excel).
If the file is opened and saved in a Windows/DOS environment it loads fine, or contents copied to an empty win/dos file.
If the same file is sent from to the Win server using DOS FTP then it loads fine.
It seems to be that these DBMS's don't like something about the operating system level file properties (hdr or EOF?).
Can any one help?
View 1 Replies
View Related
Aug 24, 2005
I am writing a program in .Net to retrieve properties of Sql Server.How can I find the following properties without querying the database:1. Replication enabled2. Default language3. Processors and threads running.Thanks,verve
View 3 Replies
View Related
Apr 27, 2006
Hi
I'm running SQL Server 2005 Express SP1 on a Danish PC, and I need to have the server language set to Danish.
However, when I want to change the language in server properties (the current language is English (US) using Management Studio Express, I can't - all of the properties on the General page are greyed out.
I know that the SQL Server Express SP1 download is available in several languages (Danish not being one of them) - does that mean that I can't get my SQL Server Express SP1 installation to "speak" Danish at all?
Please help - it's driving me up the wall.
View 4 Replies
View Related
Oct 20, 2006
Hello to everyone, I've a question about UDTs and the way I can use them to access tables and columns where they are applied in a SQL Server 2005 DB.
I've already spent 2 days googling and MSDN reading but nothing helped me to solve my problem, thats why I'm posting it here (this is the second post, maybe the last one was in the wrong Forum).
The scenario follows:
I've created a UDT called MyUDT that exposes 2 properties MyTable, MyColumn, here its the code:
[Serializable]
[SqlUserDefinedType(Format.UserDefined, IsByteOrdered = true, MaxByteSize = 8000, Name = "MyUDT")]
public class MyUDT : INullable, IBinarySerialize
{
private string _myTable;
private string _myColumn;
....
/// <summary>
/// Set or Get the Table Name where the UDT is applied.
/// </summary>
public string MyTable {
get { return this._myTable; }
set { this._myTable = value; }
}
/// <summary>
/// Set or Get the Table's Column Name where the UDT is applied.
/// </summary>
public string MyColumn
{
get { return this._myColumn; }
set { this._myColumn = value; }
}
....
}
And here it's my question/s:
How can I expose the defined Properties (MyTable, MyColumn) in order to be directly used from
SQL Server Management Studio within the Column Properties Panel?
Pls take a look to the print screen placed below:
[img=http://img81.imageshack.us/img81/7193/untitledip1.th.jpg]
If it is not possible, is there a way for any UDT to get back from the sql server execution context
the table and the column where it is applied/used?
I need to solve that in order to later retrieve via SQL the Extended Table Properties where the UDT is used
and make some work on presented MetaData. Thanks in advance, every answer/help will be very much appreciated.
View 10 Replies
View Related
Jan 9, 2007
Hi everyone,
Primary platform is 2005 under 64-bit.
I'm trying to figure out what does 'Processor Affinity' and 'I/O Affinity' means when you're viewing server properties. We've got eight processors.
Thanks for your comments,
View 4 Replies
View Related
Jul 13, 2005
Hi,
I have a MS SQL Server Express database wich I upsized once from MS
Access. I can connect to it and get/insert data but I can't update the
field properties.
I've used Access 2003, Visual Studio .Net and SQL Server Web Data
Administrator, but I can't change the properties of existing tables. I
cán add new tables and add their properties afterwards. Since I have a
lot of tables it would be too much work too recreate them all. So how
can I edit my existing tables?
View 1 Replies
View Related
Mar 30, 2001
Hi
We have two servers each running SQL7. I cannot run a trace on one server from the other. Whatever server name I enter in the drop down box, the trace only records activity on the server that profiler is running on. Even if I put a non-existent server name in the box (!), the trace accepts the name but still only runs on the host server.
Any explanations please.
Keith
View 2 Replies
View Related
Nov 29, 2004
I have looked on google and haven't found a query (as of yet) to perform this function.
Essentially I am using VB.NET with Excel and have a mapping between a worksheet and a table in my database. I wrote an import function to pull the data out of excel and put it into SQL Server but I want to try catching errors before i do that.
What is the SQL query to get column sizes from a table. Meaning in a table I have column1 that is allowed a size of int(5). How do i retrieve that information from a query opposed to just looking at it in SQL Server EM??
any help would be appreciated
thanks
View 5 Replies
View Related
May 21, 2008
Hi Folks,
In SQL 2005, the linked servers are not automatically enabled for RPC / RPC OUT like they were in SQL 2000. I have set the properties for my linked server by using SQL Management Studio.
I right click on the Linked Server --> Properties --> Server Options
There are options like: Collation Compatible, Data Access, RPC, RPC OUT, Use Remote Collation
There is a drop down box to set each value to TRUE or FALSE. Setting them through management studio works great, however for the production environment I need to set these properties programmatically. Is there a stored procedure or registry setting that would allow my program to set these values for a given linked server?
Thank you.
View 3 Replies
View Related
May 4, 2015
How to change the Security Properties of a Linked Server.
In tsql, I need to setup a linked server and want to set the Properties -> Security -> For a login not defined in the list above, connections will: -> Not be made But I cannot figure out how to set it to Not be made. I manually set it in the GUI, and the scripted the linked server and when I ran the script to create it was set to Be made using the login's current security context. The create script did not even set it correctly.
I have looked around and all that I have found is a column in sys.linked_logins, uses_self_credential that looks promising. But I cannot change the system catalog.
how i can set the "For a login not defined in the list above" security property in tsql?
View 4 Replies
View Related
