Installing SQL Server Web Data Administrator

On the SQL Server Web Data Administrator page (see last line in this note), it states that the following are requirements
Microsoft SQL Server 7 SP2 or later
Microsoft .NET SDK or Microsoft Visual Studio .NET
Microsoft Internet Explorer 5.5 or later
Microsoft Internet Information Services (IIS)
1. Can I use MSDE 2000 instead of SQL Server 7 SP2
2. Can I use the free copy of ".NET Framework SDK Version 1.1" from Microsoft or do I need a more costly, expanded version
http://www.microsoft.com/downloads/details.aspx?familyid=c039a798-c57a-419e-acbc-2a332cb7f959&displaylang=e
Thank you
AFGHi,
1. You can use SQL Web Data Administrator with MSDE 2000
2. You can use the .NET Framework SDK Ver 1.1
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.|||I installed the app but when I run it the default.aspx code appears in ie rather than the application. What did I do wrong
Ning|||Hi Ning,
I am not able find a reason for it to display the Code instead of the GUI.
Which Server are you using ? IIS or Cassini ?
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.|||I'm using IIS on a xp machine. Right now, I'm having trouble with my vs.net as well. I have installed and used vs.net on my win 2000 machine without any problems. I just inherited a xp machine and would like to do development on it. I installed vs.net and the IDE appears to be fine. I can start a simple asp.net project but all the server controls behave strangely. For example, asp:textbox behave like a label showing its text non-editable text while a html textbox works just fine. I wonder if the two problems are related. By the way I've seen another msg in the group about having the same problem with sql web admin
Ning|||Hi,
Try using Cassini Personal Web Server instead of IIS. It should work.
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.sql

Installing SQL Server Web Data Administrator

On the SQL Server Web Data Administrator page (see last line in this note), it states that the following are requirements:
Microsoft SQL Server 7 SP2 or later
Microsoft .NET SDK or Microsoft Visual Studio .NET
Microsoft Internet Explorer 5.5 or later
Microsoft Internet Information Services (IIS)
1. Can I use MSDE 2000 instead of SQL Server 7 SP2?
2. Can I use the free copy of ".NET Framework SDK Version 1.1" from Microsoft or do I need a more costly, expanded version?
http://www.microsoft.com/downloads/d...displaylang=en
Thank you,
AFG
Hi,
1. You can use SQL Web Data Administrator with MSDE 2000
2. You can use the .NET Framework SDK Ver 1.1
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
|||I installed the app but when I run it the default.aspx code appears in ie rather than the application. What did I do wrong?
Ning
|||Hi Ning,
I am not able find a reason for it to display the Code instead of the GUI.
Which Server are you using ? IIS or Cassini ?
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
|||I'm using IIS on a xp machine. Right now, I'm having trouble with my vs.net as well. I have installed and used vs.net on my win 2000 machine without any problems. I just inherited a xp machine and would like to do development on it. I installed vs.net and
the IDE appears to be fine. I can start a simple asp.net project but all the server controls behave strangely. For example, asp:textbox behave like a label showing its text non-editable text while a html textbox works just fine. I wonder if the two probl
ems are related. By the way I've seen another msg in the group about having the same problem with sql web admin.
Ning
|||Hi,
Try using Cassini Personal Web Server instead of IIS. It should work.
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi Ning
Did you ever get your Web Data Administrator working? I am having the very same problem and cannot find a solution anywhere. am running:
XP Pro with IIS 5.0, have installed the free .Net Framework 1.1 and need to connect to my MSDE database on our server across the internet.
Regards
Jazzer
"Ning" wrote:

> I'm using IIS on a xp machine. Right now, I'm having trouble with my vs.net as well. I have installed and used vs.net on my win 2000 machine without any problems. I just inherited a xp machine and would like to do development on it. I installed vs.net a
nd the IDE appears to be fine. I can start a simple asp.net project but all the server controls behave strangely. For example, asp:textbox behave like a label showing its text non-editable text while a html textbox works just fine. I wonder if the two pro
blems are related. By the way I've seen another msg in the group about having the same problem with sql web admin.
> Ning
|||Hi
I had the same problem and found out that it was an unregistered component (dont know why it wasn't registered ok, an installation issue on my XP Pro machine perhaps).
Anyway if you manually register (using regsvr32) sqldmo.dll (find in C:\Program Files\System32) that should solve the problem, it did mine.
Regards
Jazzer
"Ning" wrote:

> I installed the app but when I run it the default.aspx code appears in ie rather than the application. What did I do wrong?
> Ning

Installing SQL Server Web Data Administrator

On the SQL Server Web Data Administrator page (see last line in this note),
it states that the following are requirements:
Microsoft SQL Server 7 SP2 or later
Microsoft .NET SDK or Microsoft Visual Studio .NET
Microsoft Internet Explorer 5.5 or later
Microsoft Internet Information Services (IIS)
1. Can I use MSDE 2000 instead of SQL Server 7 SP2?
2. Can I use the free copy of ".NET Framework SDK Version 1.1" from Microsof
t or do I need a more costly, expanded version?
http://www.microsoft.com/downloads/...&displaylang=en
Thank you,
AFGHi,
1. You can use SQL Web Data Administrator with MSDE 2000
2. You can use the .NET Framework SDK Ver 1.1
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.|||I installed the app but when I run it the default.aspx code appears in ie ra
ther than the application. What did I do wrong?
Ning|||Hi Ning,
I am not able find a reason for it to display the Code instead of the GUI.
Which Server are you using ? IIS or Cassini ?
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.|||I'm using IIS on a xp machine. Right now, I'm having trouble with my vs.net
as well. I have installed and used vs.net on my win 2000 machine without any
problems. I just inherited a xp machine and would like to do development on
it. I installed vs.net and
the IDE appears to be fine. I can start a simple asp.net project but all the
server controls behave strangely. For example, asp:textbox behave like a la
bel showing its text non-editable text while a html textbox works just fine.
I wonder if the two probl
ems are related. By the way I've seen another msg in the group about having
the same problem with sql web admin.
Ning|||Hi,
Try using Cassini Personal Web Server instead of IIS. It should work.
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Ning
Did you ever get your Web Data Administrator working? I am having the very s
ame problem and cannot find a solution anywhere. am running:
XP Pro with IIS 5.0, have installed the free .Net Framework 1.1 and need to
connect to my MSDE database on our server across the internet.
Regards
Jazzer
"Ning" wrote:

> I'm using IIS on a xp machine. Right now, I'm having trouble with my vs.net as wel
l. I have installed and used vs.net on my win 2000 machine without any problems. I j
ust inherited a xp machine and would like to do development on it. I installed vs.ne
t a
nd the IDE appears to be fine. I can start a simple asp.net project but all
the server controls behave strangely. For example, asp:textbox behave like a
label showing its text non-editable text while a html textbox works just fi
ne. I wonder if the two pro
blems are related. By the way I've seen another msg in the group about having the same probl
em with sql web admin.
> Ning|||Hi
I had the same problem and found out that it was an unregistered component (
dont know why it wasn't registered ok, an installation issue on my XP Pro ma
chine perhaps).
Anyway if you manually register (using regsvr32) sqldmo.dll (find in C:\Prog
ram Files\System32) that should solve the problem, it did mine.
Regards
Jazzer
"Ning" wrote:

> I installed the app but when I run it the default.aspx code appears in ie
rather than the application. What did I do wrong?
> Ning

Installing SQL Server Express 2005 June CTP from command line

I am trying to install SQL Server Express 2005 June CTP from command line, but by having the BIN folder completely blank.
Can anyone please specify the command line options, which I can use while installing, which can install it silently ?
Plz. write the entire statement to be written at the command prompt.
Thanking in advance.

I believe

SQLExpre32.exe -q /norebootchk /qn reboot=ReallySuppress addlocal=all instancename=SQLEXPRESS

will do the trick.

Installing SQL Server Express

I am having a problem installing SQL Server Express 2005 from the command line in that it gets part way through and then stops - no message - just terminates. After much rooting around in log files and running a normal install I'm pretty sure that it is stopping because of a warning regarding "Minimum Hardware Requirements".

The laptop I'm trying to install it on is a Samsung X05, Centrino 1.4, 1gb RAM and 60gb free disk space. I've tried it on another laptop (Sony with a higher spec.) and get exactly the same problem.

As far as I can see the hardware spec is well above the recommended minumum so I'm at a loss as to what to try next to overcome the problem. If anyone has any suggestions then I'd be very grateful.

Moving to Setup forum.

Mike

|||

The warning messages are just that, warnings, and shouldn't lead to any failures. So my guess is that it might be something with the way your command line is structured. For starters, can you post your command line install (remove passwords if they are used of course)? Can you also search your install logs for the text string "value 3"? This typically follows a more informative error message if one exists.

Thanks,
Sam Lester (MSFT)

|||

Thanks for responding Sam.

If I run sqlexpr.exe without any command line arguments I get a warning but can continue. However if I use a command line it fails to install.

The command line i am using is as follows:

sqlexpr.exe /qb INSTANCENAME=myinstance DISABLENETWORKPROTOCOLS=0 SECURITYMODE=SQL SAPWD=mypassword

Unfortunately none of the log files contain "value 3". However:

1. Summary.txt contains the following message:

"The current system does not meet the recommended hardware requirements for this SQL Server release. For detailed hardware requirements, see the readme file or SQL Server Books Online.

Setup succeeded with the installation, inspect the log file completely for status on all the components. "

2. Core(Local).Log contains:

"Machine = MYMACHINE, Article = Processor, Result = 0 (0x0)
Machine = MYMACHINE, Article = PhysicalMemory, Result = 70010 (0x1117a)
Machine = MYMACHINE, Article = DiskFreeSpace, Result = 0 (0x0)"

and

"Article: Minimum Hardware Requirement, Result: Warning
Description: Minimum hardware requirements are not met, therefore, some components may not perform as expected. Action: Make sure minimum hardware requirements are met. Please refer to the readme for minimum requirements."

I'm assuming that it means that it doesn't think that the machine has sufficient memory but given the spec of it (see my previous message) then surely it should.

If you (or anyone else) has any further thoughts then I'd be really grateful because I'm stumped on this one. My only alternative is to let users loose on the full SQL install interface and there are too many for me to want to do that!!

Thanks

Brian

|||

Hi,

refer manually installtion steps

http://msdn.microsoft.com/vstudio/express/support/install/

Hemantgiri S. Goswami

|||

Hi Hemantgiri

Thanks for the link but I really don't want a few hundred "Administrative Assistants" in schools installing SQL Express manually. Using the command line to automate it will be fine except if they get the same warning i am getting because it then fails to install correctly rather than giving an option to continue.

Brian

|||

Hey Brian, I think the issue with the command line is that you haven't supplied anything for the ADDLOCAL parameter. By adding "ADDLOCAL=ALL" to the end of your command line, you should get what you're looking for. If you only want to install a subset of the product, you can take a look at the template.ini file for some examples or reply back with specific questions.

Thanks,
Sam Lester (MSFT)

|||

Spot-on Sam.

I notice that template.ini says: "If ADDLOCAL is not specified, setup will fail." I feel such a fool!!

Thanks very much for your help.

Brian

Installing SQL Server Express

I am having a problem installing SQL Server Express 2005 from the command line in that it gets part way through and then stops - no message - just terminates. After much rooting around in log files and running a normal install I'm pretty sure that it is stopping because of a warning regarding "Minimum Hardware Requirements".

The laptop I'm trying to install it on is a Samsung X05, Centrino 1.4, 1gb RAM and 60gb free disk space. I've tried it on another laptop (Sony with a higher spec.) and get exactly the same problem.

As far as I can see the hardware spec is well above the recommended minumum so I'm at a loss as to what to try next to overcome the problem. If anyone has any suggestions then I'd be very grateful.

Moving to Setup forum.

Mike

|||

The warning messages are just that, warnings, and shouldn't lead to any failures. So my guess is that it might be something with the way your command line is structured. For starters, can you post your command line install (remove passwords if they are used of course)? Can you also search your install logs for the text string "value 3"? This typically follows a more informative error message if one exists.

Thanks,
Sam Lester (MSFT)

|||

Thanks for responding Sam.

If I run sqlexpr.exe without any command line arguments I get a warning but can continue. However if I use a command line it fails to install.

The command line i am using is as follows:

sqlexpr.exe /qb INSTANCENAME=myinstance DISABLENETWORKPROTOCOLS=0 SECURITYMODE=SQL SAPWD=mypassword

Unfortunately none of the log files contain "value 3". However:

1. Summary.txt contains the following message:

"The current system does not meet the recommended hardware requirements for this SQL Server release. For detailed hardware requirements, see the readme file or SQL Server Books Online.

Setup succeeded with the installation, inspect the log file completely for status on all the components. "

2. Core(Local).Log contains:

"Machine = MYMACHINE, Article = Processor, Result = 0 (0x0)
Machine = MYMACHINE, Article = PhysicalMemory, Result = 70010 (0x1117a)
Machine = MYMACHINE, Article = DiskFreeSpace, Result = 0 (0x0)"

and

"Article: Minimum Hardware Requirement, Result: Warning
Description: Minimum hardware requirements are not met, therefore, some components may not perform as expected. Action: Make sure minimum hardware requirements are met. Please refer to the readme for minimum requirements."

I'm assuming that it means that it doesn't think that the machine has sufficient memory but given the spec of it (see my previous message) then surely it should.

If you (or anyone else) has any further thoughts then I'd be really grateful because I'm stumped on this one. My only alternative is to let users loose on the full SQL install interface and there are too many for me to want to do that!!

Thanks

Brian

|||

Hi,

refer manually installtion steps

http://msdn.microsoft.com/vstudio/express/support/install/

Hemantgiri S. Goswami

|||

Hi Hemantgiri

Thanks for the link but I really don't want a few hundred "Administrative Assistants" in schools installing SQL Express manually. Using the command line to automate it will be fine except if they get the same warning i am getting because it then fails to install correctly rather than giving an option to continue.

Brian

|||

Hey Brian, I think the issue with the command line is that you haven't supplied anything for the ADDLOCAL parameter. By adding "ADDLOCAL=ALL" to the end of your command line, you should get what you're looking for. If you only want to install a subset of the product, you can take a look at the template.ini file for some examples or reply back with specific questions.

Thanks,
Sam Lester (MSFT)

|||

Spot-on Sam.

I notice that template.ini says: "If ADDLOCAL is not specified, setup will fail." I feel such a fool!!

Thanks very much for your help.

Brian

Integrate Service Pack

Hi,
With Windows XP and its Service Pack 2, one is able to run the service pack
at the command line with an -integrate option, and it will update an RTM
Windows XP install file set to an SP2 Windows XP install file set.
Do the SQL Server service packs have the -integrate option?
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org
No.
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006

> With Windows XP and its Service Pack 2, one is able to run the service
> pack at the command line with an -integrate option, and it will update an
> RTM Windows XP install file set to an SP2 Windows XP install file set.
> Do the SQL Server service packs have the -integrate option?
|||You can vote for adding this feature here
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125400
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Daniel Jameson" <djameson@.childrensoncologygroup.org> wrote in message
news:OiqXHipYHHA.448@.TK2MSFTNGP04.phx.gbl...
> Hi,
> With Windows XP and its Service Pack 2, one is able to run the service
> pack at the command line with an -integrate option, and it will update an
> RTM Windows XP install file set to an SP2 Windows XP install file set.
> Do the SQL Server service packs have the -integrate option?
> --
> Thank you,
> Daniel Jameson
> SQL Server DBA
> Children's Oncology Group
> www.childrensoncologygroup.org
>

Integrate Service Pack

Hi,
With Windows XP and its Service Pack 2, one is able to run the service pack
at the command line with an -integrate option, and it will update an RTM
Windows XP install file set to an SP2 Windows XP install file set.
Do the SQL Server service packs have the -integrate option?
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.orgNo.
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006

> With Windows XP and its Service Pack 2, one is able to run the service
> pack at the command line with an -integrate option, and it will update an
> RTM Windows XP install file set to an SP2 Windows XP install file set.
> Do the SQL Server service packs have the -integrate option?|||You can vote for adding this feature here
https://connect.microsoft.com/SQLSe...=1254
00
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Daniel Jameson" <djameson@.childrensoncologygroup.org> wrote in message
news:OiqXHipYHHA.448@.TK2MSFTNGP04.phx.gbl...
> Hi,
> With Windows XP and its Service Pack 2, one is able to run the service
> pack at the command line with an -integrate option, and it will update an
> RTM Windows XP install file set to an SP2 Windows XP install file set.
> Do the SQL Server service packs have the -integrate option?
> --
> Thank you,
> Daniel Jameson
> SQL Server DBA
> Children's Oncology Group
> www.childrensoncologygroup.org
>

Integrate Service Pack

Hi,
With Windows XP and its Service Pack 2, one is able to run the service pack
at the command line with an -integrate option, and it will update an RTM
Windows XP install file set to an SP2 Windows XP install file set.
Do the SQL Server service packs have the -integrate option?
--
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.orgNo.
--
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
> With Windows XP and its Service Pack 2, one is able to run the service
> pack at the command line with an -integrate option, and it will update an
> RTM Windows XP install file set to an SP2 Windows XP install file set.
> Do the SQL Server service packs have the -integrate option?|||You can vote for adding this feature here
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125400
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Daniel Jameson" <djameson@.childrensoncologygroup.org> wrote in message
news:OiqXHipYHHA.448@.TK2MSFTNGP04.phx.gbl...
> Hi,
> With Windows XP and its Service Pack 2, one is able to run the service
> pack at the command line with an -integrate option, and it will update an
> RTM Windows XP install file set to an SP2 Windows XP install file set.
> Do the SQL Server service packs have the -integrate option?
> --
> Thank you,
> Daniel Jameson
> SQL Server DBA
> Children's Oncology Group
> www.childrensoncologygroup.org
>

installing SQL Express from command line AND SQL authentication

Hello,

I'm installing SQL express from command line, and using something like that:

/qb INSTANCENAME="SQLEXPRESS" ADDLOCAL="All" SECURITYMODE="SQL" AGTACCOUNT="konrad" AGTPASSWORD="*******" SQLBROWSERACCOUNT="konrad" SQLBROWSERPASSWORD="*******" SQLACCOUNT="konrad" SQLPASSWORD="*******" SAPWD="********"

but after installation process security mode is still set to windows authorization
I realy don't know what is wrong
Could it be that the SQL Server password is not complex enough and you enabled a security complexity policy ? I thought that the install procedure should cancel then, but it seems that the SECURITYMODE is ignored for some reason. Did you try to put the settings in a template file and see if it will be taken from that ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||hmmm it's weird... when I type simple password installation goes to end without errors, but when passwords are more complicated I get an error:

SQL Server Setup could not validate the service accounts. Either the service accounts have not been provided for all of the services being installed, or the specified username or password is incorrect. For each service, specify a valid username, password, and domain, or specify a built-in system account.

atm it works only with one pair of passwords which I specify in first installation on this system after reboot but sql auth. still doesn't work :/

could someone give me working command to execute this installer with SQL Authentication that may be very helpfull

regards,
Konrad B.
|||

Any special characters in there ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||nope only letters and numbers