Two issues with VWD2008 and SQL Server 2005 Express on
VISTA.

Hello,

I would appreciate if you can help me out here. I have been struggling to make
VWD2008 Express work on Vista Ultimate for past two weeks. I have two road
blocker issues. One, the WebDev.WebServer stops working (atually it does not
run) and two, sql server does not get installed. I have poured through forums
and blogs to try to find a solution. So far, nothing has fixed my issues on
Vista. I don't have these problems in Windows XP systems, though.

1) I am running as Adminstrator on my new Laptop running Vista (has all updates,
and Firewall turned off). I downloaded VWD2008 Express, installed it with SQL
Server Express. and created "hello.aspx" with just "HELLO"
in body of the page. The build worked fine, but then I got error
"WebDev.WebServer.exe has stopped working".

This happens everytime I try to preview any page or OR select
Website->ASP.NET configuration from Menu. I have removed and reinstalled this
4 to 5 times, tried different fixes from the Net. The same steps works like
charm on 2 other computers running XP. When I try to start the
WebDev.WebServer.exe from command prompt on Vista, I get error "ASP.NET
Development server failed to start listening on port 8080. Error Message: An
attempt was made to access a socket in a way forbidden by its access
permissions".

2) I am not able to add SQL Server Database in VWD2008 express. It gives me an
error message:

"Connection to SQL Server files (*.mdf) require SQL Server Express 2005 to
function properly. Please verify the installation of the component or download
from the URL: http://go.microsoft.com/fwlink/?LinkID=49251".

Please note that SQL Server 2005 Express with VSD2008Express installation showed
no errors. When I check SQL server configuration manager (local) I see no items
under SQL Server 2005 Services.

So, I uninstalled SQL Server and installed SQL Server 2005 Express with Advanced
Services Service Pack 2.  This installation fails every time, with error. The
Log shows the following:

"Product         : Microsoft SQL Server Native Client 
Product Version : 9.00.3042.00 
Install         : Successful 
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0022_<name of machine>_SQLNCLI_2.log 
--------------------------------------------------------------------------------

Product         : SQL Server Database Services
Error           : SQL Server Setup could not connect to the database service for
server configuration. The error was: [Microsoft][SQL Native Client][SQL
Server]Login failed for user 'sa'. Refer to server error logs and setup logs for
more information. For details on how to view setup logs, see "How to View
Setup Log Files" in SQL Server Books Online.
--------------------------------------------------------------------------------

Product         : SQL Server Database Services
Error           : SQL Server Setup could not connect to the database service for
server configuration. The error was: [Microsoft][SQL Native Client][SQL
Server]Login failed for user 'sa'. Refer to server error logs and setup logs for
more information. For details on how to view setup logs, see "How to View
Setup Log Files" in SQL Server Books Online.
--------------------------------------------------------------------------------

Product         : Microsoft SQL Server 2005 Express Edition 
Product Version : 9.2.3042.00 
Install         : Failed 
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0022__<name of machine>__SQL.log 
Last Action     : InstallFinalize 
Error String    : SQL Server Setup could not connect to the database service for
server configuration. The error was: {SQL Native Client}{SQL
Server}Login failed for user 'sa'. Refer to server error logs and setup logs for
more information. For details on how to view setup logs, see "How to View
Setup Log Files" in SQL Server Books Online. 
Error Number    : 29515 "

I have tried to install SQL Server multiple times on Vista (as Admin).  I tried
using Vista's IIS server, but I still have the SQL Database issue.

I would appreciate your help.

Thanks

SKS

1)  Take a look at: 
http://www.microsoft.com/products/ee/transform.aspx?ProdName=Windows%20Operating
%20System&ProdVer=5.1.2600.2180&EvtID=4226&EvtSrc=Tcpip&LCID

Jeff

Jeff,

 Thanks for your post.

When I noticed that ftp on Vista was also not working, I figured something was
blocking, and I think your reply helped me think little harder.

McAfee showed that firewall as disabled, but after searching for hours, I found
that McAfee firewall process was running. When I stopped that usingTask Manager,
my ftp started working fine.

 1) Now I don't get this error "WebDev.WebServer.exe has stopped
working", and Web Server starts, but then I get this error on IE7 - 

“localhost” is not set up to establish a connection on port “49647” with
this computer; and on Firefox I get "Firefox can't establish a connection
to the server at localhost:49647".

When I use IIS7 as "custom server" in VWD2008Express IIS, the pages
come up just fine on port 80 or for that matter 48000.

 

2) The SQL Server is properly installed now. I still need to figure out how to
connect ASP pages to that. ASPX pages do connect fine.

 

Regards

 

SKS