Most of SharePoint customers suffer no issues when integrating SQL Server Reporting Services 2012 (SSRS 2012)  with SharePoint 2010 (SP 2010), however we had quite a bit of trouble. So for those who may also be having some trouble, we would describe how to fix the error. You can following the steps bellow:

- First, you should install SQL Server with Reporting Services Add-in for SharePoint
- Install SharePoint on the Reporting Services Server and connect that server up to the farm (using Configuration Wizard)
- Install the rsSharePoint.msi file provided by Microsoft on all your front-end servers running SharePoint
- Run these two commands on all front-end servers running Sharepoint
- Run these two commands on all front-end servers running Sharepoint  

• Install-SPRSService
• Install-SPRSServiceProxy

- Navigate to Central Administration -> System Settings > Manage services on server.  Start the SQL Server Reporting Services Service
- Navigate to Central Administration -> Application Management > Manage Service Applications.  Create a new SQL Server Reporting Services Service Application

Problem 1:
"Install-SPRSService : The term 'Install-SPRSService' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again"

Solve:
You should install the Reporting Services SharePoint Add-In (Found on your SQL Server 2012 installation media) on every server running SharePoint. Please don't use the rsSharePoint.msi provided on Microsoft's website.

Problem 2:
"When we try to create a SQL Server Reporting Services Service Application under 'Manage Service Applications', we receive an error relating to permissions to a registry key"

Solve:
There's nothing wrong with your registry except that SharePoint is looking for files that don't exist.  This is because you most likely installed the Reporting Services SharePoint Add-In with the rsSharePoint.msi file that Microsoft provides on their website. That file is a cut-down version of what gets installed when you install the Add-In from the SQL Server 2012 installation media.  Uninstall it from Control Panel, and re-install it with the SQL Server 2012 installation media. 

Problem 3:
"we have created my SQL Server Reporting Services Service Application, but when we try to access any of the links inside it (system settings for instance), we are receiving a 503 unauthorised error message"

Solve:
This may vary from case to case, but for me it was because we ran these commands on every front end server:

• Install-SPRSService
• Install-SPRSServiceProxy

When in actual fact, depending on your scenario (SharePoint Standard Licensing we think is the cause), you should only run these scripts on the server that you wish to be running the Server Service. You will need to uninstall them by using the following scripts (remember to delete the application and stop the service  in Central Admin first)

• Install-SPRSServiceProxy –uninstall
• Install-SPRSService -uninstall

ASP.NET 4.5.2 European Shared Hosting with HostForLIFE.eu

Windows & ASP.NET 4.5.2 Shared Hosting refers to the type of hosting where there is server which hosts many different website that is a website does not individually have a dedicated server for its own purpose. Shared Web hosting is a type of web hosting that allows many websites on the same server. The different websites owned by different people that are present on this sever share the same IP address, the same connectivity, the same CPU time.

Simplicity and Cost-efficiency are the two main benefits. Sharing server space can be fairly cheap. The free add-ons, such as templates and website builders, also save the webmaster money. The host manages the resources and maintains the server, which makes things a lot easier on the site owners. For the technically challenged, this is the best solution, since no knowledge of programming, designing, or hosting is required.

HostForLIFE.eu ASP.NET 4.5.2 Shared Hosting Rich Feature and Cost Effective

HostForLIFE.eu offers five types of ASP.NET 4.5.2 shared hosting plans start from €1.29 per month. With all of the shared hosting plans you can host unlimited amount of domains. Its HostForLIFE.eu LITE Shared Hosting Plan starts at €1.29 /month, and include features like 1000MB Disk Space, 10GB Monthly Bandwidth, the latest stable technologies like Windows Server 2012, Internet Information Services 8.0 / 8.5, SQL 2014, SQL 2012, SQL 2008 R2, SQL 2008, ASP.NET 4.5, ASP.NET 4.5.2, ASP.NET MVC 5.2, Silverlight 5 and 100+ Free WebMatrix and PHP Applications.

HostForLIFE.eu European ASP.NET 4.5.2 Cloud Hosting is Affordable

Cloud Hosting systems are becoming more and more popular, because web hosts, basically Shared Hosting providers have to deal with a large amount of websites which require growing amount of resources. Cloud hosting can be useful for many companies for many reasons. Hosting in the cloud different technologies can be used together that can't be used together with regular hosting. For instance, with cloud hosting it is possible to use PHP and ASP files together and even in the same folder because it can draw the technologies needed from the cloud. This gives you better flexibility and the ability to use almost any type of technology you want to and know that it will mesh without a hitch.

Price and Technical Support in HostForLIFE.eu European ASP.NET 4.5.2 Cloud Hosting

HostForLIFE.eu is another hosting provider that has been known for offering fast and reliable servers.  HostForLIFE.eu lowest-priced ASP.NET Cloud Hosting called Bronze Plan has 1 GB Diskspace, 10 GB Bandwith, Guaranteed Conn 10Gb/s and Dedicated App Pool priced at €1.49 per month.

HostForLIFE.eu provides 24/7 customers support through its Helpdesk and Email support. Our Microsoft certificated technicians offer the most professional support to help our customers on ASP.NET issues effectively. Besides, customers can check our knowledgebase to diagnose issues by themselves.

ASP.NET 4.5.2 Reseller Hosting with HostForLIFE.eu

Reseller hosting is the web hosting program or service which re bundles the services that are available from the primary providers or the real web hosts. The reseller can sell space and bandwidth from a rented dedicated server. Alternatively, the reseller can get permission to sell space and bandwidth from shared server. This type of hosting is the most inexpensive method by which websites can be hosted on the internet.

Reseller hosting is the perfect solution for webmasters, designers, developers, internet consultants or anyone wanting to start a profitable online business. If you're looking to get into the reseller hosting business, Plesk Panel reseller hosting is the best option. Reseller web hosting is an ideal solution for those who already have a web site but maximum reliability, performance and uptime is critical to their business or e-commerce web site. A webmaster may require a network of websites under different domain names to serve different business plans, but all are hosted under a common reseller hosting account.

Why Choose us to be Your ASP.NET Reseller Hosting Partner?

HostForLIFE.eu Windows ASP.NET 4.5.2 Reseller Plans starts from €15.00/month allow our customer to re-brand our control panel, thus, we remain completely anonymous. We also offer private nameserver and this service is available upon request. With no contracts, the ability to cancel anytime, and a 30 day money back guarantee, our unlimited reseller hosting is completely risk free.

Some of the highlighting or standout features of HostForLIFE.eu’s Reseller Plan are 10 domains, 40GB Diskspace , 200 GB Bandwith 4GB RAM or higher, DAILY Server Monitoring and support the latest technology from Microsoft such as ASP.NET 4.5.2 Hosting, ASP.NET 5.2, SQL Server 2012/2014, Windows Server 2008/2012. HostForLIFE also provide free application download softwares like Joomla 3.3, WordPress 3.9, DotNetNuke, WebMatrix Application, Mambo, Joomla, phpBB, BlogEngine.NET,etc.

BugNET is an issue tracking and project issue management solution built using C# and ASP.NET . The main goals are to keep the codebase simple, well documented, easy to deploy and scalable. You can found BugNet project on CodePlex and now, we are going to try installing BugNET. Here are the easiest way to install BugNET:

1. First, Log in to your database server with a user who has sufficient privileges.
2. Create a database on your SQL Server , you can name it for example: BugNetDatabase.
3. Create a new login. I used the same name for the database and the login.
4. I disabled Enforce password expiration since this is my local server on the intranet. You can also set Windows authentication. Set the membership on the BugNetDatabase.
5. Now that you have database user/connection, you can deploy the package on web server. The instructions on codeplex site are clear. I let myself to copy these instructions here to comment them or to show how I modified. All the information in bold, blue is copied from codeplex site.
6. Download the latest stable release of BugNET, using the INSTALL package.
7. Extract the contents of the install package to a folder on your computer.Create a directory in the c:\inetpub\wwwroot\ folder called bugnet (c:\inetpub\wwwroot\bugnet)
hen you must Copy the contents of the extracted BugNET INSTALL package to the c:\inetpub\wwwroot\bugnet\ folder. In the zip folder you downloaded, you'll find 2 folders.Go to the properties of the c:\inetpub\wwwroot\bugnet\ folder, click on the Security tab, be sure to add the permissions for the appropriate user (WinXP/2000 uses the local ASPNET account, Win2003/Vista/2008/7 use the local Network Service account). Give this account modify permissions on the folder.

- Uploads: if you using file system based uploads
- App_Data : This folder is where BugNET stores its database.- web.config - the application installer will create a unique machine key for password encryption during the installation process.
8. Open up the the web server IIS Console.

- Click start button ->  then, type run -> type INETMGR then ENTER.Create a virtual directory in IIS for the bugnet folder.
- Expand the websites node
- Expand the default websites node
Right click on the BugNET folder under the default website, click on Convert to Application, if you don't have that option, choose properties and then add the application. 

9. After that, don’t forget to configure your server.  The last thing that isn't mentioned on the official instructions : configuring web.config to let BugNet to communicate with your database. You can replace the following code:

<connectionStrings>
        <clear/>       
<add name="BugNET" connectionString="Data Source=.\SQLEXPRESS;Database=BugNET;Integrated Security=True;" providerName="" />  
</connectionStrings>

With  
<connectionStrings> 
<clear />  
<add name="BugNET" connectionString="Server=XXX.XXX.XXX.XXX;Database=BugNetTest;User ID=bugnettest;Password=XXXXXXX;" providerName="System.Data.SqlClient" />
</connectionStrings> 

Finally, you can connect to the site with your favorite web browser using the following link: 
http://localhost/BugNetTest/Install/Install.aspx

Browse again to http://localhost/BugNetTest/. As indicated on the codeplex site for the first connection use admin/password.

European leading web hosting provider, HostForLIFE.eu announced cheap dedicated Windows cloud server due to high demand of Windows cloud server users in Europe.

Windows & ASP.NET hosting provider HostForLIFE.eu announced cheap dedicated Windows cloud server hosting plans. HostForLIFE.eu offers the ultimate performance and flexibility at an economical price for windows cloud server. HostForLIFE.eu cheap dedicated Windows cloud server hosting plans starts from just as low as €16.00/month only.

HostForLIFE.eu provisions all dedicated Windows Cloud Server in just few minutes (upon payment verification and completion). HostForLIFE.eu has a very strong commitment to introduce their Cheap dedicated Windows and ASP.NET Cloud Server hosting service to the worldwide market. HostForLIFE.eu starts to target market in Europe. HostForLIFE.eu will be the one-stop cheap dedicated Windows and ASP.NET Cloud Server Hosting Solution for every ASP.NET enthusiast and developer.

HostForLIFE’s cheap dedicated Windows Dedicated Cloud Server hosting plan comes with the following features: Windows 2008R2/2012, Data Center OS Version, 1 x vCPU, 1 GB RAM, You have full root access to the server 24/7/365, 40 GB Storage (SSD), 1000 GB Bandwidth, 1000 Mbps Connection, 1 Static IP and SAN Storage.

For additional information on this cheap Windows dedicated cloud server Hosting plan, please visit http://hostforlife.eu/European-Cheap-Windows-Cloud-Server-Plans

About HostForLIFE.eu:
HostForLIFE.eu is European Windows Hosting Provider which focuses on Windows Platform only. HostForLIFE.eu deliver on-demand hosting solutions including Shared hosting, Reseller Hosting, Cloud Hosting, Dedicated Servers, and IT as a Service for companies of all sizes.

HostForLIFE.eu is awarded Top No#1 SPOTLIGHT Recommended Hosting Partner by Microsoft (see www.microsoft.com/web/hosting/HostingProvider/Details/953). Their service is ranked the highest top #1 spot in several European countries, such as: Germany, Italy, Netherlands, France, Belgium, United Kingdom, Sweden, Finland, Switzerland and other European countries. Besides this award, they have also won several awards from reputable organizations in the hosting industry and the detail can be found on their official website.

Managing the website content has been one of the main challenges to many website developers and managers. It is common to find some content management systems (cms hosting) that are too complex and costly. Though, many thanks to the origin of open-source cms like as silverstripe, creating websites have moved from being a boring job to a thrilling and creative procedure. SilverStripe CMS Hosting is associate degree open supply online page management system utilized by governments, businesses, and non-profit organizations round the world. It is an influential tool for skilled internet development groups, and online page authors rave regarding however straightforward it’s to use.

As a platform, SilverStripe CMS is employed to make websites, intranets, and internet applications. The trendy design of SilverStripe CMS permits organizations to stay pace with innovation in the online. SilverStripe CMS Hosting permits websites and applications to contain gorgeous style, nice content, and compelling interactive and social functions.

SilverStripe is based on PHP5, HTML, Javascript, and CSS. These are all well-known, open standards that are used across the entire Internet. In addition to the data that is stored in the site's directory tree (images, video, audio files, compressed archives, et cetera), site content and configuration information is kept in a unified SQL* database, similar to most CMS software. Due to its use of open standards, it is able to function on most platforms regardless of the operating system they run. (SQL database can be MySQL, PostgreSQL, Microsoft SQL Server or others).

Installation is fairly straightforward, however it is significantly more complex than some other CMS packages like Wordpress or TextPattern. Documentation is provided to walk you through the process. However, installation of this particular CMS is not as obvious, nor as user-friendly, as some of its competition.

SilverStripe CMS is a PHP/SQL application and as such you will need to download the installation files from the official SilverStripe CMS website first. After having your SilverStripe-version.tar.gz ( the version number is changing when a new release is available ) file downloaded, please extract it on your local computer. The extracted files should be uploaded under your HostForLIFE.eu ‘s hosting account where you would like to have SilverStripe installed.

If you would like to have your SilverStripe CMS directly accessible at http://yourdomain.com you should upload the files under the root directory on your Silverstripe CMS Hosting. On the other hand, if you would like to have it located under a subfolder you may create a subdirectory under your root folder where the files should be uploaded. If you upload your files under /rootfolder/cms/ your Silverstripe installation will be accessible under http://yourdomain.com/cms.

After your files are uploaded under your account you should proceed with your MySQL database creation process. You can easily create a MySQL database for your CMS on Plesk Control Panel.

The setup is pretty fast and will start when you access:
http://yourdomain.com/install.php
There are a few sections on the installation page which are important for the setup. The first section is Database:

Here you should type in the database name, username and password you have created. When your database details are filled in correctly click the “Re-check requirements” warning message on this tab should disappear. We have the first section for the setup with the correct details and the next one is choosing main administrator account access details:

You should ensure that you have filled in a working e-mail address as it is also used to reset the password if lost or forgotten. We have used only the word “admin” on the screenshot as this is a demo install and will not be used for a live website. The last step is to select the available template in the core distribution of the Silverstripe CMS or use empty website and start building your own menu structure. If you are a first time user it is recommended to select the template:

This way the installer will create demo content and you will be able to review the basic functions of the CMS. When we have completed all the above sections on the installation screen will click on “Install SilverStripe” button at the very bottom of the page:

This is the last step which completes the CMS initial setup. You will notice the following error message on the page which will load with the SilverStripe successful installation page. For security reasons you should now delete the install files, unless you are planning to reinstall later (requires admin login, see above). The web server also now only needs write access to the "assets" folder, you can remove write access from all other folders.

You can remove installation files by using the “Click here” link. As for the permissions of the “assets” folder you may change these using Plesk Panel > File Manager or your favorite FTP client. The CMS admin you may access using:

http://yourdomain.com/index.php/admin/
and this will provide you with the access to the tools available to start building your website with the default CMS style.

European Windows and ASP.NET hosting specialist, HostForLIFE.eu, has officially launched the new Windows & ASP.NET Shared Hosting Plan offered from as low as €1.29/month only. This LITE Windows & ASP.NET Hosting packages combine generous or 1 website, 1 GB disk space, 10 GB bandwidth, Support UTF-8 Domains, Dedicated Pool, etc. As the market for hosted solutions continues to grow, the new hosting range is designed to exceed the growing technical demands of businesses and IT professionals.

HostForLIFE.eu  is confident that their new LITE shared hosting plans will surely appeal to the personal across the world, besides the website owners and companies owning websites. The new web hosting plans will meet the requirement of high performance web hosting where one can easily update the content of a website on a regular basis. This plan is designed more for the web hobbiest needing affordable, high availability, hosting and easy backend management of windows and ASP.NET with powerful Plesk control panel.

Every day thousands of people decide to set up a website for business or personal use. New business owners and the average consumer don’t always have access to unlimited budgets. HostForLIFE.eu understand the importance of reliable hosting but are not always prepared to pay the exorbitant prices that reliable hosts charge.

For additional information about LITE Shared Hosting Plan offered by HostForLIFE.eu, please visit http://hostforlife.eu

About HostForLIFE.eu:

HostForLIFE.eu is European Windows Hosting Provider which focuses on Windows Platform only. HostForLIFE.eu  deliver on-demand hosting solutions including Shared hosting, Reseller Hosting, Cloud Hosting, Dedicated Servers, and IT as a Service for companies of all sizes.

HostForLIFE.eu is awarded Top No#1 SPOTLIGHT Recommended Hosting Partner by Microsoft (see www.microsoft.com/web/hosting/HostingProvider/Details/953). Their service is ranked the highest top #1 spot in several European countries, such as: Germany, Italy, Netherlands, France, Belgium, United Kingdom, Sweden, Finland, Switzerland and other European countries. Besides this award, They have also won several awards from reputable organizations in the hosting industry and the detail can be found on their official website.

Today I had a problem with a table that has around 5 million records on my SQL Server 2012. The table has as primary key “Header No.”,”Transaction No.”. In the table is a field “Order No.” that at the moment is blank for all records. I also had an index on that field, because I will need to search for it. I think that in the future only 1 in several 1000 records will have an order no. So the index will be highly selective because I will have only 1 record per order no.

The code is like this:
Table.RESET;
Table.SETCURRENTKEY(“Order No.”);
Table.SETRANGE(“Order No.”,TheOrderNo);
IF Table.FINDFIRST THEN BEGIN

It should go lightening fast but it takes almost 1 second for each FINDFIRST.

Why?
The SQL plan gave me this:

Top[2,1];Nested Loops[3,2];Index Seek($2)[4,3];Clustered Index Seek(Company Name$Table$0)[6,3]
WHAT? A CLUSTERED index Seek?????
it should have been an index seek.
The select was what I expected:
SELECT TOP 1 * FROM “Company Name$Table” WITH (READUNCOMMITTED)  
HERE ((”Order No_”=?)) ORDER BY “Order No_”,”Header No_”,”Transaction No_” OPTION (OPTIMIZE FOR UNKNOWN)

But because SQL knows that the Field “Order No.” contained only blanks, it decided to do a clustered index seek because of the ORDER BY (at least this is what I think SQL decided). So how to fix it NOW (I don’t want to wait that it goes into production and it takes days or months before the problem fixes itself.

What is the code for?
The FINDFIRST serves because I want the Invoice No. of that record and it has to be a non-blank value.
So, I changed the index from “Order No.” to “Order No.”,”Invoice No.”. It makes the index a little bigger, but it shouldn’t be a big problem (or at least I hope so).
The C/AL code I changed like this:

Table.RESET;
Table.SETCURRENTKEY(“Order No.”,”Invoice No.”);”
Table.SETRANGE(“Order No.”,TheOrderNo);
Table.SETFILTER(“Invoice No.”,’<>%1’,’’);
IF Table.FINDFIRST THEN BEGIN

Even with all blank values in “Order No.”,”Invoice No.” at the moment, SQL has changed its plan to an index seek and the code has become very fast.

In this blog post I will show you reasons why you might be getting SQL Server error 18456 and show you may be able to solve it.

18456 Error overview

When connecting to Microsoft SQL Server Hosting and trying to use usually SQL Authentication method you may get event ID error 18456 login failed for user you provided. See below example.This usually means that your connection request was successfully received by the server name you specified but the server is not able to grant you access for a number of reasons and throws error: 18456. This eventID sometimes provides also state 1 which actually isn’t that useful as due to security reasons any error is converted to state 1 unless you can check logging on the server. Microsoft does not provide very useful message boxes so below are some explanations why you get the error.

Below is a list of reasons and some brief explanation what to do:
SQL Authentication not enabled: If you use SQL Login for the first time on SQL Server instance than very often error 18456 occurs because server might be set in Windows Authentication mode (only).

Invalid userID: SQL Server is not able to find the specified UserID on the server you are trying to get. The most common cause is that this userID hasn’t been granted access on the server but this could be also a simple typo or you accidentally are trying to connect to different server (Typical if you use more than one server)

Invalid password: Wrong password or just a typo. Remember that this username can have different passwords on different servers.

Less common errors: The userID might be disabled on the server. Windows login was provided for SQL Authentication (change to Windows Authentication. If you use SSMS you might have to run as different user to use this option). Password might have expired and probably several other reasons…. If you know of any other ones let me know.

18456 state 1 explanations: Usually Microsoft SQL Server will give you error state 1 which actually does not mean anything apart from that you have 18456 error. State 1 is used to hide actual state in order to protect the system, which to me makes sense. Below is a list with all different states.

I hope that helped you solve you 18456 error. If you know of another cause and solution than let us know and we will include it in the blog post.

A cloud server hosting company gives opportunity to buy resources that help in customization and also comes with innumerable functionalities that are gained through network in a similar manner that is offered through traditional hosting solution. It is possible to avoid all kinds of hassles that are related to hardware and minimal maintenance is required. For a cloud server, a monthly fee is paid to company.

HostForLIFE.eu is one such company that can deliver performance and dedication to your family of websites with Cloud Server. But before you know whether or not a cloud server is needed, you must know what one is. Cloud server give your site, or family of sites, all the resources necessary to navigate technical issues and keep things running smoothly. Instead of sharing personnel, infrastructure and storage space with a pack of unrelated sites, you have the freedom to control operation and mold the server to meet your needs. This can be beneficial in a number of ways.

A dedicated Cloud server has its own processor, Random Access Memory (RAM) and bandwidth capability. Dedicated Cloud servers allow you to install and run almost any program. They additionally allow other users, whom you have given access, the ability to connect to your dedicated Cloud server and use those same programs at the same time you do. This has made dedicated servers very popular amongst internet gamers. Dedicated cloud servers offer all the same features of regular dedicated hosting servers but they are intended for less serious pursuits.

According to the need of clients, Windows platform such as Windows Server 2008/2012 is rendered if using Visual Basic scripts, Active Server Pages (ASP.NET ) or Microsoft Access or Microsoft SQL database. Other important factor to be focused for rendering web hosting services is the disk space and bandwidth required. HostForLIFE.eu cloud server solution with 8 GB RAM, 2x500GB Storage Space, 5000 GB Bandwidth, 1000 MBps Connection speed with Netherlands Data Center or US Data Center.

Also, dedicated Cloud Server can keep you safe from the hazards of the web. Spyware, viruses, worms, and other nasty sounding names are waiting for an opening, planning an attack on your site that will set you back in more ways than one. If your users sense that a website has inadequate protection, it will make them think hard about returning. Hackers may also try to break in and steal financial information if you use your website for commercial purposes. Keeping the predators at bay means having a knowledge of all the latest security measures and how to implement them. Or you can just sign up for a dedicated server and not worry about it.

Different features of cloud servers 

The most important feature is that you can possibly get true value for money. You need to pay same amount as that of basic shared hosting and can get set of features that is found in a dedicated server. Cloud solution is the only way through which it is possible to save a good sum of money and enjoy different features that is necessary for business.Cloud server comes up with no downtime and this means that you will never experience error page regarding website and it always get loaded in different browsers when customers or viewers want to check. The downtime in this regard does not last for more than a few seconds and it is an amazing feature.

Next advantage is related to adding and removing of servers at any point of time and can instantly scale up solutions. It can be that you may in need of another server, which will help to handle large amount of traffic and once it is settled it is possible to scale down the server. It has turned out to be a useful user for people who are making use of cloud computing.

Benefits of Dedicated Cloud Server With HostForLIFE.eu

Faster Service

For most people what is in short supply is time. On this point a cloud server scores above dedicated servers.

Security

Cloud Server provide the highest level of security just like a dedicated cloud server, complete with customizable firewall protection and secure isolated disk space along with the benefit of sharing the cost of the server with other users yet reaping the benefits of the dedicated cloud server.

Performance

All resources can be regulated in the Cloud Server environment. One customer can not run away with a large share of the resources. Your service will run reliably and predictable.

Control

Unlike a shared server, Cloud Server allows you the control of the server. You can choose the software you want to install, RAM, processor etc.

Scalability

Dedicated cloud servers can consume time because the creation of back up takes time. Cloud servers face immense pressure as the number of clients can balloon and go out of control. But that does not happen in dedicated servers as the numbers are manageable. 

In my current project I need to query an MS SQL Server database. Unfortunately the dates are stored as a BigInt instead of a proper date datatype. So I had to find out how to do compare the dates with the systemdate, and how to get the system date. To log this for possible later use, as an exception, a blog about SqlServer. To get the system date, you can do:

(SELECT dt=GETDATE()) a

It's maybe my Oracle background, but I would write this like:
(SELECT GETDATE() dt) a

An alternative is:
select CURRENT_TIMESTAMP

I found this at this blog. Contrary to the writer of that blog I would prefer this version, since I found that it works on Oracle too. There are several ways to convert this to a bigint, but the most compact I found is:
( SELECT  YEAR(DT)*10000+MONTH(dt)*100+DAY(dt) sysdateInt
FROM
  -- Test Data
  (SELECT  GETDATE() dt) a ) utl

The way I wrote this, makes it usefull as a subquery or a joined query:

SELECT
  Ent.* ,
  CASE
    WHEN Ent.endDate  IS NOT NULL
    AND Ent.endDate-1 < sysdateInt
    THEN Ent.endDate-1
    ELSE sysdateInt
  END refEndDateEntity ,
  utl.sysdateInt
FROM
  SomeEntity Ent,
  ( SELECT  YEAR(DT)*10000+MONTH(dt)*100+DAY(dt) sysdateInt
FROM
  -- Test Data
  (SELECT  GETDATE() dt) a ) utl;

To convert a bigint to a date, you can do the following:
CONVERT(DATETIME, CONVERT(CHAR(8), ent.endDate))

However, I found that although this works in a select clause, in the where-clause this would run into a "Data Truncation" error. Maybe it is due to the use of SqlDeveloper and thus a JDBC connection to SqlServer, but I'm not so enthousiastic about the error-responses of SqlServer... I assume the error has to do with the fact that it has to do with the fact that SqlServer has to interpret a column-value of a row when it did not already selected it, that is when evaluating wheter to add the row (or not) to the result set. So to make it work I added the construction as a determination value in the select clause of a 1:1 view on the table, and use that view in stead of the table. Then the selected value can be used in the where clause.