IRIS Startup Failure - SQL Server does not exist or Access Denied Windows 7 & 10

When opening IRIS the user may encounter the following error message:

This is normally caused by one of 5 things, the:

1. • SQL Server Service not running

   • Windows Firewall blocking access

   • SQL Server Network Protocols

   • SQL Server Browser not running

   • SQL Server being set to (local) on a network version

Below are the steps to check for each of these cases.

SQL Server Service not Running

1. Click Start, All Programs, Microsoft SQL Server 2008 R2, Configuration Tools, SQL Server Configuration Manager.

2. From the open window select the SQL Server Services option.

3. Right-click on the option for your SQL Service, by default this is SQL Server (IRISPRACTICE) but this can include variations such as SQL Server (SQLEXPRESS) and may not always appear as the example.

4. Select the option to Start, once the Service State shows Running you can close the window and retry the IRIS Main Menu.

Back to top

Windows Firewall blocking access

In some cases the Windows Firewall on the server may be blocking access to IRIS from the workstations. In these cases it may be necessary to set exclusions for the SQL Server within the Windows Firewall.

• It assumed that the default posts 1433 and 1434 are in use by SQL Server.  Please refer to Understanding SQL Server TCP Ports to establish which ports are in use.

1. Click Start, Control Panel.

2. Double-click Windows Firewall.

3. Select Advanced Settings.

4. Click Inbound Rules and then click New Rule.

5. Select Port and then click Next.

6. Specify the relevant TCP Port.

•  Port Number 2345 is used for illustration purposes and will not reflect the actual TCP Port in use.

7. Ensure TCP is selected and in the Specify Local Ports enter 2345.

8. Click Next.

9. Make sure Allow the connection is selected and click Next.

10. Select all three options and click Next.

11. Name the rule and click Finish.

12. You now need to repeat this process to specify an Outbound Rule.

13. Click Outbound Rule and then click New Rule repeat steps above.

• An Inbound and Outbound Firewall Rule has been configured for the SQL Installation in use by the IRIS Software.

Back to top

SQL Server Network Protocols

1. Ensure everyone is logged out of IRIS.

2. Log onto the server.

3. Click Start, All programs, Microsoft SQL Server, Configuration Tools, SQL Server Configuration Manager.

4. Go to SQL Server Network Configuration – Protocols for IRISPRACTICE (assuming your SQL Server is IRISPRACTICE).

5. If Shared Memory, Named Pipes or TCP/IP are showing as Disabled then right-click on them and select Enable.

6. Click OK on the warning message:

7. Once the relevant protocols are showing as Enabled, go to SQL Server Services.

8. Right-click on SQL Server (IRISPRACTICE) and select Restart.

Back to top

SQL Server being set to (local) on a network version

1. Click Start, Run.

2. Type in cmd and click OK.

3. Type in cd\ and press Enter.

4. Type in cd IRIS and press enter (this assumes the IRIS folder is in C:\IRIS\).

5. Type in iCoreShowDBInfo and press Enter:

6. The DataSource is the full SQL Server name.

7. If the DataSource starts with (local) then this will need to be changed to the name of the server.

8. Type in hostname and press Enter.

9. Type in createpracticelogin hostname\instance IRIS and press enter (where hostname is the result from step 8, instance is the sql server instance name and IRIS is the Initial Catalog).

10. Now if you rerun iCoreShowDBInfo the DataSource should now include the server name:

Back to top

SQL Server Browser not running

1. Ensure everyone is logged out of IRIS.

2. Log onto the server.

3. Click Start, All programs, Microsoft SQL Server, Configuration Tools, SQL Server Configuration Manager.

4. Go to SQL Server Services.

5. If SQL Server Browser is listed as Stopped, right-click on it and select Start.

Back to top