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 annasiva 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

Anonymous

  • 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

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

5 Answers

How to recover SQL server mdf files?


RecoveryFix for SQL database recovery software is recover and repair MDF files components from corrupted SQL server database. This software compatible with Windows 7, Server 2008, Vista, Server 2003, XP and 2000. More details see this site: http://www.en.repairsqlserver.net/ or download this tool from http://www.en.repairsqlserver.net/free-trial.html

May 06, 2014 | Microsoft Database Software A5K-02817 SQL...

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

Tip

Mamimum RAM for User @ 3GB using boot.ini switch on 4GB Physical RAM


The DOS will always take a percentage of the physical RAM on the motherboard leaving the rest for the User. By default the Windows Operating System will use 50% of the physical RAM installed on the motherboard leaving the user the remaining 50% this can be changed using a switch in the boot.ini file

The /3GB was originally meant to be used in systems that have 3GB or more of RAM something that is no longer quite as rare as it used to be Windows XP SP3 will support upto 4GB although on a 32bit (x86) version of Windows will acually see 3.25gb that is the limitation.

However, even if you don't have 3 GB or more of memory, you can still use the /3GB switch. the switch can have any value between 2048 (2 GB) and 3072 (3 GB) megabytes. It needs to be expressed in decimal notation.

The /3GB switch applies to 32-bit systems only (x86).

Example with Windows XP SP3 Home Edition with the recovery console installed this gives you the option of default 50-50% split or the 3GB switch 75-25% split.

The /noexecute parameter enables, disables, and configures Data Execution Prevention (DEP), a set of hardware and software technologies designed to prevent harmful code from running in protected memory locations using the optin switch enables DEP only for operating system components, including the Windows kernel and drivers. Administrators can enable DEP on selected executable files by using the Application Compatibility Toolkit (ACT).

The /burnmemory parameter specifies the amount of memory, in megabytes, that Windows cannot use in this example, /burnmemory=128 will reduce the physical RAM memory that is available to Windows by 128 MB.

[boot loader]
timeout=10
default=multi(0)disk(0)rdisk(0)partition(1)WINDOWS
[operating systems]
multi(0)disk(0)rdisk(0)partition(1)WINDOWS="Microsoft Windows XP Home Edition 3GB Switch" /noexecute=optin /3GB /fastdetect
multi(0)disk(0)rdisk(0)partition(1)WINDOWS="Microsoft Windows XP Home Edition " /noexecute=optin /burnmemory=128 /fastdetect
C:CMDCONSBOOTSECT.DAT="Microsoft Windows Recovery Console" /cmdcons


Check out the noexecute and the 3GB switch plus all available boot.ini switches HERE

I suggest that you use AnalogX MaxMem it is a realtime physical memory management program that automatically ensures that you always have as much physical memory available as possible used with the 3GB switch you should never have memory issues ever again.



on Mar 14, 2010 | Microsoft Windows XP Home Edition for PC

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...

5 Answers

SQL 401: cannot open database


SQL database Recovery Software remove errors from SQL server database and allow recover your all database of SQL Server 2012 or below versions. The software support with all over version of SQL server. Try at here:-
SQL Database Recovery

Jun 06, 2008 | Computers & Internet

1 Answer

Sql server


It should install automatically when you insert the CD - double clikc cd-rom drive if it does not begin to load.

This might be a useful article - there was a bug - you may need to upgrade to SP2. http://www.microsoft.com/sql/prodinfo/previousversions/system-requirements.mspx

Note: If you are running a 64-bit version of a Microsoft Windows Server™ operating system, you need to use SQL Server 2000 Enterprise Edition (64-bit). Visit the SQL Server 2000 (64-bit) System Requirements page for additional information.

Apr 06, 2008 | Microsoft SQL Server 2000 Standard Edition...

1 Answer

Error while trying to login to database


You have a named instance installed with dynamic ports configured (default) named "local". In this case, the connection string would be localhost\local instead of local:1433. You could alternatively configure the service to use a fixed port and then connect using just localhost:. With dynamic ports, you would have to resolve the name of the service through SqlBrowser, which should be running

Nov 03, 2017 | Microsoft SQL Server Standard Edition for...

1 Answer

SQL server won't work on my laptop


Two ways to access your server. First, make sure the SQL Server Service is running. Start | Run | Services.msc | Enter. Look for Microsoft SQL Server Service and that it's running. Or Look for the SQL Service Broker icon by the clock and see that it's running. The default instance of SQL Server uses the Hostname. Start | Run | Cmd | Enter. The type hostname. This will be the name to access to server. Then type IPCONFIG, this is then the IP address that you could also use to access it.

SQL Server runs on port 1433, so any firewall has to have it open.

Open Query Analyzer, type in the hostname or ip of the local box, type in "sa" and the password for sa (if setup in mixed mode) or Windows Authentication.

Once you login in, you should now see the databases in the Tree on the left side under the Server | Databases node.

Your description though states "SQL Server won't work on my laptop". TO answer this, the only two SQL Editions that work on anything other than "SERVER" software is SQL Professional and SQL Developer. All others have to be on a "SERVER" platform.

Aug 30, 2007 | Microsoft SQL Server 2000 Standard Edition...

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

Related Topics:

147 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Ekse

Level 3 Expert

13434 Answers

Marvin
Marvin

Level 3 Expert

85231 Answers

Brad Brown

Level 3 Expert

18226 Answers

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

Answer questions

Manuals & User Guides

Loading...