Re: Access denied after OS Disk upgrade!?

Take a look at the ERRORLOG for more details. Normally the log is located in
C:\Program Files\Microsoft SQL Server\MSSQL\LOG

You can also try starting sql server in the console mode from the command
prompt.
If you have a default instance of sql installed in the default location, you
should change directory to
C:\Program Files\Microsoft SQL Server\MSSQL\Binn
and execute
sqlservr -c
the output messages to the console will give you a clue to what is going
wrong.
hth
--
Vikram Vamshi
Database Engineer
Eclipsys Corporation
"TomJ" <tjdarth@xxxxxxxxxxx> wrote in message
news:%23V7UTUbjFHA.3972@xxxxxxxxxxxxxxxxxxxxxxx
>I recently had to upgrade my WIN-XP SP2 OS harddrive. I am now getting the
>following error message when I attemp to start MSSQL 2000 Developer edition
>through Enterprise Manager or Query Analyzer: "A connection could not be
>established to (LOCAL) Reason:SQL Server does not exist or access denied.
>ConnectionOpen (Connect()).. Please verify SQL Server is running and check
>your SQL Server registration properties ( by righ-clicking on the (LOCAL)
>node) and try again." When I take the suggested approach of right-clicking,
>I get the same message because he cannot connect!!?
>
> When I go to Admin Tools>Computer Management>Services and
> Applications>Services>MSSQLSERVER>Start, the service starts but then
> issues the mess:THE MSSQLSERVER SERVICE ON LOCAL COMPUTER STARTED AND
> STOPPED. sOME SERVICES STOP AUTOMATICALLY IF THEY HAVE NO WORK TO DO, FOR
> EXAMPLE, THE PERFORMANCE LOGS AND ALERTS SERVICE. And its back to square
> #1.
>
> Can someone help? Thanks in advance
>
> Tom Johnson A+, MCP, MCSD .NET
>
>
>


.

Relevant Pages

  • Re: Error "SQL Server does not allow remote connections"
    ... The application could not connect to the sql server db. ... network is blocking the connection. ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 ... integratedSecurity, SqlConnection owningObject) +737554 ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Connection from remote computer to network SQL Server
    ... There is no firewall on the W2K machine acting as the SQL server. ... I tried making the SQL machine a "trusted" on the router. ... connection works. ... To find the IP address of your computer inside the network, ...
    (microsoft.public.access.adp.sqlserver)
  • ADO.net Orcas Samples Install Problem
    ... An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, ... or am I better off with a full SQL Server install. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: OpenDataSource SQL Server xpress problem
    ... I tried your suggestions with some success. ... I tried setting up the .odc file through the Word Mail Merge wizard as ... If I work through the dialog to connect and then click the 'Test Connection' ... but I suspect it's because until recently most SQL Server ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Exception trying to import data from Excel .
    ... An attempt to install Microsoft SQL Server 2005 this week has not gone ... The connection type "EXCEL" specified for connection manager ... to create a connection manager for an unknown connection type. ...
    (microsoft.public.sqlserver.tools)