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

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

Install MSDE on New System

I currently have a WinXP system which has MSDE installed. I am replacing
that system with a new one and I want to install MSDE and then move a copy
of all my current DBs. I have MS Office 2003 and I plan to install MSDE from
those CDs. To move copies of the DBs I plan to Detach them at the old
system, copy the DB to the new system and attach it there (and attach it
back on the old system as well - just to be safe)
Is that a reasonable approach or is there a better way?
Wayne
hi Wayne,
Wayne Wengert wrote:
> I currently have a WinXP system which has MSDE installed. I am
> replacing that system with a new one and I want to install MSDE and
> then move a copy of all my current DBs. I have MS Office 2003 and I
> plan to install MSDE from those CDs. To move copies of the DBs I plan
> to Detach them at the old system, copy the DB to the new system and
> attach it there (and attach it back on the old system as well - just
> to be safe)
> Is that a reasonable approach or is there a better way?
> Wayne
it's a reasonable approach ... you can go on..
just a note... if you use SQL Server standard logins, please verify orphaned
user, that's to say users no longer in sync with their respective logins...
this sync is established on the sid column of database..sysusers and
master..syslogins, and where NULL is returned you have orhpaned users
problems.. so please check
http://msdn.microsoft.com/library/de...ca-cz_8qzy.asp
for sp_change_users_login system stored procedure synopsis and
http://www.sqlservercentral.com/colu...okenlogins.asp
Neil Boyle article for further info..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks. Will do!
Wayne
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3cdnj9F6l0itoU1@.individual.net...
> hi Wayne,
> Wayne Wengert wrote:
> it's a reasonable approach ... you can go on..
> just a note... if you use SQL Server standard logins, please verify
orphaned
> user, that's to say users no longer in sync with their respective
logins...
> this sync is established on the sid column of database..sysusers and
> master..syslogins, and where NULL is returned you have orhpaned users
> problems.. so please check
>
http://msdn.microsoft.com/library/de...ca-cz_8qzy.asp
> for sp_change_users_login system stored procedure synopsis and
> http://www.sqlservercentral.com/colu...okenlogins.asp
> Neil Boyle article for further info..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>

Install issue w/MSDE2000 on XP Pro U/G

I have just recently upgraded a system from 98SE to XP
Pro. In doing so the MSDE2000 stopped functioning. I
ran a full uninstall and then tried a reinstall. That
didn't work. Found several KB articles on manually
uninstalling MSDE2000 and I still can't get it to work.
I have have checked that the server service is running,
I've cleaned the temp folder, removed old registry keys,
everything. When I run the install it gets almost to the
end and then rolls backwards, without giving any errors.
I don't want to have to reload the system. Any help on
this matter would be greatly appreciated.
Thank You,
Tim Davis
hi Tim,
"Tim Davis" <tdavis@.ats-computers.com> ha scritto nel messaggio
news:0b3401c49cc7$691475b0$a501280a@.phx.gbl...
> I have just recently upgraded a system from 98SE to XP
> Pro. In doing so the MSDE2000 stopped functioning. I
> ran a full uninstall and then tried a reinstall. That
> didn't work. Found several KB articles on manually
> uninstalling MSDE2000 and I still can't get it to work.
> I have have checked that the server service is running,
> I've cleaned the temp folder, removed old registry keys,
> everything. When I run the install it gets almost to the
> end and then rolls backwards, without giving any errors.
> I don't want to have to reload the system. Any help on
> this matter would be greatly appreciated.
please add the
/L*v "c:\MsdeLog.txt"
parameter to your command line parameter list..
this will instruct MSDE setup to produce a verbose log text file, about 2mb,
where you can search for
RETURN VALUE 3
conditions, which will elaborate the fail causes, in order to help
troubleshouting
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Install Error - Operating System Service Pack Level (SP1)

I am attempting to install SQL Server 2005 Developer Edition (from CD) on my IBM PC with XP Operating System. During set up, I get a error message (see below) telling me about a Service Pack requirement. When I click on the link provided in the error message, it does not lead to any service pack download.

I'm trying to read thru these forum posts, it seems that there is a service pack that I need to download after installing SQL Server 2005. But how can I install the pack after when I can't install SQL Server. Any help would be greatly appreciated. Below is more information about the version of windows my PC has.

My PC: Windows Version 5.1 (Build 2600.xpsp2.030422-1633:Service Pack 1)

Error message from install program:

Operating System Service Pack Level Requirement. (Error)

Messages

Operating System Service Pack Level Requirement.

"The current operating system does not meet Service Pack level requirements for this SQL Server release. Install the most recent Service Pack from the Microsoft download center at http://go.microsoft.com/fwlink/?LinkId=50380, and then run SQL Server Setup again."

SQL Server 2005 Developer Edition needs SP2 on operating sytesm Windows XP. Please update your operating sytem and then install SQL Server 2005 again. Please see the BOL (Books On Line) for detailed inforamtion.

Install Error

Hello, I'm trying to install report services on windows 2003 server. I'm
getting this error message
"System Check Results
IIS is wither not installed or not configured for a server componenet
installation."
I already registed using aspnet_regiis â'i this command and also given
read-write access. I have default website up and running and point to
C:\Inetpub\wwwroot.
Any idea?.Thanks for all your help on this.I am having the exact same issue. Did you resolve it? If so, how?
Thanks in advance.
Eric
"Pandi" wrote:
> Hello, I'm trying to install report services on windows 2003 server. I'm
> getting this error message
> "System Check Results
> IIS is wither not installed or not configured for a server componenet
> installation."
> I already registed using aspnet_regiis â'i this command and also given
> read-write access. I have default website up and running and point to
> C:\Inetpub\wwwroot.
> Any idea?.Thanks for all your help on this.|||Yes I resolve it by uninstalling IIS and reinstall IIS. Looks like
Installation does not work if you have any other web site running on the same
machine.
I had three website running on the same server, now i have only one report
server website running on that box. Looks like report services only run on
default website. I'm trying to move that virtual directory to different
website on the same box, but i could not get this to work. but i will try to
move this to different website eventually.
Thanks , Pandi
"Eric S." wrote:
> I am having the exact same issue. Did you resolve it? If so, how?
> Thanks in advance.
> Eric
> "Pandi" wrote:
> > Hello, I'm trying to install report services on windows 2003 server. I'm
> > getting this error message
> > "System Check Results
> > IIS is wither not installed or not configured for a server componenet
> > installation."
> > I already registed using aspnet_regiis â'i this command and also given
> > read-write access. I have default website up and running and point to
> > C:\Inetpub\wwwroot.
> >
> > Any idea?.Thanks for all your help on this.

installation

Hi. all

A very basic question. I am new to SQL server. I am installing SQL server 2005

Workgroup eddition on window 2000 advance server. The system summary is following:

[System Summary]

OS Name Microsoft Windows 2000 Advanced Server
Version 5.0.2195 Service Pack 4 Build 2195
OS Manufacturer Microsoft Corporation
System Type X86-based PC
Processor x86 Family 6 Model 8 Stepping 0 AuthenticAMD ~1659 Mhz
BIOS Version Phoenix - AwardBIOS v6.00PG
Windows Directory C:\WINNT
System Directory C:\WINNT\system32
Boot Device \Device\Harddisk0\Partition1
Total Physical Memory 753,136 KB
Available Physical Memory 380,024 KB
Total Virtual Memory 2,548,656 KB
Available Virtual Memory 1,846,432 KB
Page File Space 1,795,520 KB
Page File C:\pagefile.sys

When run set up. SCC always show the warning for the minimun hardware requiremnet not satisfied. Which part of the hardware is not enought for this installation?

THanks

Ceiling

I'm not aware of all the checks that occur during install, but the message is merely a warning. Your machine looks sufficient to run SQL Server.

Thanks,
Sam Lester (MSFT)

Install BOL (February 2007)

I have BOL (May 2006) in my system, do I need to remove to install BOL (February 2007)? Is the BOL cummulative?No need to as the BOL update is cumulative, http://sqlserver-qa.net/blogs/sqltools/archive/2007/02/24/bol-a-lower-version-of-this-product-has-been-detected.aspx|||Thanks for the quick reply. I'll try this one.

Inserting records with value outside replication identity ranges

I have a live system that uses merge replication. We are upgrading the
system by setting up a whole new set of servers. When we go live on the new
servers, I would like to copy into the new server database, any changes that
have been made to the old databases. Unfortunately, replication adds check
constraints to identity columns starting with the last identity value in the
database. The old system is still adding id values below the maximum id
(e.g. each region is adding values within their own range which is below the
maximum id in the table.)
I can't just copy the entire database and then setup replication because the
snapshot would take way too long to get to one of the subscribers and we need
to be able to switchover relatively quickly.
Since SQL Server does not let me modify or drop the identity column check
constraint that replication added, how can I add these identity values after
replication has already been set up on the new system?
There could be other issues though. What if the subscriber record is updated
rather than inserted - how will you know which updated rows to take? I think
the simplest way is to sync all subscribers prior to migrating the production
database to the new server. Then using this as the master, set up replication
from the new publisher.
Paul Ibison
|||During the cutover, we will stop all changes to the old database, wait for
replication to sync up, then copy changes from the old publisher over to the
new publisher. then get everyone connected to the new servers.
One of our subscribers is in China where network connectivity is slow and
unreliable. I have tried getting a snapshot with all the data to this
subscriber and it just takes too long - days if it ever succeeds, which so
far it has not. I have to get the snapshot to China with some of the tables
empty, then add the data after.
"Paul Ibison" wrote:

> There could be other issues though. What if the subscriber record is updated
> rather than inserted - how will you know which updated rows to take? I think
> the simplest way is to sync all subscribers prior to migrating the production
> database to the new server. Then using this as the master, set up replication
> from the new publisher.
> Paul Ibison

Inserting Records

pls i have this issue on inserting records into SQL SERVER Express. this is the code so far :-

imports system.data

imports system.data.sqlclient

Protected

Sub btn1_Click(ByVal senderAsObject,ByVal eAs System.EventArgs)Handles btn1.ClickDim strConnAsString = ConfigurationManager.ConnectionStrings("Connect1").ConnectionStringDim ObjConnAsNew SqlConnection(strConn)Dim strCommAsString ="insert Products(ProductName,UnitPrice) values(@.ProductName,@.UnitPrice)"Dim ObjCommAsNew SqlCommand(strComm, ObjConn)

ObjComm.Parameters.AddWithValue(

"@.ProductName", txtprodname.Text)

ObjComm.Parameters.AddWithValue(

"@.UnitPrice", SqlDbType.Money).Value = txtprice.Text

ObjConn.Open()

ObjComm.ExecuteNonQuery()

ObjConn.Close()

EndSub

End

Class

The issue i have is that anytime i click the button to insert a new record, i get two records added to the database automatically

What does the declaration for btn1_Click look like on your .aspx page?|||

tmorton:

What does the declaration for btn1_Click look like on your .aspx page?

pls i dont understand what u mean by declaration for btn1_Click. PLs elaborate.

thanks

|||Sorry, I am trying to ask what the <asp:button declaration looks like for btn1.|||

tmorton:

Sorry, I am trying to ask what the <asp:button declaration looks like for btn1.

Do U mean the On_Click event handler ? If so i used it as

<asp:Button ID="btn1" runat="server" OnClick="btn1_Click"/> if u are still not satisfied with these please recommend a site where i can have a guide or u please help withsome sample codes

|||

websyd:

Do U mean the On_Click event handler ? If so i used it as

<asp:Button ID="btn1" runat="server" OnClick="btn1_Click"/> if u are still not satisfied with these please recommend a site where i can have a guide or u please help withsome sample codes

Yes, that's what I meant. You basically have wired up the Click event twice, as you have it present in your Button declaration, as well as in your "Handles" clause. See Mike Pope's blog post for a bit more explanation:Documenting Event Handlers. You need to remove it from one place or the other, then the code will only run one time. I'd probably just remove the Handles clause from this code:

Sub btn1_Click(ByVal senderAsObject,ByVal eAs System.EventArgs)Handles btn1.Click|||Great Guy, U hav made me happy with this forum again. It worked perfectly OK. Thanks i hope i can always right u to solve my problems as regards ASP.NET