Installation Error: edition

Showing posts with label edition. Show all posts

Friday, March 30, 2012

Installing MSDE on different plattforms.

Product
Our product is developed in Visual Studio .NET using MFC and .NET.
It connects to a MS SQL Server Desktop Edition (MSDE), where the data is
stored.
Installation
Our problems relates to the installation of our product.
Installation happens in these steps:
- Install .NET
- Install MSDE2000 (with a SA password we have chosen)
- Reboot
- Start our own InstallDB.exe which does the follwoing:
-- Connects to the MSDE (the master database)
-- creates our own database (called "exordb" and creates our own sql
user called "exor")
-- Connects again to MSDE using the exor user and loads data into the
exordb database.
We are using the following connectionstring for connecting to master db the
first time.
Data Source=127.0.01; Integrated Security=SSPI;Initial Catalog=master
We are considering to use this one instead:
server=127.0.0.1;uid=sa;pwd=****;database=master
after the exordb is set up we connect using
server=127.0.0.1;uid=exor;pwd=***;database=exordb
Problems
1. (the most critical)
Installation failes (the first connection string) for some customers with XP
SP2 even if they turn off the firewall.
They get the standard SQLServer Exception:
SQL Server does not exist or access denied.
The MSDE is there (unnamed instance) and is ON.
2. (Windows 98)
When installed on Windows98 MSDE does not start automatically after the
reboot, at least that what it seems on the WIndows 98 machine we have tested
on. (We have also discovered that only SQL Autentification works on Win98,
we solved that by using the second connection string instead of the first
one).
3. (manual start of MSDE)
How may we detect (in our code, preferrably .NET/C#) that MSDE is not
running and how do we start it from the code?
4. (MSDE installed by someone else)
If MSDE is already installed on the computer by another program and
SQL-authentification is not set, how may we set it so our connection string
will work.
hi Vilhelm,
Vilhelm wrote:
> Product
> Our product is developed in Visual Studio .NET using MFC and .NET.
> It connects to a MS SQL Server Desktop Edition (MSDE), where the data
> is stored.
> Installation
> Our problems relates to the installation of our product.
> Installation happens in these steps:
> - Install .NET
> - Install MSDE2000 (with a SA password we have chosen)
> - Reboot
> - Start our own InstallDB.exe which does the follwoing:
> -- Connects to the MSDE (the master database)
> -- creates our own database (called "exordb" and creates our own
> sql user called "exor")
> -- Connects again to MSDE using the exor user and loads data into
> the exordb database.
>
> We are using the following connectionstring for connecting to master
> db the first time.
> Data Source=127.0.01; Integrated Security=SSPI;Initial
> Catalog=master
> We are considering to use this one instead:
> server=127.0.0.1;uid=sa;pwd=****;database=master
> after the exordb is set up we connect using
> server=127.0.0.1;uid=exor;pwd=***;database=exordb
> Problems
> 1. (the most critical)
> Installation failes (the first connection string) for some customers
> with XP SP2 even if they turn off the firewall.
> They get the standard SQLServer Exception:
> SQL Server does not exist or access denied.
> The MSDE is there (unnamed instance) and is ON.
I'm trying to get some more material about that kind of issue on XP sp2 to
report it to Microsoft representative... but I am unable to repro it in my
tests.. I'm aware of another issue on XP sp2 which cause installation
failure due to MDAC stack troubles, currently with no workaround as no MDAC
2.8 xp sp2 refresh is available... please forward me more info, if you
like..

> 2. (Windows 98)
> When installed on Windows98 MSDE does not start automatically after
> the reboot, at least that what it seems on the WIndows 98 machine we
> have tested on.
it's correct... MSDE runs as a standard application on Win9x platform as it
does not support service mode..
you should check that the service manager is added in the autostart folder
and that the "Autostart service when OS starts" check box is checked ..
to start MSDE you can call the SQL Server Service Manager as following:
(named instance)
scm.exe -Action 1 -Silent 1 -Service MSSQL$InstanceName
(default Instance)
scm.exe -Action 1 -Silent 1 -Service MSSQLServer
please keep in mind that, on Win9x, MSDE path will not be added to
autoexec.bat if you don't reboot the
computer, so you have to rely on Win32 API like FindFirstFile or the like to
find where the scm.exe is (usually ..\Program Files\Microsoft SQL
Server\80\Tools\Binn\scm.exe)

>(We have also discovered that only SQL
> Autentification works on Win98, we solved that by using the second
> connection string instead of the first one).
MSDE installed on Win9x does not support integrated security

> 3. (manual start of MSDE)
> How may we detect (in our code, preferrably .NET/C#) that MSDE is not
> running and how do we start it from the code?
you can rely on SQL-DMO COM object...
you can then ping it like
dim oServer as SQLDMO.SQLServer2
objServer.PingSQLServerVersion
start it, or just connect...

> 4. (MSDE installed by someone else)
> If MSDE is already installed on the computer by another program and
> SQL-authentification is not set, how may we set it so our connection
> string will work.
you have to manually change the login authentication mode, logging in as
member of the server's sysadmin role and setting the
objServer.IntegratedSecurity.SecurityMode = SQLDMOSecurity_Mixed
or modify the Windows registry
HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer
LoginMode=2
(HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\InstanceName\MSSQLServer for
a named instance)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thank you a lot for some useful answers!!
More input on question 1.
I have not been able ot reproduce it here, but some of my customers report
this problem. Maybe we can resolve it with some well-phrased questions I can
ask one of my customers on the phone.
We use installshield Premier edition which installs MDAC 2.8 if necessary as
part of the installation process.
Vilhelm Heiberg
Norway.
"Andrea Montanari" wrote:

> hi Vilhelm,
> Vilhelm wrote:
> I'm trying to get some more material about that kind of issue on XP sp2 to
> report it to Microsoft representative... but I am unable to repro it in my
> tests.. I'm aware of another issue on XP sp2 which cause installation
> failure due to MDAC stack troubles, currently with no workaround as no MDAC
> 2.8 xp sp2 refresh is available... please forward me more info, if you
> like..
>
> it's correct... MSDE runs as a standard application on Win9x platform as it
> does not support service mode..
> you should check that the service manager is added in the autostart folder
> and that the "Autostart service when OS starts" check box is checked ..
> to start MSDE you can call the SQL Server Service Manager as following:
> (named instance)
> scm.exe -Action 1 -Silent 1 -Service MSSQL$InstanceName
> (default Instance)
> scm.exe -Action 1 -Silent 1 -Service MSSQLServer
> please keep in mind that, on Win9x, MSDE path will not be added to
> autoexec.bat if you don't reboot the
> computer, so you have to rely on Win32 API like FindFirstFile or the like to
> find where the scm.exe is (usually ..\Program Files\Microsoft SQL
> Server\80\Tools\Binn\scm.exe)
>
> MSDE installed on Win9x does not support integrated security
>
> you can rely on SQL-DMO COM object...
> you can then ping it like
> dim oServer as SQLDMO.SQLServer2
> objServer.PingSQLServerVersion
> start it, or just connect...
>
> you have to manually change the login authentication mode, logging in as
> member of the server's sysadmin role and setting the
> objServer.IntegratedSecurity.SecurityMode = SQLDMOSecurity_Mixed
> or modify the Windows registry
> HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer
> LoginMode=2
> (HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\InstanceName\MSSQLServer for
> a named instance)
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>

Wednesday, March 28, 2012

Installing MS SQL Server 2005 Developer

I've done this before but it's been sometime. When I finish installing the MS SQL Server 2005 Developer edition, all I see under the Microsoft SQL Server 2005 folder in the All Programs is Configuration Tools with the following shortcuts:

Notification Services Command Prompt
SQL Server Configuration Manager
SQL Server Error and Usage Reporting
SQL Server Surface Area Configuration

The are a whole bunch of other programs inside the Microsoft SQL Server 2005 folder that are missing. How do I add those services or program such as the Microsoft SQL Server Management Studio?

Does anyone have any idea? Please help if anyone does have some suggestion. Your help is much appreciated.|||

mychucky:
Does anyone have any idea? Please help if anyone does have some suggestion. Your help is much appreciated.

Two questions did you choose all components when it was time to choose components and did you copy all the content of the CD/DVD to your hard drive before installing? If yes then you may want to use the configurations from the link below to configure, if no then copy the content to your hard drive rerun setup and choose repair because the developer edition comes with two Management Studios. Hope this helps.

http://myvstsblog.com/archive/2005/10/31/56.aspx

|||Thank you so much for the response. Yes, you're a right. I copied the contents to the hard drive of the computer and installed it that way. The link asked to click on the "Surface Area Configuration and Connections" but how do I get back to this step so that I can click on the link stated in the link you gave me?|||

mychucky:
Thank you so much for the response. Yes, you're a right. I copied the contents to the hard drive of the computer and installed it that way. The link asked to click on the "Surface Area Configuration and Connections" but how do I get back to this step so that I can click on the link stated in the link you gave me?

Sorry my connection is going crazy but I found you all you need to configure it because it controls how you connect with your applications. Here is a configration by an advanced user and the others are by Microsoft so just read the Microsoft list and use the visual guide. You should see it in your drop down under SQL Server in programs or look in the tools sub folder in Microsoft SQL Server folder. Hope this helps.

http://www.developer.com/db/article.php/3496511

http://msdn2.microsoft.com/en-us/library/ms173748.aspx

http://msdn2.microsoft.com/en-us/library/ms183753.aspx

|||Thanks so much for the info.|||

mychucky:
Thanks so much for the info.

I am glad I could help.

|||

Caddre:
did you copy all the content of the CD/DVD to your hard drive before installing?

I thought I was going mad. I had the same issue after reinstalling MSSQL Server 2005 Developer dozen times.

(and I also installed before MSSQL2005Dev)

Only after I copied the content of DVD to hard disk, I succeded

Well, it does not seem to b well documented installation feature! or I missed something?

Installing MS SQL Server 2000

:p Hi,
I've MS SQL Server 6.5 installed in my Windows 2000 machine. Is it possible to install MS SQL Server 2000 personal or standard edition in the same machine without upgrading or removing the old SQL Server 6,5 ?
Thanks in advance.yes

books online {Working with Named and Multiple Instances of SQL Server 2000}|||Thanks Scott, I did it.

Installing MS Reporting Services Probs

Hi NG
We have a problem to install the MS Reporting Services 2000 on a Windows
2003 Server Web Edition.
IIS is propertly installed, runing, and its serves many wepages.
During the installation (System prequestites check) of RS comes the
following message:
"IIS either not installed or not configured for a server component
installation"
We have no idea, how we can configure the IIS for server component
installations.
Thx for help.
Greets TomSeems you can only install Reporting Services Developer Edition on Windows
2003 server Web edition:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/htm/gs_installingrs_v1_8jom.asp
Or maybe you can try setting it up as a web farm, as your database will have
to be running on a different server anyway:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/htm/gs_installingrs_v1_8jom.asp
Kaisa M. Lindahl Lervik
"news.microsoft.com" <thomas.scholtke@.rbc-is.ch> wrote in message
news:ukqWIurPGHA.532@.TK2MSFTNGP15.phx.gbl...
> Hi NG
> We have a problem to install the MS Reporting Services 2000 on a Windows
> 2003 Server Web Edition.
> IIS is propertly installed, runing, and its serves many wepages.
> During the installation (System prequestites check) of RS comes the
> following message:
> "IIS either not installed or not configured for a server component
> installation"
> We have no idea, how we can configure the IIS for server component
> installations.
> Thx for help.
> Greets Tom
>

Installing more than one edition

I am a contract software designer, servicing multiple industries and multiple sizes within those industries. I need a way to develop and test on both SQL Server Developer edition, and SQL Server Express. Is it possible to install these two editions side-by-side for the purposes of development?

Do I need to have them installed on separate computers?

Yes. You can install different editions of SQL Server 2005 on the same machine successfully, which is supported by SQL Server 2005 provided that the machine has enouugh resources like disk space and the operating system supports the edition of SQL Server 2005. Please see BOL(Books OnLine) for details.

|||Yes, and the major concern is to be aware that if you use SSMS (from the Developer Edition), you will have some functionality that SQL Express does not support. So be cautious when you are attempting to guide a client that may have only SSMSE.sql

Installing Local SQL2000 Personal Edition

I am trying to install a local version of SQL2000 on my XP Pro.

I am having this problem, do you know why because I cannot find the solution on the microsoft website:
Server: Msg 17, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.You'd probably do better to post this kind of question in the Micrsoft SQL Server (http://www.dbforums.com/f7/) forum.

-PatP

Monday, March 26, 2012

Installing Express on box that already has Developer Edition

I'm not at all certain I need to install SQL Server 2005 Express Edition on
my box, but I thought I'd post this anyway.
I currently have SQL Server 2005 Developer Edition installed on my box and
am using it to develop a commercial website I hope to deploy within the next
six months. Meanwhile, I have at least one upcoming Windows Forms project
requiring a SQL Server database which will need to be deployed with the
project. Naturally, I will be including the .mdf file in the setup files fo
r
the project.
My questions are as follows:
1) Will I need to include a copy of the SQL Server 2005 EE on my setup disk
or can I get by with just distributing the .mdf file?
2) If the answer to question 1 is yes on including a copy of SSEE; do I need
to install SQL Server 2005 EE on my computer in order to include it with the
setup disk? I would want to be able to install my application and the
database as a single operation rather than forcing the end user to install
SQL Server first and then install the application.
3) If the answer to question 2 is yes, what problems, if any, will I
encounter trying to install SQL Server 2005 EE on a machine that already has
the Developer Edition installed?
Thanks for any and all help!
Allen"SQL Server Express can be redistributed (subject to agreement)". so, you
can bundle it with your application.
if you know for sure that your clients already have sqlexpress installed,
you can just include the *.mdf. this will make your deployment package much
smaller.
no, you do not need to install sqlexpress on your box in order to
redistribute it. typically, if you're an ISV and develop your app using a
valid visual studio, you should be good to redistribute.
there should be no prob installing sqlexpress on a box with dev edt.
-oj
"AlBruAn" <AlBruAn@.discussions.microsoft.com> wrote in message
news:99156D83-2DA5-4EFA-AC48-275271F3CAE3@.microsoft.com...
> I'm not at all certain I need to install SQL Server 2005 Express Edition
> on
> my box, but I thought I'd post this anyway.
> I currently have SQL Server 2005 Developer Edition installed on my box and
> am using it to develop a commercial website I hope to deploy within the
> next
> six months. Meanwhile, I have at least one upcoming Windows Forms project
> requiring a SQL Server database which will need to be deployed with the
> project. Naturally, I will be including the .mdf file in the setup files
> for
> the project.
> My questions are as follows:
> 1) Will I need to include a copy of the SQL Server 2005 EE on my setup
> disk
> or can I get by with just distributing the .mdf file?
> 2) If the answer to question 1 is yes on including a copy of SSEE; do I
> need
> to install SQL Server 2005 EE on my computer in order to include it with
> the
> setup disk? I would want to be able to install my application and the
> database as a single operation rather than forcing the end user to install
> SQL Server first and then install the application.
> 3) If the answer to question 2 is yes, what problems, if any, will I
> encounter trying to install SQL Server 2005 EE on a machine that already
> has
> the Developer Edition installed?
> Thanks for any and all help!
> Allen|||"SQL Server Express can be redistributed (subject to agreement)". so, you
can bundle it with your application.
if you know for sure that your clients already have sqlexpress installed,
you can just include the *.mdf. this will make your deployment package much
smaller.
no, you do not need to install sqlexpress on your box in order to
redistribute it. typically, if you're an ISV and develop your app using a
valid visual studio, you should be good to redistribute.
there should be no prob installing sqlexpress on a box with dev edt.
-oj
"AlBruAn" <AlBruAn@.discussions.microsoft.com> wrote in message
news:99156D83-2DA5-4EFA-AC48-275271F3CAE3@.microsoft.com...
> I'm not at all certain I need to install SQL Server 2005 Express Edition
> on
> my box, but I thought I'd post this anyway.
> I currently have SQL Server 2005 Developer Edition installed on my box and
> am using it to develop a commercial website I hope to deploy within the
> next
> six months. Meanwhile, I have at least one upcoming Windows Forms project
> requiring a SQL Server database which will need to be deployed with the
> project. Naturally, I will be including the .mdf file in the setup files
> for
> the project.
> My questions are as follows:
> 1) Will I need to include a copy of the SQL Server 2005 EE on my setup
> disk
> or can I get by with just distributing the .mdf file?
> 2) If the answer to question 1 is yes on including a copy of SSEE; do I
> need
> to install SQL Server 2005 EE on my computer in order to include it with
> the
> setup disk? I would want to be able to install my application and the
> database as a single operation rather than forcing the end user to install
> SQL Server first and then install the application.
> 3) If the answer to question 2 is yes, what problems, if any, will I
> encounter trying to install SQL Server 2005 EE on a machine that already
> has
> the Developer Edition installed?
> Thanks for any and all help!
> Allen|||Addition to the other reply.
You can install Sql Server2005 Express on the computer with SQL Server 2005
Developer Edition/Standard editon, or other editions. I have both (Developer
and Express Adv) installed on one of my boxex).
If your application uses SQL Server2005 Express's user instanace feature
(only available to Express edition, not other editions), then you want to
try it out on your development computer before shipping your app to client.
In this case, you need to have SQL Server 2005 Express available on your
computer.
"AlBruAn" <AlBruAn@.discussions.microsoft.com> wrote in message
news:99156D83-2DA5-4EFA-AC48-275271F3CAE3@.microsoft.com...
> I'm not at all certain I need to install SQL Server 2005 Express Edition
> on
> my box, but I thought I'd post this anyway.
> I currently have SQL Server 2005 Developer Edition installed on my box and
> am using it to develop a commercial website I hope to deploy within the
> next
> six months. Meanwhile, I have at least one upcoming Windows Forms project
> requiring a SQL Server database which will need to be deployed with the
> project. Naturally, I will be including the .mdf file in the setup files
> for
> the project.
> My questions are as follows:
> 1) Will I need to include a copy of the SQL Server 2005 EE on my setup
> disk
> or can I get by with just distributing the .mdf file?
> 2) If the answer to question 1 is yes on including a copy of SSEE; do I
> need
> to install SQL Server 2005 EE on my computer in order to include it with
> the
> setup disk? I would want to be able to install my application and the
> database as a single operation rather than forcing the end user to install
> SQL Server first and then install the application.
> 3) If the answer to question 2 is yes, what problems, if any, will I
> encounter trying to install SQL Server 2005 EE on a machine that already
> has
> the Developer Edition installed?
> Thanks for any and all help!
> Allen|||Addition to the other reply.
You can install Sql Server2005 Express on the computer with SQL Server 2005
Developer Edition/Standard editon, or other editions. I have both (Developer
and Express Adv) installed on one of my boxex).
If your application uses SQL Server2005 Express's user instanace feature
(only available to Express edition, not other editions), then you want to
try it out on your development computer before shipping your app to client.
In this case, you need to have SQL Server 2005 Express available on your
computer.
"AlBruAn" <AlBruAn@.discussions.microsoft.com> wrote in message
news:99156D83-2DA5-4EFA-AC48-275271F3CAE3@.microsoft.com...
> I'm not at all certain I need to install SQL Server 2005 Express Edition
> on
> my box, but I thought I'd post this anyway.
> I currently have SQL Server 2005 Developer Edition installed on my box and
> am using it to develop a commercial website I hope to deploy within the
> next
> six months. Meanwhile, I have at least one upcoming Windows Forms project
> requiring a SQL Server database which will need to be deployed with the
> project. Naturally, I will be including the .mdf file in the setup files
> for
> the project.
> My questions are as follows:
> 1) Will I need to include a copy of the SQL Server 2005 EE on my setup
> disk
> or can I get by with just distributing the .mdf file?
> 2) If the answer to question 1 is yes on including a copy of SSEE; do I
> need
> to install SQL Server 2005 EE on my computer in order to include it with
> the
> setup disk? I would want to be able to install my application and the
> database as a single operation rather than forcing the end user to install
> SQL Server first and then install the application.
> 3) If the answer to question 2 is yes, what problems, if any, will I
> encounter trying to install SQL Server 2005 EE on a machine that already
> has
> the Developer Edition installed?
> Thanks for any and all help!
> Allensql

Installing Express on box that already has Developer Edition

Installing Developer Edition Management Studio

I'm attempting to upgrade from SQL Express to SQL Developer. I uninstalled completely before loading Dev edition, but I can't seem to install the Management Studio now. Any ideas?

Hello Joe,

Could you please let us know what error you are getting while installing Dev edition?

This will help in narrowing down the cause so that we can resolve it quickly.

Regards,

Rajesh

|||

Actually, I just had to clean up the Windows Installer. Once I removed any references to Express Editions of visual studio and mssql, it worked just fine.

Thanks anyhow.

Installing Developer Edition Management Studio

I'm attempting to upgrade from SQL Express to SQL Developer. I uninstalled completely before loading Dev edition, but I can't seem to install the Management Studio now. Any ideas?

Hello Joe,

Could you please let us know what error you are getting while installing Dev edition?

This will help in narrowing down the cause so that we can resolve it quickly.

Regards,

Rajesh

|||

Actually, I just had to clean up the Windows Installer. Once I removed any references to Express Editions of visual studio and mssql, it worked just fine.

Thanks anyhow.

sql

Installing Developer Edition Management Studio

I'm attempting to upgrade from SQL Express to SQL Developer. I uninstalled completely before loading Dev edition, but I can't seem to install the Management Studio now. Any ideas?

Hello Joe,

Could you please let us know what error you are getting while installing Dev edition?

This will help in narrowing down the cause so that we can resolve it quickly.

Regards,

Rajesh

|||

Actually, I just had to clean up the Windows Installer. Once I removed any references to Express Editions of visual studio and mssql, it worked just fine.

Thanks anyhow.

Installing Client Tools

I recently installed an evaluation copy of SQL Server (Enterprise x64 edition). What's the proper way to load the management and analytical tools onto client machines? There are 2 separate problems:

1. The 64 bit program only comes with 64 bit tools. (Should I just download the 32 bit evaluation copy? Will the tools expire in 180 days on all the client machines?)

2. What are the licensing rules? Surely I am allowed to load client tools (but not the server itself) onto client devices. Is that right?

Thanks!Evaulation edition expiration only applicable to server components whereby you cannot use the server services, but for client tools I haven't seen such problem you can use them to connect to other SQL server instances.|||That's very helpful - thank you.

It would also be nice to know what the licensing rules actually are & what the best practice is supposed to be.|||Refer to this http://support.microsoft.com/kb/257716 page that clears about licensing policy on client tools, though it is for SQL 2000 all the information is still applicable to SQL 2005 in this case. I would also ask you to refer to the local Microsoft support for more information on licensing, as x64 is bit new in recent times.

Installing and Uninstalling Express Edition

Hi guys,

I'm trying to create a all-in-one installation package for my application which make use of the SQL 2005 Express edition. It seems that there's no way to roll my application MSI installation with the database engine, the only ways around this problem is to use a bootstrap exe to launch the sql setup before or after my main application's MSI. This works fine during installation and I have modified the original .NET framework bootstrapper to do just that.

The problem comes when uninstalling my application. Since the uninstall process is all done through the MSI engine, how would I take the sql instance with me during my application's uninstall? Since the sql engine is also based on MSI technology, I won't be able to do that during the removal step of my application's MSI, right? Any one know any "clean" ways around that? Besides not letting users uninstall my application directly from Add/Remove program and force them to call another exe simular to my installation bootstrap?

I'm considering to use 3rd party tools like InstallShields, but even them are recommending people to stay with the MSI technology which is where the problem is. I'm running out of ideas really fast...

Thanks in advance!

William

Hi,

Since my initial posting, I've been working on the command to uninstall a named instance of SQL Server 2005. I though it would help once I get my problem above solved, as it seems to be the next logical step.

It seems that from MSDN (http://support.microsoft.com/default.aspx/kb/909967), there isn't a way to automate this process neither. The command ARPWrapper.exe don't have (or I couldn't fine) parameter to specify the named instance I'm trying to remove. The switch "/REMOVE" just brings up a window letting user choose their instance to remove. Anyone knows if such a way exists?

As I've said before, I'm trying to package my .NET application with SQL Server 2005 Express Edition into one. So that users can install and uninstall from one place with minimal user intervention. It seems to be such a common task, but it's certainly not too intuitive.

William

|||I too want to have the ability to uninstall a named instance of SQL Server 2005 Express SP2 from the command prompt in silent mode? You were you able to find a solution?sql

Friday, March 23, 2012

Installing A Default Instance AFTER a Named Instance??

I have SQL Server 2000 Standard Edition (sp3a) running on a windows 2003 (sp4) Server.

It is a Production Server with 3 NAMED Instances and NO Default Instance.

Does anyone know if I can rerun the SQL Server Install and add a DEFAULT Instance to this box without disrupting the other Named Instances?Except for a reboot after the install, you should have no problems installing a default instance.|||Thank you : )|||Will the default instance automatically have the name of the Server - or is there a way to give it name - like you would a named instance.. sorry if the question sounds stupid.. : )|||The default instance will have the name of the server. The only way around this that I can think of off the top of my head is to give the machine a DNS alias.|||Thanks !!! I'm not so much worried about the name as I am Blowing up the Server by installing a Default Instance AFTER it has already been populated with Named Instances.

installing 2nd instance

I am trying to install a second instance of sql server 2000. I am running xp
pro and using the developer edition. When I run the install, it completes
normally. The registry has entries for the new named instance. When I try
to register the new server using enterprise manager and add it to a group,
first the wizard does not list the new name. If I type in the name and
proceed, I eventually get an error message saying "sql server does not exist
or access denied. ..." The error log shows that it gets part way with
starting the service but then is stopped before completing. I don't remember
now the limitations on the Developer Edition, is this one of them or is there
another problem? I am using mixed mode with an sa login.
--
JBWhat did the error log say was the issue?
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
"JB" <JB@.discussions.microsoft.com> wrote in message
news:03A65A47-1ADD-42AD-86A5-B937A651A346@.microsoft.com...
I am trying to install a second instance of sql server 2000. I am running
xp
pro and using the developer edition. When I run the install, it completes
normally. The registry has entries for the new named instance. When I try
to register the new server using enterprise manager and add it to a group,
first the wizard does not list the new name. If I type in the name and
proceed, I eventually get an error message saying "sql server does not exist
or access denied. ..." The error log shows that it gets part way with
starting the service but then is stopped before completing. I don't
remember
now the limitations on the Developer Edition, is this one of them or is
there
another problem? I am using mixed mode with an sa login.
--
JB|||Here is the whole lot:
2006-09-24 20:56:50.54 server Copyright (C) 1988-2000 Microsoft
Corporation.
2006-09-24 20:56:50.54 server All rights reserved.
2006-09-24 20:56:50.54 server Server Process ID is 160.
2006-09-24 20:56:50.54 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL$LJBUILDER_SC\log\ERRORLOG'.
2006-09-24 20:56:50.56 server SQL Server is starting at priority class
'normal'(2 CPUs detected).
2006-09-24 20:56:50.56 server SQL Server configured for thread mode
processing.
2006-09-24 20:56:50.56 server Using dynamic lock allocation. [2500] Lock
Blocks, [5000] Lock Owner Blocks.
2006-09-24 20:56:50.59 server Attempting to initialize Distributed
Transaction Coordinator.
2006-09-24 20:56:50.60 server Failed to obtain
TransactionDispenserInterface: Result Code = 0x8004d01b
2006-09-24 20:56:50.62 spid3 Warning ******************
2006-09-24 20:56:50.62 spid3 SQL Server started in single user mode.
Updates allowed to system catalogs.
2006-09-24 20:56:50.62 spid3 Starting up database 'master'.
2006-09-24 20:56:50.82 server Using 'SSNETLIB.DLL' version '8.0.311'.
2006-09-24 20:56:50.82 spid3 Server name is 'LJDESIGNS\LJBUILDER_SC'.
2006-09-24 20:56:50.82 spid5 Starting up database 'model'.
2006-09-24 20:56:50.82 spid7 Starting up database 'msdb'.
2006-09-24 20:56:50.82 spid8 Starting up database 'pubs'.
2006-09-24 20:56:50.82 spid9 Starting up database 'Northwind'.
2006-09-24 20:56:51.04 server SQL server listening on 127.0.0.1: 1032.
2006-09-24 20:56:51.06 server SQL server listening on TCP, Shared Memory,
Named Pipes.
2006-09-24 20:56:51.06 server SQL Server is ready for client connections
2006-09-24 20:56:51.57 spid5 Clearing tempdb database.
2006-09-24 20:56:52.70 spid5 Starting up database 'tempdb'.
2006-09-24 20:56:52.84 spid3 Recovery complete.
2006-09-24 20:56:52.89 spid3 Warning: override, autoexec procedures
skipped.
2006-09-24 20:57:03.01 spid51 Error: 15457, Severity: 0, State: 1
2006-09-24 20:57:03.01 spid51 Configuration option 'allow updates'
changed from 0 to 1. Run the RECONFIGURE statement to install..
2006-09-24 20:57:03.09 spid51 Error: 15457, Severity: 0, State: 1
2006-09-24 20:57:03.09 spid51 Configuration option 'allow updates'
changed from 1 to 0. Run the RECONFIGURE statement to install..
2006-09-24 20:57:03.65 spid3 SQL Server is terminating due to 'stop'
request from Service Control Manager.
--
JB
"JB" wrote:
> I am trying to install a second instance of sql server 2000. I am running xp
> pro and using the developer edition. When I run the install, it completes
> normally. The registry has entries for the new named instance. When I try
> to register the new server using enterprise manager and add it to a group,
> first the wizard does not list the new name. If I type in the name and
> proceed, I eventually get an error message saying "sql server does not exist
> or access denied. ..." The error log shows that it gets part way with
> starting the service but then is stopped before completing. I don't remember
> now the limitations on the Developer Edition, is this one of them or is there
> another problem? I am using mixed mode with an sa login.
> --
> JB|||Have you tried applying SP3a or SP4? It's not clear what the build number
of SQL Server is. This is on Windows 2003, right?
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
"JB" <JB@.discussions.microsoft.com> wrote in message
news:1B35467F-FEA8-47E1-BB94-3DA14D172E97@.microsoft.com...
Here is the whole lot:
2006-09-24 20:56:50.54 server Copyright (C) 1988-2000 Microsoft
Corporation.
2006-09-24 20:56:50.54 server All rights reserved.
2006-09-24 20:56:50.54 server Server Process ID is 160.
2006-09-24 20:56:50.54 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL$LJBUILDER_SC\log\ERRORLOG'.
2006-09-24 20:56:50.56 server SQL Server is starting at priority class
'normal'(2 CPUs detected).
2006-09-24 20:56:50.56 server SQL Server configured for thread mode
processing.
2006-09-24 20:56:50.56 server Using dynamic lock allocation. [2500] Lock
Blocks, [5000] Lock Owner Blocks.
2006-09-24 20:56:50.59 server Attempting to initialize Distributed
Transaction Coordinator.
2006-09-24 20:56:50.60 server Failed to obtain
TransactionDispenserInterface: Result Code = 0x8004d01b
2006-09-24 20:56:50.62 spid3 Warning ******************
2006-09-24 20:56:50.62 spid3 SQL Server started in single user mode.
Updates allowed to system catalogs.
2006-09-24 20:56:50.62 spid3 Starting up database 'master'.
2006-09-24 20:56:50.82 server Using 'SSNETLIB.DLL' version '8.0.311'.
2006-09-24 20:56:50.82 spid3 Server name is 'LJDESIGNS\LJBUILDER_SC'.
2006-09-24 20:56:50.82 spid5 Starting up database 'model'.
2006-09-24 20:56:50.82 spid7 Starting up database 'msdb'.
2006-09-24 20:56:50.82 spid8 Starting up database 'pubs'.
2006-09-24 20:56:50.82 spid9 Starting up database 'Northwind'.
2006-09-24 20:56:51.04 server SQL server listening on 127.0.0.1: 1032.
2006-09-24 20:56:51.06 server SQL server listening on TCP, Shared Memory,
Named Pipes.
2006-09-24 20:56:51.06 server SQL Server is ready for client connections
2006-09-24 20:56:51.57 spid5 Clearing tempdb database.
2006-09-24 20:56:52.70 spid5 Starting up database 'tempdb'.
2006-09-24 20:56:52.84 spid3 Recovery complete.
2006-09-24 20:56:52.89 spid3 Warning: override, autoexec procedures
skipped.
2006-09-24 20:57:03.01 spid51 Error: 15457, Severity: 0, State: 1
2006-09-24 20:57:03.01 spid51 Configuration option 'allow updates'
changed from 0 to 1. Run the RECONFIGURE statement to install..
2006-09-24 20:57:03.09 spid51 Error: 15457, Severity: 0, State: 1
2006-09-24 20:57:03.09 spid51 Configuration option 'allow updates'
changed from 1 to 0. Run the RECONFIGURE statement to install..
2006-09-24 20:57:03.65 spid3 SQL Server is terminating due to 'stop'
request from Service Control Manager.
--
JB
"JB" wrote:
> I am trying to install a second instance of sql server 2000. I am running
> xp
> pro and using the developer edition. When I run the install, it completes
> normally. The registry has entries for the new named instance. When I
> try
> to register the new server using enterprise manager and add it to a group,
> first the wizard does not list the new name. If I type in the name and
> proceed, I eventually get an error message saying "sql server does not
> exist
> or access denied. ..." The error log shows that it gets part way with
> starting the service but then is stopped before completing. I don't
> remember
> now the limitations on the Developer Edition, is this one of them or is
> there
> another problem? I am using mixed mode with an sa login.
> --
> JB|||Per your suggestion. I first installed sp3a on the existing instance of SQL
Server(default instance). This ran without problems and the instance runs
ok. Then I ran the install for 2nd (named) instance. There aren't many
options during the install. I generally clicked Next. On one page, my user
name was displayed along with the domain. I entered my password. A page or
two later, I selected mixed mode and entered the sa password. The intall
seemed to go without any problems. When I then started Enterprise manager to
register the server, first it does not list the new instance in the select a
server page. If I type in the name and continue, I eventually get the
error, "sql server does not exist or access denied
ConnectionOpen(Connect()). Same as before. Then I tried to run sp3a on the
just installed named instance. The setup sees the new instance(i.e. it shows
in a list of instances to upgrade) but when I select the instance and
proceed, eventually I get the error "a service control operation failed for
MSSQL$LJDESIGNS_SC service: 1069 The service did not start due to a logon
failure." I am running windows xp pro sp 2.
--
JB
"Tom Moreau" wrote:
> Have you tried applying SP3a or SP4? It's not clear what the build number
> of SQL Server is. This is on Windows 2003, right?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> ..
> "JB" <JB@.discussions.microsoft.com> wrote in message
> news:1B35467F-FEA8-47E1-BB94-3DA14D172E97@.microsoft.com...
> Here is the whole lot:
> 2006-09-24 20:56:50.54 server Copyright (C) 1988-2000 Microsoft
> Corporation.
> 2006-09-24 20:56:50.54 server All rights reserved.
> 2006-09-24 20:56:50.54 server Server Process ID is 160.
> 2006-09-24 20:56:50.54 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL$LJBUILDER_SC\log\ERRORLOG'.
> 2006-09-24 20:56:50.56 server SQL Server is starting at priority class
> 'normal'(2 CPUs detected).
> 2006-09-24 20:56:50.56 server SQL Server configured for thread mode
> processing.
> 2006-09-24 20:56:50.56 server Using dynamic lock allocation. [2500] Lock
> Blocks, [5000] Lock Owner Blocks.
> 2006-09-24 20:56:50.59 server Attempting to initialize Distributed
> Transaction Coordinator.
> 2006-09-24 20:56:50.60 server Failed to obtain
> TransactionDispenserInterface: Result Code = 0x8004d01b
> 2006-09-24 20:56:50.62 spid3 Warning ******************
> 2006-09-24 20:56:50.62 spid3 SQL Server started in single user mode.
> Updates allowed to system catalogs.
> 2006-09-24 20:56:50.62 spid3 Starting up database 'master'.
> 2006-09-24 20:56:50.82 server Using 'SSNETLIB.DLL' version '8.0.311'.
> 2006-09-24 20:56:50.82 spid3 Server name is 'LJDESIGNS\LJBUILDER_SC'.
> 2006-09-24 20:56:50.82 spid5 Starting up database 'model'.
> 2006-09-24 20:56:50.82 spid7 Starting up database 'msdb'.
> 2006-09-24 20:56:50.82 spid8 Starting up database 'pubs'.
> 2006-09-24 20:56:50.82 spid9 Starting up database 'Northwind'.
> 2006-09-24 20:56:51.04 server SQL server listening on 127.0.0.1: 1032.
> 2006-09-24 20:56:51.06 server SQL server listening on TCP, Shared Memory,
> Named Pipes.
> 2006-09-24 20:56:51.06 server SQL Server is ready for client connections
> 2006-09-24 20:56:51.57 spid5 Clearing tempdb database.
> 2006-09-24 20:56:52.70 spid5 Starting up database 'tempdb'.
> 2006-09-24 20:56:52.84 spid3 Recovery complete.
> 2006-09-24 20:56:52.89 spid3 Warning: override, autoexec procedures
> skipped.
> 2006-09-24 20:57:03.01 spid51 Error: 15457, Severity: 0, State: 1
> 2006-09-24 20:57:03.01 spid51 Configuration option 'allow updates'
> changed from 0 to 1. Run the RECONFIGURE statement to install..
> 2006-09-24 20:57:03.09 spid51 Error: 15457, Severity: 0, State: 1
> 2006-09-24 20:57:03.09 spid51 Configuration option 'allow updates'
> changed from 1 to 0. Run the RECONFIGURE statement to install..
> 2006-09-24 20:57:03.65 spid3 SQL Server is terminating due to 'stop'
> request from Service Control Manager.
> --
> JB
>
> "JB" wrote:
> > I am trying to install a second instance of sql server 2000. I am running
> > xp
> > pro and using the developer edition. When I run the install, it completes
> > normally. The registry has entries for the new named instance. When I
> > try
> > to register the new server using enterprise manager and add it to a group,
> > first the wizard does not list the new name. If I type in the name and
> > proceed, I eventually get an error message saying "sql server does not
> > exist
> > or access denied. ..." The error log shows that it gets part way with
> > starting the service but then is stopped before completing. I don't
> > remember
> > now the limitations on the Developer Edition, is this one of them or is
> > there
> > another problem? I am using mixed mode with an sa login.
> > --
> > JB
>|||What are you typing in for the name? ServerName\InstanceName
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"JB" <JB@.discussions.microsoft.com> wrote in message
news:C333117C-0509-4459-AD9D-5DEB8566E122@.microsoft.com...
> Per your suggestion. I first installed sp3a on the existing instance of
> SQL
> Server(default instance). This ran without problems and the instance runs
> ok. Then I ran the install for 2nd (named) instance. There aren't many
> options during the install. I generally clicked Next. On one page, my
> user
> name was displayed along with the domain. I entered my password. A page
> or
> two later, I selected mixed mode and entered the sa password. The intall
> seemed to go without any problems. When I then started Enterprise manager
> to
> register the server, first it does not list the new instance in the select
> a
> server page. If I type in the name and continue, I eventually get the
> error, "sql server does not exist or access denied
> ConnectionOpen(Connect()). Same as before. Then I tried to run sp3a on
> the
> just installed named instance. The setup sees the new instance(i.e. it
> shows
> in a list of instances to upgrade) but when I select the instance and
> proceed, eventually I get the error "a service control operation failed
> for
> MSSQL$LJDESIGNS_SC service: 1069 The service did not start due to a logon
> failure." I am running windows xp pro sp 2.
> --
> JB
>
> "Tom Moreau" wrote:
>> Have you tried applying SP3a or SP4? It's not clear what the build
>> number
>> of SQL Server is. This is on Windows 2003, right?
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> ..
>> "JB" <JB@.discussions.microsoft.com> wrote in message
>> news:1B35467F-FEA8-47E1-BB94-3DA14D172E97@.microsoft.com...
>> Here is the whole lot:
>> 2006-09-24 20:56:50.54 server Copyright (C) 1988-2000 Microsoft
>> Corporation.
>> 2006-09-24 20:56:50.54 server All rights reserved.
>> 2006-09-24 20:56:50.54 server Server Process ID is 160.
>> 2006-09-24 20:56:50.54 server Logging SQL Server messages in file
>> 'C:\Program Files\Microsoft SQL Server\MSSQL$LJBUILDER_SC\log\ERRORLOG'.
>> 2006-09-24 20:56:50.56 server SQL Server is starting at priority class
>> 'normal'(2 CPUs detected).
>> 2006-09-24 20:56:50.56 server SQL Server configured for thread mode
>> processing.
>> 2006-09-24 20:56:50.56 server Using dynamic lock allocation. [2500]
>> Lock
>> Blocks, [5000] Lock Owner Blocks.
>> 2006-09-24 20:56:50.59 server Attempting to initialize Distributed
>> Transaction Coordinator.
>> 2006-09-24 20:56:50.60 server Failed to obtain
>> TransactionDispenserInterface: Result Code = 0x8004d01b
>> 2006-09-24 20:56:50.62 spid3 Warning ******************
>> 2006-09-24 20:56:50.62 spid3 SQL Server started in single user mode.
>> Updates allowed to system catalogs.
>> 2006-09-24 20:56:50.62 spid3 Starting up database 'master'.
>> 2006-09-24 20:56:50.82 server Using 'SSNETLIB.DLL' version '8.0.311'.
>> 2006-09-24 20:56:50.82 spid3 Server name is 'LJDESIGNS\LJBUILDER_SC'.
>> 2006-09-24 20:56:50.82 spid5 Starting up database 'model'.
>> 2006-09-24 20:56:50.82 spid7 Starting up database 'msdb'.
>> 2006-09-24 20:56:50.82 spid8 Starting up database 'pubs'.
>> 2006-09-24 20:56:50.82 spid9 Starting up database 'Northwind'.
>> 2006-09-24 20:56:51.04 server SQL server listening on 127.0.0.1: 1032.
>> 2006-09-24 20:56:51.06 server SQL server listening on TCP, Shared
>> Memory,
>> Named Pipes.
>> 2006-09-24 20:56:51.06 server SQL Server is ready for client
>> connections
>> 2006-09-24 20:56:51.57 spid5 Clearing tempdb database.
>> 2006-09-24 20:56:52.70 spid5 Starting up database 'tempdb'.
>> 2006-09-24 20:56:52.84 spid3 Recovery complete.
>> 2006-09-24 20:56:52.89 spid3 Warning: override, autoexec procedures
>> skipped.
>> 2006-09-24 20:57:03.01 spid51 Error: 15457, Severity: 0, State: 1
>> 2006-09-24 20:57:03.01 spid51 Configuration option 'allow updates'
>> changed from 0 to 1. Run the RECONFIGURE statement to install..
>> 2006-09-24 20:57:03.09 spid51 Error: 15457, Severity: 0, State: 1
>> 2006-09-24 20:57:03.09 spid51 Configuration option 'allow updates'
>> changed from 1 to 0. Run the RECONFIGURE statement to install..
>> 2006-09-24 20:57:03.65 spid3 SQL Server is terminating due to 'stop'
>> request from Service Control Manager.
>> --
>> JB
>>
>> "JB" wrote:
>> > I am trying to install a second instance of sql server 2000. I am
>> > running
>> > xp
>> > pro and using the developer edition. When I run the install, it
>> > completes
>> > normally. The registry has entries for the new named instance. When I
>> > try
>> > to register the new server using enterprise manager and add it to a
>> > group,
>> > first the wizard does not list the new name. If I type in the name and
>> > proceed, I eventually get an error message saying "sql server does not
>> > exist
>> > or access denied. ..." The error log shows that it gets part way with
>> > starting the service but then is stopped before completing. I don't
>> > remember
>> > now the limitations on the Developer Edition, is this one of them or is
>> > there
>> > another problem? I am using mixed mode with an sa login.
>> > --
>> > JB
>>|||I typed in just the instance name. I am on the road for a day or two and
won't be able to try servername\instancename until I return to my office.
However, when I tried to run sp3a againt the new instance, it showed
instancename in the selection list. sp3a was then was unable to connect to
the instance and as a result, the sp3a upgrade failed to run. It that case,
there was no issue with servername\instancename since I didn't need to type
anything. In both the sp3a upgrade and register server cases, sql recognizes
that the instance is there, it just cannot make a connection. The failure
has to do with logon but I can't see what the problem is.
--
JB
"Roger Wolter[MSFT]" wrote:
> What are you typing in for the name? ServerName\InstanceName
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "JB" <JB@.discussions.microsoft.com> wrote in message
> news:C333117C-0509-4459-AD9D-5DEB8566E122@.microsoft.com...
> > Per your suggestion. I first installed sp3a on the existing instance of
> > SQL
> > Server(default instance). This ran without problems and the instance runs
> > ok. Then I ran the install for 2nd (named) instance. There aren't many
> > options during the install. I generally clicked Next. On one page, my
> > user
> > name was displayed along with the domain. I entered my password. A page
> > or
> > two later, I selected mixed mode and entered the sa password. The intall
> > seemed to go without any problems. When I then started Enterprise manager
> > to
> > register the server, first it does not list the new instance in the select
> > a
> > server page. If I type in the name and continue, I eventually get the
> > error, "sql server does not exist or access denied
> > ConnectionOpen(Connect()). Same as before. Then I tried to run sp3a on
> > the
> > just installed named instance. The setup sees the new instance(i.e. it
> > shows
> > in a list of instances to upgrade) but when I select the instance and
> > proceed, eventually I get the error "a service control operation failed
> > for
> > MSSQL$LJDESIGNS_SC service: 1069 The service did not start due to a logon
> > failure." I am running windows xp pro sp 2.
> > --
> > JB
> >
> >
> > "Tom Moreau" wrote:
> >
> >> Have you tried applying SP3a or SP4? It's not clear what the build
> >> number
> >> of SQL Server is. This is on Windows 2003, right?
> >>
> >> --
> >> Tom
> >>
> >> ----
> >> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> >> SQL Server MVP
> >> Toronto, ON Canada
> >> ..
> >> "JB" <JB@.discussions.microsoft.com> wrote in message
> >> news:1B35467F-FEA8-47E1-BB94-3DA14D172E97@.microsoft.com...
> >> Here is the whole lot:
> >>
> >> 2006-09-24 20:56:50.54 server Copyright (C) 1988-2000 Microsoft
> >> Corporation.
> >> 2006-09-24 20:56:50.54 server All rights reserved.
> >> 2006-09-24 20:56:50.54 server Server Process ID is 160.
> >> 2006-09-24 20:56:50.54 server Logging SQL Server messages in file
> >> 'C:\Program Files\Microsoft SQL Server\MSSQL$LJBUILDER_SC\log\ERRORLOG'.
> >> 2006-09-24 20:56:50.56 server SQL Server is starting at priority class
> >> 'normal'(2 CPUs detected).
> >> 2006-09-24 20:56:50.56 server SQL Server configured for thread mode
> >> processing.
> >> 2006-09-24 20:56:50.56 server Using dynamic lock allocation. [2500]
> >> Lock
> >> Blocks, [5000] Lock Owner Blocks.
> >> 2006-09-24 20:56:50.59 server Attempting to initialize Distributed
> >> Transaction Coordinator.
> >> 2006-09-24 20:56:50.60 server Failed to obtain
> >> TransactionDispenserInterface: Result Code = 0x8004d01b
> >> 2006-09-24 20:56:50.62 spid3 Warning ******************
> >> 2006-09-24 20:56:50.62 spid3 SQL Server started in single user mode.
> >> Updates allowed to system catalogs.
> >> 2006-09-24 20:56:50.62 spid3 Starting up database 'master'.
> >> 2006-09-24 20:56:50.82 server Using 'SSNETLIB.DLL' version '8.0.311'.
> >> 2006-09-24 20:56:50.82 spid3 Server name is 'LJDESIGNS\LJBUILDER_SC'.
> >> 2006-09-24 20:56:50.82 spid5 Starting up database 'model'.
> >> 2006-09-24 20:56:50.82 spid7 Starting up database 'msdb'.
> >> 2006-09-24 20:56:50.82 spid8 Starting up database 'pubs'.
> >> 2006-09-24 20:56:50.82 spid9 Starting up database 'Northwind'.
> >> 2006-09-24 20:56:51.04 server SQL server listening on 127.0.0.1: 1032.
> >> 2006-09-24 20:56:51.06 server SQL server listening on TCP, Shared
> >> Memory,
> >> Named Pipes.
> >> 2006-09-24 20:56:51.06 server SQL Server is ready for client
> >> connections
> >> 2006-09-24 20:56:51.57 spid5 Clearing tempdb database.
> >> 2006-09-24 20:56:52.70 spid5 Starting up database 'tempdb'.
> >> 2006-09-24 20:56:52.84 spid3 Recovery complete.
> >> 2006-09-24 20:56:52.89 spid3 Warning: override, autoexec procedures
> >> skipped.
> >> 2006-09-24 20:57:03.01 spid51 Error: 15457, Severity: 0, State: 1
> >> 2006-09-24 20:57:03.01 spid51 Configuration option 'allow updates'
> >> changed from 0 to 1. Run the RECONFIGURE statement to install..
> >> 2006-09-24 20:57:03.09 spid51 Error: 15457, Severity: 0, State: 1
> >> 2006-09-24 20:57:03.09 spid51 Configuration option 'allow updates'
> >> changed from 1 to 0. Run the RECONFIGURE statement to install..
> >> 2006-09-24 20:57:03.65 spid3 SQL Server is terminating due to 'stop'
> >> request from Service Control Manager.
> >>
> >> --
> >> JB
> >>
> >>
> >> "JB" wrote:
> >>
> >> > I am trying to install a second instance of sql server 2000. I am
> >> > running
> >> > xp
> >> > pro and using the developer edition. When I run the install, it
> >> > completes
> >> > normally. The registry has entries for the new named instance. When I
> >> > try
> >> > to register the new server using enterprise manager and add it to a
> >> > group,
> >> > first the wizard does not list the new name. If I type in the name and
> >> > proceed, I eventually get an error message saying "sql server does not
> >> > exist
> >> > or access denied. ..." The error log shows that it gets part way with
> >> > starting the service but then is stopped before completing. I don't
> >> > remember
> >> > now the limitations on the Developer Edition, is this one of them or is
> >> > there
> >> > another problem? I am using mixed mode with an sa login.
> >> > --
> >> > JB
> >>
> >>
>
>

Friday, March 30, 2012

Installing MSDE on different plattforms.

Wednesday, March 28, 2012

Installing MS SQL Server 2005 Developer

Installing MS SQL Server 2000

Installing MS Reporting Services Probs

Installing more than one edition

Installing Local SQL2000 Personal Edition

Monday, March 26, 2012

Installing Express on box that already has Developer Edition

Installing Express on box that already has Developer Edition

Installing Developer Edition Management Studio

Installing Developer Edition Management Studio

Installing Developer Edition Management Studio

Installing Client Tools

Installing and Uninstalling Express Edition

Friday, March 23, 2012

Installing A Default Instance AFTER a Named Instance??

installing 2nd instance

installing 2nd instance

installing 2nd instance

Installation Error

Blog Archive

About Me