nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Installing SQL Server Express and Using It with JMP

Eric_Hill

Here is a link to the instructions for installing SQL Server Express on your Windows laptop for demoing Query Builder without the need for network connections. FYI, it is behind the SAS firewall and thus will require a VPN connection:

http://sww.sas.com/~sasewh/SQLServerExpress.html

Secondly, here are the instructions for getting the ODBC driver for SQL Server installed (which you should not need to do if you installed SQL Server Express) and connecting the to the instance of SQL Server Express that you installed. This is also behind the SAS firewall:

http://sww.sas.com/~sasewh/SQLServerODBCConnection.html

If you have questions or problems, contact chris.kirchberg@jmp.com or eric.hill@jmp.com.

Comments

Peter_Hersh

Hey Eric,

The One Drive link does not seem to work any more for the SQBTest.bak folder.

Do you have a new location?

Thanks,

Pete

wendytseng

\\jmpdev2\public\SQLServer

Also make sure you click on the hidden "OK" button when you restore the DB. Screenshot below.

Restore Database.jpg