RS 2005 Initialize Greyed Out ???
Sep 13, 2006
HI There
I have installed Reportin Services 2005 , X64. I selected install but do not configure.
Afterwards i applied Service Pack 1 and ran all the hotfixes for sql components as per KB 918222.
The i launch the RS configuration manager i succesffuly setup Report Server/Manager Virtual DIrectory and servcie identity.
I then setup the database, i create a new database to the local 2005 instance i just installed with RS, the databse is created successfully.
Basically i have green ticks all the way, however Initialize is greyed out i cannot take the option to initialize the server ???
When i try to restart the RS service it says that the service failed to repond in a timely fashion, when i check the even log the servcie only started 10 minutes later, and there are no errors ?
WHen i go back to RS config manager , initialize is till greyed out , this is the last step i ahve to do but i cannot take the option ???
PLEASE HELP, Thanx
View 6 Replies
ADVERTISEMENT
Oct 2, 2006
I am looking to make the primary key auto increment by 1. I have found by looking around the internet that you need to do this in the Tables -> [Table Name] -> Columns -> [Column Name], Properties window, and I see the "Identity Increment" however all of the properties there are greyed out -- I can't access them. Any ideas on how to make this work?For some background: I'm running SQL Server 2005 with Visual Studio 2005. To create this database, I right-clicked on my project, and went to 'Add SQL Database', I filled in the columns all from within visual studio.
View 1 Replies
View Related
Nov 8, 2007
I have SSRS 2005 installed. User wants to change email address on subscription to send to external customer or others in our organization.
If I modify right "Manage individual subscriptions" to enabled for his security profile, the email address box is greyed-out.
I tried changing value <SendEmailToUserAlias>xxxx</ SendEmailToUserAlias> to FALSE in rsreportserver.config, with SSRS restart, but address box is greyed-out.
If I modify right "Manage all subscriptions" enabled for his security profile, the address box is not greyed-out, but can now see-edit everyone's subscriptions for that report.
How can I turn on address box is not greyed-out, but not open view of ALL subscriptions to my users?
View 5 Replies
View Related
Mar 8, 2004
I want to use the debugger on my workstation which has also got SQL Server Dev installed . buyt the debugger is greyed out when I check it from Query analyzer window ?
How do I make it to use
thanks
View 2 Replies
View Related
Sep 5, 2006
I know there's a trick to this, that I can't figure out.
Have an SSIS package that I developed and deployed/saved(?) to a file on the SSIS server. Now I need to change the data flows. Did that, no issues, lets me resave the file, but I can't debug or execute the package so I can test what I did is right? Why is the debug drop down box greyed out? There's gotta be something I'm missing here.
THanks,
Lezza
View 8 Replies
View Related
Jan 27, 2007
Hello I am working on a sql express table and while configuring the steps after I select the data source and the selectment statement window shows, I want to use the advanced tab but it is greyed out. I want to be able to add edit and delete my data. I have administrator rights for this project and the workstation so thats not the issue. What I am tryng to accomplish is extending a website to manage it's content and users. Also the table has colums and the colums has test data within them I tested a query and the connection had a successful return. Maybe it's a configuration thing I am unaware of.
DKB
View 3 Replies
View Related
Feb 27, 2004
I'm trying to detach a database and reattach to another server. When trying to detach it using Enterprise Manager, the command is greyed out. I've tried taking the database offline first but the command is still not enabled. I'm logged in as sysadmin. What gives?
View 7 Replies
View Related
Jul 23, 2005
If I open Enterprise Manager through a saved MSC file, the Tools > SQLQuery Analyzer option is greyed out (unavailable). If I open EnterpriseManager from the Programs menu, Query Analyzer is available. Is theresomething specific I need to do with msc?I created an MSC file and added the Enterprise Manager snap-in.
View 3 Replies
View Related
May 1, 2008
Hello,
I have installed all the required installations for SQl Server CE, however when I open SQL Management Studio, the server type option is greyed out and I do not have the option to select SQL CE server type.
I have installed SQl Management Studio Express edition (if that helps.).
Please suggest.
Regards,
Arjun
View 5 Replies
View Related
May 13, 2007
Hi Guys,
Why is that some of the databases has their "Transaction Log" & "File and Filegroup" options in Backup greyed out? I was trying to create a backup job using the sql enterprise backup wizard. However, the database that is the backend of our erp application has its "Transaction Log" and "File and Filegroup" option greyed out.
Any idea why?
sk
View 4 Replies
View Related
Sep 11, 2000
I would like to enter info into the startup service account so that the MS
SQL Server Agent will run under this account. Then I can run jobs.
However, I don't know why the "startup service account" info is
greyed out, which prevents me from entering this information.
Any help would be appreciated!!
View 2 Replies
View Related
Aug 15, 2007
Hello All,
I have a workstation that had an installation of SQL 2K5 that a tech set up for me. Naturally, it was the wrong edition AND no components were actually installed, making my laptop into a paperweight. I advised that we get SQL Developer for the DBA's and I am trying to install but the option for Reporting Services is greyed out.
I have uninstalled SQL (I think it was Standard) and I even went through the "complete uninstall" detailed in one of these threads thinking that was the problem. I am still unable to install Reporting Services.
Has anyone run into this problem?
PLEASE HELP!
thanks!
View 10 Replies
View Related
Jul 15, 2007
Hi,
I'm trying to install SQL Server 2005 onto my XP Professional PC. When I get to the "Components to install" part, the "SQL server database services option" is greyed out. Infact, all options except "Workstation components..." are greyed out. I've tried uninstalling all previous versions of SQL server and trying again, but with the same results.
any help would be much appreciated
Simon
View 5 Replies
View Related
Sep 26, 2007
Hi all,
I'm working on a new SSRS implementation, and have created a Report Model against an SSAS database. I launced Report Builder and can see and select the model in the list, but the OK button at the bottom of the pane is greyed out so I'm unable to actually start building a report against it. Any ideas on what I need to change to make the button work? I have already verified that I have full access to the data source as well as the model, in addition to the underlying SSAS DB, so I don't believe it is a permissions issue... But I'm certainly open to any suggestions.
Thanks!
View 3 Replies
View Related
Jan 30, 2008
I have added several SqlDataSource controls to my C# project, but when I try to configure them, there seems to be a lot of greyed out buttons. Either the WHERE, ORDER BY, and ADVANCED buttons are greyed out, or when they are active, the ADVANCED button always displays the advabced options which are always greyed out. I doesn't make any sense to me. Please explain (in baby language please)
View 4 Replies
View Related
Jul 12, 2006
Having problems connecting to SQL Server Express using 'sa' account and having read threds re problem and MS, advice is that Authenticaion mode needs to be set to both Windows and SQL. I have studio express installed and go to Security from the properties of the Server to change this option to use both authentication modes, however the options are greyed out!
Can anyone advise pse.
And will amending this option help me to enable the sa login which is refused at the moment, error as follows:
Login failed for user 'sa'.The user is not associated with a trusted SQL Server connection
Thank you in advance
View 4 Replies
View Related
Mar 9, 2007
I've got a report with several cascading parameters. When I preview the report, everything works fine. However, when I deploy the report, the very first (and thus the rest) of the cascading parameters is greyed out. Any idea what's going on?
I am passing one unrelated parameter into this report, and I also have three non-cascading parameters before this one, but none of them are used in the queries for the cascading parameters. They also appear correctly at the top of the report.
This is rather frustrating since the preview works fine -- making it pretty difficult to debug the issue!
View 3 Replies
View Related
Feb 22, 2004
Hi All,
Great forum y'all have going here.
Just wondering if anyone else has experienced this?
Enterprise Manager:
I have setup and 'sucessfully tested a MAPI session' with a mail profile via support services > sql mail. That works fine, however in sql server agent properties the mail session section on the first general tab appears to be greyed out.
scenario is:
Windows Server 2003 SBS edition
SQL Server 2000 SP3
Exchange Server 2003 is also running on the server, with Outlook 2003 client (so i suspect side chaining issue).
Any help appreciated! did not have any luck googling or using microsoft KB.
View 12 Replies
View Related
Apr 22, 2014
I am looking at the file / filegroup level backup and recovery options within SQL Server and I'm struggling with the following concept.
Books online assures me that it is possible to perform a file restore whilst the database is in the simple recovery model.
So I have set up a database with two separate file groups, a read/write primary and a read only "secondary". Each filegroup has 2 underlying data files.
I have then created a "live" customers tables within the primary filegroup and assigned my existing "archive" customers tables within the secondary filegroup.
If I try to perform a file or filegroup level backup within management studio, those options are greyed out. I can only perform a database backup.
If I switch back to the full recovery model, the options are no longer greyed out.
So my question is this, is file level backup and recovery actually supported in the simple user model, do you have to perform this task outside of management studio, or (as is likely) am I missing something crucial?
View 3 Replies
View Related
Jun 12, 2008
Hi.
My company has upgraded some of the database systems to SQL 2005 while other have a fresh install.
The problem we're seeing is that the view button located in the Advanced section of the steps in the Job properties windows is greyed out. The path is valid as we can copy the path and paste it at the run command and view the log.
Does anyone know how this problem can be resolved? If we select to log the results to a table; we have access to the corresponding view button but not the one for the file system logging.
We rely heavily on this feature since we used it often under SQL 2K. Can anyone provide any helpful details to resolve this or has anyone seen this problem before???
Any helpful replies would be highly appreciated.
Thanks!
View 6 Replies
View Related
Oct 25, 2006
While configuring a TableAdapter I noticed that the option "Create methods to send updates directly to the database (GenerateDBDirectMethods)" is greyed out.Can a TableAdapter only have one table in order to create the methods for sending the updates directly to the database?If so, what is the work-around?The TableAdapter that I am trying to create uses the following statement to fill its DataTable:SELECT Client.Name, Users.FirstName, Users.LastNameFROM Users INNER JOIN Client ON Users.ClientId = Client.IdThanks for your response in advance!
View 2 Replies
View Related
Jul 26, 2007
This is driving me a little nuts, I have been testing locally with SQL Server Express 2005 and this has not been a problem, however now that I have restored the databases to SQL Server 2005 (not express) When I go into SQL Server Management Studio open a table the option for changing a query type is greyed out has anyone seen this or have any ideas how I can get this working.
Thanks,
Terry
View 3 Replies
View Related
Jan 15, 2005
how do I move my database schema from 1 machine to another? Its a MSDE 2000 DB and Im using visual studio 2003.
In VS when I goto the server explorer and right click on a DB the "generate create script" options is greyed out.
What am I doing wrong?
If you cant help me with the above question could you please recommend another way for me to get my DB schema with all its constraints from one of my work stations to another. I dont want to manually recreate it.
Thankyou
View 3 Replies
View Related
Jan 14, 2005
In the server explorer "generate create script" is greyed out, what am I doing wrong?
I want to generate a script that will re-create my DB schema on another machine.
Any help would be appreciated.
Thanks
View 3 Replies
View Related
Oct 17, 2008
Have installed SQL 2008 on Windows 2008 and have come across a strange issue.
When connecting to the Report Server cvia SSMS to enable "My Reports" (for example) the Report Server Properties are greyed out and we cannot alter them. This occurs when logged on both locally & remotely to the Win 2008 server.
Interestingly, we have another (XP Pro) box with SQL 2008 on it. If we connect to the Win 2008 SQL report server from the XP machine's SSMS, then we have full control and can access and change the report server properties on the Win 2008 server.
The relevant domain accounts are in the Admin group on the Win 2008 server and the XP Server so we are confused as to why we cannot edit the Win 2008 report server properties locally.
View 5 Replies
View Related
Jan 16, 2015
In Domain Management, when I click on the Import values button... "Import Valid values from Excel" is greyed out and unavailable.
View 0 Replies
View Related
Feb 19, 2008
When i try to open Sql Server Enterpris Manager the following error msg appers
Snap-in Failed to initialize
Name- unknown
CLSID{--}
how to solve this pbm help me very urgent
View 3 Replies
View Related
Feb 3, 2004
i am using a control that i downloaded from the control gallery It has a line for a connection string.
which i put on in there: data source=server;initial catalog=database;user id=blahblah;password=557896 and i get an error:
Exception Details: System.InvalidOperationException: The ConnectionString property has not been initialized.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[InvalidOperationException: The ConnectionString property has not been initialized.]
System.Data.SqlClient.SqlConnection.Open() +433
Microsoft.Vote.VoteButtonClick(Object sender, EventArgs e) +289
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1277
How would i initialize the connection string.
any help would be appreciated
alucke
View 1 Replies
View Related
Sep 16, 2004
I am getting this problem when I try to open a DTS package.
MMC: Snap-in Failed to Initialize: Name: Meta Data Services:
CLSID(xxxxxxxxxxx)
Have anyone encountered this problem?
Lystra
View 4 Replies
View Related
Jun 9, 2008
I have problem with sql server configuration tool. it can not be opened
View 3 Replies
View Related
Jun 2, 2006
Hence you have a database which huge tables and a transactional replication (push subscriptions).
Now my question:
1. if I have to initialize a snapshot but I would like to do it without the snapshot agent, what methods are available?
2. Usually the distribution agent will request an initialize snapshot. How can I tell him, that I would like to use an alternative method and that the distribution agent should NOT request a snapshot?
3. Any suggestions about a good practive for materializing huge and big tables wihtout using the disitrbution agent (e.g. "switch off" replication, bcp table out of the primary site and bcp it into the target site, "start" distribution agent so that it doesn't request a snapshot).
Regards
Nobsay
View 6 Replies
View Related
Nov 27, 2006
I have a DTS package that is running under SQL 2005 (64-bit Itanium). It has a data driven query in it and I receive the following error:
ActiveX Scripting Transform 'DTSTransformation__1' was not able to initialize the script execution engine
I don't want to have to re-register any DLLs if I don't have to. Shouldn't this work out of the box?
Any ideas?
View 2 Replies
View Related
Feb 18, 2008
I have just completed a fresh install of SSRS 2005. Now, when I try to initialize it, it fails. I then try to delete any encrypted content and get the following error:
Code Snippet
ReportServicesConfigUI.WMIProvider.WMIProviderException: The encrypted value for the "LogonCred" configuration setting cannot be decrypted. (rsFailedToDecryptConfigInformation)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.DeleteEncryptedInformation()
From what I know, Reporting Services has never been installed on the machine in question. And if so, then haow can I get around this encrypted key issue?
Thanks!
View 6 Replies
View Related
