Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

MSDN2000 SQL server

Posted on 2005-05-09
17
Medium Priority
?
298 Views
Last Modified: 2008-02-01
I downloaded a ffree MSDN2000 sql server (I am a beginner) and I amnaged to start a server named HOME\MASSIMO.

I do not know If I can change the name of this server and if so how( please step by step)

Also, can I add a new server instance ?

Thanks
0
Comment
Question by:brillox
  • 9
  • 8
17 Comments
 
LVL 21

Expert Comment

by:Kevin3NF
ID: 13968248
Yes, you can add a new instance....re-run setup and specify a named instance.

For the first question, are you wanting to change the name of the server or the SQL Server?
0
 

Author Comment

by:brillox
ID: 13968510
Thanks Kevin,

I would like to change the name of the server
0
 
LVL 21

Expert Comment

by:Kevin3NF
ID: 13968559
Depending on the O/S, probably right click on the  My Computer icon, properties, computer name and follow the directions there.  The SQL Server name will not automatically change with it.
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 

Author Comment

by:brillox
ID: 13968865
Well. I think that I'll keep this name...

The reason of all this is because every time that I restart my Pc (WIN XP PRO) I have to re-type the server name in the SQL service manager try icon application. I wonder why he does not detect it automatically....
0
 
LVL 21

Expert Comment

by:Kevin3NF
ID: 13968978
Why are you even looking at the SQL Service Manager?  What is your end goal here?
0
 

Author Comment

by:brillox
ID: 13969066
My end goal was to start or stop the SQL server without going in control panel /admin tools etc .....

Therefore I found this application into the SQL folder and I launched.....

As I told you I am a beginner with SQL (basically I am a beginner in every aspect of programming) and I prepared my computer with all the tools to learn VB.NET (visual Studio), PHP ASP SQL C# and C++.

I am doing a Honour Degree in computing (2nd year) and in the summer I study by myself....
0
 

Author Comment

by:brillox
ID: 13969073
while I am writing here I an actually studying VB.NET (Sams teachyourself in 21 days...)
0
 
LVL 21

Expert Comment

by:Kevin3NF
ID: 13969216
>> My end goal was to start or stop the SQL server without going in control panel /admin tools etc .....<<

OK....and the issue was that the SQL Server name was not appearing and you had to type it in?  I have no idea why that would be happening....have you opened Enterprise manager and registered the local SQL Server?

Have you also installed SP3?  very important to learn on sp3 or better :-)
0
 

Author Comment

by:brillox
ID: 13969241
No Idea of what is Enterprise Manager....
0
 
LVL 21

Expert Comment

by:Kevin3NF
ID: 13969311
Enterprise Manager should be in the SQL Server program group and is the main utility for administering SQL Servers.
0
 

Author Comment

by:brillox
ID: 13969396
I apologise, but in the folder MSDEReIA (which is the folder that has been created after the installation of MSDE2000A.exe, I do not have any program group named SQL... maybe I downloaded the wrong thing, but was the only free one. Basically I downloaded this one in order to study SQL with VisualStudio.Net

DO you know another free SQL server package ?
0
 
LVL 21

Accepted Solution

by:
Kevin3NF earned 375 total points
ID: 13969491
Ahhhh.....MSDE does not come with the client tools....consequences of its free price tag

You may be best off just sticking with what you currently have installed.  
0
 

Author Comment

by:brillox
ID: 13969527
Yes I think so.....

Maybe later on I will think about buying a more complete product....

However, thanks for your time Kevin
0
 
LVL 21

Expert Comment

by:Kevin3NF
ID: 13969562
The developer edition of SQL Server is only $49.  Can't use it for production purposes, but that is the only limitation I am aware of
0
 

Author Comment

by:brillox
ID: 13969625
Hmmmm,

I may think to buy it.... do you have the link for it and also I suppose I need to disinstall this version first....
and then install the new one
0
 
LVL 21

Expert Comment

by:Kevin3NF
ID: 13969715
http://www.microsoft.com/sql/howtobuy/development.asp

Personally, I would start clean, but you can install developer and MSDE on the same system.  If you have them both running, they are going to compete for memory...
0
 

Author Comment

by:brillox
ID: 13969816
Thanks Kevin....
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Suggested Courses

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question