Installing MSDE 2000a

I have downloaded MSDE 2000a and installed it from the run command on Windows
XP SP2 but can only connect with the login "Trusted NT connection" and not
with the sa login. Can someone please give me the correct command to type to
install with sql or mixed authentication.
http://support.microsoft.com/default...b;en-us;319930
look at the heading "Enable Mixed Mode Authentication After Installation"
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"cwsjnr" wrote:

> I have downloaded MSDE 2000a and installed it from the run command on Windows
> XP SP2 but can only connect with the login "Trusted NT connection" and not
> with the sa login. Can someone please give me the correct command to type to
> install with sql or mixed authentication.

Installing MSDE

I've downloaded sql2ksp3. After I have extracted the file, I found MSDE folder and I ran the setup.exe. Halfway through the installation, it says the instance name specified is invalid.

Does anyone know how to fix this? Thanks.Take a look atKB article 810826 and specify an INSTANCENAME parameters to the command.

Installing MSDE

Hello,
JOe here,
I am doing my best to install the MSDEsp3 that is included
in Office 2003 Pro I also downloaded the MSDE2000A from MS
site. When I try to install it it decides to stop
intalling and gives this error.
(A strong SA pasword is required for security reasons.
Please use SAPWD switch to supply the same. please refer
ro the readme for more details. Setup will now exit)
Well... I refered and i looked but didn't see a thing.
So ... I came here.
any help here please
Joe
hi Joe,
"Joe" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:749001c494d9$290e17a0$a501280a@.phx.gbl...
> Hello,
> JOe here,
> I am doing my best to install the MSDEsp3 that is included
> in Office 2003 Pro I also downloaded the MSDE2000A from MS
> site. When I try to install it it decides to stop
> intalling and gives this error.
> (A strong SA pasword is required for security reasons.
> Please use SAPWD switch to supply the same. please refer
> ro the readme for more details. Setup will now exit)
> Well... I refered and i looked but didn't see a thing.
> So ... I came here.
you have to provide this information as a parameter like
c:\...\>setup.exe (other params) SAPWD="your strong pwd" (other params) /L*v
"c:\msdelog.txt"
you can see all parameters synopsis at
http://msdn.microsoft.com/library/de...stsql_84xl.asp ,
where futher info are presented too
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
|||Andrea, Thanks for your reply,
But I haven't a clue what this is.
I am like in a dark room with my hands over my eyes with
this one.
Where do you start to install this? In a command prompt?
I have failed to tell you (I guess) that I am new to this
SQL.
I have never installed anything from a command prompt
before..
Ok, Let me ask this question please?
I bought about a year ago, the Office XP Developer edition
of Office. Inside this package was about 6 CD's and one of
them says SQL server 2000 is this the real thing or do I
need more? I installed this once and was in dire need of
information to get it to work but of course I didn't get
it. So.. I uninstalled it.
I really need some guidence here please.
Thanks very much for your time Pison
Joe
>--Original Message--
>hi Joe,
>"Joe" <anonymous@.discussions.microsoft.com> ha scritto
nel messaggio[vbcol=seagreen]
>news:749001c494d9$290e17a0$a501280a@.phx.gbl...
included[vbcol=seagreen]
MS
>you have to provide this information as a parameter like
>c:\...\>setup.exe (other params) SAPWD="your strong pwd"
(other params) /L*v
>"c:\msdelog.txt"
>you can see all parameters synopsis at
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/distsql/distsql_84xl.asp ,
>where futher info are presented too
>--
>Andrea Montanari (Microsoft MVP - SQL Server)
>http://www.asql.biz/DbaMgr.shtm
http://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
>.
>
|||hi Joe,
"Joe" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:782901c49503$694226c0$a501280a@.phx.gbl...
> Andrea, Thanks for your reply,
> But I haven't a clue what this is.
> I am like in a dark room with my hands over my eyes with
> this one.
> Where do you start to install this? In a command prompt?
> I have failed to tell you (I guess) that I am new to this
> SQL.
> I have never installed anything from a command prompt
> before..
> Ok, Let me ask this question please?
> I bought about a year ago, the Office XP Developer edition
> of Office. Inside this package was about 6 CD's and one of
> them says SQL server 2000 is this the real thing or do I
> need more? I installed this once and was in dire need of
> information to get it to work but of course I didn't get
> it. So.. I uninstalled it.
> I really need some guidence here please.
ok... =;-D
you have to install MSDE providing some parameters... this can be done
providing an INI file the setup bootstrapper will read, or just pass them as
command line parameters, and this is the way I do prefer and suggest...
and yes... you have to run the setup.exe from a command prompt...
so go this way...
locate your MSDE installer directory and provide all required params...
c:\...\>setup.exe
add the sa pwd as
SAPWD="your pwd"
we don't want to install a named instance of MSDE, as it will be the default
instance, so omit relative param...
we do not want to specify custom directories for binaries and data files,
and they will point to Program Files\..., so omit relative param...
we do wan to to allow network connections, so specify relative param as
DISABLENETWORKPROTOCOLS=0
se do want to allow SQL Server authenticated connections instead of trusted
WinNT connections only, so specify relative param as
SECURITYMODE=SQL
and finally, we do want the setup to log all install operation to a verbose
txt file
/L*v "c:\msdelog.txt"
the resulting command will be
c:\...\>setup.exe SAPWD="your pwd" DISABLENETWORKPROTOCOLS=0
SECURITYMODE=SQL /L*v "c:\msdelog.txt"
and pelase do use the package you downloaded from the web, MSDE Web Release
A, as it is updated at the last service pack level
for your convenience, you can download SQL Server Books On Line, the online
documentation, from
http://www.microsoft.com/sql/techinf...000/books.asp, where you
can find lot of information about the product
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
|||Hello Andrea,
Ok,someone told me that SQL was easier than Access. I
don't think so...
locate your MSDE installer directory and provide all
required params...
c:\...\>setup.exe
add the sa pwd as >>>>>> where does this go?
SAPWD="your pwd"
In here? >>>c:\...\>setup.exe
I have no Idea?
Ok here is the path to the MSDE on C:\
C:\MSDERela\setup.exe
Now how does this work with this >>> SAPWD="your pwd"
1. Open CMD ?
2. Type What?
3. Sorry I am still lost?
4. I failed to read the rest of your post because I got
lost here.
5. Why is this so damn difficult.
Signed Frustrated Joe

>--Original Message--
>hi Joe,
>"Joe" <anonymous@.discussions.microsoft.com> ha scritto
nel messaggio[vbcol=seagreen]
>news:782901c49503$694226c0$a501280a@.phx.gbl...
this[vbcol=seagreen]
edition[vbcol=seagreen]
of
>ok... =;-D
>you have to install MSDE providing some parameters...
this can be done
>providing an INI file the setup bootstrapper will read,
or just pass them as
>command line parameters, and this is the way I do prefer
and suggest...
>and yes... you have to run the setup.exe from a command
prompt...
>so go this way...
>locate your MSDE installer directory and provide all
required params...
>c:\...\>setup.exe
>add the sa pwd as
> SAPWD="your pwd"
>we don't want to install a named instance of MSDE, as it
will be the default
>instance, so omit relative param...
>we do not want to specify custom directories for binaries
and data files,
>and they will point to Program Files\..., so omit
relative param...
>we do wan to to allow network connections, so specify
relative param as
> DISABLENETWORKPROTOCOLS=0
>se do want to allow SQL Server authenticated connections
instead of trusted
>WinNT connections only, so specify relative param as
>SECURITYMODE=SQL
>and finally, we do want the setup to log all install
operation to a verbose
>txt file
> /L*v "c:\msdelog.txt"
>the resulting command will be
>c:\...\>setup.exe SAPWD="your pwd"
DISABLENETWORKPROTOCOLS=0
>SECURITYMODE=SQL /L*v "c:\msdelog.txt"
>and pelase do use the package you downloaded from the
web, MSDE Web Release
>A, as it is updated at the last service pack level
>for your convenience, you can download SQL Server Books
On Line, the online
>documentation, from
>http://www.microsoft.com/sql/techinf...tdoc/2000/book
s.asp, where you
>can find lot of information about the product
>--
>Andrea Montanari (Microsoft MVP - SQL Server)
>http://www.asql.biz/DbaMgr.shtm
http://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
>.
>
|||hi Joe,
don't worry =;-D
"Joe" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:033a01c49520$cea94b70$a401280a@.phx.gbl...
> Hello Andrea,
> Ok,someone told me that SQL was easier than Access. I
> don't think so...
don't think so too =;-D

> locate your MSDE installer directory and provide all
> required params...
> c:\...\>setup.exe
> add the sa pwd as >>>>>> where does this go?
> SAPWD="your pwd"
> In here? >>>c:\...\>setup.exe
> I have no Idea?
> Ok here is the path to the MSDE on C:\
> C:\MSDERela\setup.exe
> Now how does this work with this >>> SAPWD="your pwd"
>
yep.
open a command window.. navigate to tha folder, and type the full command
like
C:\MSDERela\>setup.exe SAPWD="your pwd" DISABLENETWORKPROTOCOLS=0
SECURITYMODE=SQL /L*v "C:\msdelog.txt"
on the same line =;-D
this will install a default instance of MSDE, with enabled network
protocols, allowing SQL Server authenticated connections too, with the "sa"
SQL Server special account password of "your pwd"
the installation will be logged in the C:\msdelog.txt file...
again, you can see the full explanation of each parameter at
http://msdn.microsoft.com/library/de...stsql_84xl.asp
regards
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
|||Hello Andrea
Ok This is much better ;) I will give this a try
I will let you know
JOe
>--Original Message--
>hi Joe,
>don't worry =;-D
>"Joe" <anonymous@.discussions.microsoft.com> ha scritto
nel messaggio
>news:033a01c49520$cea94b70$a401280a@.phx.gbl...
>don't think so too =;-D
>
>yep.
>open a command window.. navigate to tha folder, and type
the full command
>like
>C:\MSDERela\>setup.exe SAPWD="your pwd"
DISABLENETWORKPROTOCOLS=0
>SECURITYMODE=SQL /L*v "C:\msdelog.txt"
>on the same line =;-D
>this will install a default instance of MSDE, with
enabled network
>protocols, allowing SQL Server authenticated connections
too, with the "sa"
>SQL Server special account password of "your pwd"
>the installation will be logged in the C:\msdelog.txt
file...
>again, you can see the full explanation of each parameter
at
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/distsql/distsql_84xl.asp
>regards
>--
>Andrea Montanari (Microsoft MVP - SQL Server)
>http://www.asql.biz/DbaMgr.shtm
http://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
>.
>
|||I am getting the response MSDERela is not a recognized
internal command?
And the spinning wheel goes round and round ;)
Thanks
Joe

>--Original Message--
>hi Joe,
>don't worry =;-D
>"Joe" <anonymous@.discussions.microsoft.com> ha scritto
nel messaggio
>news:033a01c49520$cea94b70$a401280a@.phx.gbl...
>don't think so too =;-D
>
>yep.
>open a command window.. navigate to tha folder, and type
the full command
>like
>C:\MSDERela\>setup.exe SAPWD="your pwd"
DISABLENETWORKPROTOCOLS=0
>SECURITYMODE=SQL /L*v "C:\msdelog.txt"
>on the same line =;-D
>this will install a default instance of MSDE, with
enabled network
>protocols, allowing SQL Server authenticated connections
too, with the "sa"
>SQL Server special account password of "your pwd"
>the installation will be logged in the C:\msdelog.txt
file...
>again, you can see the full explanation of each parameter
at
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/distsql/distsql_84xl.asp
>regards
>--
>Andrea Montanari (Microsoft MVP - SQL Server)
>http://www.asql.biz/DbaMgr.shtm
http://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
>.
>
|||=;-D
"Joe" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:7a4d01c4952d$ffaa8a10$a601280a@.phx.gbl...
> I am getting the response MSDERela is not a recognized
> internal command?
at your DOS command prompt type
CD\
it must appear
C:\>
change again directory to the folder containing the setup.exe file, you said
the dir is named MSDERela, so
CD MSDERela
now it must appear
C:\MSDERela>
now type the setup command string:
setup.exe SAPWD="your pwd" DISABLENETWORKPROTOCOLS=0 SECURITYMODE=SQL /L*v
"c:\msdelog.txt"
hey... this is standard console interaction =;-D
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
|||hey... this is standard console interaction =;-D
I am not exactly sure how to take that?
Could you please type out the string for DOS prompt again.
I just do not get your meaning CD.It is not on a CD
Yes on my c drive the folder MSDERela is there and the
setup.exe is inside that folder
I am a newbie yes but just here.
If you go here
www.animocracy.com
You can see the extensive work I have done with CDO and
other MVP's there pison
Also www.Slovaun.com
amd www.Immoralbalance.com
There are many more and I do contribute to the MVP sites
But as I have mentioned I do not use the CMD that often.
These sites didn't get there by accident. Ok so I am not
afraid of stepping into deep water ;-)
You are speaking way above my head in some areas you
cannot assume I understand your terminology.
So... I do feel a little embarrassed that I cannot even
install this much less use it ;(
Thanks Andrea
Joe
>--Original Message--
>=;-D
>"Joe" <anonymous@.discussions.microsoft.com> ha scritto
nel messaggio
>news:7a4d01c4952d$ffaa8a10$a601280a@.phx.gbl...
>at your DOS command prompt type
>CD\
>it must appear
>C:\>
>change again directory to the folder containing the
setup.exe file, you said
>the dir is named MSDERela, so
>CD MSDERela
>now it must appear
>C:\MSDERela>
>now type the setup command string:
>setup.exe SAPWD="your pwd" DISABLENETWORKPROTOCOLS=0
SECURITYMODE=SQL /L*v
>"c:\msdelog.txt"
>hey... this is standard console interaction =;-D
>--
>Andrea Montanari (Microsoft MVP - SQL Server)
>http://www.asql.biz/DbaMgr.shtm
http://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
>.
>

Installing MSDE

After a number of tries I have not been able to successfully install the MSDE 2000 Desktop engine.. I downloaded the file, followed all instructions in the ReadMe and now have a folder "Microsoft SQLServer" in the Program Files. This folder contains 2 s
ub folders "80" and "MSSQL$VSdotNet". These have sub folders which I have serched but cannort locate an executable file that gives me any kind of interface to design or use a database.
In the past, all my database have been in MS Access2000. Am I expecting too much of san Access type of look?
I am at a complete loss as to where to go from here in using the MSDE and getting the sample databases to load. If anyone can point me to a place to look fo a tutorial or simple set of instructions, I would appreciate it, much.
I am using Windows XP Pro.
Milt
hi Milt,
"sirmilt" <sirmilt@.discussions.microsoft.com> ha scritto nel messaggio
news:534F95C8-7C68-45F3-A2CE-6C4995F2B57D@.microsoft.com...
>....
please post your command line...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hello sirmlt,
welcome to the MSDE group. MSDE does not come with a graphical UI tool. To administer it you can download the free tools online for e.g. MSDEManager or dbamanager by Andrea from http://www.asql.biz/DbaMgr.shtm.
This will give you a tool to administer the sql server, for e.g. to create logins, users etc. Then to create your database you can use t-sql statements in .net to create the db dynamically but if you want to create it using UI then the server explorer in
vs.net will let you connect to the server (which will be your machine if you install MSDE there) nad create database. Or you can install SQL Server developer edition (cheaper cost wise and for development purposes). This will provide you with both the
tool to administer the databases (It is called Enterprise Manager) and you can create/modify the db there itself.
Let us know if you have any more questions.
goodluck
dev
"sirmilt" wrote:

> After a number of tries I have not been able to successfully install the MSDE 2000 Desktop engine.. I downloaded the file, followed all instructions in the ReadMe and now have a folder "Microsoft SQLServer" in the Program Files. This folder contains 2
sub folders "80" and "MSSQL$VSdotNet". These have sub folders which I have serched but cannort locate an executable file that gives me any kind of interface to design or use a database.
> In the past, all my database have been in MS Access2000. Am I expecting too much of san Access type of look?
> I am at a complete loss as to where to go from here in using the MSDE and getting the sample databases to load. If anyone can point me to a place to look fo a tutorial or simple set of instructions, I would appreciate it, much.
> I am using Windows XP Pro.
> --
> Milt
|||Thank you for the response. Your answer clears up my misunderstanding of the interface with the MSDE. I looked at the web site you suggested and it is all in Italian, I hope there is an english version, I will be trying it out over the next couple of day
s.
Milt
"dev_kh" wrote:

> Hello sirmlt,
> welcome to the MSDE group. MSDE does not come with a graphical UI tool. To administer it you can download the free tools online for e.g. MSDEManager or dbamanager by Andrea from http://www.asql.biz/DbaMgr.shtm.
> This will give you a tool to administer the sql server, for e.g. to create logins, users etc. Then to create your database you can use t-sql statements in .net to create the db dynamically but if you want to create it using UI then the server explorer
in vs.net will let you connect to the server (which will be your machine if you install MSDE there) nad create database. Or you can install SQL Server developer edition (cheaper cost wise and for development purposes). This will provide you with both th
e tool to administer the databases (It is called Enterprise Manager) and you can create/modify the db there itself.[vbcol=seagreen]
> Let us know if you have any more questions.
> goodluck
> dev
> "sirmilt" wrote:
2 sub folders "80" and "MSSQL$VSdotNet". These have sub folders which I have serched but cannort locate an executable file that gives me any kind of interface to design or use a database.[vbcol=seagreen]
|||dev_kh
Thank you for replying. I took a brief look at the site you suggested and it's in Italian. I will download and hope for an english version.
Thanks Again
Milt
"dev_kh" wrote:

> Hello sirmlt,
> welcome to the MSDE group. MSDE does not come with a graphical UI tool. To administer it you can download the free tools online for e.g. MSDEManager or dbamanager by Andrea from http://www.asql.biz/DbaMgr.shtm.
> This will give you a tool to administer the sql server, for e.g. to create logins, users etc. Then to create your database you can use t-sql statements in .net to create the db dynamically but if you want to create it using UI then the server explorer
in vs.net will let you connect to the server (which will be your machine if you install MSDE there) nad create database. Or you can install SQL Server developer edition (cheaper cost wise and for development purposes). This will provide you with both th
e tool to administer the databases (It is called Enterprise Manager) and you can create/modify the db there itself.[vbcol=seagreen]
> Let us know if you have any more questions.
> goodluck
> dev
> "sirmilt" wrote:
2 sub folders "80" and "MSSQL$VSdotNet". These have sub folders which I have serched but cannort locate an executable file that gives me any kind of interface to design or use a database.[vbcol=seagreen]
|||> Thank you for replying. I took a brief look at the site you suggested and
it's in Italian.
>I will download and hope for an english version.
hey... I'm italian, thought =;-D
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||dev_kh
Thanks for the response. I download what appears to be the right file and will try it out, I appreciate your trying to help out this novice.
Milt
"dev_kh" wrote:

> Hello sirmlt,
> welcome to the MSDE group. MSDE does not come with a graphical UI tool. To administer it you can download the free tools online for e.g. MSDEManager or dbamanager by Andrea from http://www.asql.biz/DbaMgr.shtm.
> This will give you a tool to administer the sql server, for e.g. to create logins, users etc. Then to create your database you can use t-sql statements in .net to create the db dynamically but if you want to create it using UI then the server explorer
in vs.net will let you connect to the server (which will be your machine if you install MSDE there) nad create database. Or you can install SQL Server developer edition (cheaper cost wise and for development purposes). This will provide you with both th
e tool to administer the databases (It is called Enterprise Manager) and you can create/modify the db there itself.[vbcol=seagreen]
> Let us know if you have any more questions.
> goodluck
> dev
> "sirmilt" wrote:
2 sub folders "80" and "MSSQL$VSdotNet". These have sub folders which I have serched but cannort locate an executable file that gives me any kind of interface to design or use a database.[vbcol=seagreen]
|||Andrea
I did download and install the program suceessfully. I'm a comparative novice at programming, however, and have to struggle with some of the settings as I'm not sure exactly what is needed.
I do appreciate your taking the time to try and help me.
Milt
"Andrea Montanari" wrote:

> it's in Italian.
> hey... I'm italian, thought =;-D
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||Andrea
I did download and install the program suceessfully. I'm a comparative novice at programming, however, and have to struggle with some of the settings as I'm not sure exactly what is needed.
I do appreciate your taking the time to try and help me.
Milt
"Andrea Montanari" wrote:

> it's in Italian.
> hey... I'm italian, thought =;-D
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||Mime-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Trace: news.uni-berlin.de WRwDGb8hXM5vooZ9AkxMRAxL6OyRmZqCnfNc+olhAQgA9jRmO8
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
Path: TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!fu-berlin.de!uni-berlin.de!not-for-mail
Xref: TK2MSFTNGP08.phx.gbl microsoft.public.sqlserver.msde:16464
hi Milt,
"sirmilt" <sirmilt@.discussions.microsoft.com> ha scritto nel messaggio
news:37427C61-4E89-4529-8969-DA73200715C7@.microsoft.com...
> Andrea
> I did download and install the program suceessfully. I'm a comparative
novice at programming, however, and have to struggle with some of the
settings as I'm not sure exactly what is needed.
> I do appreciate your taking the time to try and help me.
thank you for your interest in this prj of mine... for DbaMgr related
questions, please write me privately about it, in order not to go OT on
microsoft public NG
thank you
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Installing Data Mining Web Controls

Hello,

I have SQL 2005 and Visual Studio 2005 and I′m trying to install the Data Mining Web Controls. I downloaded the SQL Samples and I′m following the instructions of the "ReadMe_Data_Mining_Web_Controls.htm" file, but when I try to install de data mining web controls the setup.exe does′nt create the folder "C:\Program Files\Microsoft.AnalysisServices.DataMiningHtmlViewers " and the folder "C:\Inetpub\wwwroot\aspnet_client\microsoft_analysisservices_datamininghtmlviewers ".

Then, I don′t have the file "C:\Program Files\Microsoft.AnalysisServices.DataMiningHtmlViewers\Microsoft.AnalysisServices.DataMiningHTMLViewers.dll " for using the web controls.

Can somebody help me?

Dunia

The package coming with SQL Samples will install the sample source code in a Samples subfolder somewhere under %ProgramFiles%\Microsoft SQL Server\90. I am almost sure that the location is %ProgramFiles%\Microsoft SQL Server\90\Tools\Samples, but I may be wrong. A search for a folder called Samples under %ProgramFiles%\Microsoft SQL Server\90 will find the right location.

At that location, you will find the Data Mining web viewer sample, which is a Visual Studio 2005 solution. You have to open the solution in Visual Studio and build it. It contains:

- the web viewers sample (one assembly)

- a setup package that deploys the assembly together with the documentation in the location you mentioned (under %ProgramFiles%)

After building the solution, you should run the generated setup package, install the sample and then use it according to the documentation

Hope this helps

|||

Hi,

first of all I′d like to thank you for the answer.

I tryed to build the solution that you mentioned but I had the following error:

"Could not find file 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls\obj\Debug\Microsoft.AnalysisServices.DataMiningHtmlViewers.dll'"

Maybe the installer of the samples didn′t install this dll. I think that this is the problem. Do you know if I can download this dll from a site?

Thanks,

Dunia

|||

I never saw this before, but I can think of two possible reasons:

- In Visual Studio, you opened the setup project and not the whole solution which contains both the viewers project and the setup

or

- the solution was opened, you are trying to build the Release version and it incorrectly points to the debug version of the dll.

I would suggest:

- make sure that the full solution is opened, not only the setup project. Based on the error, I think it should be a file with the ".sln" extension in the "C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls" folder

- if that is not the problem, try to open in Visual Studio the .csproj project in 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls'. If this works, then you should retry to build the first project (the setup)

If none of these works, please let us know and I will post a zip containing the full solution for the sample

|||

Hello,

I have already tryed to build the .sln and .csproj, but I have the same error message, that there is no 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls\obj\Debug\Microsoft.AnalysisServices.DataMiningHtmlViewers.dll'.

I′d really appreciate if you could post me this file.....

Thanks,

Dunia

|||

My e-mail is dunia@.execplan.com.br

|||

Hello

Sorry for the late answer. I have sent you the sample code. Please let us know if you run into any more issues

bogdan

|||

I have the same problem with installing data mining web controls.

Can you please send me the zip that contains the solution ?

Thanks a lot

My email is georges_0@.hotmail.com

|||Hi Guys,
Can i have a copy of the file, Microsoft.AnalysisServices.DataMiningHtmlViewers.dll too. My email is bala.singam@.hotmail.com .

I also downloaded " DataMiningViewerClient " what's the different with the Data Mining Web Controls?|||I am having the same issue. I have made certain that all prerequisites have been installed and configured properly. How do I get a copy of this that has the missing dll?

Installing Data Mining Web Controls

Hello,

I have SQL 2005 and Visual Studio 2005 and I′m trying to install the Data Mining Web Controls. I downloaded the SQL Samples and I′m following the instructions of the "ReadMe_Data_Mining_Web_Controls.htm" file, but when I try to install de data mining web controls the setup.exe does′nt create the folder "C:\Program Files\Microsoft.AnalysisServices.DataMiningHtmlViewers " and the folder "C:\Inetpub\wwwroot\aspnet_client\microsoft_analysisservices_datamininghtmlviewers ".

Then, I don′t have the file "C:\Program Files\Microsoft.AnalysisServices.DataMiningHtmlViewers\Microsoft.AnalysisServices.DataMiningHTMLViewers.dll " for using the web controls.

Can somebody help me?

Dunia

The package coming with SQL Samples will install the sample source code in a Samples subfolder somewhere under %ProgramFiles%\Microsoft SQL Server\90. I am almost sure that the location is %ProgramFiles%\Microsoft SQL Server\90\Tools\Samples, but I may be wrong. A search for a folder called Samples under %ProgramFiles%\Microsoft SQL Server\90 will find the right location.

At that location, you will find the Data Mining web viewer sample, which is a Visual Studio 2005 solution. You have to open the solution in Visual Studio and build it. It contains:

- the web viewers sample (one assembly)

- a setup package that deploys the assembly together with the documentation in the location you mentioned (under %ProgramFiles%)

After building the solution, you should run the generated setup package, install the sample and then use it according to the documentation

Hope this helps

|||

Hi,

first of all I′d like to thank you for the answer.

I tryed to build the solution that you mentioned but I had the following error:

"Could not find file 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls\obj\Debug\Microsoft.AnalysisServices.DataMiningHtmlViewers.dll'"

Maybe the installer of the samples didn′t install this dll. I think that this is the problem. Do you know if I can download this dll from a site?

Thanks,

Dunia

|||

I never saw this before, but I can think of two possible reasons:

- In Visual Studio, you opened the setup project and not the whole solution which contains both the viewers project and the setup

or

- the solution was opened, you are trying to build the Release version and it incorrectly points to the debug version of the dll.

I would suggest:

- make sure that the full solution is opened, not only the setup project. Based on the error, I think it should be a file with the ".sln" extension in the "C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls" folder

- if that is not the problem, try to open in Visual Studio the .csproj project in 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls'. If this works, then you should retry to build the first project (the setup)

If none of these works, please let us know and I will post a zip containing the full solution for the sample

|||

Hello,

I have already tryed to build the .sln and .csproj, but I have the same error message, that there is no 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls\obj\Debug\Microsoft.AnalysisServices.DataMiningHtmlViewers.dll'.

I′d really appreciate if you could post me this file.....

Thanks,

Dunia

|||

My e-mail is dunia@.execplan.com.br

|||

Hello

Sorry for the late answer. I have sent you the sample code. Please let us know if you run into any more issues

bogdan

|||

I have the same problem with installing data mining web controls.

Can you please send me the zip that contains the solution ?

Thanks a lot

My email is georges_0@.hotmail.com

|||Hi Guys,
Can i have a copy of the file, Microsoft.AnalysisServices.DataMiningHtmlViewers.dll too. My email is bala.singam@.hotmail.com .

I also downloaded " DataMiningViewerClient " what's the different with the Data Mining Web Controls?|||I am having the same issue. I have made certain that all prerequisites have been installed and configured properly. How do I get a copy of this that has the missing dll?|||

Hi

Would you kindly guide me with installing the Data Mining Web Controls. In my SQL Server 2005 installation I cannot find a way to install samples. I tried to download all the relevant SQL Server 2005 samples from Codeplex but still the c:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls folder is not created.

|||

Rbonnici,

Just a couple thoughts:

Have you tried installing the samples from your SQL Server 2005 install discs? You may have better luck. Have you tried performing searching on your box for the file? Maybe it didnt install in that location. Also, Have you verified that the installs you downloaded from CodePlex actually installed by looking in Add/Remove programs?

I have never had or heard of the samples not installing.

-Cam

Installing Data Mining Web Controls

Hello,

I have SQL 2005 and Visual Studio 2005 and I′m trying to install the Data Mining Web Controls. I downloaded the SQL Samples and I′m following the instructions of the "ReadMe_Data_Mining_Web_Controls.htm" file, but when I try to install de data mining web controls the setup.exe does′nt create the folder "C:\Program Files\Microsoft.AnalysisServices.DataMiningHtmlViewers " and the folder "C:\Inetpub\wwwroot\aspnet_client\microsoft_analysisservices_datamininghtmlviewers ".

Then, I don′t have the file "C:\Program Files\Microsoft.AnalysisServices.DataMiningHtmlViewers\Microsoft.AnalysisServices.DataMiningHTMLViewers.dll " for using the web controls.

Can somebody help me?

Dunia

The package coming with SQL Samples will install the sample source code in a Samples subfolder somewhere under %ProgramFiles%\Microsoft SQL Server\90. I am almost sure that the location is %ProgramFiles%\Microsoft SQL Server\90\Tools\Samples, but I may be wrong. A search for a folder called Samples under %ProgramFiles%\Microsoft SQL Server\90 will find the right location.

At that location, you will find the Data Mining web viewer sample, which is a Visual Studio 2005 solution. You have to open the solution in Visual Studio and build it. It contains:

- the web viewers sample (one assembly)

- a setup package that deploys the assembly together with the documentation in the location you mentioned (under %ProgramFiles%)

After building the solution, you should run the generated setup package, install the sample and then use it according to the documentation

Hope this helps

|||

Hi,

first of all I′d like to thank you for the answer.

I tryed to build the solution that you mentioned but I had the following error:

"Could not find file 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls\obj\Debug\Microsoft.AnalysisServices.DataMiningHtmlViewers.dll'"

Maybe the installer of the samples didn′t install this dll. I think that this is the problem. Do you know if I can download this dll from a site?

Thanks,

Dunia

|||

I never saw this before, but I can think of two possible reasons:

- In Visual Studio, you opened the setup project and not the whole solution which contains both the viewers project and the setup

or

- the solution was opened, you are trying to build the Release version and it incorrectly points to the debug version of the dll.

I would suggest:

- make sure that the full solution is opened, not only the setup project. Based on the error, I think it should be a file with the ".sln" extension in the "C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls" folder

- if that is not the problem, try to open in Visual Studio the .csproj project in 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls'. If this works, then you should retry to build the first project (the setup)

If none of these works, please let us know and I will post a zip containing the full solution for the sample

|||

Hello,

I have already tryed to build the .sln and .csproj, but I have the same error message, that there is no 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls\obj\Debug\Microsoft.AnalysisServices.DataMiningHtmlViewers.dll'.

I′d really appreciate if you could post me this file.....

Thanks,

Dunia

|||

My e-mail is dunia@.execplan.com.br

|||

Hello

Sorry for the late answer. I have sent you the sample code. Please let us know if you run into any more issues

bogdan

|||

I have the same problem with installing data mining web controls.

Can you please send me the zip that contains the solution ?

Thanks a lot

My email is georges_0@.hotmail.com

|||Hi Guys,
Can i have a copy of the file, Microsoft.AnalysisServices.DataMiningHtmlViewers.dll too. My email is bala.singam@.hotmail.com .

I also downloaded " DataMiningViewerClient " what's the different with the Data Mining Web Controls?|||I am having the same issue. I have made certain that all prerequisites have been installed and configured properly. How do I get a copy of this that has the missing dll?|||

Hi

Would you kindly guide me with installing the Data Mining Web Controls. In my SQL Server 2005 installation I cannot find a way to install samples. I tried to download all the relevant SQL Server 2005 samples from Codeplex but still the c:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls folder is not created.

|||

Rbonnici,

Just a couple thoughts:

Have you tried installing the samples from your SQL Server 2005 install discs? You may have better luck. Have you tried performing searching on your box for the file? Maybe it didnt install in that location. Also, Have you verified that the installs you downloaded from CodePlex actually installed by looking in Add/Remove programs?

I have never had or heard of the samples not installing.

-Cam

Installing Data Mining Web Controls

Hello,

I have SQL 2005 and Visual Studio 2005 and I′m trying to install the Data Mining Web Controls. I downloaded the SQL Samples and I′m following the instructions of the "ReadMe_Data_Mining_Web_Controls.htm" file, but when I try to install de data mining web controls the setup.exe does′nt create the folder "C:\Program Files\Microsoft.AnalysisServices.DataMiningHtmlViewers " and the folder "C:\Inetpub\wwwroot\aspnet_client\microsoft_analysisservices_datamininghtmlviewers ".

Then, I don′t have the file "C:\Program Files\Microsoft.AnalysisServices.DataMiningHtmlViewers\Microsoft.AnalysisServices.DataMiningHTMLViewers.dll " for using the web controls.

Can somebody help me?

Dunia

The package coming with SQL Samples will install the sample source code in a Samples subfolder somewhere under %ProgramFiles%\Microsoft SQL Server\90. I am almost sure that the location is %ProgramFiles%\Microsoft SQL Server\90\Tools\Samples, but I may be wrong. A search for a folder called Samples under %ProgramFiles%\Microsoft SQL Server\90 will find the right location.

At that location, you will find the Data Mining web viewer sample, which is a Visual Studio 2005 solution. You have to open the solution in Visual Studio and build it. It contains:

- the web viewers sample (one assembly)

- a setup package that deploys the assembly together with the documentation in the location you mentioned (under %ProgramFiles%)

After building the solution, you should run the generated setup package, install the sample and then use it according to the documentation

Hope this helps

|||

Hi,

first of all I′d like to thank you for the answer.

I tryed to build the solution that you mentioned but I had the following error:

"Could not find file 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls\obj\Debug\Microsoft.AnalysisServices.DataMiningHtmlViewers.dll'"

Maybe the installer of the samples didn′t install this dll. I think that this is the problem. Do you know if I can download this dll from a site?

Thanks,

Dunia

|||

I never saw this before, but I can think of two possible reasons:

- In Visual Studio, you opened the setup project and not the whole solution which contains both the viewers project and the setup

or

- the solution was opened, you are trying to build the Release version and it incorrectly points to the debug version of the dll.

I would suggest:

- make sure that the full solution is opened, not only the setup project. Based on the error, I think it should be a file with the ".sln" extension in the "C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls" folder

- if that is not the problem, try to open in Visual Studio the .csproj project in 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls'. If this works, then you should retry to build the first project (the setup)

If none of these works, please let us know and I will post a zip containing the full solution for the sample

|||

Hello,

I have already tryed to build the .sln and .csproj, but I have the same error message, that there is no 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls\obj\Debug\Microsoft.AnalysisServices.DataMiningHtmlViewers.dll'.

I′d really appreciate if you could post me this file.....

Thanks,

Dunia

|||

My e-mail is dunia@.execplan.com.br

|||

Hello

Sorry for the late answer. I have sent you the sample code. Please let us know if you run into any more issues

bogdan

|||

I have the same problem with installing data mining web controls.

Can you please send me the zip that contains the solution ?

Thanks a lot

My email is georges_0@.hotmail.com

|||Hi Guys,
Can i have a copy of the file, Microsoft.AnalysisServices.DataMiningHtmlViewers.dll too. My email is bala.singam@.hotmail.com .

I also downloaded " DataMiningViewerClient " what's the different with the Data Mining Web Controls?|||I am having the same issue. I have made certain that all prerequisites have been installed and configured properly. How do I get a copy of this that has the missing dll?sql

Installing Data Mining Web Controls

Hello,

I have SQL 2005 and Visual Studio 2005 and I′m trying to install the Data Mining Web Controls. I downloaded the SQL Samples and I′m following the instructions of the "ReadMe_Data_Mining_Web_Controls.htm" file, but when I try to install de data mining web controls the setup.exe does′nt create the folder "C:\Program Files\Microsoft.AnalysisServices.DataMiningHtmlViewers " and the folder "C:\Inetpub\wwwroot\aspnet_client\microsoft_analysisservices_datamininghtmlviewers ".

Then, I don′t have the file "C:\Program Files\Microsoft.AnalysisServices.DataMiningHtmlViewers\Microsoft.AnalysisServices.DataMiningHTMLViewers.dll " for using the web controls.

Can somebody help me?

Dunia

The package coming with SQL Samples will install the sample source code in a Samples subfolder somewhere under %ProgramFiles%\Microsoft SQL Server\90. I am almost sure that the location is %ProgramFiles%\Microsoft SQL Server\90\Tools\Samples, but I may be wrong. A search for a folder called Samples under %ProgramFiles%\Microsoft SQL Server\90 will find the right location.

At that location, you will find the Data Mining web viewer sample, which is a Visual Studio 2005 solution. You have to open the solution in Visual Studio and build it. It contains:

- the web viewers sample (one assembly)

- a setup package that deploys the assembly together with the documentation in the location you mentioned (under %ProgramFiles%)

After building the solution, you should run the generated setup package, install the sample and then use it according to the documentation

Hope this helps

|||

Hi,

first of all I′d like to thank you for the answer.

I tryed to build the solution that you mentioned but I had the following error:

"Could not find file 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls\obj\Debug\Microsoft.AnalysisServices.DataMiningHtmlViewers.dll'"

Maybe the installer of the samples didn′t install this dll. I think that this is the problem. Do you know if I can download this dll from a site?

Thanks,

Dunia

|||

I never saw this before, but I can think of two possible reasons:

- In Visual Studio, you opened the setup project and not the whole solution which contains both the viewers project and the setup

or

- the solution was opened, you are trying to build the Release version and it incorrectly points to the debug version of the dll.

I would suggest:

- make sure that the full solution is opened, not only the setup project. Based on the error, I think it should be a file with the ".sln" extension in the "C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls" folder

- if that is not the problem, try to open in Visual Studio the .csproj project in 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls'. If this works, then you should retry to build the first project (the setup)

If none of these works, please let us know and I will post a zip containing the full solution for the sample

|||

Hello,

I have already tryed to build the .sln and .csproj, but I have the same error message, that there is no 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls\obj\Debug\Microsoft.AnalysisServices.DataMiningHtmlViewers.dll'.

I′d really appreciate if you could post me this file.....

Thanks,

Dunia

|||

My e-mail is dunia@.execplan.com.br

|||

Hello

Sorry for the late answer. I have sent you the sample code. Please let us know if you run into any more issues

bogdan

|||

I have the same problem with installing data mining web controls.

Can you please send me the zip that contains the solution ?

Thanks a lot

My email is georges_0@.hotmail.com

|||Hi Guys,
Can i have a copy of the file, Microsoft.AnalysisServices.DataMiningHtmlViewers.dll too. My email is bala.singam@.hotmail.com .

I also downloaded " DataMiningViewerClient " what's the different with the Data Mining Web Controls?|||I am having the same issue. I have made certain that all prerequisites have been installed and configured properly. How do I get a copy of this that has the missing dll?|||Dear friends.

The requested files are available at :
http://www.codeplex.com/MSFTASProdSamples/SourceControl/ListDownloadableCommits.aspx

installing .Net framework and sql server issues

I have downloaded .net,visual basic and sql server components (2005 beta 2)
- I had .net 1.0 and no other vb or sql server versions on my machine.
- i uninstalled the 1.0 framework and installed the 2.0 beta 2 version
- when i tried to install sql server it told me that i either had previous versions of sql server or .net on my machine.
- i therefore uninstalled .net beta 2 and tried installing sql server again
-- this time i got a message saying "please install .net 2.0 before proceeding"
-- i have no clues as how to proceed
-- i used the clean up tools--sqlbuw.exe and vs2005_beta_cleanup_tool.exe

Thank you

There's a full uninstall here:

http://support.microsoft.com/kb/909967

installing .Net framework and sql server issues

I have downloaded .net,visual basic and sql server components (2005 beta 2)
- I had .net 1.0 and no other vb or sql server versions on my machine.
- i uninstalled the 1.0 framework and installed the 2.0 beta 2 version
- when i tried to install sql server it told me that i either had previous versions of sql server or .net on my machine.
- i therefore uninstalled .net beta 2 and tried installing sql server again
-- this time i got a message saying "please install .net 2.0 before proceeding"
-- i have no clues as how to proceed
-- i used the clean up tools--sqlbuw.exe and vs2005_beta_cleanup_tool.exe

Thank you

There's a full uninstall here:

http://support.microsoft.com/kb/909967

sql

Installed SQLServer 2005 TrialEdition

Hi Fellows,

I am really in a fix.I have downloaded the trial version from MIcrosoft site and run setup with named instance. But I cannot find my management console link anywhere. Can anyone help me here .

My site is : Windows XP Professional SP2

Installed : SQLServer 2005 180Day Trial Pack downloaded from Microsoft Network.

I ran setup from : server directory and also from tools directory.

In my programes menu I can only see Configuration Toolsunder which there are three options :

1) SQL Server Configuration Tool

2) SQL Server Surface Configuration Tool and

3) SQL Server Error and Usage Reporting

Is it SQL Server 2005 Enterprise edition? XP SP2 does not support Enterprise edition. You need server operating systems to support Enterprise edition such as W2K SP4, W2K3 EE SP2, Longhorn Server.

|||

I dont know . I just downloaded the server from MSDN site it was an x86 executable file . My PC is a Win XP Professional on our internal Domain .

|||What does the Splash screen tell you ? After calling the installer you should get the splah screen showing the dition type you are trying to install.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Hi

I just uninstalled everything and run the installer again . It says SQL 2005 Server but does not give anytype of edition. However now I find that the Management Console is appearing in the program menu.

Thanks to all . But I am still mystified as to why it should do like this .

Regards

|||Strange thing, I just started my ISO and it directly gives me the edition type as of [1]

[1] http://www.sqlserver2005.de/SharedFiles/SplashScreen.jpg

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||Two questions:

1/How did you uninstall everything? I uninstalled in the wrong order from add/remove programs now I am in three quarters installed limbo. [Ghosting the machine seems the simplest way out].

2/I did not get the tools setup to work, or the sample database install in the server directory, the error message was (in both cases)
"The following components that you chose to install are already installed on the machine. To view a report of available options and alternatives click on Details."
Clicking on details was unhelpful (said to maintain components from add/remove programs)
[The components that were already installed did not mention the sample databases]

This is on Windows 2000 SP4, with sqlserver 2005 evaluation edition.

Thank you for your time,
Turloch|||

Hi

I simply went to the Add/remove programs and selected the Microsoft SQL Server 2005 , clicked remove . It asked and it simply removed it clean including the native client etc. Although the Add/Remove page still shows the name it has actually removed the product. To remove the name from the list you will have to select them one by one and click remove. It will prompt you with something like 'This program can only be used for removing installed options' Just click Ok and the entry will go away .

For the tools setup to work when you install you will get a page after the SQL support files and Native client are installed wherein you are asked to choose what you wish to install . Select both the SQL database services as well as the Client tools ( Last option on the page ) then click next .

Regards

|||Thanks...

I went add/remove [the wrong sql server component first] and the computer removed the entry in add/remove programs but left the program (mostly) intact [I had to repair .net from the add/remove programs section]

>For

the tools setup to work when you install you will get a page after the

SQL support files and Native client are installed wherein you are asked

to choose what you wish to install . Select both the SQL database

services as well as the Client tools ( Last option on the page ) then

click next .

I still get the error/warning:

"The following

components that you chose to install are already installed on the

machine. To view a report of available options and alternatives click

on Details."

[Component is:

Workstation components, Books Online and development tools 9:00.1399.06]

Maybe I was just unlucky not to choose the databases on my first install.

I can install the sample databases that have there own msi, I suppose I can create a test

database and or try to attach those database files for now, thanks.

Thank you for your time,

Turloch

|||[FYI: I attached the demo databases installed as .msi files into my limping sql server install]|||I didn′t understand your last reply, is the problem solved ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Yes I managed to resolve the problem . Here is what I did

1) Went to Add/Remove programs

2) Select MS SQL Server 2005

3) Clicked on Remove ( It asked me what components I want to remove so I checked Both Database Server and Workgroup Client )

4) Then removed everything else that was MS SQL

5) Re-ran the setup file

Wala .. I had the SQL Server Management Console in the Program List.

Thanks all

Regards

Installation SP1 freezes

When I try to install SP1 on W2K3 Standard Server, the installation
freezes on "Inspecting".
I downloaded the file WindowsServer2003-KB889101-SP1-x86-ENU.exe from
the Microsoft download area.
I have tried the installation twice with the same results. The only
way out was to use the hardware Reset key.
Any ideas?
TIA
Sorry, posted into wrong group.

Installation SP1 freezes

When I try to install SP1 on W2K3 Standard Server, the installation
freezes on "Inspecting".
I downloaded the file WindowsServer2003-KB889101-SP1-x86-ENU.exe from
the Microsoft download area.
I have tried the installation twice with the same results. The only
way out was to use the hardware Reset key.
Any ideas?
TIASorry, posted into wrong group.

Installation SP1 freezes

When I try to install SP1 on W2K3 Standard Server, the installation
freezes on "Inspecting".
I downloaded the file WindowsServer2003-KB889101-SP1-x86-ENU.exe from
the Microsoft download area.
I have tried the installation twice with the same results. The only
way out was to use the hardware Reset key.
Any ideas?
TIASorry, posted into wrong group.

Installation Question

When I installed SQL Server 2005 from the downloaded disk, I seem to have
also installed visual studio. Firstly, is this an option that I checked at
the time (sorry but it was a while ago). The reason I ask is that the VS
2005 seems incomplete and only gives me access to AS, RS and IS packages.
However I want to use c#. So, can I still install the other components of VS
2005 or have I got the installation order incorrect?
TIA,
JB
What you have is the stripped down version of Visual Studio called the
Business Intelligence Management Studio. If you install Visual Studio 2005,
it will give you a complete install with all components active, including
the BI ones already installed. You have not messed anything up. The two
programs (SQL 2005 and VS 2005) were designed to complement each other.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"JB" <JB@.Acme.Com> wrote in message
news:exAJzbb%23FHA.916@.TK2MSFTNGP10.phx.gbl...
> When I installed SQL Server 2005 from the downloaded disk, I seem to have
> also installed visual studio. Firstly, is this an option that I checked at
> the time (sorry but it was a while ago). The reason I ask is that the VS
> 2005 seems incomplete and only gives me access to AS, RS and IS packages.
> However I want to use c#. So, can I still install the other components of
> VS 2005 or have I got the installation order incorrect?
> TIA,
> JB
>

Installation Question

When I installed SQL Server 2005 from the downloaded disk, I seem to have
also installed visual studio. Firstly, is this an option that I checked at
the time (sorry but it was a while ago). The reason I ask is that the VS
2005 seems incomplete and only gives me access to AS, RS and IS packages.
However I want to use c#. So, can I still install the other components of VS
2005 or have I got the installation order incorrect?
TIA,
JBWhat you have is the stripped down version of Visual Studio called the
Business Intelligence Management Studio. If you install Visual Studio 2005,
it will give you a complete install with all components active, including
the BI ones already installed. You have not messed anything up. The two
programs (SQL 2005 and VS 2005) were designed to complement each other.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"JB" <JB@.Acme.Com> wrote in message
news:exAJzbb%23FHA.916@.TK2MSFTNGP10.phx.gbl...
> When I installed SQL Server 2005 from the downloaded disk, I seem to have
> also installed visual studio. Firstly, is this an option that I checked at
> the time (sorry but it was a while ago). The reason I ask is that the VS
> 2005 seems incomplete and only gives me access to AS, RS and IS packages.
> However I want to use c#. So, can I still install the other components of
> VS 2005 or have I got the installation order incorrect?
> TIA,
> JB
>

Installation Question

When I installed SQL Server 2005 from the downloaded disk, I seem to have
also installed visual studio. Firstly, is this an option that I checked at
the time (sorry but it was a while ago). The reason I ask is that the VS
2005 seems incomplete and only gives me access to AS, RS and IS packages.
However I want to use c#. So, can I still install the other components of VS
2005 or have I got the installation order incorrect?
TIA,
JBWhat you have is the stripped down version of Visual Studio called the
Business Intelligence Management Studio. If you install Visual Studio 2005,
it will give you a complete install with all components active, including
the BI ones already installed. You have not messed anything up. The two
programs (SQL 2005 and VS 2005) were designed to complement each other.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"JB" <JB@.Acme.Com> wrote in message
news:exAJzbb%23FHA.916@.TK2MSFTNGP10.phx.gbl...
> When I installed SQL Server 2005 from the downloaded disk, I seem to have
> also installed visual studio. Firstly, is this an option that I checked at
> the time (sorry but it was a while ago). The reason I ask is that the VS
> 2005 seems incomplete and only gives me access to AS, RS and IS packages.
> However I want to use c#. So, can I still install the other components of
> VS 2005 or have I got the installation order incorrect?
> TIA,
> JB
>

Installation Problems

I downloaded MS SQL as an ISO file, and tried to mount the image. All I got was a quick loading screen and then MS SQL in a grey box, and it didn't even show up on my applications list when I pushed CTRL+ALT+DELETE.

Um. Help? :[

Hhhmm, that sounds strange, could be a number of reasons why this is happening, what are you using to mount the image? Alcohol 120% is a good program http://www.alcohol-soft.com/

If you don't want to spend a lot of time troubleshooting this you can always extract the ISO contents to a local folder and install SQL from there, Winimage is a good freebie you can use to extract the ISO http://www.winimage.com/

|||Try to directly run the setup in the folder: SQL Server x86\Servers

There might be some security issues which does not allow you to run .hta files.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||In my case, I am using Virtual CDROM from http://www.softwarepatch.com/windows/xpvirtualcddownload.html to access my ISO images. All you need to do is follow the readme file. You can even share the virtual CD ROM in your network

installation problems

I downloaded the latest version (I guess) and tried to install, but it
doesn't seem to have installed. The file name is MSDE2000A.exe, and it's
about 43meg.
I double-click, go through the whole thing accepting all the default
options, and when I am done, I see nothing in the services dialog that
indicates I have installed this. Nor do I see the thing in the system tray
that I see referenced in this group in other threads.
Anyone know what I am doing wrong?
I should add that I'm on Windows 2000 Pro, no SP. It's in a lab, so it's got
no internet access and is a fresh, clean install of Windows.
"middletree" <middletree@.htomail.com> wrote in message
news:%23pnVLJyAFHA.2608@.TK2MSFTNGP10.phx.gbl...
> I downloaded the latest version (I guess) and tried to install, but it
> doesn't seem to have installed. The file name is MSDE2000A.exe, and it's
> about 43meg.
> I double-click, go through the whole thing accepting all the default
> options, and when I am done, I see nothing in the services dialog that
> indicates I have installed this. Nor do I see the thing in the system tray
> that I see referenced in this group in other threads.
> Anyone know what I am doing wrong?
>
|||hi,
middletree wrote:
> I downloaded the latest version (I guess) and tried to install, but it
> doesn't seem to have installed. The file name is MSDE2000A.exe, and
> it's about 43meg.
> I double-click, go through the whole thing accepting all the default
> options, and when I am done, I see nothing in the services dialog that
> indicates I have installed this. Nor do I see the thing in the system
> tray that I see referenced in this group in other threads.
> Anyone know what I am doing wrong?
in order to install MSDE you have to run the setup.exe bootstrap installer
passing in the required/desired parameters...
that's to say you have to open a command prompt windows, navigate to the
folder you unpacked the Web downloaded package and run
C:\...\>setup.exe <parameters list>
you can see all supported parameters at
http://msdn.microsoft.com/library/de...stsql_84xl.asp
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||OK, thanks.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:35pcbjF4ovqd9U1@.individual.net...
> hi,
> middletree wrote:
> in order to install MSDE you have to run the setup.exe bootstrap installer
> passing in the required/desired parameters...
> that's to say you have to open a command prompt windows, navigate to the
> folder you unpacked the Web downloaded package and run
> C:\...\>setup.exe <parameters list>
> you can see all supported parameters at
>
http://msdn.microsoft.com/library/de...stsql_84xl.asp
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>