cannot create default instance


    Sponsored Links


  • 1. Backup one server to another
    Hello, I am trying to backup a database on one SQL server (A) to another SQL server (B). Is it possible to do this? (A) is outside of our firewall. I can connect to the server with enterprise manager on (B) and am able to access it. I can't map a network drive through the firewall for security reasons. Would log shipping be a good alternative if I can't perform a direct backup? Thanks, Steve
  • 2. MSDE and SQL Server same computer
    Can SQL server and MSDE coexist on the same computer. I would like to try the trial version of SQL server to check out the tools that MSDE lacks but SQL server includes. Thanks
  • 3. Error 1069 after installation
    I'm trying to install the evaluation edition of SQL Server 2000 on my PC that is running XP Pro. I chose all the default options, including "Use the same account for each service. Auto start..." and "Use the Local System account". When the installation finishes and I reboot, the MSSQLServer indicator in the system tray shows a red mark. When I right-click and choose "Start/Continue", it comes back with the error "The service did not start due to a logon error.", then "An Error 1069 occured when trying to perform this service operation on the MSSQLServer Service." Before installing it, I had logged on to Windows with an account that has administrator privileges (it was not a limited account). The computer is part of a workgroup, but no other PCs were invoived in this. This is the third attempt to install sql server (after each of the first two attempts I did a complete uninstall). Thanks.
  • 4. Sql server 2000 x Windows 2000 Professional - Urgent
    This is perfectly normal as the only editions of sql server that are allowed on Win2kPro are the Developer Edition, Personal Edition or the Desktop Edition. To run Standard you need the Server version of the OS. -- Andrew J. Kelly SQL Server MVP "Jorge" < XXXX@XXXXX.COM > wrote in message news:074301c358f8$dd4eab80$ XXXX@XXXXX.COM ... > Hi folks, > > I have Windows 2000 Professional and when I tried to > install SQL 2000 Std ed, I got a message saying "only the > client can be installed". Any ideas for that ? I'm > wondering if the error has something related with IIS. > BTW: I don't have IIS installed. > > Thanks in advance. > > JP >
  • 5. Disable SQL Mail?
    I need to disable SQL mail on a W2K box running SQL 2000. I see no way to do this via Enterprise Manager. Was this an option during installation? Can it be uninstalled w/ out reinstalling the whole thing?

cannot create default instance

Postby Brad Cochran » Sat, 28 Aug 2004 00:08:44 GMT

Okay, my problem is a bit of an odd one.  I am trying to 
reinstall a medical management program that relies on SQL 
Server 2000 as its DBMS.  The problem is that the computer 
I am trying to install this on (one of our trainers' 
notebooks) previously had SQL Server (Personal Edition) 
installed, and it was apparently not uninstalled correctly.

When I tried to run setup, first I picked the option to 
uninstall, but that failed (sorry, I don't remember the 
error it gave.. I think it couldn't find some files).  So 
next, I tried to just do a new install.  This worked, but 
it wouldn't let me create a default instance of the 
database server (the option was greyed out), and forced me 
to put in an instance name.

Unfortunately, the software we use with SQL Server doesn't 
appear to support connecting to anything other than a 
default instance.  I tried setting the connection 
properties to PCNAME\INSTANCENAME, but it flat out refuses 
to connect.

Is there any way I can turn this instance into a default 
instance (this is a new install with a blank database, so 
I'm not concerned about losing any data), or at the very 
least uninstall SQL Server *completely* (maybe some 
registry keys that didn't get removed or something?), 
allowing me to reinstall and setup a default instance.

Any help would be greatly appreciated.  Thanks.

Re: cannot create default instance

Postby Eric Sabine » Sat, 28 Aug 2004 04:04:22 GMT

Maybe do a manual uninstall?

 http://www.**--****.com/ ;en-us;290991&Product=sql

Similar Threads:

1.Cannot log into default instance after changes to sp_configure

2.Cannot connect to default instance


I am trying to connect to my Win2k3SBSPre server's default instance of SQL 
using SQL Server Management Studio. Instead it is connecting to one of the 
instances of MSDE running (for ISA). I've tried both the server name and IP 
as the server in SQL SMS and both connect to the SERVER\MSFW instance. HELP


David Lozzi 

3.Cannot install the default instance of SQL 2005

I had SQL express installed and tried to upgrade to SQL 2005.  It allows me 
to create a new named instance but won't upgrade the default instance.

Is there any way to upgrade the default instance or can I remove the default 
instance so that I can reinstall it at 2005?

4.2147024893: cannot remove reporting service of default instance:

When I remove it from control panel,  the error message shows:

the setup failed to read IIsMimeMap table. The error code is 2147024893

I cannot connect the reproting service using other instances.
I cannot open reporting services configuration either.
There is not much information in google.

Can you help me?

Thanks a lot!  

5.Cannot Uninstall SQL 2005 Enterprise Default Instance

Please I need help!! I cannot find the way to completily uninstall SQL2005!!

I cannot get some useful advise about this, that's why I'm posting again,
removing a SQL 2005 instance shouldn't be that hard!!!

My problem: I've installed a SQL 2005 Enterprise default instance
side-by-side with a
SQL2000 named instance.

Then my SQL2005 instance became corrupt and I've decided to uninstall, but
it seems that there's no way to completily remove the instance.

My first attempt, was removing everything that refeers to SQL2005
Enterprise using the Add/Remove Programs option, I've also used the
Microsoft Clean UP Util.
I've noticed that the uninstallation process does not remove all file-system
folders, but I haven't removed the manually.

On my SQL Server Service Manager I still can see both the SQL2000 and
SQL2005 instance, if I select the SQL2005 instance I get the following
"The specified service does not exist as an installed service."
wich tells me that the service is not running.

When I begin a new SQL2005 setup,  on the installation wizard, on the
instance name form when I click on "Installed Instances" only my SQL2000
instance is listed. So I choose to install SQL2005 as a default instance.

When the setup progress tries to validate instance name I get the following
"An instance with the same name is already installed on this computer. To
proceed with SQL Server Setup, provide a unique instance name."

I need to fix this without formatting the server. That not an option to
me, there has to be a way.

Thanks a Lot!

6. Is there a way to create default SQL Server instance or a named in

7. Creating an Alias for a (non-default) SQL Server 2005 Instance

8. Can't created a linked server on a named instance to default i



Who is online

Users browsing this forum: No registered users and 23 guest