How would I go about installing the second node for SQL 2000 cluster? The
first node is up and running.
Think I go it. Thanks-
"Gabe Matteson" <gmatteson.rounder.com.nospam> wrote in message
news:uNZKUQMtHHA.2124@.TK2MSFTNGP02.phx.gbl...
> How would I go about installing the second node for SQL 2000 cluster? The
> first node is up and running.
>
|||Whats the answer ? You cant do this live, can you ?
"Gabe Matteson" <gmatteson.rounder.com.nospam> wrote in message
news:uAIXXWMtHHA.1208@.TK2MSFTNGP05.phx.gbl...
> Think I go it. Thanks-
> "Gabe Matteson" <gmatteson.rounder.com.nospam> wrote in message
> news:uNZKUQMtHHA.2124@.TK2MSFTNGP02.phx.gbl...
>
Showing posts with label second. Show all posts
Showing posts with label second. Show all posts
Friday, March 30, 2012
Install Second Instance Of SQL Server 2005
I'm trying to install a second instance of SQL Server 2005 to an existing
server where Service Pack 2 is installed. Nothing special - no clustering, I
just want an additional instance for QA purposes.
The problem that I'm experiencing is that I receive an error message during
the installation:
Error 1603 installing Microsoft SQL Server 2005 Setup Support Files
The log file doesn't provide any description of an error. My only guess at
this point is that my current instance has higher versions of files than the
ones on the original install disk.
Any suggestions on how to proceed? Should I wipe-out the server and start
over?
I would appreciate any assistance. THANKS!!!
Regards,
RayHi Ray,
You could try running sqlrun.msi (in the setup directory) directly,
instead of the setup.exe. That would forego the installation of the
Setup Support Files. Not sure if that works, though.
--
Regards,
Steve
www.foxville.ch
On Sep 13, 7:08 pm, raz0r9edge <raz0r9e...@.discussions.microsoft.com>
wrote:
> I'm trying to install a second instance of SQL Server 2005 to an existing
> server where Service Pack 2 is installed. Nothing special - no clustering, I
> just want an additional instance for QA purposes.
> The problem that I'm experiencing is that I receive an error message during
> the installation:
> Error 1603 installing Microsoft SQL Server 2005 Setup Support Files
> The log file doesn't provide any description of an error. My only guess at
> this point is that my current instance has higher versions of files than the
> ones on the original install disk.
> Any suggestions on how to proceed? Should I wipe-out the server and start
> over?
> I would appreciate any assistance. THANKS!!!
> Regards,
> Ray
server where Service Pack 2 is installed. Nothing special - no clustering, I
just want an additional instance for QA purposes.
The problem that I'm experiencing is that I receive an error message during
the installation:
Error 1603 installing Microsoft SQL Server 2005 Setup Support Files
The log file doesn't provide any description of an error. My only guess at
this point is that my current instance has higher versions of files than the
ones on the original install disk.
Any suggestions on how to proceed? Should I wipe-out the server and start
over?
I would appreciate any assistance. THANKS!!!
Regards,
RayHi Ray,
You could try running sqlrun.msi (in the setup directory) directly,
instead of the setup.exe. That would forego the installation of the
Setup Support Files. Not sure if that works, though.
--
Regards,
Steve
www.foxville.ch
On Sep 13, 7:08 pm, raz0r9edge <raz0r9e...@.discussions.microsoft.com>
wrote:
> I'm trying to install a second instance of SQL Server 2005 to an existing
> server where Service Pack 2 is installed. Nothing special - no clustering, I
> just want an additional instance for QA purposes.
> The problem that I'm experiencing is that I receive an error message during
> the installation:
> Error 1603 installing Microsoft SQL Server 2005 Setup Support Files
> The log file doesn't provide any description of an error. My only guess at
> this point is that my current instance has higher versions of files than the
> ones on the original install disk.
> Any suggestions on how to proceed? Should I wipe-out the server and start
> over?
> I would appreciate any assistance. THANKS!!!
> Regards,
> Ray
Install roll back
Hi Guys,
During install of msde2000a, at the last few second of
install on a 2000 server box, installation failed and
rollback. Could anyone can help to solve the problem,
below copied from msde log file.
Thanks,
Ted
Action 14:58:50:
DisableNetAccess.2D02443E_7002_4C0B_ABC9_EAB2C0643 97B.
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
E141-427A-AB0C-D3605127224A}
TempFolder is C:\DOCUME~1\C2KUSE~1.CLA\LOCALS~1
\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library C:\DOCUME~1
\C2KUSE~1.CLA\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-
D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
E141-427A-AB0C-D3605127224A}
Starting custom action DisableNetAccess()
Ending custom action DisableNetAccess()
Action 14:58:50: WriteEnvironmentStrings. Updating
environment strings
WriteEnvironmentStrings: Name: PATH, Value: C:\Program
Files\Microsoft SQL Server\80\Tools\Binn\, Action
1610612738
Action 14:58:50: RegisterTypeLibraries. Registering type
libraries
RegisterTypeLibraries: LibID: {10010001-E260-11CF-AE68-
00AA004A34D5}
RegisterTypeLibraries: LibID: {10010001-EB1C-11CF-AE6E-
00AA004A34D5}
RegisterTypeLibraries: LibID: {10010200-740B-11D0-AE7B-
00AA004A34D5}
Action 14:58:51: InstallServices. Installing new services
Action 14:58:51:
InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397 B.
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
E141-427A-AB0C-D3605127224A}
TempFolder is C:\DOCUME~1\C2KUSE~1.CLA\LOCALS~1
\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library C:\DOCUME~1
\C2KUSE~1.CLA\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-
D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
E141-427A-AB0C-D3605127224A}
Starting custom action InstallPerfMon
Registering performance counters from sqlctr.ini
PerfmonLoad routine returned error code 6
Action ended 14:58:52: InstallFinalize. Return value 3.
Action 14:58:52: Rollback. Rolling back action:
If more of the log will help let me know.
Hi Ted,
Is your 2000 server part of a domain or standalone?
bigp
"Ted" <anonymous@.discussions.microsoft.com> wrote in message news:<355701c4c34c$ce848a60$a401280a@.phx.gbl>...
> Hi Guys,
> During install of msde2000a, at the last few second of
> install on a 2000 server box, installation failed and
> rollback. Could anyone can help to solve the problem,
> below copied from msde log file.
> Thanks,
> Ted
>
> Action 14:58:50:
> DisableNetAccess.2D02443E_7002_4C0B_ABC9_EAB2C0643 97B.
> SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
> E141-427A-AB0C-D3605127224A}
> TempFolder is C:\DOCUME~1\C2KUSE~1.CLA\LOCALS~1
> \Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
> Loading extended custom action library C:\DOCUME~1
> \C2KUSE~1.CLA\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-
> D3605127224A}\sqlcax.dll
> SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
> E141-427A-AB0C-D3605127224A}
> Starting custom action DisableNetAccess()
> Ending custom action DisableNetAccess()
> Action 14:58:50: WriteEnvironmentStrings. Updating
> environment strings
> WriteEnvironmentStrings: Name: PATH, Value: C:\Program
> Files\Microsoft SQL Server\80\Tools\Binn\, Action
> 1610612738
> Action 14:58:50: RegisterTypeLibraries. Registering type
> libraries
> RegisterTypeLibraries: LibID: {10010001-E260-11CF-AE68-
> 00AA004A34D5}
> RegisterTypeLibraries: LibID: {10010001-EB1C-11CF-AE6E-
> 00AA004A34D5}
> RegisterTypeLibraries: LibID: {10010200-740B-11D0-AE7B-
> 00AA004A34D5}
> Action 14:58:51: InstallServices. Installing new services
> Action 14:58:51:
> InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397 B.
> SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
> E141-427A-AB0C-D3605127224A}
> TempFolder is C:\DOCUME~1\C2KUSE~1.CLA\LOCALS~1
> \Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
> Loading extended custom action library C:\DOCUME~1
> \C2KUSE~1.CLA\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-
> D3605127224A}\sqlcax.dll
> SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
> E141-427A-AB0C-D3605127224A}
> Starting custom action InstallPerfMon
> Registering performance counters from sqlctr.ini
> PerfmonLoad routine returned error code 6
> Action ended 14:58:52: InstallFinalize. Return value 3.
> Action 14:58:52: Rollback. Rolling back action:
> If more of the log will help let me know.
|||I'm having the same problem he describes. It is a standalone server. I have found several web pages that detail this problem, but have yet to find a solution to it for Windows 2000 professional.
This page outlines the specific problem I'm having:
http://www.crescentbloom.com/III/D/11.htm
But in it's workaround, step 4 is something that my computer doesn't have (a 'Server' item on my services list)
I have also found instructions from Microsoft's site on how to fix this in Win 2003, but they also do not work for Win 2000 Pro. Can anybody be of help? Thank you!
-Greg
*****************************************
* A copy of the whole thread can be found at:
* http://www.sqlmonster.com/Uwe/Forum...erver-msde/681
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse...a630a1edd2a9d2
*****************************************
|||The Server is part of a large domain, I have installed
MSDE on other servers on the same domain and they worked
fine.
>--Original Message--
>Hi Ted,
>Is your 2000 server part of a domain or standalone?
>bigp
>"Ted" <anonymous@.discussions.microsoft.com> wrote in
message news:<355701c4c34c$ce848a60$a401280a@.phx.gbl>...[vbcol=seagreen]
{E09B48B5-[vbcol=seagreen]
{E09B48B5-[vbcol=seagreen]
type[vbcol=seagreen]
services[vbcol=seagreen]
{E09B48B5-[vbcol=seagreen]
{E09B48B5-
>.
>
|||The server service is runing ok
>--Original Message--
>I'm having the same problem he describes. It is a
standalone server. I have found several web pages that
detail this problem, but have yet to find a solution to
it for Windows 2000 professional.
>This page outlines the specific problem I'm having:
>http://www.crescentbloom.com/III/D/11.htm
>But in it's workaround, step 4 is something that my
computer doesn't have (a 'Server' item on my services
list)
>I have also found instructions from Microsoft's site on
how to fix this in Win 2003, but they also do not work
for Win 2000 Pro. Can anybody be of help? Thank you!
>-Greg
>*****************************************
>* A copy of the whole thread can be found at:
>* http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-
msde/681
>*
>* Report spam or abuse by clicking the following URL:
>* http://www.sqlmonster.com/Uwe/Abuse.aspx?
aid=c471d6429e704a1082a630a1edd2a9d2
>*****************************************
>.
>
|||Can your server locate the PDC, the fsmocheck line of dcdiag?
<anonymous@.discussions.microsoft.com> wrote in message news:<43ee01c4c56d$de6b0800$a601280a@.phx.gbl>...[vbcol=seagreen]
> The Server is part of a large domain, I have installed
> MSDE on other servers on the same domain and they worked
> fine.
> message news:<355701c4c34c$ce848a60$a401280a@.phx.gbl>...
> {E09B48B5-
> {E09B48B5-
> type
> services
> {E09B48B5-
> {E09B48B5-
|||It is the pdc.
Do you think it my be rights?
>--Original Message--
>Can your server locate the PDC, the fsmocheck line of
dcdiag?
><anonymous@.discussions.microsoft.com> wrote in message
news:<43ee01c4c56d$de6b0800$a601280a@.phx.gbl>...[vbcol=seagreen]
worked[vbcol=seagreen]
$a401280a@.phx.gbl>...[vbcol=seagreen]
of[vbcol=seagreen]
and[vbcol=seagreen]
problem,[vbcol=seagreen]
DisableNetAccess.2D02443E_7002_4C0B_ABC9_EAB2C0643 97B.[vbcol=seagreen]
AB0C-[vbcol=seagreen]
C:\Program[vbcol=seagreen]
AE68-[vbcol=seagreen]
AE6E-[vbcol=seagreen]
AE7B-[vbcol=seagreen]
InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397 B.[vbcol=seagreen]
AB0C-[vbcol=seagreen]
value 3.
>.
>
During install of msde2000a, at the last few second of
install on a 2000 server box, installation failed and
rollback. Could anyone can help to solve the problem,
below copied from msde log file.
Thanks,
Ted
Action 14:58:50:
DisableNetAccess.2D02443E_7002_4C0B_ABC9_EAB2C0643 97B.
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
E141-427A-AB0C-D3605127224A}
TempFolder is C:\DOCUME~1\C2KUSE~1.CLA\LOCALS~1
\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library C:\DOCUME~1
\C2KUSE~1.CLA\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-
D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
E141-427A-AB0C-D3605127224A}
Starting custom action DisableNetAccess()
Ending custom action DisableNetAccess()
Action 14:58:50: WriteEnvironmentStrings. Updating
environment strings
WriteEnvironmentStrings: Name: PATH, Value: C:\Program
Files\Microsoft SQL Server\80\Tools\Binn\, Action
1610612738
Action 14:58:50: RegisterTypeLibraries. Registering type
libraries
RegisterTypeLibraries: LibID: {10010001-E260-11CF-AE68-
00AA004A34D5}
RegisterTypeLibraries: LibID: {10010001-EB1C-11CF-AE6E-
00AA004A34D5}
RegisterTypeLibraries: LibID: {10010200-740B-11D0-AE7B-
00AA004A34D5}
Action 14:58:51: InstallServices. Installing new services
Action 14:58:51:
InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397 B.
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
E141-427A-AB0C-D3605127224A}
TempFolder is C:\DOCUME~1\C2KUSE~1.CLA\LOCALS~1
\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library C:\DOCUME~1
\C2KUSE~1.CLA\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-
D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
E141-427A-AB0C-D3605127224A}
Starting custom action InstallPerfMon
Registering performance counters from sqlctr.ini
PerfmonLoad routine returned error code 6
Action ended 14:58:52: InstallFinalize. Return value 3.
Action 14:58:52: Rollback. Rolling back action:
If more of the log will help let me know.
Hi Ted,
Is your 2000 server part of a domain or standalone?
bigp
"Ted" <anonymous@.discussions.microsoft.com> wrote in message news:<355701c4c34c$ce848a60$a401280a@.phx.gbl>...
> Hi Guys,
> During install of msde2000a, at the last few second of
> install on a 2000 server box, installation failed and
> rollback. Could anyone can help to solve the problem,
> below copied from msde log file.
> Thanks,
> Ted
>
> Action 14:58:50:
> DisableNetAccess.2D02443E_7002_4C0B_ABC9_EAB2C0643 97B.
> SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
> E141-427A-AB0C-D3605127224A}
> TempFolder is C:\DOCUME~1\C2KUSE~1.CLA\LOCALS~1
> \Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
> Loading extended custom action library C:\DOCUME~1
> \C2KUSE~1.CLA\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-
> D3605127224A}\sqlcax.dll
> SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
> E141-427A-AB0C-D3605127224A}
> Starting custom action DisableNetAccess()
> Ending custom action DisableNetAccess()
> Action 14:58:50: WriteEnvironmentStrings. Updating
> environment strings
> WriteEnvironmentStrings: Name: PATH, Value: C:\Program
> Files\Microsoft SQL Server\80\Tools\Binn\, Action
> 1610612738
> Action 14:58:50: RegisterTypeLibraries. Registering type
> libraries
> RegisterTypeLibraries: LibID: {10010001-E260-11CF-AE68-
> 00AA004A34D5}
> RegisterTypeLibraries: LibID: {10010001-EB1C-11CF-AE6E-
> 00AA004A34D5}
> RegisterTypeLibraries: LibID: {10010200-740B-11D0-AE7B-
> 00AA004A34D5}
> Action 14:58:51: InstallServices. Installing new services
> Action 14:58:51:
> InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397 B.
> SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
> E141-427A-AB0C-D3605127224A}
> TempFolder is C:\DOCUME~1\C2KUSE~1.CLA\LOCALS~1
> \Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
> Loading extended custom action library C:\DOCUME~1
> \C2KUSE~1.CLA\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-
> D3605127224A}\sqlcax.dll
> SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
> E141-427A-AB0C-D3605127224A}
> Starting custom action InstallPerfMon
> Registering performance counters from sqlctr.ini
> PerfmonLoad routine returned error code 6
> Action ended 14:58:52: InstallFinalize. Return value 3.
> Action 14:58:52: Rollback. Rolling back action:
> If more of the log will help let me know.
|||I'm having the same problem he describes. It is a standalone server. I have found several web pages that detail this problem, but have yet to find a solution to it for Windows 2000 professional.
This page outlines the specific problem I'm having:
http://www.crescentbloom.com/III/D/11.htm
But in it's workaround, step 4 is something that my computer doesn't have (a 'Server' item on my services list)
I have also found instructions from Microsoft's site on how to fix this in Win 2003, but they also do not work for Win 2000 Pro. Can anybody be of help? Thank you!
-Greg
*****************************************
* A copy of the whole thread can be found at:
* http://www.sqlmonster.com/Uwe/Forum...erver-msde/681
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse...a630a1edd2a9d2
*****************************************
|||The Server is part of a large domain, I have installed
MSDE on other servers on the same domain and they worked
fine.
>--Original Message--
>Hi Ted,
>Is your 2000 server part of a domain or standalone?
>bigp
>"Ted" <anonymous@.discussions.microsoft.com> wrote in
message news:<355701c4c34c$ce848a60$a401280a@.phx.gbl>...[vbcol=seagreen]
{E09B48B5-[vbcol=seagreen]
{E09B48B5-[vbcol=seagreen]
type[vbcol=seagreen]
services[vbcol=seagreen]
{E09B48B5-[vbcol=seagreen]
{E09B48B5-
>.
>
|||The server service is runing ok
>--Original Message--
>I'm having the same problem he describes. It is a
standalone server. I have found several web pages that
detail this problem, but have yet to find a solution to
it for Windows 2000 professional.
>This page outlines the specific problem I'm having:
>http://www.crescentbloom.com/III/D/11.htm
>But in it's workaround, step 4 is something that my
computer doesn't have (a 'Server' item on my services
list)
>I have also found instructions from Microsoft's site on
how to fix this in Win 2003, but they also do not work
for Win 2000 Pro. Can anybody be of help? Thank you!
>-Greg
>*****************************************
>* A copy of the whole thread can be found at:
>* http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-
msde/681
>*
>* Report spam or abuse by clicking the following URL:
>* http://www.sqlmonster.com/Uwe/Abuse.aspx?
aid=c471d6429e704a1082a630a1edd2a9d2
>*****************************************
>.
>
|||Can your server locate the PDC, the fsmocheck line of dcdiag?
<anonymous@.discussions.microsoft.com> wrote in message news:<43ee01c4c56d$de6b0800$a601280a@.phx.gbl>...[vbcol=seagreen]
> The Server is part of a large domain, I have installed
> MSDE on other servers on the same domain and they worked
> fine.
> message news:<355701c4c34c$ce848a60$a401280a@.phx.gbl>...
> {E09B48B5-
> {E09B48B5-
> type
> services
> {E09B48B5-
> {E09B48B5-
|||It is the pdc.
Do you think it my be rights?
>--Original Message--
>Can your server locate the PDC, the fsmocheck line of
dcdiag?
><anonymous@.discussions.microsoft.com> wrote in message
news:<43ee01c4c56d$de6b0800$a601280a@.phx.gbl>...[vbcol=seagreen]
worked[vbcol=seagreen]
$a401280a@.phx.gbl>...[vbcol=seagreen]
of[vbcol=seagreen]
and[vbcol=seagreen]
problem,[vbcol=seagreen]
DisableNetAccess.2D02443E_7002_4C0B_ABC9_EAB2C0643 97B.[vbcol=seagreen]
AB0C-[vbcol=seagreen]
C:\Program[vbcol=seagreen]
AE68-[vbcol=seagreen]
AE6E-[vbcol=seagreen]
AE7B-[vbcol=seagreen]
InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397 B.[vbcol=seagreen]
AB0C-[vbcol=seagreen]
value 3.
>.
>
Install problems on one system
Hi;
I have VMWare on a test computer and installed the dev version of SqlServer
2005 fine on the frist VM partition.
However, on the second it won't let me check the reporting services and
requires a strong password. Why?
--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htmHi,
For further research, I would like to know:
1. Do your two VMWare partions have the same version of Windows OS?
2. What's the Windows OS edition?
3. What will happen if you specify a strong password for it?
4. Could you send me related system event logs to me
(changliw@.microsoft.com) ?
Sincerely yours,
Charles Wang
Microsoft Online Community Support|||Hi;
1. Yes - same everything.
2. Windows 2003 with all service packs.
3. I did not do that as I want the same p/w we use for everything on the
test system.
4. Will get tomorrow (I'm home now).
--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htm
"Charles Wang[MSFT]" wrote:
> Hi,
> For further research, I would like to know:
> 1. Do your two VMWare partions have the same version of Windows OS?
> 2. What's the Windows OS edition?
> 3. What will happen if you specify a strong password for it?
> 4. Could you send me related system event logs to me
> (changliw@.microsoft.com) ?
> Sincerely yours,
> Charles Wang
> Microsoft Online Community Support
>|||Hi;
For question 4 all it has is:
MsiInstaller - SQL Server 2005 - Install started.
MsiInstaller - SQL Server 2005 - Installation failed.
And the failed is because I cancelled it.
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htm
"Charles Wang[MSFT]" wrote:
> Hi,
> For further research, I would like to know:
> 1. Do your two VMWare partions have the same version of Windows OS?
> 2. What's the Windows OS edition?
> 3. What will happen if you specify a strong password for it?
> 4. Could you send me related system event logs to me
> (changliw@.microsoft.com) ?
> Sincerely yours,
> Charles Wang
> Microsoft Online Community Support
>|||BTW - the big problem is it requiring a strong password for the SqlServer sa
user. That will break all of our unit tests.
--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htm
"Charles Wang[MSFT]" wrote:
> Hi,
> For further research, I would like to know:
> 1. Do your two VMWare partions have the same version of Windows OS?
> 2. What's the Windows OS edition?
> 3. What will happen if you specify a strong password for it?
> 4. Could you send me related system event logs to me
> (changliw@.microsoft.com) ?
> Sincerely yours,
> Charles Wang
> Microsoft Online Community Support
>|||Hi Dave,
Thanks for your response.
By default, strong password is a policy in Windows 2003. From your
description, I understand that your SQL Server 2005 ran with mixed
authentication mode and you log on the SQL 2005 with sa account.
I would like to know whether or not you can log on the SQL Server 2005 with
sa account which password is weak. Which place did this issue occurs?
To let me better understand this issue, I would like you could mail me
(changliw@.microsoft.com) a screenshot of your issue.
In SQL Server 2005, you can modify sa password and cancel the strong
password policy via:
Log on into Microsoft SQL Server Management Studio with sysadmin;
Expand the Security folder;
Expand the Logins folder;
Right click sa account and click Properties on the pop menu;
Cancel the selection of "Enforce password policy";
Modify the sa password if you want to.
Sincerely yours,
Charles Wang
Microsoft Online Community Support|||Hello;
Not exactly. I have not installed Sql Server 2005 yet because of these two
problems.
1) It has greyed out reporting services and I need to install that.
2) It wants a strong password during install. How can I set it to not
require that during install?
What is weird is this is a Windows 2003 test system and I have another
identical test system that did not have these problems. The only difference
is the other system has IIS installed.
So, how can I fix this?
--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htm
"Charles Wang[MSFT]" wrote:
> Hi Dave,
> Thanks for your response.
> By default, strong password is a policy in Windows 2003. From your
> description, I understand that your SQL Server 2005 ran with mixed
> authentication mode and you log on the SQL 2005 with sa account.
> I would like to know whether or not you can log on the SQL Server 2005 with
> sa account which password is weak. Which place did this issue occurs?
> To let me better understand this issue, I would like you could mail me
> (changliw@.microsoft.com) a screenshot of your issue.
> In SQL Server 2005, you can modify sa password and cancel the strong
> password policy via:
> Log on into Microsoft SQL Server Management Studio with sysadmin;
> Expand the Security folder;
> Expand the Logins folder;
> Right click sa account and click Properties on the pop menu;
> Cancel the selection of "Enforce password policy";
> Modify the sa password if you want to.
>
> Sincerely yours,
> Charles Wang
> Microsoft Online Community Support
>
>|||David Thielen wrote:
> Hello;
> Not exactly. I have not installed Sql Server 2005 yet because of these two
> problems.
> 1) It has greyed out reporting services and I need to install that.
> 2) It wants a strong password during install. How can I set it to not
> require that during install?
> What is weird is this is a Windows 2003 test system and I have another
> identical test system that did not have these problems. The only difference
> is the other system has IIS installed.
> So, how can I fix this?
>
Reporting Services requires IIS - that's how it delivers the reports...
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Yes, Reporting Service is a web-based application. I recommend that Install
IIS 6.0 first and then try again.
You can install the component via "Add/Remove Components" from control
panel or "Add or remove a role" from "Manage Your Server" in the start menu.
Sincerely yours,
Charles Wang
Microsoft Online Community Support
======================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Any idea on the strong password requirement?
--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htm
"Charles Wang[MSFT]" wrote:
> Yes, Reporting Service is a web-based application. I recommend that Install
> IIS 6.0 first and then try again.
> You can install the component via "Add/Remove Components" from control
> panel or "Add or remove a role" from "Manage Your Server" in the start menu.
> Sincerely yours,
> Charles Wang
> Microsoft Online Community Support
> ======================================================> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================>|||Hi Dave,
That's due to your windows security policy on password.
You can try executing the statement ALTER LOGIN sa WITH CHECK_POLICY=OFF.
For more information on password policy, you can refer to:
Strong Passwords
http://msdn2.microsoft.com/en-us/library/ms161962.aspx
Password Policy
http://msdn2.microsoft.com/en-us/library/ms161959.aspx
If you have any other questions or concerns, please let me know. It's my
pleasure to be of assistance.
Charles Wang
Microsoft Online Community Support|||Hi;
Let me ask the question a little differently:
1) Why does this copy of Windows 2003 have a strong password policy when
another test system that I installed the same does not?
2) The password it will not allow for Sql Server it did allow as the
administrator password for Windows itself. How is it there is a policy that
requires the strong password only from Sql Server?
3) How can I turn off this policy for all of Windows on this system? It's a
test system so we don't want strong passwords required.
--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htm
"Charles Wang[MSFT]" wrote:
> Hi Dave,
> That's due to your windows security policy on password.
> You can try executing the statement ALTER LOGIN sa WITH CHECK_POLICY=OFF.
> For more information on password policy, you can refer to:
> Strong Passwords
> http://msdn2.microsoft.com/en-us/library/ms161962.aspx
> Password Policy
> http://msdn2.microsoft.com/en-us/library/ms161959.aspx
> If you have any other questions or concerns, please let me know. It's my
> pleasure to be of assistance.
> Charles Wang
> Microsoft Online Community Support
>
>|||Hi Dave,
Appreciate your response.
For your first question, Windows Server 2003 has strong password policy by
default, so if another test system doesn't have that policy, it may be
changed.
For your seconde question, SQL Server doesn't force a database to have
strong password even Windows 2003 has that policy. However this is decided
by authentication mode of SQL Server 2005. If you log on your SQL Server
2005 with Windows Authentication, your SQL Server password policy is based
on Windows policy and should be changed in Windows security policy;
otherwise, if you log on SQL Server 2005 with SQL Authentication, you can
modify the password policy in SQL Server 2005 Management Studio:
1. Expand the the Login of Security node;
2. Right click the login account and click Properties;
3. Cancel the selection of "Enforce password policy".
For your third question, if your computer is in domain, you need cancel the
policy in your domain contrller first. For local configuration, you can do
via "Start->Administrative Tools->Local Security Policy->Account
Policy->Password Policy". Please refer to the following articles to change
the policy:
Account Policy Settings
http://technet2.microsoft.com/WindowsServer/en/library/353f7ad9-b53d-41d0-98
67-199f6595a01b1033.mspx?mfr=true
Step-by-Step Guide to Enforcing Strong Password Policies
http://www.microsoft.com/technet/prodtechnol/windowsserver2003/technologies/
directory/activedirectory/stepbystep/strngpw.mspx
Sincerely yours,
Charles Wang
Microsoft Online Community Support
I have VMWare on a test computer and installed the dev version of SqlServer
2005 fine on the frist VM partition.
However, on the second it won't let me check the reporting services and
requires a strong password. Why?
--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htmHi,
For further research, I would like to know:
1. Do your two VMWare partions have the same version of Windows OS?
2. What's the Windows OS edition?
3. What will happen if you specify a strong password for it?
4. Could you send me related system event logs to me
(changliw@.microsoft.com) ?
Sincerely yours,
Charles Wang
Microsoft Online Community Support|||Hi;
1. Yes - same everything.
2. Windows 2003 with all service packs.
3. I did not do that as I want the same p/w we use for everything on the
test system.
4. Will get tomorrow (I'm home now).
--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htm
"Charles Wang[MSFT]" wrote:
> Hi,
> For further research, I would like to know:
> 1. Do your two VMWare partions have the same version of Windows OS?
> 2. What's the Windows OS edition?
> 3. What will happen if you specify a strong password for it?
> 4. Could you send me related system event logs to me
> (changliw@.microsoft.com) ?
> Sincerely yours,
> Charles Wang
> Microsoft Online Community Support
>|||Hi;
For question 4 all it has is:
MsiInstaller - SQL Server 2005 - Install started.
MsiInstaller - SQL Server 2005 - Installation failed.
And the failed is because I cancelled it.
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htm
"Charles Wang[MSFT]" wrote:
> Hi,
> For further research, I would like to know:
> 1. Do your two VMWare partions have the same version of Windows OS?
> 2. What's the Windows OS edition?
> 3. What will happen if you specify a strong password for it?
> 4. Could you send me related system event logs to me
> (changliw@.microsoft.com) ?
> Sincerely yours,
> Charles Wang
> Microsoft Online Community Support
>|||BTW - the big problem is it requiring a strong password for the SqlServer sa
user. That will break all of our unit tests.
--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htm
"Charles Wang[MSFT]" wrote:
> Hi,
> For further research, I would like to know:
> 1. Do your two VMWare partions have the same version of Windows OS?
> 2. What's the Windows OS edition?
> 3. What will happen if you specify a strong password for it?
> 4. Could you send me related system event logs to me
> (changliw@.microsoft.com) ?
> Sincerely yours,
> Charles Wang
> Microsoft Online Community Support
>|||Hi Dave,
Thanks for your response.
By default, strong password is a policy in Windows 2003. From your
description, I understand that your SQL Server 2005 ran with mixed
authentication mode and you log on the SQL 2005 with sa account.
I would like to know whether or not you can log on the SQL Server 2005 with
sa account which password is weak. Which place did this issue occurs?
To let me better understand this issue, I would like you could mail me
(changliw@.microsoft.com) a screenshot of your issue.
In SQL Server 2005, you can modify sa password and cancel the strong
password policy via:
Log on into Microsoft SQL Server Management Studio with sysadmin;
Expand the Security folder;
Expand the Logins folder;
Right click sa account and click Properties on the pop menu;
Cancel the selection of "Enforce password policy";
Modify the sa password if you want to.
Sincerely yours,
Charles Wang
Microsoft Online Community Support|||Hello;
Not exactly. I have not installed Sql Server 2005 yet because of these two
problems.
1) It has greyed out reporting services and I need to install that.
2) It wants a strong password during install. How can I set it to not
require that during install?
What is weird is this is a Windows 2003 test system and I have another
identical test system that did not have these problems. The only difference
is the other system has IIS installed.
So, how can I fix this?
--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htm
"Charles Wang[MSFT]" wrote:
> Hi Dave,
> Thanks for your response.
> By default, strong password is a policy in Windows 2003. From your
> description, I understand that your SQL Server 2005 ran with mixed
> authentication mode and you log on the SQL 2005 with sa account.
> I would like to know whether or not you can log on the SQL Server 2005 with
> sa account which password is weak. Which place did this issue occurs?
> To let me better understand this issue, I would like you could mail me
> (changliw@.microsoft.com) a screenshot of your issue.
> In SQL Server 2005, you can modify sa password and cancel the strong
> password policy via:
> Log on into Microsoft SQL Server Management Studio with sysadmin;
> Expand the Security folder;
> Expand the Logins folder;
> Right click sa account and click Properties on the pop menu;
> Cancel the selection of "Enforce password policy";
> Modify the sa password if you want to.
>
> Sincerely yours,
> Charles Wang
> Microsoft Online Community Support
>
>|||David Thielen wrote:
> Hello;
> Not exactly. I have not installed Sql Server 2005 yet because of these two
> problems.
> 1) It has greyed out reporting services and I need to install that.
> 2) It wants a strong password during install. How can I set it to not
> require that during install?
> What is weird is this is a Windows 2003 test system and I have another
> identical test system that did not have these problems. The only difference
> is the other system has IIS installed.
> So, how can I fix this?
>
Reporting Services requires IIS - that's how it delivers the reports...
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Yes, Reporting Service is a web-based application. I recommend that Install
IIS 6.0 first and then try again.
You can install the component via "Add/Remove Components" from control
panel or "Add or remove a role" from "Manage Your Server" in the start menu.
Sincerely yours,
Charles Wang
Microsoft Online Community Support
======================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Any idea on the strong password requirement?
--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htm
"Charles Wang[MSFT]" wrote:
> Yes, Reporting Service is a web-based application. I recommend that Install
> IIS 6.0 first and then try again.
> You can install the component via "Add/Remove Components" from control
> panel or "Add or remove a role" from "Manage Your Server" in the start menu.
> Sincerely yours,
> Charles Wang
> Microsoft Online Community Support
> ======================================================> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================>|||Hi Dave,
That's due to your windows security policy on password.
You can try executing the statement ALTER LOGIN sa WITH CHECK_POLICY=OFF.
For more information on password policy, you can refer to:
Strong Passwords
http://msdn2.microsoft.com/en-us/library/ms161962.aspx
Password Policy
http://msdn2.microsoft.com/en-us/library/ms161959.aspx
If you have any other questions or concerns, please let me know. It's my
pleasure to be of assistance.
Charles Wang
Microsoft Online Community Support|||Hi;
Let me ask the question a little differently:
1) Why does this copy of Windows 2003 have a strong password policy when
another test system that I installed the same does not?
2) The password it will not allow for Sql Server it did allow as the
administrator password for Windows itself. How is it there is a policy that
requires the strong password only from Sql Server?
3) How can I turn off this policy for all of Windows on this system? It's a
test system so we don't want strong passwords required.
--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htm
"Charles Wang[MSFT]" wrote:
> Hi Dave,
> That's due to your windows security policy on password.
> You can try executing the statement ALTER LOGIN sa WITH CHECK_POLICY=OFF.
> For more information on password policy, you can refer to:
> Strong Passwords
> http://msdn2.microsoft.com/en-us/library/ms161962.aspx
> Password Policy
> http://msdn2.microsoft.com/en-us/library/ms161959.aspx
> If you have any other questions or concerns, please let me know. It's my
> pleasure to be of assistance.
> Charles Wang
> Microsoft Online Community Support
>
>|||Hi Dave,
Appreciate your response.
For your first question, Windows Server 2003 has strong password policy by
default, so if another test system doesn't have that policy, it may be
changed.
For your seconde question, SQL Server doesn't force a database to have
strong password even Windows 2003 has that policy. However this is decided
by authentication mode of SQL Server 2005. If you log on your SQL Server
2005 with Windows Authentication, your SQL Server password policy is based
on Windows policy and should be changed in Windows security policy;
otherwise, if you log on SQL Server 2005 with SQL Authentication, you can
modify the password policy in SQL Server 2005 Management Studio:
1. Expand the the Login of Security node;
2. Right click the login account and click Properties;
3. Cancel the selection of "Enforce password policy".
For your third question, if your computer is in domain, you need cancel the
policy in your domain contrller first. For local configuration, you can do
via "Start->Administrative Tools->Local Security Policy->Account
Policy->Password Policy". Please refer to the following articles to change
the policy:
Account Policy Settings
http://technet2.microsoft.com/WindowsServer/en/library/353f7ad9-b53d-41d0-98
67-199f6595a01b1033.mspx?mfr=true
Step-by-Step Guide to Enforcing Strong Password Policies
http://www.microsoft.com/technet/prodtechnol/windowsserver2003/technologies/
directory/activedirectory/stepbystep/strngpw.mspx
Sincerely yours,
Charles Wang
Microsoft Online Community Support
Install problems on one system
Hi;
I have VMWare on a test computer and installed the dev version of SqlServer
2005 fine on the frist VM partition.
However, on the second it won't let me check the reporting services and
requires a strong password. Why?
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htmHi,
For further research, I would like to know:
1. Do your two VMWare partions have the same version of Windows OS?
2. What's the Windows OS edition?
3. What will happen if you specify a strong password for it?
4. Could you send me related system event logs to me
(changliw@.microsoft.com) ?
Sincerely yours,
Charles Wang
Microsoft Online Community Support|||Hi;
1. Yes - same everything.
2. Windows 2003 with all service packs.
3. I did not do that as I want the same p/w we use for everything on the
test system.
4. Will get tomorrow (I'm home now).
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htm
"Charles Wang[MSFT]" wrote:
> Hi,
> For further research, I would like to know:
> 1. Do your two VMWare partions have the same version of Windows OS?
> 2. What's the Windows OS edition?
> 3. What will happen if you specify a strong password for it?
> 4. Could you send me related system event logs to me
> (changliw@.microsoft.com) ?
> Sincerely yours,
> Charles Wang
> Microsoft Online Community Support
>|||Hi;
For question 4 all it has is:
MsiInstaller - SQL Server 2005 - Install started.
MsiInstaller - SQL Server 2005 - Installation failed.
And the failed is because I cancelled it.
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htm
"Charles Wang[MSFT]" wrote:
> Hi,
> For further research, I would like to know:
> 1. Do your two VMWare partions have the same version of Windows OS?
> 2. What's the Windows OS edition?
> 3. What will happen if you specify a strong password for it?
> 4. Could you send me related system event logs to me
> (changliw@.microsoft.com) ?
> Sincerely yours,
> Charles Wang
> Microsoft Online Community Support
>|||BTW - the big problem is it requiring a strong password for the SqlServer sa
user. That will break all of our unit tests.
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htm
"Charles Wang[MSFT]" wrote:
> Hi,
> For further research, I would like to know:
> 1. Do your two VMWare partions have the same version of Windows OS?
> 2. What's the Windows OS edition?
> 3. What will happen if you specify a strong password for it?
> 4. Could you send me related system event logs to me
> (changliw@.microsoft.com) ?
> Sincerely yours,
> Charles Wang
> Microsoft Online Community Support
>|||Hi Dave,
Thanks for your response.
By default, strong password is a policy in Windows 2003. From your
description, I understand that your SQL Server 2005 ran with mixed
authentication mode and you log on the SQL 2005 with sa account.
I would like to know whether or not you can log on the SQL Server 2005 with
sa account which password is weak. Which place did this issue occurs?
To let me better understand this issue, I would like you could mail me
(changliw@.microsoft.com) a screenshot of your issue.
In SQL Server 2005, you can modify sa password and cancel the strong
password policy via:
Log on into Microsoft SQL Server Management Studio with sysadmin;
Expand the Security folder;
Expand the Logins folder;
Right click sa account and click Properties on the pop menu;
Cancel the selection of "Enforce password policy";
Modify the sa password if you want to.
Sincerely yours,
Charles Wang
Microsoft Online Community Support|||Hello;
Not exactly. I have not installed Sql Server 2005 yet because of these two
problems.
1) It has greyed out reporting services and I need to install that.
2) It wants a strong password during install. How can I set it to not
require that during install?
What is weird is this is a Windows 2003 test system and I have another
identical test system that did not have these problems. The only difference
is the other system has IIS installed.
So, how can I fix this?
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htm
"Charles Wang[MSFT]" wrote:
> Hi Dave,
> Thanks for your response.
> By default, strong password is a policy in Windows 2003. From your
> description, I understand that your SQL Server 2005 ran with mixed
> authentication mode and you log on the SQL 2005 with sa account.
> I would like to know whether or not you can log on the SQL Server 2005 wit
h
> sa account which password is weak. Which place did this issue occurs?
> To let me better understand this issue, I would like you could mail me
> (changliw@.microsoft.com) a screenshot of your issue.
> In SQL Server 2005, you can modify sa password and cancel the strong
> password policy via:
> Log on into Microsoft SQL Server Management Studio with sysadmin;
> Expand the Security folder;
> Expand the Logins folder;
> Right click sa account and click Properties on the pop menu;
> Cancel the selection of "Enforce password policy";
> Modify the sa password if you want to.
>
> Sincerely yours,
> Charles Wang
> Microsoft Online Community Support
>
>|||David Thielen wrote:
> Hello;
> Not exactly. I have not installed Sql Server 2005 yet because of these two
> problems.
> 1) It has greyed out reporting services and I need to install that.
> 2) It wants a strong password during install. How can I set it to not
> require that during install?
> What is weird is this is a Windows 2003 test system and I have another
> identical test system that did not have these problems. The only differenc
e
> is the other system has IIS installed.
> So, how can I fix this?
>
Reporting Services requires IIS - that's how it delivers the reports...
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Yes, Reporting Service is a web-based application. I recommend that Install
IIS 6.0 first and then try again.
You can install the component via "Add/Remove Components" from control
panel or "Add or remove a role" from "Manage Your Server" in the start menu.
Sincerely yours,
Charles Wang
Microsoft Online Community Support
========================================
==============
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties, and confers no rights.
========================================
==============|||Any idea on the strong password requirement?
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htm
"Charles Wang[MSFT]" wrote:
> Yes, Reporting Service is a web-based application. I recommend that Instal
l
> IIS 6.0 first and then try again.
> You can install the component via "Add/Remove Components" from control
> panel or "Add or remove a role" from "Manage Your Server" in the start men
u.
> Sincerely yours,
> Charles Wang
> Microsoft Online Community Support
> ========================================
==============
> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ========================================
==============
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> ========================================
==============
>sql
I have VMWare on a test computer and installed the dev version of SqlServer
2005 fine on the frist VM partition.
However, on the second it won't let me check the reporting services and
requires a strong password. Why?
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htmHi,
For further research, I would like to know:
1. Do your two VMWare partions have the same version of Windows OS?
2. What's the Windows OS edition?
3. What will happen if you specify a strong password for it?
4. Could you send me related system event logs to me
(changliw@.microsoft.com) ?
Sincerely yours,
Charles Wang
Microsoft Online Community Support|||Hi;
1. Yes - same everything.
2. Windows 2003 with all service packs.
3. I did not do that as I want the same p/w we use for everything on the
test system.
4. Will get tomorrow (I'm home now).
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htm
"Charles Wang[MSFT]" wrote:
> Hi,
> For further research, I would like to know:
> 1. Do your two VMWare partions have the same version of Windows OS?
> 2. What's the Windows OS edition?
> 3. What will happen if you specify a strong password for it?
> 4. Could you send me related system event logs to me
> (changliw@.microsoft.com) ?
> Sincerely yours,
> Charles Wang
> Microsoft Online Community Support
>|||Hi;
For question 4 all it has is:
MsiInstaller - SQL Server 2005 - Install started.
MsiInstaller - SQL Server 2005 - Installation failed.
And the failed is because I cancelled it.
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htm
"Charles Wang[MSFT]" wrote:
> Hi,
> For further research, I would like to know:
> 1. Do your two VMWare partions have the same version of Windows OS?
> 2. What's the Windows OS edition?
> 3. What will happen if you specify a strong password for it?
> 4. Could you send me related system event logs to me
> (changliw@.microsoft.com) ?
> Sincerely yours,
> Charles Wang
> Microsoft Online Community Support
>|||BTW - the big problem is it requiring a strong password for the SqlServer sa
user. That will break all of our unit tests.
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htm
"Charles Wang[MSFT]" wrote:
> Hi,
> For further research, I would like to know:
> 1. Do your two VMWare partions have the same version of Windows OS?
> 2. What's the Windows OS edition?
> 3. What will happen if you specify a strong password for it?
> 4. Could you send me related system event logs to me
> (changliw@.microsoft.com) ?
> Sincerely yours,
> Charles Wang
> Microsoft Online Community Support
>|||Hi Dave,
Thanks for your response.
By default, strong password is a policy in Windows 2003. From your
description, I understand that your SQL Server 2005 ran with mixed
authentication mode and you log on the SQL 2005 with sa account.
I would like to know whether or not you can log on the SQL Server 2005 with
sa account which password is weak. Which place did this issue occurs?
To let me better understand this issue, I would like you could mail me
(changliw@.microsoft.com) a screenshot of your issue.
In SQL Server 2005, you can modify sa password and cancel the strong
password policy via:
Log on into Microsoft SQL Server Management Studio with sysadmin;
Expand the Security folder;
Expand the Logins folder;
Right click sa account and click Properties on the pop menu;
Cancel the selection of "Enforce password policy";
Modify the sa password if you want to.
Sincerely yours,
Charles Wang
Microsoft Online Community Support|||Hello;
Not exactly. I have not installed Sql Server 2005 yet because of these two
problems.
1) It has greyed out reporting services and I need to install that.
2) It wants a strong password during install. How can I set it to not
require that during install?
What is weird is this is a Windows 2003 test system and I have another
identical test system that did not have these problems. The only difference
is the other system has IIS installed.
So, how can I fix this?
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htm
"Charles Wang[MSFT]" wrote:
> Hi Dave,
> Thanks for your response.
> By default, strong password is a policy in Windows 2003. From your
> description, I understand that your SQL Server 2005 ran with mixed
> authentication mode and you log on the SQL 2005 with sa account.
> I would like to know whether or not you can log on the SQL Server 2005 wit
h
> sa account which password is weak. Which place did this issue occurs?
> To let me better understand this issue, I would like you could mail me
> (changliw@.microsoft.com) a screenshot of your issue.
> In SQL Server 2005, you can modify sa password and cancel the strong
> password policy via:
> Log on into Microsoft SQL Server Management Studio with sysadmin;
> Expand the Security folder;
> Expand the Logins folder;
> Right click sa account and click Properties on the pop menu;
> Cancel the selection of "Enforce password policy";
> Modify the sa password if you want to.
>
> Sincerely yours,
> Charles Wang
> Microsoft Online Community Support
>
>|||David Thielen wrote:
> Hello;
> Not exactly. I have not installed Sql Server 2005 yet because of these two
> problems.
> 1) It has greyed out reporting services and I need to install that.
> 2) It wants a strong password during install. How can I set it to not
> require that during install?
> What is weird is this is a Windows 2003 test system and I have another
> identical test system that did not have these problems. The only differenc
e
> is the other system has IIS installed.
> So, how can I fix this?
>
Reporting Services requires IIS - that's how it delivers the reports...
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Yes, Reporting Service is a web-based application. I recommend that Install
IIS 6.0 first and then try again.
You can install the component via "Add/Remove Components" from control
panel or "Add or remove a role" from "Manage Your Server" in the start menu.
Sincerely yours,
Charles Wang
Microsoft Online Community Support
========================================
==============
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties, and confers no rights.
========================================
==============|||Any idea on the strong password requirement?
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htm
"Charles Wang[MSFT]" wrote:
> Yes, Reporting Service is a web-based application. I recommend that Instal
l
> IIS 6.0 first and then try again.
> You can install the component via "Add/Remove Components" from control
> panel or "Add or remove a role" from "Manage Your Server" in the start men
u.
> Sincerely yours,
> Charles Wang
> Microsoft Online Community Support
> ========================================
==============
> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ========================================
==============
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> ========================================
==============
>sql
Monday, March 19, 2012
Installation
I am trying to install msde on server 2003 platform. No matter what I try
when the installation reaches 1 second remaining it then rolls back the
installation process.
hi Ryan,
Ryan wrote:
> I am trying to install msde on server 2003 platform. No matter what I
> try when the installation reaches 1 second remaining it then rolls
> back the installation process.
please add the
/L*v "c:\MsdeLog.txt"
parameter to the setup.exe boostrap installer call, in order to enable
verbose logging of the installation process..
you can later inspect that text file (about 2mb for a complete succesfull
installation) for
RETURN VALUE 3
entries... about 10/15 lines before each entry some (sometime cryptic)
description of the problem will be reported..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||When i try that i get "error opening installation log file. Verify that the
specified log file location exists and is writable" I have verified
everything concerning the log file and still receive this error.
"Andrea Montanari" wrote:
> hi Ryan,
> Ryan wrote:
> please add the
> /L*v "c:\MsdeLog.txt"
> parameter to the setup.exe boostrap installer call, in order to enable
> verbose logging of the installation process..
> you can later inspect that text file (about 2mb for a complete succesfull
> installation) for
> RETURN VALUE 3
> entries... about 10/15 lines before each entry some (sometime cryptic)
> description of the problem will be reported..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||Ryan,
I had exactly the same problem trying to install MSDE SP3. After hours of
searching I never found a definitive answer for the problem. What finally
worked for me was to completely clean out my failed installation attempts
(including the registry) and install MSDE from scratch using the new SP4
file. This file will allow you to create a new install as well as upgrade
existing MSDE installations. The command that I used for the installation
(which installs a named instance) is:
Setup DISABLENETWORKPROTOCOLS=0 INSTANCENAME="mynamedinstance"
SAPWD="mypassword" /L*v C:\MSDE_setup.log
This approach worked for me on the first try. Hope it helps... RS
"Ryan" wrote:
> I am trying to install msde on server 2003 platform. No matter what I try
> when the installation reaches 1 second remaining it then rolls back the
> installation process.
when the installation reaches 1 second remaining it then rolls back the
installation process.
hi Ryan,
Ryan wrote:
> I am trying to install msde on server 2003 platform. No matter what I
> try when the installation reaches 1 second remaining it then rolls
> back the installation process.
please add the
/L*v "c:\MsdeLog.txt"
parameter to the setup.exe boostrap installer call, in order to enable
verbose logging of the installation process..
you can later inspect that text file (about 2mb for a complete succesfull
installation) for
RETURN VALUE 3
entries... about 10/15 lines before each entry some (sometime cryptic)
description of the problem will be reported..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||When i try that i get "error opening installation log file. Verify that the
specified log file location exists and is writable" I have verified
everything concerning the log file and still receive this error.
"Andrea Montanari" wrote:
> hi Ryan,
> Ryan wrote:
> please add the
> /L*v "c:\MsdeLog.txt"
> parameter to the setup.exe boostrap installer call, in order to enable
> verbose logging of the installation process..
> you can later inspect that text file (about 2mb for a complete succesfull
> installation) for
> RETURN VALUE 3
> entries... about 10/15 lines before each entry some (sometime cryptic)
> description of the problem will be reported..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||Ryan,
I had exactly the same problem trying to install MSDE SP3. After hours of
searching I never found a definitive answer for the problem. What finally
worked for me was to completely clean out my failed installation attempts
(including the registry) and install MSDE from scratch using the new SP4
file. This file will allow you to create a new install as well as upgrade
existing MSDE installations. The command that I used for the installation
(which installs a named instance) is:
Setup DISABLENETWORKPROTOCOLS=0 INSTANCENAME="mynamedinstance"
SAPWD="mypassword" /L*v C:\MSDE_setup.log
This approach worked for me on the first try. Hope it helps... RS
"Ryan" wrote:
> I am trying to install msde on server 2003 platform. No matter what I try
> when the installation reaches 1 second remaining it then rolls back the
> installation process.
Friday, March 9, 2012
Inserts per Second
SQL Server 2005;
What rank of inserts per second could be archived
on a modern desktop (1CPU/3GHz/1GB) hardware?
How this compare to a dedicated server hardware?
And most important question;
In a scenario when an applications writes received data to a database.
Which insert method would give the fastest results?
And which method do you recommended for actual use?
(bulk insert, asynchronous inserts, packaged inserts, or something else)
Thanks,
Mitja SemolicYour question is impossible to answer. There are too many variables.
Your "on a modern desktop" question --
Do you mean that you would have SQL Server installed on this "modern
desktop" and you would be inserting data locally?
Or do you mean that a client application would be running on this desktop
and inserting data to a SQL Server ON THE NETWORK?
How is your application written? How are your stored procedures or insert
statements? Do you SET NOCOUNT ON or do you receive the "n rows affected"
from your insert statement?
Did you drop the non-clustered indexes on your tables before running the
inserts?
If you want a super fast "just get the data in there" routine, BULK INSERT
is probably your fastest bet. If you want to be able to create an error
file you will need to use BCP. If you want to insert your data one row at a
time, read the file and call an insert stored procedure or build the T-SQL
within your application to perform the insert.
Keith Kratochvil
"Mitja Semolic" <mitja.semolic@.ensico.si> wrote in message
news:yTDcg.3320$oj5.1032258@.news.siol.net...
> SQL Server 2005;
> What rank of inserts per second could be archived
> on a modern desktop (1CPU/3GHz/1GB) hardware?
> How this compare to a dedicated server hardware?
> And most important question;
> In a scenario when an applications writes received data to a database.
> Which insert method would give the fastest results?
> And which method do you recommended for actual use?
> (bulk insert, asynchronous inserts, packaged inserts, or something else)
> Thanks,
> Mitja Semolic
>|||I was expecting an obsolete answer,
so I wondered if it was worth posting?
I don't want to confuse you with a simple question.
But are there any concrete benchmark result
that could showcase the SQL server performance
in different scenarios and different hardware?
Let me ask you a similar question:s
How fast a car can go, what is its track time?
How many frames per second can draw a graphics card for a specific game?
Are this questions also impossible to answer?
Some thinks should be left simple.
Mitja Semolic
What rank of inserts per second could be archived
on a modern desktop (1CPU/3GHz/1GB) hardware?
How this compare to a dedicated server hardware?
And most important question;
In a scenario when an applications writes received data to a database.
Which insert method would give the fastest results?
And which method do you recommended for actual use?
(bulk insert, asynchronous inserts, packaged inserts, or something else)
Thanks,
Mitja SemolicYour question is impossible to answer. There are too many variables.
Your "on a modern desktop" question --
Do you mean that you would have SQL Server installed on this "modern
desktop" and you would be inserting data locally?
Or do you mean that a client application would be running on this desktop
and inserting data to a SQL Server ON THE NETWORK?
How is your application written? How are your stored procedures or insert
statements? Do you SET NOCOUNT ON or do you receive the "n rows affected"
from your insert statement?
Did you drop the non-clustered indexes on your tables before running the
inserts?
If you want a super fast "just get the data in there" routine, BULK INSERT
is probably your fastest bet. If you want to be able to create an error
file you will need to use BCP. If you want to insert your data one row at a
time, read the file and call an insert stored procedure or build the T-SQL
within your application to perform the insert.
Keith Kratochvil
"Mitja Semolic" <mitja.semolic@.ensico.si> wrote in message
news:yTDcg.3320$oj5.1032258@.news.siol.net...
> SQL Server 2005;
> What rank of inserts per second could be archived
> on a modern desktop (1CPU/3GHz/1GB) hardware?
> How this compare to a dedicated server hardware?
> And most important question;
> In a scenario when an applications writes received data to a database.
> Which insert method would give the fastest results?
> And which method do you recommended for actual use?
> (bulk insert, asynchronous inserts, packaged inserts, or something else)
> Thanks,
> Mitja Semolic
>|||I was expecting an obsolete answer,
so I wondered if it was worth posting?
I don't want to confuse you with a simple question.
But are there any concrete benchmark result
that could showcase the SQL server performance
in different scenarios and different hardware?
Let me ask you a similar question:s
How fast a car can go, what is its track time?
How many frames per second can draw a graphics card for a specific game?
Are this questions also impossible to answer?
Some thinks should be left simple.
Mitja Semolic
Inserts per Second
SQL Server 2005;
What rank of inserts per second could be archived
on a modern desktop (1CPU/3GHz/1GB) hardware?
How this compare to a dedicated server hardware?
And most important question;
In a scenario when an applications writes received data to a database.
Which insert method would give the fastest results?
And which method do you recommended for actual use?
(bulk insert, asynchronous inserts, packaged inserts, or something else)
Thanks,
Mitja SemolicYour question is impossible to answer. There are too many variables.
Your "on a modern desktop" question --
Do you mean that you would have SQL Server installed on this "modern
desktop" and you would be inserting data locally?
Or do you mean that a client application would be running on this desktop
and inserting data to a SQL Server ON THE NETWORK?
How is your application written? How are your stored procedures or insert
statements? Do you SET NOCOUNT ON or do you receive the "n rows affected"
from your insert statement?
Did you drop the non-clustered indexes on your tables before running the
inserts?
If you want a super fast "just get the data in there" routine, BULK INSERT
is probably your fastest bet. If you want to be able to create an error
file you will need to use BCP. If you want to insert your data one row at a
time, read the file and call an insert stored procedure or build the T-SQL
within your application to perform the insert.
Keith Kratochvil
"Mitja Semolic" <mitja.semolic@.ensico.si> wrote in message
news:yTDcg.3320$oj5.1032258@.news.siol.net...
> SQL Server 2005;
> What rank of inserts per second could be archived
> on a modern desktop (1CPU/3GHz/1GB) hardware?
> How this compare to a dedicated server hardware?
> And most important question;
> In a scenario when an applications writes received data to a database.
> Which insert method would give the fastest results?
> And which method do you recommended for actual use?
> (bulk insert, asynchronous inserts, packaged inserts, or something else)
> Thanks,
> Mitja Semolic
>|||I was expecting an obsolete answer,
so I wondered if it was worth posting?
I don't want to confuse you with a simple question.
But are there any concrete benchmark result
that could showcase the SQL server performance
in different scenarios and different hardware?
Let me ask you a similar question:s
How fast a car can go, what is its track time?
How many frames per second can draw a graphics card for a specific game?
Are this questions also impossible to answer?
Some thinks should be left simple.
Mitja Semolic
What rank of inserts per second could be archived
on a modern desktop (1CPU/3GHz/1GB) hardware?
How this compare to a dedicated server hardware?
And most important question;
In a scenario when an applications writes received data to a database.
Which insert method would give the fastest results?
And which method do you recommended for actual use?
(bulk insert, asynchronous inserts, packaged inserts, or something else)
Thanks,
Mitja SemolicYour question is impossible to answer. There are too many variables.
Your "on a modern desktop" question --
Do you mean that you would have SQL Server installed on this "modern
desktop" and you would be inserting data locally?
Or do you mean that a client application would be running on this desktop
and inserting data to a SQL Server ON THE NETWORK?
How is your application written? How are your stored procedures or insert
statements? Do you SET NOCOUNT ON or do you receive the "n rows affected"
from your insert statement?
Did you drop the non-clustered indexes on your tables before running the
inserts?
If you want a super fast "just get the data in there" routine, BULK INSERT
is probably your fastest bet. If you want to be able to create an error
file you will need to use BCP. If you want to insert your data one row at a
time, read the file and call an insert stored procedure or build the T-SQL
within your application to perform the insert.
Keith Kratochvil
"Mitja Semolic" <mitja.semolic@.ensico.si> wrote in message
news:yTDcg.3320$oj5.1032258@.news.siol.net...
> SQL Server 2005;
> What rank of inserts per second could be archived
> on a modern desktop (1CPU/3GHz/1GB) hardware?
> How this compare to a dedicated server hardware?
> And most important question;
> In a scenario when an applications writes received data to a database.
> Which insert method would give the fastest results?
> And which method do you recommended for actual use?
> (bulk insert, asynchronous inserts, packaged inserts, or something else)
> Thanks,
> Mitja Semolic
>|||I was expecting an obsolete answer,
so I wondered if it was worth posting?
I don't want to confuse you with a simple question.
But are there any concrete benchmark result
that could showcase the SQL server performance
in different scenarios and different hardware?
Let me ask you a similar question:s
How fast a car can go, what is its track time?
How many frames per second can draw a graphics card for a specific game?
Are this questions also impossible to answer?
Some thinks should be left simple.
Mitja Semolic
Sunday, February 19, 2012
inserting record into second database from a stored procedure in first database
is it possible to insert record into second database from a stored procedure which is in first database?
If the store proc include an INSERT INTO statement. Run a search for INSERT INTO in SQL Server BOL(books online). Hope this helps.
If the store proc include an INSERT INTO statement. Run a search for INSERT INTO in SQL Server BOL(books online). Hope this helps.
Subscribe to:
Posts (Atom)