MSDE problems

Hi!

I'm working on a website that will be a webshop in the end. I chosed MSDE as database for the project. Now I have a problem. When i want to have a counter (for the cusomers number for exampel) i can't turn autoincresement on. Well I can, but I can't save it. If i try I get an errormessage.
Why is it so and how will i get it to work?
I'm running the newest version...
Thanks for any help!What is the error message you are receiving?

In order to make a column an Identity column the data type must be integer and it may not allow nulls.

Terri|||I have translated the errormessage from swedish to english. I don't think it's absolutley correkt translated but i hope you will understand it anyway:
(And yes i have the column as Int and not allow nulls)

There was an error saving the design of this table. No changes were made.

[Microsoft][ODBC SQL server driver][SQL server] Unable to create standardvalue on colums with IDENTITY-attribut. Tabel 'tbkunder', column 'kundnummer.
[Microsoft][ODBC SQL server driver][SQL server] Unable to create restriction. Watch previous errormessage.|||This is very difficult with the language difference.

It sounds to me like you are trying to set the IDENTITY property on a column that has a Default Value set, which can't be done.

Terri

MSDE OSQL command

Is there any books or website that will explain in depth about OSQL. Thanks.
Did you try the BOL ?
http://www.aspfaq.com/show.asp?id=2229
HTH, Jens Suessmeyer.
sql

MSDE installation problems

hi

i have downloaded the free MSDERelA from the official website but when i wanna run the installation, it says

"A strong SA password is needed for security reasons.Please use the SAPWD switch to supply the same"

i read the readme doc but i still cant understand how to install n where to find the SAPWD switch ??

Please guide me
Thank you very muchInstructions here

msde installation pro

pls help!!!
I've tried to insatll the msde fr the webmatrix program,and have followed the instructions as said in the website.I aslo get all the screen shots showed on the site,but after 2,3 seconds there is a pop up error message saying,"The instance name specified is invalid".
this is a software that I got through the book Sams teach yorself asp.net in 24hours(the accopmpaning cd has the webmatrix msde n some other software),they have said if we have questions about installing to ask this website.
Need advice as soon as possible!!
shelomi-colombo,sri lanaka.

Try these links and download the MSDE or the full version Evaluation edition. Hope this helps.

http://www.microsoft.com/downloads/details.aspx?FamilyId=413744D1-A0BC-479F-BAFA-E4B278EB9147&displaylang=en

http://www.microsoft.com/sql/evaluation/trial/default.mspx

|||Hi Shelomi,
Please ask your cousin in Toronto for more help
Agent742

MSDE Install Problems

Iam having some problems installing an MSDE database. I have downloaded
MSDE2000A from the microsoft website and iam running the setup from the
command promt using the following command : sql2000.msi BLANKSAPWD=1
the setup starts to run fine, then it gets to a point in the installation
and the progress bar starts to go backwards and the setup exits without any
errors being logged or any indication that the install failed, except that in
the Add / Remove programs section of controll pannel there is nothing related
to MSDE installed.
how can i remedy this situation?It's hard to diagnose with the little information provided.
What version of Windows are you using?
Is there enough disk space?
Do you have admin privileges on the computer?
Watch very carefully while it is installing, an error message may appear on
the screen for just a few seconds before it uninstalls.
Come back with whatever additional information you can provide.
--
Arnie Rowland
"To be successful, your heart must accompany your knowledge."
"Luca" <Luca@.discussions.microsoft.com> wrote in message
news:4B112961-D412-4AF4-9DAE-8ED2692D09ED@.microsoft.com...
> Iam having some problems installing an MSDE database. I have downloaded
> MSDE2000A from the microsoft website and iam running the setup from the
> command promt using the following command : sql2000.msi BLANKSAPWD=1
> the setup starts to run fine, then it gets to a point in the installation
> and the progress bar starts to go backwards and the setup exits without
> any
> errors being logged or any indication that the install failed, except that
> in
> the Add / Remove programs section of controll pannel there is nothing
> related
> to MSDE installed.
> how can i remedy this situation?|||windows server 2003
Plenty of disk space
And no there is no error at all, it gets to 1 seccond remaing then just
starts going backwards..
"Arnie Rowland" wrote:
> It's hard to diagnose with the little information provided.
> What version of Windows are you using?
> Is there enough disk space?
> Do you have admin privileges on the computer?
> Watch very carefully while it is installing, an error message may appear on
> the screen for just a few seconds before it uninstalls.
> Come back with whatever additional information you can provide.
> --
> Arnie Rowland
> "To be successful, your heart must accompany your knowledge."
>
> "Luca" <Luca@.discussions.microsoft.com> wrote in message
> news:4B112961-D412-4AF4-9DAE-8ED2692D09ED@.microsoft.com...
> > Iam having some problems installing an MSDE database. I have downloaded
> > MSDE2000A from the microsoft website and iam running the setup from the
> > command promt using the following command : sql2000.msi BLANKSAPWD=1
> >
> > the setup starts to run fine, then it gets to a point in the installation
> > and the progress bar starts to go backwards and the setup exits without
> > any
> > errors being logged or any indication that the install failed, except that
> > in
> > the Add / Remove programs section of controll pannel there is nothing
> > related
> > to MSDE installed.
> >
> > how can i remedy this situation?
>
>|||hi Luca,
Luca wrote:
> Iam having some problems installing an MSDE database. I have
> downloaded MSDE2000A from the microsoft website and iam running the
> setup from the command promt using the following command :
> sql2000.msi BLANKSAPWD=1
> the setup starts to run fine, then it gets to a point in the
> installation and the progress bar starts to go backwards and the
> setup exits without any errors being logged or any indication that
> the install failed, except that in the Add / Remove programs section
> of controll pannel there is nothing related to MSDE installed.
> how can i remedy this situation?
please add the
/L*v "c:\MsdeLog.txt"
parameter to the
c:\...\>setup.exe BLANKSAPWD=1
(btw, BLANKSAPWD=1 is not a very good choice at all)
command line call to the boostrap installer of MSDE... this will enable
verbose logging of the setup process, resulting in an about 2mb text file
(for a succesufll installation) you can inspect in case of problem..
scan the log file for
RETURN VALUE 3
entries... about 10 lines before each entry you will get some (sometime
cryptic) description of the problem..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
-- remove DMO to reply|||Ok i have added the extra command and have looked at the output.. the only
things i can see that may be causing the errors and that are close to Return
Value 3 are:
InstallSQLAgentSecurity failed (SERVER-NAME,LocalSystem,87).
-
MSI (s) (2C:D4) [09:24:31:823]: Executing op:
End(Checksum=0,ProgressTotalHDWord=0,ProgressTotalLDWord=0)
MSI (s) (2C:D4) [09:24:31:823]: Error in rollback skipped. Return: 5
MSI (s) (2C:D4) [09:24:31:838]: Closing Terminal Server registry propogation
window. Discarding Changes.
MSI (s) (2C:D4) [09:24:31:885]: No System Restore sequence number for this
installation.
not sure if the last one means anything but the - InstallSQLAgentSecurity
failed (SERVER-NAME,LocalSystem,87). looks like something
any ideas?
"Andrea Montanari" wrote:
> hi Luca,
> Luca wrote:
> > Iam having some problems installing an MSDE database. I have
> > downloaded MSDE2000A from the microsoft website and iam running the
> > setup from the command promt using the following command :
> > sql2000.msi BLANKSAPWD=1
> >
> > the setup starts to run fine, then it gets to a point in the
> > installation and the progress bar starts to go backwards and the
> > setup exits without any errors being logged or any indication that
> > the install failed, except that in the Add / Remove programs section
> > of controll pannel there is nothing related to MSDE installed.
> >
> > how can i remedy this situation?
> please add the
> /L*v "c:\MsdeLog.txt"
> parameter to the
> c:\...\>setup.exe BLANKSAPWD=1
> (btw, BLANKSAPWD=1 is not a very good choice at all)
> command line call to the boostrap installer of MSDE... this will enable
> verbose logging of the setup process, resulting in an about 2mb text file
> (for a succesufll installation) you can inspect in case of problem..
> scan the log file for
> RETURN VALUE 3
> entries... about 10 lines before each entry you will get some (sometime
> cryptic) description of the problem..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.bizhttp://italy.mvps.org
> DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
> -- remove DMO to reply
>
>|||hi Luca,
Luca wrote:
> MSI (s) (2C:D4) [09:24:31:838]: Closing Terminal Server registry
> propogation window. Discarding Changes.
> MSI (s) (2C:D4) [09:24:31:885]: No System Restore sequence number for
> this installation.
are you installing MSDE on a Terminal Server session? if this is the case,
this usually causes a lot of problems... try installing it not on TS
session..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
-- remove DMO to reply|||thanks for all your help. i have solved to problem
"Andrea Montanari" wrote:
> hi Luca,
> Luca wrote:
> > MSI (s) (2C:D4) [09:24:31:838]: Closing Terminal Server registry
> > propogation window. Discarding Changes.
> > MSI (s) (2C:D4) [09:24:31:885]: No System Restore sequence number for
> > this installation.
> are you installing MSDE on a Terminal Server session? if this is the case,
> this usually causes a lot of problems... try installing it not on TS
> session..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.bizhttp://italy.mvps.org
> DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
> -- remove DMO to reply
>
>

MSDE Install Problems

Iam having some problems installing an MSDE database. I have downloaded
MSDE2000A from the microsoft website and iam running the setup from the
command promt using the following command : sql2000.msi BLANKSAPWD=1
the setup starts to run fine, then it gets to a point in the installation
and the progress bar starts to go backwards and the setup exits without any
errors being logged or any indication that the install failed, except that i
n
the Add / Remove programs section of controll pannel there is nothing relate
d
to MSDE installed.
how can i remedy this situation?It's hard to diagnose with the little information provided.
What version of Windows are you using?
Is there enough disk space?
Do you have admin privileges on the computer?
Watch very carefully while it is installing, an error message may appear on
the screen for just a few seconds before it uninstalls.
Come back with whatever additional information you can provide.
Arnie Rowland
"To be successful, your heart must accompany your knowledge."
"Luca" <Luca@.discussions.microsoft.com> wrote in message
news:4B112961-D412-4AF4-9DAE-8ED2692D09ED@.microsoft.com...
> Iam having some problems installing an MSDE database. I have downloaded
> MSDE2000A from the microsoft website and iam running the setup from the
> command promt using the following command : sql2000.msi BLANKSAPWD=1
> the setup starts to run fine, then it gets to a point in the installation
> and the progress bar starts to go backwards and the setup exits without
> any
> errors being logged or any indication that the install failed, except that
> in
> the Add / Remove programs section of controll pannel there is nothing
> related
> to MSDE installed.
> how can i remedy this situation?|||windows server 2003
Plenty of disk space
And no there is no error at all, it gets to 1 seccond remaing then just
starts going backwards..
"Arnie Rowland" wrote:

> It's hard to diagnose with the little information provided.
> What version of Windows are you using?
> Is there enough disk space?
> Do you have admin privileges on the computer?
> Watch very carefully while it is installing, an error message may appear o
n
> the screen for just a few seconds before it uninstalls.
> Come back with whatever additional information you can provide.
> --
> Arnie Rowland
> "To be successful, your heart must accompany your knowledge."
>
> "Luca" <Luca@.discussions.microsoft.com> wrote in message
> news:4B112961-D412-4AF4-9DAE-8ED2692D09ED@.microsoft.com...
>
>|||hi Luca,
Luca wrote:
> Iam having some problems installing an MSDE database. I have
> downloaded MSDE2000A from the microsoft website and iam running the
> setup from the command promt using the following command :
> sql2000.msi BLANKSAPWD=1
> the setup starts to run fine, then it gets to a point in the
> installation and the progress bar starts to go backwards and the
> setup exits without any errors being logged or any indication that
> the install failed, except that in the Add / Remove programs section
> of controll pannel there is nothing related to MSDE installed.
> how can i remedy this situation?
please add the
/L*v "c:\MsdeLog.txt"
parameter to the
c:\...\>setup.exe BLANKSAPWD=1
(btw, BLANKSAPWD=1 is not a very good choice at all)
command line call to the boostrap installer of MSDE... this will enable
verbose logging of the setup process, resulting in an about 2mb text file
(for a succesufll installation) you can inspect in case of problem..
scan the log file for
RETURN VALUE 3
entries... about 10 lines before each entry you will get some (sometime
cryptic) description of the problem..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
-- remove DMO to reply|||Ok i have added the extra command and have looked at the output.. the only
things i can see that may be causing the errors and that are close to Return
Value 3 are:
InstallSQLAgentSecurity failed (SERVER-NAME,LocalSystem,87).
-
MSI (s) (2C:D4) [09:24:31:823]: Executing op:
End(Checksum=0,ProgressTotalHDWord=0,Pro
gressTotalLDWord=0)
MSI (s) (2C:D4) [09:24:31:823]: Error in rollback skipped. Return: 5
MSI (s) (2C:D4) [09:24:31:838]: Closing Terminal Server registry propoga
tion
window. Discarding Changes.
MSI (s) (2C:D4) [09:24:31:885]: No System Restore sequence number for th
is
installation.
not sure if the last one means anything but the - InstallSQLAgentSecurity
failed (SERVER-NAME,LocalSystem,87). looks like something
any ideas?
"Andrea Montanari" wrote:

> hi Luca,
> Luca wrote:
> please add the
> /L*v "c:\MsdeLog.txt"
> parameter to the
> c:\...\>setup.exe BLANKSAPWD=1
> (btw, BLANKSAPWD=1 is not a very good choice at all)
> command line call to the boostrap installer of MSDE... this will enable
> verbose logging of the setup process, resulting in an about 2mb text file
> (for a succesufll installation) you can inspect in case of problem..
> scan the log file for
> RETURN VALUE 3
> entries... about 10 lines before each entry you will get some (sometime
> cryptic) description of the problem..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.bizhttp://italy.mvps.org
> DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
> -- remove DMO to reply
>
>|||hi Luca,
Luca wrote:
> MSI (s) (2C:D4) [09:24:31:838]: Closing Terminal Server registry
> propogation window. Discarding Changes.
> MSI (s) (2C:D4) [09:24:31:885]: No System Restore sequence number for
> this installation.
are you installing MSDE on a Terminal Server session? if this is the case,
this usually causes a lot of problems... try installing it not on TS
session..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
-- remove DMO to reply|||thanks for all your help. i have solved to problem
"Andrea Montanari" wrote:

> hi Luca,
> Luca wrote:
> are you installing MSDE on a Terminal Server session? if this is the case,
> this usually causes a lot of problems... try installing it not on TS
> session..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.bizhttp://italy.mvps.org
> DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
> -- remove DMO to reply
>
>

MSDE for High trafic website

Could I use MSDE for a web site that has 1 million hits per day; 300,000 of
it would be database requests? Or do I have to go with MSSQL?
Thanks Stephan
Stephan, MSDE is designed to work with about 25 concurrent users before the
slowdown from the workload governor becomes noticable. MSDE is intended for
use with small workgroups.
Anything over 8 concurrent operations will cause the workload governor to
kick in, which has the effect of slowing down each transaction by a few
milliseconds. If you don't have many concurrent users, it's not a big deal,
but if you have 300,000 DB requests per day that might be a problem.
Check out this article on MSDN for further info:
http://msdn.microsoft.com/library/de...r_sa2_0ciq.asp
"Stephan" <Stephan@.discussions.microsoft.com> wrote in message
news:EF45810E-94B8-468A-ABD3-FA5403A69398@.microsoft.com...
> Could I use MSDE for a web site that has 1 million hits per day; 300,000
> of
> it would be database requests? Or do I have to go with MSSQL?
> Thanks Stephan
|||Am Wed, 19 Oct 2005 10:48:07 -0700 schrieb Stephan:

> Could I use MSDE for a web site that has 1 million hits per day; 300,000 of
> it would be database requests? Or do I have to go with MSSQL?
> Thanks Stephan
I use MSDE in a project with 20 concurrent workstations, which are polling
every 10 seconds for updates of some records, not very much. But sometimes
it happens that the workload gouvernor comes like a hammer, then it needs
from 2 up to 20 seconds before the next queries where processed. And this
is the big problem with this gouvernor, it doesn't come slow, if he starts,
he slows down the MSDE immediately very much.
But you could check SQLExpress, the "new MSDE", which has not longer such
gouvernor or other slowdowns. The limits for the new MSDE are 1 CPU, 1 Gb
Memory, no agent and so on.
But that's only what i read about it, if have not tested it in reality.
bye,
Helmut
|||Thanks! I will stick withMSSQL then.
"Chris Burnette" wrote:

> Stephan, MSDE is designed to work with about 25 concurrent users before the
> slowdown from the workload governor becomes noticable. MSDE is intended for
> use with small workgroups.
> Anything over 8 concurrent operations will cause the workload governor to
> kick in, which has the effect of slowing down each transaction by a few
> milliseconds. If you don't have many concurrent users, it's not a big deal,
> but if you have 300,000 DB requests per day that might be a problem.
> Check out this article on MSDN for further info:
> http://msdn.microsoft.com/library/de...r_sa2_0ciq.asp
> "Stephan" <Stephan@.discussions.microsoft.com> wrote in message
> news:EF45810E-94B8-468A-ABD3-FA5403A69398@.microsoft.com...
>
>