IRIS Startup failure - SQL Server does not exist or Access Denied

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

   • SQL Server Network Protocols

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

   • Windows Firewall blocking access

   • SQL Server Browser not running

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

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

Windows Firewall blocking access

1. Click Start, Control Panel.

2. Open the Windows Firewall.

3. Click the Exceptions tab.

4. Click Add Port.

5. In the Name box enter SQL.

6. In the Port number box enter 1433.

7. Select the TCP option.

8. Click OK.

9. Click Add Port.

10. In the Name box enter SQL.

11. In the Port number box enter 1434.

12. Select the UDP option.

13. Click OK.

14. Click Add Program.

15. Click Browse.

16. Browse to the SQL Server executable file in Program Files.
    

17. The default locations for this are:

1. • For SQL 2005: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn

   • For SQL 2008: C:\Program Files\Microsoft SQL Server\ MSSQL10.IRISPRACTICE\MSSQL\Binn

17. Select sqlservr.exe and click Open.

18. Click OK.
    

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