none
SqlServer2008expressTCP/Ip Connection doesn't work. RRS feed

  • 问题

  • I already enabled and config the tcp/ip and the namepipes in the service config manager. And the port for my tcp/ip connection is 1433(static).

    When I'm trying to connect the db using manage studio express with "localhost\sqlexpress" or "192.168.1.2\sqlexpress". It works. But when I swiched the Network Protocal in the connection option from "<default>" to "tcp/ip". The same connection doesn't work.

    I've already tried restart my computer or remove the dynamic port. And also enable the automic startup of SqlServerBrowser. But all of this cannot help.

    I check my system log. When the SqlServer is restarted. I found an error message came up.

    "Error 58, severity -1, state 1 was raised, but no message with that error number was found in sys.messages. If error is larger than 50000, make sure the user-defined message is added using sp_addmessage."

    Event ID:18054

    Task Type:(2)

    My os is :Windows 7 ultimate 64bit. The dbEngine is SqlServerExpressSp164-bit

    2010年3月19日 11:47

答案

全部回复

  • 不好意思,我以为只能发英文的,汗。
    2010年3月19日 11:48
  • Tried connect with 192.168.1.2,1433 instead of instance name? Double check sql server log, ensure sql is listening on port 1433.
    2010年3月19日 13:31
  • Date,Source,Severity,Message
    03/20/2010 17:29:48,spid53,Unknown,Starting up database 'lshop'.
    03/20/2010 17:29:47,spid53,Unknown,Using 'xpstar.dll' version '2007.100.1600' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
    03/20/2010 17:29:47,spid53,Unknown,Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
    03/20/2010 17:29:41,Server,Unknown,Server resumed execution after being idle 3778 seconds: user activity awakened the server. This is an informational message only. No user action is required.
    03/20/2010 15:56:01,spid13s,Unknown,Service Broker manager has started.
    03/20/2010 15:56:01,spid7s,Unknown,Recovery is complete. This is an informational message only. No user action is required.
    03/20/2010 15:56:01,spid13s,Unknown,The Database Mirroring protocol transport is disabled or not configured.
    03/20/2010 15:56:01,spid13s,Unknown,The Service Broker protocol transport is disabled or not configured.
    03/20/2010 15:56:01,spid10s,Unknown,Starting up database 'tempdb'.
    03/20/2010 15:56:01,Server,Unknown,SQL Server is now ready for client connections. This is an informational message; no user action is required.
    03/20/2010 15:56:01,Server,Unknown,The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b<c/> state: 3. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.
    03/20/2010 15:56:01,Server,Unknown,The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x490<c/> state: 16. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.
    03/20/2010 15:56:01,Server,Unknown,Dedicated administrator connection support was not started because it is disabled on this edition of SQL Server. If you want to use a dedicated administrator connection<c/> restart SQL Server using the trace flag 7806. This is an informational message only. No user action is required.
    03/20/2010 15:56:01,Server,Unknown,Server named pipe provider is ready to accept connection on [ \\.\pipe\MSSQL$SQLEXPRESS\sql\query ].
    03/20/2010 15:56:01,Server,Unknown,A self-generated certificate was successfully loaded for encryption.
    03/20/2010 15:56:00,spid10s,Unknown,Clearing tempdb database.
    03/20/2010 15:55:59,spid7s,Unknown,Starting up database 'msdb'.
    03/20/2010 15:55:59,spid7s,Unknown,Informational: No full-text supported languages found.
    03/20/2010 15:55:59,Server,Unknown,Error 58<c/> severity -1<c/> state 1 was raised<c/> but no message with that error number was found in sys.messages. If error is larger than 50000<c/> make sure the user-defined message is added using sp_addmessage.
    03/20/2010 15:55:59,Server,Unknown,Error: 18054<c/> Severity: 16<c/> State: 1.
    03/20/2010 15:55:59,spid7s,Unknown,Server name is 'DADI-PC\SQLEXPRESS'. This is an informational message only. No user action is required.
    03/20/2010 15:55:59,spid10s,Unknown,Starting up database 'model'.
    03/20/2010 15:55:58,spid7s,Unknown,The resource database build version is 10.00.2531. This is an informational message only. No user action is required.
    03/20/2010 15:55:58,spid7s,Unknown,Starting up database 'mssqlsystemresource'.
    03/20/2010 15:55:58,spid7s,Unknown,SQL Trace ID 1 was started by login "sa".
    03/20/2010 15:55:58,spid7s,Unknown,FILESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'SQLEXPRESS'.
    03/20/2010 15:55:58,spid7s,Unknown,Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
    03/20/2010 15:55:58,spid7s,Unknown,Starting up database 'master'.
    03/20/2010 15:55:58,Server,Unknown,Node configuration: node 0: CPU mask: 0x000000000000000f Active CPU mask: 0x000000000000000f. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
    03/20/2010 15:55:57,Server,Unknown,Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.
    03/20/2010 15:55:57,Server,Unknown,Detected 4 CPUs. This is an informational message; no user action is required.
    03/20/2010 15:55:57,Server,Unknown,SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
    03/20/2010 15:55:57,Server,Unknown,Registry startup parameters: <nl/>     -d C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\master.mdf<nl/>     -e C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Log\ERRORLOG<nl/>     -l C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\mastlog.ldf
    03/20/2010 15:55:57,Server,Unknown,This instance of SQL Server last reported using a process ID of 4340 at 2010/3/20 13:23:16 (local) 2010/3/20 5:23:16 (UTC). This is an informational message only; no user action is required.
    03/20/2010 15:55:57,Server,Unknown,Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Log\ERRORLOG'.
    03/20/2010 15:55:57,Server,Unknown,Authentication mode is MIXED.
    03/20/2010 15:55:57,Server,Unknown,System Manufacturer: 'Gigabyte Technology Co.<c/> Ltd.'<c/> System Model: 'P55-US3L'.
    03/20/2010 15:55:57,Server,Unknown,Server process ID is 2000.
    03/20/2010 15:55:57,Server,Unknown,All rights reserved.
    03/20/2010 15:55:57,Server,Unknown,(c) 2005 Microsoft Corporation.
    03/20/2010 15:55:57,Server,Unknown,Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64) <nl/>    Mar 29 2009 10:11:52 <nl/>    Copyright (c) 1988-2008 Microsoft Corporation<nl/>    Express Edition with Advanced Services (64-bit) on Windows NT 6.1 <X64> (Build 7600: )

    I cannot find any infomation about the tcpip connection in the log.
    2010年3月20日 9:34
  • That means tcp/ip is disabled or port number is used by other process.
    2010年3月20日 17:07