Trouble with sql express 2005

[Red Squirrel]

I have to install sql express 2005 with a sa account. I set the password during the install. For whatever reason I can't connect to the database no matter what I try. No firewall or anything and it's local so it should not matter.

I use this command:

osql -U sa

then enter the password.

It sits there for a while then I get this error:

[SQL Native Client]Named pipes provider: could not open a connection to SQL server [2].
[SQL Native Client] Login timeout expired

Then goes on about that it failed and that it does not allow remote connections by default (which I went and enabled).

What else could I check? Also I tried the netstat command but for w/e reason it does not work in windows like I'm used to in Linux, I'm just getting the help file come up non stop instead of the listing. What port should it be listening on? I want to see if it's actually even listening.

 

[nickbits]

try

osql -S localhost\SQLEXPRESS -U sa

 

[Red Squirrel]

No go. But I managed to get it going with the actual application it was meant for. I just figured if I can't connect with osql then the program would not be able to connect either.

Sadly I did so much messing with the settings I forget what I did to make it work lol. I am SO imaging that machine once I'm done.