On my local machine I have installed:
Microsoft SQL Server Enterprise Evaluation Edition (64-bit) 12.0.4100 SP1
Microsoft SQL Server Express Edition (64-bit) 12.0.2000 RTM
I installed both using the default install options, and have restored different databases to each. In SQL Server 2014 Management Studio, I can access both databases on their separate servers, and run queries against them.
I am able to connect to a database in Express from Python and by using the interface brought up when you open a
.udl file see here.
However, I am unable to connect to the SQL Server Evaluation Edition server from outside of Management Studio and I can't figure out why. My machine can 'see' the server but once I select the server, it cannot see any of the databases in the server. When I click 'select database on the server' it brings up a "login timeout expired" warning. In contrast, when I follow the same steps after selecting
SQLExpress everything works as expected.
Are there additional settings I need to change in SQL Server to enable access? I imagine there's something quite simple I have neglected to do as I'm a SQL Server novice.
Here are the connection details as reported in Management Studio for the SQL Express instance I can successfully connect to:
Here are the connection details as reported in Management Studio for the SQL Server instance I cannot connect to from outside of Management Studio:
Thanks very much for any help with this - my objective is to connect to the database from Python.