The End user will use the Validation application on the R Drive.
However a NEW user will often require the following:
SQLNCLI Driver required
The database connections require the SQL Client Driver to be installed on the system running the code. Typical error from validation code
Traceback (most recent call last):
File "val.py", line 31, in <module>
File "rr\database\sqlserver.pyc", line 9, in connect
File "rr\database\ado.pyc", line 54, in connect
File "adodbapi\adodbapi.pyc", line 118, in connect
adodbapi.apibase.OperationalError: (com_error(-2147352567, 'Exception occurred.', (0, u'ADODB.Connection', u'Provider cannot be found. It may not be properly installed.', u'C:\\Windows\\HELP\\ADO270.CHM', 1240655, -2146824582), None),'Error opening connection to "Provider=SQLNCLI11;Data Source=RR-SQL-Live;Initial Catalog=RenalReg;Integrated Security=SSPI;"')
This driver may not be installed on some desktops and usually will not be installed on the servers by default. Download available from Microsoft site in the SQL Server Feature pack for SQL Server 2012 SP1 https://www.microsoft.com/en-gb/download/details.aspx?id=35580
Management Studio Installer
When installing SQL Management Studio it will try to install the SQL Client Driver if that is already installed it will usually fail with an error "user exists". The solution is to uninstall SQL Client Driver before installing SQL Management Studio.