Hot answers tagged

48

“Microsoft® System CLR Types for Microsoft® SQL Server® 2012” can be downloaded at Microsoft® SQL Server® 2012 Feature Pack (direct links: X86 version, X64 version). And it seems to have fixed the installation problem for us; the server we needed to install the Report Viewer 2012 on does not have SQL Server installed at all.


9

I know this is a really old post, but for anyone that is still having this issue... I managed to work around it by going into my local administrators group on the server and clearing out any accounts showing up as a GUID. Once I did that, I was able to launch the tool, fill in no server/user info and just hit connect. It logged right in after that. (I ...


6

Introduction According to the various documents I found during my initial research and the documents provided in links and discussions I have come up with a solid, reliable, compliant solution. RFC 3484 The binary comparisons conducted further down and the rules applied are according to RFC 3484 which is apparently also valid for IPv4 addresses. RFC 3484 ...


4

Here's how I solved this: 1) Turned on 'the' administrator account via command line: net user administrator /active:yes 2) Logged in as the built in admin and opened the browser as an administrator 3) Successfully went to http://localhost/reports and assigned my regular admin account all the rights it needed. I'm not sure what the difference is between ...


4

SSRS supports several standard data sources as well as other .NET data sources: https://msdn.microsoft.com/en-ca/library/ms159219.aspx Assuming you are using the SQL native client for the data source, you have no option to specify a source IP address: https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring(v=vs.110)....


3

I struggled with this as well. It was impossible in Windows 8 with my own "admin" account to get the Report Server working. Worse yet I had forgotten the administrator account password I used to set up the computer. You have to enable the administrator account in Computer Management => Local Users and Groups => Administrator; right-click, select Properties, ...


3

Late reply, but I just ran into this issue with moving SSRS 2008 R2 to a new server. Had the same problem as described above, but going through the Database and Credentials wizards fixed it for me, even though I made no changes and everything was displayed correctly. Go to Database -> Change Credentials/Change Database in the configuration manager and ...


3

Assign the Browser role to the NT AUTHORITY\Authenticated Users group to configure the read-only access of the SSRS environment for all the authenticated domain users. Source


3

IIRC RS Configuration Manager looks for matching version of the report server. You will need RSConfigTool that comes with Sql Server 2008 (you can run it remotely on any other machine)


3

I use the principle of least privilege when setting up services and create a specific account for each service. If you are going to use built-in accounts, which one you should select depends if you are using Active Directory or not. If the server is in an AD Domain, you should use Network. Otherwise, I'd suggest Local System. But my first choice would be to ...


3

According to the Google Developers guide, you don't have to set up multiple code snippets for each site, as long as they share the same top level domain: Google Developer's Guide Here's a good article on displaying subdomains in the dashboard.


2

This is by design and can be researched by searching for Kerberos and double hop issue. You need to enable Kerberos delegation on your reporting services server as well as set up an SPN so that Kerberos can pass the credentials of the user running the report instead of the Service Account for SSRS.


2

I would first determine if SSRS is indeed only using one processor. This is simple enough using Process Monitor, Task Manager, or Performance Monitor. If it's only using one thread, I would research the documentation and see if there is anyway to scale this out. Unfortunately, I don't know the answer. The other thing I would look at is SQL Server. Use SQL ...


2

I really like pingdom. They will externally monitor services or even look for a specific string which is returned by a web server etc. http://pingdom.com/ You get one free probe without SMS messaging. You just pay for SMS credits as and when you use them. If you get by with just e-mails or push notifications to their apps they it's completely free for one ...


2

Here the solution to download the Microsoft® System CLR Types for Microsoft® SQL Server® 2012 Step 1 : Choose the below website link https://www.microsoft.com/en-us/download/details.aspx?id=29065 Step 2 : In this link, you have to choose the "Install instructions" menu. Then, you need to ...


2

The solution was two-fold: I exported the certificate from the primary site sever under "Personal\Certificates" the friendly name is "ConfigMgr SQL Server Identification Certificate." I then imported the certificate to my local workstation under "Trusted Root Certificate Authorities\Certificates." This allowed me to connect to SQL server when I choose "Use ...


2

Using ILSpy, I've determined that "ExecutionLogLevel" setting isn't even used by SSRS 2012; it's not a supported setting. There is no code that references that string anywhere. FYI, I can find code that references "EnableExecutionLogging" and "ExecutionLogDaysKept" (complete with the internal constants defining the default values that SSRS uses). The ...


2

I checked Add/Remove programs and no luck either, Can't find SSRS listed. That's because it's not listed as SQL Server Reporting Services. You will need to choose SQL Server in the list of installed programs, click "Uninstall/Change", select the instance of SQL Server that you want to work with, then finally in the 'Select Features' interface, check only '...


2

I don't think that you can. I think it's hard-coded. I have SBS08, not SBS2011, but apparently they both use the Windows SBS Fax Sharepoint Receive Connector for the SBS console mail. This is set to allow all connections from 127.0.0.1 anonymously. Your best bet would probably be to set up some kind of SMTP server with similar properties, perhaps the ...


2

It means that your queries aren't large enough to fill the memory. This is a good thing, unless you are seeing heavy I/O while running the report.


2

You said in a comment above that your databases are only about 10GB total. SQL Server can easily load them entirely in memory, including data, indexes, and temporary data from your queries. This is a good thing, and provides better performance than reading from disk.


2

Ok, I think I found a workaround - it's not exactly pretty, but it does work. From information found here: https://blogs.msdn.microsoft.com/sambetts/2014/02/04/multi-subnet-clustered-sql-registerallprovidersip-sharepoint-2013/ I set RegisterAllProvidersIP to 0 then set the HostRecordTTL to 300 and restarted the role. This will force the cluster to only ...


2

In order to resolve the issue I had to edit C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer\reportserver.xml Under: <AuthenticationTypes> Comment out the following: <!--<RSWindowsNTLM/>--> <!--<RSWindowsNegotiate/>--> <RSWindowsBasic/> Leaving WindowsBasic as the only ...


2

Yes, you have two use accounts (one on each server) with the same name and password. Then run your application Pool under that user-account. Give limited permission to the account, to just do what it is suppose to do. The AppPoolIdentity account has no access to the network or other servers.


2

Add the URL to your Local Intranet zone in Internet Explorer settings on the client laptop.


1

I have something that works on SSRS 2012, but it's a total hack. It's possible to use client-side Javascript to rewrite all the URLs (plus the occasional RedirectUrl parameter SSRS is fond of), but that doesn't account for the Response.Redirect() calls server-side. So you'd be left with a partial solution. In short, add an HttpModule to ReportManager so you ...


1

If you can configure the VPN client not to change your default gateway, you shouldn't have any interruption to your internet connection. The only reason you lose your internet connection is because the VPN client adds a new default route to the VPN server at the other end of the tunnel, forcing all traffic through the VPN. Almost all VPN clients I've ever ...


1

After long long search, I found this one: http://support.microsoft.com/kb/926642 It seems, Microsoft has deliberately blocked loopback authentications. That's why I cannot configure my TFS and Sharepoint URLs as needed - they just fail to authenticate.


1

I think that you want to look at "Configuring Reporting Services Scale-out Deployment", which used to be called a SSRS "web farm". In this scenario, you can install a number of SSRS web sites that all reference the same metadata databases on a common, central SQL Server. You can install just one "farm" server or many farm servers, in addition to the central ...


1

There is xymon, which can do E-mail and SMS. It is free (open source). It provides alerts and reports from a central xymon server. It can be customized for your unique requirements. It monitors and collects historical information related to connectivity, CPU utilization, memory, disk utilization, process statuses, and much more. Monitoring a web server (...


Only top voted, non community-wiki answers of a minimum length are eligible