Problem with In Place Upgrade of Named Instance?

I have two software products that are accessing the same MSDE Database instance. I recently upgraded the MSDE instance to SQL Express using the in place method. The upgrade runs with success. However, one scenerio is breaking both software products.

1. Product A is not installed

2. An older version of Product B which uses MSDE is intalled.

3. I upgrade the MSDE instance to SQL Express

4. An older version of Product A is installed that uses MSDE.

Note: At this point the install of product A attempts to install an MSDE named instance that is the same as the upgraded instance

5. The install of Product A fails and corrupts the registry keys

6. Now my SQL Express named instance is corrupt and product B can not find the database instance.

Question: Can MSDE and SQL Express run side by side with both having an instance with the same name? I am pretty sure that the answer is going to be No.

If not, how can I prevent this scenerio from occurring. I'm thinking that I will have to do a side by side upgrade creating a new instance with a different name. Then I will have to direct both products to the new named instance. Any ideas or suggestions?

no you can not have the 2 different database engines running with the same instance name. I personally would install the sqlexpress system using the .\SQLEXPRESS instance name as this is the default instance name when using the express or full version visual studio products.

If you do wish to install the systems on the same machine you might be able to direct the instance names by moderfiying the setup ini files on the MSDE System, or the command line tags.

Problem with Enterprise manager and authentication

Hi
I recently upgraded my infrastructure to Active Directory 2003.
Since then I'm having two problems when I start Enterprise Manager and
connect on 2003 sever member with SQL2000 sp3a:
1 On non-member machine, I use SQL authentication to register the server and
in the security log I keep getting dozens of Event ID 529 (unkown username
or bad password) every minutes.
The user in the event is the local account logged on the workstation.
2 on member machines, I have three successfull events (logoff/privilges
assigned/logon) every 10 seconds
In the first case, why does it try to log on with the local account ?
In the second case why does it logoff/logon every 10 seconds ?
I can't remove this audit (international group security policy...) and the
security logs are full in about 2 weeks with 600,000+ events!! I can't
manage that!
Thanks in advance for your help.
Regards,
Christophe Niel
Thats an odd one, have you seen http://support.microsoft.com/?kbid=890477 ?,
looks similar to your problem.
Peter
"Facts are stupid things."
Ronald Reagan
"Christophe Niel" wrote:

> Hi
> I recently upgraded my infrastructure to Active Directory 2003.
> Since then I'm having two problems when I start Enterprise Manager and
> connect on 2003 sever member with SQL2000 sp3a:
> 1 On non-member machine, I use SQL authentication to register the server and
> in the security log I keep getting dozens of Event ID 529 (unkown username
> or bad password) every minutes.
> The user in the event is the local account logged on the workstation.
> 2 on member machines, I have three successfull events (logoff/privilges
> assigned/logon) every 10 seconds
> In the first case, why does it try to log on with the local account ?
> In the second case why does it logoff/logon every 10 seconds ?
>
> I can't remove this audit (international group security policy...) and the
> security logs are full in about 2 weeks with 600,000+ events!! I can't
> manage that!
> Thanks in advance for your help.
> Regards,
> Christophe Niel
>
>
|||Both are probably due to polling services that is
automatically set to check every 10 seconds.
In the first case, because you are logged in as the local
account and it is trying to poll the services from the
workstation using that account.
In Enterprise Manager, go up to the menu to Tools, Options.
You can deselect the checkbox to poll the services.
-Sue
On Wed, 9 Mar 2005 11:25:01 +0100, "Christophe Niel"
<Christophe.niel@.removetomail.fr.abnamro.com> wrote:

>Hi
>I recently upgraded my infrastructure to Active Directory 2003.
>Since then I'm having two problems when I start Enterprise Manager and
>connect on 2003 sever member with SQL2000 sp3a:
>1 On non-member machine, I use SQL authentication to register the server and
>in the security log I keep getting dozens of Event ID 529 (unkown username
>or bad password) every minutes.
>The user in the event is the local account logged on the workstation.
>2 on member machines, I have three successfull events (logoff/privilges
>assigned/logon) every 10 seconds
>In the first case, why does it try to log on with the local account ?
>In the second case why does it logoff/logon every 10 seconds ?
>
>I can't remove this audit (international group security policy...) and the
>security logs are full in about 2 weeks with 600,000+ events!! I can't
>manage that!
>Thanks in advance for your help.
>Regards,
>Christophe Niel
>
|||Wow! it worked!!
and "Doh!"... I've been using enterprise manager for years and I had never
seen an "option" menu (or let's say the polling option didn't strike me as
the cause of my problem)
Well, as I said: it worked and my logs are clean again.
Thanks a lot
Christophe
"Sue Hoegemeier" <Sue_H@.nomail.please> a crit dans le message de news:
3dtt21pbu974t8584n2ae5tifdhca95st0@.4ax.com...
> Both are probably due to polling services that is
> automatically set to check every 10 seconds.
> In the first case, because you are logged in as the local
> account and it is trying to poll the services from the
> workstation using that account.
> In Enterprise Manager, go up to the menu to Tools, Options.
> You can deselect the checkbox to poll the services.
> -Sue
> On Wed, 9 Mar 2005 11:25:01 +0100, "Christophe Niel"
> <Christophe.niel@.removetomail.fr.abnamro.com> wrote:
>

Problem with Enterprise manager and authentication

Hi
I recently upgraded my infrastructure to Active Directory 2003.
Since then I'm having two problems when I start Enterprise Manager and
connect on 2003 sever member with SQL2000 sp3a:
1 On non-member machine, I use SQL authentication to register the server and
in the security log I keep getting dozens of Event ID 529 (unkown username
or bad password) every minutes.
The user in the event is the local account logged on the workstation.
2 on member machines, I have three successfull events (logoff/privilges
assigned/logon) every 10 seconds
In the first case, why does it try to log on with the local account ?
In the second case why does it logoff/logon every 10 seconds ?
I can't remove this audit (international group security policy...) and the
security logs are full in about 2 weeks with 600,000+ events!! I can't
manage that!
Thanks in advance for your help.
Regards,
Christophe NielThats an odd one, have you seen http://support.microsoft.com/?kbid=890477 ?,
looks similar to your problem.
Peter
"Facts are stupid things."
Ronald Reagan
"Christophe Niel" wrote:
> Hi
> I recently upgraded my infrastructure to Active Directory 2003.
> Since then I'm having two problems when I start Enterprise Manager and
> connect on 2003 sever member with SQL2000 sp3a:
> 1 On non-member machine, I use SQL authentication to register the server and
> in the security log I keep getting dozens of Event ID 529 (unkown username
> or bad password) every minutes.
> The user in the event is the local account logged on the workstation.
> 2 on member machines, I have three successfull events (logoff/privilges
> assigned/logon) every 10 seconds
> In the first case, why does it try to log on with the local account ?
> In the second case why does it logoff/logon every 10 seconds ?
>
> I can't remove this audit (international group security policy...) and the
> security logs are full in about 2 weeks with 600,000+ events!! I can't
> manage that!
> Thanks in advance for your help.
> Regards,
> Christophe Niel
>
>|||Both are probably due to polling services that is
automatically set to check every 10 seconds.
In the first case, because you are logged in as the local
account and it is trying to poll the services from the
workstation using that account.
In Enterprise Manager, go up to the menu to Tools, Options.
You can deselect the checkbox to poll the services.
-Sue
On Wed, 9 Mar 2005 11:25:01 +0100, "Christophe Niel"
<Christophe.niel@.removetomail.fr.abnamro.com> wrote:
>Hi
>I recently upgraded my infrastructure to Active Directory 2003.
>Since then I'm having two problems when I start Enterprise Manager and
>connect on 2003 sever member with SQL2000 sp3a:
>1 On non-member machine, I use SQL authentication to register the server and
>in the security log I keep getting dozens of Event ID 529 (unkown username
>or bad password) every minutes.
>The user in the event is the local account logged on the workstation.
>2 on member machines, I have three successfull events (logoff/privilges
>assigned/logon) every 10 seconds
>In the first case, why does it try to log on with the local account ?
>In the second case why does it logoff/logon every 10 seconds ?
>
>I can't remove this audit (international group security policy...) and the
>security logs are full in about 2 weeks with 600,000+ events!! I can't
>manage that!
>Thanks in advance for your help.
>Regards,
>Christophe Niel
>|||Wow! it worked!!
and "Doh!"... I've been using enterprise manager for years and I had never
seen an "option" menu (or let's say the polling option didn't strike me as
the cause of my problem)
Well, as I said: it worked and my logs are clean again.
Thanks a lot
Christophe
"Sue Hoegemeier" <Sue_H@.nomail.please> a écrit dans le message de news:
3dtt21pbu974t8584n2ae5tifdhca95st0@.4ax.com...
> Both are probably due to polling services that is
> automatically set to check every 10 seconds.
> In the first case, because you are logged in as the local
> account and it is trying to poll the services from the
> workstation using that account.
> In Enterprise Manager, go up to the menu to Tools, Options.
> You can deselect the checkbox to poll the services.
> -Sue
> On Wed, 9 Mar 2005 11:25:01 +0100, "Christophe Niel"
> <Christophe.niel@.removetomail.fr.abnamro.com> wrote:
>>Hi
>>I recently upgraded my infrastructure to Active Directory 2003.
>>Since then I'm having two problems when I start Enterprise Manager and
>>connect on 2003 sever member with SQL2000 sp3a:
>>1 On non-member machine, I use SQL authentication to register the server
>>and
>>in the security log I keep getting dozens of Event ID 529 (unkown username
>>or bad password) every minutes.
>>The user in the event is the local account logged on the workstation.
>>2 on member machines, I have three successfull events (logoff/privilges
>>assigned/logon) every 10 seconds
>>In the first case, why does it try to log on with the local account ?
>>In the second case why does it logoff/logon every 10 seconds ?
>>
>>I can't remove this audit (international group security policy...) and the
>>security logs are full in about 2 weeks with 600,000+ events!! I can't
>>manage that!
>>Thanks in advance for your help.
>>Regards,
>>Christophe Niel
>

Problem with Enterprise manager and authentication

Hi
I recently upgraded my infrastructure to Active Directory 2003.
Since then I'm having two problems when I start Enterprise Manager and
connect on 2003 sever member with SQL2000 sp3a:
1 On non-member machine, I use SQL authentication to register the server and
in the security log I keep getting dozens of Event ID 529 (unkown username
or bad password) every minutes.
The user in the event is the local account logged on the workstation.
2 on member machines, I have three successfull events (logoff/privilges
assigned/logon) every 10 seconds
In the first case, why does it try to log on with the local account ?
In the second case why does it logoff/logon every 10 seconds ?
I can't remove this audit (international group security policy...) and the
security logs are full in about 2 weeks with 600,000+ events!! I can't
manage that!
Thanks in advance for your help.
Regards,
Christophe NielThats an odd one, have you seen http://support.microsoft.com/?kbid=890477 ?,
looks similar to your problem.
Peter
"Facts are stupid things."
Ronald Reagan
"Christophe Niel" wrote:

> Hi
> I recently upgraded my infrastructure to Active Directory 2003.
> Since then I'm having two problems when I start Enterprise Manager and
> connect on 2003 sever member with SQL2000 sp3a:
> 1 On non-member machine, I use SQL authentication to register the server a
nd
> in the security log I keep getting dozens of Event ID 529 (unkown username
> or bad password) every minutes.
> The user in the event is the local account logged on the workstation.
> 2 on member machines, I have three successfull events (logoff/privilges
> assigned/logon) every 10 seconds
> In the first case, why does it try to log on with the local account ?
> In the second case why does it logoff/logon every 10 seconds ?
>
> I can't remove this audit (international group security policy...) and the
> security logs are full in about 2 weeks with 600,000+ events!! I can't
> manage that!
> Thanks in advance for your help.
> Regards,
> Christophe Niel
>
>|||Both are probably due to polling services that is
automatically set to check every 10 seconds.
In the first case, because you are logged in as the local
account and it is trying to poll the services from the
workstation using that account.
In Enterprise Manager, go up to the menu to Tools, Options.
You can deselect the checkbox to poll the services.
-Sue
On Wed, 9 Mar 2005 11:25:01 +0100, "Christophe Niel"
<Christophe.niel@.removetomail.fr.abnamro.com> wrote:

>Hi
>I recently upgraded my infrastructure to Active Directory 2003.
>Since then I'm having two problems when I start Enterprise Manager and
>connect on 2003 sever member with SQL2000 sp3a:
>1 On non-member machine, I use SQL authentication to register the server an
d
>in the security log I keep getting dozens of Event ID 529 (unkown username
>or bad password) every minutes.
>The user in the event is the local account logged on the workstation.
>2 on member machines, I have three successfull events (logoff/privilges
>assigned/logon) every 10 seconds
>In the first case, why does it try to log on with the local account ?
>In the second case why does it logoff/logon every 10 seconds ?
>
>I can't remove this audit (international group security policy...) and the
>security logs are full in about 2 weeks with 600,000+ events!! I can't
>manage that!
>Thanks in advance for your help.
>Regards,
>Christophe Niel
>|||Wow! it worked!!
and "Doh!"... I've been using enterprise manager for years and I had never
seen an "option" menu (or let's say the polling option didn't strike me as
the cause of my problem)
Well, as I said: it worked and my logs are clean again.
Thanks a lot
Christophe
"Sue Hoegemeier" <Sue_H@.nomail.please> a crit dans le message de news:
3dtt21pbu974t8584n2ae5tifdhca95st0@.4ax.com...
> Both are probably due to polling services that is
> automatically set to check every 10 seconds.
> In the first case, because you are logged in as the local
> account and it is trying to poll the services from the
> workstation using that account.
> In Enterprise Manager, go up to the menu to Tools, Options.
> You can deselect the checkbox to poll the services.
> -Sue
> On Wed, 9 Mar 2005 11:25:01 +0100, "Christophe Niel"
> <Christophe.niel@.removetomail.fr.abnamro.com> wrote:
>
>