MSDE Setup not working for me!!!!

[flamingsouls]

Hello,


I am trying to go through the Wrox book, Beginning ASP.NET for Visual Basic .NET. The book had me install the free SQL server desktop engine. After installing and rebooting, I see the icon down in the task manager and it says that SQL Server is running. The problem I have is when I go into VS and use a SQL Data Adapter, and I select new connection, no SQL Server is listed. I do have the provider for SQL Server selected.
I have also gone into Server Explorer and saw my server there under SQL Servers. Just for trying stuff, I registered my server. I then went back to register it and whenever I try to connect, using either Windows Integrated Security or logging in with a specific name and password, it comes up(shortened version), Unable to connect: SQL Server does not exist or you do not have permissions. I am logged in as Admin and I am part of "Debugger Users; Administrators" groups.

I know that's a lot but I'd really like to get this SQL Server working. Do I have to register it somewhere in the computer that I'm not told about? Oh, in Services the MSql$NETSDK is listed as automatic and LocalSystem.....just in case that helps.

Thanks a bunch!!!
Josh

 

[LiLithTecH]

Do you have TCP/IP set as the Default Network?
(I believe Named Pipes is installed default)

 

[flamingsouls]

In MSDE or Network settings? Where would I find that out?

thx
Josh

 

[LiLithTecH]

To check, go to:


Menu Bar \ SQL Server (from program group) \ SQL Client Configuration Manager

Select Net Library tab.

Select TCP/IP as the Default Network

Click on the Done button