Windows Firewall Port Needed For Reporting Services 2005

Jan 4, 2007

Leon writes "I am trying to connect to a W2K3 Server's 2005 Reporting Server through my laptop's (WXP Pro SP2) SQL Server Management Studio.

I turned Port 1433 on in the server's Windows Firewall and was able to connect to the server's database engine from my laptop, but I have to turn Windows Firewall on the server off completely to be able to connect to the Reporting Server.

I have tried all the ports listed for SQL Server in the Microsoft documentation (TCP and UDP), but they seem to have no effect.

Can anyone tell me which port or ports I need to turn on in the server's firewall so that I can access Reporting Services through my laptop's SSMS?

Thanks in advance.

LGR"

View 1 Replies


ADVERTISEMENT

Help Needed !!!! The Colors Used By A Bar Chart In SQL Server 2005 Reporting Services.

May 3, 2007

I have created a linked report in which I have two screen:
First Screen: Clicking on the bar of particular country the details of that particular country should be visible (the second screen)

Second Screen: When I clicked on a bar. All the count values are very well correct. In first chart Count of values under one bar "Pending decision"(yellow) was 337 for a country and in second screen its 337 again(shown in light green bar).
<!--[if !vml]--><!--[endif]-->
Problem: My problem is to make it sure that the colors that the first screen is having for particular status (as shown in the legend) should remain same in second screen also. For example for a status say "pending decision" the chart is using yellow color, so in screen two as well it must be shown with yellow color and not with lany other color. Can anyone help me in this context. Is there any way to customize colors used by bar chart. Please note that the question is not about using appropriate color scheme(palette) the question is how to "capture/ Re-use/ customize/ pass as a parameter" the colors used by a bar chart in SQL Server 2005 Reporting Services.

View 1 Replies View Related

SQL Server 2005 Reporting Services On Windows Vista

Jun 13, 2006

Hello out there!

I've tried to install all features in the SQL Server 2005 to run on Windows Vista. The Reporting Services failed to install. I think it is because of the IIS 7.0 that 's not recognised by SQL Server.

Is there anyone who have had the same problem and is there anyone who have a suggestion to solve this problem?

View 5 Replies View Related

Windows Server 2008 And SQL Reporting Services 2005

Feb 4, 2008

Quick question; is SQL Reporting Services 2005 fully compatible with Windows Server 2008 / IIS 7 that RTM'd today?

View 1 Replies View Related

Reporting Services 2005 On Windows 2000 Server

Mar 19, 2007

Hi,

I successfully got SQL 2005 Express with reporting services running under VISTA. Developed some reports in the VISTA environment. However, my target system is a Windows 2000 server. We installed SQL 2005 w/reporting services onto the Windows 2000 server. SQL2005 Database is up and running. Reporting Services are running, IIS RRS virtual directories are built, RRS databases are built. I can do everything except deploy reports from Business Intelligent Studio. I can preview reports, just cannot deploy. The Reporting Services indicate 1 failure in its configuration; the Web Service Identity. It is loaded with <server>ASPNET. I cannot get rid of this error. I assume this is the problem. After digging around I found that Windows 2000 does not have an ASPNET user, it uses the IWAM user instead. Reporting services did not run at all till I changed the rs config file and put the IWAM user in as <WebServiceAccount>.

Does anyone have Reporting services 2005 running on Windows 2000 server? Anyone know how to fix the Web Service Identity error I am getting?

Thanks

View 8 Replies View Related

SQL Server 2005 Express &&amp; Windows Reporting Services

Feb 28, 2006

Hi,

I've just installed SQL Server Express 2005 on our shiny new Windows Server 2003 R x64 server. It has an Intel 830 D chip that uses x86 and 64EMT.

Problem is that I get the message "64-bit ASP.Net is Registered. Required 32-bit ASP.Net to install Microsoft Reporting Services 2005(32-bit)."

Is there any way that I can remedy this?

Thanks in advance

Robert



View 6 Replies View Related

SQL 2012 :: SSIS Firewall Port

Aug 5, 2015

We have SSIS packages deployed and scheduled on SQL_Server_A. The packages have to access databases on SQL_Server_B, which is behind a firewall.

Question: would opening only SQL port between these two servers be enough or some other ports have to be open as well? (The packages only select and bring data back to Server_A or transfer data from Server_A to the databases and do inserts. Nothing else.)

View 1 Replies View Related

Firewall Port Forwarding To SQL Server

Apr 25, 2008

Hi,

Is there any concerns or problems with forward a port to SQL server
from our internet firewall so that you can access the databases over the internet? Is it a standard practice to do this in order to remotely access the SQL server. Or is there a better way to do this? Also, if it is ok to do this are any things you need to do to enhance your security from vulnerabilities being open to the internet.

Any suggestions or comments would be appreciated on this subject.

Thanks

View 2 Replies View Related

Trying To Configure Reporting Services SQL 2005 On Windows 2008 Server With IIS7

Apr 21, 2008

Hi,
I have a Windows 2008 server 64-bit SP1 and I have installed SQL 2005 SP2 Enterprise Edition 64-bit. My current version is 9.00.3042.00. I am trying to configure Reporting Services and I am having lots of trouble getting the Application Pools to work properly. I have followed the Microsoft Technet paper 839480 "How to Install and Configure Reporting Services on Windows Server 2008". In the "Configure Reporting Services" part, I have successfully configured everything (all arrows are green) and have the following setup:

Report Server Virtual dir: ReportServer Default Web Site
Report Manager Virtual dir: Reports Defualt Web Site
Windows Service Identity: ReportServer with a service acct login
Web Service Identity:
Report Server: ReportServer,
Report Manager: DefaultAppPool (I get an error when I try to configure it to anything else: ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 800708AC at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String applicationPool)

The one thing I notice in the SQL Server configuration manager is that there is a red dot next to the SQL Reporting Services services even though the green arrow is there to show it is running.

When I look in IIS7, I see the application pools Reports and ReportServer and they are both in Integrated mode. When I try to go to http://localhost/reportserver, it gives an error. It will work if I change both application pools to classic. But then when I try to go to http://localhost/reports, I get an error:

"REQUEST IS NOT AVAILABLE IN THIS CONTEXT".

I have read up on IIS7 and it says that:
"This error is due to a design change in the IIS7 Integrated pipeline that makes the request context unavailable in Application_Start event. When using the Classic mode (the only mode when running on previous versions of IIS), the request context used to be available, even though the Application_Start event has always been intended as a global and request-agnostic event in the application lifetime."

So, how do I configure these application pools to work using IIS7 with SQL 2005 Reporting Services on a Windows 2008 server? I have tried all kinds of different things based on what I am reading on the net and nothing is working. Anybody have any suggestions?

Thanks!
Isabelle

View 3 Replies View Related

How Do I Configure SQL Server 2005 Reporting Services To Deliver Subscription E-mails To Addresses External To My Windows Domain

Jun 10, 2007

Can anyone help me with a problem I have with SSRS 2005? How do I configure SQL Server 2005 Reporting Services to deliver subscription e-mails to addresses external to my windows domain?

I've been having trouble configuring the Report Server e-mail delivery component to send subscription e-mails to addresses outside the domain on which the report server is hosted.

For e.g. since my local windows domain is named "smartsystems.com", I have found that the Report Manager does not have any problems sending subscription mails to "eawagu@smartsystems.com" but throws up an error whenever I include "eawagu@yahoo.com" in the recipients' list.

Any insights?

View 1 Replies View Related

SQL Server Reporting Services 2005 Service Would Not Start On Windows Server 2003

Dec 13, 2007

SQL Server Reporting Services 2005 Service would not Start on windows server 2003. Working great till yesterday and no changes were made to config file.

Here is the error in Event log


Event Type: Error
Event Source: SQL Server Report Service
Event Category: None
Event ID: 0
Date: 12/13/2007
Time: 8:25:59 AM
User: N/A
Computer: XXXXXXXXXXX
Description:
Service cannot be started. Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information.
at Microsoft.ReportingServices.Library.ServiceAppDomainController.Start(Boolean firstTime)
at Microsoft.ReportingServices.NTService.ReportService.OnStart(String[] args)
at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.


Here is i found in log files
ReportingServicesService!resourceutilities!4!12/13/2007-08:25:59:: i INFO: Running on 0 physical processors, 1 logical processors
ReportingServicesService!servicecontroller!4!12/13/2007-08:25:59:: e ERROR: Exception caught loading and setting code permissions policy level: System.Security.XmlSyntaxException: Invalid syntax on line 158.
at System.Security.Util.Parser.GetRequiredSizes(TokenizerStream stream, Int32& index)
at System.Security.Util.Parser.ParseContents()
at System.Security.Util.Parser..ctor(Tokenizer t)
at System.Security.SecurityManager.LoadPolicyLevelFromStringHelper(String str, String path, PolicyLevelType type)
at System.Security.SecurityManager.LoadPolicyLevelFromString(String str, PolicyLevelType type)
at Microsoft.ReportingServices.Library.ServiceController.SetAppDomainPolicy()
ReportingServicesService!servicecontroller!4!12/13/2007-08:25:59:: e ERROR: Error Starting Service: System.Security.XmlSyntaxException: Invalid syntax on line 158.
at System.Security.Util.Parser.GetRequiredSizes(TokenizerStream stream, Int32& index)
at System.Security.Util.Parser.ParseContents()
at System.Security.Util.Parser..ctor(Tokenizer t)
at System.Security.SecurityManager.LoadPolicyLevelFromStringHelper(String str, String path, PolicyLevelType type)
at System.Security.SecurityManager.LoadPolicyLevelFromString(String str, PolicyLevelType type)
at Microsoft.ReportingServices.Library.ServiceController.SetAppDomainPolicy()
at Microsoft.ReportingServices.Library.ServiceController.StartService(Boolean firstStart)

View 1 Replies View Related

Windows Server 2008 Enterprise &&amp; SQL Server 2005 Reporting Services

Mar 12, 2008



Does anyone know how to properly install SQL server 2005 express reporting services on windows server 2008. When ever i try to access the report manager I get an error "Cannot access the remote server" even though the report server is on the local machine. I only have the web server role installed on the server. Im still quite a newbie at managing servers so please keep it as simple as possible.
Thanks
Matthew

View 2 Replies View Related

How Can I Port Driver And OAL Code Of Windows CE 5.0 To Windows CE 4.2

Jul 12, 2006

How can I Port Driver and OAL code of Windows CE 5.0 to Windows CE 4.2?

If anybody have idea about this, kindly give me suggestions.

View 1 Replies View Related

SQL Server Reporting Services Help Needed!

Mar 14, 2007

Hi Gurus
Currently we are using SQL Server Reporting Services on top of our client data warehouse. Almost all the reports deployed on the report production server are executing Stored Procedures (behind the scene).
Can anyone tell me how can I query Report Server database to get a list of reports and the stored procedures being executed by these reports?

Early Thanks,
Salman Shehbaz.
Database Administrator
Xavor Corp.
92-321-440-0797

View 1 Replies View Related

SQL Server Reporting Services Help Needed!

Mar 14, 2007

Hi ALL
Currently we are using SQL Server Reporting Services on top of our client data warehouse. Almost all the reports deployed on the report production server are executing Stored Procedures (behind the scene).
Can anyone tell me how can I query Report Server database to get a list of reports and the stored procedures being executed by these reports?
Early Thanks,
Salman Shehbaz.
Database Administrator
Xavor Corp.
92-321-440-0797

View 5 Replies View Related

Query Help Needed For Reporting Services

May 13, 2008

I have a process that stores a machine status every 2 minutes in a bit field of an SQL database. Running = True, Stopped = False. I am trying to build a report that shows the percent run time every hour. This information would be the count of Trues divided by the total count for each hour. I can select and group the data on the hour but I can either count() the total number of readings or count() the number of readings where the status is true. How do I collect both pieces of information in the same data collection?

SELECT TOP (100)
Max(Time) As Time_M,
Count(Running) As Count_T
FROM Compact10
Group by DatePart(mm,Time), DatePart(dd,Time), DatePart(hh,time)
Order by DatePart(mm,Time) desc, DatePart(dd,Time) desc, DatePart(hh,time) desc

View 3 Replies View Related

SQL Express Install And Windows Firewall

Apr 22, 2008

I am trying to install SQl express as part of a custom app.I have been able to use the template.ini to pass in all the parameters and install. installs fine,however the installation isnt browseable by remote machines due to the sqlserver.exe and sqlbrowser.exe not being in the windows firewall list. How can i add then to this list automatically at install time? or is there another way around this?

View 1 Replies View Related

Remote Access And Windows Firewall

Sep 20, 2006

Hi all,

I have a Windows Server 2003 with SQL Server 2005.
I´ve configured the following itens to allow remote connecitions:

[code]
WORKAROUND
Warning If you use Registry Editor incorrectly, you may cause
serious problems that may require
you to reinstall your operating system. Microsoft cannot
guarantee that you can solve problems that result from using
Registry Editor incorrectly. Use Registry Editor at your own
risk.To work around this problem, follow these steps on the
computer that Windows XP SP2 is installed on:

1. Make sure that the Log On As account for the MSDTC service
is the Network Service account. To do this, follow these steps:
a. Click Start, and then click Run.
b. In the Run dialog box, type Services.msc, and then click OK.
c. In the Services window, locate the Distributed Transaction
Coordinator service under Name in the right pane.
d. Under the Log On As column, see whether the Log On As
account is Network Service or Local System.

If the Log On As account is Network Service, go to step 2.
If the Log On As account is Local System, continue with these steps.
e. Click Start, and then click Run.
f. In the Run dialog box, type cmd, and then click OK.
g. At the command prompt, type Net stop msdtc to stop the MSDTC service.
h. At the command prompt, type Msdtc €“uninstall to remove MSDTC.
i. At the command prompt, type regedit to open Registry Editor.
j. In Registry Editor, locate, and then delete the following subkey:
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSDTC
k. Close Registry Editor.
l. At the command prompt, type Msdtc €“install to install MSDTC.
m. At the command prompt, type Net start msdtc to start
the MSDTC service.

Note The Log On As account for the MSDTC service is set
to the Network Service account.

2. To allow the network transaction, you must enable
MSDTC. To do this, follow these steps:
a. Click Start, and then click Run.
b. In the Run dialog box, type dcomcnfg.exe, and then click OK.
c. In the Component Services window, expand Component
Services, expand Computers, and then expand My Computer.
d. Right-click My Computer, and then click Properties.
e. In the My Computer Properties dialog box, click
Security Configuration on the MSDTC tab.
f. In the Security Configuration dialog box, click to
select the Network DTC Access check box.
g. To allow the distributed transaction to run on this
computer from a remote computer, click to select the Allow Inbound check box.
h. To allow the distributed transaction to run on a
remote computer from this computer, click to select the Allow
Outbound check box.
i. Under the Transaction Manager Communication
group, click to select the No Authentication Required option.
j. In the Security Configuration dialog box, click OK.
k. In the My Computer Properties dialog box, click OK.


3. Configure Windows Firewall to include the MSDTC
program and to include port 135 as an exception. To do this,
follow these steps:

a. Click Start, and then click Run.
b. In the Run dialog box, type Firewall.cpl, and then click OK.
c. In Control Panel, double-click Windows Firewall.
d. In the Windows Firewall dialog box, click Add
Program on the Exceptions tab.
e. In the Add a Program dialog box, click Browse,
and then locate the Msdtc.exe file. By default, the
file is stored in the Installation drive:WindowsSystem32 folder.
f. In the Add a Program dialog box, click OK.
g. In the Windows Firewall dialog box, click to select
the msdtc option in the Programs and Services list.
h. Click Add Port on the Exceptions tab.
i. In the Add a Port dialog box, type 135 in the Port
number text box, and then click to select the TCP option.
j. In the Add a Port dialog box, type a name for the
exception in the Name text box, and then click OK.
k. In the Windows Firewall dialog box, select the name
that you used for the exception in step j in the
Programs and Services list, and then click OK.
[/code]

But, when the Windows firewal on the server is "On", remote connections
are not allowed, despite I´ve configured the Exceptions on the firewall.

Is there another task to solve this problem?

thanx!!!!

View 1 Replies View Related

When Windows Firewall Is ON, SQL Server Does Not Get Connected Thru TCP

Jul 27, 2006

I am using SQL Server 2005 Express + SP1 on a Windows Small Business Server(SBS) box. The SBS is connected to a client thru LAN.

Following are what I gave as IP address and DNS on the server:

IP: 192.168.16.2, subnet mask : 255.255.255.0, Preferred DNS server: 192.168.16.2, Default gateway and Alternate DNS Server blank

On the client, I have,

IP: 192.168.16.4, subnet mask : 255.255.255.0, Preferred DNS server, Default gateway and Alternate DNS Server blank

I can ping and connect to either of the machines.

If I do a sqlcmd -S "tcp:servernameINSTANCE,port", I get the following error message:
HResult 0x80090304, Level 16, State 1
SQL Network Interfaces: The Local Security Authority cannot be contacted

Sqlcmd: Error: Microsoft SQL Native Client : Cannot generate SSPI context

If I do a sqlcmd -S "tcp:192.168.16.2INSTANCE,port", it connects to SQL Server.

I have the Windows Firewall ON. If I Off the firewall, I do not have any problem at all.

I included File and Printer Sharing, sqlsvr.exe in the Exception list of the Windows Firewall.

Any help to solve the issue is appreciated.

Thanks.

View 7 Replies View Related

Windows Server 2008 - Firewall

Apr 18, 2008



Hello,

I have purchased 4 new boxes for SQL2005 and my var database product all running on the new Windows 2008 server. A lot of silly mind bender issues but I am up and live now. However, what should the firewall settings be on my SQL database box? I have ultimately turned off Windows Firewall so that I could connect and continue forward.

Thanks!

Chris

View 9 Replies View Related

Configure SQL Server Express With Windows Firewall

Jun 7, 2006

I have changed SQL Server port to 2433, and add it to exception in Windows Firewall, add executive files as in this KB http://msdn2.microsoft.com/en-us/library/ms175043.aspx

Want to change port of SQL Server Browser as well, but dont know how to :(

anyway, after enable Firewall, SQL server is stop working. How to get it working with Firewall? Also, if some one lets me know how to change port of SQL Server Browser too, it would be great

thanks

View 3 Replies View Related

Reporting Services :: Parameters Needed For Connection And Again At Report Run-time

May 5, 2015

In VS2008 SSRS, when creating a dataset, only the name of the stored procedure was required.  When populating the dataset, VS prompted for the parameters, whether or not there were any.  In VS2010, the name of the stored procedure is not enough if there are parameters.When creating a dataset in Visual Studio 2010 for databases and stored procedures in SQL 2012, I must provide (what should be) run-time parameters to obtain a field list and then to preview the report. 

So the embedded dataset looks like this (wherein the only parameter is a password): exec dbo.spu_procedure1 @PW='999'.This works well and as expected during report design and development.  But 999 must be provided at run-time by the requester, and not in the dataset definition.  If I remove the parameter in the dataset's exec string before deploying the report, the field list is cleared and the report is unusable. So I cannot overcome what seems a contradiction: necessary to obtain a field list, but "yet-to-be-provided" when the user selects the report.

By keeping @PW='999' in the dataset specification, the user cannot override the parameter and automatically has a password to view the report.  

View 3 Replies View Related

Migrate From 32bit 2000 Reporting Services To 2005 64bit Reporting Services

Mar 22, 2008



Hello,

I am trying to migrate my reports from SQL server 2000 reporting services 32bit to 2005 64bit. I am following the migration steps that MS specified.
Restored my Reportserver and ReportserverTempDB databases
Then I was using the configure Report services to upgrade these databases but I always end up getting the follwoing exception when I run the upgrade on the "Database Setup" configuration for 'ReportServerTempDB' database
System.Data.SqlClient.SqlException: Could not locate entry in sysdatabases for database 'ReportServerTempDBTempDB'. No entry found with that name. Make sure that the name is entered correctly.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(String connectionString, String script)
at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String connectionString, String script)

It's driving me crazy, why is it looking for 'ReportServerTempDBTempDB' in the catalog instead of 'ReportServerTempDB'?
Is it possible to migrate from 32bit to 64bit?

Any help is appreciated

View 1 Replies View Related

SQL Security :: Windows Server Firewall Not Blocking SSMS Access From All IPs

Nov 6, 2015

We have a hosted server with a website and sql server 2008 on.

The windows firewall is turned on for all networks / profiles and says its blocking incoming traffic.

I see a lot of login attempts in the windows logs where hackers are trying to connect to it. I can also access it via SSMS from multiple external ips.

Everywhere I've googled says that incoming traffic should be blocked by default by the firewall.

There are no obvious rules that allow SSMS access.

If I do a blocking rule on inbound rules for a single ip that does work, blocking it from that ip, but any other ip's can still connect.

In the firewall log file I can see the allowed connections on port 1433 etc. other than the dropped one from the test blocking rule.

View 5 Replies View Related

Adding A Custom Named Instance To Windows Firewall Exception List

Aug 14, 2007

We install SQL Express 2005 with a custom named instance. Since a named instance uses dynamic ports, how can I add this named instance to the Windows Firewall exception list? Previously with MSDE 2000 we installed as default, then I added port 1433 to the Firewall exception list.

Is there a way to install SQL Express to a static port (programmatically)? Or, is there a better method, like adding the SQL custom named instance service to the firewall exception list?

View 1 Replies View Related

Cannot Install Reporting Services On Windows Vista

May 15, 2008

Hi Guys,

I was struggling with installing reporting services from Sql 2005 dev edition on windows vista. I somehow managed to install the SQLExpress edition for Reporting Services, but now i want to unistall it and install Sql Reporting Services from Sql 2005 Dev edition CD.

When I try to unistall the SQlExpress Reporting Servie instance, the screen which says unistalling components disappears in a couple of secs and when i refresh the list of programs installed under Programs and features, i can still see SQLExpress Reporting Servies, i do not understand why this is happening and probably this is the reason behind not able to see the Reproting Services check box ungreyed when installing SQL 2005 dev edition.
CAN SOMEONE HELP ME ON THIS PLEASE?

View 1 Replies View Related

Reporting Services Unavailable After Windows 2003 SP2 Installed

Jul 24, 2007

I have installed windows server 2003 on one of our test boxes (prior to live) and found that reporting services is now unavailable.

When I browse to the report server I get

Service Unavailable
The event log reports several times

"A process serving application pool 'reportserver' terminated unexpectedly. The process id was '3500'. The process exit code was '0xffffffff'.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

before the worker process is disabled:

"Application pool 'reportserver' is being automatically disabled due to a series of failures in the process(es) serving that application pool.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp."

Has anyone seen similar behavior?

Stuart


"

View 1 Replies View Related

Reporting Services :: Opening PDF Files On Windows Phones

Jun 10, 2015

Since migrating our SSRS 2005 to SSRS 2014 we have had a number of clients saying they can't open .pdf files that get emailed to them from our SSRS subscriptions.

They open fine no a Windows PC, iPhone and Android.

View 5 Replies View Related

Reporting Services Configuration Fails In Windows 2003 SP2 ,64-bit Machine

May 14, 2008



Hi all,
i am tring to install and configure reporting services in Windows 2003 SP2- 64 bit machine as part of installing SCE 2007, and i followed the procedure for confiurng all the options in reportingservices config tool,

all the options show green flag and still could not proceed further as the following error is coming

"The Selected Sql server reportin service instance is not configured , please configure to continue" which halts the further process,

I have installed SQL Server 2005 edition and installed Sql server 2005 SP2 also,

any inputs on this issue , i would welcome them,

View 2 Replies View Related

Reporting Services :: Windows File Share -> Add Date Extension

Feb 24, 2010

When I am saving a SSRS report in excel format in a shared network drive, how can I add the date extension to the filename ?I assume this is something that needs to be handled within the SSRS reporting side rather than the subscription side.

View 5 Replies View Related

Can't Install Reporting Services And Full-Text Search On Windows Vista

Apr 26, 2007

When I install SQL Server 2005 Express Edition with Advanced Services SP2 on Windows Vista, Reporting Services and Full-Text Search are not being installed. My user account is configured as a Standard User. When I initiate the installation, I'm prompted for the password for the administrator user account.



During the System Configuration Check, I get a warning for the IIS Feature Requirement action. The associated message says: "Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online."



KB Article 920201 ("You receive a warning message on the System Configuration Check page of the SQL Server 2005 Setup program on a computer that is running Windows Vista or a Server Core installation of Windows Server "Longhorn"") seems to address this issue. I used the Windows Features applet and selected all of the Internet Information Services items that were listed in the KB article; however, the "Windows Authentication" item was not in my list. ("IIS Metabase" and "IIS 6 WMI" were in my list but were worded differently--"IIS Metabase and IIS 6 configuration compatibility" and "IIS 6 WMI Compatibility", respectively--but I selected them both.) When I re-ran the SQLEXPR_ADV installer, I got the same warning...and Reporting Services and Full-Text Search were still not installed.



I went back into the Windows Features applet and selected all of the remaining unselected "Internet Information Services" items, and then re-ran the SQLEXPR_ADV installer. I got the same warning...and Reporting Services and Full-Text Search were still not installed.



It's frustrating that there is no obvious reason or error message as to why Reporting Services and Full-Text Search are not being installed. Are these features compatible with Windows Vista? Does anyone have an idea as to what the problem might be?

View 8 Replies View Related

Reporting Services :: SSRS Properties Greyed Out In SSMS On Windows 2008

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

Reporting Services :: SSRS Windows Integrated Not Working To DNS Name / Works With Server Name

Aug 12, 2015

I have an acctest server (XX-ATS-ASSHP102) running SSRS, SQL DB Engine & SSAS. I'm trying to configure NATIVE SQL Reporting Services to use a data source with Windows Integrated mode towards a SSAS cube on the same server. When I use the servername (or 127.0.0.1) it works perfectly. But when I use the DNS name bidb.acctest.internal it fails with the error "The connection either timed out or was lost.". The profiler on SSAS says "anonymous login" so the Kerberos login is broken at some point.The weird thing is that this works perfectly in production environment, but I've missed something in the ACCTEST environment.The SPN for the serviceaccount running SSAS has correctect SPN:s:

MSOLAPSvc.3/bidb.acctest.internal
MSOLAPSvc.3/bidb.acctest.internal:MSSQLSERVER
MSOLAPSvc.3/XX-ATS-ASSHP102
MSOLAPSvc.3/XX-ATS-ASSHP102.XX.XXXXXXXXXXX.net
MSOLAPSvc.3/XX-ATS-ASSHP102.XX.XXXXXXXXXXX.net:MSSQLSERVER
MSOLAPSvc.3/XX-ATS-ASSHP102:MSSQLSERVER

The SSRS account has delegation with "any service". No account has the "sensitive" flag.DNS names are A-records, except the hostname for the SSRS site which is a c-name, but it's identical in production.The "impersonate client after login" and "replace token" permissions are correct in the policy.The rsreportserver.config says:

    <Authentication>
        <AuthenticationTypes>
            <RSWindowsNTLM/>
        </AuthenticationTypes>
        <RSWindowsExtendedProtectionLevel>Off</RSWindowsExtendedProtectionLevel>
        <RSWindowsExtendedProtectionScenario>Proxy</RSWindowsExtendedProtectionScenario>
        <EnableAuthPersistence>true</EnableAuthPersistence>
    </Authentication>

both in production and in acctest env..

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved