1

I am doing this tutorial of Microsoft: Basic Data Mining Tutorial

http://technet.microsoft.com/en-us/library/ms167167.aspx

I am using SQL Server 2012 and SSIS - SQL Server Integration Services but I got stuck on one problem,... it says: "Login time expired" ... it cannot connect to SQL Server...

I turned off the Windows Firewall but it didn't help. I also made sure that TCP/IP and Named Pipes are ENABLED within SQL Server...

Any ideas?

Here is a screenshot:

enter image description here

migrated from serverfault.com Dec 12 '13 at 5:43

This question came from our site for system and network administrators.

  • Try right clicking the sql server in management studio and checking the 'Connections' tab and verify "Allow remote connections to this server" is checked. – Allan S. Hansen Dec 12 '13 at 7:02
  • Is the SQL Server local or remote? Did you restart the instance after changing the TCP/IP setting? – Jon Seigel Dec 12 '13 at 14:09

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.