2

I installed, SQL server 2016 on my local machine with SSIS feature.

I am able to connect Analysis instance but when I am trying to connect to Database Engine it is giving below error.

enter image description here

Services start error

enter image description here

Event Viewer log-1

enter image description here

Event Viewer log-2

enter image description here

  • is sql server service started on the server that you are trying to connect ? – Kin Shah Dec 29 '16 at 14:28
  • The remote computer refused the connection - looks like a firewall issue. – Sean Gallardy Dec 29 '16 at 14:43
  • 1
    maybe check sql browser service is running. – Darren Dec 29 '16 at 15:00
  • 1
    are remote connections enabled? – McNets Dec 29 '16 at 15:08
  • I check SQL server and SQL server agent service are not running. Tried to start it but get error. (ss from error and event log are attached in question.. – cjs Dec 29 '16 at 16:02
0

Make sure services are running in SQL config manager. If they are, make sure there is an exception for whatever TCP/IP port is being used under protocols in SQL server network configuration

Check and make sure the accounts you created to run the SQL services have the proper permissions assigned to them

https://msdn.microsoft.com/en-us/library/ms143504.aspx

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.