Are you trying to connect through Enterprise Manager?
Right click on the server name and select connect. It
usually saves the login id and password that is used to
connect. Hopefully the login is still valid.

Sometimes I can't connect on the first try.

>-----Original Message-----
>Hi,
> I am new to sql and am having a problem we run sql 2k
on a windows 2k
>machine. I rebooted the computer today but SQL fails to
start! if i try to
>start it i get the following error message.
>
>
>a connection could not be established to SERVER
>
>Reason: SQL server does not exist or access denied.
>connectionopne (connect())......
>Pease verify SQL Server is runnign and check your Sql
Server Registration
>properties.
>
>I have dones this but i cannot change anything.
>
>Part of the problem is that the SQL services will not sart
and there is not
>error message as to why this is
>
>any help would be great!
>
>Mickey
>
>
>.
>

Report this post to a moderator

I have tried that but no luck. I think that I can chase the problem back
to a domain name change. And I believe that the database is trying to
authenticate on the old domain. I have even tried logging in using the sa
account but that does not work. I really am not sure how to approach this
problem. This is compounded by not having a good backup of the transaction
log. the only blessing is that this domain is still under construction but I
really want to recover the database and transaction log.

and help would be great

Mickey

"mike" <mgodshall@meridianmobility.com> wrote in message
news:117ac01c21ec6$2d3856a0$2a
e2c90a@hosting.microsoft.com...
> Are you trying to connect through Enterprise Manager?
> Right click on the server name and select connect. It
> usually saves the login id and password that is used to
> connect. Hopefully the login is still valid.
>
> Sometimes I can't connect on the first try.
>
> >-----Original Message-----
> >Hi,
> > I am new to sql and am having a problem we run sql 2k
> on a windows 2k
> >machine. I rebooted the computer today but SQL fails to
> start! if i try to
> >start it i get the following error message.
> >
> >
> >a connection could not be established to SERVER
> >
> >Reason: SQL server does not exist or access denied.
> >connectionopne (connect())......
> >Pease verify SQL Server is runnign and check your Sql
> Server Registration
> >properties.
> >
> >I have dones this but i cannot change anything.
> >
> >Part of the problem is that the SQL services will not sart
> and there is not
> >error message as to why this is
> >
> >any help would be great!
> >
> >Mickey
> >
> >
> >.
> >

Report this post to a moderator