You create a data source name (DSN) to save database setup information, so you can open a connection to the SQL Server database without re-entering the server information.

This brought up a dialog to set up the ODBC connection. After selecting the System DNS tab, I entered "ViewComposerDB" for the name of the ODBC DNS Setup text box, described it as the View Composer ...

Another tool that you should consider when first taking ownership of a database server is sp_Blitz. This tool will identify common problems with the way SQL Server databases are setup.

If when installing SolidWorks, Microsoft SQL Server fails to install, first change block sizes and the instance name and see. More solutions here.

Although this next step might have been set for other reasons, you must have a server firewall rule setup to allow incoming SQL connections from your client to your Azure SQL database.

SQL Servers allow the import or export of database diagrams to another database. All the information related to a database is stored in the dtproperties table. Therefore, to import or export a ...