I am using a SQL Server Management Console and the SQL Server 2016 Evaluation edition trying to connect a local server on Windows 10. I am connecting to an Azure cloud instance cluster because I have a local instance I would like but also connecting with the same error. I have enabled my services: https://docs.microsoft.com/en-us/sql/master-data-services/install-windows/web-application-requirements-master-data-services?view=sql-server-2017. I get the error message:

Unable to connect to localhost. The target server does not have the SMTP service installed. You cannot manage an IIS 7.5 Web or FTP server by using Internet Information Services (6.0) Manager.

I am taking a class of my SQL and can't get a server up. I have a lot of SQL experience in MYSQL which I can just use the console. I'm a administrator and went to the manage.iss.net for the set-up but on localhost:55539 I don't know the login. Also, checked .NET on my machine to be current with running on a new Windows 10. When I look for Windows Authorization on settings I don't think they kept it with this home edition operating system. I am running 5 programs at once to find the right setting I need.I can see that I am running when I look at my services. enter image description here

enter image description here

enter image description here

  • Are you quite sure that you're launching SQL Server Management Studio? From the error message, it appears that you're actually launching Internet Information Services (6.0) Manager. – Charles Burge Apr 15 at 0:31
  • Yes. When I use SQL Server to set-up my database it complains my server isn't correct and turn on web services. The problem for not connecting is what is above. – April Randolph for IEEE Apr 15 at 0:50
  • @Charles Burge I updated the applications that are all being used to get SQL Server 2016 working – April Randolph for IEEE Apr 26 at 20:05
  • Why is the logon for NT AUTHORITY\ANONYMOUS LOGON? You must have created an administrator login when installing SQL Server. If you have not created your login when installing SQL Server, then this post might help, but it might be easier to uninstall and reinstall, not skipping the steps of creating logins. You also don't need Active Directory for a single-computer installation and omitting it might avoid some complexities. – harrymc May 1 at 6:03
  • @harrymc I am the administrator using the correct admin server address. Where that is coming from is only in the message. I don't know why it would mean anything but connecting to an administrator account because that's all I created. Also, I have launched this before by needing to start the deamon and you'll notice that has a logon unlike the other authorizations. – April Randolph for IEEE May 4 at 15:40

As you can login locally to SQL Server, but only experience the problem when going through Active Directory, there is something lacking with your domain login.

There are multiple reasons for such a problem. A couple of them are listed below:

  • You need to grant the AD domain the right to login to SQL Server.
    To add the login to a fixed database role, you could use:

    USE YourDatabase
    ALTER ROLE db_owner ADD MEMBER 'DOMAIN\login'

    For more details and an alternative using the GRANT command, see the post
    Why Does A/D Account Need SQL Server Login?

  • Some sources suggest that problems might arise when trying to login to SQL Server from a different Windows login, as SSMS is pretty touchy on this point. It is worth checking if this is indeed the problem.

  • So I don't understand as I use older SQL Server this is a database created in a SQL Management Configuration with a wizard so I can't get to it from commandline. I've administered the Database but can't seem to get create database to be authenticated in this case with SQL Server 2016 Eval Edition. – April Randolph for IEEE May 5 at 20:36
  • The above is information that can help, but making it work needs local access, which only you have. – harrymc May 5 at 21:13
  • I just added a Rule. The question is what setting I want in this specific kind of out dated software. – April Randolph for IEEE May 5 at 21:58

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.