Question about Computers & Internet

1 Answer

SQL Server 2000 SP3 - Installation Path

How do i change the default installation path of SQL Server 2000 SP3 to D:Program FilesMicro Soft SQL Server. I tried using .iss with 
[SetupTypeSQL-0]
   szDir=D:Program FilesMicroSoft SQL Server
   szDataDir=D:Program FilesMicroSoft SQL Server.
This is not working.

help me with  right procedure to do this.

Posted by on

  • Anonymous Mar 28, 2014

    Is there a way of using R studio with MS CRM Dyanmics? I found a solution that mentioned JDBC drivers for MS SQL Server connections but not for MS CRM Dynamics 2011. Any suggestions?

×

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Novelist:

    An expert who has written 50 answers of more than 400 characters.

    Champion:

    An expert who has answered 200 questions.

  • Expert
  • 244 Answers

The only way to change it. Is to reinstall the SQL Server, and be guided accordingly once you meet the setup option you need to change the folder destination where you can setup the sql.

Hoping this will be the solution you are looking for.


Best Regards,


Philip

Posted on Oct 30, 2007

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Sony experia U Sony keeps flashing on screen and nothing else happens. This occured after I tried to update phone


To install the flash tool, follow the steps below:
  1. Download the Tools
  2. Unzip the file you downloaded and place it somewhere on your computer.
  3. In the unzipped folder, run Emma.exe. During the installation, make sure you remember the installation path:
    1. Default path in Windows 64 bit is: "C:\Program Files (x86)\Sony Mobile\Emma\"
    2. Default path in Windows 32 bit is: "C:\Program Files\Sony Mobile\Emma\"
  4. Copy the Customization.ini file. You find it in the <Emma zip filename>.
  5. Paste the Customization.ini file into the installation folder. The installation folder is the folder named Emma in the installation path examples on point 3.1 and 3.2 above.
  6. Click Start > All programs > Sony Mobile > Emma (if you used the default installation path from step 3 above) to start the flash tool
You can visit my blog with video Tutor lol
http://pcgadgetdeni.blogspot.com/2013/02/flash-tool-for-xperia-devices.html

Feb 14, 2013 | Sony Ericsson Sony Xperia U St25i Black...

Tip

How to recover sql 2000 sa password


Microsoft SQL Server 2000 is a full-featured relational database management system that offers a variety of administrative tools to ease the burdens of database development, maintenance and administration. It operates in one of two authentication modes: Windows Authentication Mode (the default) or Mixed Mode.

When you install the SQL Server 2000, you can log in the server with Windows Authentication and SQL Server Authentication if you select mixed mode authentication. If you select Windows Authentication, you cannot assign a sa password during installation. However, you should set the sa password after installation.

It is very easy for one to set sa password in SQL 2000. Just follow the below steps:

* 1. Expand a server group, and then expand a server.
* 2. Expand Security, and then click Logins.
* 3. In the details pane, right-click SA, and then click Properties.
* 4. In the Password box, type the new password.

The type of client connections determines the choice of security mode. If all of the incoming clients support trusted connections, you can use Windows Authentication Mode. If some clients do not support trusted connections, you can select Mixed Mode.

If you forget the sa password, you will need to use MS SQL Server Password Unlocker to reset sa password SQL 2000. MS SQL Server Password Unlocker is easy yet powerful SQL Server password reset software for you to reset SQL password, including reset SA password and other user passwords. It provides you an easy and safe way to reset SQL Server password for Microsoft SQL Server 2000/2005/2008 in a minute. No need for you to reinstall MS SQL Server on your PC. The file in master.mdf format is enough for you to recover sa password SQL 2000.

Steps to reset sql password 2000 for sa as follows:
* 1. Download and install MS SQL Server Password Unlocker.
* 2. Click the application icon to run it.
* 3. Click Open to import your master.mdf file. All the user names of your MS SQL Server will be displayed.
* 4. Select sa account, click Change password button to reset sa password.
* 5. Type a new password, and then click OK to finish your operation.

Note: This method to reset sa password in sql server 2000 is usually applied when you cannot login SQL Server 2000 by Windows Authentication wile you forget system administrator login password.

More information about sa password:

According to Microsoft, System administrator (sa) is a special login provided for backward compatibility. By default, it is assigned to the sysadmin fixed server role and cannot be changed. Although sa is a built-in administrator login, do not use it routinely. Instead, make system administrators members of the sysadmin fixed server role, and have them log on using their own logins. Use sa only when there is no other way to log in to an instance of Microsoft SQL Server.

on Oct 19, 2010 | Computers & Internet

1 Answer

What path do i select to install rainbow six 3


You can let Rainbow Six choose the default path. It is probably something like...

c:\\Program Files(x86)\Ubisoft\

Otherwise, you can use that path. The path really doesn't matter as long as the application knows where to find all of it's relevant files.

Dec 09, 2012 | Ubi Soft M Clancys Rainbow Six 3 Raven...

8 Answers

I forgot my sql server password, and i need to get the sql sa password back, how can i retrieve my sql sa password? its SQL server 2005. Any advice is ok, i dont want to reinstall the SQL server, Thanks in...


Lost or forgot your administrator/user password for Microsoft SQL Server?
If so, turn to help from AnyPasskey SQL Password Recovery, which is a professional program enables you reset administrator or user password for Microsoft SQL Server instantly regardless of the length, complexity, language and encoding of the password set before. As long as you got AnyPasskey SQL Password Recovery and master.mdf file, you could reset SA password on any authorized PC in minutes without the installation of Microsoft SQL Server. What's more, this featured-in tool supports all versions of Microsoft SQL Server and Microsoft SQL Server Express perfectly. 6_21_2012_1_55_07_am.jpg

Sep 15, 2010 | Computers & Internet

4 Answers

Hay Bahratt, I have uninstalled the 3 SQL programs in the control panel a few times with no effect on the issue. I didn't try moving directory C:\Program Files\Microsoft SQL Server\MSSQL to another...


If you have removed it from control panel, its done. You just have to clean up any left over registry entries using CCleaner and then try installing again
http://www.ccleaner.com/download
You may also want to check out this microsoft link if it doesn;t work
http://office.microsoft.com/en-us/help/HP011128601033.aspx

Jan 10, 2010 | Computers & Internet

1 Answer

Error installing MS Office pro 2007 with BCM


Uninstall from control panel the following:
Microsoft SQL Server native client
Microsoft SQL Server Setup Support files
Microsoft SQL Server VSS writer

Move directory C:\Program Files\Microsoft SQL Server\MSSQL.1 to another location for possible use. Delete everything under Microsoft SQL Server in c:\Program Files

Reinstall

Jan 10, 2010 | Microsoft Office Professional 2007 Full...

1 Answer

Want to install Quick verse 7 on Vista


the Quick verse 7 was made only for 95 98 2000 and XP but you can try this method on how to install the QV 7 on winXP sp3

"Install QuickVerse Essentials version 7 on WinXP w/sp3

Place the QuickVerse version 7 Essentials CD into optical drive & close tray. This begins the auto run / install process. (Please do not remove CD until right at the end!)

Installation menus appear. Accept the defaults and choose “Typical Installation” (85Mb)

Message box appears at the end of the installation: “QuickVerse installation has encountered a problem and needs to close” Choose “Don’t Send” The installation program exits.

Navigate to: Start Button / All Programs / Parsons / QuickVerse 7 / (from drop down list) find “QuickVerse 7.0” and right click on it. Select “Send To Desktop”

Click on the new QuickVerse 7.0 desktop icon to run the program.

Dialog Box appears, “The librarian datafile library.mdb not found etc…” Select “New” / "Open Book" dialog box appears click on “Close”

Now with QuickVerse 7.0 running go to File / Add Books. “Registration Guide – Introduction” box appears. Choose “Next” The path to the new collection to register should identify the optical drive (with the QuickVerse CD already inserted) Choose “Next”, “Next” and “Finish” ("Registering STEP Books" msg box appears)

Customize Option: select “No” (default) then “OK”

Go to File / Library management. “Library Management – Maintenance” box appears
The Left Hand (LH) pane shows:
Default Drive
QuickVerse Essentials

Highlight QV Essentials in the LH pane. The RH pane shows all the books present on the CD. I chose to install only the NRSV w/Apocrypha book. Drag and drop this book to the LH pane i.e. Default Drive.

“Transferring Book Files” msg box appears whilst the book is being copied from the CD to the hd.

Close the dialog, exit the program, remove the CD and you’re away…"

hope this helps./

Nov 04, 2008 | Computers & Internet

1 Answer

Installation path change


Change The Default Location For Installing Apps -----------------------------------------------
As the size of hard drives increase, more people are using partitions to separate and store groups of files.
XP uses the C:\Program Files directory as the default base directory into which new programs are installed. However, you can change the default installation drive and/ or directory by using a Registry hack.
Go to :-
- Start > Run
- Type “regedit” (without “” NOOBS!)
- Go to this directory… HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion
- Look for the value named ProgramFilesDir. by default,this value will be C:\Program Files. Edit the value to any valid drive or folder and XP will use that new location as the default installation directory for new programs.

Oct 19, 2008 | Computers & Internet

1 Answer

Installing SQL server and VB.NET on VISTA Home Basic


installl SQL SERVER 2005

Vb.net is fine its your sql that will mess things up

BTW visual studio come with an SQL server

Jan 09, 2008 | Microsoft Windows Vista Ultimate Edition

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

136 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18425 Answers

Alun Cox

Level 3 Expert

2678 Answers

David Payne
David Payne

Level 3 Expert

14162 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...