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 2005 Express edition

I have Visual Web Developer 2005 Express edition and I wanted to install SQL Server 2005 Express edition.

From this page, I have downloaded and installed 'Microsoft SQL Server 2005 Express Edition'and'Microsoft SQL Server 2005 Express Edition with Advanced Services

http://msdn.microsoft.com/vstudio/express/sql/download/

After the installation, how should I access the SQL Server 2005 Express edition?

Because the only thing listed in 'Start > All Programs > SQL Server 2005' is 'Configuration Tools'

I was hoping that when I install SQL Server 2005 express edition, I would get all the menu that I get by installing SQL Server 2000.

So after installing SQL Server 2005 Express edition, what should I be expection? Thanks

SQL Server 2005 Express will work inside VS2005, you can go to database and create a new database now, give it a try!|||

albertpascual:

SQL Server 2005 Express will work inside VS2005, you can go to database and create a new database now, give it a try!

I only have Visual Web Developer express edition. DOes SQL Server 2005 express edition work with Visual Web Developer express edition?

|||I do not know, sorry!|||I do not know, sorry! If you have the database menu and you can connect to a database, will work.

Installing SQL Server 2005 Express edition

I'm trying to install the latest SQL Server Express downloaded from Microsoft. I've followed all instructions on the download page but get the message concerning Incompatible Components being found on my machine. To my knowledge I have never installed any previous components from any betas or other previous versions. Nor have I had a previous version of .Net Framework 2.0 on my machine. Just in case, I've checked Add/Remove Programs and run the removal tool as recommended on the Microsoft site. The tool reports that it can't find any components! If I knew what to look for I'd go through the Registry to manually uninstall any problem keys. The trouble is that I can't get through to Microsoft to find out what might be causing the trouble. It appears that I'm not alone. Can anyone help please.Search for a file with a name that ends with Core.log. It can be found under C:\Program Files\Microsoft SQL Server, if you installed SQL Server in C: drive.

Please find the latest version of the file. This file will list any incompatible component(s), that was found during installation.

I hope this helps.

-- JB|||Many thanks John. That was very helpful and I am grateful for your suggestion. On looking into the core.log file I've extracted the following piece of information:
"Product "{44568A1C-53F6-49A5-A163-CD9ADC0F76D5}" versioned 2.0.50727 is not compatible with current builds of SQL Server. Expected at least version: 2.0.50727.42 The Product Name is "Microsoft .NET Framework 2.0". Unfortunately, the most recent version that I can find from the Microsoft site is version 2.0.50727!!!!!!!!!!! Can anyone help me find the 2.0.50727.42 version?|||This is one area where things are confusing... I believe there were a few builds of the .NET Framework that were released that were versioned 2.0.50727.xx prior to the final release. The 2.0.50727.42 version is the FINAL RTM version of the 2.0 framework. If the very last number in the version is < 42, you do not have the final released version installed.

You can download the final release of the 2.0 framework from here:

http://www.microsoft.com/downloads/details.aspx?FamilyID=0856eacb-4362-4b0d-8edd-aab15c5e04f5&DisplayLang=en

jeff.|||Thanks Jeff. You're right this is VERY confusing. I believe that the link you've given me is the one that I downloaded and tried to install. Unfortunately without success. Since experimenting a bit I've actually found a download that works. Unfortunately, I've had to pull down the full SDK version. This is a BIG download with lots and lots of stuff. I have now got a working version of SQL Server 2005 Express but with a massive overhead of other peripheral material. Since installing it all (I wasn't given any choice as to what to install) my notebook has become very sluggish! You just can't win can you! It's all or nothing with this lot!!!!
Thanks to everyone for their help.