RE: Starter kit will not install no localhost connection

From: Baisong Wei[MSFT] (v-baiwei_at_online.microsoft.com)
Date: 03/29/04 

Date: Mon, 29 Mar 2004 08:06:34 GMT

Hi mGen,

I am really sorry that this problem is still not resolved yet. I did test
times on my computer and no problem with that. Since this thread is so
long, it cannot be guaranteed that there is no change on from the start.
So, I would like to have a summary of it and hope you could follow my steps
in installing it.

1) Uninstall the MSDE you installed on you computer in the Control Panel
using 'Add and Remove Programms', Remove the 'Microsoft SQL Server Desktop
Engin'.
Then, there should be no any SQL Server Service running on your machine.

Then, download MSDE from the following link and install it:
http://www.microsoft.com/sql/msde/downloads/download.asp
setup SAPWD="YourPassword"

Then download the Service Pack for it from:
http://www.microsoft.com/downloads/details.aspx?FamilyId=413744D1-A0BC-479F-
BAFA-E4B278EB9147&displaylang=en
Install the Service Pack for the MSDE:
sql2kdesksp3.exe
Then go to the Service of the MMC and restart the MSSQLServer Service.

>From the 'Start'->'Run', type in 'Regedit', then go to the
HKEY_LOCAL_MACHINE\Software\Microsoft\MSSqlserver\MSSqlServer

There is a key 'LoginMode', make sure it is set to '0', which means Mixed
Authentication

Make sure the TCP/IP protocol are enabled:
Click "Start", and then click "Run". type "svrnetcn.exe" (without the
quotation marks) in the "Open" box, and then click OK. Note: By default,
the
svrnetcn.exe is available in the following folder:
<InstallationDrive>/Program Files/Microsoft SQL Server/80/Tools/BINN
The TCP/IP should be on the right side, which are 'enabled protocols'. If
not, enabled the TCP/IP protocols
Then restart the MSSQLSERVER in MMC.

2)
a) In the command prompt, type:
ping localhost
There should be reply from 127.0.0.1

In the Service in the MMC, make sure the TelNet service
Then type in
telnet localhost 1433
then screen will clear ( this means the MSDE service is running)

b) In the command prompt, use osql to test.
osql -S localhost -E (If this works, you installation will be OK)
and
osql -S localhost -U sa -P YourPassword
(You set this password in the installation process)
These two connection should be OK

c) In the command prompt, use Query Analyzer to test ( in the command
prompt, type 'isql' (without single quotes) to launch Query Analyzer)
When 'Connect to SQL Server' dialog appear, in the 'SQL Server', type in
'localhost' (without single quote)
User Windows authentication, should be no problem.
and
User SQL Server authentication, use 'sa' (without single quotes) and
'YourPassword' (without singel quotes)should be no problem.

3) Open the Profiler (Start->Run, typing 'Profiler' (without single quotes))
Then from the menu, 'File' ->'New'->'Trace' then type in LOCALHOST as the
SQL Server and use the windows authentication to connect it. If step 2.c is
OK ,it will connect to the localhost. In the Event Tab, choose only
Security Adit: Audit Login on the right pane. Then press Run.

4) switch to the ASP.NET starter Kit location ,then start installation.
When it come to the test connection step. Press the button. How about it.
If failed, how about the application name, NTuserName and LoginName in the
profiler.

Thanks for you time to take the test. Since I tested many times and no
problem, I just want to make sure that the steps you take is the same as
mine.

Sincerely Yours

Baisong Wei
Microsoft Online Support
----------------------------------------------------
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.