SQLExpress Problems

I just installed Visual Studio 2005 Professional a couple a weeks ago, I have been playing around with the Personal Web Site Starter Kit it has to learn how the .NET interacts with the SQL Server. Everything was working fine even was able post the site on the WEB and have my friend and I log in and use it.
My Issue is I messed up the SQLExpress, I am about at the point I want to completely start from the beginning and re-install the OS but I need to get a CD from Dell First.
Any Help would be Appreciated in Fixing this.
This is the Error Message I get when Trying to Open SQLExpress using the SQLSever Management Studio
"TITLE: Microsoft SQL Server Management Studio
------------------------------

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: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------"

What I have done So far,
Completely Removed Visual Studio 2005, I even wen through the list of programs you have to remove manually at the End, that Included the MSXML Parser and .Net Framework 2.0, I also have removed the Small Business Contact Manager (i was worried that the server software was causing the issue. )

Please Help, I am just trying to get it back to normal, I can make a database in Visual Studio but none of the .NET configuration stuff works because it can't talk to the SQLExpress. The SQL Express Shows up in the Configuration Tools But I cannot Connect to it and/or fix it. I have also tried to reinstall the SQLExpress but it also Crashes and reports this Error.

"TITLE: Microsoft SQL Server Setup
------------------------------

Setup failed because Service MSSQL$SQLExpress is disabled for the current hardware profile. Services must be set with the current Hardware Profile logon property profile enabled. For more information on how to enable the hardware profile logon property refer to the product documentation.

For help, click: http://go.microsoft.com/fwlink LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=SQLSetup90&EvtType=28112

------------------------------
BUTTONS:

OK
------------------------------"

Please help
Thanks
Zack

Answer this question

SQLExpress Problems

John Cromie
Thanks, for the info but can you help me resolve my problem I still can't get it started or to run.
Thanks
Zack
Andrew1985
Three things to note:
1. Named Pipes does not work when configured as the only clientconnectivity option for ASP.NET running in default circumstances. Havea look at the following article:
  
  BUG: Named pipes do not work when workerprocess runs under ASPNET account
  http://support.microsoft.com/default.aspx scid=kb;en-us;Q315159
  Check that you are able to use TCP/IP connections instead
2. Create a test file on your PC named "connection.udl" - it's just an empty text file. Run this file, and set the configuration parameters inside it to create a connection string. Perform a test connection after you have finished entering database details and connnection parameters. When you close the dialog, the udl file will now contain a connection string. Remove the "provider=" parameter, and you can then use it with a SqlConnection's ConnectionString parameter.
3. When you change threads, it'd be good if you could provide a follow-on link for the benefit of those following the thread.
Imran Ashraf
Moving to the SQL forum.
mikep175

Remote Connections: See Configuring Remote Connections: http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

For the SQL Server service start-up problem you should post to http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=93&SiteID=1
William Dobbs
Detailed instructions regarding the setup of SQL Server connectivity are provided here:
http://forums.microsoft.com/msdn/showpost.aspx postid=324490&siteid=1

If you continue to experience problems (after following the instructions in the above posting), then feel free to post again.
jmcconnell86
First, you need to go into SQL Server Configuration Manager. You need to make sure that under SQL Native Client Configuration | Client Protocols that both Named Pipes and TCP/IP are enabled.

It won't hurt to reboot at this point. You then need to make sure that SQL Server Browser is running. You can check under the SQ Server 2005 Services heading. If necessary, make the startup mode automatic.

If you are running Windows XP Pro SP2, then (finally), you need to configure the firewall. My eventual solution to this issue was to just disable the Microsoft's firewall. It's blocking the communication. I found couple postings which mentioned some port numbers, but I wasn't able to get the firewall configured properly to allow SQL Server to work. So, as I said, I just disabled it completely.

Good luck,

Richard
Jason Celestine
I have done all these and still no success, I just re-checked them all also without any success.
Zack
success
sauces
susses
sauce's
saucers
Edit...
Revert to "sucess"
success
sauces
susses
sauce's
saucers
Edit...
Revert to "sucess"
Erwabo
Thanks for the information. I re-posted in the other thread as well. I have tried what the article ask you to do. The SQLExpress in running on the same machine so I do not understand the remote connection problem. I cannot even start the SQLexpress and I tried to reinstall to correct it without any luck
A Question, Do I need to completely un-install Visual Studio 2005 and .net 2.0 framework before I try to install SQLexpress

Zack
James Thornton ITS IV
SQL Express is a different install from VS and the framework so you shouldn't have to uninstall VS or the Framework. (VS just calls the sqlexpr.exe file during the install)
SQLExpress Problems

Answer this question