Home > Archive > MS SQL Server > July 2005 > URGENT!!!









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author URGENT!!!
ChrisR

2005-07-21, 8:23 pm

I had to reboot a server as a last resort because nobody was able to connect
to it. Now:

1; I have started the SQL Service using the login for my administrator.
2; But cannot connect to it with either the admin or sa logins. Get the
message: SQL Server does not exists or access is denied.
3: Cannot start the SQL Agent with that same admin account. Get the message:
sqlsERVERaGENT CANNOT BE STARTED. Unable to connect to server 'Bla'.

Im doing all this Termial Serviced onto the box.

SQL2K sp3a.


TIA, ChrisR




pheonix1t

2005-07-21, 8:23 pm

ChrisR wrote:
> I had to reboot a server as a last resort because nobody was able to connect
> to it. Now:
>
> 1; I have started the SQL Service using the login for my administrator.
> 2; But cannot connect to it with either the admin or sa logins. Get the
> message: SQL Server does not exists or access is denied.
> 3: Cannot start the SQL Agent with that same admin account. Get the message:
> sqlsERVERaGENT CANNOT BE STARTED. Unable to connect to server 'Bla'.
>
> Im doing all this Termial Serviced onto the box.
>
> SQL2K sp3a.
>
>
> TIA, ChrisR
>
>
>
>

read the server logs, why isn't it working/starting?
are there errors or some warnings in the event viewer from windows?
do u have enough disk space?


ChrisR

2005-07-21, 8:23 pm

Sorry for the delayed response. As it turns out, something other than SQL
was using my SQL port. SQL was able to start... but not in the assigned
port. All is well now.


"pheonix1t" <nothing@nothing.gone> wrote in message
news:%23ch1hWkjFHA.1204@TK2MSFTNGP12.phx.gbl...
> ChrisR wrote:
> read the server logs, why isn't it working/starting?
> are there errors or some warnings in the event viewer from windows?
> do u have enough disk space?
>
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com