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 hotfix SQL2000-KB810185-8.00.0780-ENU

I am attempting to install this hotfix on a second instance of SQL Server
2000 running sp3 on a window 2003 server. I successfully installed the
hotfix on the first instance with no problems following the same sequence of
events against the first instance.
I am unable to install as it tells me one of the files is write locked. I
have shutdown both instances (SQL server and SQL agent) as well as the MSDTC.
I have shutdown the Window 2003 server and attempted to run the install. I
was successfully able to install the hotfixes on 2 instances on another
server running the same products.
The file in question is dbmslpcn.dll.
Any suggestions ?
1. Try renaming the DLL - does this work?
2. Run TLIST (included in windows resource kit) to see what app is holding
a lock to this DLL
syntax: TLIST -m <DLL>/<.exe Name>
3. shutdown all unecessary services and set to manual mode, then reboot.
See KB for a list of services to NOT shut down:
INF: Order of Installation for SQL Server 7.0 Clustering Setup WGID:249
ID: 219264
Do not shut off any services necessary for disk or network access.
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||I ran the tasklist command, found my application that was using the file and
stopped that service. thanks very much for the info
"Fany Vargas [MSFT]" wrote:

> 1. Try renaming the DLL - does this work?
> 2. Run TLIST (included in windows resource kit) to see what app is holding
> a lock to this DLL
> syntax: TLIST -m <DLL>/<.exe Name>
> 3. shutdown all unecessary services and set to manual mode, then reboot.
> See KB for a list of services to NOT shut down:
> INF: Order of Installation for SQL Server 7.0 Clustering Setup WGID:249
> ID: 219264
> Do not shut off any services necessary for disk or network access.
> Fany Vargas
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their
> Microsoft software to better protect against viruses and security
> vulnerabilities. The easiest way to do this is to visit the following
> websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>

installing hotfix SQL2000-KB810185-8.00.0780-ENU

I am attempting to install this hotfix on a second instance of SQL Server
2000 running sp3 on a window 2003 server. I successfully installed the
hotfix on the first instance with no problems following the same sequence of
events against the first instance.
I am unable to install as it tells me one of the files is write locked. I
have shutdown both instances (SQL server and SQL agent) as well as the MSDTC
.
I have shutdown the Window 2003 server and attempted to run the install. I
was successfully able to install the hotfixes on 2 instances on another
server running the same products.
The file in question is dbmslpcn.dll.
Any suggestions ?1. Try renaming the DLL - does this work?
2. Run TLIST (included in windows resource kit) to see what app is holding
a lock to this DLL
syntax: TLIST -m <DLL>/<.exe Name>
3. shutdown all unecessary services and set to manual mode, then reboot.
See KB for a list of services to NOT shut down:
INF: Order of Installation for SQL Server 7.0 Clustering Setup WGID:249
ID: 219264
Do not shut off any services necessary for disk or network access.
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx|||I ran the tasklist command, found my application that was using the file and
stopped that service. thanks very much for the info
"Fany Vargas [MSFT]" wrote:

> 1. Try renaming the DLL - does this work?
> 2. Run TLIST (included in windows resource kit) to see what app is holding
> a lock to this DLL
> syntax: TLIST -m <DLL>/<.exe Name>
> 3. shutdown all unecessary services and set to manual mode, then reboot.
> See KB for a list of services to NOT shut down:
> INF: Order of Installation for SQL Server 7.0 Clustering Setup WGID:249
> ID: 219264
> Do not shut off any services necessary for disk or network access.
> Fany Vargas
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their
> Microsoft software to better protect against viruses and security
> vulnerabilities. The easiest way to do this is to visit the following
> websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>sql

installing hotfix SQL2000-KB810185-8.00.0780-ENU

I am attempting to install this hotfix on a second instance of SQL Server
2000 running sp3 on a window 2003 server. I successfully installed the
hotfix on the first instance with no problems following the same sequence of
events against the first instance.
I am unable to install as it tells me one of the files is write locked. I
have shutdown both instances (SQL server and SQL agent) as well as the MSDTC.
I have shutdown the Window 2003 server and attempted to run the install. I
was successfully able to install the hotfixes on 2 instances on another
server running the same products.
The file in question is dbmslpcn.dll.
Any suggestions ?1. Try renaming the DLL - does this work?
2. Run TLIST (included in windows resource kit) to see what app is holding
a lock to this DLL
syntax: TLIST -m <DLL>/<.exe Name>
3. shutdown all unecessary services and set to manual mode, then reboot.
See KB for a list of services to NOT shut down:
INF: Order of Installation for SQL Server 7.0 Clustering Setup WGID:249
ID: 219264
Do not shut off any services necessary for disk or network access.
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx|||I ran the tasklist command, found my application that was using the file and
stopped that service. thanks very much for the info
"Fany Vargas [MSFT]" wrote:
> 1. Try renaming the DLL - does this work?
> 2. Run TLIST (included in windows resource kit) to see what app is holding
> a lock to this DLL
> syntax: TLIST -m <DLL>/<.exe Name>
> 3. shutdown all unecessary services and set to manual mode, then reboot.
> See KB for a list of services to NOT shut down:
> INF: Order of Installation for SQL Server 7.0 Clustering Setup WGID:249
> ID: 219264
> Do not shut off any services necessary for disk or network access.
> Fany Vargas
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their
> Microsoft software to better protect against viruses and security
> vulnerabilities. The easiest way to do this is to visit the following
> websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>

Installing Exchange Pack for Reporting Services

Has anyone successfully installed the Exchange Pack for Reporting Services?
I've attempted a couple of times and continue to get "Object Reference not
set to an instance of object", which causes the install to rollback.
Does anyone know how to correct this problem?
This question was originally posted in 10\04, but there was never an answer
posted.Do you have a default instance of SQL Server? What OS are you running? We
have never been able to repro this here.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"winkle60" <winkle60@.discussions.microsoft.com> wrote in message
news:22141FD2-86C1-4CBC-87F1-6E09FD77CC94@.microsoft.com...
> Has anyone successfully installed the Exchange Pack for Reporting
> Services?
> I've attempted a couple of times and continue to get "Object Reference not
> set to an instance of object", which causes the install to rollback.
> Does anyone know how to correct this problem?
> This question was originally posted in 10\04, but there was never an
> answer
> posted.
>|||Yes, I have the default instance running on SQL Server. The Reporting Service
installed fine. We are running Server 2003 STD (ver. 5.2.3790). .NET
Framework 1.1 (ver 1.1.4322.573). No Visual Studio installed.
"Brian Welcker [MSFT]" wrote:
> Do you have a default instance of SQL Server? What OS are you running? We
> have never been able to repro this here.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "winkle60" <winkle60@.discussions.microsoft.com> wrote in message
> news:22141FD2-86C1-4CBC-87F1-6E09FD77CC94@.microsoft.com...
> > Has anyone successfully installed the Exchange Pack for Reporting
> > Services?
> >
> > I've attempted a couple of times and continue to get "Object Reference not
> > set to an instance of object", which causes the install to rollback.
> >
> > Does anyone know how to correct this problem?
> >
> > This question was originally posted in 10\04, but there was never an
> > answer
> > posted.
> >
>
>|||I had this error, and it went away once I installed Visual Studio.NET Pro on
the PC, so there must be some object missing without it.
Michael
"winkle60" <winkle60@.discussions.microsoft.com> wrote in message
news:22141FD2-86C1-4CBC-87F1-6E09FD77CC94@.microsoft.com...
> Has anyone successfully installed the Exchange Pack for Reporting
Services?
> I've attempted a couple of times and continue to get "Object Reference not
> set to an instance of object", which causes the install to rollback.
> Does anyone know how to correct this problem?
> This question was originally posted in 10\04, but there was never an
answer
> posted.
>|||I have not tried installing Visual Studio, but I had a feeling that it might
be the issue even though it is supposed to be optional. I will try it when I
get the chance and see what happens.
"michael@.civis.com" wrote:
> I had this error, and it went away once I installed Visual Studio.NET Pro on
> the PC, so there must be some object missing without it.
> Michael
> "winkle60" <winkle60@.discussions.microsoft.com> wrote in message
> news:22141FD2-86C1-4CBC-87F1-6E09FD77CC94@.microsoft.com...
> > Has anyone successfully installed the Exchange Pack for Reporting
> Services?
> >
> > I've attempted a couple of times and continue to get "Object Reference not
> > set to an instance of object", which causes the install to rollback.
> >
> > Does anyone know how to correct this problem?
> >
> > This question was originally posted in 10\04, but there was never an
> answer
> > posted.
> >
>
>|||I installed Visual Studio .NET 2003 and was able to complete the install.
Another question, is there anyway to actually pull data from the Exchange
system without installing the SSW softeware extraction piece on the Exchange
server?
"michael@.civis.com" wrote:
> I had this error, and it went away once I installed Visual Studio.NET Pro on
> the PC, so there must be some object missing without it.
> Michael
> "winkle60" <winkle60@.discussions.microsoft.com> wrote in message
> news:22141FD2-86C1-4CBC-87F1-6E09FD77CC94@.microsoft.com...
> > Has anyone successfully installed the Exchange Pack for Reporting
> Services?
> >
> > I've attempted a couple of times and continue to get "Object Reference not
> > set to an instance of object", which causes the install to rollback.
> >
> > Does anyone know how to correct this problem?
> >
> > This question was originally posted in 10\04, but there was never an
> answer
> > posted.
> >
>
>|||I'm wondering the same thing. Is the SSQ software piece required? If so, is
that a seperate product you have to buy? I'd be curious to hear from anyone
who made this work. Thanks.
"winkle60" wrote:
> I installed Visual Studio .NET 2003 and was able to complete the install.
> Another question, is there anyway to actually pull data from the Exchange
> system without installing the SSW softeware extraction piece on the Exchange
> server?
> "michael@.civis.com" wrote:
> > I had this error, and it went away once I installed Visual Studio.NET Pro on
> > the PC, so there must be some object missing without it.
> >
> > Michael
> >
> > "winkle60" <winkle60@.discussions.microsoft.com> wrote in message
> > news:22141FD2-86C1-4CBC-87F1-6E09FD77CC94@.microsoft.com...
> > > Has anyone successfully installed the Exchange Pack for Reporting
> > Services?
> > >
> > > I've attempted a couple of times and continue to get "Object Reference not
> > > set to an instance of object", which causes the install to rollback.
> > >
> > > Does anyone know how to correct this problem?
> > >
> > > This question was originally posted in 10\04, but there was never an
> > answer
> > > posted.
> > >
> >
> >
> >

Installed SQL2000 SP4 successfully but still shows RTM as installe

After installing SP4 on server, I checked ProductLevel and Productversion and
they still showed RTM and 8.00.194.
I did see a whitepaper about this regarding SP1 and the fix was to apply the
latest SP which is SP4, so this does not apply to me.
The other option was to edit the registry key which I do not feel
comfortable doing.
Has anyone else come across this before??
Hi Kristen
Your version number is not SP1 (384) but the RTM version.
Did you run the setup from the directory that you unzipped the files to?
Have you more than one instance of SQL Server running and have you upgraded
them all?
Did you run the service pack setup from the server?
John
"Kristen" wrote:

> After installing SP4 on server, I checked ProductLevel and Productversion and
> they still showed RTM and 8.00.194.
> I did see a whitepaper about this regarding SP1 and the fix was to apply the
> latest SP which is SP4, so this does not apply to me.
> The other option was to edit the registry key which I do not feel
> comfortable doing.
> Has anyone else come across this before??

Installed SQL2000 SP4 successfully but still shows RTM as installe

After installing SP4 on server, I checked ProductLevel and Productversion and
they still showed RTM and 8.00.194.
I did see a whitepaper about this regarding SP1 and the fix was to apply the
latest SP which is SP4, so this does not apply to me.
The other option was to edit the registry key which I do not feel
comfortable doing.
Has anyone else come across this before'?Hi Kristen
Your version number is not SP1 (384) but the RTM version.
Did you run the setup from the directory that you unzipped the files to?
Have you more than one instance of SQL Server running and have you upgraded
them all?
Did you run the service pack setup from the server?
John
"Kristen" wrote:
> After installing SP4 on server, I checked ProductLevel and Productversion and
> they still showed RTM and 8.00.194.
> I did see a whitepaper about this regarding SP1 and the fix was to apply the
> latest SP which is SP4, so this does not apply to me.
> The other option was to edit the registry key which I do not feel
> comfortable doing.
> Has anyone else come across this before'?

Installed SQL2000 SP4 successfully but still shows RTM as installe

After installing SP4 on server, I checked ProductLevel and Productversion an
d
they still showed RTM and 8.00.194.
I did see a whitepaper about this regarding SP1 and the fix was to apply the
latest SP which is SP4, so this does not apply to me.
The other option was to edit the registry key which I do not feel
comfortable doing.
Has anyone else come across this before'?Hi Kristen
Your version number is not SP1 (384) but the RTM version.
Did you run the setup from the directory that you unzipped the files to?
Have you more than one instance of SQL Server running and have you upgraded
them all?
Did you run the service pack setup from the server?
John
"Kristen" wrote:

> After installing SP4 on server, I checked ProductLevel and Productversion
and
> they still showed RTM and 8.00.194.
> I did see a whitepaper about this regarding SP1 and the fix was to apply t
he
> latest SP which is SP4, so this does not apply to me.
> The other option was to edit the registry key which I do not feel
> comfortable doing.
> Has anyone else come across this before'?

Installation woes

Hello all,
I am attempting to install RS onto the following machine:
Win2k3 Domain Controller
SQL Standard
I have installed RS successfully, however at the end of the installation it
instructs me that it could not be activated.
I run rsactivate without success...
When I type http://ipaddress/reports I recieve an error Http 404 file not
found...
What have I done wrong?
Cheers
AshThis is the MS docs:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/htm/gs_installingrs_v1_8k82.asp
This may help more
http://weblogs.asp.net/taganov/archive/2004/03/23/94514.aspx
A Google search should also render a whole bunch.
"AshVsAOD" <.> wrote in message
news:OjsXafHZEHA.2016@.TK2MSFTNGP09.phx.gbl...
> Hello all,
> I am attempting to install RS onto the following machine:
> Win2k3 Domain Controller
> SQL Standard
> I have installed RS successfully, however at the end of the installation
it
> instructs me that it could not be activated.
> I run rsactivate without success...
> When I type http://ipaddress/reports I recieve an error Http 404 file not
> found...
> What have I done wrong?
> Cheers
> Ash
>|||I have read and re-read both of these documents, I perhaps should have
specified that in my previous post.
Still it doesn't work.
"Chris Botha" <chris_s_botha@.AT_h.o.t.m.a.i.l.com> wrote in message
news:%23dDwh5IZEHA.3420@.TK2MSFTNGP12.phx.gbl...
> This is the MS docs:
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/htm/gs_installingrs_v1_8k82.asp
> This may help more
> http://weblogs.asp.net/taganov/archive/2004/03/23/94514.aspx
> A Google search should also render a whole bunch.
> "AshVsAOD" <.> wrote in message
> news:OjsXafHZEHA.2016@.TK2MSFTNGP09.phx.gbl...
> > Hello all,
> >
> > I am attempting to install RS onto the following machine:
> >
> > Win2k3 Domain Controller
> > SQL Standard
> >
> > I have installed RS successfully, however at the end of the installation
> it
> > instructs me that it could not be activated.
> >
> > I run rsactivate without success...
> >
> > When I type http://ipaddress/reports I recieve an error Http 404 file
not
> > found...
> >
> > What have I done wrong?
> >
> > Cheers
> >
> > Ash
> >
> >
>|||You are right, you should get 401 access denied for a security issue.
Here is what I would have attempted with my knowledge.
1. Check that the virtual directory exists in IIS.
2. The default page on the Reports directory is called Home.aspx, ensure it
is there.
From your example try http://ipaddress/reports/Home.aspx
3. Maybe IIS is blocking aspx pages, so put "aaa.htm" and a "aaa.txt" on the
virtual directory, see if you can get to them.
4. Create a test virtual directory, allow anonymous access, and put some
test pages there, txt, htm, aspx and see if you can get to them. Take the
anonymous access off, see what happens.
"AshVsAOD" <.> wrote in message
news:#iFR2CJZEHA.2816@.TK2MSFTNGP11.phx.gbl...
> I have read and re-read both of these documents, I perhaps should have
> specified that in my previous post.
> Still it doesn't work.
> "Chris Botha" <chris_s_botha@.AT_h.o.t.m.a.i.l.com> wrote in message
> news:%23dDwh5IZEHA.3420@.TK2MSFTNGP12.phx.gbl...
> > This is the MS docs:
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/htm/gs_installingrs_v1_8k82.asp
> >
> > This may help more
> > http://weblogs.asp.net/taganov/archive/2004/03/23/94514.aspx
> >
> > A Google search should also render a whole bunch.
> >
> > "AshVsAOD" <.> wrote in message
> > news:OjsXafHZEHA.2016@.TK2MSFTNGP09.phx.gbl...
> > > Hello all,
> > >
> > > I am attempting to install RS onto the following machine:
> > >
> > > Win2k3 Domain Controller
> > > SQL Standard
> > >
> > > I have installed RS successfully, however at the end of the
installation
> > it
> > > instructs me that it could not be activated.
> > >
> > > I run rsactivate without success...
> > >
> > > When I type http://ipaddress/reports I recieve an error Http 404 file
> not
> > > found...
> > >
> > > What have I done wrong?
> > >
> > > Cheers
> > >
> > > Ash
> > >
> > >
> >
> >
>|||Chris,
1. The virtual directory exists
2. The page is there and is accessable
3. Following the "Instructions" you pointed to in your previous post I
shouldn't need to do anything when installing on a brand new Win2k3 Domain
Controller, however I thought along these lines also before coming up empty.
4. I am running other Web applications fine off the server. CRM for one.
The whole reason I posted here was that I had exhausted all avenues. I
appreciate the time you have put into this.
Any other ideas anyone? I am at a loss here, I have installed RS
successfully many times on Win2k, this is my first experience with Win2k3.
I am leaning towards CRM having something to do with it. I will continue
the search for answers.
Ash
"Chris Botha" <chris_s_botha@.AT_h.o.t.m.a.i.l.com> wrote in message
news:OQRZG$JZEHA.2544@.TK2MSFTNGP10.phx.gbl...
> You are right, you should get 401 access denied for a security issue.
> Here is what I would have attempted with my knowledge.
> 1. Check that the virtual directory exists in IIS.
> 2. The default page on the Reports directory is called Home.aspx, ensure
it
> is there.
> From your example try http://ipaddress/reports/Home.aspx
> 3. Maybe IIS is blocking aspx pages, so put "aaa.htm" and a "aaa.txt" on
the
> virtual directory, see if you can get to them.
> 4. Create a test virtual directory, allow anonymous access, and put some
> test pages there, txt, htm, aspx and see if you can get to them. Take the
> anonymous access off, see what happens.
> "AshVsAOD" <.> wrote in message
> news:#iFR2CJZEHA.2816@.TK2MSFTNGP11.phx.gbl...
> > I have read and re-read both of these documents, I perhaps should have
> > specified that in my previous post.
> >
> > Still it doesn't work.
> > "Chris Botha" <chris_s_botha@.AT_h.o.t.m.a.i.l.com> wrote in message
> > news:%23dDwh5IZEHA.3420@.TK2MSFTNGP12.phx.gbl...
> > > This is the MS docs:
> > >
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/htm/gs_installingrs_v1_8k82.asp
> > >
> > > This may help more
> > > http://weblogs.asp.net/taganov/archive/2004/03/23/94514.aspx
> > >
> > > A Google search should also render a whole bunch.
> > >
> > > "AshVsAOD" <.> wrote in message
> > > news:OjsXafHZEHA.2016@.TK2MSFTNGP09.phx.gbl...
> > > > Hello all,
> > > >
> > > > I am attempting to install RS onto the following machine:
> > > >
> > > > Win2k3 Domain Controller
> > > > SQL Standard
> > > >
> > > > I have installed RS successfully, however at the end of the
> installation
> > > it
> > > > instructs me that it could not be activated.
> > > >
> > > > I run rsactivate without success...
> > > >
> > > > When I type http://ipaddress/reports I recieve an error Http 404
file
> > not
> > > > found...
> > > >
> > > > What have I done wrong?
> > > >
> > > > Cheers
> > > >
> > > > Ash
> > > >
> > > >
> > >
> > >
> >
> >
>|||hi,
try this... but i prepared this for installing with share
point server..it may be helpful to u ..
***************
To configure a server running share point portal server,
sql server , analysis services and reporting services
Software Requirements:
1. windows 2003 server enterprise edition.
1.1. Configure application server (enable both front page
extensions and asp.net ) to install IIS.
1.2. Install smtp server
1.3. Configure DNS giving appropriate IP address.
2. SQL Server 2000 Enterprise Edition with Analysis
Services (if reqd) and service packs for both SQL server
and Analysis services.
3. Visual Studio .net Enterprise Architecture
4. Share Point Portal Server
Install share point portal server with out
desktop engine if u r using sql server on the same
machine.
while configuring share point portal server it
will ask to remove front page server extensions at the
time of creating a portal. remove the front page server
extensions and then restart the machine and after that
create a portal site.
5. Reporting services
While installing reporting services it will
check the system and gives a warning message that share
point is also installed in the system and we need to
manually configure reporting services.
leave it and go for the next tab.
Specify a domain/user account where ever asked.
unckeck the ssl certification if u dont have
any and check direct to default
website.
Then continue installing.
After installation
1. go to IIS
right click on reports--> properties--
>configuration -->extensions-->edit
and then uncheck if "Verify that the file exists" is
checked.
and then click OK
close IIS.
2. open E:\Inetpub\wwwroot\webconfig file.
2.1. in <http Modules>
include the third line also.
<add name="Session"
type="System.Web.SessionState.SessionStateModule"/>
and change the below line as follows
pages enableSessionState="true" enableViewState="true"
enableViewStateMac="true" validateRequest="false" />
3. In cmd prompt go to
E:\Program Files\Common Files\Microsoft Shared\web server
extensions\60\BIN
type
stsadm -o addpath -url http://localhost/reportserver -type
exclusion
and
stsadm -o addpath -url http://localhost/reports -type
exclusion
4. in cmd prompt go to
E:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer
type
rsactivate -c "rsreportserver.config"
Then restart the machine
ur configuration is complete now.
********************
>--Original Message--
>Chris,
>1. The virtual directory exists
>2. The page is there and is accessable
>3. Following the "Instructions" you pointed to in your
previous post I
>shouldn't need to do anything when installing on a brand
new Win2k3 Domain
>Controller, however I thought along these lines also
before coming up empty.
>4. I am running other Web applications fine off the
server. CRM for one.
>The whole reason I posted here was that I had exhausted
all avenues. I
>appreciate the time you have put into this.
>Any other ideas anyone? I am at a loss here, I have
installed RS
>successfully many times on Win2k, this is my first
experience with Win2k3.
>I am leaning towards CRM having something to do with it.
I will continue
>the search for answers.
>Ash
>"Chris Botha" <chris_s_botha@.AT_h.o.t.m.a.i.l.com> wrote
in message
>news:OQRZG$JZEHA.2544@.TK2MSFTNGP10.phx.gbl...
>> You are right, you should get 401 access denied for a
security issue.
>> Here is what I would have attempted with my knowledge.
>> 1. Check that the virtual directory exists in IIS.
>> 2. The default page on the Reports directory is called
Home.aspx, ensure
>it
>> is there.
>> From your example try
http://ipaddress/reports/Home.aspx
>> 3. Maybe IIS is blocking aspx pages, so put "aaa.htm"
and a "aaa.txt" on
>the
>> virtual directory, see if you can get to them.
>> 4. Create a test virtual directory, allow anonymous
access, and put some
>> test pages there, txt, htm, aspx and see if you can get
to them. Take the
>> anonymous access off, see what happens.
>> "AshVsAOD" <.> wrote in message
>> news:#iFR2CJZEHA.2816@.TK2MSFTNGP11.phx.gbl...
>> > I have read and re-read both of these documents, I
perhaps should have
>> > specified that in my previous post.
>> >
>> > Still it doesn't work.
>> > "Chris Botha" <chris_s_botha@.AT_h.o.t.m.a.i.l.com>
wrote in message
>> > news:%23dDwh5IZEHA.3420@.TK2MSFTNGP12.phx.gbl...
>> > > This is the MS docs:
>> > >
>> >
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-
us/rsinstall/htm/gs_installingrs_v1_8k82.asp
>> > >
>> > > This may help more
>> > >
http://weblogs.asp.net/taganov/archive/2004/03/23/94514.asp
x
>> > >
>> > > A Google search should also render a whole bunch.
>> > >
>> > > "AshVsAOD" <.> wrote in message
>> > > news:OjsXafHZEHA.2016@.TK2MSFTNGP09.phx.gbl...
>> > > > Hello all,
>> > > >
>> > > > I am attempting to install RS onto the following
machine:
>> > > >
>> > > > Win2k3 Domain Controller
>> > > > SQL Standard
>> > > >
>> > > > I have installed RS successfully, however at the
end of the
>> installation
>> > > it
>> > > > instructs me that it could not be activated.
>> > > >
>> > > > I run rsactivate without success...
>> > > >
>> > > > When I type http://ipaddress/reports I recieve an
error Http 404
>file
>> > not
>> > > > found...
>> > > >
>> > > > What have I done wrong?
>> > > >
>> > > > Cheers
>> > > >
>> > > > Ash
>> > > >
>> > > >
>> > >
>> > >
>> >
>> >
>>
>
>.
>

Installation Problems : SQL and RS in diff domains

Hello,
I have been trying to install RS for a while now. I was able to
install it successfully when I had the SQL server running locally.
But I need to make to work having the SQL server on a different
machine.
Here is my scenario.
1. SQL server 2000 is running on a Win2003 Server which is NOT in my
domain
2. Reporting services will run on my machine which is also running
Win2003 Server
My options during installation are
Windows Authenication and
for the reportServer a Service account (default) option
At the end of the installation I get a message saying that Reporting
Services cannot be initalized
I try to access the localhost/Reports
and I get the following error message
============= The report server cannot open a connection to the report server
database. A connection to the database is required for all requests
and processing. (rsReportServerDatabaseUnavailable) Get Online Help
Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection.
=============
I would like to know if the problem is due to the fact that the SQL
server is running outside my domain ?
Also I would appreciate what are the best options to choose for the
account types, I read diff docs and each give a different opinion.
Thanks
BofoHi,
I am also facing the same problem. pls help us
Thanks,
Raj
"bofobofo@.yahoo.com" wrote:
> Hello,
> I have been trying to install RS for a while now. I was able to
> install it successfully when I had the SQL server running locally.
> But I need to make to work having the SQL server on a different
> machine.
> Here is my scenario.
> 1. SQL server 2000 is running on a Win2003 Server which is NOT in my
> domain
> 2. Reporting services will run on my machine which is also running
> Win2003 Server
> My options during installation are
> Windows Authenication and
> for the reportServer a Service account (default) option
> At the end of the installation I get a message saying that Reporting
> Services cannot be initalized
> I try to access the localhost/Reports
> and I get the following error message
> =============> The report server cannot open a connection to the report server
> database. A connection to the database is required for all requests
> and processing. (rsReportServerDatabaseUnavailable) Get Online Help
> Login failed for user '(null)'. Reason: Not associated with a trusted
> SQL Server connection.
> =============> I would like to know if the problem is due to the fact that the SQL
> server is running outside my domain ?
> Also I would appreciate what are the best options to choose for the
> account types, I read diff docs and each give a different opinion.
> Thanks
> Bofo
>|||Hi folks,
The primary issue here is that across domains (that are not trusted) the
windows context is not valid. Typically you encounter this in a DMZ
scenario.
Since windows identities are out of the question, you'll need to use SQL
Auth to authenticate between report server and the SQL Server it uses.
What you need are:
1) tell setup to use SQL Auth when creating the database
2) tell RS to use SQL Auth when connecting to the database
For 1), you can use the RSSETUPACCOUNT and RSSETUPPASSWORD command line
flags. Supply an admin level SQL Login.
For 2), on the database dialog in setup, choose Credentials Type SQL Login,
and specify the SQL user the report server is to use to communicate with the
report server. Needless to say, the credentials for 1 and 2 should be
different :-).
Hope that helps,
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"Raj" <Raj@.discussions.microsoft.com> wrote in message
news:12BE2D5D-A6BE-4F0F-BDC9-617BAD05D107@.microsoft.com...
> Hi,
> I am also facing the same problem. pls help us
> Thanks,
> Raj
> "bofobofo@.yahoo.com" wrote:
>> Hello,
>> I have been trying to install RS for a while now. I was able to
>> install it successfully when I had the SQL server running locally.
>> But I need to make to work having the SQL server on a different
>> machine.
>> Here is my scenario.
>> 1. SQL server 2000 is running on a Win2003 Server which is NOT in my
>> domain
>> 2. Reporting services will run on my machine which is also running
>> Win2003 Server
>> My options during installation are
>> Windows Authenication and
>> for the reportServer a Service account (default) option
>> At the end of the installation I get a message saying that Reporting
>> Services cannot be initalized
>> I try to access the localhost/Reports
>> and I get the following error message
>> =============>> The report server cannot open a connection to the report server
>> database. A connection to the database is required for all requests
>> and processing. (rsReportServerDatabaseUnavailable) Get Online Help
>> Login failed for user '(null)'. Reason: Not associated with a trusted
>> SQL Server connection.
>> =============>> I would like to know if the problem is due to the fact that the SQL
>> server is running outside my domain ?
>> Also I would appreciate what are the best options to choose for the
>> account types, I read diff docs and each give a different opinion.
>> Thanks
>> Bofo|||Hello Lukasz
I am tryin to deploy to a remote server which is within a DMZ. I am
using SQL authentication. I have identical usernames and password for a
Windows account and a SQL account.
When I open <server>/reportServer, after passwd auth, i get the list of
all reports and I can click on them and they are functioning.
But when I open <server>/reports, after passwd auth, i get to the Home
screen with the folder containing the reports. But when I click any
report in that page, I get a
'Cant display Page' in that frame.
I am unable to find whats causing the problem.
1. All reports working when I browse them on the server machine.
2. When I try to access http://<server>/reports, I am prompted for a
passwd/user
I enter an username/passwd that has admin priv on Windows and also dba
admin on the SQL server
3. I pass that phase and go on to see the firstpage of the reports
which shows a folder containing all the reports.
I can view and change all links like the properties, security etc.
4. When I clic any report .rdl file, I get the browser page 'action
cancelled' IE message.
The SQL database is using the mixed mode of auth
But I can access all the reports from my machine when i use the
http://<server>/reportserver URL.
Has anyone faced such a problem
any help will be appreciated
Thanks
Bofo

Installation of SQL sp3a on Windows 2003 ent Failover Clustering

Platform: Windows 2003 ent failover cluster SQL Server 2k ent
We did installation of SQL Server 2k ent successfully. We are using Mixed
mode which allow both NT and SQL authentication. We assigned sa password. We
are able to start/stop/start SQL servrices. We are able to failover to
another node on SQL server. Right after completed SQL Server 2k ent
installation, we started to apply SP3a. But we got error in middle of serivce
pack: Setup was unable to verify the state of the server for an upgrade.
Verify the server is able to start and that you provide a valid sa password
and restart setup. We followed the instruction on article ID 330022 and
readme come with CD but it still doesn't work.
I also referenced the article http://support.microsoft.com/?id=814844 but
they are not really applied to our case. Our platform is on WINDOWS 2003.
We are implementing Failover Clustering. Our MDAC is 2.8 version above. We
didn't have any problem to install sql sp3a on any other win2k or win2k3 ent
platform. Only this time is Windows 2003 ent FAILOVER CLUSTERING.
Look at
PRB: Installation of a named instance of SQL Server 2000 virtual server on a
Windows 2003-based cluster fails
http://support.microsoft.com/default...b;en-us;815431
The aliases have to stay in place until SP3a is complete.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Maggie" <Maggie@.discussions.microsoft.com> wrote in message
news:4CDB4730-44F5-4EFC-9F5F-030CAF9A9101@.microsoft.com...
> Platform: Windows 2003 ent failover cluster SQL Server 2k ent
> We did installation of SQL Server 2k ent successfully. We are using Mixed
> mode which allow both NT and SQL authentication. We assigned sa password.
We
> are able to start/stop/start SQL servrices. We are able to failover to
> another node on SQL server. Right after completed SQL Server 2k ent
> installation, we started to apply SP3a. But we got error in middle of
serivce
> pack: Setup was unable to verify the state of the server for an upgrade.
> Verify the server is able to start and that you provide a valid sa
password
> and restart setup. We followed the instruction on article ID 330022 and
> readme come with CD but it still doesn't work.
> I also referenced the article http://support.microsoft.com/?id=814844 but
> they are not really applied to our case. Our platform is on WINDOWS 2003.
> We are implementing Failover Clustering. Our MDAC is 2.8 version above.
We
> didn't have any problem to install sql sp3a on any other win2k or win2k3
ent
> platform. Only this time is Windows 2003 ent FAILOVER CLUSTERING.
>

Installation Error on MSDE

I am trying to install MSDE on a Win2K machine. The installation appears to go successfully, but when the Sql Server Service Manager tries to start, I get the error "The specified service does not exist as an installed service". Sure enough, when I go to the servcies, the MSSQL service is not in the list. I have tried to install twice with the same results. I was thinking about self registering the service, but I do not know what service is causing the problem. Anyone can think of anything?Read the sqlstp.log file - this should give you some information as to why it failed.|||Thanks, I forgot about the log file.|||Check it out and reply back.|||I did a search for the file and it was not created. Any other ideas?|||Check Services applet and see if you have a named instance-based service. I may be wrong but I think that's the default for MSDE.|||When you mentioned that the installation appeared to go successfully - what feedback did the process give you ?|||The process goes throguh the install and then prompts to reboot the computer. I do that and a message comes up registery services, that is when the error first appears. I am not using a named instance, so if I am not mistaken the instace then comes from the local computer name. THe computers name is "server" (unique, huh?).|||Do you see msde in the control panel under Add/Remove programs ?|||No, but we do have a Microsoft Sql Server folder created under Program Files.|||Does this folder exist due to the installation process or do you have sql server installed ?|||This computer does not have Sql Server installed|||Look for sqlsp/sqlstp/setup log files in your \winnt directory. Also, see if an errorlog exists under the sql server directory.|||Did not find any of these log files. Could they be in the System32 folder?|||Enable verbose logging when you install.|||Also, make sure that your server service is started before you install.