locked
Remote Connection Error RRS feed

  • Question

  • Hi all,

    Just getting started with SQL Server 2012.

    I've managed to install, configure, set up users, set permissions, enable TCP/IP and all that, and I can connect to the database locally using the Server Management Studio.
    But when I try to connect to the database using SQL server credentials (not Windows) from Visual Studio on another computer, I get an error in the event log saying:

    "Login failed for user 'DOMAIN\SERVER$'. Reason: Could not find a login matching the name provided. [CLIENT: 192.168.0.2]"

    Obviously, the connection fails.
    (If it isn't obvious, this is not a SQL User, but rather a COMPUTER.)

    EDIT: Now the server just refuses to start altogether if I enable TCP:

    04/14/2012 16:05:13,spid13s,Unknown,SQL Server could not spawn FRunCommunicationsManager thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.
    04/14/2012 16:05:13,spid13s,Unknown,Error: 17120<c/> Severity: 16<c/> State: 1.
    04/14/2012 16:05:13,spid13s,Unknown,Could not start the network library because of an internal error in the network library. To determine the cause<c/> review the errors immediately preceding this one in the error log.
    04/14/2012 16:05:13,spid13s,Unknown,Error: 17826<c/> Severity: 18<c/> State: 3.
    04/14/2012 16:05:13,spid13s,Unknown,TDSSNIClient initialization failed with error 0x2740<c/> status code 0x1. Reason: Initialization failed with an infrastructure error. Check for previous errors. Only one usage of each socket address (protocol/network address/port) is normally permitted.
    04/14/2012 16:05:13,spid13s,Unknown,Error: 17182<c/> Severity: 16<c/> State: 1.
    04/14/2012 16:05:13,spid13s,Unknown,TDSSNIClient initialization failed with error 0x2740<c/> status code 0xa. Reason: Unable to initialize the TCP/IP listener. Only one usage of each socket address (protocol/network address/port) is normally permitted.
    04/14/2012 16:05:13,spid13s,Unknown,Error: 17182<c/> Severity: 16<c/> State: 1.
    04/14/2012 16:05:13,spid13s,Unknown,Server TCP provider failed to listen on [ 'any' <ipv6> 49173]. Tcp port is already in use.
    04/14/2012 16:05:13,spid13s,Unknown,Error: 26023<c/> Severity: 16<c/> State: 1.

    I've tried changing port, as well, but then the message just repeats for the new port.

    Any ideas what's wrong? Thanks.

    • Edited by Athena Saki Saturday, April 14, 2012 2:18 PM I'm scrwed >_< Why are Microsoft software so difficult to use !?!
    Saturday, April 14, 2012 1:14 PM

Answers

  • I have now installed SQL Server 2008 R2 and removed 2012.

    For some reason, port 49172 still fails to work. However, when changing the port to 9172, all is fine and dandy, so I'll be going with that for now.

    • Proposed as answer by Peja Tao Monday, April 16, 2012 7:36 AM
    • Marked as answer by Athena Saki Monday, April 16, 2012 8:59 AM
    Saturday, April 14, 2012 9:01 PM

All replies

  • you're saying that you're connecting with SQL login credentials and not Windows Authentication?

    did you enabled Mixed Mode authentication on the SQL Server ?


    if you don't know where do find this setting - see this page for SQL 2000 How to set up Mixed Mode security (Enterprise Manager) which still valid for SQL 2012
    Saturday, April 14, 2012 4:17 PM
  • Yes to both. I can connect just fine with SQL credentials using the Server Management Studio.
    Saturday, April 14, 2012 4:20 PM
  • I've seen that you've asked the same question/issue in TFS forum but included additional info. Can't connect to TFS server

    see my answer there if it is effectively the same issue (TFS 2010 does not support SQL 2012)


    Saturday, April 14, 2012 4:29 PM
  • True, I am experiencing problems with the team foundation server, but I also cannot connect to the database, ignoring the foundation server.

    I don't know if the problems are related, so I made two issues. It is important that I get at least the database up and working. The team foundation server is secondary.

    Saturday, April 14, 2012 4:32 PM
  • True, I am experiencing problems with the team foundation server, but I also cannot connect to the database, ignoring the foundation server.

    I don't know if the problems are related, so I made two issues. It is important that I get at least the database up and working. The team foundation server is secondary.

    you wouldn't be able to connect to the database as it does not exists or had not setup completely / correctly because the configuration of the TFS failed as you've described in the other thread.

    Just for clarification, could you connect to the SQL 2012 using SSMS and check if the database for Team Foundation Server (TFS) does exist - I think the name of the database matches the name of the default collection. At least you can interpret if any database is coming from TFS or not.

    Saturday, April 14, 2012 4:41 PM
  • ----
    you wouldn't be able to connect to the database as it does not exists or had not setup completely / correctly because the configuration of the TFS failed as you've described in the other thread.
    ----
    This problem and the team foundation server problem are different things. I am not only using sql server for tfs, but for another database, as well.
    When I say I can't connect, I obviously mean I can't connect to sql server (from outside the local machine).
    I can get it into it using SSMS and browse all databases just fine.

    ----
    Just for clarification, could you connect to the SQL 2012 using SSMS and check if the database for Team Foundation Server (TFS) does exist - I think the name of the database matches the name of the default collection. At least you can interpret if any database is coming from TFS or not.
    ----
    I see two databases from tfs: Tfs_Configuration and Tfs_DefaultCollection.

    EDIT:
    I also see that Tfs_Configuration has been populated with tables while Tfs_DefaultCollection has not.
    • Edited by Athena Saki Saturday, April 14, 2012 4:48 PM
    Saturday, April 14, 2012 4:46 PM
  • I just checked with Visual Studio 2010 Premium that I can connect to a SQL 2012 on another server using Windows Authentication.

    Could you connect to SQL 2012 from Visual Studio 2010 using Windows Authentication?


    Saturday, April 14, 2012 4:56 PM
  • I know for sure this problem is recent. I have been able to connect successfully to the database before using sql credentials.
    I don't know why it fails to work now, however.

    Also, I am afraid I cannot connect using Windows credentials. I do not have any domain computer that is using any domain user login.
    The alternative would be to try installing Visual Studio 2010 on the server... I could try it if it helps.

    Saturday, April 14, 2012 4:59 PM
  • I have now installed SQL Server 2008 R2 and removed 2012.

    For some reason, port 49172 still fails to work. However, when changing the port to 9172, all is fine and dandy, so I'll be going with that for now.

    • Proposed as answer by Peja Tao Monday, April 16, 2012 7:36 AM
    • Marked as answer by Athena Saki Monday, April 16, 2012 8:59 AM
    Saturday, April 14, 2012 9:01 PM