none
Подключение к SQL серверу: error 26 RRS feed

  • Вопрос

  • Сервер установлен на том же ПК где и приложение. Сервер настроен АНАЛОГИЧНО домашнему (где разрабатывалось ПО и где оно успешно запускается), аналогично всем инструкциям в Интернете.
    При создании *.udl файла коннект проходит на УРА. При подключении посредством Managment студии - аналогично (и виндовс аутентификации и логин\пароль). При тестировании с помощью telnet - порт 1433 открыт. netstat - порт слушается, все окей.<br><br>
    Но при запуске приложения (С# + ADO.NET) получаем следующее.
    При любой строке подключения (connection string) возникает следующая ошибка
    http://i.piccy.info/i5/22/32/1713222/ERROR.jpg

    Примеры строк подключения:
    Integrated Security=SSPI;Persist Security Info=False;User ID=sa;Initial Catalog=aeroscan;Data Source=AERO-88\SQLEXPRESS
    Persist Security Info=False;User ID=sa;Initial Catalog=aeroscan;Data Source=AERO-88\SQLEXPRESS
    Persist Security Info=False;User ID=sa;password=123;Initial Catalog=aeroscan;Data Source=AERO-88\SQLEXPRESS
    Network Library=dbmssocn;Persist Security Info=False;User ID=sa;password=123;Initial Catalog=aeroscan;Data Source=localhost,1433\SQLEXPRESS
    Network Library=dbmssocn;Persist Security Info=False;User ID=sa;password=123;Initial Catalog=aeroscan;Data Source=localhost,1433
    
    В коде коннект вызывается вот так (предварительно присвоив connectionString вышесказанные значения):
     SqlConnection conn = new SqlConnection(connectionString);
     conn.Open();
     SqlCommand myCommand = conn.CreateCommand();
     ...

    ERRORLOG
    2011-07-08 20:02:51.04 Server      Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) 
    Jul  9 2008 14:43:34 
    Copyright (c) 1988-2008 Microsoft Corporation
    Express Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)
    2011-07-08 20:02:51.40 Server      (c) 2005 Microsoft Corporation.
    2011-07-08 20:02:51.45 Server      All rights reserved.
    2011-07-08 20:02:51.45 Server      Server process ID is 1324.
    2011-07-08 20:02:51.45 Server      Authentication mode is MIXED.
    2011-07-08 20:02:51.45 Server      Logging SQL Server messages in file 'c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Log\ERRORLOG'.
    2011-07-08 20:02:51.62 Server      This instance of SQL Server last reported using a process ID of 880 at 08.07.2011 20:01:20 (local) 08.07.2011 17:01:20 (UTC). This is an informational message only; no user action is required.
    2011-07-08 20:02:51.62 Server      Registry startup parameters: 
    -d c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\master.mdf
    -e c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Log\ERRORLOG
    -l c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\mastlog.ldf
    2011-07-08 20:02:52.01 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
    2011-07-08 20:02:52.01 Server      Detected 2 CPUs. This is an informational message; no user action is required.
    2011-07-08 20:02:55.82 Server      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.
    2011-07-08 20:03:00.03 Server      Node configuration: node 0: CPU mask: 0x00000003 Active CPU mask: 0x00000003. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
    2011-07-08 20:03:02.64 spid7s      Starting up database 'master'.
    2011-07-08 20:03:04.56 spid7s      Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
    2011-07-08 20:03:06.26 spid7s      FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'SQLEXPRESS'.
    2011-07-08 20:03:07.34 spid7s      SQL Trace ID 1 was started by login "sa".
    2011-07-08 20:03:07.57 spid7s      Starting up database 'mssqlsystemresource'.
    2011-07-08 20:03:07.68 spid7s      The resource database build version is 10.00.1600. This is an informational message only. No user action is required.
    2011-07-08 20:03:09.07 spid10s     Starting up database 'model'.
    2011-07-08 20:03:09.17 spid7s      Server name is 'AERO-88\SQLEXPRESS'. This is an informational message only. No user action is required.
    2011-07-08 20:03:09.32 spid7s      Informational: No full-text supported languages found.
    2011-07-08 20:03:09.32 spid7s      Starting up database 'msdb'.
    2011-07-08 20:03:09.60 Server      A self-generated certificate was successfully loaded for encryption.
    2011-07-08 20:03:09.78 Server      Server is listening on [ 'any' <ipv4> 1433].
    2011-07-08 20:03:09.78 Server      Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\SQLEXPRESS ].
    2011-07-08 20:03:09.78 Server      Server local connection provider is ready to accept connection on [ \\.\pipe\MSSQL$SQLEXPRESS\sql\query ].
    2011-07-08 20:03:09.78 Server      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, restart SQL Server using the trace flag 7806. This is an informational message only. No user action is required.
    2011-07-08 20:03:09.81 Server      The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b, 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.
    2011-07-08 20:03:09.81 Server      SQL Server is now ready for client connections. This is an informational message; no user action is required.
    2011-07-08 20:03:10.71 spid10s     Clearing tempdb database.
    2011-07-08 20:03:12.96 spid10s     Starting up database 'tempdb'.
    2011-07-08 20:03:13.74 spid13s     The Service Broker protocol transport is disabled or not configured.
    2011-07-08 20:03:13.76 spid13s     The Database Mirroring protocol transport is disabled or not configured.
    2011-07-08 20:03:14.06 spid13s     Service Broker manager has started.
    2011-07-08 20:03:14.06 spid7s      Recovery is complete. This is an informational message only. No user action is required.
    
    Настройки сервера:
    http://i.piccy.info/i5/08/86/1718608/err1.jpg
    http://i.piccy.info/i5/01/86/1718601/err2.jpg
    http://i.piccy.info/i5/02/86/1718602/err3.jpg
    http://i.piccy.info/i5/03/86/1718603/err4.jpg
    
    netstat
    C:\>netstat -n -a
    
    Активные подключения
    
    Имя Локальный адрес Внешний адрес Состояние
    TCP 0.0.0.0:23 0.0.0.0:0 LISTENING
    TCP 0.0.0.0:135 0.0.0.0:0 LISTENING
    TCP 0.0.0.0:445 0.0.0.0:0 LISTENING
    TCP 0.0.0.0:1110 0.0.0.0:0 LISTENING
    TCP 0.0.0.0:1433 0.0.0.0:0 LISTENING
    TCP 127.0.0.1:1025 127.0.0.1:1026 ESTABLISHED
    TCP 127.0.0.1:1026 127.0.0.1:1025 ESTABLISHED
    TCP 127.0.0.1:1378 127.0.0.1:1379 ESTABLISHED
    TCP 127.0.0.1:1379 127.0.0.1:1378 ESTABLISHED
    TCP 127.0.0.1:1380 127.0.0.1:6039 ESTABLISHED
    TCP 127.0.0.1:1394 127.0.0.1:1395 ESTABLISHED
    TCP 127.0.0.1:1395 127.0.0.1:1394 ESTABLISHED
    TCP 127.0.0.1:1399 127.0.0.1:1400 ESTABLISHED
    TCP 127.0.0.1:1400 127.0.0.1:1399 ESTABLISHED
    TCP 127.0.0.1:1489 127.0.0.1:1433 TIME_WAIT
    TCP 127.0.0.1:6039 0.0.0.0:0 LISTENING
    TCP 127.0.0.1:6039 127.0.0.1:1380 ESTABLISHED
    TCP 192.168.1.43:139 0.0.0.0:0 LISTENING
    TCP 192.168.1.43:1376 94.153.233.212:5938 ESTABLISHED
    TCP 192.168.1.43:1494 192.168.1.43:1433 TIME_WAIT
    UDP 0.0.0.0:445 *:*
    UDP 0.0.0.0:500 *:*
    UDP 0.0.0.0:1029 *:*
    UDP 0.0.0.0:1381 *:*
    UDP 0.0.0.0:1434 *:*
    UDP 0.0.0.0:4500 *:*
    UDP 127.0.0.1:123 *:*
    UDP 127.0.0.1:1900 *:*
    UDP 192.168.1.43:123 *:*
    UDP 192.168.1.43:137 *:*
    UDP 192.168.1.43:138 *:*
    UDP 192.168.1.43:1900 *:*
    
    telnet
    http://i.piccy.info/i5/33/86/1718633/err5.jpg
    
    *.UDL
    http://i.piccy.info/i5/36/86/1718636/err6.jpg
    
    ping
    C:\Documents and Settings\Администратор>ping AERO-88
    
    Обмен пакетами с Aero-88 [192.168.1.43] по 32 байт:
    
    Ответ от 192.168.1.43: число байт=32 время<1мс TTL=128
    Ответ от 192.168.1.43: число байт=32 время<1мс TTL=128
    Ответ от 192.168.1.43: число байт=32 время<1мс TTL=128
    Ответ от 192.168.1.43: число байт=32 время<1мс TTL=128
    
    Статистика Ping для 192.168.1.43:
    Пакетов: отправлено = 4, получено = 4, потеряно = 0 (0% потерь),
    Приблизительное время приема-передачи в мс:
    Минимальное = 0мсек, Максимальное = 0 мсек, Среднее = 0 мсек

    Помогите, сейчас сдохну
    







    11 июля 2011 г. 7:27

Ответы

Все ответы