Can`t connect so SQL server. Error in get connection.

D_Petrov

<p>Hello,</p>
<p>I use BIRT Version: Luna Release (4.4.0).</p>
<p>Currently everything with Data sources was OK (Win Server 2003+SQL Server 2005+Apache Tomcat 6.0.41 Server), until I switched to Win Server 2012 and SQL Server 2012 and Apache Tomcat 8.5.6 Server.</p>
<p>I am not able to connect from my local BIRT installation for development to the new server.</p>
<p>What is done so far:<br>
1 SQL Browser service is running.</p>
<p>2. SQL Server and Browser are added in Firewall.</p>
<p>3. The user, which I am using has all required rights to the DB and is using SQL Server Authentication.</p>
<p>4. <strong><span style="font-family:calibri, sans-serif;"><span style="font-size:11pt;">sqljdbc4.jar </span></span></strong>driver is installed and sys variable is pointing to it.</p>
<p>

micajblock

<p>From the image your database URL is wrong.</p>

D_Petrov

<p>Hello Mica,</p>
<p> </p>
<p>Thanks for the reply.</p>
<p>Finally I managed to fix the problem and it was purely SQL related.</p>
<p>New SQL installation, newly created DBs and users, afterwards backups were restored over these DBs.</p>
<p>The user from the backups was the same like the one created on the new instance.</p>
<p>So I deleted it and created it again and bingo.</p>
<p> </p>
<p>Regards,<br>
Dragomir</p>