Question about Microsoft Computers & Internet

1 Answer

I have installed Windows 2012 server Os and in that system i have installed Sql Server 2008 R2 Express Edition and Microsoft SQL Server 2012 Transact-SQL with Same Instences,now i want to stop sqlserver 2008r2 instence,i want connect only sql2012 Db

Posted by on

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 148 Answers

Hi Sarma,

If it is the single instance, SQL server service is registered only once. Please remove and reinstall with named instance.

Warm Regards,
Abhay Pujari

Posted on Jan 07, 2015

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,
a 6ya expert can help you resolve that 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.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

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:

5 Answers

How do I recover data from .mdf file


Detach you database. Overwrite the mdf and ldf files you've restored from your backup with your files from the D: drive. Reattach the database.
There is no guarantee that this will work or if it works, that your database is in a state where you can continue to work with.
If that doesn't work then there is an option to try to restore database using SQL Server Recovery Toolbox. It is a powerful tool for data recovery. They have a demo version. So you can check it works in your situation or not.
http://www.oemailrecovery.com/sql_repair.html

Jan 19, 2016 | Microsoft SQL Server 2008 Enterprise Full...

Tip

SQL 2008 SA Password Reset


How to reset sa password in SQL Server 2008 when forgot the sa password?

Many time, This problem comes, they have setup SQL 2008 or SQL 2008 R2 for development or QA environment, but they don't know the login sa password by which they can connect to server. In SQL Server 2005, SQL used to fixed group sysadmin with the server role BUILTINAdministrators, that is to say, all local NT administrator automatically add a SQL Server system administrator. But since 2008 Windows BUILTINAdministrators group is not included by default in the sysadmin server role in SQL Server.

So, follow the steps mentioned to reset SQL 2008 password for SA account if no BUILTINAdministrators.

Step 1. Download and install MS SQL Server Password Unlocker.

Step 2. Run MS SQL Server Password Unlocker, click Open, import the master.mdf file. All the user names of your SQL Server will be displayed.

Step 3. Select an SQL account, such as 'SA', click Change Password button.

Step 4. Type a new password, and then click OK.

The new password has been set for your SA account, now you can login
SQL Server with the new password.

Currently SQL Server 2008 still supports two types validation and authentication for access link to resources database, Windows authentication mode and SQL Server and Windows authentication mode which also known as mixed mode. Both of these authentication methods provide access to SQL Server 2008 and its resources.

The Mixed Mode - SQL Server and Windows Authentication Mode

SQL Server and Windows Authentication Mode uses either Active Directory user accounts or SQL Server accounts when validating access to SQL Server. SQL Server 2005 introduces a new way, the policy of the password and account lockout the policy session of SQL Server by using SQL Server implement authentication. SQL Server 2008 also to do so. The policy of SQL Server that can be used include password complexity, password expiration and account lockout. This feature is not available in SQL Server 2000 and becomes a major security risk for most organizations and database administrators. In essence, this weakness has contributed to the Windows authentication set as best practice for the management of authentication in the past. Today, SQL Server and Windows authentication mode may be able to successfully compete with the Windows Authentication Mode.

on Oct 26, 2010 | Computers & Internet

3 Answers

Repair database without being attached SQL 2005


Use SQL Server Repair Kit. A convenient, reliable and ultimately efficient MS SQL database repair tool for system administrators, developers and database experts. Best in class performance and outstanding usability for users with and without experience.

Read more: http://www.mssqlserver.repair/

May 13, 2015 | Microsoft SQL Server 2005 Enterprise...

2 Answers

How to install sql server 2012


Hello Hatsabi

Check out the following video. It contains the step by step guide on installing the SQL Server 2012.


If that don't work for you, for any reason, try one of the many solutions on the following page


install sql server 2012 YouTube

Feb 24, 2015 | Microsoft SQL Server 2005 Enterprise...

1 Answer

Lost SQL Server 2005 product key. How to find installed SQL Server product key?


If you have SQL Server 2005 installed on your computer, you could find lost product key with effective software, iSunshare Product Key Finder.
How to Find Product Key with iSunshare Product Key Finder

Step 1: Install Product Key Finder on your computer.
The computer is which one where SQL Server 2005 installed.

Step 2: Click "Start Recovery" button.
Few seconds later, SQL Server, Windows, Office, IE etc product keys are listed in Product Key Finder.

Step 3: Click "Save" button on menu or "Save to File" button to save product keys for them.

This way to find SQL Server product key also applies to SQL Server 2000/2008/2012/2014.

Jun 27, 2014 | Microsoft SQL Server 2005 Enterprise...

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

1 Answer

I can't install the service pack 3 of SQL server


Are you installing SP3 for SQL 2005 Standard or Express editions?

According to Microsoft, the standard edition will not work on XP Home.

See:
http://technet.microsoft.com/en-us/library/ms143506(SQL.90).aspx

Aug 01, 2010 | Microsoft Windows XP Home Edition

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

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

Related Topics:

81 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2764 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18394 Answers

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

Answer questions

Manuals & User Guides

Loading...