Add a db (which already has tSQLt installed) to SQL Test

Redshift

I hadn't used SQL Test since installing it on my latest laptop.

I restored my development database, which already contains tSQLt into an instance and I can do all my normal development activities with the exception of using SQL Test.

The database doesn't appear in the list of dbs in the left hand pane of SQL Test and if I try to add it I get the following error message:-

SQL Test could not install the tSQLt Framework on mydatabasename

Any ideas how I add a database that already has tSQLt and a host of tests back into SQL Test.

I'm using SSMS v17.9.1

Eddie D

Hi,  thank you for your forum post.

What version of SQL Test and version of the tSQLt framework you are using?

Is there any further on-screen information as to why the test framework could not be installed?

I assume SQL CLR for the SQL Instance is enabled?

The restored development database, dependent upon the version of SQL Test and version of the tSQLt framework, does the database have Set TRUSTWORTHY ON?

• If using V1.7.3 or earlier, or a SQL 2017 or later database, Set TRUSTWORTHY ON for the database.  If using V1.7.4 or later, this setting is no longer a requirement on pre-SQL 2017 databases due to an upgrade of the tSQLt framework to V1.0.5873.27393.

Many thanks
Eddie

Redshift

Thanks Eddie,

The issue was that SQL CLR wasn't enabled on the instance.

Cheers

Neil

Eddie D

Hi Neil

Great news.  Good to read that all is now OK.

Many Thanks
Eddie