0

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.

see here,

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:

enter image description here

Here are the connection details as reported in Management Studio for the SQL Server instance I cannot connect to from outside of Management Studio:

enter image description here

Thanks very much for any help with this - my objective is to connect to the database from Python.

Robin

  • Have you checked SQL Server Configuration Manager? It sounds like it could be a problem with one or more Client Protocols being disabled. – Matt May 28 '15 at 13:13
  • Please open the UDL file in notepad and paste it contents (masking Userid/passwords) – Spörri May 28 '15 at 14:28
  • Thanks for the help. This is the UDL file that works: [oledb] ; Everything after this line is an OLE DB initstring Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=FSSFoodFeed;Data Source=FSA003379\SQLEXPRESS The one that doesn't looks like this: [oledb] ; Everything after this line is an OLE DB initstring Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Data Source=FSA003379\ROBINS_SERVER Note that these files were create by creating a blank file with extension udl and selecting options from the "connection" tab – RobinL May 28 '15 at 15:20
  • I have looked into the configuration manager - here are some screenshots: imgur.com/a/EjwwP – RobinL May 28 '15 at 15:25
  • Is your eval instance allowing remote connections? Also, since you can connect to the instance using SSMS directly, check the SQL error logs, they may shed some light on why connections are failing. – SQLRockstar May 28 '15 at 19:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.