'NT ANONYMOUS LOGON AUTHORITY' failure in SQL Server 2012 on remote server

Asked

Viewed 1,158 times

6

I have a legal application running on my local server. I made some changes to it and prepared to publish an approval environment for testing. How we are migrating local banks and servers to a new one data center, I decided to test the new application already pointing to the bank in the new data center. The point is that now, by changing my Connection string for the new server and database, when running the application in Visual Studio I get the following error:

Erro de Servidor no Aplicativo '/'
Falha no logon do usuário 'integracao'.

Connectionstring

    public const string CONNECTION_STRING = @"Data Source=ITVRS-D08;Initial Catalog=Teste; User Id=integracao;Password=integracao;";
    public const string DEPLOYMENT_CONNECTION_STRING = @"Data Source=ITVRS-D08;Initial Catalog=Teste; User Id=integracao;Password=integracao;";

Connectionstring of the application that was running locally

    public const string CONNECTION_STRING = @"Data Source=ITVRS-r08;Initial Catalog=Integracao; User Id=integracao;Password=integracao;";
    public const string DEPLOYMENT_CONNECTION_STRING = @"Data Source=ITVRS-R08;Initial Catalog=Integracao; User Id=integracao;Password=integracao;";

The user 'integration' was created on the new server with the same permissions and such. It’s not a permission issue, I believe, as all permissions have already been granted.

The only difference in the environment is that the local server is SQL Server 2008 and in the new data center is SQL Server 2012.

Does it have anything to do with that? What else can I check to get my application running?

c# asp.net sql-server-2012

  • You can log in with this user through SQL Server Management Studio?

  • On any of the servers I soon by windows Authentication

  • but I can also log in by this user in SQL @Ciganomorrisonmendez

  • I still have the problem...

  • In the test with Microsoft SQL Server Management Studio, do you have to enter the remote machine to test? Or can you log in via your local machine? The message returned by the application in Visual Studio does not clarify anything.

  • I tried with another application too and the same thing happens. In the local database I can run normally but changing the connection string to the datacenter with a replica of the database, user and etc gives this error to any user I try

  • Yes, the datacenter I only access remotely.

  • When you say you can connect via Management Studio, you are connecting with your DBA user ? in the database ? the application user can connect in the remote database with his login and his password ? via management studio ?

Show 3 more comments

3 answers

4

Check the settings of SQL TCP services at:All SQL Managment programs SQL Server Configuration Tools Configurartion SQL Network Configuration Protocols for MSSQLSERVER TCP/IP in the ip address tab must contain IP Server and Enabled:yes at all, this also directly implies in the form that SQL has been installed as local system authorities, internet and etc. This is my connection string and works perfectly on network. An effective test is to open your sql on your computer and try to connect to the server by Managment studio.

provider connection string="Data Source=.;Initial Catalog=banco;Persist Security Info=True;User ID=sa;Password=senha

  • when u say you can connect via Management Studio, vc is connecting with your DBA user ? in the database ?

  • the application user can connect in the remote database with his login and his password ? via management studio ?

  • I say a first test to know if at least the SQL network service is working by Management, otherwise you would not even have to worry about the error in the application.

  • I open local in my management studio the server yes, by windows Authentication. Remotely on the server I can connect both by windows Authentication and by login and password.

  • Still with the Pfvictor problem?

1

Possibly port 1433 on your remote server is not open, or remote SQL Server is not configured to accept remote connections.

To configure remote access on the server, follow the steps in this link.

  • one of the steps says: "mark or clear the Allow remote connections to this server checkbox"??

  • The box was already marked, that is, allowing remote connections.

  • Look at the Firewall, then.

  • What I need to check on the firewall?

  • See if there is an exception for port 1433, or for SQL Server itself.

  • Firewall everything ok too. There is no exception

  • Try now connecting from your machine’s SQL Server Management Studio to the remote server.

  • Connects @Gypsy

  • It continues the same error... with variations of the described in the question and: " User login failure 'NT AUTHORITY ANONYMOUS LOGON'."

  • But it can’t be anonymous login. It has to be that login "integration".

  • Well... the user is as I passed the question. And now regardless of the user I pass in connectionstring gives this same Anonymous Logon error

  • You said there is no exception, but there must be, the 1433 output and the 1433 input, if not, create them.

Show 7 more comments

0

Have you checked whether the remote database server allows external access to the IP in which your application is hosted? Generally database servers limit external access, making it necessary for you to add an exception to the Ips you want to have access to your server.

If this is the case, follow the details described on this page to configure your type-approval server to allow remote access: http://www.systematiza.com.br/site/? page_id=837

Browser other questions tagged c# asp.net sql-server-2012

You are not signed in. Login or sign up in order to post.