Google Answers Logo
View Question
 
Q: Configuring & Installing .Net Framewaork, SQL and Other Components ( Answered,   0 Comments )
Question  
Subject: Configuring & Installing .Net Framewaork, SQL and Other Components
Category: Computers > Programming
Asked by: jonten4-ga
List Price: $50.00
Posted: 29 May 2004 00:45 PDT
Expires: 28 Jun 2004 00:45 PDT
Question ID: 353477
I am getting more involved with Asp.Net most specifically with this
question J# .Net application development.  A friend of mine is
comfortable with Java and we figure J# would be best for the goal for
when developing on a windows platform.  Any other suggestions to
research wouldnt hurt.

So on my network of 4 computers there is a computer running XP which
we are using for our server. It has sql server installed along with an
asp application that is running on it just fine.

Next my goal was to get everything that I had installed on the other
computer installed on another so this is what I did.

Installed the .net Framework 1.1
Installed IIS off of the XP pro disk.

Attemted to Install (Where my problem is) 
Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A
Microsoft SQL Server 2000 Service Pack 3a

And my question what, from top to bottom, do I need to install on an
XP pro machine that meets all hardware requirements,  to get J# C# and
VB Asp.Net applications to run using a SQL database and the order of
all the installations/configuring of all software?  

I think I have everything just either misunderstanding something or didn't do
something correctly, obviously. Understand that my understanding is basic:)

Thank you,
Jon

Request for Question Clarification by studboy-ga on 29 May 2004 06:18 PDT
Hi jonten4-ga

The .NET (runtime) framework needs to be installed on all machines
that you're running .NET apps (all 4 computers).

The .NET app development IDE only needs to be installed on the machine
that you do development on.

The SQL Server should be installed onthe machine that runs the server
(I don't  think you're running the server on all 4 machines, are you?)

The .NET stuff and the SQL stuff are independent of each other, so you
can install in whichever order.

Let me know if this is what you're looking for and I can post a formal
answer.  Thanks.

Clarification of Question by jonten4-ga on 29 May 2004 08:38 PDT
"The .NET (runtime) framework needs to be installed on all machines
that you're running .NET apps (all 4 computers)."
Really?  Does this mean users will not be able to view the
application/site on computers that don't have the .Net framework
installed? Please explain more for me.

"The .NET app development IDE only needs to be installed on the machine
that you do development on."  
IDE? you mean WebMatrix?

"The SQL Server should be installed onthe machine that runs the server
(I don't  think you're running the server on all 4 machines, are you?)"  
No I am not but what the thinking was, was to get SQL to run on the
machine I am wanting to develop .Net applications on for testing
purposes. Would it be easier for me to use the server (one of the four
computers on my network)? I would have liked to know how to
succesfully install SQL on my machine (or any machine at that matter)

"The .NET stuff and the SQL stuff are independent of each other, so you
can install in whichever order."
Yeah thats what I figured but I must have something wrong.  I thought
that I had downloaded/ran from disk and installed everything that I
needed for both .Net and SQL but I must have something wrong or am
missing something.

"Let me know if this is what you're looking for and I can post a formal
answer."  Yeah your on the right track.

Ok so to help you answer my question what I did was install all
mentioned above...problems that I ran through were;
Error telling me that I needed to have a strong password.
I followed some diorections on the internet that told me to right
click on the setup file, create short cut then right click on shortcut
and in target put:
C:\sql2ksp3\MSDE\setup.exe /upgradesp sqlrun blanksapwd=1 
everything after .exe is what was suggested by the forum I was on.

One big issue that makes me think I am A either missing something or B
have something wrong is that I have the SQL Server Service Manager
running in the bottom right of my screen but can not get to the
important things like Enterprise Manager.

Thanks for your help,
Jon

Request for Question Clarification by studboy-ga on 31 May 2004 00:40 PDT
Hi Jon

1) Yes, the way .NET works is much the same way as Java--a "runtime"
component/env is needed before the user can run the program.  The .NET
framework provides the runtime.  In Windows 2003 and above Microsoft
package the framework with the OS: so in the future you won't need to
install the framework.

2) Yes, by IDE I meant WebMatrix, or Visual Studio IDE, or any IDE
that you use to develop the apps.  Looks like you're using WebMatrix.

3) For development, what you were doign should be fine: install on
your development computer.  I assume you have chosen a strong passwd
so that problem is solved?  Have you right click on that icon on the
bottom right of the screen to see whether it brings up a
setup/management menu?  Note that MSDE is not the full version SQL
Server--it's a stripped down version of the full server.  The method
you mentioned for setup appears to be a workaround for a "invalid
instance" problem seen by some users when they install the service
pack.

Let me know whether right clicking on the icon brings up anything.  Thanks.

Request for Question Clarification by studboy-ga on 31 May 2004 00:47 PDT
Also, make sure to install the Service Pack--the Enterprise Manager is
inthe Service Pack Update.  Check the
Start->Program->AdminTools->ComputerManagement
menu afterwards as well:

http://doc.ddart.net/mssql/sql2000/html/howtosql/ht_servpem_431h.htm

Clarification of Question by jonten4-ga on 31 May 2004 16:33 PDT
Ok, thanks for getting back to me again.

Right clicking on the icon brings up the following options in the exact order;

Open SQL Service Manager
Current Service on COMPUTER NAME
--Distrubuted Transaction Coordinator
--SQL Server (this one is checked)
--SQL Server Agent
MSSQLSERVER - STOP
MSSQLSERVER - PAUSE
MSSQLSERVER - START (greyed out)
Exit
Options 
About (Microsoft SQL Service Manager Version 8.00.760)

---------------

"Also, make sure to install the Service Pack--the Enterprise Manager is
inthe Service Pack Update.  Check the
Start->Program->AdminTools->ComputerManagement"

I went right to computer management and there is nothing in there
about Enterprise manager under Services and Applications. However,
there is under services the following;

SQLSERVERAGENT - Started - Manual
MSSQSERVER - Started - Automatic
MSSQLServerADHelper - blank - Manual (tried to start this but it says:
Windows could not start the MSSQLServerADHelper on Local Computer. For
more information, review the System Event Log. If this is a
non-Microsoft service, contact the service vendor, and refer to
service-specific error code - 1073741724.)

There are a few errors in the log;
3 of these probably because I tried to install it a few times? - (The
MSSQLServerADHelper service terminated with service-specific error
3221225572 (0xC0000064).)

1 of these where the problem probably started - (The Distributed
Transaction Coordinator service terminated unexpectedly.  It has done
this 1 time(s).)

Let me know anything else you need to know...thanks again Jon

Clarification of Question by jonten4-ga on 31 May 2004 16:35 PDT
Also, about the strong password, I beleive I did finally get this
right since I am not getting that error anymore...I followed some
sketchy directions on a forum can you clarify that process for me?

Clarification of Question by jonten4-ga on 31 May 2004 16:37 PDT
Possible that it is a user issue?  In the logs, under user where the
errors occur, its says N/A...thanks alot, Jon

Request for Question Clarification by studboy-ga on 01 Jun 2004 01:55 PDT
The ADHelper is for active directories and might not be needed if you
don't intend to publish.  I would guess the error is due to a
permission problem on a certain directory/file.  Are you login as
root/admin?   If not, try login as admin.  Otherwise, if you really
need the helper, call Microsoft support (although I think they have
quite poor support).

Now back to the Enterprise Manager--a couple of questions:

1) Did the Service Pack install successfully?
2) Are you running Windows 2000?  If you're not seeing it under
ComputerManagement -> Service&Apps -> MicrosoftSQLServers then it
could be hiding somewhere else.  What happen if you bring up Service
Manager when you right click on the bottom-right icon?  BTW, you might
not need the Enterprise Manager--Microsoft provides the following tool
as an alternative to manage your databases/tables:

http://go.microsoft.com/?linkid=445372

Request for Question Clarification by studboy-ga on 02 Jun 2004 08:13 PDT
Hi Jon

Any new progress/updates?

Thanks!

Clarification of Question by jonten4-ga on 03 Jun 2004 23:21 PDT
Hey,

"1) Did the Service Pack install successfully?" How can tell you for sure?
Here arte therrors that I think are relevent in the logs

ERROR1 - The Distributed Transaction Coordinator service terminated
unexpectedly.  It has done this 1 time(s).

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
___________________________________________________

ERROR2 - The MSSQLServerADHelper service terminated with
service-specific error 3221225572 (0xC0000064).

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
____________________________________________________


WARNING this may be relevent?

- Your computer has detected that the IP address 192.168.1.100 for the
Network Card with network address 004063C05DFE is already in use on
the network. Your computer will automatically attempt to obtain a
different address.

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
_______________________________________________________________________________


2) Are you running Windows 2000?  
No I am running XP Pro

If you're not seeing it under
ComputerManagement -> Service&Apps -> MicrosoftSQLServers then it
could be hiding somewhere else.  
This is what is there;
MSSQLSERVER
MSSQLServerADHelper
SQLSERVERAGENT


What happen if you bring up Service
Manager when you right click on the bottom-right icon?  
This

Right clicking on the icon brings up the following options in the exact order;

Open SQL Service Manager
Current Service on COMPUTER NAME
--Distrubuted Transaction Coordinator
--SQL Server (this one is checked)
--SQL Server Agent
MSSQLSERVER - STOP
MSSQLSERVER - PAUSE
MSSQLSERVER - START (greyed out)
Exit
Options 
About (Microsoft SQL Service Manager Version 8.00.760)
___________________________________________________________

BTW, you might
not need the Enterprise Manager--Microsoft provides the following tool
as an alternative to manage your databases/tables:

No I need Enterprise Manager, Query Analyzer Import and Export Wizard etc.

Sorry for the delay I have been slammed lately...Jon

Request for Question Clarification by studboy-ga on 04 Jun 2004 08:41 PDT
Hi Jon

What happen if you click on/expand the + on MSSQLSERVER?
You said you see it:


ComputerManagement -> Service&Apps -> MicrosoftSQLServers then it
could be hiding somewhere else.  
This is what is there;
MSSQLSERVER
MSSQLServerADHelper
SQLSERVERAGENT

Clarification of Question by jonten4-ga on 04 Jun 2004 12:03 PDT
"What happen if you click on/expand the + on MSSQLSERVER?
You said you see it:

ComputerManagement -> Service&Apps -> MicrosoftSQLServers then it
could be hiding somewhere else.  
This is what is there;
MSSQLSERVER
MSSQLServerADHelper
SQLSERVERAGENT"

Yeah if I go into COmputer Management and then Service and
Applications there is a list of all the programs on the computer,
however there is no plus sign next to any of those programs, including
MSSQLSERER.

If I double click on MSSQLSERVER a box pops up that gives me the
option to choose one of four tabs;
-On the first tab, to stop pause , the path executable etc.
-the second tab is "Log On" Local system account is checked everything
else is blank except under hardware profile..it says Profile 1 and
under service it says enabled.
-There is a Recovery Tab with drop downs yo select options if the
service fails. Reset fail account after 0 days.
- Fourth tab is Dependencies There are two boxes. First box says No
Dependencies. The second Box says "The following system components
depend on thsi service"  In this box it says SQLSERVERAGENT it has a +
nerxt to it but when clicking it nothing happens...

Thanks for your help,
Jon

Request for Question Clarification by studboy-ga on 10 Jun 2004 16:01 PDT
OK, I contacted Microsoft and did some digging, the free MSDE does
*not* come with Enterprise Manager. The service pack "updates" the
Enterprise Manager only if you have the full SQL Server ($200). 
However, there are third party free manager-like tools.  See
discussions at:

http://66.102.7.104/search?q=cache:GWSYHFgMWwUJ:www.mcse.ms/message675258.html+where+is+msde+enterprise+manager&hl=en&start=2

http://www.microsoft.com/sql/msde/partners/default.asp

Let me know if this answers your question.

Request for Question Clarification by studboy-ga on 10 Jun 2004 16:03 PDT
Developer edition ($49) also has the enterprise manager.

Request for Question Clarification by studboy-ga on 10 Jun 2004 16:06 PDT
Another free manager:


http://www.aspenterprisemanager.com/


Also read this good article--you can emulate the manager if you use Access instead:

http://www.ftponline.com/vsm/2003_06/magazine/columns/databasedesign/

Request for Question Clarification by studboy-ga on 10 Jun 2004 16:10 PDT
As the article described SQL-DMO can also emulate the manager.

Anyway, let me know how it goes.

Clarification of Question by jonten4-ga on 11 Jun 2004 12:51 PDT
Thanks..lets just wrap this up
Answer  
Subject: Re: Configuring & Installing .Net Framewaork, SQL and Other Components
Answered By: studboy-ga on 11 Jun 2004 14:00 PDT
 
Thanks Jon.  To summarize:

There are two parts to the answer to this question.  Part one is
regarding the dependency of .NET and SQL/MSDE and part two is
regarding the SQL Enterprise Manager.

1) 
The .NET (runtime) framework needs to be installed on all machines
that you're running .NET apps (all 4 computers).

The .NET app development IDE only needs to be installed on the machine
that you do development on.

The SQL Server should be installed onthe machine that runs the server

The .NET stuff and the SQL stuff are independent of each other, so you
can install in whichever order.  For development, you can install the
.NET, IDE, and SQL Server on the same machine.

2)
There was some fine confusion in Microsoft's documentation regarding
the availability of Enterprise Manager as promsied by the Service
Pack.  As it turned out, the Enterprise Manager is only available on
the full or development version of SQL Server, but not with MSDE 2000
alone.  There are third party tools and ways to emulate the Enterprise
Manager for development, however (see above for links to sources).
If you have the full or development version of SQL Server, the service
pack will update you with an Enterprise Manager accessible through:
Start->Program->AdminTools->ComputerManagement->Service&Apps

Sorry for taking so long to investigate as the wording regarding the
Enterprise Manager availability as referenced by the service pack
readme is quite misleading.
Comments  
There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy