have lost the ability to get in

I never, ever cross-post, but I am desparate. This was placed in the
sqlserver.server group earlier today.
I installed SQL 2005 on a new machine last week. Created a database using
scripts. Worked fine for a few days. It's not on my machine, but on a
Win2003 Vitrual Server instance which I get to remotely.
Yesterday, I attached a database that had been created on another machine,
with SQL 2000. Seemed to work fine. I closed SQL Server to work on something
else, then opened it back up. It won't let me in now. It says that it
doesn't allow remote connections, even though I am doing it from the same
machine that it resides on. (Well, it's remote in that I am using Terminal
Services, but you know what I mean).
Text of the message is below the line at the bottom of this.
I tried changing the way I log in, including Windows Authentication, SQL
Server authentication, using my network name, and then using the user name I
created just for this thing when I installed SQL Server. I alwasy get the
same message. I also tried connecting remotely from another machine.
I was able to use this same machine to connect to another SQL Server
instance on the network, so it's apparent that the installation of SQL
Server isn't messed up.
I know that I will probably get asked about an admin username and password,
but I don't know what mine is. I tried sa with no password, but it didn't
work.
This is really causing some problems and I have something due at noon today.
Any help appreciated.
If I uninstalled SQL Server and re-install, will that let me in then?
----
--
TITLE: Connect to Server
--
Cannot connect to SERV423.
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
(provider: Named Pipes Provider, error: 40 - Could not open a connection to
SQL Server) (Microsoft SQL Server, Error: 2)
For help, click:
tID=2&LinkId=20476" target="_blank">http://go.microsoft.com/fwlink?Prod...=2&LinkId=20476
BUTTONS:
OK
--I stumbled across the fact that two of the services weren't running, despite
their being set to automatic. Not sure why, but at any rate, I started them
and I can get in now.
While I am happy that I am in, I sure wish MS would have given a more
intuitive error message; would have saved me a few hours.|||Hi middletree,
Can you please tell use the exact services that needed to be started in
order for you to get this to work. I am having the exact same issue and
i've googled hi and lo with no apparent solution.
Thanks,
Brendan
middletree wrote:
> I stumbled across the fact that two of the services weren't running, despi
te
> their being set to automatic. Not sure why, but at any rate, I started the
m
> and I can get in now.
> While I am happy that I am in, I sure wish MS would have given a more
> intuitive error message; would have saved me a few hours.