Installation Error: 2012

Friday, March 30, 2012

Installing Northwind

Greetings.
I just installed MSDE 2000A
How can I install northwind database on it ?
I looked up on the net and it asks you to install vs2003 version of MSDE
So do I have to del this and install the other MSDE ?
Coz I did run the ConfigSamples.exe from my VS 2003 sdk directory, but it
did not install northwind database for me.
Thanks
Hemang
http://www.microsoft.com/downloads/d...displaylang=en
should help.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Hemang Shah" <hemang@.hemang.net> wrote in message
news:CfGdnTTggswyXX_cRVn-qg@.rogers.com...
> Greetings.
> I just installed MSDE 2000A
> How can I install northwind database on it ?
> I looked up on the net and it asks you to install vs2003 version of MSDE
> So do I have to del this and install the other MSDE ?
> Coz I did run the ConfigSamples.exe from my VS 2003 sdk directory, but it
> did not install northwind database for me.
> Thanks
> Hemang
>

Installing new performance dashboard for SQL Server 2005 SP2

Hi All,
I tried to install the new performance dashboards on 2005 sp2 on
windows 2003 and received the following error messages.
Has anyone seen these before? I know it is quite new...
Thanks
Peter
Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
'object_schema_name' is not a recognized built-in function name.
Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
Incorrect syntax near the keyword 'as'.
Msg 15151, Level 16, State 1, Line 1
Cannot find the object 'usp_GetPageDetails', because it does not exist
or you do not have permission.Did you run the sql script that came with the download?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Peter Nolan" <peter@.peternolan.com> wrote in message
news:1177505070.696147.173040@.n35g2000prd.googlegroups.com...
> Hi All,
> I tried to install the new performance dashboards on 2005 sp2 on
> windows 2003 and received the following error messages.
> Has anyone seen these before? I know it is quite new...
> Thanks
> Peter
>
> Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
> 'object_schema_name' is not a recognized built-in function name.
> Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
> Incorrect syntax near the keyword 'as'.
> Msg 15151, Level 16, State 1, Line 1
> Cannot find the object 'usp_GetPageDetails', because it does not exist
> or you do not have permission.
>|||The fact that you get an error about 'object_schema_name' suggests SP2 is
not installed on the instance since this is a new function added by SP2. Try
(re)applying SP2 to the instance to see if that resolves the issue.
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
http://sqlblogcasts.com/blogs/sqldbatips
"Peter Nolan" <peter@.peternolan.com> wrote in message
news:1177505070.696147.173040@.n35g2000prd.googlegroups.com...
> Hi All,
> I tried to install the new performance dashboards on 2005 sp2 on
> windows 2003 and received the following error messages.
> Has anyone seen these before? I know it is quite new...
> Thanks
> Peter
>
> Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
> 'object_schema_name' is not a recognized built-in function name.
> Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
> Incorrect syntax near the keyword 'as'.
> Msg 15151, Level 16, State 1, Line 1
> Cannot find the object 'usp_GetPageDetails', because it does not exist
> or you do not have permission.
>|||
> GUEST wrote:
> Hi All,
> I tried to install the new performance dashboards on 2005 sp2 on
> windows 2003 and received the following error messages.
> Has anyone seen these before? I know it is quite new...
> Thanks
> Peter
>
> Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
> 'object_schema_name' is not a recognized built-in function name.
> Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
> Incorrect syntax near the keyword 'as'.
> Msg 15151, Level 16, State 1, Line 1
> Cannot find the object 'usp_GetPageDetails', because it does not
exist
> or you do not have permission.
I am getting the same error.
What is the fix for this if the server is on sp2?|||On May 22, 6:54 pm, stacey.do...@.shawinc-dot-com.no-spam.invalid
(sdoran) wrote:
>
> exist
> I am getting the same error.
> What is the fix for this if the server is on sp2?
Same error here - SQL 2005 SP2 Latest hotfixes, etc. Any fix for
this?sql

Installing new performance dashboard for SQL Server 2005 SP2

Hi All,
I tried to install the new performance dashboards on 2005 sp2 on
windows 2003 and received the following error messages.
Has anyone seen these before? I know it is quite new...
Thanks
Peter
Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
'object_schema_name' is not a recognized built-in function name.
Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
Incorrect syntax near the keyword 'as'.
Msg 15151, Level 16, State 1, Line 1
Cannot find the object 'usp_GetPageDetails', because it does not exist
or you do not have permission.Did you run the sql script that came with the download?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Peter Nolan" <peter@.peternolan.com> wrote in message
news:1177505070.696147.173040@.n35g2000prd.googlegroups.com...
> Hi All,
> I tried to install the new performance dashboards on 2005 sp2 on
> windows 2003 and received the following error messages.
> Has anyone seen these before? I know it is quite new...
> Thanks
> Peter
>
> Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
> 'object_schema_name' is not a recognized built-in function name.
> Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
> Incorrect syntax near the keyword 'as'.
> Msg 15151, Level 16, State 1, Line 1
> Cannot find the object 'usp_GetPageDetails', because it does not exist
> or you do not have permission.
>|||The fact that you get an error about 'object_schema_name' suggests SP2 is
not installed on the instance since this is a new function added by SP2. Try
(re)applying SP2 to the instance to see if that resolves the issue.
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
http://sqlblogcasts.com/blogs/sqldbatips
"Peter Nolan" <peter@.peternolan.com> wrote in message
news:1177505070.696147.173040@.n35g2000prd.googlegroups.com...
> Hi All,
> I tried to install the new performance dashboards on 2005 sp2 on
> windows 2003 and received the following error messages.
> Has anyone seen these before? I know it is quite new...
> Thanks
> Peter
>
> Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
> 'object_schema_name' is not a recognized built-in function name.
> Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
> Incorrect syntax near the keyword 'as'.
> Msg 15151, Level 16, State 1, Line 1
> Cannot find the object 'usp_GetPageDetails', because it does not exist
> or you do not have permission.
>|||> GUEST wrote
> Hi All
> I tried to install the new performance dashboards on 2005 sp2 o
> windows 2003 and received the following error messages
>
> Has anyone seen these before? I know it is quite new..
>
> Thank
>
> Pete
>
>
> Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 2
> 'object_schema_name' is not a recognized built-in function name
> Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 4
> Incorrect syntax near the keyword 'as'
> Msg 15151, Level 16, State 1, Line
> Cannot find the object 'usp_GetPageDetails', because it does no
exis
> or you do not have permission
I am getting the same error
What is the fix for this if the server is on sp2|||On May 22, 6:54 pm, stacey.do...@.shawinc-dot-com.no-spam.invalid
(sdoran) wrote:
> > GUEST wrote:
> > Hi All,
> > I tried to install the new performance dashboards on 2005 sp2 on
> > windows 2003 and received the following error messages.
> >
> > Has anyone seen these before? I know it is quite new...
> >
> > Thanks
> >
> > Peter
> >
> >
> > Msg 195, Level 15, State 10, Procedureusp_GetPageDetails, Line 27
> > 'object_schema_name' is not a recognized built-in function name.
> > Msg 156, Level 15, State 1, Procedureusp_GetPageDetails, Line 42
> > Incorrect syntax near the keyword 'as'.
> > Msg 15151, Level 16, State 1, Line 1
> > Cannot find the object 'usp_GetPageDetails', because it does not
> exist
> > or you do not have permission.
> I am getting the same error.
> What is the fix for this if the server is on sp2?
Same error here - SQL 2005 SP2 Latest hotfixes, etc. Any fix for
this?

Installing named instance with sample.msi

I need to install a named instance of the Desktop Engine, so I followed the directions at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_74qd.asp
which has instructions on using Orca to modify sample.msi. I also followed the instructions found at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_8yeq.asp
on how to edit the msi file to create a named instance.
YET, when used, this altered msi installs a DEFAULT instance.
Am I missing something? If so, what?

Thanks for any help,
Allan Sorenson
Crossroads technologyOriginally posted by B1ueboy
I need to install a named instance of the Desktop Engine, so I followed the directions at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_74qd.asp
which has instructions on using Orca to modify sample.msi. I also followed the instructions found at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_8yeq.asp
on how to edit the msi file to create a named instance.
YET, when used, this altered msi installs a DEFAULT instance.
Am I missing something? If so, what?

Thanks for any help,
Allan Sorenson
Crossroads technology

A little more info on the last edit:
Using Orca I added the row named 'SqlInstanceName' with the desired instance name as the value to the 'Property' table.

Installing My Reports

Hello All,
I have designed some Reports in RS, now i want to install it on
Production Machine (Web Server) but issue is that, production machine
doesnt have RS. Can it be possible to make any setup or package which
install required dll's to production machine without installing RS?
Please help me how to solve this.
Regards
RajeshRS is required if you wish to use RS to retrieve your report data as well as
provide report management capabilities. If you just want to display a
report on your web page you should look into using the new Report Viewer
controls that shipped with VS2005.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Raj" <kapse_rajesh@.rediffmail.com> wrote in message
news:1134627577.603210.61580@.g49g2000cwa.googlegroups.com...
> Hello All,
> I have designed some Reports in RS, now i want to install it on
> Production Machine (Web Server) but issue is that, production machine
> doesnt have RS. Can it be possible to make any setup or package which
> install required dll's to production machine without installing RS?
> Please help me how to solve this.
>
> Regards
> Rajesh
>|||Daniel,
Thanks for Instant FeedBack, but problem is that I dont have VS2005 and
i just want to display reports on web page, can it be possible that i
use RS's dll or supporting files and install it on Production Machine
and run the reports?|||No, it is not possible. You need to install RS if you want to process the
reports. The only other option you have is the one I mentioned, using the
VS controls in 2005.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Raj" <kapse_rajesh@.rediffmail.com> wrote in message
news:1134714178.861590.319450@.f14g2000cwb.googlegroups.com...
> Daniel,
> Thanks for Instant FeedBack, but problem is that I dont have VS2005 and
> i just want to display reports on web page, can it be possible that i
> use RS's dll or supporting files and install it on Production Machine
> and run the reports?
>

Installing multiple instances of MSDE2000

Hello
I installed 2 instances of msde , installation passed ok but noone can
connect to my machine , i portscanned host machine and port 1443 is not
opened ,can it be becaus i installed it on a VmWare console, any help is
apriciated.
PS I didn't forget to set DISABLENETWORKPROTOCOLS=0.
Thx in advance
__________
TomislavFist you need to find out what the instance names are and whether one is a
default instance (both are probably named instances as no-one is listening
to port 1433).
Use either server network utility, svrnetcn.exe, or check the services in
the machine. After you know the instance names, you connect using:
machinename\instancename
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Tomislav Zemljak" <tomislav.zemljak@.*maknime*bj.tel.hr> wrote in message
news:c3rn9s$ksm$1@.sunce.iskon.hr...
> Hello
> I installed 2 instances of msde , installation passed ok but noone can
> connect to my machine , i portscanned host machine and port 1443 is not
> opened ,can it be becaus i installed it on a VmWare console, any help is
> apriciated.
> PS I didn't forget to set DISABLENETWORKPROTOCOLS=0.
> Thx in advance
> __________
> Tomislav
>|||"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote:
> Fist you need to find out what the instance names are and whether one is a
> default instance (both are probably named instances as no-one is listening
> to port 1433).
One is default instance , other is named "second"
> Use either server network utility, svrnetcn.exe, or check the services in
> the machine. After you know the instance names, you connect using:
> machinename\instancename
That didn't solve it ... both instances are started and appear to be
working on host machine , remote users still cant connect and portscann
shows that port 1443 isn't open .Thx for trying thou.|||You don't say whether these instances are both named or one is a default def
ault instance. You cannot have two
default instances. My guess is that you have two names instance. A named ins
tance does NOT listen on 1433.
Please follow my direction closely to find out whether these are default or
named instances and the name of
the instance.
This is what I write in my earlier post:

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Tomislav Zemljak" <tomislav.zemljak@.*maknime*bj.tel.hr> wrote in message news:c3s99i$4ge$1
@.sunce.iskon.hr...
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote:
> One is default instance , other is named "second"
> That didn't solve it ... both instances are started and appear to be
> working on host machine , remote users still cant connect and portscann
> shows that port 1443 isn't open .Thx for trying thou.
>|||"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote:
> You don't say whether these instances are both named or one is a default
default instance.
As i already wrote (look below) one is default instance , other is named
"second".
I "fixed" the problem by reinstalling both instances , now they work , thx
for tryng to help !
You cannot have two
> default instances. My guess is that you have two names instance. A named
instance does NOT listen on 1433.
> Please follow my direction closely to find out whether these are default
or named instances and the name of
> the instance.
> This is what I write in my earlier post:
>
in
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Tomislav Zemljak" <tomislav.zemljak@.*maknime*bj.tel.hr> wrote in message
news:c3s99i$4ge$1@.sunce.iskon.hr...
wrote:
is a
listening
in
>

Installing Multiple Instances of ASP.NET Application Services on ONE SQL Server Database

Hi,

I am trying to install multiple application services on 1 sql server database. Is this possible? I do not know how to install anything but the default application services settings for the membership, roles, etc.

Please help if you can.

Thanks,

Ezeibe

Seems not possilble in 1 databases, but should be able in different databases on 1 SQL instance. Just use aspnet_regsql.exe to create schema for membership in serveral database, and then connect to 1 database respectively in your applications.

Installing Multiple Instances Design Question

I have 4 small small SQL 2000 databases that I need to consolidate to a
single machine.
The data is minimal maybe 100 GB total with an expection of some
moderate growth.
The box will be configured with a raid 5.
Question:
Should the O.S and each instance be on its own partition?
Or would it be better to have the instances on one partition and
dedicate a partition for the data and log files?
Any inforomation would be greatly appreciated.
Thanks,
Hulicat
I would investigate if the four database could reside in the same server.
(Perhaps because of security or other needs, that is not possible.)
If you have to have 'separate' servers, install multiple instances of SQL
Server on the same box. All instances will use the same OS -the only thing
being 'duplicated' is SQL Server instances (code, settings, etc.)
Drives.
Best choice: RAID 1 for OS and SQL installables (2 drives). RAID 10 for data
files (4 drives). RAID 10 for Logs files (4 drives). For optimal
performance, each instance 'should' have its own drives for data and logs.
I wouldn't recommend trying to make everything work with a single RAID 5.
That would be painful.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Hulicat" <dennis_A_white@.yahoo.com> wrote in message
news:1162403869.339729.318940@.e64g2000cwd.googlegr oups.com...
>I have 4 small small SQL 2000 databases that I need to consolidate to a
> single machine.
> The data is minimal maybe 100 GB total with an expection of some
> moderate growth.
> The box will be configured with a raid 5.
> Question:
> Should the O.S and each instance be on its own partition?
> Or would it be better to have the instances on one partition and
> dedicate a partition for the data and log files?
> Any inforomation would be greatly appreciated.
> Thanks,
> Hulicat
>
|||~Thanks~
Arnie Rowland wrote:[vbcol=seagreen]
> I would investigate if the four database could reside in the same server.
> (Perhaps because of security or other needs, that is not possible.)
> If you have to have 'separate' servers, install multiple instances of SQL
> Server on the same box. All instances will use the same OS -the only thing
> being 'duplicated' is SQL Server instances (code, settings, etc.)
> Drives.
> Best choice: RAID 1 for OS and SQL installables (2 drives). RAID 10 for data
> files (4 drives). RAID 10 for Logs files (4 drives). For optimal
> performance, each instance 'should' have its own drives for data and logs.
> I wouldn't recommend trying to make everything work with a single RAID 5.
> That would be painful.
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to the
> top yourself.
> - H. Norman Schwarzkopf
>
> "Hulicat" <dennis_A_white@.yahoo.com> wrote in message
> news:1162403869.339729.318940@.e64g2000cwd.googlegr oups.com...

Installing Multiple Instances Design Question

I have 4 small small SQL 2000 databases that I need to consolidate to a
single machine.
The data is minimal maybe 100 GB total with an expection of some
moderate growth.
The box will be configured with a raid 5.
Question:
Should the O.S and each instance be on its own partition?
Or would it be better to have the instances on one partition and
dedicate a partition for the data and log files?
Any inforomation would be greatly appreciated.
Thanks,
HulicatI would investigate if the four database could reside in the same server.
(Perhaps because of security or other needs, that is not possible.)
If you have to have 'separate' servers, install multiple instances of SQL
Server on the same box. All instances will use the same OS -the only thing
being 'duplicated' is SQL Server instances (code, settings, etc.)
Drives.
Best choice: RAID 1 for OS and SQL installables (2 drives). RAID 10 for data
files (4 drives). RAID 10 for Logs files (4 drives). For optimal
performance, each instance 'should' have its own drives for data and logs.
I wouldn't recommend trying to make everything work with a single RAID 5.
That would be painful.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Hulicat" <dennis_A_white@.yahoo.com> wrote in message
news:1162403869.339729.318940@.e64g2000cwd.googlegroups.com...
>I have 4 small small SQL 2000 databases that I need to consolidate to a
> single machine.
> The data is minimal maybe 100 GB total with an expection of some
> moderate growth.
> The box will be configured with a raid 5.
> Question:
> Should the O.S and each instance be on its own partition?
> Or would it be better to have the instances on one partition and
> dedicate a partition for the data and log files?
> Any inforomation would be greatly appreciated.
> Thanks,
> Hulicat
>|||~Thanks~
Arnie Rowland wrote:[vbcol=seagreen]
> I would investigate if the four database could reside in the same server.
> (Perhaps because of security or other needs, that is not possible.)
> If you have to have 'separate' servers, install multiple instances of SQL
> Server on the same box. All instances will use the same OS -the only thing
> being 'duplicated' is SQL Server instances (code, settings, etc.)
> Drives.
> Best choice: RAID 1 for OS and SQL installables (2 drives). RAID 10 for da
ta
> files (4 drives). RAID 10 for Logs files (4 drives). For optimal
> performance, each instance 'should' have its own drives for data and logs.
> I wouldn't recommend trying to make everything work with a single RAID 5.
> That would be painful.
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to th
e
> top yourself.
> - H. Norman Schwarzkopf
>
> "Hulicat" <dennis_A_white@.yahoo.com> wrote in message
> news:1162403869.339729.318940@.e64g2000cwd.googlegroups.com...sql

Installing Multiple Instances Design Question

I have 4 small small SQL 2000 databases that I need to consolidate to a
single machine.
The data is minimal maybe 100 GB total with an expection of some
moderate growth.
The box will be configured with a raid 5.
Question:
Should the O.S and each instance be on its own partition?
Or would it be better to have the instances on one partition and
dedicate a partition for the data and log files?
Any inforomation would be greatly appreciated.
Thanks,
HulicatI would investigate if the four database could reside in the same server.
(Perhaps because of security or other needs, that is not possible.)
If you have to have 'separate' servers, install multiple instances of SQL
Server on the same box. All instances will use the same OS -the only thing
being 'duplicated' is SQL Server instances (code, settings, etc.)
Drives.
Best choice: RAID 1 for OS and SQL installables (2 drives). RAID 10 for data
files (4 drives). RAID 10 for Logs files (4 drives). For optimal
performance, each instance 'should' have its own drives for data and logs.
I wouldn't recommend trying to make everything work with a single RAID 5.
That would be painful.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Hulicat" <dennis_A_white@.yahoo.com> wrote in message
news:1162403869.339729.318940@.e64g2000cwd.googlegroups.com...
>I have 4 small small SQL 2000 databases that I need to consolidate to a
> single machine.
> The data is minimal maybe 100 GB total with an expection of some
> moderate growth.
> The box will be configured with a raid 5.
> Question:
> Should the O.S and each instance be on its own partition?
> Or would it be better to have the instances on one partition and
> dedicate a partition for the data and log files?
> Any inforomation would be greatly appreciated.
> Thanks,
> Hulicat
>|||~Thanks~
Arnie Rowland wrote:
> I would investigate if the four database could reside in the same server.
> (Perhaps because of security or other needs, that is not possible.)
> If you have to have 'separate' servers, install multiple instances of SQL
> Server on the same box. All instances will use the same OS -the only thing
> being 'duplicated' is SQL Server instances (code, settings, etc.)
> Drives.
> Best choice: RAID 1 for OS and SQL installables (2 drives). RAID 10 for data
> files (4 drives). RAID 10 for Logs files (4 drives). For optimal
> performance, each instance 'should' have its own drives for data and logs.
> I wouldn't recommend trying to make everything work with a single RAID 5.
> That would be painful.
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to the
> top yourself.
> - H. Norman Schwarzkopf
>
> "Hulicat" <dennis_A_white@.yahoo.com> wrote in message
> news:1162403869.339729.318940@.e64g2000cwd.googlegroups.com...
> >I have 4 small small SQL 2000 databases that I need to consolidate to a
> > single machine.
> > The data is minimal maybe 100 GB total with an expection of some
> > moderate growth.
> >
> > The box will be configured with a raid 5.
> >
> > Question:
> > Should the O.S and each instance be on its own partition?
> > Or would it be better to have the instances on one partition and
> > dedicate a partition for the data and log files?
> >
> > Any inforomation would be greatly appreciated.
> >
> > Thanks,
> > Hulicat
> >

Installing MSSQL 2005 SP2 deleted all documents in my documents

hi,
Installing MSSQL 2005 SP2 deleted all documents in my documents. i'm
running it on XP SP2.
anybody run into this? restoring OS does not bring back the files.
any help would be appreciated.
Doron, shalom
I have just installed SP2 on XP SP2 and it worked just fine. What is the
path of your SQL Server instalaltion?
<doron.almog@.gmail.com> wrote in message
news:1172531419.194567.175800@.h3g2000cwc.googlegro ups.com...
> hi,
> Installing MSSQL 2005 SP2 deleted all documents in my documents. i'm
> running it on XP SP2.
> anybody run into this? restoring OS does not bring back the files.
> any help would be appreciated.
>

Installing MSSQL 2005 SP2 deleted all documents in my documents

hi,
Installing MSSQL 2005 SP2 deleted all documents in my documents. i'm
running it on XP SP2.
anybody run into this? restoring OS does not bring back the files.
any help would be appreciated.Doron, shalom
I have just installed SP2 on XP SP2 and it worked just fine. What is the
path of your SQL Server instalaltion?
<doron.almog@.gmail.com> wrote in message
news:1172531419.194567.175800@.h3g2000cwc.googlegroups.com...
> hi,
> Installing MSSQL 2005 SP2 deleted all documents in my documents. i'm
> running it on XP SP2.
> anybody run into this? restoring OS does not bring back the files.
> any help would be appreciated.
>

Installing MSSQL 2005 SP2 deleted all documents in my documents

hi,
Installing MSSQL 2005 SP2 deleted all documents in my documents. i'm
running it on XP SP2.
anybody run into this? restoring OS does not bring back the files.
any help would be appreciated.Doron, shalom
I have just installed SP2 on XP SP2 and it worked just fine. What is the
path of your SQL Server instalaltion?
<doron.almog@.gmail.com> wrote in message
news:1172531419.194567.175800@.h3g2000cwc.googlegroups.com...
> hi,
> Installing MSSQL 2005 SP2 deleted all documents in my documents. i'm
> running it on XP SP2.
> anybody run into this? restoring OS does not bring back the files.
> any help would be appreciated.
>

Installing MSDTC Resource after installing SQL Server 2000 cluster

Is it possible to install and configure the MSDTC resource in a SQL Server 2000 cluster after SQL is installed and running?

When I recently went through a rebuild of my cluster, I forgot to install the resource before installing SQL Server. Now, if I install and bring online the MSDTC resource the SQL disk groups will not fail over correctly. The SQL Server resource will not come online.

Thanks in advance for any help. I would really like to avoid rebuilding again.

Andy

I am not an expert on clusters but you might want to check out the following article

http://support.microsoft.com/kb/294209/en-us

Michelle

sql

Installing MSDE200A on Windows 2003

I have done a freresh install of Windows 2003, patches and now trying to
install MSDE RelA.
I use the command line "SETUP SAPWD="Password"" and it appears to install
successfully. I restart. When I try to install an application that uses
MSDE it claims there is no database.
I do a "netstat -an" and do not see anything listening on port 1433. I've
uninstalled and reinstalled with no change. What am I doing wrong?
Hi
In Control Panel > Services, Is the MSDE service there and running?
Regards
Mike
"Brian" wrote:

> I have done a freresh install of Windows 2003, patches and now trying to
> install MSDE RelA.
> I use the command line "SETUP SAPWD="Password"" and it appears to install
> successfully. I restart. When I try to install an application that uses
> MSDE it claims there is no database.
> I do a "netstat -an" and do not see anything listening on port 1433. I've
> uninstalled and reinstalled with no change. What am I doing wrong?
|||I do "Net Start" and MSSQLSERVER is listed. It is also displayed in the gui
as automatic and running.
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> In Control Panel > Services, Is the MSDE service there and running?
> Regards
> Mike
> "Brian" wrote:
|||MSDE installs by default with Windows Security only. Setting an sa password
doesn't influence that. You also have to add SECURITYMODE=SQL to your setup
script if you want to use SQL Security.
You can change an MSDE installation to use SQL Security after it has been
installed by changing the registry key
HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\Lo ginMode to 2.
See:
http://support.microsoft.com/default...b;en-us;285097
for extensive info.
Jacco Schalkwijk
SQL Server MVP
"Brian" <Brian@.discussions.microsoft.com> wrote in message
news:7B17BA79-2F77-47D2-AAB1-99C3495885EC@.microsoft.com...
>I have done a freresh install of Windows 2003, patches and now trying to
> install MSDE RelA.
> I use the command line "SETUP SAPWD="Password"" and it appears to install
> successfully. I restart. When I try to install an application that uses
> MSDE it claims there is no database.
> I do a "netstat -an" and do not see anything listening on port 1433. I've
> uninstalled and reinstalled with no change. What am I doing wrong?
|||Brian,
By default MSDE RelA installs with TCP protocol turned off for security
reasons. Use svrnetcn.exe in the Binn folder to enable protocols and
configure ports.
Ron Allen
"Brian" <Brian@.discussions.microsoft.com> wrote in message
news:7B17BA79-2F77-47D2-AAB1-99C3495885EC@.microsoft.com...
>I have done a freresh install of Windows 2003, patches and now trying to
> install MSDE RelA.
> I use the command line "SETUP SAPWD="Password"" and it appears to install
> successfully. I restart. When I try to install an application that uses
> MSDE it claims there is no database.
> I do a "netstat -an" and do not see anything listening on port 1433. I've
> uninstalled and reinstalled with no change. What am I doing wrong?

Installing MSDE2000 sp3 - help

Hiya folks,
I'm a newbie at this, so forgive the ignorance that I may display!
I have installed a software package on my system that installs MSDE through
merge modules contained in its MSI. I have several workstations that
connect. Unfortunately, with SP2 coming down the pipe for windows xp, i
have to do lots of fancy stuff to make sure they still connect (it uses
named pipes tcp/ip). The solution according to microsoft is to install SP3
for sql...i've downloaded the MSDE version of the upgrade, and attempted to
install for several hours with no luck.
First, it said i required a strong password, which i supplised in the
setup.ini:
[options]
sapassword="mypassword"
Things started to load, and then the installer quit. Confused, I started it
again. Now the installer is giving me '
the instance name specified is invalid'
Ok, so i go back to the setup.ini and add a line
[options]
sapassword="mypassword"
instancename="liveddm"
and STILL, i get the invalid instance name error message. No matter what I
seem to try, it is telling me i have an invalid instance name; if i use
enterprise manager, i can clearly see my instance and browse the attached
database. I've also tried instancename="computername\liveddm" with no luck.
Any help would be greatly appreciated.
Thanks!
Sheldon
sheldon@.REMOVETHISthedoctorcompany.com
Sheldon Purkiss wrote:
> Hiya folks,
> I'm a newbie at this, so forgive the ignorance that I may display!
> I have installed a software package on my system that installs MSDE through
> merge modules contained in its MSI. I have several workstations that
> connect. Unfortunately, with SP2 coming down the pipe for windows xp, i
> have to do lots of fancy stuff to make sure they still connect (it uses
> named pipes tcp/ip). The solution according to microsoft is to install SP3
> for sql...i've downloaded the MSDE version of the upgrade, and attempted to
> install for several hours with no luck.
> First, it said i required a strong password, which i supplised in the
> setup.ini:
> [options]
> sapassword="mypassword"
> Things started to load, and then the installer quit. Confused, I started it
> again. Now the installer is giving me '
> the instance name specified is invalid'
> Ok, so i go back to the setup.ini and add a line
> [options]
> sapassword="mypassword"
> instancename="liveddm"
> and STILL, i get the invalid instance name error message. No matter what I
> seem to try, it is telling me i have an invalid instance name; if i use
> enterprise manager, i can clearly see my instance and browse the attached
> database. I've also tried instancename="computername\liveddm" with no luck.
> Any help would be greatly appreciated.
> Thanks!
> Sheldon
> sheldon@.REMOVETHISthedoctorcompany.com
>
>
>
Hi Sheldon
Unfortunately, I believe that if your software vendor has installed MSDE
using merge modules from within their own MSI they will need to supply
you with the patch package themselves.
See http://www.microsoft.com/sql/downloads/2000/sp3.asp
Tony

Installing MSDE2000

Hi,
I've been trying to follow Microsoft's instructions on installing MSDE2000 for Visual Studio. I do instancename=VSDOTNET SECURITY=SQL SAPWD=XXXX and all that. When I reboot, I notice that I have no services in the SQL Service Manager, nor can it find my computername.

Anybody know why this is?This is on Windows XP professional SP1.

Installing MSDE??

Ok I installed the MSDE and after following the steps the last message box says to go to the control panel and install and configure the components.

I'm not sure what to do once I'm in the control panel.

Thank you.Somewhere along the way did you try to install MSDE but were unsuccessful? What is the exact wording of the message you are receiving?

Terri|||I am also having a problem with the installation of MSDE. About 2/3's the way through the installation the process froze. I cannot uninstall or re-install. The message I am receiving is that the installation was tampered with and needs to be uninstalled and re-installed. When I go to My Computer, Install/Uninstall Software, SQL Server is not listed.

Any suggestions?|||Well, searching the SQL Server and MSDE Forum here for posts from others who have experienced the same thing is a good start. And then starting a new thread with your own particular situation with the exact error messages would be the next step.

Terri|||i have the same probleme.
in my case it was an error of directory\subdirectory

c:\sql2ksp3\MSDE>

don't forget the MSDE subdirectory !! ;)

then type the command : setup SAPWD=xxxx SecurityMode=SQL

i hope it can help you.sql

installing MSDE?

Hello!

In the setup of MSDE I need to edit the ini file. Well when I do it looks as if the installation was complete, but there is no MSDE services application and the actual services are on the box(I can start/stop them). Could someone show me what the edited ini file needs to have to be sure the install is complete? Or maybe there's something else that I need to do and just don't know about.

Many thanks.Not sure I understand what the problem is.

Is it MSDE 1.0 or MSDE 2000?

Is the OS NT or Win2k or 9x/ME?

Can you see if the MSSQLSERVER service is running?
You can check this easily by running sqlmangr.exe

installing MSDE without sa password

Hello friends,
I am a beginer installing MSDE in a W98 system. The setup file request me a
secure password "sa".
I don't know what must I do now?
How can I define a secure password in W98?
Thanks a lot.
Lorka
On Tue, 15 Jun 2004 16:58:27 +0200, Lorka wrote:

>Hello friends,
>I am a beginer installing MSDE in a W98 system. The setup file request me a
>secure password "sa".
>I don't know what must I do now?
>How can I define a secure password in W98?
>Thanks a lot.
>Lorka
Hi Lorka,
Make up a password that's hard to guess (*). Write it down somewhere safe,
unless you have perfect recall. Never give it out to anyone.
(*) A hard to guess password uses both upper- and lowercase letters, at
least one digit and at least one special character. Of coourse, there is
no relation between the password and your username, your real name or the
names of anyone you love. Steer clear from English words as well (or if
you do include them, make sure you misspell them - as in pas5w0Rd)
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)
|||I understand the problem - Win98 has no passwords. You must install MSDE and the use the "osql.exe" utility via DOS window commands. Look this up in the MS SQL Server 2000 Books Online (Jan 2004 version is the most recent) Its free and must be installed o
n your system. Look for sp_password as the stored procedure to set the sa password under osql.
Good luck.
Mark Ferguson
"Lorka" wrote:

> Hello friends,
> I am a beginer installing MSDE in a W98 system. The setup file request me a
> secure password "sa".
> I don't know what must I do now?
> How can I define a secure password in W98?
> Thanks a lot.
> Lorka
>
>
|||PS: Although Win98 has no passwords, SQL Server uses SQL or Mixed Mode security under Win98. Look for their descriptions in the SQL Server Books Online.
For Win98, you will have to define a user name and password in SQL Server for each user, and assign them to a SQL Server Role. Thereafter, when they attempt to access SQL Server, they will have to log into it using these names and passwords. by default on
ly the "sa" username is defined and it has no default password (i think). So the reaosn for the strong password at install time is to avoid people from just nonchalantly logging in under the "sa" user name. If anyone else knows this to be wrong, please re
ply with corrections.
Seems to me that Win98 may pose another problem. I dont think it has named pipes - an alternative method to TCP/IP by which SQLServer and applications communicate - but I am not sure about this. Again, check the SQL Server Books Online.
Mark Ferguson

Installing MSDE with VB application

Does anyone have any experience or knowledge what would be best way of installing msde with vb application
I created vb app with msde database , right now app uses sql server, iam planning to move sql database to msde and distribute that with vb app. What would be best approach for distributing and installing those files? Does vb package deployment will do the trick or I should acuire some professional setup program ??
Thanks
RobertRefer to MS website about recent updations on MSDE.

Installing MSDE with a different instance name

Hi All,
I'm trying (and have been for ages) to install a MSDE server with adifferent instance name than the default. Im setting theinstancename when using the setup.exe file and all seems to installfine, but when I then restart my system the SQL icon appears in thesystem tray but the white circle is completely empty. It saysthat it is not connected.
If i install with the default instance name then all seems to work fine.
Does anyone know what I am doing wrong and what I can do to fix this problem?
Thanks in advance for any help!
The text below is from the BOL (books online). Hope this helps.
(When you install SQL Server 2000 on a computer with no existing installations of SQL Server, Setup specifies the installation of a default instance. However, you can choose to install SQL Server 2000 as a named instance instead by clearing the Default option in the Instance Name dialog box.)

Installing MSDE using VS.NET

Hi all,
I want to create setup/Installer project in Visual
Studio.NET 2003 that will detect MSDE. If MSDE already
installed then setup will not install MSDE , If not then
setup will install MSDE.
So please tell me have will i installed MSDE
using /Installer project in Visual Studio.NET 2003.
Thx in Advance
Amit
Hi Amit,
You can download MSDE toolkit, that is a plug-in to Microsoft Visual Studio
that automates the process of creating an integrated package with both the
application and the MSDE database, from
http://www.microsoft.com/downloads/d...403-c4ba-4d98-
bb0b-2c9d6414071f&DisplayLang=en
This toolkit will help you in customizing and designing a setup for MSDE
that can be integrated with your application.
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Thank you ashish great link. I installed on my system
working fine

.
My next question is how i can add my database file in MSDE
using same VS.Net installer.
Amit

>--Original Message--
>Hi Amit,
>You can download MSDE toolkit, that is a plug-in to
Microsoft Visual Studio
>that automates the process of creating an integrated
package with both the
>application and the MSDE database, from
>http://www.microsoft.com/downloads/details.aspx?
FamilyID=6e9a7403-c4ba-4d98-
>bb0b-2c9d6414071f&DisplayLang=en
>
>This toolkit will help you in customizing and designing a
setup for MSDE
>that can be integrated with your application.
>HTH
>Ashish
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>.
>
|||Hi Amit,
You can go through the following technical article that helps in designing
classes for MSDE installation.
http://msdn.microsoft.com/library/de...us/dnmsde/html
/msdedepl.asp
According to that you can use the "AfterInstall" event to add the database
to the MSDE server.
According to my understanding, you will have to include the database files
in your setup and extract it to the desired location, and then execute the
"attachdb" function or the sp_attach_db stored procedure from the object.
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi Ashish,
Thank you my installation nightmare is over.
But i have still one problem.
I am using trusted connection to connect my web site with
MSDE database.
In command line i use
osql -S myserver\Instancename -E connected successfully.
while connecting with my website it will give following
error.
"Login failed for user "servername\ASPNET"
i also use SQL connection in which i provide user id and
password but the result is same an error occurs.
"Login failed for user "sa". Reason: Not associated with
trusted SQL server Connection"
please tell me where i am wrong.
Thanks
Amit

>--Original Message--
>Hi Amit,
>You can go through the following technical article that
helps in designing
>classes for MSDE installation.
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/dnmsde/html
>/msdedepl.asp
>
>According to that you can use the "AfterInstall" event to
add the database
>to the MSDE server.
>According to my understanding, you will have to include
the database files
>in your setup and extract it to the desired location, and
then execute the
>"attachdb" function or the sp_attach_db stored procedure
from the object.
>HTH
>Ashish
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>.
>
|||Hi Amit,
The user servername\ASPNET is the default user name that the ASP.NET process
runs as within the operating system. It is configured in the machine.config
file. By default, it has no access to your databases.
You have three basic options:
1. Grant appropriate database access to the ASPNET user.
2. Use impersonation on the site - configured in your web.config file (ie
impersonate the windows user that the end user is connecting as - not great
for public sites of any type)
3. Have your application log on as a specific user and grant that user
access to the database.
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Amit" <anonymous@.discussions.microsoft.com> wrote in message
news:213c01c42794$69f54020$a101280a@.phx.gbl...[vbcol=seagreen]
> Hi Ashish,
> Thank you my installation nightmare is over.
> But i have still one problem.
> I am using trusted connection to connect my web site with
> MSDE database.
> In command line i use
> osql -S myserver\Instancename -E connected successfully.
> while connecting with my website it will give following
> error.
> "Login failed for user "servername\ASPNET"
> i also use SQL connection in which i provide user id and
> password but the result is same an error occurs.
> "Login failed for user "sa". Reason: Not associated with
> trusted SQL server Connection"
>
> please tell me where i am wrong.
>
> Thanks
> Amit
>
> helps in designing
> url=/library/en-us/dnmsde/html
> add the database
> the database files
> then execute the
> from the object.
> confers no rights.
sql

Installing MSDE SQL 2000 SP4

I was working on a install for MSDE SQL SERVER 2000 when I noticed that there
was a more recent version available. I have not yet installed and wanted to
kow if the Service Pack 4 for Microsoft SQL Server 2000 - Desktop Engine
(MSDE 2000) included the Microsoft SQL Server 2000 - Database Engine
Components and the Service Pack 4 for Microsoft SQL Server 2000 - Analysis
Services Components in it's install or do I have to install them after I set
up the engine for the first time. Let me re-iterate that I am not upgrading
an instance rather I am trying to install an instance with the SP4 updates,
hoping that I get all of the tools that I can in one shot.
ANDREA,
Thank you for your answer. I have another question. I am sending these
files across a network and trying to automate the installation. I know how
to automate the MSDE install after I have extracted the files from the
SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE, but is there a way to use command
lines to extract silently or maybe even feed it a path to extract to? That
way I only have to worry about one file?
ANdrew
"Andrea Montanari" wrote:

> hi,
> Thunda wrote:
> you can directly go with the sp4 version... it can both install fresh sp
> level MSDE instances as long as upgrade existing pre-sp4 instances..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
> -- remove DMO to reply
>
>

Installing MSDE SP3 to Win98 causes an error.

Ok I have an MSI file that installs an instance of the MSDE. I recently updated my install to used the SP3 MSMs of the MSDE. I have the installation working correctly on XP. However it fails rather quickly on install to Win98. I will paste the log file of the failure below.

To create the installation I used the VisualStudio installer. Afte the installtion I use ORCA and edit the MSI with the following values in the property table.

ProductLanguage = 1033
SqlBlankPwd = 1
SqlSecurityMode = SQL

No special actions are being used by my installer. Yet according to MS the reason for my error is that I am using a special action with a non-c++ dll (KB Article (http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B306627)) . I am guessing that this is something that MS is doing. Has anyone else gotten a successful install of SP3 onto Win98? Any info would be helpful.

Mike Villaronga
mike_villaronga@.yahoo.com

LogFile:

Internal Error 2737. StreamSupportFiles.2D02443E_7002_4C0B_ABC9_EAB2C06 4397B, C:\WINDOWS\TEMP\MSI60B6.TMP, StreamSupportFiles
=== Logging stopped: 2/3/03 10:06:17 ===I have not gotten SP3 to install on win98. I have tried to do it manually as well as from an install shield application. I get an error message that there is a dll missing. It doesn't specify which dll or give any kind of clue.

[SIZE=1]Originally posted by mvillaronga
Ok I have an MSI file that installs an instance of the MSDE. I recently updated my install to used the SP3 MSMs of the MSDE. I have the installation working correctly on XP. However it fails rather quickly on install to Win98. I will paste the log file of the failure below.

I am guessing that this is something that MS is doing. Has anyone else gotten a successful install of SP3 onto Win98? Any info would be helpful.

Installing MSDE SA password error.

I've been trying to install MSDE so i could run ASP.Net Forums. But whenever i run the setup.exe file, it gives me a pop up message with the following message:

"A strong SA password is required for security reasons. Please use SAPWD switch to supply the same. Refer to the readme for more details. Set up will now Exit."

Could any body please tell me what to do??...

Yes. I'm stupid. And please excuse my ignoracne.Go to run and type the following replace path and password optionally you can specify authentication mode (default is windows) SECURITYMODE=SQL.

f:\sql2ksp3\MSDE\setup.exe sapwd="password"

Hope this helps

Regards
S(:

Installing MSDE on different plattforms.

Product
Our product is developed in Visual Studio .NET using MFC and .NET.
It connects to a MS SQL Server Desktop Edition (MSDE), where the data is
stored.
Installation
Our problems relates to the installation of our product.
Installation happens in these steps:
- Install .NET
- Install MSDE2000 (with a SA password we have chosen)
- Reboot
- Start our own InstallDB.exe which does the follwoing:
-- Connects to the MSDE (the master database)
-- creates our own database (called "exordb" and creates our own sql
user called "exor")
-- Connects again to MSDE using the exor user and loads data into the
exordb database.
We are using the following connectionstring for connecting to master db the
first time.
Data Source=127.0.01; Integrated Security=SSPI;Initial Catalog=master
We are considering to use this one instead:
server=127.0.0.1;uid=sa;pwd=****;database=master
after the exordb is set up we connect using
server=127.0.0.1;uid=exor;pwd=***;database=exordb
Problems
1. (the most critical)
Installation failes (the first connection string) for some customers with XP
SP2 even if they turn off the firewall.
They get the standard SQLServer Exception:
SQL Server does not exist or access denied.
The MSDE is there (unnamed instance) and is ON.
2. (Windows 98)
When installed on Windows98 MSDE does not start automatically after the
reboot, at least that what it seems on the WIndows 98 machine we have tested
on. (We have also discovered that only SQL Autentification works on Win98,
we solved that by using the second connection string instead of the first
one).
3. (manual start of MSDE)
How may we detect (in our code, preferrably .NET/C#) that MSDE is not
running and how do we start it from the code?
4. (MSDE installed by someone else)
If MSDE is already installed on the computer by another program and
SQL-authentification is not set, how may we set it so our connection string
will work.
hi Vilhelm,
Vilhelm wrote:
> Product
> Our product is developed in Visual Studio .NET using MFC and .NET.
> It connects to a MS SQL Server Desktop Edition (MSDE), where the data
> is stored.
> Installation
> Our problems relates to the installation of our product.
> Installation happens in these steps:
> - Install .NET
> - Install MSDE2000 (with a SA password we have chosen)
> - Reboot
> - Start our own InstallDB.exe which does the follwoing:
> -- Connects to the MSDE (the master database)
> -- creates our own database (called "exordb" and creates our own
> sql user called "exor")
> -- Connects again to MSDE using the exor user and loads data into
> the exordb database.
>
> We are using the following connectionstring for connecting to master
> db the first time.
> Data Source=127.0.01; Integrated Security=SSPI;Initial
> Catalog=master
> We are considering to use this one instead:
> server=127.0.0.1;uid=sa;pwd=****;database=master
> after the exordb is set up we connect using
> server=127.0.0.1;uid=exor;pwd=***;database=exordb
> Problems
> 1. (the most critical)
> Installation failes (the first connection string) for some customers
> with XP SP2 even if they turn off the firewall.
> They get the standard SQLServer Exception:
> SQL Server does not exist or access denied.
> The MSDE is there (unnamed instance) and is ON.
I'm trying to get some more material about that kind of issue on XP sp2 to
report it to Microsoft representative... but I am unable to repro it in my
tests.. I'm aware of another issue on XP sp2 which cause installation
failure due to MDAC stack troubles, currently with no workaround as no MDAC
2.8 xp sp2 refresh is available... please forward me more info, if you
like..

> 2. (Windows 98)
> When installed on Windows98 MSDE does not start automatically after
> the reboot, at least that what it seems on the WIndows 98 machine we
> have tested on.
it's correct... MSDE runs as a standard application on Win9x platform as it
does not support service mode..
you should check that the service manager is added in the autostart folder
and that the "Autostart service when OS starts" check box is checked ..
to start MSDE you can call the SQL Server Service Manager as following:
(named instance)
scm.exe -Action 1 -Silent 1 -Service MSSQL$InstanceName
(default Instance)
scm.exe -Action 1 -Silent 1 -Service MSSQLServer
please keep in mind that, on Win9x, MSDE path will not be added to
autoexec.bat if you don't reboot the
computer, so you have to rely on Win32 API like FindFirstFile or the like to
find where the scm.exe is (usually ..\Program Files\Microsoft SQL
Server\80\Tools\Binn\scm.exe)

>(We have also discovered that only SQL
> Autentification works on Win98, we solved that by using the second
> connection string instead of the first one).
MSDE installed on Win9x does not support integrated security

> 3. (manual start of MSDE)
> How may we detect (in our code, preferrably .NET/C#) that MSDE is not
> running and how do we start it from the code?
you can rely on SQL-DMO COM object...
you can then ping it like
dim oServer as SQLDMO.SQLServer2
objServer.PingSQLServerVersion
start it, or just connect...

> 4. (MSDE installed by someone else)
> If MSDE is already installed on the computer by another program and
> SQL-authentification is not set, how may we set it so our connection
> string will work.
you have to manually change the login authentication mode, logging in as
member of the server's sysadmin role and setting the
objServer.IntegratedSecurity.SecurityMode = SQLDMOSecurity_Mixed
or modify the Windows registry
HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer
LoginMode=2
(HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\InstanceName\MSSQLServer for
a named instance)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thank you a lot for some useful answers!!
More input on question 1.
I have not been able ot reproduce it here, but some of my customers report
this problem. Maybe we can resolve it with some well-phrased questions I can
ask one of my customers on the phone.
We use installshield Premier edition which installs MDAC 2.8 if necessary as
part of the installation process.
Vilhelm Heiberg
Norway.
"Andrea Montanari" wrote:

> hi Vilhelm,
> Vilhelm wrote:
> I'm trying to get some more material about that kind of issue on XP sp2 to
> report it to Microsoft representative... but I am unable to repro it in my
> tests.. I'm aware of another issue on XP sp2 which cause installation
> failure due to MDAC stack troubles, currently with no workaround as no MDAC
> 2.8 xp sp2 refresh is available... please forward me more info, if you
> like..
>
> it's correct... MSDE runs as a standard application on Win9x platform as it
> does not support service mode..
> you should check that the service manager is added in the autostart folder
> and that the "Autostart service when OS starts" check box is checked ..
> to start MSDE you can call the SQL Server Service Manager as following:
> (named instance)
> scm.exe -Action 1 -Silent 1 -Service MSSQL$InstanceName
> (default Instance)
> scm.exe -Action 1 -Silent 1 -Service MSSQLServer
> please keep in mind that, on Win9x, MSDE path will not be added to
> autoexec.bat if you don't reboot the
> computer, so you have to rely on Win32 API like FindFirstFile or the like to
> find where the scm.exe is (usually ..\Program Files\Microsoft SQL
> Server\80\Tools\Binn\scm.exe)
>
> MSDE installed on Win9x does not support integrated security
>
> you can rely on SQL-DMO COM object...
> you can then ping it like
> dim oServer as SQLDMO.SQLServer2
> objServer.PingSQLServerVersion
> start it, or just connect...
>
> you have to manually change the login authentication mode, logging in as
> member of the server's sysadmin role and setting the
> objServer.IntegratedSecurity.SecurityMode = SQLDMOSecurity_Mixed
> or modify the Windows registry
> HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer
> LoginMode=2
> (HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\InstanceName\MSSQLServer for
> a named instance)
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>

installing MSDE and instance name

Hi Joe,
The little server icon is called Service Manager and it does not list the
named instances.
To check the status of the named instance that you have installed, you can
type the server name in the Severbox. It is a dropdown cum text box. So you
will be able to type the SQL Server Name.
For a named instance, the SQL Server name would be
<computername>\<Instancename>.
In your case it would be <computername>\JoesDB01.
After typing the server name, click on Refresh Services button and it
should show you the state of the different services, like the SQL Server,
SQL Server Agent, Distributed Transaction Coordinator.
You can control the state of each Service,
1. Start - Click on this to start/Continue the service, if it is Stopped or
Paused
2. Stop - Click on this to stop the Service.
3. Pause - Click on this to pause the service. Pausing, will allow the
current users to work and will not allow new users to connect to the SQL
Server.
You can also installed the SQL Web Data Administrator, to create and manage
Database from
http://www.microsoft.com/downloads/d...798-C57A-419E-
ACBC-2A332CB7F959&displaylang=en
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
Great! This helped a lot. Things seem to be working fine now
Thanks Ashish!
-- Joe
sql

installing msde 2000a

I tried to install the MSDE 2000A to have a copy of the SQL Server northwind datbase on my machine. When I was installing it I got an error that said the following......

"A strong SA password is required for security reasons. Please use SAPWD switch to supply the same. Refer to readme for more details. Set up will now exit"

Does any one know what I need to do to fix this?

-Thanks

Try reading the 'Readme' file. There you will see the instructions to include the /SAPWD switch and also include a password during installation.

|||To install a new instance of Desktop Engine

1.. Open a command prompt window.

2.. From the command prompt, use the cd command to navigate to the folder
containing the MSDE 2000 SP3a setup utility:
cd c:\MSDESP3aFolder\MSDE

where c:\MSDESP3aFolder is either the path to the folder into which you
extracted the MSDE 2000 SP3a files, or the Desktop Engine SP3a folder on the
SQL Server 2000 SP3a CD.

3.. Execute one of the following commands:

The following is from the "sp3readme.htm" file located in the same folder as
the setup.exe file.

You have to install a named instance configured to use Mixed Mode, execute:
setup INSTANCENAME="InstanceName" SECURITYMODE=SQL SAPWD="AStrongSAPwd"Where
AStrongSAPwd is a strong password to be assigned to the sa login and
InstanceName is the name to be assigned to the instance.

installing msde 2000a

I tried to install the MSDE 2000A to have a copy of the SQL Server northwind datbase on my machine. When I was installing it I got an error that said the following......

"A strong SA password is required for security reasons. Please use SAPWD switch to supply the same. Refer to readme for more details. Set up will now exit"

Does any one know what I need to do to fix this?

-Thanks

Try reading the 'Readme' file. There you will see the instructions to include the /SAPWD switch and also include a password during installation.

|||To install a new instance of Desktop Engine

1.. Open a command prompt window.

2.. From the command prompt, use the cd command to navigate to the folder
containing the MSDE 2000 SP3a setup utility:
cd c:\MSDESP3aFolder\MSDE

where c:\MSDESP3aFolder is either the path to the folder into which you
extracted the MSDE 2000 SP3a files, or the Desktop Engine SP3a folder on the
SQL Server 2000 SP3a CD.

3.. Execute one of the following commands:

The following is from the "sp3readme.htm" file located in the same folder as
the setup.exe file.

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 2000 Release A on a XP Home Machine

Hi,
I'd like to install MSDE 2000 Release A on a XP Home machine via the
command-prompt switches and parameters. I have two areas of ignorance:
1) At first blush, it seems to me that I'll have disparate server names. By
this I mean that when I install MSDE on my computer to conduct the
development, it will have the name "Server_Name"\"Instance_Name". My
server's called "Dell," So I'll have a MSDE instance of,
DELL\"Instance_Name" On the other hand, the target server, an XP Home
machine, is called "SherPerf." So this server instance will be named
SHERPERF\"Instance_Name"
I plan on using an Access adp front end. I don't know how to code viable
connection strings around disparate server names. I.E. in development I'm
connecting to server name #1; but, in production I'm connecting to server
name #2.
What am I missing?
2) If I want to use Windows Authentication, should I create a new user? If
so, what groups should this user be part of? Is it standard practice to
create a user account for MSDE programmatically? If so, how do I do this?
LDAP?
I realize this is a lot to ask. Thanks in advance.
--
Mark Holahan
You application should utilize a configuration file or the registry to store
the ADO connection string or the parameters for the connection string. Then
you would simply change the configuration information to point to another
server. Making a connection string for a different server is easy - just
replace one server name with another. See the Books Online for more
information about ADO or ADO.NET connection strings and how to construct
them.
Jim
"Mark Holahan" <mark.holahan@.unifiedllc.com> wrote in message
news:unoBXFtDFHA.2600@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I'd like to install MSDE 2000 Release A on a XP Home machine via the
> command-prompt switches and parameters. I have two areas of ignorance:
> 1) At first blush, it seems to me that I'll have disparate server names.
> By this I mean that when I install MSDE on my computer to conduct the
> development, it will have the name "Server_Name"\"Instance_Name". My
> server's called "Dell," So I'll have a MSDE instance of,
> DELL\"Instance_Name" On the other hand, the target server, an XP Home
> machine, is called "SherPerf." So this server instance will be named
> SHERPERF\"Instance_Name"
> I plan on using an Access adp front end. I don't know how to code viable
> connection strings around disparate server names. I.E. in development I'm
> connecting to server name #1; but, in production I'm connecting to server
> name #2.
> What am I missing?
> 2) If I want to use Windows Authentication, should I create a new user? If
> so, what groups should this user be part of? Is it standard practice to
> create a user account for MSDE programmatically? If so, how do I do this?
> LDAP?
> I realize this is a lot to ask. Thanks in advance.
> --
> --
> Mark Holahan
>
|||Thanks Jim! Yes...of course. Can you tell I haven't done this before?
Do you have any comment regarding my second question?
Many thanks.
"Jim Young" <thorium48@.hotmail.com> wrote in message
news:%23ioGNN0DFHA.3536@.TK2MSFTNGP15.phx.gbl...
> You application should utilize a configuration file or the registry to
> store the ADO connection string or the parameters for the connection
> string. Then you would simply change the configuration information to
> point to another server. Making a connection string for a different server
> is easy - just replace one server name with another. See the Books Online
> for more information about ADO or ADO.NET connection strings and how to
> construct them.
> Jim
> "Mark Holahan" <mark.holahan@.unifiedllc.com> wrote in message
> news:unoBXFtDFHA.2600@.TK2MSFTNGP09.phx.gbl...
>
|||Regarding question #2 - If your computers are not a member of a domain then
Windows authentication will be of less importance and all user will be local
to the machine they are running on. If you have the chance to use Windows
security then what groups the users are a member of is entirely up to you.
Ideally you would make the groups the logins to the server and the add the
user to the groups. That way you do not have to add each user individually
as a login to the server.
Jim
"Mark Holahan" <mark.holahan@.unifiedllc.com> wrote in message
news:eaXlKZ2DFHA.3824@.TK2MSFTNGP10.phx.gbl...
> Thanks Jim! Yes...of course. Can you tell I haven't done this before?
> Do you have any comment regarding my second question?
> Many thanks.
>
> "Jim Young" <thorium48@.hotmail.com> wrote in message
> news:%23ioGNN0DFHA.3536@.TK2MSFTNGP15.phx.gbl...
>

Installing MSDE 2000 Rel A

Hi all,
I am unable to install MSDE on Window XP pro, SP2. Setup rolls back every
time without any indication of why. I had an earlier installation of MSDE
which I removed manually following the instructions in the Knowledge Base
article. I installed MSDE on a Windows 2000 Pro machine using the same
procedure without any problems.
The command line syntax I'm using is: setup sapwd="[mypassword]"
SECURITYMODE=SQL
Can anyone help?
Thanks.
When you manually uninstalled MSDE did you also remove the "MSSQLServer" key
under HKEY_LOCAL_MACHINE\Software\Microsoft ? That key and the "Microsoft
SQL Server" key needs to be removed. Also remove the entire directory tree
under c:\program files\Microsoft SQL Server. Also, reboot the machine after
doing the manual uninstall.
Jim
"Stephen Bishop" <Stephen Bishop@.discussions.microsoft.com> wrote in message
news:1E567705-A87F-4B8D-8DF5-202D934D5263@.microsoft.com...
> Hi all,
> I am unable to install MSDE on Window XP pro, SP2. Setup rolls back every
> time without any indication of why. I had an earlier installation of MSDE
> which I removed manually following the instructions in the Knowledge Base
> article. I installed MSDE on a Windows 2000 Pro machine using the same
> procedure without any problems.
> The command line syntax I'm using is: setup sapwd="[mypassword]"
> SECURITYMODE=SQL
> Can anyone help?
> Thanks.
|||Hi Jim,
I did delete those keys from the registry with no luck.
In a separate post, I uploaded part of the install log what appears to point
to the problem . Searching for "return value 3" I found the following:
"Starting custom action InstallPerfMon
Registering performance counters from sqlctr.ini
PerfmonLoad routine returned error code 6
Action ended 11:32:55: InstallFinalize. Return value 3."
According to a Knowledge Base article, the only solution to this involves
some advanced level tinkering with the registry, which I don't feel
comfortable undertaking. Is there any other way?
Thanks for your reply.
sb
"Jim Young" wrote:

> When you manually uninstalled MSDE did you also remove the "MSSQLServer" key
> under HKEY_LOCAL_MACHINE\Software\Microsoft ? That key and the "Microsoft
> SQL Server" key needs to be removed. Also remove the entire directory tree
> under c:\program files\Microsoft SQL Server. Also, reboot the machine after
> doing the manual uninstall.
> Jim
> "Stephen Bishop" <Stephen Bishop@.discussions.microsoft.com> wrote in message
> news:1E567705-A87F-4B8D-8DF5-202D934D5263@.microsoft.com...
>
>
sql

Installing MSDE 2000 on Server with SQL 2005 Express

Can anybody help?

I have a Windows XP and 2003 server; we have installed SQL 2005 Express on it but have an application that installs MSDE 2000 to connect to an application. After the MSDE 2000 is installed we can no longer see the instance across the network. If we uninstall the SQL 2005 express version we can see the Instance in MSDE 2000.

Is there any compatibility issue with install MSDE 2000 after SQL 2005 has been installed.

Many Thanks in advance

David

In general, this should work. There are specific limitations, which I think are well spelled out in BOL. Here's a copy and paste; hopefully this will describe your issue:

In SQL Server 2000, the identification of the server connection endpoints was performed by the SQL Server service. SQL Server 2005 replaces that function with the SQL Server Browser service. If you install SQL Server on a computer that is also running SQL Server 2000 or MSDE, you must ensure that SQL Server 2000 or MSDE is upgraded to Service Pack 3 (SP3) or later. Versions prior to SP3 do not properly share port 1434 and may not make your SQL Server instances available to requesting client applications. Although you can change the services startup order so that the SQL Server Browser service starts before SQL Server 2000 or MSDE, the recommended resolution is to update all older versions of SQL Server to the latest service pack.

When an instance of SQL Server 2000 is installed on the computer, if the SQL Server Browser is not running, the SQL Server 2000 listener service starts. If SQL Server Browser starts after the listener service, it waits 5 seconds for SQL Server 2000 to give up port 1434. If that does not occur, SQL Server Browser fails to start. To resolve this problem with versions of SQL Server 2000 prior to service pack 3, stop SQL Server 2000, start SQL Server Browser, then restart SQL Server 2000. The SQL Server 2000 listener service continues to attempt to start on port 1434, so the SQL Server 2000 instance should be upgraded to service pack 3 as soon as possible.

SQL Server 7.0 had no similar capabilities and has no conflicts with SQL Server Browser.

Installing MSDE 2000 on a system with SQL Express 2005

I noticed that when I install an app that uses MSDE 2000 on my system (which
has SQL Express 2005 installed) the MSDE setup will load and hang at "11
minutes" remaining. I can't cancel it, clicking Cancel switches the dialog
to say "Cancelling" but nothing ever happens.
Is it possible for MSDE 2000 to co-exist with SQL Express 2005 on a system?
If yes, how?
Thanks for your help!
hi Pyil,
Phil Palios wrote:
> I noticed that when I install an app that uses MSDE 2000 on my system
> (which has SQL Express 2005 installed) the MSDE setup will load and
> hang at "11 minutes" remaining. I can't cancel it, clicking Cancel
> switches the dialog to say "Cancelling" but nothing ever happens.
> Is it possible for MSDE 2000 to co-exist with SQL Express 2005 on a
> system? If yes, how?
yes it should be ... do not know if MSDE 2000 should be previously installed
than SQLExpress, but should be..
please provide the
/L*v "c:\MsdeLot.txt"
parameter to the setup.exe boostrap installer in order to allow verbose
logging of the installation process.. this will result in an about
2mb(succesfull installation) text file you can inspect for
RETURN VALUE 3
entries... about 10/15 lines before each entry, some (sometime cryptic)
description of the problem will be reported..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Andrea,
I opened up the MSDE log and there are no lines that contain "value 3" my
guess for this is that since setup hung it never was able to log a value 3
and exit gracefully.
The last two lines in the log are:
Starting custom action InstallSqlRedis
Executing "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlredis.exe
/q:a"
So it appears that sqlredis.exe may be what is hanging, and the MSDE install
is not hearing back so it hangs. Any ideas on what is going on and how it
may be fixed?
Thanks so much!
-Phil
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3t11onFprggaU1@.individual.net...
> hi Pyil,
> Phil Palios wrote:
> yes it should be ... do not know if MSDE 2000 should be previously
> installed than SQLExpress, but should be..
> please provide the
> /L*v "c:\MsdeLot.txt"
> parameter to the setup.exe boostrap installer in order to allow verbose
> logging of the installation process.. this will result in an about
> 2mb(succesfull installation) text file you can inspect for
> RETURN VALUE 3
> entries... about 10/15 lines before each entry, some (sometime cryptic)
> description of the problem will be reported..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Phil,
Phil Palios wrote:
> Hi Andrea,
> I opened up the MSDE log and there are no lines that contain "value
> 3" my guess for this is that since setup hung it never was able to
> log a value 3 and exit gracefully.
> The last two lines in the log are:
> Starting custom action InstallSqlRedis
> Executing "C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\sqlredis.exe /q:a"
> So it appears that sqlredis.exe may be what is hanging, and the MSDE
> install is not hearing back so it hangs. Any ideas on what is going
> on and how it may be fixed?
>
you can not fix this, as this problem is raised by MDAC setup itself... but
you can hack it... it's not supported but you can do it...
first install the latest MDAC stack manually, then run MSDE setup.exe
boostrap installer...
when MSDE setup hangs, kill setupre.exe process via Task Manager, then the
setup will proceed and complete successfully...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Installing MSDE 2000

I'm trying to install SQL2000 Desktop for Visual Studio.Net. Fromcmd prompt
I'm running:
Setup.exe /qb+ INSTANCENAME=VSDOTNET DISABLENETWORKPROTOCOLS=1 SAPWD=password
Nothing happens then I get a popup saying: "Please go to the control panel
to install and configure system components".
How intuitive!! Does this mean MDAC upgrade or what? Anyone know what this
message implies?
TX
Don't know if it has anything to do with it but can you firstly try..
Setup.exe SAPWD="password"
--Original Message--
From: CW [mailto:CW@.discussions.microsoft.com]
Posted At: Tuesday, 18 January 2005 7:55 AM
Posted To: microsoft.public.sqlserver.msde
Conversation: Installing MSDE 2000
Subject: Installing MSDE 2000
I'm trying to install SQL2000 Desktop for Visual Studio.Net. Fromcmd
prompt I'm running:
Setup.exe /qb+ INSTANCENAME=VSDOTNET DISABLENETWORKPROTOCOLS=1
SAPWD=password
Nothing happens then I get a popup saying: "Please go to the control
panel to install and configure system components".
How intuitive!! Does this mean MDAC upgrade or what? Anyone know what
this message implies?
TX

Installing MSDE (VB.NET)

Hi,
I need to package and deploy my MSDE database with my application. How do I
do this? It needs to deploy, install, and I need to also install tables,
users, user rights and also possibly some sample data.
I can do an unattended install, but do I have to write a seperate program or
use osql/isql to run batch file/sql scripts to update the database?
Surely there's an automated method to "click-and-install"...?

Liddle Feesh
*fap fap fap fap*
<>< <>< <>< <>< ><>
<>< <>< <>< <>< <>< <><
My friend, there is no elegant way to do this.
Microsoft offers merge modules that will handle the installation for you. You can then use a CustomAction to attach a database or run SQL statementts to create a database. This isn't recommended because now YOU become responsible for creating a patch file
to patch the millions of security holes in MSDE. MSDE also uninstalls with your program under this scenario.
What I have ended up doing is programmatically shelling out to call the setup.exe program that is included with MSDE. I have created a program that looks similar to the Visual Studio .NET install where users can first click on a link to launch the SQL Ser
ver 2000 MSDE install, then install my application.
Microsoft has also created a gimpy MSDE/.NET Framework bootstrapper, but it is far from being stable. I personally think it's a piece of junk and wouldn't recommend it. *Supposedly*, if the next version of Visual Studio EVER ships, a generic bootstrapper
is supposed to be included that will allow chained .MSI installations. But until then, we're out of luck.
I recommend shelling out to the setup.exe program provided with MSDE. Good luck.
Rob Reagan
"Liddle Feesh" wrote:

> Hi,
> I need to package and deploy my MSDE database with my application. How do I
> do this? It needs to deploy, install, and I need to also install tables,
> users, user rights and also possibly some sample data.
> I can do an unattended install, but do I have to write a seperate program or
> use osql/isql to run batch file/sql scripts to update the database?
> Surely there's an automated method to "click-and-install"...?
>
> --
> Liddle Feesh
> *fap fap fap fap*
> <>< <>< <>< <>< ><>
> <>< <>< <>< <>< <>< <><
>
>
|||Hi Rob,
I have been using the MSDE bootstrapper and have had quiet a few issues with it, like the installation just hangs many times, the MSDE instance needs to be reinstalled even if it is installed (a confirmed bug my Microsoft here), etc.. you mentioned you ar
e shelling out the exe yourself. I was just wondering what all parameters are you taking care of.. I mean In general what pointers/advise will you give to anyone who wants to do the same thing.
Thanks
dev
"Rob Reagan" wrote:

> My friend, there is no elegant way to do this.
> Microsoft offers merge modules that will handle the installation for you. You can then use a CustomAction to attach a database or run SQL statementts to create a database. This isn't recommended because now YOU become responsible for creating a patch fi
le to patch the millions of security holes in MSDE. MSDE also uninstalls with your program under this scenario.
> What I have ended up doing is programmatically shelling out to call the setup.exe program that is included with MSDE. I have created a program that looks similar to the Visual Studio .NET install where users can first click on a link to launch the SQL S
erver 2000 MSDE install, then install my application.
> Microsoft has also created a gimpy MSDE/.NET Framework bootstrapper, but it is far from being stable. I personally think it's a piece of junk and wouldn't recommend it. *Supposedly*, if the next version of Visual Studio EVER ships, a generic bootstrappe
r is supposed to be included that will allow chained .MSI installations. But until then, we're out of luck.[vbcol=seagreen]
> I recommend shelling out to the setup.exe program provided with MSDE. Good luck.
> Rob Reagan
> "Liddle Feesh" wrote:
|||Since I am using this as a remote database over the network, I'm setting DISABLENETWORKPROTOCOLS=0. I'm also setting the SAPWD, INSTANCENAME, and SECURITYMODE parameters.
Be forewarned that the MSDE installer is a great example of the half-baked software that Microsoft inflicts on the public. The uninstaller leaves garbage behind. While developing, you're going to have to do alot of removal of orphaned files and registry k
eys by hand before you can attempt a reinstall for the same named instance.
Be very careful when cleaning out your registry from orphaned MSDE keys. I zapped a few that I shouldn't have and was unable to reinstall MSDE, period. I've got to reformat my drive and reinstall Windows.
Rob
"dev_kh" wrote:

> Hi Rob,
> I have been using the MSDE bootstrapper and have had quiet a few issues with it, like the installation just hangs many times, the MSDE instance needs to be reinstalled even if it is installed (a confirmed bug my Microsoft here), etc.. you mentioned you
are shelling out the exe yourself. I was just wondering what all parameters are you taking care of.. I mean In general what pointers/advise will you give to anyone who wants to do the same thing.[vbcol=seagreen]
> Thanks
> dev
> "Rob Reagan" wrote:
file to patch the millions of security holes in MSDE. MSDE also uninstalls with your program under this scenario.[vbcol=seagreen]
Server 2000 MSDE install, then install my application.[vbcol=seagreen]
per is supposed to be included that will allow chained .MSI installations. But until then, we're out of luck.[vbcol=seagreen]
|||Oh My Goodness, I also had to manually delete the registry keys many times but no formatting so far. Thanks for your reply though. I was wondering more in lines with figuring out whether the MSDE installation went fine or not when you shell it out. Als
o do you do any logging of the MSDE installation..
Thanks again
"Rob Reagan" wrote:

> Since I am using this as a remote database over the network, I'm setting DISABLENETWORKPROTOCOLS=0. I'm also setting the SAPWD, INSTANCENAME, and SECURITYMODE parameters.
> Be forewarned that the MSDE installer is a great example of the half-baked software that Microsoft inflicts on the public. The uninstaller leaves garbage behind. While developing, you're going to have to do alot of removal of orphaned files and registry
keys by hand before you can attempt a reinstall for the same named instance.[vbcol=seagreen]
> Be very careful when cleaning out your registry from orphaned MSDE keys. I zapped a few that I shouldn't have and was unable to reinstall MSDE, period. I've got to reformat my drive and reinstall Windows.
> Rob
> "dev_kh" wrote:
u are shelling out the exe yourself. I was just wondering what all parameters are you taking care of.. I mean In general what pointers/advise will you give to anyone who wants to do the same thing.[vbcol=seagreen]
h file to patch the millions of security holes in MSDE. MSDE also uninstalls with your program under this scenario.[vbcol=seagreen]
QL Server 2000 MSDE install, then install my application.[vbcol=seagreen]
apper is supposed to be included that will allow chained .MSI installations. But until then, we're out of luck.[vbcol=seagreen]
|||I have had good luck shelling the setup.exe program. My only complaint there is that the uninstaller is so sloppy and leaves behind a bunch of keys and files. I do not log in my production program, only in my test environment. I have considered writing my
own custom uninstaller that shells to the windows uninstaller, then cleans up keys and files afterwards. The only disadvantage is that the user could bypass my customer uninstaller (accesible through the programs menu) and use the one in Add\Remove Progr
ams.
Rob
"dev_kh" wrote:

> Oh My Goodness, I also had to manually delete the registry keys many times but no formatting so far. Thanks for your reply though. I was wondering more in lines with figuring out whether the MSDE installation went fine or not when you shell it out. A
lso do you do any logging of the MSDE installation..[vbcol=seagreen]
> Thanks again
> "Rob Reagan" wrote:
ry keys by hand before you can attempt a reinstall for the same named instance.[vbcol=seagreen]
you are shelling out the exe yourself. I was just wondering what all parameters are you taking care of.. I mean In general what pointers/advise will you give to anyone who wants to do the same thing.[vbcol=seagreen]
tch file to patch the millions of security holes in MSDE. MSDE also uninstalls with your program under this scenario.[vbcol=seagreen]
SQL Server 2000 MSDE install, then install my application.[vbcol=seagreen]
trapper is supposed to be included that will allow chained .MSI installations. But until then, we're out of luck.[vbcol=seagreen]
|||Hi Rob,
Cheers for the reply (and the other guys too!) - I've heard Microsoft
released an MSDE Installer SDK in December 2003... might be worth a look
at?
It's pretty late and I've just got in - so I'll have to look at this
tomorrow!
cya later, chaps!

Liddle Feesh
*fap fap fap fap*
<>< <>< <>< <>< ><>
<>< <>< <>< <>< <>< <><

Installing MSDE - User Security Issues...

Hi,
Could someone point me in the direction of a step-by-step tutorial for
replicating a SQL Server 2000 database as an MSDE database in a seperate
machine, with all tables (including data), users/security, etc.
Currently I'm taking a backup (I can't script the data from Ent. Mgr) and
using oSQL to restore the database to an MSDE install on a machine.
It's done in two steps - installing MSDE and restoring the backup. However,
after the backup has been restored (the user restores correctly) - I am
unable to connect to the database as the default user that I created in the
backup. If I remove the user and re-add him via Ent. Mgr then I can
connect... does anyone know why this is?
First Step - Install MSDE script:
^^^^^^^^^^^^^^^^^^^^^^^^
Set objShell = CreateObject("WScript.Shell")
Set fso = createobject("scripting.filesystemobject")
Set WshNetwork = WScript.CreateObject("WScript.Network")
objShell.Exec(fso.getabsolutepathname(".") & "\setup.exe BLANKSAPWD=1
SAPWD="""" SECURITYMODE=SQL TARGETDIR=""C:\Program Files\Microsoft SQL
Server\Mssql\Binn\"" DATADIR=""C:\Program Files\Microsoft SQL
Server\Mssql\Data\"" instancename=""" & WshNetwork.ComputerName &
"\DatabaseName""")
Second Step - Restore the database backup:
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Set objShell = CreateObject("WScript.Shell")
set fso = createobject("scripting.filesystemobject")
Set WshNetwork = WScript.CreateObject("WScript.Network")
currentpath = fso.getabsolutepathname(".")
' Start the msde service
objShell.Exec("net start MSSQL$" & WshNetwork.ComputerName &
"\DatabaseName")
' Make local data and backup directories
'objShell.Exec("md c:\SQL_Databases\DATA")
'objShell.Exec("md c:\SQL_Databases\BACKUP")
' Copy this Repository.bak to the SQL_Databases DatabaseName.bak
fso.CopyFile currentpath &
"\Repository.bak","c:\SQL_Databases\BACKUP\DatabaseName.bak"
' Restore
objShell.Exec(currentpath & "\osql.exe -S" & WshNetwork.ComputerName &
"\DatabaseName -E -Q ""restore database DatabaseName from disk =
'C:\SQL_Databases\BACKUP\DatabaseName.bak'""")
All I want to do is reproduce one of my SQL Server databases AS IS on
several client workstations by way of an MSDE installer.
Any help gratefully appreciated !
Thanks,
Mike
xposted to closely related groups: .sqlserver.msde, .sqlserver.security,
.sqlserver.setup
--
Liddle Feesh
*fap fap fap fap*
<>< <>< <>< <>< ><>
<>< <>< <>< <>< <>< <><
. ,
.:/
. ,,///;, ,;/
. o:::::::;;///

quote:

>::::::::;;\\\

''\\\\'" ';\
';\314546 HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/?id=314546
304692 INF: Moving SQL Server 7.0 Databases to a New Server with BACKUP and
http://support.microsoft.com/?id=304692
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||"Kevin McDonnell [MSFT]" <kevmc@.online.microsoft.com> wrote in message
news:clkWql2wDHA.2900@.cpmsftngxa07.phx.gbl...

quote:

> 314546 HOW TO: Move Databases Between Computers That Are Running SQL

Server

quote:

> http://support.microsoft.com/?id=314546
> 304692 INF: Moving SQL Server 7.0 Databases to a New Server with BACKUP

and

quote:

> http://support.microsoft.com/?id=304692

Hi Kevin and Joseph,
Many thanks for your replies relating to my difficulties with the orphaned
users that arise when restoring a backup on a different server.
Using the sp_change_user_login stored procedure worked perfectly.
Thanks again for your advice, and please accept my apologies for the slight
crosspost.
Best Regards,
Mike
Liddle Feesh
*fap fap fap fap*
<>< <>< <>< <>< ><>
<>< <>< <>< <>< <>< <><
. ,
.:/
. ,,///;, ,;/
. o:::::::;;///

quote:

>::::::::;;\\\

''\\\\'" ';\
';\sql

Friday, March 30, 2012

Blog Archive

About Me