Installing named instance with sample.msi

I need to install a named instance of the Desktop Engine, so I followed the directions at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_74qd.asp
which has instructions on using Orca to modify sample.msi. I also followed the instructions found at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_8yeq.asp
on how to edit the msi file to create a named instance.
YET, when used, this altered msi installs a DEFAULT instance.
Am I missing something? If so, what?

Thanks for any help,
Allan Sorenson
Crossroads technologyOriginally posted by B1ueboy
I need to install a named instance of the Desktop Engine, so I followed the directions at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_74qd.asp
which has instructions on using Orca to modify sample.msi. I also followed the instructions found at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_8yeq.asp
on how to edit the msi file to create a named instance.
YET, when used, this altered msi installs a DEFAULT instance.
Am I missing something? If so, what?

Thanks for any help,
Allan Sorenson
Crossroads technology

A little more info on the last edit:
Using Orca I added the row named 'SqlInstanceName' with the desired instance name as the value to the 'Property' table.

Installing MSDE with a different instance name

Hi All,
I'm trying (and have been for ages) to install a MSDE server with adifferent instance name than the default. Im setting theinstancename when using the setup.exe file and all seems to installfine, but when I then restart my system the SQL icon appears in thesystem tray but the white circle is completely empty. It saysthat it is not connected.
If i install with the default instance name then all seems to work fine.
Does anyone know what I am doing wrong and what I can do to fix this problem?
Thanks in advance for any help!
The text below is from the BOL (books online). Hope this helps.
(When you install SQL Server 2000 on a computer with no existing installations of SQL Server, Setup specifies the installation of a default instance. However, you can choose to install SQL Server 2000 as a named instance instead by clearing the Default option in the Instance Name dialog box.)

Installing MSDE SP3 to Win98 causes an error.

Ok I have an MSI file that installs an instance of the MSDE. I recently updated my install to used the SP3 MSMs of the MSDE. I have the installation working correctly on XP. However it fails rather quickly on install to Win98. I will paste the log file of the failure below.

To create the installation I used the VisualStudio installer. Afte the installtion I use ORCA and edit the MSI with the following values in the property table.

ProductLanguage = 1033
SqlBlankPwd = 1
SqlSecurityMode = SQL

No special actions are being used by my installer. Yet according to MS the reason for my error is that I am using a special action with a non-c++ dll (KB Article (http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B306627)) . I am guessing that this is something that MS is doing. Has anyone else gotten a successful install of SP3 onto Win98? Any info would be helpful.

Mike Villaronga
mike_villaronga@.yahoo.com

LogFile:

Internal Error 2737. StreamSupportFiles.2D02443E_7002_4C0B_ABC9_EAB2C06 4397B, C:\WINDOWS\TEMP\MSI60B6.TMP, StreamSupportFiles
=== Logging stopped: 2/3/03 10:06:17 ===I have not gotten SP3 to install on win98. I have tried to do it manually as well as from an install shield application. I get an error message that there is a dll missing. It doesn't specify which dll or give any kind of clue.

[SIZE=1]Originally posted by mvillaronga
Ok I have an MSI file that installs an instance of the MSDE. I recently updated my install to used the SP3 MSMs of the MSDE. I have the installation working correctly on XP. However it fails rather quickly on install to Win98. I will paste the log file of the failure below.

I am guessing that this is something that MS is doing. Has anyone else gotten a successful install of SP3 onto Win98? Any info would be helpful.

installing MSDE and instance name

Hi Joe,
The little server icon is called Service Manager and it does not list the
named instances.
To check the status of the named instance that you have installed, you can
type the server name in the Severbox. It is a dropdown cum text box. So you
will be able to type the SQL Server Name.
For a named instance, the SQL Server name would be
<computername>\<Instancename>.
In your case it would be <computername>\JoesDB01.
After typing the server name, click on Refresh Services button and it
should show you the state of the different services, like the SQL Server,
SQL Server Agent, Distributed Transaction Coordinator.
You can control the state of each Service,
1. Start - Click on this to start/Continue the service, if it is Stopped or
Paused
2. Stop - Click on this to stop the Service.
3. Pause - Click on this to pause the service. Pausing, will allow the
current users to work and will not allow new users to connect to the SQL
Server.
You can also installed the SQL Web Data Administrator, to create and manage
Database from
http://www.microsoft.com/downloads/d...798-C57A-419E-
ACBC-2A332CB7F959&displaylang=en
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
Great! This helped a lot. Things seem to be working fine now
Thanks Ashish!
-- Joe
sql

installing MSDE

Hi:
I'm just getting started with ASP.net and am trying to install MSDE. I am getting the error message : Instance specified name is invalid.
I have followed the directions in the downloadpage. Any help??

Thanks
Crystal.How are you installing it?|||Do you have another version of SQL Server running, i.e. 7.0? You may not be able to install MSDE with MSSQL7 running.

installing hotfix SQL2000-KB810185-8.00.0780-ENU

I am attempting to install this hotfix on a second instance of SQL Server
2000 running sp3 on a window 2003 server. I successfully installed the
hotfix on the first instance with no problems following the same sequence of
events against the first instance.
I am unable to install as it tells me one of the files is write locked. I
have shutdown both instances (SQL server and SQL agent) as well as the MSDTC.
I have shutdown the Window 2003 server and attempted to run the install. I
was successfully able to install the hotfixes on 2 instances on another
server running the same products.
The file in question is dbmslpcn.dll.
Any suggestions ?
1. Try renaming the DLL - does this work?
2. Run TLIST (included in windows resource kit) to see what app is holding
a lock to this DLL
syntax: TLIST -m <DLL>/<.exe Name>
3. shutdown all unecessary services and set to manual mode, then reboot.
See KB for a list of services to NOT shut down:
INF: Order of Installation for SQL Server 7.0 Clustering Setup WGID:249
ID: 219264
Do not shut off any services necessary for disk or network access.
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||I ran the tasklist command, found my application that was using the file and
stopped that service. thanks very much for the info
"Fany Vargas [MSFT]" wrote:

> 1. Try renaming the DLL - does this work?
> 2. Run TLIST (included in windows resource kit) to see what app is holding
> a lock to this DLL
> syntax: TLIST -m <DLL>/<.exe Name>
> 3. shutdown all unecessary services and set to manual mode, then reboot.
> See KB for a list of services to NOT shut down:
> INF: Order of Installation for SQL Server 7.0 Clustering Setup WGID:249
> ID: 219264
> Do not shut off any services necessary for disk or network access.
> Fany Vargas
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their
> Microsoft software to better protect against viruses and security
> vulnerabilities. The easiest way to do this is to visit the following
> websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>

installing hotfix SQL2000-KB810185-8.00.0780-ENU

I am attempting to install this hotfix on a second instance of SQL Server
2000 running sp3 on a window 2003 server. I successfully installed the
hotfix on the first instance with no problems following the same sequence of
events against the first instance.
I am unable to install as it tells me one of the files is write locked. I
have shutdown both instances (SQL server and SQL agent) as well as the MSDTC
.
I have shutdown the Window 2003 server and attempted to run the install. I
was successfully able to install the hotfixes on 2 instances on another
server running the same products.
The file in question is dbmslpcn.dll.
Any suggestions ?1. Try renaming the DLL - does this work?
2. Run TLIST (included in windows resource kit) to see what app is holding
a lock to this DLL
syntax: TLIST -m <DLL>/<.exe Name>
3. shutdown all unecessary services and set to manual mode, then reboot.
See KB for a list of services to NOT shut down:
INF: Order of Installation for SQL Server 7.0 Clustering Setup WGID:249
ID: 219264
Do not shut off any services necessary for disk or network access.
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx|||I ran the tasklist command, found my application that was using the file and
stopped that service. thanks very much for the info
"Fany Vargas [MSFT]" wrote:

> 1. Try renaming the DLL - does this work?
> 2. Run TLIST (included in windows resource kit) to see what app is holding
> a lock to this DLL
> syntax: TLIST -m <DLL>/<.exe Name>
> 3. shutdown all unecessary services and set to manual mode, then reboot.
> See KB for a list of services to NOT shut down:
> INF: Order of Installation for SQL Server 7.0 Clustering Setup WGID:249
> ID: 219264
> Do not shut off any services necessary for disk or network access.
> Fany Vargas
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their
> Microsoft software to better protect against viruses and security
> vulnerabilities. The easiest way to do this is to visit the following
> websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>sql

installing hotfix SQL2000-KB810185-8.00.0780-ENU

I am attempting to install this hotfix on a second instance of SQL Server
2000 running sp3 on a window 2003 server. I successfully installed the
hotfix on the first instance with no problems following the same sequence of
events against the first instance.
I am unable to install as it tells me one of the files is write locked. I
have shutdown both instances (SQL server and SQL agent) as well as the MSDTC.
I have shutdown the Window 2003 server and attempted to run the install. I
was successfully able to install the hotfixes on 2 instances on another
server running the same products.
The file in question is dbmslpcn.dll.
Any suggestions ?1. Try renaming the DLL - does this work?
2. Run TLIST (included in windows resource kit) to see what app is holding
a lock to this DLL
syntax: TLIST -m <DLL>/<.exe Name>
3. shutdown all unecessary services and set to manual mode, then reboot.
See KB for a list of services to NOT shut down:
INF: Order of Installation for SQL Server 7.0 Clustering Setup WGID:249
ID: 219264
Do not shut off any services necessary for disk or network access.
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx|||I ran the tasklist command, found my application that was using the file and
stopped that service. thanks very much for the info
"Fany Vargas [MSFT]" wrote:
> 1. Try renaming the DLL - does this work?
> 2. Run TLIST (included in windows resource kit) to see what app is holding
> a lock to this DLL
> syntax: TLIST -m <DLL>/<.exe Name>
> 3. shutdown all unecessary services and set to manual mode, then reboot.
> See KB for a list of services to NOT shut down:
> INF: Order of Installation for SQL Server 7.0 Clustering Setup WGID:249
> ID: 219264
> Do not shut off any services necessary for disk or network access.
> Fany Vargas
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their
> Microsoft software to better protect against viruses and security
> vulnerabilities. The easiest way to do this is to visit the following
> websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>

Installing Enterprise version over Standard

We currently are running one instance of SQL Server 2000 Standard with a few databases. We need to upgrade to Enterprise version to use data cubes. Should we be able to install right over the top of our current instance of SQL Server or will we have to
create a new instance?
Thanks in advance for any help.
Hi,
You can upgrade the SQL Server standard to SQL server enterprise edition
directly.
Steps from boks online:-
How to perform an edition upgrade within SQL Server 2000 (Setup)
To upgrade a SQL Server 2000 installation to a different edition of SQL
Server 2000
1.. Insert the Microsoft SQL Server 2000T compact disc for the edition
you want to install into your CD-ROM drive. If the compact disc does not
autorun, double-click Autorun.exe in the root directory of the compact disc.
2.. Select SQL Server 2000 Components, select Install Database Server, and
then setup prepares the SQL Server Installation Wizard. At the Welcome
screen, click Next.
3.. In Computer Name dialog box, select Local Computer or Remote computer.
4.. In the Installation Selection dialog box, click Upgrade, Remove, or
Add Components to an existing instance of SQL Server, and then click Next.
5.. In the Instance Name dialog box, click Next.
6.. In the Existing Installation dialog box, click Upgrade your existing
installation, and then click Next.
7.. If Setup detects that you are doing an edition upgrade, the Upgrade
dialog box appears. Click Yes, Upgrade my <text specific to the upgrade> to
upgrade the feature set of your current installation, and click Next.
8.. After the upgrade is completed, you are prompted as to whether you
want to install additional components. If you click Yes, the Select
Components dialog box appears. Accept the defaults or select the additional
components you want to install, and then click Next.
You can select an item in the Components list, and then select items from
the related Sub-Components list. Click to select items you want to install;
clear the check box of the items you do not want to install.
9.. When you are finished specifying options, in the Start Copying Files
dialog box, click Next.
10.. In the Setup Complete dialog box, click Yes, I want to restart my
computer now, and then click Finish to complete the edition upgrade.
Thanks
Hari
MCDBA
"mt" <anonymous@.discussions.microsoft.com> wrote in message
news:104B9AD9-3BE2-4B86-84F4-7C22BCD28CAC@.microsoft.com...
> We currently are running one instance of SQL Server 2000 Standard with a
few databases. We need to upgrade to Enterprise version to use data cubes.
Should we be able to install right over the top of our current instance of
SQL Server or will we have to create a new instance?
> Thanks in advance for any help.

Installing Enterprise version over Standard

We currently are running one instance of SQL Server 2000 Standard with a few
databases. We need to upgrade to Enterprise version to use data cubes. Sh
ould we be able to install right over the top of our current instance of SQL
Server or will we have to
create a new instance?
Thanks in advance for any help.Hi,
You can upgrade the SQL Server standard to SQL server enterprise edition
directly.
Steps from boks online:-
How to perform an edition upgrade within SQL Server 2000 (Setup)
To upgrade a SQL Server 2000 installation to a different edition of SQL
Server 2000
1.. Insert the Microsoft SQL Server 2000T compact disc for the edition
you want to install into your CD-ROM drive. If the compact disc does not
autorun, double-click Autorun.exe in the root directory of the compact disc.
2.. Select SQL Server 2000 Components, select Install Database Server, and
then setup prepares the SQL Server Installation Wizard. At the Welcome
screen, click Next.
3.. In Computer Name dialog box, select Local Computer or Remote computer.
4.. In the Installation Selection dialog box, click Upgrade, Remove, or
Add Components to an existing instance of SQL Server, and then click Next.
5.. In the Instance Name dialog box, click Next.
6.. In the Existing Installation dialog box, click Upgrade your existing
installation, and then click Next.
7.. If Setup detects that you are doing an edition upgrade, the Upgrade
dialog box appears. Click Yes, Upgrade my <text specific to the upgrade> to
upgrade the feature set of your current installation, and click Next.
8.. After the upgrade is completed, you are prompted as to whether you
want to install additional components. If you click Yes, the Select
Components dialog box appears. Accept the defaults or select the additional
components you want to install, and then click Next.
You can select an item in the Components list, and then select items from
the related Sub-Components list. Click to select items you want to install;
clear the check box of the items you do not want to install.
9.. When you are finished specifying options, in the Start Copying Files
dialog box, click Next.
10.. In the Setup Complete dialog box, click Yes, I want to restart my
computer now, and then click Finish to complete the edition upgrade.
Thanks
Hari
MCDBA
"mt" <anonymous@.discussions.microsoft.com> wrote in message
news:104B9AD9-3BE2-4B86-84F4-7C22BCD28CAC@.microsoft.com...
> We currently are running one instance of SQL Server 2000 Standard with a
few databases. We need to upgrade to Enterprise version to use data cubes.
Should we be able to install right over the top of our current instance of
SQL Server or will we have to create a new instance?
> Thanks in advance for any help.|||Hi,
You can upgrade the SQL Server standard to SQL server enterprise edition
directly.
Steps from boks online:-
How to perform an edition upgrade within SQL Server 2000 (Setup)
To upgrade a SQL Server 2000 installation to a different edition of SQL
Server 2000
1.. Insert the Microsoft SQL Server 2000T compact disc for the edition
you want to install into your CD-ROM drive. If the compact disc does not
autorun, double-click Autorun.exe in the root directory of the compact disc.
2.. Select SQL Server 2000 Components, select Install Database Server, and
then setup prepares the SQL Server Installation Wizard. At the Welcome
screen, click Next.
3.. In Computer Name dialog box, select Local Computer or Remote computer.
4.. In the Installation Selection dialog box, click Upgrade, Remove, or
Add Components to an existing instance of SQL Server, and then click Next.
5.. In the Instance Name dialog box, click Next.
6.. In the Existing Installation dialog box, click Upgrade your existing
installation, and then click Next.
7.. If Setup detects that you are doing an edition upgrade, the Upgrade
dialog box appears. Click Yes, Upgrade my <text specific to the upgrade> to
upgrade the feature set of your current installation, and click Next.
8.. After the upgrade is completed, you are prompted as to whether you
want to install additional components. If you click Yes, the Select
Components dialog box appears. Accept the defaults or select the additional
components you want to install, and then click Next.
You can select an item in the Components list, and then select items from
the related Sub-Components list. Click to select items you want to install;
clear the check box of the items you do not want to install.
9.. When you are finished specifying options, in the Start Copying Files
dialog box, click Next.
10.. In the Setup Complete dialog box, click Yes, I want to restart my
computer now, and then click Finish to complete the edition upgrade.
Thanks
Hari
MCDBA
"mt" <anonymous@.discussions.microsoft.com> wrote in message
news:104B9AD9-3BE2-4B86-84F4-7C22BCD28CAC@.microsoft.com...
> We currently are running one instance of SQL Server 2000 Standard with a
few databases. We need to upgrade to Enterprise version to use data cubes.
Should we be able to install right over the top of our current instance of
SQL Server or will we have to create a new instance?
> Thanks in advance for any help.

Installing Enterprise version over Standard

We currently are running one instance of SQL Server 2000 Standard with a few databases. We need to upgrade to Enterprise version to use data cubes. Should we be able to install right over the top of our current instance of SQL Server or will we have to create a new instance
Thanks in advance for any help.Hi,
You can upgrade the SQL Server standard to SQL server enterprise edition
directly.
Steps from boks online:-
How to perform an edition upgrade within SQL Server 2000 (Setup)
To upgrade a SQL Server 2000 installation to a different edition of SQL
Server 2000
1.. Insert the Microsoft® SQL Server 2000T compact disc for the edition
you want to install into your CD-ROM drive. If the compact disc does not
autorun, double-click Autorun.exe in the root directory of the compact disc.
2.. Select SQL Server 2000 Components, select Install Database Server, and
then setup prepares the SQL Server Installation Wizard. At the Welcome
screen, click Next.
3.. In Computer Name dialog box, select Local Computer or Remote computer.
4.. In the Installation Selection dialog box, click Upgrade, Remove, or
Add Components to an existing instance of SQL Server, and then click Next.
5.. In the Instance Name dialog box, click Next.
6.. In the Existing Installation dialog box, click Upgrade your existing
installation, and then click Next.
7.. If Setup detects that you are doing an edition upgrade, the Upgrade
dialog box appears. Click Yes, Upgrade my <text specific to the upgrade> to
upgrade the feature set of your current installation, and click Next.
8.. After the upgrade is completed, you are prompted as to whether you
want to install additional components. If you click Yes, the Select
Components dialog box appears. Accept the defaults or select the additional
components you want to install, and then click Next.
You can select an item in the Components list, and then select items from
the related Sub-Components list. Click to select items you want to install;
clear the check box of the items you do not want to install.
9.. When you are finished specifying options, in the Start Copying Files
dialog box, click Next.
10.. In the Setup Complete dialog box, click Yes, I want to restart my
computer now, and then click Finish to complete the edition upgrade.
Thanks
Hari
MCDBA
"mt" <anonymous@.discussions.microsoft.com> wrote in message
news:104B9AD9-3BE2-4B86-84F4-7C22BCD28CAC@.microsoft.com...
> We currently are running one instance of SQL Server 2000 Standard with a
few databases. We need to upgrade to Enterprise version to use data cubes.
Should we be able to install right over the top of our current instance of
SQL Server or will we have to create a new instance?
> Thanks in advance for any help.sql

installing anther sql2005 instance

Hi,
I have installed sql2005 default instance, and I need to install anther named instance. but when I tried to install the s/w it does not give option for new instance instead, it shows only uninstall option.
How can I install anther nameds instance;
thanks in advance.Did you do an upgrade of an existing SQL 2000 instance?

There are a considerable number of factors that would prevent this;
http://support.microsoft.com/kb/910228/en-us?spid=2855&sid=312

Installing and Configuring SSRS on Vista

This config stuff is getting a little bit ridiculous. I already had a
default instance of SQL Server 2005 SP2 down on the machine. I got all of
the IIS components installed on Vista in order to get an installation of
SSRS to go through. There was no installation option for configuration.
After installing, I applied SP2. Then I opened up IIS Manager and set the
app pool to Classic ASP.NET. When I launch RS Configuration, I select my
default instance, click connect, it it promptly blows up with the following
error:
YES, the SQL Server instance is started. If I click continue, it constantly
throws WMI errors. I managed to get to the database configuration and
create the reportserver and reportservertemp databases. Doing anything to
the virtual directories causes RS Configuration to simply abort and shut
down. I obviously can't get to either the reports or reportserver website,
because the config tool crashes and won't setup the virtual directories in
the config. (If I look in IIS admin, neither of the sites has a virtual
directory configured and the connection string is set to SQLEXPRESS and NOT
the default instance that I have on the machine.) This is getting
ridiculous. Does anyone have a manual config checklist which does NOT
require this Config tool, because the RS Config simply does NOT work.
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
ReportServicesConfigUI.WMIProvider.WMIProviderException: A WMI error has
occurred and no additional error information is available. -->
System.Runtime.InteropServices.COMException (0x8000000A)
at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementObject.InvokeMethod(String methodName,
ManagementBaseObject inParameters, InvokeMethodOptions options)
at ReportServicesConfigUI.WMIProvider.RSInstance.RefreshServerStatus()
-- End of inner exception stack trace --
at ReportServicesConfigUI.WMIProvider.RSInstance.RefreshServerStatus()
at
ReportServicesConfigUI.WMIProvider.RSInstance.get_DelayLoadConfiguration()
at
ReportServicesConfigUI.WMIProvider.RSInstance.get_Item(ConfigurationItemNames
itemName)
at ReportServicesConfigUI.ConfigurationManager.ResetStepStatus()
at ReportServicesConfigUI.ConfigurationManager.ChangeMachine()
at ReportServicesConfigUI.ConfigurationManager.LaunchDialog()
at ReportServicesConfigUI.ConfigurationManager.OnActivated(EventArgs e)
at System.Windows.Forms.Form.set_Active(Boolean value)
at System.Windows.Forms.Form.WmActivate(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
CodeBase:
file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
---
RSConfigTool
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase:
file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/RSConfigTool.exe
---
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
CodeBase:
file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
---
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
CodeBase:
file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
---
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
CodeBase:
file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
---
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
CodeBase:
file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
---
System.Management
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
CodeBase:
file:///C:/Windows/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d50a3a/System.Management.dll
---
System.ServiceProcess
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
CodeBase:
file:///C:/Windows/assembly/GAC_MSIL/System.ServiceProcess/2.0.0.0__b03f5f7f11d50a3a/System.ServiceProcess.dll
---
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
For example:
<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
--
Mike - mhotek@.mssqlserver.com
President FilAm Software Technology, Inc
Vice-President MHS Enterprises, Inc
MCITP - SQL Server DBA, MCT
http://www.mssqlserver.com
http://www.mhse.netI hacked my way around and manually added the virtual directory within IIS
Admin for the Reports website. I then hacked and manually input the
<ReportServerVirtualDirectory> within the RSWebApplication.config file. It
at least finds the website now when I go to http://<machine>/reports.
However, it fails on the connection attempt with the VERY unhelpful error
message of:
The attempt to connect to the report server failed. Check your connection
information and that the report server is a compatible version.
So, since I know that it is all compatible, I'm assuming that I missed
something when I manually created the connection string in IIS Admin. Does
anyone have a sample connection string from a working SSRS configuration?
--
Mike - mhotek@.mssqlserver.com
President FilAm Software Technology, Inc
Vice-President MHS Enterprises, Inc
MCITP - SQL Server DBA, MCT
http://www.mssqlserver.com
http://www.mhse.net
"Michael Hotek" <mike.hotek@.mhse.net> wrote in message
news:2D164AE8-B582-4478-8D92-96C284E996DA@.microsoft.com...
> This config stuff is getting a little bit ridiculous. I already had a
> default instance of SQL Server 2005 SP2 down on the machine. I got all of
> the IIS components installed on Vista in order to get an installation of
> SSRS to go through. There was no installation option for configuration.
> After installing, I applied SP2. Then I opened up IIS Manager and set the
> app pool to Classic ASP.NET. When I launch RS Configuration, I select my
> default instance, click connect, it it promptly blows up with the
> following error:
> YES, the SQL Server instance is started. If I click continue, it
> constantly throws WMI errors. I managed to get to the database
> configuration and create the reportserver and reportservertemp databases.
> Doing anything to the virtual directories causes RS Configuration to
> simply abort and shut down. I obviously can't get to either the reports
> or reportserver website, because the config tool crashes and won't setup
> the virtual directories in the config. (If I look in IIS admin, neither
> of the sites has a virtual directory configured and the connection string
> is set to SQLEXPRESS and NOT the default instance that I have on the
> machine.) This is getting ridiculous. Does anyone have a manual config
> checklist which does NOT require this Config tool, because the RS Config
> simply does NOT work.
> See the end of this message for details on invoking
> just-in-time (JIT) debugging instead of this dialog box.
> ************** Exception Text **************
> ReportServicesConfigUI.WMIProvider.WMIProviderException: A WMI error has
> occurred and no additional error information is available. -->
> System.Runtime.InteropServices.COMException (0x8000000A)
> at
> System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32
> errorCode, IntPtr errorInfo)
> at System.Management.ManagementObject.InvokeMethod(String methodName,
> ManagementBaseObject inParameters, InvokeMethodOptions options)
> at ReportServicesConfigUI.WMIProvider.RSInstance.RefreshServerStatus()
> -- End of inner exception stack trace --
> at ReportServicesConfigUI.WMIProvider.RSInstance.RefreshServerStatus()
> at
> ReportServicesConfigUI.WMIProvider.RSInstance.get_DelayLoadConfiguration()
> at
> ReportServicesConfigUI.WMIProvider.RSInstance.get_Item(ConfigurationItemNames
> itemName)
> at ReportServicesConfigUI.ConfigurationManager.ResetStepStatus()
> at ReportServicesConfigUI.ConfigurationManager.ChangeMachine()
> at ReportServicesConfigUI.ConfigurationManager.LaunchDialog()
> at ReportServicesConfigUI.ConfigurationManager.OnActivated(EventArgs e)
> at System.Windows.Forms.Form.set_Active(Boolean value)
> at System.Windows.Forms.Form.WmActivate(Message& m)
> at System.Windows.Forms.Form.WndProc(Message& m)
> at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message&
> m)
> at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
> at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
> IntPtr wparam, IntPtr lparam)
>
> ************** Loaded Assemblies **************
> mscorlib
> Assembly Version: 2.0.0.0
> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
> CodeBase:
> file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
> ---
> RSConfigTool
> Assembly Version: 9.0.242.0
> Win32 Version: 9.00.3042.00
> CodeBase:
> file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/RSConfigTool.exe
> ---
> System.Windows.Forms
> Assembly Version: 2.0.0.0
> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
> CodeBase:
> file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
> ---
> System
> Assembly Version: 2.0.0.0
> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
> CodeBase:
> file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
> ---
> System.Drawing
> Assembly Version: 2.0.0.0
> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
> CodeBase:
> file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
> ---
> System.Xml
> Assembly Version: 2.0.0.0
> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
> CodeBase:
> file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
> ---
> System.Management
> Assembly Version: 2.0.0.0
> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
> CodeBase:
> file:///C:/Windows/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d50a3a/System.Management.dll
> ---
> System.ServiceProcess
> Assembly Version: 2.0.0.0
> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
> CodeBase:
> file:///C:/Windows/assembly/GAC_MSIL/System.ServiceProcess/2.0.0.0__b03f5f7f11d50a3a/System.ServiceProcess.dll
> ---
> ************** JIT Debugging **************
> To enable just-in-time (JIT) debugging, the .config file for this
> application or computer (machine.config) must have the
> jitDebugging value set in the system.windows.forms section.
> The application must also be compiled with debugging
> enabled.
> For example:
> <configuration>
> <system.windows.forms jitDebugging="true" />
> </configuration>
> When JIT debugging is enabled, any unhandled exception
> will be sent to the JIT debugger registered on the computer
> rather than be handled by this dialog box.
> --
> Mike - mhotek@.mssqlserver.com
> President FilAm Software Technology, Inc
> Vice-President MHS Enterprises, Inc
> MCITP - SQL Server DBA, MCT
> http://www.mssqlserver.com
> http://www.mhse.net|||Turn off user account control (UAC) in Vista.
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Michael Hotek" <mike.hotek@.mhse.net> wrote in message
news:91E85C23-8B52-49A4-B1A4-2F0F5CF7B362@.microsoft.com...
>I hacked my way around and manually added the virtual directory within IIS
>Admin for the Reports website. I then hacked and manually input the
><ReportServerVirtualDirectory> within the RSWebApplication.config file. It
>at least finds the website now when I go to http://<machine>/reports.
>However, it fails on the connection attempt with the VERY unhelpful error
>message of:
> The attempt to connect to the report server failed. Check your connection
> information and that the report server is a compatible version.
> So, since I know that it is all compatible, I'm assuming that I missed
> something when I manually created the connection string in IIS Admin.
> Does anyone have a sample connection string from a working SSRS
> configuration?
> --
> Mike - mhotek@.mssqlserver.com
> President FilAm Software Technology, Inc
> Vice-President MHS Enterprises, Inc
> MCITP - SQL Server DBA, MCT
> http://www.mssqlserver.com
> http://www.mhse.net
> "Michael Hotek" <mike.hotek@.mhse.net> wrote in message
> news:2D164AE8-B582-4478-8D92-96C284E996DA@.microsoft.com...
>> This config stuff is getting a little bit ridiculous. I already had a
>> default instance of SQL Server 2005 SP2 down on the machine. I got all
>> of the IIS components installed on Vista in order to get an installation
>> of SSRS to go through. There was no installation option for
>> configuration. After installing, I applied SP2. Then I opened up IIS
>> Manager and set the app pool to Classic ASP.NET. When I launch RS
>> Configuration, I select my default instance, click connect, it it
>> promptly blows up with the following error:
>> YES, the SQL Server instance is started. If I click continue, it
>> constantly throws WMI errors. I managed to get to the database
>> configuration and create the reportserver and reportservertemp databases.
>> Doing anything to the virtual directories causes RS Configuration to
>> simply abort and shut down. I obviously can't get to either the reports
>> or reportserver website, because the config tool crashes and won't setup
>> the virtual directories in the config. (If I look in IIS admin, neither
>> of the sites has a virtual directory configured and the connection string
>> is set to SQLEXPRESS and NOT the default instance that I have on the
>> machine.) This is getting ridiculous. Does anyone have a manual config
>> checklist which does NOT require this Config tool, because the RS Config
>> simply does NOT work.
>> See the end of this message for details on invoking
>> just-in-time (JIT) debugging instead of this dialog box.
>> ************** Exception Text **************
>> ReportServicesConfigUI.WMIProvider.WMIProviderException: A WMI error has
>> occurred and no additional error information is available. -->
>> System.Runtime.InteropServices.COMException (0x8000000A)
>> at
>> System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32
>> errorCode, IntPtr errorInfo)
>> at System.Management.ManagementObject.InvokeMethod(String methodName,
>> ManagementBaseObject inParameters, InvokeMethodOptions options)
>> at ReportServicesConfigUI.WMIProvider.RSInstance.RefreshServerStatus()
>> -- End of inner exception stack trace --
>> at ReportServicesConfigUI.WMIProvider.RSInstance.RefreshServerStatus()
>> at
>> ReportServicesConfigUI.WMIProvider.RSInstance.get_DelayLoadConfiguration()
>> at
>> ReportServicesConfigUI.WMIProvider.RSInstance.get_Item(ConfigurationItemNames
>> itemName)
>> at ReportServicesConfigUI.ConfigurationManager.ResetStepStatus()
>> at ReportServicesConfigUI.ConfigurationManager.ChangeMachine()
>> at ReportServicesConfigUI.ConfigurationManager.LaunchDialog()
>> at ReportServicesConfigUI.ConfigurationManager.OnActivated(EventArgs e)
>> at System.Windows.Forms.Form.set_Active(Boolean value)
>> at System.Windows.Forms.Form.WmActivate(Message& m)
>> at System.Windows.Forms.Form.WndProc(Message& m)
>> at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message&
>> m)
>> at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
>> at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
>> IntPtr wparam, IntPtr lparam)
>>
>> ************** Loaded Assemblies **************
>> mscorlib
>> Assembly Version: 2.0.0.0
>> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
>> CodeBase:
>> file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
>> ---
>> RSConfigTool
>> Assembly Version: 9.0.242.0
>> Win32 Version: 9.00.3042.00
>> CodeBase:
>> file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/RSConfigTool.exe
>> ---
>> System.Windows.Forms
>> Assembly Version: 2.0.0.0
>> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
>> CodeBase:
>> file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
>> ---
>> System
>> Assembly Version: 2.0.0.0
>> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
>> CodeBase:
>> file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
>> ---
>> System.Drawing
>> Assembly Version: 2.0.0.0
>> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
>> CodeBase:
>> file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
>> ---
>> System.Xml
>> Assembly Version: 2.0.0.0
>> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
>> CodeBase:
>> file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
>> ---
>> System.Management
>> Assembly Version: 2.0.0.0
>> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
>> CodeBase:
>> file:///C:/Windows/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d50a3a/System.Management.dll
>> ---
>> System.ServiceProcess
>> Assembly Version: 2.0.0.0
>> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
>> CodeBase:
>> file:///C:/Windows/assembly/GAC_MSIL/System.ServiceProcess/2.0.0.0__b03f5f7f11d50a3a/System.ServiceProcess.dll
>> ---
>> ************** JIT Debugging **************
>> To enable just-in-time (JIT) debugging, the .config file for this
>> application or computer (machine.config) must have the
>> jitDebugging value set in the system.windows.forms section.
>> The application must also be compiled with debugging
>> enabled.
>> For example:
>> <configuration>
>> <system.windows.forms jitDebugging="true" />
>> </configuration>
>> When JIT debugging is enabled, any unhandled exception
>> will be sent to the JIT debugger registered on the computer
>> rather than be handled by this dialog box.
>> --
>> Mike - mhotek@.mssqlserver.com
>> President FilAm Software Technology, Inc
>> Vice-President MHS Enterprises, Inc
>> MCITP - SQL Server DBA, MCT
>> http://www.mssqlserver.com
>> http://www.mhse.net
>

Installing a Second Instance

Hi,
I'm trying to install a 2nd instance on a cluster.
We've setup two cluster groups C101TC001 and C101TC002, one for each instance.
I've stopped all the services and managed to get the installation to run,
but it won't allow me to apply the Service Pack (3a).
It reports an error
An error has occurred while creating virtual resources for clustering. Can
not create a file when that file already exists.
This then invalidates the instance.
Can anyone assist?
Thanks
Bev
After this I'm unable to get the instance registered or even started.
The error message that you got can be due to various reasons. Here is one Microsoft Knowledge base articles that has the same error (but as I said you may be having a
different issue)
BUG: The Setup program of SQL Server 2000 Service Pack 2 or a later version may stop responding in a Windows clustering environment if there is an offline database
http://support.microsoft.com/default...B;EN-US;320524
This KB says the cause is "This problem occurs because Setup program cannot access the database.
During installation in a Windows Clustering environment, Setup program must query the user databases to make sure that all the database files are on disk resources that
have the correct dependencies and the virtual SQL Server resource. The virtual SQL Server resource is required for the failover support. When a database is offline, Setup
program cannot access the database. "
I understand you are installing SP3a and the above KB is for SP2 but one can still get similar error message.
You last point stated that "After this I'm unable to get the instance registered or even started." I think you will need to first concentrate on why this instance is not starting.
Anyways to be able to apply SP3a, the sql instance needs to be running. So, need to troubleshoot why this instance is not coming online. See what errors you get when
you try to being this SQL Server resource online. Try starting it from command promt and see if that works outside the cluster. The errors in SQL Errorlog, NT App, System
logs and cluster.log should be helpful to troubleshoot this further.
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way
to do this is to visit the following websites: http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
sql

Installing a Named SQL Instance

I am migrating a SQL Instance to an existing SQL 2000 cluster that already
has the default instance installed. There is a large user community that
will be accessing the databases in the 2nd instance and I am trying to find a
way to configure the installation so that they can continue to use the same
ODBC connections. Today, they are configured using a single name (such as
RAVEN). Is it possible to configure the 2nd instance using this single name?
Thanks in advance.
You should be able to create a DNS SRV record to point to the named
instance.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Brian" <Brian@.discussions.microsoft.com> wrote in message
news:9FC76909-7CB6-48E2-A5E5-236F7665A150@.microsoft.com...
I am migrating a SQL Instance to an existing SQL 2000 cluster that already
has the default instance installed. There is a large user community that
will be accessing the databases in the 2nd instance and I am trying to find
a
way to configure the installation so that they can continue to use the same
ODBC connections. Today, they are configured using a single name (such as
RAVEN). Is it possible to configure the 2nd instance using this single
name?
Thanks in advance.
|||I remember doing this on a migration, and i had issues with some clients
trying to access using the new DNS record, it ws solved applying MDAC 2.8.
I hope you don't run in this error but try to check this is you experience
any problem.
"Tom Moreau" wrote:

> You should be able to create a DNS SRV record to point to the named
> instance.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "Brian" <Brian@.discussions.microsoft.com> wrote in message
> news:9FC76909-7CB6-48E2-A5E5-236F7665A150@.microsoft.com...
> I am migrating a SQL Instance to an existing SQL 2000 cluster that already
> has the default instance installed. There is a large user community that
> will be accessing the databases in the 2nd instance and I am trying to find
> a
> way to configure the installation so that they can continue to use the same
> ODBC connections. Today, they are configured using a single name (such as
> RAVEN). Is it possible to configure the 2nd instance using this single
> name?
> Thanks in advance.
>
|||I assumed he was using current MDAC, but that's a good point.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Frivas" <Frivas@.discussions.microsoft.com> wrote in message
news:3DFCE095-1AD3-42E5-B97B-D38570E13B8D@.microsoft.com...
I remember doing this on a migration, and i had issues with some clients
trying to access using the new DNS record, it ws solved applying MDAC 2.8.
I hope you don't run in this error but try to check this is you experience
any problem.
"Tom Moreau" wrote:

> You should be able to create a DNS SRV record to point to the named
> instance.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "Brian" <Brian@.discussions.microsoft.com> wrote in message
> news:9FC76909-7CB6-48E2-A5E5-236F7665A150@.microsoft.com...
> I am migrating a SQL Instance to an existing SQL 2000 cluster that already
> has the default instance installed. There is a large user community that
> will be accessing the databases in the 2nd instance and I am trying to
> find
> a
> way to configure the installation so that they can continue to use the
> same
> ODBC connections. Today, they are configured using a single name (such as
> RAVEN). Is it possible to configure the 2nd instance using this single
> name?
> Thanks in advance.
>
|||Named Instance support was introduced in MDAC 2.6. If you have to use an
earlier MDAC stack, you must alias the named instance using the client
network utility on each client.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Frivas" <Frivas@.discussions.microsoft.com> wrote in message
news:3DFCE095-1AD3-42E5-B97B-D38570E13B8D@.microsoft.com...[vbcol=seagreen]
>I remember doing this on a migration, and i had issues with some clients
> trying to access using the new DNS record, it ws solved applying MDAC 2.8.
> I hope you don't run in this error but try to check this is you experience
> any problem.
> "Tom Moreau" wrote:

Installing a local instance of SQL on a Cluster Node

Hi
I have an Active/Passive SQL 2000 Cluster - the OS is W3K Server.
I would like to install a local copy of SQL Server on the node that is
currently passive - if I start the SQL install process, it does give me
this option but I don't know what, if any, problems this might cause.
I appreciate if the currently active node fails, it will failover to
the node which also has a local version running as well.
Has anyone done this? I've tried searching groups and Microsoft without
success.
Thanks
Toby
It's OK to install local instances on cluster nodes. Just make sure the
instance name does not conflict with any instance on the cluster.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
..
<tjbeaumont@.gmail.com> wrote in message
news:1160036955.164570.322690@.i3g2000cwc.googlegro ups.com...
Hi
I have an Active/Passive SQL 2000 Cluster - the OS is W3K Server.
I would like to install a local copy of SQL Server on the node that is
currently passive - if I start the SQL install process, it does give me
this option but I don't know what, if any, problems this might cause.
I appreciate if the currently active node fails, it will failover to
the node which also has a local version running as well.
Has anyone done this? I've tried searching groups and Microsoft without
success.
Thanks
Toby
|||<tjbeaumont@.gmail.com> wrote in message
news:1160036955.164570.322690@.i3g2000cwc.googlegro ups.com...
> Hi
> I have an Active/Passive SQL 2000 Cluster - the OS is W3K Server.
> I would like to install a local copy of SQL Server on the node that is
> currently passive - if I start the SQL install process, it does give me
> this option but I don't know what, if any, problems this might cause.
Yes, you can do it, but it is a violation of the HA spirit. Meaning, why in
the world would you want to screw around and do that when the company has
obviously felt that the other SQL instances (in the cluster) require HA?
Don't mess with the HA environment!
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp
|||That's true for production clusters. But we install standalone SQL instances
on a clustered node all the time on our test clusters.
Linchi
"Russ Kaufmann" wrote:

> <tjbeaumont@.gmail.com> wrote in message
> news:1160036955.164570.322690@.i3g2000cwc.googlegro ups.com...
> Yes, you can do it, but it is a violation of the HA spirit. Meaning, why in
> the world would you want to screw around and do that when the company has
> obviously felt that the other SQL instances (in the cluster) require HA?
> Don't mess with the HA environment!
>
> --
> Russ Kaufmann
> MVP - Windows Server - Clustering
> ClusterHelp.com, a Microsoft Certified Gold Partner
> Web http://www.clusterhelp.com
> Blog http://msmvps.com/clusterhelp
>
>
|||"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:6B70403B-35CF-4773-9160-8FFC9DDC8638@.microsoft.com...
> That's true for production clusters. But we install standalone SQL
> instances
> on a clustered node all the time on our test clusters.
So, your test environment doesn't mirror production?
Actually, I can see doing that.
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp

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 a Database

Hello all...I develop a Database in a Local Instance of a server.
Then, I need to install ALL the New database in a remote server using TCP
connection and, I have no idea how script them and how can I execute this
script remotely. Obviously, I have Administrator permissions on this server
(W2K3).
Any Idea?
Some sample to clarify me the concept?
Thanks
If you're using Enterprise Manager, you can register the remote server with
the local server in EM. Perform a backup of the database with a
right-click, copy the backup file to the remote server (same location if
possible) then restore the database with another right-click. You can also
use Query Analyzer and the Transact-SQL statments (BACKUP and RESTORE) to
perform the backup and restore. Another technique is to use sp_detach_db
and sp_attach_db.
For more information see these topics in the SQL Server Books Online.
Also look at :
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/default...b;en-us;314546
HTH
Jerry
"Nando_uy" <Nandouy@.discussions.microsoft.com> wrote in message
news:2142AE07-CEEE-4FC1-AE1F-D33F417F6D4D@.microsoft.com...
> Hello all...I develop a Database in a Local Instance of a server.
> Then, I need to install ALL the New database in a remote server using TCP
> connection and, I have no idea how script them and how can I execute this
> script remotely. Obviously, I have Administrator permissions on this
> server
> (W2K3).
> Any Idea?
> Some sample to clarify me the concept?
> Thanks

Installing a Database

Hello all...I develop a Database in a Local Instance of a server.
Then, I need to install ALL the New database in a remote server using TCP
connection and, I have no idea how script them and how can I execute this
script remotely. Obviously, I have Administrator permissions on this server
(W2K3).
Any Idea?
Some sample to clarify me the concept?
ThanksIf you're using Enterprise Manager, you can register the remote server with
the local server in EM. Perform a backup of the database with a
right-click, copy the backup file to the remote server (same location if
possible) then restore the database with another right-click. You can also
use Query Analyzer and the Transact-SQL statments (BACKUP and RESTORE) to
perform the backup and restore. Another technique is to use sp_detach_db
and sp_attach_db.
For more information see these topics in the SQL Server Books Online.
Also look at :
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/defaul...kb;en-us;314546
HTH
Jerry
"Nando_uy" <Nandouy@.discussions.microsoft.com> wrote in message
news:2142AE07-CEEE-4FC1-AE1F-D33F417F6D4D@.microsoft.com...
> Hello all...I develop a Database in a Local Instance of a server.
> Then, I need to install ALL the New database in a remote server using TCP
> connection and, I have no idea how script them and how can I execute this
> script remotely. Obviously, I have Administrator permissions on this
> server
> (W2K3).
> Any Idea?
> Some sample to clarify me the concept?
> Thankssql

Installing a Database

Hello all...I develop a Database in a Local Instance of a server.
Then, I need to install ALL the New database in a remote server using TCP
connection and, I have no idea how script them and how can I execute this
script remotely. Obviously, I have Administrator permissions on this server
(W2K3).
Any Idea?
Some sample to clarify me the concept?
ThanksIf you're using Enterprise Manager, you can register the remote server with
the local server in EM. Perform a backup of the database with a
right-click, copy the backup file to the remote server (same location if
possible) then restore the database with another right-click. You can also
use Query Analyzer and the Transact-SQL statments (BACKUP and RESTORE) to
perform the backup and restore. Another technique is to use sp_detach_db
and sp_attach_db.
For more information see these topics in the SQL Server Books Online.
Also look at :
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;314546
HTH
Jerry
"Nando_uy" <Nandouy@.discussions.microsoft.com> wrote in message
news:2142AE07-CEEE-4FC1-AE1F-D33F417F6D4D@.microsoft.com...
> Hello all...I develop a Database in a Local Instance of a server.
> Then, I need to install ALL the New database in a remote server using TCP
> connection and, I have no idea how script them and how can I execute this
> script remotely. Obviously, I have Administrator permissions on this
> server
> (W2K3).
> Any Idea?
> Some sample to clarify me the concept?
> Thanks