O SQL ( Enterprise Manager) não abre o (LOCAL)

KingArthur · Agosto 15, 2009

Me ajudem por favor!!!

Eu já usava o SQL 2000 no Meu PC mas tive que formatar meu computador...

Depois que fui abrir o (LOCAL)apareceu a mensagem:

A connection could not be established to (LOCAL).

Reason: SQL Server inexistente ou acesso negado.

ConnectionOpen (connect())..

Please verify SQL Server is running and check your SQL Server registration properties (by right-clicking on the (LOCAL) node) and try again.

Tentei de tudo e nada de funcionar...

Já olhei o ERRORLOG Arquivo e diz:

2009-08-15 12:24:35.20 server Microsoft SQL Server 2000 - 8.00.194 (Intel X86)

Aug 6 2000 00:57:48

Enterprise Evaluation Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

2009-08-15 12:24:35.20 server Server Process ID is 1148.

2009-08-15 12:24:35.20 server Logging SQL Server messages in file 'C:\Arquivos de programas\Microsoft SQL Server\MSSQL\log\ERRORLOG'.

2009-08-15 12:24:35.20 server SQL Server is starting at priority class 'normal'(2 CPUs detected).

2009-08-15 12:24:35.90 server SQL Server configured for thread mode processing.

2009-08-15 12:24:35.90 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.

2009-08-15 12:24:35.95 server Attempting to initialize Distributed Transaction Coordinator.

2009-08-15 12:24:36.03 server Failed to obtain TransactionDispenserInterface: Result Code = 0x8004d01b

2009-08-15 12:24:36.04 spid4 Starting up database 'master'.

2009-08-15 12:24:36.17 server Using 'SSNETLIB.DLL' version '8.0.311'.

2009-08-15 12:24:36.17 spid5 Starting up database 'model'.

2009-08-15 12:24:36.21 spid4 Server name is 'JC-FC85EAF652A6'.

2009-08-15 12:24:36.21 spid8 Starting up database 'msdb'.

2009-08-15 12:24:36.21 spid9 Starting up database 'pubs'.

2009-08-15 12:24:36.21 spid10 Starting up database 'Northwind'.

2009-08-15 12:24:36.29 server SQL server listening on 192.168.2.100: 1433.

2009-08-15 12:24:36.29 server SQL server listening on 5.107.233.77: 1433.

2009-08-15 12:24:36.29 server SQL server listening on 127.0.0.1: 1433.

2009-08-15 12:24:36.29 server SQL server listening on TCP, Shared Memory, Named Pipes.

2009-08-15 12:24:36.29 server SQL Server is ready for client connections

2009-08-15 12:24:36.40 spid5 Clearing tempdb database.

2009-08-15 12:24:36.76 spid5 Starting up database 'tempdb'.

2009-08-15 12:24:36.82 spid4 Recovery complete.

2009-08-15 12:26:31.10 spid51 Using 'xpstar.dll' version '2000.80.194' to execute extended stored procedure 'sp_MSgetversion'.

2009-08-15 12:35:57.57 server SQL Server terminating because of system shutdown.

2009-08-15 12:35:57.64 server LogEvent: Failed to report the current event. Operating system error = 31(Um dispositivo conectado ao sistema não está funcionando.).

2009-08-15 12:35:59.21 spid4 SQL Server is terminating due to 'stop' request from Service Control Manager.

No ERRORLOG Arquivo 1 diz:

2009-08-15 12:22:36.07 server Microsoft SQL Server 2000 - 8.00.194 (Intel X86)

Aug 6 2000 00:57:48

Enterprise Evaluation Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

2009-08-15 12:22:36.09 server Server Process ID is 3248.

2009-08-15 12:22:36.09 server Logging SQL Server messages in file 'C:\Arquivos de programas\Microsoft SQL Server\MSSQL\log\ERRORLOG'.

2009-08-15 12:22:36.09 server SQL Server is starting at priority class 'normal'(2 CPUs detected).

2009-08-15 12:22:36.90 server SQL Server configured for thread mode processing.

2009-08-15 12:22:36.92 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.

2009-08-15 12:22:36.96 server Attempting to initialize Distributed Transaction Coordinator.

2009-08-15 12:22:37.40 server Failed to obtain TransactionDispenserInterface: Result Code = 0x8004d01b

2009-08-15 12:22:37.42 spid4 Warning ******************

2009-08-15 12:22:37.42 spid4 SQL Server started in single user mode. Updates allowed to system catalogs.

2009-08-15 12:22:37.46 spid4 Starting up database 'master'.

2009-08-15 12:22:37.79 server Using 'SSNETLIB.DLL' version '8.0.311'.

2009-08-15 12:22:37.79 spid5 Starting up database 'model'.

2009-08-15 12:22:37.79 spid4 Server name is 'JC-FC85EAF652A6'.

2009-08-15 12:22:37.81 spid8 Starting up database 'msdb'.

2009-08-15 12:22:37.81 spid7 Starting up database 'pubs'.

2009-08-15 12:22:37.81 spid9 Starting up database 'Northwind'.

2009-08-15 12:22:38.12 spid5 Clearing tempdb database.

2009-08-15 12:22:38.37 server SQL server listening on 192.168.2.100: 1433.

2009-08-15 12:22:38.37 server SQL server listening on 5.107.233.77: 1433.

2009-08-15 12:22:38.37 server SQL server listening on 127.0.0.1: 1433.

2009-08-15 12:22:38.45 server SQL server listening on TCP, Shared Memory, Named Pipes.

2009-08-15 12:22:38.45 server SQL Server is ready for client connections

2009-08-15 12:22:38.59 spid5 Starting up database 'tempdb'.

2009-08-15 12:22:38.68 spid4 Warning ******************

2009-08-15 12:22:38.68 spid4 Attempting to change default collation to Latin1_General_CI_AS.

2009-08-15 12:22:41.28 spid4 Clustered index restored for master.sysdatabases.

2009-08-15 12:22:41.29 spid4 Non-clustered index restored for master.sysobjects.

2009-08-15 12:22:41.34 spid4 index restored for master.syscolumns.

2009-08-15 12:22:41.34 spid4 index restored for master.systypes.

2009-08-15 12:22:41.34 spid4 index restored for master.sysusers.

2009-08-15 12:22:41.43 spid4 index restored for master.sysproperties.

2009-08-15 12:22:41.45 spid4 index restored for master.sysfulltextcatalogs.

2009-08-15 12:22:41.46 spid4 index restored for master.sysxlogins.

2009-08-15 12:22:41.53 spid4 index restored for master.sysdevices.

2009-08-15 12:22:41.57 spid4 index restored for master.sysservers.

2009-08-15 12:22:41.62 spid4 index restored for master.syslanguages.

2009-08-15 12:22:41.64 spid4 index restored for master.syscharsets.

2009-08-15 12:22:41.64 spid4 index restored for master.sysfilegroups.

2009-08-15 12:22:42.73 spid4 index restored for master.spt_values.

2009-08-15 12:22:42.74 spid4 index restored for master.spt_datatype_info_ext.

2009-08-15 12:22:42.74 spid4 index restored for master.MSreplication_options.

2009-08-15 12:22:42.74 spid4 index restored for master.spt_datatype_info.

2009-08-15 12:22:42.82 spid4 Non-clustered index restored for tempdb.sysobjects.

2009-08-15 12:22:42.82 spid4 index restored for tempdb.syscolumns.

2009-08-15 12:22:42.82 spid4 index restored for tempdb.systypes.

2009-08-15 12:22:42.82 spid4 index restored for tempdb.sysusers.

2009-08-15 12:22:42.82 spid4 index restored for tempdb.sysproperties.

2009-08-15 12:22:42.82 spid4 index restored for tempdb.sysfulltextcatalogs.

2009-08-15 12:22:42.84 spid4 index restored for tempdb.sysfilegroups.

2009-08-15 12:22:42.85 spid4 Non-clustered index restored for model.sysobjects.

2009-08-15 12:22:42.92 spid4 index restored for model.syscolumns.

2009-08-15 12:22:42.92 spid4 index restored for model.systypes.

2009-08-15 12:22:42.96 spid4 index restored for model.sysusers.

2009-08-15 12:22:42.96 spid4 index restored for model.sysproperties.

2009-08-15 12:22:42.96 spid4 index restored for model.sysfulltextcatalogs.

2009-08-15 12:22:42.96 spid4 index restored for model.sysfilegroups.

2009-08-15 12:22:43.21 spid4 Non-clustered index restored for msdb.sysobjects.

2009-08-15 12:22:43.31 spid4 Non-clustered index restored for msdb.sysobjects.

2009-08-15 12:22:43.35 spid4 index restored for msdb.syscolumns.

2009-08-15 12:22:43.37 spid4 index restored for msdb.systypes.

2009-08-15 12:22:43.43 spid4 index restored for msdb.sysusers.

2009-08-15 12:22:43.43 spid4 index restored for msdb.sysproperties.

2009-08-15 12:22:43.43 spid4 index restored for msdb.sysfulltextcatalogs.

2009-08-15 12:22:43.43 spid4 index restored for msdb.sysfilegroups.

2009-08-15 12:22:43.45 spid4 index restored for msdb.sysjobschedules.

2009-08-15 12:22:43.46 spid4 index restored for msdb.syscategories.

2009-08-15 12:22:43.46 spid4 index restored for msdb.systargetservers.

2009-08-15 12:22:43.46 spid4 index restored for msdb.systargetservergroups.

2009-08-15 12:22:43.48 spid4 index restored for msdb.RTblDatabaseVersion.

2009-08-15 12:22:43.49 spid4 index restored for msdb.sysalerts.

2009-08-15 12:22:43.49 spid4 index restored for msdb.sysoperators.

2009-08-15 12:22:43.49 spid4 index restored for msdb.syscachedcredentials.

2009-08-15 12:22:43.54 spid4 index restored for msdb.logmarkhistory.

2009-08-15 12:22:43.67 spid4 index restored for msdb.RTblNamedObj.

2009-08-15 12:22:43.67 spid4 index restored for msdb.sysdtscategories.

2009-08-15 12:22:43.67 spid4 index restored for msdb.sysdbmaintplan_databases.

2009-08-15 12:22:43.68 spid4 index restored for msdb.mswebtasks.

2009-08-15 12:22:43.70 spid4 index restored for msdb.RTblProps.

2009-08-15 12:22:43.71 spid4 index restored for msdb.RTblRelshipProps.

2009-08-15 12:22:43.73 spid4 index restored for msdb.sysdownloadlist.

2009-08-15 12:22:43.73 spid4 index restored for msdb.sysjobs.

2009-08-15 12:22:43.73 spid4 index restored for msdb.sysjobsteps.

2009-08-15 12:22:43.79 spid4 Non-clustered index restored for pubs.sysobjects.

2009-08-15 12:22:43.85 spid4 index restored for pubs.syscolumns.

2009-08-15 12:22:43.85 spid4 index restored for pubs.systypes.

2009-08-15 12:22:43.85 spid4 index restored for pubs.sysusers.

2009-08-15 12:22:43.85 spid4 index restored for pubs.sysproperties.

2009-08-15 12:22:43.85 spid4 index restored for pubs.sysfulltextcatalogs.

2009-08-15 12:22:43.85 spid4 index restored for pubs.sysfilegroups.

2009-08-15 12:22:43.92 spid4 index restored for pubs.titleauthor.

2009-08-15 12:22:43.92 spid4 index restored for pubs.stores.

2009-08-15 12:22:43.92 spid4 index restored for pubs.sales.

2009-08-15 12:22:43.92 spid4 index restored for pubs.roysched.

2009-08-15 12:22:43.95 spid4 index restored for pubs.pub_info.

2009-08-15 12:22:43.99 spid4 index restored for pubs.employee.

2009-08-15 12:22:44.04 spid4 index restored for pubs.authors.

2009-08-15 12:22:44.04 spid4 index restored for pubs.publishers.

2009-08-15 12:22:44.04 spid4 index restored for pubs.titles.

2009-08-15 12:22:44.14 spid4 Non-clustered index restored for Northwind.sysobjects.

2009-08-15 12:22:44.18 spid4 index restored for Northwind.syscolumns.

2009-08-15 12:22:44.18 spid4 index restored for Northwind.systypes.

2009-08-15 12:22:44.18 spid4 index restored for Northwind.sysusers.

2009-08-15 12:22:44.18 spid4 index restored for Northwind.sysproperties.

2009-08-15 12:22:44.18 spid4 index restored for Northwind.sysfulltextcatalogs.

2009-08-15 12:22:44.18 spid4 index restored for Northwind.sysfilegroups.

2009-08-15 12:22:44.29 spid4 index restored for Northwind.Orders.

2009-08-15 12:22:44.29 spid4 index restored for Northwind.Products.

2009-08-15 12:22:44.29 spid4 index restored for Northwind.CustomerCustomerDemo.

2009-08-15 12:22:44.29 spid4 index restored for Northwind.CustomerDemographics.

2009-08-15 12:22:44.29 spid4 index restored for Northwind.Territories.

2009-08-15 12:22:44.31 spid4 index restored for Northwind.EmployeeTerritories.

2009-08-15 12:22:44.32 spid4 index restored for Northwind.Employees.

2009-08-15 12:22:44.34 spid4 index restored for Northwind.Categories.

2009-08-15 12:22:44.35 spid4 index restored for Northwind.Customers.

2009-08-15 12:22:44.37 spid4 index restored for Northwind.Suppliers.

2009-08-15 12:22:44.75 spid4 Default collation successfully changed.

2009-08-15 12:22:44.79 spid4 Recovery complete.

2009-08-15 12:22:44.81 spid4 Warning: override, autoexec procedures skipped.

2009-08-15 12:22:50.37 spid51 Error: 15457, Severity: 0, State: 1

2009-08-15 12:22:50.37 spid51 Configuration option 'allow updates' changed from 0 to 1. Run the RECONFIGURE statement to install..

2009-08-15 12:22:50.45 spid51 Error: 15457, Severity: 0, State: 1

2009-08-15 12:22:50.45 spid51 Configuration option 'allow updates' changed from 1 to 0. Run the RECONFIGURE statement to install..

2009-08-15 12:22:50.79 spid4 SQL Server is terminating due to 'stop' request from Service Control Manager.

E tem mais ERRORLOG Arquivo 2 e ERRORLOG 3 na pasta: C:\Arquivos de programas\Microsoft SQL Server\MSSQL\LOG

Se alguém puder me ajudar eu agradeço muito pois to precisando do SQL urgente...

Meu Sitema operacional é o Windons XP Professional...

quintelab · Agosto 17, 2009

Ou o Sql Server não esta instalado ou esta usando algum usuário sem permissão.

Abraços...

KingArthur · Agosto 18, 2009

Eu vou ter que reinstalar o SQL? Mas o que eu uso não tem como desistalar o que eu faço?

A senha do sa eu coloquei a certa e nada de pegar...

Vou tentar instalar novamente valeu pela dica...

Obrigado!

reinaldo polato · Agosto 18, 2009

e ai kingArthur beleza

faz o seguinte instala o sql server 2000 de novo e faz o seguinte

Instação quando aparecer essas partes de instação voce faz isso ai embaixo

user information

no company coloca a mesma coisa do nome

no services accounts coloca

use the same account for each service. Auto star SQL Server Service

e seleciona o use the local system account

ai na proxima tela de instação seleciona mixed mode(Windows Authentication and SQL server Authentication) e coloca uma senha no enter passoword e embaixo repete a senha

segue esse passo e depois ve se funcionou direito

Entrar

Arquivado

O SQL ( Enterprise Manager) não abre o (LOCAL)

Recommended Posts

KingArthur 0

Compartilhar este post

Link para o post

Compartilhar em outros sites

quintelab 91

Compartilhar este post

Link para o post

Compartilhar em outros sites

KingArthur 0

Compartilhar este post

Link para o post

Compartilhar em outros sites

reinaldo polato 1

Compartilhar este post

Link para o post

Compartilhar em outros sites

Fixar div até atingir uma certa altura

Ajuda com Extends e envio para o banco

PHP+Codeginiter - Orientação para Impressão

Este projeto é apoiado pelas empresas

Fóruns

Tempo Real

Informação importante