|
|
|
Аа-аа, что делать?
|
|||
|---|---|---|---|
|
#18+
При подключении A connection could not be established to ' ... ' - Login failed for user '...' Помогите плиз, что случилось, что делать ???? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 04.11.2002, 11:43:24 |
|
||
|
Аа-аа, что делать?
|
|||
|---|---|---|---|
|
#18+
А по конкретнее можно? а то вариантов причин очень много... например Caps Lock включен... или сервер не работает или пароль поменяли или кабель перерезали... или пользователя удалили или много еще чего... Вы локально подключаетесь или удаленно? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 04.11.2002, 11:59:00 |
|
||
|
Аа-аа, что делать?
|
|||
|---|---|---|---|
|
#18+
И при подключении локально и удаленно. Работал сервер нормально, ничего с ним не делали особенного и тут login failed. Вот errorlog файл который создается при запуске sql севера. (может по его содержанию можно что-то узнать) 2002-11-04 11:33:14.40 kernel Microsoft SQL Server 7.00 - 7.00.623 (Intel X86) Nov 27 1998 22:20:07 Copyright (c) 1988-1998 Microsoft Corporation Standard Edition on Windows NT 4.0 (Build 1381: Service Pack 6) 2002-11-04 11:33:14.42 kernel Copyright (C) 1988-1997 Microsoft Corporation. 2002-11-04 11:33:14.42 kernel All rights reserved. 2002-11-04 11:33:14.42 kernel Logging SQL Server messages in file 'E:\MSSQL7\log\ERRORLOG'. 2002-11-04 11:33:14.54 kernel initconfig: Number of user connections limited to 32767. 2002-11-04 11:33:14.54 kernel SQL Server is starting at priority class 'normal'(2 CPUs detected). 2002-11-04 11:33:14.68 kernel User Mode Scheduler configured for thread processing 2002-11-04 11:33:17.11 kernel initdata: Warning: Could not set working set size to 519040 KB. 2002-11-04 11:33:17.12 server Directory Size: 21625 2002-11-04 11:33:17.18 spid1 Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks 2002-11-04 11:33:17.18 kernel Attempting to initialize Distributed Transaction Coordinator. 2002-11-04 11:33:17.45 spid1 Failed to obtain TransactionDispenserInterface: Result Code = 0x8004d01b 2002-11-04 11:33:17.46 spid1 Starting up database 'master'. 2002-11-04 11:33:17.46 spid1 Opening file E:\MSSQL7\data\master.mdf. 2002-11-04 11:33:17.48 spid1 Opening file E:\MSSQL7\data\mastlog.ldf. 2002-11-04 11:33:17.56 spid1 Loading SQL Server's Unicode collation. 2002-11-04 11:33:17.57 spid1 Loading SQL Server's non-Unicode sort order and character set. 2002-11-04 11:33:17.64 spid1 6 transactions rolled forward in database 'master' (1). 2002-11-04 11:33:17.64 spid1 0 transactions rolled back in database 'master' (1). 2002-11-04 11:33:17.68 spid1 Starting up database 'model'. 2002-11-04 11:33:17.68 spid1 Opening file E:\MSSQL7\DATA\model.mdf. 2002-11-04 11:33:17.71 spid1 Opening file E:\MSSQL7\DATA\modellog.ldf. 2002-11-04 11:33:17.78 spid1 Clearing tempdb database. 2002-11-04 11:33:17.82 spid1 Creating file E:\MSSQL7\DATA\TEMPDB.MDF. 2002-11-04 11:33:17.92 spid1 Closing file E:\MSSQL7\DATA\TEMPDB.MDF. 2002-11-04 11:33:17.96 spid1 Creating file E:\MSSQL7\DATA\TEMPLOG.LDF. 2002-11-04 11:33:17.98 spid1 Closing file E:\MSSQL7\DATA\TEMPLOG.LDF. 2002-11-04 11:33:18.03 spid1 Opening file E:\MSSQL7\DATA\TEMPDB.MDF. 2002-11-04 11:33:18.06 spid1 Opening file E:\MSSQL7\DATA\TEMPLOG.LDF. 2002-11-04 11:33:18.42 spid1 Closing file E:\MSSQL7\DATA\TEMPDB.MDF. 2002-11-04 11:33:18.51 spid1 Closing file E:\MSSQL7\DATA\TEMPLOG.LDF. 2002-11-04 11:33:18.53 spid1 Starting up database 'tempdb'. 2002-11-04 11:33:18.53 spid1 Opening file E:\MSSQL7\DATA\TEMPDB.MDF. 2002-11-04 11:33:18.54 spid1 Opening file E:\MSSQL7\DATA\TEMPLOG.LDF. 2002-11-04 11:33:18.65 spid1 Server name is 'UCL2002'. 2002-11-04 11:33:18.65 kernel Using 'SQLEVN70.DLL' version '7.00.623'. 2002-11-04 11:33:18.65 kernel Using 'OPENDS60.DLL' version '7.00.00.0623'. 2002-11-04 11:33:18.67 ods Using 'SSNMPN70.DLL' version '7.0.623' to listen on '\\.\pipe\sql\query'. 2002-11-04 11:33:18.67 ods Using 'SSMSSO70.DLL' version '7.0.623' to listen on '1433'. 2002-11-04 11:33:18.70 ods Using 'SSMSRP70.DLL' version '7.0.623' to listen on 'UCL2002'. 2002-11-04 11:33:19.23 spid6 Starting up database 'msdb'. 2002-11-04 11:33:19.23 spid6 Opening file E:\MSSQL7\DATA\msdbdata.mdf. 2002-11-04 11:33:19.23 spid7 Starting up database 'pubs'. 2002-11-04 11:33:19.23 spid7 Opening file E:\MSSQL7\DATA\pubs.mdf. 2002-11-04 11:33:19.37 spid8 Starting up database 'Northwind'. 2002-11-04 11:33:19.37 spid8 Opening file E:\MSSQL7\DATA\northwnd.mdf. 2002-11-04 11:33:19.40 spid10 Starting up database 'Niss-ucl'. 2002-11-04 11:33:19.40 spid10 Opening file E:\MSSQL7\data\Niss-ucl_Data.MDF. 2002-11-04 11:33:19.48 spid9 Starting up database 'Garantiya'. 2002-11-04 11:33:19.48 spid9 Opening file E:\MSSQL7\data\Garantiya_Data.MDF. 2002-11-04 11:33:19.64 spid7 Opening file E:\MSSQL7\DATA\pubs_log.ldf. 2002-11-04 11:33:19.65 spid6 Opening file E:\MSSQL7\DATA\msdblog.ldf. 2002-11-04 11:33:19.75 spid10 Opening file E:\MSSQL7\data\Niss-ucl_Log.LDF. 2002-11-04 11:33:19.76 spid8 Opening file E:\MSSQL7\DATA\northwnd.ldf. 2002-11-04 11:33:19.89 spid9 Opening file E:\MSSQL7\data\Garantiya_Log.LDF. 2002-11-04 11:33:20.64 spid1 Recovery complete. 2002-11-04 11:33:20.64 spid1 SQL Server's Unicode collation is: 2002-11-04 11:33:20.64 spid1 'English' (ID = 1033). 2002-11-04 11:33:20.64 spid1 comparison style = 196609. 2002-11-04 11:33:20.64 spid1 SQL Server's non-Unicode sort order is: 2002-11-04 11:33:20.64 spid1 'nocase_1251' (ID = 106). 2002-11-04 11:33:20.64 spid1 SQL Server's non-Unicode character set is: 2002-11-04 11:33:20.64 spid1 'cp1251' (ID = 5). 2002-11-04 11:33:26.14 spid7 Using 'xpsqlbot.dll' version '1998.11.13' to execute extended stored procedure 'xp_qv'. 2002-11-04 11:33:50.32 spid8 Using 'xpsql70.dll' version '1998.11.13' to execute extended stored procedure 'xp_msver'. Может кто-то сможет посоветовать. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 04.11.2002, 12:45:35 |
|
||
|
Аа-аа, что делать?
|
|||
|---|---|---|---|
|
#18+
Похоже заморочка с со стартом DTC судя по данным строкам 2002-11-04 11:33:17.18 kernel Attempting to initialize Distributed Transaction Coordinator. 2002-11-04 11:33:17.45 spid1 Failed to obtain TransactionDispenserInterface: Result Code = 0x8004d01b Советовать чего либо издалека сложно. Но может, проверьте учетную запись у службы DTC (в ОС) ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 04.11.2002, 14:29:50 |
|
||
|
|

start [/forum/topic.php?fid=46&fpage=3384&tid=1819100]: |
0ms |
get settings: |
4ms |
get forum list: |
8ms |
check forum access: |
2ms |
check topic access: |
2ms |
track hit: |
20ms |
get topic data: |
6ms |
get forum data: |
2ms |
get page messages: |
78ms |
get tp. blocked users: |
1ms |
| others: | 202ms |
| total: | 325ms |

| 0 / 0 |
