I am running 2 instances of MSDE2000 on a server with Win2K server SP4 and
ISA Server 2000. From the workstations on the network I am able to create
an ODBC connection to the default instance of SQL (MSSQL) but receive an
error when trying to connect to the 2nd instance (MSSQL\INSTANCENAME). Both
names appear in the dropdown list when creating the ODBC connection. Both
instances are running and networking for TCP/IP is enabled using SVRNETCN.
Both instances use the same SA password and connection is made using SQL
Authentication.
Error Message is
Connection Failed
SQLState 01000
SQL Server Error: 10048
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect())
Connection Failed
SQLState 08001
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access denied
If I stop both instances of SQL and start only the 2nd instance i am then
able to connect to it but am unable to connect to the default instance when
it is restarted. It seems that the first instance of SQL to start can have
a connection made to it and any other instances cannot have an ODBC
connection. I think it may be related to ISA Server but cannot confirm at
this stage
Any advice would be appreciated.
Darrin
Darrin Acreman wrote:
> I am running 2 instances of MSDE2000 on a server with Win2K server SP4 and
> ISA Server 2000. From the workstations on the network I am able to create
> an ODBC connection to the default instance of SQL (MSSQL) but receive an
> error when trying to connect to the 2nd instance (MSSQL\INSTANCENAME). Both
> names appear in the dropdown list when creating the ODBC connection. Both
> instances are running and networking for TCP/IP is enabled using SVRNETCN.
> Both instances use the same SA password and connection is made using SQL
> Authentication.
> Error Message is
> Connection Failed
> SQLState 01000
> SQL Server Error: 10048
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect())
> Connection Failed
> SQLState 08001
> SQL Server Error: 17
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
> access denied
> If I stop both instances of SQL and start only the 2nd instance i am then
> able to connect to it but am unable to connect to the default instance when
> it is restarted. It seems that the first instance of SQL to start can have
> a connection made to it and any other instances cannot have an ODBC
> connection. I think it may be related to ISA Server but cannot confirm at
> this stage
> Any advice would be appreciated.
> Darrin
>
Check the port numbers for both instances, they should be different
different. Check the application log/system log for any errors generated
by the second instance you start.
Showing posts with label microsoft. Show all posts
Showing posts with label microsoft. Show all posts
Friday, March 30, 2012
MSDE and Installshield
I need a better installation procedure for my software, so I wanted to merge
the MSDE install into the main one. At the moment the Setup has been built
by a third part developer, who use Installshiled.
Problem is, he doesn't know which version of Installshield he needs. Someone
can give me a hint?
On Thu, 1 Jul 2004 16:18:40 +0200, Drizzt <drizzt.du@.libero.it> wrote:
> I need a better installation procedure for my software, so I wanted to
> merge
> the MSDE install into the main one. At the moment the Setup has been
> built
> by a third part developer, who use Installshiled.
> Problem is, he doesn't know which version of Installshield he needs.
> Someone can give me a hint?
From what I read, InstallShield 7 should be alright; maybe even 6.
Not related to MSDE, I am struggling with it, though: I am unable to
create simple Upgrade packages that replace a couple of files in an
installation. something that InnoSetup and InstallShield 5 do perfectly
well.
Stefan
|||When I last spoke to them, the installshield guys didn't have the bootstrapper out for MSDE. They still had the merge modules but be warned microsoft does not want you to continue that route. I even spoke with WISE Solutions and they also mentioned that
they were working on replacing the merge module for MSDE.. so something to keep in mind.
Thanks
dev
"Stefan M. Huber" wrote:
> On Thu, 1 Jul 2004 16:18:40 +0200, Drizzt <drizzt.du@.libero.it> wrote:
>
> From what I read, InstallShield 7 should be alright; maybe even 6.
> Not related to MSDE, I am struggling with it, though: I am unable to
> create simple Upgrade packages that replace a couple of files in an
> installation. something that InnoSetup and InstallShield 5 do perfectly
> well.
> Stefan
>
|||"dev_kh" <devkh@.discussions.microsoft.com> ha scritto nel messaggio
news:3014BFB6-1C09-49FB-BA4E-C21475CDD808@.microsoft.com...
> When I last spoke to them, the installshield guys didn't
> have the bootstrapper out for MSDE. They still had the merge
> modules but be warned microsoft does not want you to continue
> that route. I even spoke with WISE Solutions and they also mentioned
> that they were working on replacing the merge module for MSDE.. so
something to keep in mind.
Sorry, I got lost.
Our product must be a self-easy-installing one. I have no experience about
Installations packages, and the (external)guy who must build it needs
directions from me, as he have never installed MSDE before.
We need a tight integration between the two -installshield and MSDE- 'cause
in case of errors we need the installation to halt and report the error,
while now it simply goes on...
So, is there a simply solution? What are the methods commonly used for this?
Sorry to bother, but I really have no clues...
|||| So, is there a simply solution? What are the methods commonly used for this?
I plan on using InnoSetup. I have been using it for over a year - love it. I
have not used it for MSDE, but I plan to.
<quote>
Yes, we now know how to. But it has taken a *LOT* of effort to
integrate it into InnoSetup in such a way that it:
* Checks the existence of an earlier MSDE installation
* If found check if it was done from our software
* If not, install a new instance using Microsoft setup
* Make sure to use the correct MSI file during install
* Make sure to set all install parameters correct
* Start the MSDE after install
* Connect to MSDE and install database
* Make sure it works on all NT platforms (big problems on NT4)
* etc etc etc
We have probably spent one man-moth on this task alone... Bo
</quote>
http://fox.wikis.com/wc.dll?Wiki~Inn...ScriptMSDE~VFP
Carl K
|||So, do you have a workable solution for installing an app and MSDE or not?
TIA,
Paul
"Carl Karsten" <carl@.personnelware.com> wrote in message
news:%23dnKozoYEHA.3988@.tk2msftngp13.phx.gbl...
> | So, is there a simply solution? What are the methods commonly used for
this?
> I plan on using InnoSetup. I have been using it for over a year - love
it. I
> have not used it for MSDE, but I plan to.
> <quote>
> Yes, we now know how to. But it has taken a *LOT* of effort to
> integrate it into InnoSetup in such a way that it:
> * Checks the existence of an earlier MSDE installation
> * If found check if it was done from our software
> * If not, install a new instance using Microsoft setup
> * Make sure to use the correct MSI file during install
> * Make sure to set all install parameters correct
> * Start the MSDE after install
> * Connect to MSDE and install database
> * Make sure it works on all NT platforms (big problems on NT4)
> * etc etc etc
> We have probably spent one man-moth on this task alone... Bo
> </quote>
> http://fox.wikis.com/wc.dll?Wiki~Inn...ScriptMSDE~VFP
> Carl K
>
|||Personally, no.
If the Inno guys say it will fly, I have no reason to doubt them. They aren't
trying to sell me something - the beauty of open source software.
Carl K
"Paul McTeigue" <paul_mcteigue@.msn.com> wrote in message
news:%23vGPGesYEHA.2816@.TK2MSFTNGP11.phx.gbl...
| So, do you have a workable solution for installing an app and MSDE or not?
|
| TIA,
| Paul
|
| "Carl Karsten" <carl@.personnelware.com> wrote in message
| news:%23dnKozoYEHA.3988@.tk2msftngp13.phx.gbl...
| >
| > | So, is there a simply solution? What are the methods commonly used for
| this?
| >
| > I plan on using InnoSetup. I have been using it for over a year - love
| it. I
| > have not used it for MSDE, but I plan to.
| >
| > <quote>
| > Yes, we now know how to. But it has taken a *LOT* of effort to
| > integrate it into InnoSetup in such a way that it:
| > * Checks the existence of an earlier MSDE installation
| > * If found check if it was done from our software
| > * If not, install a new instance using Microsoft setup
| > * Make sure to use the correct MSI file during install
| > * Make sure to set all install parameters correct
| > * Start the MSDE after install
| > * Connect to MSDE and install database
| > * Make sure it works on all NT platforms (big problems on NT4)
| > * etc etc etc
| >
| > We have probably spent one man-moth on this task alone... Bo
| > </quote>
| >
| > http://fox.wikis.com/wc.dll?Wiki~Inn...ScriptMSDE~VFP
| >
| > Carl K
| >
|
|
sql
the MSDE install into the main one. At the moment the Setup has been built
by a third part developer, who use Installshiled.
Problem is, he doesn't know which version of Installshield he needs. Someone
can give me a hint?
On Thu, 1 Jul 2004 16:18:40 +0200, Drizzt <drizzt.du@.libero.it> wrote:
> I need a better installation procedure for my software, so I wanted to
> merge
> the MSDE install into the main one. At the moment the Setup has been
> built
> by a third part developer, who use Installshiled.
> Problem is, he doesn't know which version of Installshield he needs.
> Someone can give me a hint?
From what I read, InstallShield 7 should be alright; maybe even 6.
Not related to MSDE, I am struggling with it, though: I am unable to
create simple Upgrade packages that replace a couple of files in an
installation. something that InnoSetup and InstallShield 5 do perfectly
well.
Stefan
|||When I last spoke to them, the installshield guys didn't have the bootstrapper out for MSDE. They still had the merge modules but be warned microsoft does not want you to continue that route. I even spoke with WISE Solutions and they also mentioned that
they were working on replacing the merge module for MSDE.. so something to keep in mind.
Thanks
dev
"Stefan M. Huber" wrote:
> On Thu, 1 Jul 2004 16:18:40 +0200, Drizzt <drizzt.du@.libero.it> wrote:
>
> From what I read, InstallShield 7 should be alright; maybe even 6.
> Not related to MSDE, I am struggling with it, though: I am unable to
> create simple Upgrade packages that replace a couple of files in an
> installation. something that InnoSetup and InstallShield 5 do perfectly
> well.
> Stefan
>
|||"dev_kh" <devkh@.discussions.microsoft.com> ha scritto nel messaggio
news:3014BFB6-1C09-49FB-BA4E-C21475CDD808@.microsoft.com...
> When I last spoke to them, the installshield guys didn't
> have the bootstrapper out for MSDE. They still had the merge
> modules but be warned microsoft does not want you to continue
> that route. I even spoke with WISE Solutions and they also mentioned
> that they were working on replacing the merge module for MSDE.. so
something to keep in mind.
Sorry, I got lost.
Our product must be a self-easy-installing one. I have no experience about
Installations packages, and the (external)guy who must build it needs
directions from me, as he have never installed MSDE before.
We need a tight integration between the two -installshield and MSDE- 'cause
in case of errors we need the installation to halt and report the error,
while now it simply goes on...
So, is there a simply solution? What are the methods commonly used for this?
Sorry to bother, but I really have no clues...
|||| So, is there a simply solution? What are the methods commonly used for this?
I plan on using InnoSetup. I have been using it for over a year - love it. I
have not used it for MSDE, but I plan to.
<quote>
Yes, we now know how to. But it has taken a *LOT* of effort to
integrate it into InnoSetup in such a way that it:
* Checks the existence of an earlier MSDE installation
* If found check if it was done from our software
* If not, install a new instance using Microsoft setup
* Make sure to use the correct MSI file during install
* Make sure to set all install parameters correct
* Start the MSDE after install
* Connect to MSDE and install database
* Make sure it works on all NT platforms (big problems on NT4)
* etc etc etc
We have probably spent one man-moth on this task alone... Bo
</quote>
http://fox.wikis.com/wc.dll?Wiki~Inn...ScriptMSDE~VFP
Carl K
|||So, do you have a workable solution for installing an app and MSDE or not?
TIA,
Paul
"Carl Karsten" <carl@.personnelware.com> wrote in message
news:%23dnKozoYEHA.3988@.tk2msftngp13.phx.gbl...
> | So, is there a simply solution? What are the methods commonly used for
this?
> I plan on using InnoSetup. I have been using it for over a year - love
it. I
> have not used it for MSDE, but I plan to.
> <quote>
> Yes, we now know how to. But it has taken a *LOT* of effort to
> integrate it into InnoSetup in such a way that it:
> * Checks the existence of an earlier MSDE installation
> * If found check if it was done from our software
> * If not, install a new instance using Microsoft setup
> * Make sure to use the correct MSI file during install
> * Make sure to set all install parameters correct
> * Start the MSDE after install
> * Connect to MSDE and install database
> * Make sure it works on all NT platforms (big problems on NT4)
> * etc etc etc
> We have probably spent one man-moth on this task alone... Bo
> </quote>
> http://fox.wikis.com/wc.dll?Wiki~Inn...ScriptMSDE~VFP
> Carl K
>
|||Personally, no.
If the Inno guys say it will fly, I have no reason to doubt them. They aren't
trying to sell me something - the beauty of open source software.
Carl K
"Paul McTeigue" <paul_mcteigue@.msn.com> wrote in message
news:%23vGPGesYEHA.2816@.TK2MSFTNGP11.phx.gbl...
| So, do you have a workable solution for installing an app and MSDE or not?
|
| TIA,
| Paul
|
| "Carl Karsten" <carl@.personnelware.com> wrote in message
| news:%23dnKozoYEHA.3988@.tk2msftngp13.phx.gbl...
| >
| > | So, is there a simply solution? What are the methods commonly used for
| this?
| >
| > I plan on using InnoSetup. I have been using it for over a year - love
| it. I
| > have not used it for MSDE, but I plan to.
| >
| > <quote>
| > Yes, we now know how to. But it has taken a *LOT* of effort to
| > integrate it into InnoSetup in such a way that it:
| > * Checks the existence of an earlier MSDE installation
| > * If found check if it was done from our software
| > * If not, install a new instance using Microsoft setup
| > * Make sure to use the correct MSI file during install
| > * Make sure to set all install parameters correct
| > * Start the MSDE after install
| > * Connect to MSDE and install database
| > * Make sure it works on all NT platforms (big problems on NT4)
| > * etc etc etc
| >
| > We have probably spent one man-moth on this task alone... Bo
| > </quote>
| >
| > http://fox.wikis.com/wc.dll?Wiki~Inn...ScriptMSDE~VFP
| >
| > Carl K
| >
|
|
sql
MSDE and installing MS SQL server 2000
Sorry if this is a stupid question , i'm a newbie to SQL server and MSDE. I
read the installation manual but couldn't find the answer:-;
Question:
I've a server running MSDE latest patches etc.
I just purchaced MS SQL server 2000 standaard edition.
Does the installation of MS sql 2000 server takes care of copying and using
the old MSDE database(s)?
There is one application using MSDE with MSSQLSERVER as named instance, I
Think :-?
Or do i need to desintall MSDE?
Thanks for the time
Hi,
SQL Server standard edition Installation will not copy the existing
databases. Databases
you need to copy manually.
Easy approach is:-
1. Install SQL 2000 with same service pack in new machine as old
2. Stop MSSQL Server and SQL Agent service is Old server as well as in new
server
3. Copy MDF and LDF files to the new server (Incluing system databases -
Master, msdb, tempdb, model),
It is a must that you should copy the folders to same folders
as in old server
4. Start MSSQl Server service in new server
5. Login to Query Analyzer in new machine and change the SQL server name
select @.@.servername
-- The name should be old server name
Execute below script to change the server name, this step is no required
if you do not want to change server name.
sp_dropserver <servername>
go
sp_addserver <newserver_name>,local
6. Stop and start MSSQL Server and SQl agent service. Login to Enterprise
manager and see whether all your databases are up.
Note:
Ensure that you install the new SQL server with the same directory structure
as old and copy the MDF and LDF to the same folders. otherwise the database
will not come online.
You can also look into the below links to move the databases.
move the data via backup and restore
http://support.microsoft.com/default...;en-us;Q304692
sp_detach_db and sp_attach_db
http://support.microsoft.com/support.../q224/0/71.asp
one more option -- the copy database wizard
http://support.microsoft.com/default...;en-us;Q274463
PRB: User Logon and/or Permission Errors After Restoring Dump (Q168001)
http://support.microsoft.com/default...;en-us;Q168001
Thanks
Hari
SQL Server MVP
"lau" <lau@.discussions.microsoft.com> wrote in message
news:66F50CDB-4DED-4E50-B7FE-45E0CE5AFCA4@.microsoft.com...
> Sorry if this is a stupid question , i'm a newbie to SQL server and MSDE.
> I
> read the installation manual but couldn't find the answer:-;
> Question:
> I've a server running MSDE latest patches etc.
> I just purchaced MS SQL server 2000 standaard edition.
> Does the installation of MS sql 2000 server takes care of copying and
> using
> the old MSDE database(s)?
> There is one application using MSDE with MSSQLSERVER as named instance, I
> Think :-?
>
> Or do i need to desintall MSDE?
> Thanks for the time
>
read the installation manual but couldn't find the answer:-;
Question:
I've a server running MSDE latest patches etc.
I just purchaced MS SQL server 2000 standaard edition.
Does the installation of MS sql 2000 server takes care of copying and using
the old MSDE database(s)?
There is one application using MSDE with MSSQLSERVER as named instance, I
Think :-?
Or do i need to desintall MSDE?
Thanks for the time
Hi,
SQL Server standard edition Installation will not copy the existing
databases. Databases
you need to copy manually.
Easy approach is:-
1. Install SQL 2000 with same service pack in new machine as old
2. Stop MSSQL Server and SQL Agent service is Old server as well as in new
server
3. Copy MDF and LDF files to the new server (Incluing system databases -
Master, msdb, tempdb, model),
It is a must that you should copy the folders to same folders
as in old server
4. Start MSSQl Server service in new server
5. Login to Query Analyzer in new machine and change the SQL server name
select @.@.servername
-- The name should be old server name
Execute below script to change the server name, this step is no required
if you do not want to change server name.
sp_dropserver <servername>
go
sp_addserver <newserver_name>,local
6. Stop and start MSSQL Server and SQl agent service. Login to Enterprise
manager and see whether all your databases are up.
Note:
Ensure that you install the new SQL server with the same directory structure
as old and copy the MDF and LDF to the same folders. otherwise the database
will not come online.
You can also look into the below links to move the databases.
move the data via backup and restore
http://support.microsoft.com/default...;en-us;Q304692
sp_detach_db and sp_attach_db
http://support.microsoft.com/support.../q224/0/71.asp
one more option -- the copy database wizard
http://support.microsoft.com/default...;en-us;Q274463
PRB: User Logon and/or Permission Errors After Restoring Dump (Q168001)
http://support.microsoft.com/default...;en-us;Q168001
Thanks
Hari
SQL Server MVP
"lau" <lau@.discussions.microsoft.com> wrote in message
news:66F50CDB-4DED-4E50-B7FE-45E0CE5AFCA4@.microsoft.com...
> Sorry if this is a stupid question , i'm a newbie to SQL server and MSDE.
> I
> read the installation manual but couldn't find the answer:-;
> Question:
> I've a server running MSDE latest patches etc.
> I just purchaced MS SQL server 2000 standaard edition.
> Does the installation of MS sql 2000 server takes care of copying and
> using
> the old MSDE database(s)?
> There is one application using MSDE with MSSQLSERVER as named instance, I
> Think :-?
>
> Or do i need to desintall MSDE?
> Thanks for the time
>
MSDE and installing MS SQL server 2000
Sorry if this is a stupid question , i'm a newbie to SQL server and MSDE. I
read the installation manual but couldn't find the answer:-;
Question:
I've a server running MSDE latest patches etc.
I just purchaced MS SQL server 2000 standaard edition.
Does the installation of MS sql 2000 server takes care of copying and using
the old MSDE database(s)?
There is one application using MSDE with MSSQLSERVER as named instance, I
Think :-?
Or do i need to desintall MSDE?
Thanks for the timeHi,
SQL Server standard edition Installation will not copy the existing
databases. Databases
you need to copy manually.
Easy approach is:-
1. Install SQL 2000 with same service pack in new machine as old
2. Stop MSSQL Server and SQL Agent service is Old server as well as in new
server
3. Copy MDF and LDF files to the new server (Incluing system databases -
Master, msdb, tempdb, model),
It is a must that you should copy the folders to same folders
as in old server
4. Start MSSQl Server service in new server
5. Login to Query Analyzer in new machine and change the SQL server name
select @.@.servername
-- The name should be old server name
Execute below script to change the server name, this step is no required
if you do not want to change server name.
sp_dropserver <servername>
go
sp_addserver <newserver_name>,local
6. Stop and start MSSQL Server and SQl agent service. Login to Enterprise
manager and see whether all your databases are up.
Note:
Ensure that you install the new SQL server with the same directory structure
as old and copy the MDF and LDF to the same folders. otherwise the database
will not come online.
----
--
You can also look into the below links to move the databases.
move the data via backup and restore
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q304692
sp_detach_db and sp_attach_db
http://support.microsoft.com/support/kb/articles/q224/0/71.asp
one more option -- the copy database wizard
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q274463
PRB: User Logon and/or Permission Errors After Restoring Dump (Q168001)
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q168001
Thanks
Hari
SQL Server MVP
"lau" <lau@.discussions.microsoft.com> wrote in message
news:66F50CDB-4DED-4E50-B7FE-45E0CE5AFCA4@.microsoft.com...
> Sorry if this is a stupid question , i'm a newbie to SQL server and MSDE.
> I
> read the installation manual but couldn't find the answer:-;
> Question:
> I've a server running MSDE latest patches etc.
> I just purchaced MS SQL server 2000 standaard edition.
> Does the installation of MS sql 2000 server takes care of copying and
> using
> the old MSDE database(s)?
> There is one application using MSDE with MSSQLSERVER as named instance, I
> Think :-?
>
> Or do i need to desintall MSDE?
> Thanks for the time
>
read the installation manual but couldn't find the answer:-;
Question:
I've a server running MSDE latest patches etc.
I just purchaced MS SQL server 2000 standaard edition.
Does the installation of MS sql 2000 server takes care of copying and using
the old MSDE database(s)?
There is one application using MSDE with MSSQLSERVER as named instance, I
Think :-?
Or do i need to desintall MSDE?
Thanks for the timeHi,
SQL Server standard edition Installation will not copy the existing
databases. Databases
you need to copy manually.
Easy approach is:-
1. Install SQL 2000 with same service pack in new machine as old
2. Stop MSSQL Server and SQL Agent service is Old server as well as in new
server
3. Copy MDF and LDF files to the new server (Incluing system databases -
Master, msdb, tempdb, model),
It is a must that you should copy the folders to same folders
as in old server
4. Start MSSQl Server service in new server
5. Login to Query Analyzer in new machine and change the SQL server name
select @.@.servername
-- The name should be old server name
Execute below script to change the server name, this step is no required
if you do not want to change server name.
sp_dropserver <servername>
go
sp_addserver <newserver_name>,local
6. Stop and start MSSQL Server and SQl agent service. Login to Enterprise
manager and see whether all your databases are up.
Note:
Ensure that you install the new SQL server with the same directory structure
as old and copy the MDF and LDF to the same folders. otherwise the database
will not come online.
----
--
You can also look into the below links to move the databases.
move the data via backup and restore
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q304692
sp_detach_db and sp_attach_db
http://support.microsoft.com/support/kb/articles/q224/0/71.asp
one more option -- the copy database wizard
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q274463
PRB: User Logon and/or Permission Errors After Restoring Dump (Q168001)
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q168001
Thanks
Hari
SQL Server MVP
"lau" <lau@.discussions.microsoft.com> wrote in message
news:66F50CDB-4DED-4E50-B7FE-45E0CE5AFCA4@.microsoft.com...
> Sorry if this is a stupid question , i'm a newbie to SQL server and MSDE.
> I
> read the installation manual but couldn't find the answer:-;
> Question:
> I've a server running MSDE latest patches etc.
> I just purchaced MS SQL server 2000 standaard edition.
> Does the installation of MS sql 2000 server takes care of copying and
> using
> the old MSDE database(s)?
> There is one application using MSDE with MSSQLSERVER as named instance, I
> Think :-?
>
> Or do i need to desintall MSDE?
> Thanks for the time
>
MSDE and installing MS SQL server 2000
Sorry if this is a stupid question , i'm a newbie to SQL server and MSDE. I
read the installation manual but couldn't find the answer:-;
Question:
I've a server running MSDE latest patches etc.
I just purchaced MS SQL server 2000 standaard edition.
Does the installation of MS sql 2000 server takes care of copying and using
the old MSDE database(s)?
There is one application using MSDE with MSSQLSERVER as named instance, I
Think :-?
Or do i need to desintall MSDE?
Thanks for the timeHi,
SQL Server standard edition Installation will not copy the existing
databases. Databases
you need to copy manually.
Easy approach is:-
1. Install SQL 2000 with same service pack in new machine as old
2. Stop MSSQL Server and SQL Agent service is Old server as well as in new
server
3. Copy MDF and LDF files to the new server (Incluing system databases -
Master, msdb, tempdb, model),
It is a must that you should copy the folders to same folders
as in old server
4. Start MSSQl Server service in new server
5. Login to Query Analyzer in new machine and change the SQL server name
select @.@.servername
-- The name should be old server name
Execute below script to change the server name, this step is no required
if you do not want to change server name.
sp_dropserver <servername>
go
sp_addserver <newserver_name>,local
6. Stop and start MSSQL Server and SQl agent service. Login to Enterprise
manager and see whether all your databases are up.
Note:
Ensure that you install the new SQL server with the same directory structure
as old and copy the MDF and LDF to the same folders. otherwise the database
will not come online.
----
--
You can also look into the below links to move the databases.
move the data via backup and restore
http://support.microsoft.com/defaul...b;en-us;Q304692
sp_detach_db and sp_attach_db
http://support.microsoft.com/suppor...s/q224/0/71.asp
one more option -- the copy database wizard
http://support.microsoft.com/defaul...b;en-us;Q274463
PRB: User Logon and/or Permission Errors After Restoring Dump (Q168001)
http://support.microsoft.com/defaul...b;en-us;Q168001
Thanks
Hari
SQL Server MVP
"lau" <lau@.discussions.microsoft.com> wrote in message
news:66F50CDB-4DED-4E50-B7FE-45E0CE5AFCA4@.microsoft.com...
> Sorry if this is a stupid question , i'm a newbie to SQL server and MSDE.
> I
> read the installation manual but couldn't find the answer:-;
> Question:
> I've a server running MSDE latest patches etc.
> I just purchaced MS SQL server 2000 standaard edition.
> Does the installation of MS sql 2000 server takes care of copying and
> using
> the old MSDE database(s)?
> There is one application using MSDE with MSSQLSERVER as named instance, I
> Think :-?
>
> Or do i need to desintall MSDE?
> Thanks for the time
>
read the installation manual but couldn't find the answer:-;
Question:
I've a server running MSDE latest patches etc.
I just purchaced MS SQL server 2000 standaard edition.
Does the installation of MS sql 2000 server takes care of copying and using
the old MSDE database(s)?
There is one application using MSDE with MSSQLSERVER as named instance, I
Think :-?
Or do i need to desintall MSDE?
Thanks for the timeHi,
SQL Server standard edition Installation will not copy the existing
databases. Databases
you need to copy manually.
Easy approach is:-
1. Install SQL 2000 with same service pack in new machine as old
2. Stop MSSQL Server and SQL Agent service is Old server as well as in new
server
3. Copy MDF and LDF files to the new server (Incluing system databases -
Master, msdb, tempdb, model),
It is a must that you should copy the folders to same folders
as in old server
4. Start MSSQl Server service in new server
5. Login to Query Analyzer in new machine and change the SQL server name
select @.@.servername
-- The name should be old server name
Execute below script to change the server name, this step is no required
if you do not want to change server name.
sp_dropserver <servername>
go
sp_addserver <newserver_name>,local
6. Stop and start MSSQL Server and SQl agent service. Login to Enterprise
manager and see whether all your databases are up.
Note:
Ensure that you install the new SQL server with the same directory structure
as old and copy the MDF and LDF to the same folders. otherwise the database
will not come online.
----
--
You can also look into the below links to move the databases.
move the data via backup and restore
http://support.microsoft.com/defaul...b;en-us;Q304692
sp_detach_db and sp_attach_db
http://support.microsoft.com/suppor...s/q224/0/71.asp
one more option -- the copy database wizard
http://support.microsoft.com/defaul...b;en-us;Q274463
PRB: User Logon and/or Permission Errors After Restoring Dump (Q168001)
http://support.microsoft.com/defaul...b;en-us;Q168001
Thanks
Hari
SQL Server MVP
"lau" <lau@.discussions.microsoft.com> wrote in message
news:66F50CDB-4DED-4E50-B7FE-45E0CE5AFCA4@.microsoft.com...
> Sorry if this is a stupid question , i'm a newbie to SQL server and MSDE.
> I
> read the installation manual but couldn't find the answer:-;
> Question:
> I've a server running MSDE latest patches etc.
> I just purchaced MS SQL server 2000 standaard edition.
> Does the installation of MS sql 2000 server takes care of copying and
> using
> the old MSDE database(s)?
> There is one application using MSDE with MSSQLSERVER as named instance, I
> Think :-?
>
> Or do i need to desintall MSDE?
> Thanks for the time
>
MSDE and Imaging
Can the MSDE be included within a base XP image without
issue. I know that putting SQL on an image is a no-no.
Just wanted to hear if the MSDE can be included on an
image.
"Ismael" <ismael.alfaro@.gametop.com> wrote in message
news:1fd501c4ff01$0edfe1a0$a501280a@.phx.gbl...
> Can the MSDE be included within a base XP image without
> issue. I know that putting SQL on an image is a no-no.
> Just wanted to hear if the MSDE can be included on an
> image.
I don't see an issue with that. I'd set the mssqlserver service to run as
'local system', in that way you won't need to be concerned with service
accounts, or SID issues.
Steve
issue. I know that putting SQL on an image is a no-no.
Just wanted to hear if the MSDE can be included on an
image.
"Ismael" <ismael.alfaro@.gametop.com> wrote in message
news:1fd501c4ff01$0edfe1a0$a501280a@.phx.gbl...
> Can the MSDE be included within a base XP image without
> issue. I know that putting SQL on an image is a no-no.
> Just wanted to hear if the MSDE can be included on an
> image.
I don't see an issue with that. I'd set the mssqlserver service to run as
'local system', in that way you won't need to be concerned with service
accounts, or SID issues.
Steve
MSDE and IIS - Web Hosting
In trying to get around the current Jet hang problem people are seeing under
Windows 2003 and the jet oledb provider, we have ended up having to convert
many existing MS Access web site projects to MSDE.
The clients don't have the budgets to license full sql server, and don't
need the full performance you see there versus the "limiters" put into MSDE,
so we have gone this route until the jet hang problem is resolved.
My question is: what are the memory and/or performance issues when MSDE is
installed on a web server providing db services to multiple sites? I mean,
is it just one instance of MSDE running and providing all db services, or is
it doing anything less efficient other than the limiters it has in place?
How many instances of sqlservr.exe processes should I see - just one right?
What mem usage should it be using? Is the usage based on the number of
databases and activity, or will it try to grab a certain percentage of all
memory available?
Any new info on the infamous jet oledb hang problem? I opened (and paid) a
ticket with MS and they sent something to test but it didn't work and I
haven't heard back since - that was months ago.
Thanks,
Kevin
hi Kevin,
"valkev" <nospam@.4me.com> ha scritto nel messaggio
news:0bCDc.9073$Ey3.2483@.newssvr24.news.prodigy.co m...
> ...
> My question is: what are the memory and/or performance issues when MSDE is
> installed on a web server providing db services to multiple sites? I
mean,
> is it just one instance of MSDE running and providing all db services, or
is
> it doing anything less efficient other than the limiters it has in place?
>
running a database server on the same machine of a web server always hits
some penalty...
the Workload Query Governor will hit when more then 8 concurrent batches are
run on the very same time, slowing down all active workloads, reverting to
normal behaviour when the concurrent batches gets again under 8 batches, but
this is not regarding memory usage...
SQL Server/MSDE is very hungry, regarding memory...
memory usage is database and application dependent, but usage and workloads
dependent too...
as you know, in few words, SQL Server organize it's memory allocation in two
distinct regions, the "buffer pool" (BPool) and the "memory to leave"
(MemToLeave) regions. (I'm excluding use of AWE in order to provide easy
understanding)
so... the BPool is the primary region SQL Server uses for it's internal
matter, while MemToLeave consists of the virtual memory space within the 1gb
user mode address space and the memory not used by the BPool.
when SQL Server starts, it begins calculating the upper limit the BPool can
reach... if no MaxMemory is set, this value will be set to the amount of the
physical memory or the size of the user mode address space (1gb) , minus the
size of the MemToLeave, whichever is less..
by default, MemToLeave is set to 384mb, 128mb of them are for worker thread
stacks and 256mb for allocation outside the BPool, such as memory for OLE-DB
providers, in process COM objects space and memory requirements and so on..
when MaxMemory value is explicitally set, this upper limit will only address
BPool region needs...
so only the address space of BPool pages is limited by this configuration
value, while SQL Server memory requirememts outside BPool allocation are not
limited this way...
but you are not limiting the resource, so SQL Server can reclaim that memory
(up to 1 gb, in our example) for it's uses, and it will perhaps release it
only under pressure by the OS claiming for additional memory, if it's the
case, else it will maintain that memory in order to cache pages and
execution plans...
under OS pressure, SQL Server will try having the Lazy Writer releases
resources, but you are not granted that this will occur, even if SQL Server
will always try to leave some memory for other OS needs, usually between 4
and 10mb of RAM... so, on SQL Server dedicated servers, you usually see
memory usage climbing to the top and stayng there for long time, becouse of
SQL Server tends to keep pages read from disk in memory to increase further
and successive access to those pages, as long as query plans and so on... on
a heavy loaded server, if you add web server duty, you will have resource
contentions for sure...
> How many instances of sqlservr.exe processes should I see - just one
right?
as many as you installed and started...
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 Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2k8s2kF17hgbiU1@.uni-berlin.de...[vbcol=seagreen]
> hi Kevin,
> "valkev" <nospam@.4me.com> ha scritto nel messaggio
> news:0bCDc.9073$Ey3.2483@.newssvr24.news.prodigy.co m...
is[vbcol=seagreen]
> mean,
or[vbcol=seagreen]
> is
place?
> running a database server on the same machine of a web server always hits
> some penalty...
> the Workload Query Governor will hit when more then 8 concurrent batches
are
> run on the very same time, slowing down all active workloads, reverting to
> normal behaviour when the concurrent batches gets again under 8 batches,
but
> this is not regarding memory usage...
> SQL Server/MSDE is very hungry, regarding memory...
> memory usage is database and application dependent, but usage and
workloads
> dependent too...
> as you know, in few words, SQL Server organize it's memory allocation in
two
> distinct regions, the "buffer pool" (BPool) and the "memory to leave"
> (MemToLeave) regions. (I'm excluding use of AWE in order to provide easy
> understanding)
> so... the BPool is the primary region SQL Server uses for it's internal
> matter, while MemToLeave consists of the virtual memory space within the
1gb
> user mode address space and the memory not used by the BPool.
> when SQL Server starts, it begins calculating the upper limit the BPool
can
> reach... if no MaxMemory is set, this value will be set to the amount of
the
> physical memory or the size of the user mode address space (1gb) , minus
the
> size of the MemToLeave, whichever is less..
> by default, MemToLeave is set to 384mb, 128mb of them are for worker
thread
> stacks and 256mb for allocation outside the BPool, such as memory for
OLE-DB
> providers, in process COM objects space and memory requirements and so
on..
> when MaxMemory value is explicitally set, this upper limit will only
address
> BPool region needs...
> so only the address space of BPool pages is limited by this configuration
> value, while SQL Server memory requirememts outside BPool allocation are
not
> limited this way...
> but you are not limiting the resource, so SQL Server can reclaim that
memory
> (up to 1 gb, in our example) for it's uses, and it will perhaps release it
> only under pressure by the OS claiming for additional memory, if it's the
> case, else it will maintain that memory in order to cache pages and
> execution plans...
> under OS pressure, SQL Server will try having the Lazy Writer releases
> resources, but you are not granted that this will occur, even if SQL
Server
> will always try to leave some memory for other OS needs, usually between 4
> and 10mb of RAM... so, on SQL Server dedicated servers, you usually see
> memory usage climbing to the top and stayng there for long time, becouse
of
> SQL Server tends to keep pages read from disk in memory to increase
further
> and successive access to those pages, as long as query plans and so on...
on
> a heavy loaded server, if you add web server duty, you will have resource
> contentions for sure...
>
> right?
> as many as you installed and started...
> --
> 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,
Thanks for the great info. Your explanation is consistent with what I'm
seeing.
So, the only real performance difference seen going from MSDE to SQL Server
is that the Workload Query Governor will not be kicking in and slowing
things down on active installations correct? Isn't this governor on the
order of milliseconds?
Thanks,
Kevin
|||Hi Kevin,
The Workload Governor on MSDE is somewhat more serious than a matter of
milliseconds. Basically it is supposed to give MSDE approximately the same
performance characteristics as Access, i.e. 20 concurrent users is about the
most you will get. Of course how this will work in your specific situation
you have to test yourself.
But as you are moving from Access to MSDE, MSDE should perform sufficiently
ok. If you already had performance problems on Access, MSDE probably won't
solve these though.
Jacco Schalkwijk
SQL Server MVP
"valkev" <nospam@.4me.com> wrote in message
news:euLDc.9211$%l7.3730@.newssvr24.news.prodigy.co m...[vbcol=seagreen]
> "Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
> news:2k8s2kF17hgbiU1@.uni-berlin.de...
MSDE[vbcol=seagreen]
> is
> or
> place?
hits[vbcol=seagreen]
> are
to[vbcol=seagreen]
> but
> workloads
> two
> 1gb
> can
> the
> the
> thread
> OLE-DB
> on..
> address
configuration[vbcol=seagreen]
> not
> memory
it[vbcol=seagreen]
the[vbcol=seagreen]
> Server
4[vbcol=seagreen]
> of
> further
on...[vbcol=seagreen]
> on
resource
> Andrea,
> Thanks for the great info. Your explanation is consistent with what I'm
> seeing.
> So, the only real performance difference seen going from MSDE to SQL
Server
> is that the Workload Query Governor will not be kicking in and slowing
> things down on active installations correct? Isn't this governor on the
> order of milliseconds?
> Thanks,
> Kevin
>
|||Thanks Jacco.
Yeah it's kind of funny. Under Access and IIS4 running on NT, we had some
sites getting over 3M hits per month and MOST of those hits were on
db-driven pages! The Access db itself might get as big as say 10MB in size.
And we had NO problems.
Then, when going to Windows 2003 Server and running very SMALL sites using
Access, we immediately ran into this Jet OLEDB hang problem and basically
nothing runs under Access on a new latest-greatest server. Submitte a
ticket, got a little response and a dll thrown at me which didn't help any,
and haven't heard since.
So, any db needs I have for sites on this particular server we're just
coding for MSDE instead of Access because it's really our only option.
I have PHP and MySQL installed on the server, and really want to jump into
mySQL to see how it compares to Access and MSDE and SQL Server but just
haven't had the time. I suspect it will perform somewhat like MSDE, faster
because of the governors, but not as well as SQL Server who knows. My
experience is Windows, SQL Server, SQL Enterprise, stored procedures, et al
so not sure how much I'll end up doing in mySQL UNLESS I foresee getting so
many new db-driven sites that we can't afford to move to SQL Server over
MSDE and so would need to go the mySQL route.
Decision decisions.
Thanks,
Kevin
"Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid > wrote
in message news:uaN2pGQXEHA.1036@.TK2MSFTNGP10.phx.gbl...
> Hi Kevin,
> The Workload Governor on MSDE is somewhat more serious than a matter of
> milliseconds. Basically it is supposed to give MSDE approximately the same
> performance characteristics as Access, i.e. 20 concurrent users is about
the
> most you will get. Of course how this will work in your specific situation
> you have to test yourself.
> But as you are moving from Access to MSDE, MSDE should perform
sufficiently[vbcol=seagreen]
> ok. If you already had performance problems on Access, MSDE probably won't
> solve these though.
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "valkev" <nospam@.4me.com> wrote in message
> news:euLDc.9211$%l7.3730@.newssvr24.news.prodigy.co m...
> MSDE
I[vbcol=seagreen]
services,[vbcol=seagreen]
> hits
batches[vbcol=seagreen]
reverting[vbcol=seagreen]
> to
batches,[vbcol=seagreen]
in[vbcol=seagreen]
easy[vbcol=seagreen]
internal[vbcol=seagreen]
the[vbcol=seagreen]
BPool[vbcol=seagreen]
of[vbcol=seagreen]
minus[vbcol=seagreen]
> configuration
are[vbcol=seagreen]
release[vbcol=seagreen]
> it
> the
between[vbcol=seagreen]
> 4
see[vbcol=seagreen]
becouse[vbcol=seagreen]
> on...
> resource
visual
> Server
>
|||Thanks Jacco.
Yeah it's kind of funny. Under Access and IIS4 running on NT, we had some
sites getting over 3M hits per month and MOST of those hits were on
db-driven pages! The Access db itself might get as big as say 10MB in size.
And we had NO problems.
Then, when going to Windows 2003 Server and running very SMALL sites using
Access, we immediately ran into this Jet OLEDB hang problem and basically
nothing runs under Access on a new latest-greatest server. Submitte a
ticket, got a little response and a dll thrown at me which didn't help any,
and haven't heard since.
So, any db needs I have for sites on this particular server we're just
coding for MSDE instead of Access because it's really our only option.
I have PHP and MySQL installed on the server, and really want to jump into
mySQL to see how it compares to Access and MSDE and SQL Server but just
haven't had the time. I suspect it will perform somewhat like MSDE, faster
because of the governors, but not as well as SQL Server who knows. My
experience is Windows, SQL Server, SQL Enterprise, stored procedures, et al
so not sure how much I'll end up doing in mySQL UNLESS I foresee getting so
many new db-driven sites that we can't afford to move to SQL Server over
MSDE and so would need to go the mySQL route.
Decision decisions.
Thanks,
Kevin
"Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid > wrote
in message news:uaN2pGQXEHA.1036@.TK2MSFTNGP10.phx.gbl...
> Hi Kevin,
> The Workload Governor on MSDE is somewhat more serious than a matter of
> milliseconds. Basically it is supposed to give MSDE approximately the same
> performance characteristics as Access, i.e. 20 concurrent users is about
the
> most you will get. Of course how this will work in your specific situation
> you have to test yourself.
> But as you are moving from Access to MSDE, MSDE should perform
sufficiently[vbcol=seagreen]
> ok. If you already had performance problems on Access, MSDE probably won't
> solve these though.
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "valkev" <nospam@.4me.com> wrote in message
> news:euLDc.9211$%l7.3730@.newssvr24.news.prodigy.co m...
> MSDE
I[vbcol=seagreen]
services,[vbcol=seagreen]
> hits
batches[vbcol=seagreen]
reverting[vbcol=seagreen]
> to
batches,[vbcol=seagreen]
in[vbcol=seagreen]
easy[vbcol=seagreen]
internal[vbcol=seagreen]
the[vbcol=seagreen]
BPool[vbcol=seagreen]
of[vbcol=seagreen]
minus[vbcol=seagreen]
> configuration
are[vbcol=seagreen]
release[vbcol=seagreen]
> it
> the
between[vbcol=seagreen]
> 4
see[vbcol=seagreen]
becouse[vbcol=seagreen]
> on...
> resource
visual
> Server
>
|||Don't assume you can't afford SQL Server over MySQL. MySQL is Open Source,
but it is not free, an entry level tech support contract is ?1500/year, the
most expensive support contract with MySQL is ?48,000 per year. Compare that
with SQL Server licenses.
Jacco Schalkwijk
SQL Server MVP
"valkev" <nospam@.4me.com> wrote in message
news:0V4Ec.9708$9w2.1928@.newssvr24.news.prodigy.co m...
> Thanks Jacco.
> Yeah it's kind of funny. Under Access and IIS4 running on NT, we had some
> sites getting over 3M hits per month and MOST of those hits were on
> db-driven pages! The Access db itself might get as big as say 10MB in
size.
> And we had NO problems.
> Then, when going to Windows 2003 Server and running very SMALL sites using
> Access, we immediately ran into this Jet OLEDB hang problem and basically
> nothing runs under Access on a new latest-greatest server. Submitte a
> ticket, got a little response and a dll thrown at me which didn't help
any,
> and haven't heard since.
> So, any db needs I have for sites on this particular server we're just
> coding for MSDE instead of Access because it's really our only option.
> I have PHP and MySQL installed on the server, and really want to jump into
> mySQL to see how it compares to Access and MSDE and SQL Server but just
> haven't had the time. I suspect it will perform somewhat like MSDE,
faster
> because of the governors, but not as well as SQL Server who knows. My
> experience is Windows, SQL Server, SQL Enterprise, stored procedures, et
al
> so not sure how much I'll end up doing in mySQL UNLESS I foresee getting
so
> many new db-driven sites that we can't afford to move to SQL Server over
> MSDE and so would need to go the mySQL route.
> Decision decisions.
> Thanks,
> Kevin
>
> "Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid >
wrote[vbcol=seagreen]
> in message news:uaN2pGQXEHA.1036@.TK2MSFTNGP10.phx.gbl...
same[vbcol=seagreen]
> the
situation[vbcol=seagreen]
> sufficiently
won't[vbcol=seagreen]
> I
> services,
> batches
> reverting
> batches,
allocation[vbcol=seagreen]
> in
leave"[vbcol=seagreen]
> easy
> internal
> the
> BPool
amount[vbcol=seagreen]
> of
> minus
for[vbcol=seagreen]
so[vbcol=seagreen]
> are
that[vbcol=seagreen]
> release
it's[vbcol=seagreen]
releases[vbcol=seagreen]
> between
> see
> becouse
one[vbcol=seagreen]
> visual
I'm[vbcol=seagreen]
the
>
|||Don't assume you can't afford SQL Server over MySQL. MySQL is Open Source,
but it is not free, an entry level tech support contract is ?1500/year, the
most expensive support contract with MySQL is ?48,000 per year. Compare that
with SQL Server licenses.
Jacco Schalkwijk
SQL Server MVP
"valkev" <nospam@.4me.com> wrote in message
news:0V4Ec.9708$9w2.1928@.newssvr24.news.prodigy.co m...
> Thanks Jacco.
> Yeah it's kind of funny. Under Access and IIS4 running on NT, we had some
> sites getting over 3M hits per month and MOST of those hits were on
> db-driven pages! The Access db itself might get as big as say 10MB in
size.
> And we had NO problems.
> Then, when going to Windows 2003 Server and running very SMALL sites using
> Access, we immediately ran into this Jet OLEDB hang problem and basically
> nothing runs under Access on a new latest-greatest server. Submitte a
> ticket, got a little response and a dll thrown at me which didn't help
any,
> and haven't heard since.
> So, any db needs I have for sites on this particular server we're just
> coding for MSDE instead of Access because it's really our only option.
> I have PHP and MySQL installed on the server, and really want to jump into
> mySQL to see how it compares to Access and MSDE and SQL Server but just
> haven't had the time. I suspect it will perform somewhat like MSDE,
faster
> because of the governors, but not as well as SQL Server who knows. My
> experience is Windows, SQL Server, SQL Enterprise, stored procedures, et
al
> so not sure how much I'll end up doing in mySQL UNLESS I foresee getting
so
> many new db-driven sites that we can't afford to move to SQL Server over
> MSDE and so would need to go the mySQL route.
> Decision decisions.
> Thanks,
> Kevin
>
> "Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid >
wrote[vbcol=seagreen]
> in message news:uaN2pGQXEHA.1036@.TK2MSFTNGP10.phx.gbl...
same[vbcol=seagreen]
> the
situation[vbcol=seagreen]
> sufficiently
won't[vbcol=seagreen]
> I
> services,
> batches
> reverting
> batches,
allocation[vbcol=seagreen]
> in
leave"[vbcol=seagreen]
> easy
> internal
> the
> BPool
amount[vbcol=seagreen]
> of
> minus
for[vbcol=seagreen]
so[vbcol=seagreen]
> are
that[vbcol=seagreen]
> release
it's[vbcol=seagreen]
releases[vbcol=seagreen]
> between
> see
> becouse
one[vbcol=seagreen]
> visual
I'm[vbcol=seagreen]
the
>
sql
Windows 2003 and the jet oledb provider, we have ended up having to convert
many existing MS Access web site projects to MSDE.
The clients don't have the budgets to license full sql server, and don't
need the full performance you see there versus the "limiters" put into MSDE,
so we have gone this route until the jet hang problem is resolved.
My question is: what are the memory and/or performance issues when MSDE is
installed on a web server providing db services to multiple sites? I mean,
is it just one instance of MSDE running and providing all db services, or is
it doing anything less efficient other than the limiters it has in place?
How many instances of sqlservr.exe processes should I see - just one right?
What mem usage should it be using? Is the usage based on the number of
databases and activity, or will it try to grab a certain percentage of all
memory available?
Any new info on the infamous jet oledb hang problem? I opened (and paid) a
ticket with MS and they sent something to test but it didn't work and I
haven't heard back since - that was months ago.
Thanks,
Kevin
hi Kevin,
"valkev" <nospam@.4me.com> ha scritto nel messaggio
news:0bCDc.9073$Ey3.2483@.newssvr24.news.prodigy.co m...
> ...
> My question is: what are the memory and/or performance issues when MSDE is
> installed on a web server providing db services to multiple sites? I
mean,
> is it just one instance of MSDE running and providing all db services, or
is
> it doing anything less efficient other than the limiters it has in place?
>
running a database server on the same machine of a web server always hits
some penalty...
the Workload Query Governor will hit when more then 8 concurrent batches are
run on the very same time, slowing down all active workloads, reverting to
normal behaviour when the concurrent batches gets again under 8 batches, but
this is not regarding memory usage...
SQL Server/MSDE is very hungry, regarding memory...
memory usage is database and application dependent, but usage and workloads
dependent too...
as you know, in few words, SQL Server organize it's memory allocation in two
distinct regions, the "buffer pool" (BPool) and the "memory to leave"
(MemToLeave) regions. (I'm excluding use of AWE in order to provide easy
understanding)
so... the BPool is the primary region SQL Server uses for it's internal
matter, while MemToLeave consists of the virtual memory space within the 1gb
user mode address space and the memory not used by the BPool.
when SQL Server starts, it begins calculating the upper limit the BPool can
reach... if no MaxMemory is set, this value will be set to the amount of the
physical memory or the size of the user mode address space (1gb) , minus the
size of the MemToLeave, whichever is less..
by default, MemToLeave is set to 384mb, 128mb of them are for worker thread
stacks and 256mb for allocation outside the BPool, such as memory for OLE-DB
providers, in process COM objects space and memory requirements and so on..
when MaxMemory value is explicitally set, this upper limit will only address
BPool region needs...
so only the address space of BPool pages is limited by this configuration
value, while SQL Server memory requirememts outside BPool allocation are not
limited this way...
but you are not limiting the resource, so SQL Server can reclaim that memory
(up to 1 gb, in our example) for it's uses, and it will perhaps release it
only under pressure by the OS claiming for additional memory, if it's the
case, else it will maintain that memory in order to cache pages and
execution plans...
under OS pressure, SQL Server will try having the Lazy Writer releases
resources, but you are not granted that this will occur, even if SQL Server
will always try to leave some memory for other OS needs, usually between 4
and 10mb of RAM... so, on SQL Server dedicated servers, you usually see
memory usage climbing to the top and stayng there for long time, becouse of
SQL Server tends to keep pages read from disk in memory to increase further
and successive access to those pages, as long as query plans and so on... on
a heavy loaded server, if you add web server duty, you will have resource
contentions for sure...
> How many instances of sqlservr.exe processes should I see - just one
right?
as many as you installed and started...
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 Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2k8s2kF17hgbiU1@.uni-berlin.de...[vbcol=seagreen]
> hi Kevin,
> "valkev" <nospam@.4me.com> ha scritto nel messaggio
> news:0bCDc.9073$Ey3.2483@.newssvr24.news.prodigy.co m...
is[vbcol=seagreen]
> mean,
or[vbcol=seagreen]
> is
place?
> running a database server on the same machine of a web server always hits
> some penalty...
> the Workload Query Governor will hit when more then 8 concurrent batches
are
> run on the very same time, slowing down all active workloads, reverting to
> normal behaviour when the concurrent batches gets again under 8 batches,
but
> this is not regarding memory usage...
> SQL Server/MSDE is very hungry, regarding memory...
> memory usage is database and application dependent, but usage and
workloads
> dependent too...
> as you know, in few words, SQL Server organize it's memory allocation in
two
> distinct regions, the "buffer pool" (BPool) and the "memory to leave"
> (MemToLeave) regions. (I'm excluding use of AWE in order to provide easy
> understanding)
> so... the BPool is the primary region SQL Server uses for it's internal
> matter, while MemToLeave consists of the virtual memory space within the
1gb
> user mode address space and the memory not used by the BPool.
> when SQL Server starts, it begins calculating the upper limit the BPool
can
> reach... if no MaxMemory is set, this value will be set to the amount of
the
> physical memory or the size of the user mode address space (1gb) , minus
the
> size of the MemToLeave, whichever is less..
> by default, MemToLeave is set to 384mb, 128mb of them are for worker
thread
> stacks and 256mb for allocation outside the BPool, such as memory for
OLE-DB
> providers, in process COM objects space and memory requirements and so
on..
> when MaxMemory value is explicitally set, this upper limit will only
address
> BPool region needs...
> so only the address space of BPool pages is limited by this configuration
> value, while SQL Server memory requirememts outside BPool allocation are
not
> limited this way...
> but you are not limiting the resource, so SQL Server can reclaim that
memory
> (up to 1 gb, in our example) for it's uses, and it will perhaps release it
> only under pressure by the OS claiming for additional memory, if it's the
> case, else it will maintain that memory in order to cache pages and
> execution plans...
> under OS pressure, SQL Server will try having the Lazy Writer releases
> resources, but you are not granted that this will occur, even if SQL
Server
> will always try to leave some memory for other OS needs, usually between 4
> and 10mb of RAM... so, on SQL Server dedicated servers, you usually see
> memory usage climbing to the top and stayng there for long time, becouse
of
> SQL Server tends to keep pages read from disk in memory to increase
further
> and successive access to those pages, as long as query plans and so on...
on
> a heavy loaded server, if you add web server duty, you will have resource
> contentions for sure...
>
> right?
> as many as you installed and started...
> --
> 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,
Thanks for the great info. Your explanation is consistent with what I'm
seeing.
So, the only real performance difference seen going from MSDE to SQL Server
is that the Workload Query Governor will not be kicking in and slowing
things down on active installations correct? Isn't this governor on the
order of milliseconds?
Thanks,
Kevin
|||Hi Kevin,
The Workload Governor on MSDE is somewhat more serious than a matter of
milliseconds. Basically it is supposed to give MSDE approximately the same
performance characteristics as Access, i.e. 20 concurrent users is about the
most you will get. Of course how this will work in your specific situation
you have to test yourself.
But as you are moving from Access to MSDE, MSDE should perform sufficiently
ok. If you already had performance problems on Access, MSDE probably won't
solve these though.
Jacco Schalkwijk
SQL Server MVP
"valkev" <nospam@.4me.com> wrote in message
news:euLDc.9211$%l7.3730@.newssvr24.news.prodigy.co m...[vbcol=seagreen]
> "Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
> news:2k8s2kF17hgbiU1@.uni-berlin.de...
MSDE[vbcol=seagreen]
> is
> or
> place?
hits[vbcol=seagreen]
> are
to[vbcol=seagreen]
> but
> workloads
> two
> 1gb
> can
> the
> the
> thread
> OLE-DB
> on..
> address
configuration[vbcol=seagreen]
> not
> memory
it[vbcol=seagreen]
the[vbcol=seagreen]
> Server
4[vbcol=seagreen]
> of
> further
on...[vbcol=seagreen]
> on
resource
> Andrea,
> Thanks for the great info. Your explanation is consistent with what I'm
> seeing.
> So, the only real performance difference seen going from MSDE to SQL
Server
> is that the Workload Query Governor will not be kicking in and slowing
> things down on active installations correct? Isn't this governor on the
> order of milliseconds?
> Thanks,
> Kevin
>
|||Thanks Jacco.
Yeah it's kind of funny. Under Access and IIS4 running on NT, we had some
sites getting over 3M hits per month and MOST of those hits were on
db-driven pages! The Access db itself might get as big as say 10MB in size.
And we had NO problems.
Then, when going to Windows 2003 Server and running very SMALL sites using
Access, we immediately ran into this Jet OLEDB hang problem and basically
nothing runs under Access on a new latest-greatest server. Submitte a
ticket, got a little response and a dll thrown at me which didn't help any,
and haven't heard since.
So, any db needs I have for sites on this particular server we're just
coding for MSDE instead of Access because it's really our only option.
I have PHP and MySQL installed on the server, and really want to jump into
mySQL to see how it compares to Access and MSDE and SQL Server but just
haven't had the time. I suspect it will perform somewhat like MSDE, faster
because of the governors, but not as well as SQL Server who knows. My
experience is Windows, SQL Server, SQL Enterprise, stored procedures, et al
so not sure how much I'll end up doing in mySQL UNLESS I foresee getting so
many new db-driven sites that we can't afford to move to SQL Server over
MSDE and so would need to go the mySQL route.
Decision decisions.
Thanks,
Kevin
"Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid > wrote
in message news:uaN2pGQXEHA.1036@.TK2MSFTNGP10.phx.gbl...
> Hi Kevin,
> The Workload Governor on MSDE is somewhat more serious than a matter of
> milliseconds. Basically it is supposed to give MSDE approximately the same
> performance characteristics as Access, i.e. 20 concurrent users is about
the
> most you will get. Of course how this will work in your specific situation
> you have to test yourself.
> But as you are moving from Access to MSDE, MSDE should perform
sufficiently[vbcol=seagreen]
> ok. If you already had performance problems on Access, MSDE probably won't
> solve these though.
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "valkev" <nospam@.4me.com> wrote in message
> news:euLDc.9211$%l7.3730@.newssvr24.news.prodigy.co m...
> MSDE
I[vbcol=seagreen]
services,[vbcol=seagreen]
> hits
batches[vbcol=seagreen]
reverting[vbcol=seagreen]
> to
batches,[vbcol=seagreen]
in[vbcol=seagreen]
easy[vbcol=seagreen]
internal[vbcol=seagreen]
the[vbcol=seagreen]
BPool[vbcol=seagreen]
of[vbcol=seagreen]
minus[vbcol=seagreen]
> configuration
are[vbcol=seagreen]
release[vbcol=seagreen]
> it
> the
between[vbcol=seagreen]
> 4
see[vbcol=seagreen]
becouse[vbcol=seagreen]
> on...
> resource
visual
> Server
>
|||Thanks Jacco.
Yeah it's kind of funny. Under Access and IIS4 running on NT, we had some
sites getting over 3M hits per month and MOST of those hits were on
db-driven pages! The Access db itself might get as big as say 10MB in size.
And we had NO problems.
Then, when going to Windows 2003 Server and running very SMALL sites using
Access, we immediately ran into this Jet OLEDB hang problem and basically
nothing runs under Access on a new latest-greatest server. Submitte a
ticket, got a little response and a dll thrown at me which didn't help any,
and haven't heard since.
So, any db needs I have for sites on this particular server we're just
coding for MSDE instead of Access because it's really our only option.
I have PHP and MySQL installed on the server, and really want to jump into
mySQL to see how it compares to Access and MSDE and SQL Server but just
haven't had the time. I suspect it will perform somewhat like MSDE, faster
because of the governors, but not as well as SQL Server who knows. My
experience is Windows, SQL Server, SQL Enterprise, stored procedures, et al
so not sure how much I'll end up doing in mySQL UNLESS I foresee getting so
many new db-driven sites that we can't afford to move to SQL Server over
MSDE and so would need to go the mySQL route.
Decision decisions.
Thanks,
Kevin
"Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid > wrote
in message news:uaN2pGQXEHA.1036@.TK2MSFTNGP10.phx.gbl...
> Hi Kevin,
> The Workload Governor on MSDE is somewhat more serious than a matter of
> milliseconds. Basically it is supposed to give MSDE approximately the same
> performance characteristics as Access, i.e. 20 concurrent users is about
the
> most you will get. Of course how this will work in your specific situation
> you have to test yourself.
> But as you are moving from Access to MSDE, MSDE should perform
sufficiently[vbcol=seagreen]
> ok. If you already had performance problems on Access, MSDE probably won't
> solve these though.
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "valkev" <nospam@.4me.com> wrote in message
> news:euLDc.9211$%l7.3730@.newssvr24.news.prodigy.co m...
> MSDE
I[vbcol=seagreen]
services,[vbcol=seagreen]
> hits
batches[vbcol=seagreen]
reverting[vbcol=seagreen]
> to
batches,[vbcol=seagreen]
in[vbcol=seagreen]
easy[vbcol=seagreen]
internal[vbcol=seagreen]
the[vbcol=seagreen]
BPool[vbcol=seagreen]
of[vbcol=seagreen]
minus[vbcol=seagreen]
> configuration
are[vbcol=seagreen]
release[vbcol=seagreen]
> it
> the
between[vbcol=seagreen]
> 4
see[vbcol=seagreen]
becouse[vbcol=seagreen]
> on...
> resource
visual
> Server
>
|||Don't assume you can't afford SQL Server over MySQL. MySQL is Open Source,
but it is not free, an entry level tech support contract is ?1500/year, the
most expensive support contract with MySQL is ?48,000 per year. Compare that
with SQL Server licenses.
Jacco Schalkwijk
SQL Server MVP
"valkev" <nospam@.4me.com> wrote in message
news:0V4Ec.9708$9w2.1928@.newssvr24.news.prodigy.co m...
> Thanks Jacco.
> Yeah it's kind of funny. Under Access and IIS4 running on NT, we had some
> sites getting over 3M hits per month and MOST of those hits were on
> db-driven pages! The Access db itself might get as big as say 10MB in
size.
> And we had NO problems.
> Then, when going to Windows 2003 Server and running very SMALL sites using
> Access, we immediately ran into this Jet OLEDB hang problem and basically
> nothing runs under Access on a new latest-greatest server. Submitte a
> ticket, got a little response and a dll thrown at me which didn't help
any,
> and haven't heard since.
> So, any db needs I have for sites on this particular server we're just
> coding for MSDE instead of Access because it's really our only option.
> I have PHP and MySQL installed on the server, and really want to jump into
> mySQL to see how it compares to Access and MSDE and SQL Server but just
> haven't had the time. I suspect it will perform somewhat like MSDE,
faster
> because of the governors, but not as well as SQL Server who knows. My
> experience is Windows, SQL Server, SQL Enterprise, stored procedures, et
al
> so not sure how much I'll end up doing in mySQL UNLESS I foresee getting
so
> many new db-driven sites that we can't afford to move to SQL Server over
> MSDE and so would need to go the mySQL route.
> Decision decisions.
> Thanks,
> Kevin
>
> "Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid >
wrote[vbcol=seagreen]
> in message news:uaN2pGQXEHA.1036@.TK2MSFTNGP10.phx.gbl...
same[vbcol=seagreen]
> the
situation[vbcol=seagreen]
> sufficiently
won't[vbcol=seagreen]
> I
> services,
> batches
> reverting
> batches,
allocation[vbcol=seagreen]
> in
leave"[vbcol=seagreen]
> easy
> internal
> the
> BPool
amount[vbcol=seagreen]
> of
> minus
for[vbcol=seagreen]
so[vbcol=seagreen]
> are
that[vbcol=seagreen]
> release
it's[vbcol=seagreen]
releases[vbcol=seagreen]
> between
> see
> becouse
one[vbcol=seagreen]
> visual
I'm[vbcol=seagreen]
the
>
|||Don't assume you can't afford SQL Server over MySQL. MySQL is Open Source,
but it is not free, an entry level tech support contract is ?1500/year, the
most expensive support contract with MySQL is ?48,000 per year. Compare that
with SQL Server licenses.
Jacco Schalkwijk
SQL Server MVP
"valkev" <nospam@.4me.com> wrote in message
news:0V4Ec.9708$9w2.1928@.newssvr24.news.prodigy.co m...
> Thanks Jacco.
> Yeah it's kind of funny. Under Access and IIS4 running on NT, we had some
> sites getting over 3M hits per month and MOST of those hits were on
> db-driven pages! The Access db itself might get as big as say 10MB in
size.
> And we had NO problems.
> Then, when going to Windows 2003 Server and running very SMALL sites using
> Access, we immediately ran into this Jet OLEDB hang problem and basically
> nothing runs under Access on a new latest-greatest server. Submitte a
> ticket, got a little response and a dll thrown at me which didn't help
any,
> and haven't heard since.
> So, any db needs I have for sites on this particular server we're just
> coding for MSDE instead of Access because it's really our only option.
> I have PHP and MySQL installed on the server, and really want to jump into
> mySQL to see how it compares to Access and MSDE and SQL Server but just
> haven't had the time. I suspect it will perform somewhat like MSDE,
faster
> because of the governors, but not as well as SQL Server who knows. My
> experience is Windows, SQL Server, SQL Enterprise, stored procedures, et
al
> so not sure how much I'll end up doing in mySQL UNLESS I foresee getting
so
> many new db-driven sites that we can't afford to move to SQL Server over
> MSDE and so would need to go the mySQL route.
> Decision decisions.
> Thanks,
> Kevin
>
> "Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid >
wrote[vbcol=seagreen]
> in message news:uaN2pGQXEHA.1036@.TK2MSFTNGP10.phx.gbl...
same[vbcol=seagreen]
> the
situation[vbcol=seagreen]
> sufficiently
won't[vbcol=seagreen]
> I
> services,
> batches
> reverting
> batches,
allocation[vbcol=seagreen]
> in
leave"[vbcol=seagreen]
> easy
> internal
> the
> BPool
amount[vbcol=seagreen]
> of
> minus
for[vbcol=seagreen]
so[vbcol=seagreen]
> are
that[vbcol=seagreen]
> release
it's[vbcol=seagreen]
releases[vbcol=seagreen]
> between
> see
> becouse
one[vbcol=seagreen]
> visual
I'm[vbcol=seagreen]
the
>
sql
msde and iis
Hi
If I get data from msde remotely
(from another computer)
should I have iis installed on computer
with sql server.?
Does connection should have
static IP?
Thanks
Konrad
"Konrad" <konrad007@.poczta.onet.pl> wrote in message
news:OdFN8F7TEHA.1048@.tk2msftngp13.phx.gbl...
> If I get data from msde remotely
> (from another computer)
> should I have iis installed on computer
> with sql server.?
If you are accessing the data via a web page, then that would work, or
install IIS on another server.
> Does connection should have
> static IP?
I'm not sure what you are asking here... Typically the host server, running
IIS would need a static address, and be registered in DNS. The connection
from the client side, could be the netbios name or the IP addess of the
host.
Steve
If I get data from msde remotely
(from another computer)
should I have iis installed on computer
with sql server.?
Does connection should have
static IP?
Thanks
Konrad
"Konrad" <konrad007@.poczta.onet.pl> wrote in message
news:OdFN8F7TEHA.1048@.tk2msftngp13.phx.gbl...
> If I get data from msde remotely
> (from another computer)
> should I have iis installed on computer
> with sql server.?
If you are accessing the data via a web page, then that would work, or
install IIS on another server.
> Does connection should have
> static IP?
I'm not sure what you are asking here... Typically the host server, running
IIS would need a static address, and be registered in DNS. The connection
from the client side, could be the netbios name or the IP addess of the
host.
Steve
MSDE and Hard Disk Encryption
Does anyone know or have run MSDE on an encrypted hard disk ? I can't
find much about Microsoft's support of this, I know they support
encrypting the MDF's with EFS, but what about products that encrypt
the entire hard disk, specifically PC Guardian or PGPDisk ?
Anyone have experience with this ?
thanks
bob
"Bob Horkay" <bob@.lifeasbob.com> wrote in message
news:e310ee8f.0406180908.66c05525@.posting.google.c om...
> Does anyone know or have run MSDE on an encrypted hard disk ? I can't
> find much about Microsoft's support of this, I know they support
> encrypting the MDF's with EFS, but what about products that encrypt
> the entire hard disk, specifically PC Guardian or PGPDisk ?
> Anyone have experience with this ?
I've run MSDE on a disk that was encrypted by PC Guardian. It works.
Steve
find much about Microsoft's support of this, I know they support
encrypting the MDF's with EFS, but what about products that encrypt
the entire hard disk, specifically PC Guardian or PGPDisk ?
Anyone have experience with this ?
thanks
bob
"Bob Horkay" <bob@.lifeasbob.com> wrote in message
news:e310ee8f.0406180908.66c05525@.posting.google.c om...
> Does anyone know or have run MSDE on an encrypted hard disk ? I can't
> find much about Microsoft's support of this, I know they support
> encrypting the MDF's with EFS, but what about products that encrypt
> the entire hard disk, specifically PC Guardian or PGPDisk ?
> Anyone have experience with this ?
I've run MSDE on a disk that was encrypted by PC Guardian. It works.
Steve
MSDE and Full Text Search Catalog
Hi there,
First off: I know that MSDE can't handle Full Text Catalogs.
First off: I know that MSDE can't handle Full Text Catalogs.
Now I'd like to know if someone knows about a product or method which I could use that would give me the same result and work with MSDE.
The reason I ask is the following:
We have developed an Intranet application based upon MS Sharepoint Portal Server 2003 for Document Management purposes. Every Document has about 20 customized Properties which can be set. We do have an extensive interface for searching these documents
Now every user can have his "Favorite Documents" in a personal location.
What we are doing now is a "Local" version of this application. It will not allow documents to be modifed and will export the Users Favorites to his personal Computer.
For the moment we store everything (including the documents themselves) in a local MSDE Database.
Now we were recently asked to allow the user to search these local documents. Or at least search for documents with specific properties(i.e. no content indexing needed)
However I don't know how to go about this.
The structure I have for the DB is following
tblFiles
FileGUID FileName
1 Doc1
2 Doc2
tblProperties
PropertyGUID PropertyName
1 Name
2 Author
tblFileProperties
FileGUID PropertyGUID Value
1 1 Test Document.doc
1 2 John Smith
2 1 Dcoument for testing.xls
2 2 John Doe
Now you get the idea
We want to user to be able to specify search criteria for multiple properties
e.g. return every Document where Author Like 'John' and Name Like 'Document'
Preferably we should also be able to use wildcars. But that is not abolutely necessary for the moment.
Now I guess to achieve this I'd need a full text Search Catalog on tblFileProperties.Value, but I'm not even sure about that.
Any help please
RizziManIf your documents are in TEXT you can still search for them using SELECT and XML in SQL Server, the search will just be longer because SQL Server creates an Arithmetic pointer to the file. Full Text is Microsoft Proprietry technology that includes the search with CONTAINS and other key words. Full Text requires Microsoft Catalog to be populated before searches because it is not fully integrated into SQL Server, if the catalog is not populated your search will be empty. If your named concurrent users are less than 75 you can implement the Premium Small business Server 2003 and use the SQL Server that comes with it. Hope this helps.
Kind regards,
Gift Peddie|||I'm gonna have a look at what you suggested using SELECT and XML. (btw, the document content don't even need to be indexed. Only the Properties. But that should work the same way I guess)
The point is: this will be a local application with only 1 concurrent user. We do have SQL Server with Full Text Calatlog Licenses on a few servers running. But this is supposed to work on peoples Laptop when they are not connected to our company network. So I can only work with free software here as the management won't agree on buying any licenses.
Anyway, thank you for the help
Anyone else?
MSDE and Full SQL Server
This might be a stupid questions but,
Can you have a MSDE 2000 and SQL server
standard/enterprise on the same machine?
If not, can you have to instances of SQL databse with
different passwords for the 'sa' account in the respective
instances.
Many thanks
NicYou can have up to 16 instances of any edition of SQL Server 2000 (including
MSDE 2000) on a single computer.
sa is just one login that can be a member of the sysadmin fixed server role.
Any login in the sysadmin fixed server role has sys admin priviledges for
that instance of SQL Server. This would extend to any database for the
instance.
--
Alan Brewer [MSFT]
Lead Programming Writer
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Can you have a MSDE 2000 and SQL server
standard/enterprise on the same machine?
If not, can you have to instances of SQL databse with
different passwords for the 'sa' account in the respective
instances.
Many thanks
NicYou can have up to 16 instances of any edition of SQL Server 2000 (including
MSDE 2000) on a single computer.
sa is just one login that can be a member of the sysadmin fixed server role.
Any login in the sysadmin fixed server role has sys admin priviledges for
that instance of SQL Server. This would extend to any database for the
instance.
--
Alan Brewer [MSFT]
Lead Programming Writer
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
MSDE and Full SQL Server
This might be a stupid questions but,
Can you have a MSDE 2000 and SQL server
standard/enterprise on the same machine?
If not, can you have to instances of SQL databse with
different passwords for the 'sa' account in the respective
instances.
Many thanks
NicYou can have up to 16 instances of any edition of SQL Server 2000 (including
MSDE 2000) on a single computer.
sa is just one login that can be a member of the sysadmin fixed server role.
Any login in the sysadmin fixed server role has sys admin priviledges for
that instance of SQL Server. This would extend to any database for the
instance.
Alan Brewer [MSFT]
Lead programming Writer
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rightssql
Can you have a MSDE 2000 and SQL server
standard/enterprise on the same machine?
If not, can you have to instances of SQL databse with
different passwords for the 'sa' account in the respective
instances.
Many thanks
NicYou can have up to 16 instances of any edition of SQL Server 2000 (including
MSDE 2000) on a single computer.
sa is just one login that can be a member of the sysadmin fixed server role.
Any login in the sysadmin fixed server role has sys admin priviledges for
that instance of SQL Server. This would extend to any database for the
instance.
Alan Brewer [MSFT]
Lead programming Writer
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rightssql
MSDE and ExecuteXmlReader()
Is it possible to use ExecuteXmlReader() with MSDE, I've eard tis method was only available with SQLServer...
JeffMSDE includes jutst about all of the functionality of the Standard Edition but with a special development and test end-user license agreement (EULA) that prohibits production deployment.
JeffMSDE includes jutst about all of the functionality of the Standard Edition but with a special development and test end-user license agreement (EULA) that prohibits production deployment.
So, just about anything you can do with the Standard Edition you can do with MSDE.
Check out theChoosing an Edition of SQL Server 2000 whitepaper.
Terri
MSDE and Exchange
HI all,
I have a pentium 4 3.GIG dual processor 1GIG ram server, that has Exchange
5.5 and MSDE 2000. Are their any bad side effects to this setup. That is,
speed issues, load etc. Will the current setup support this.
Thanks
Robert
hi Robert,
Robert Bravery wrote:
> HI all,
> I have a pentium 4 3.GIG dual processor 1GIG ram server, that has
> Exchange
> 5.5 and MSDE 2000. Are their any bad side effects to this setup. That
> is, speed issues, load etc. Will the current setup support this.
usually Exchange is not a good companion for SQL Server... it is supported,
but if you can afford separated boxes.... :D
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,
THanks for the info. I'm trying to isolate some networking problems. Re- my
repvious post concerning MSDE, which you answered. What I am trying to
figure out is that if MSDE is on the same box as Exchange, would I
experience offline and connections dropping from client pc's. The server in
question is a pIV3.0gig, 1gig RAM, raid5, 180gig free HD
THanks
Robert
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3sbpu5Fn2vgmU1@.individual.net...
> hi Robert,
> Robert Bravery wrote:
> usually Exchange is not a good companion for SQL Server... it is
supported,
> but if you can afford separated boxes.... :D
> --
> 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
>
I have a pentium 4 3.GIG dual processor 1GIG ram server, that has Exchange
5.5 and MSDE 2000. Are their any bad side effects to this setup. That is,
speed issues, load etc. Will the current setup support this.
Thanks
Robert
hi Robert,
Robert Bravery wrote:
> HI all,
> I have a pentium 4 3.GIG dual processor 1GIG ram server, that has
> Exchange
> 5.5 and MSDE 2000. Are their any bad side effects to this setup. That
> is, speed issues, load etc. Will the current setup support this.
usually Exchange is not a good companion for SQL Server... it is supported,
but if you can afford separated boxes.... :D
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,
THanks for the info. I'm trying to isolate some networking problems. Re- my
repvious post concerning MSDE, which you answered. What I am trying to
figure out is that if MSDE is on the same box as Exchange, would I
experience offline and connections dropping from client pc's. The server in
question is a pIV3.0gig, 1gig RAM, raid5, 180gig free HD
THanks
Robert
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3sbpu5Fn2vgmU1@.individual.net...
> hi Robert,
> Robert Bravery wrote:
> usually Exchange is not a good companion for SQL Server... it is
supported,
> but if you can afford separated boxes.... :D
> --
> 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
>
MSDE and Enterprise Manager?
I am a complete sql newbie! For the life of me I can't figure out how to get Enterprise Manager to connect with MSDE. Something about mixed mode or tcp/ip settings? But no one's ever really clear on how to do these things. I've uninstalled MSDE until I can get more info.
I just need a quick walk-through on how to install msde to work with EM. This is what I used when MSDE requested a strong password:
setup INSTANCENAME="InstanceName" SECURITYMODE=SQL SAPWD="AStrongSAPwd"
Is this correct? Any help would be appreciated.
Thanks.
You access it by address or servername + \ + Instance name:
Server\MSDEInstanceName
|||What part are you having a problem with?
Tell EM to connect to the server\instancename using sql authentication login sa, password AStrongPWD.
|||If you have the full SQL Server installed then you install the MSDE as a named instance and right click at the top of the Enterprise manager of the full version to register the MSDE and you can manage it directly. If you have the MSDE installed then you install the full version as a named instance and repeat the above. I have registered 68 SQL Server 7/2000 in one XP box so if you have more questions post again. Hope this helps.|||Thanks to everyone for their help.
I had the eval version of 2000 installed but it's expired. I would now like to use EM with MSDE to connect to the database on my website. I re-installed MSDE but it's only showing the local database.
When I try to register my online domain (ip address) it fails. Says sql may not be running. But it is running. I know it's something basic and silly I'm not doing, but I'm still very new to sql. Is there any other very basic step I may be missing?
Again, thanks for everyone's help...sorry for all the newbie questions.
|||Which is probably correct because your SQL Server service maybe off, the developer edition is $40 in the link below but you could get it for less because when you are using hosting company you need Enterprise manager. Hope this helps.
http://www.provantage.com/buy-22053391-microsoft-backoffice-sql-server-2000-developer-edition-shopping.htm
MSDE and Enterprise Manager Trouble
I have installed an MSDE instance on my PC. I have used both the setup.exe program and installed MSDE with the merge modules. Everything works fine - I am able to programmatically connect to the database and execute all of my statements. However, when I t
ry to register the database with Enterprise Manager, Enterprise Manager doesn't see the instance. Similarly, my program that uses SQLDMO.DLL to enumerate all servers does not see the MSDE instance. Both the database, my program, and Enterprise Manager are
running locally on the same machine.
This is a development box, and I have had to uninstall MSDE by hand several times by removing registry keys manually. I suspect that my problem is that I have deleted a key that I needed. Does anyone have any clues? Thanks in advance.
Rob Reagan
MSDE with Sp3a or MSDE Release A installs by default without network
connections enabled and will not advertise itself on the network. You can
still register the instance in Enterprise Manager by typing the name in the
textbox during registration.
You can install MSDE with network connections, see the "Customizing Desktop
Engine Setup.exe" topic in Books Online for details. You can also enable
network connections after installation with (I think) svrnetcn.exe in the
Tools\Bin directory, but I have no MSDe instance to check that at the
moment.
Jacco Schalkwijk
SQL Server MVP
"Rob Reagan" <RobReagan@.discussions.microsoft.com> wrote in message
news:AEC24187-ADA9-48D1-ADC3-837FEE031CEB@.microsoft.com...
> I have installed an MSDE instance on my PC. I have used both the setup.exe
program and installed MSDE with the merge modules. Everything works fine - I
am able to programmatically connect to the database and execute all of my
statements. However, when I try to register the database with Enterprise
Manager, Enterprise Manager doesn't see the instance. Similarly, my program
that uses SQLDMO.DLL to enumerate all servers does not see the MSDE
instance. Both the database, my program, and Enterprise Manager are running
locally on the same machine.
> This is a development box, and I have had to uninstall MSDE by hand
several times by removing registry keys manually. I suspect that my problem
is that I have deleted a key that I needed. Does anyone have any clues?
Thanks in advance.
> Rob Reagan
ry to register the database with Enterprise Manager, Enterprise Manager doesn't see the instance. Similarly, my program that uses SQLDMO.DLL to enumerate all servers does not see the MSDE instance. Both the database, my program, and Enterprise Manager are
running locally on the same machine.
This is a development box, and I have had to uninstall MSDE by hand several times by removing registry keys manually. I suspect that my problem is that I have deleted a key that I needed. Does anyone have any clues? Thanks in advance.
Rob Reagan
MSDE with Sp3a or MSDE Release A installs by default without network
connections enabled and will not advertise itself on the network. You can
still register the instance in Enterprise Manager by typing the name in the
textbox during registration.
You can install MSDE with network connections, see the "Customizing Desktop
Engine Setup.exe" topic in Books Online for details. You can also enable
network connections after installation with (I think) svrnetcn.exe in the
Tools\Bin directory, but I have no MSDe instance to check that at the
moment.
Jacco Schalkwijk
SQL Server MVP
"Rob Reagan" <RobReagan@.discussions.microsoft.com> wrote in message
news:AEC24187-ADA9-48D1-ADC3-837FEE031CEB@.microsoft.com...
> I have installed an MSDE instance on my PC. I have used both the setup.exe
program and installed MSDE with the merge modules. Everything works fine - I
am able to programmatically connect to the database and execute all of my
statements. However, when I try to register the database with Enterprise
Manager, Enterprise Manager doesn't see the instance. Similarly, my program
that uses SQLDMO.DLL to enumerate all servers does not see the MSDE
instance. Both the database, my program, and Enterprise Manager are running
locally on the same machine.
> This is a development box, and I have had to uninstall MSDE by hand
several times by removing registry keys manually. I suspect that my problem
is that I have deleted a key that I needed. Does anyone have any clues?
Thanks in advance.
> Rob Reagan
MSDE and Enterprise Manager
I have just installed (new clean install) of MSDE 3a. On another machine I have enterprise manager, and I thought I would be able to access it, but when I try to register it in EM it gives me the following error: SERVERNAME - SQL Server does not exist or access denied, Connection Open(Connect(). I have done this in the past with no problem. Did I forget a parameter on the install of 3a to allow other machines to access or do I have some other security issue?Depends on the configuration of MSDE. If you have enabled (using sapwd flag on setup.exe) SQL authentication, you can authenticate with these credentials. However, I did not try to connect to an MSDE instance running on another box with Enterprise Manager yet. But AFAIK, SQL auth should work fine in this case.|||I did configure it for SQL authentication.sql
MSDE and Enterprise Manager
If you have a machine running MSDE and you use Enterprise
Manager to connect to it, should you be able to set up
database maintenance plans that will delete expired
backups?
I'm seeing a situation where you can set up the
maintenance plan but the drop down box for the type of
period (days, weeks, etc) after which to delete expired
backups is blank.
My first thought is that there's an issue with using EM
to set up maintenance plans on MSDE.
Thanks for any assistance.
hi Charles,
"Charles Allen" <callen@.bkd.com> ha scritto nel messaggio
news:3d2c01c4c1ec$13e369d0$a301280a@.phx.gbl
> If you have a machine running MSDE and you use Enterprise
> Manager to connect to it, should you be able to set up
> database maintenance plans that will delete expired
> backups?
> I'm seeing a situation where you can set up the
> maintenance plan but the drop down box for the type of
> period (days, weeks, etc) after which to delete expired
> backups is blank.
> My first thought is that there's an issue with using EM
> to set up maintenance plans on MSDE.
> Thanks for any assistance.
unfortunately, your first thought should be that you are not licensed to use
Enterprise Manager against MSDE instances, and you should rely on self based
solutions or third party tools
(http://www.microsoft.com/sql/msde/partners/default.asp or
http://www.aspfaq.com/show.asp?id=2442 , google for others)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks for your message. My understanding of the licensing is you can use
Enterprise Manager IF you own a copy of SQL Server Standard or greater. If my
understanding is correct, then the issue goes back to functionality. Do you
agree?
In case you are wondering, you might use MSDE even if you have an installed
version of SQL Server if the application you are using is based on one or the
other. Great Plains, for example, knows which one you are using and has
specific licenses.
"Andrea Montanari" wrote:
> hi Charles,
> "Charles Allen" <callen@.bkd.com> ha scritto nel messaggio
> news:3d2c01c4c1ec$13e369d0$a301280a@.phx.gbl
> unfortunately, your first thought should be that you are not licensed to use
> Enterprise Manager against MSDE instances, and you should rely on self based
> solutions or third party tools
> (http://www.microsoft.com/sql/msde/partners/default.asp or
> http://www.aspfaq.com/show.asp?id=2442 , google for others)
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||That's not quite correct. The Appropriate Uses of MSDE FAQ at
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp says the following:
Q. Can I use SQL Server tools and services in conjunction with MSDE?
A. You can only use SQL Server tools and services in conjunction with
MSDE if you acquired MSDE through SQL Server 2000 (Developer Edition,
Standard Edition, or Enterprise Edition), and if you are using MSDE in
conjunction with a properly licensed copy of SQL Server 2000. Visit the How
to Buy page for information on obtaining a valid SQL Server license.
Note: The tools and services included with SQL Server Developer
Edition may not be used to manage production server environments.
The following utilities are installed by the MSDE setup application
and are provided without restrictions for use with the copy of MSDE that is
installed by your application: bcp.exe, cnfgsvr.exe, dcomscm.exe, osql.exe,
sqlmaint.exe, sqlmangr.exe, scm.exe, sqladhlp.exe, and svrnetcn.exe. The
dtsrun.exe utility is also provided, but can only be used to run existing
Data Transformation Services (DTS) packages against the copy of MSDE
installed by your application; it cannot be used to develop new DTS
packages.
The key phrase here is "using MSDE in conjuntion with a properly licensed
copy of SQL Server 2000." Simply owning a copy of SQL Server Standard
Edition isn't enough, and you'll have to talk to your laywer to figure out
what that phrase means. All I've been told is that it doesn't apply in most
cases and requires a room full of lawyers and a white board to understand.
Rather than go through all that, you're probably better off putting Andrea's
suggestion to work and using a third-party tool.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Charles Allen" <CharlesAllen@.discussions.microsoft.com> wrote in message
news:18142445-2FBB-43EC-9719-8751C5AC767D@.microsoft.com...[vbcol=seagreen]
> Thanks for your message. My understanding of the licensing is you can use
> Enterprise Manager IF you own a copy of SQL Server Standard or greater. If
> my
> understanding is correct, then the issue goes back to functionality. Do
> you
> agree?
> In case you are wondering, you might use MSDE even if you have an
> installed
> version of SQL Server if the application you are using is based on one or
> the
> other. Great Plains, for example, knows which one you are using and has
> specific licenses.
> "Andrea Montanari" wrote:
begin 666 ts.gif
J1TE&.#EA`0`!`( ``````/___R'Y! $`````+ `````!``$```(!1 `[
`
end
Manager to connect to it, should you be able to set up
database maintenance plans that will delete expired
backups?
I'm seeing a situation where you can set up the
maintenance plan but the drop down box for the type of
period (days, weeks, etc) after which to delete expired
backups is blank.
My first thought is that there's an issue with using EM
to set up maintenance plans on MSDE.
Thanks for any assistance.
hi Charles,
"Charles Allen" <callen@.bkd.com> ha scritto nel messaggio
news:3d2c01c4c1ec$13e369d0$a301280a@.phx.gbl
> If you have a machine running MSDE and you use Enterprise
> Manager to connect to it, should you be able to set up
> database maintenance plans that will delete expired
> backups?
> I'm seeing a situation where you can set up the
> maintenance plan but the drop down box for the type of
> period (days, weeks, etc) after which to delete expired
> backups is blank.
> My first thought is that there's an issue with using EM
> to set up maintenance plans on MSDE.
> Thanks for any assistance.
unfortunately, your first thought should be that you are not licensed to use
Enterprise Manager against MSDE instances, and you should rely on self based
solutions or third party tools
(http://www.microsoft.com/sql/msde/partners/default.asp or
http://www.aspfaq.com/show.asp?id=2442 , google for others)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks for your message. My understanding of the licensing is you can use
Enterprise Manager IF you own a copy of SQL Server Standard or greater. If my
understanding is correct, then the issue goes back to functionality. Do you
agree?
In case you are wondering, you might use MSDE even if you have an installed
version of SQL Server if the application you are using is based on one or the
other. Great Plains, for example, knows which one you are using and has
specific licenses.
"Andrea Montanari" wrote:
> hi Charles,
> "Charles Allen" <callen@.bkd.com> ha scritto nel messaggio
> news:3d2c01c4c1ec$13e369d0$a301280a@.phx.gbl
> unfortunately, your first thought should be that you are not licensed to use
> Enterprise Manager against MSDE instances, and you should rely on self based
> solutions or third party tools
> (http://www.microsoft.com/sql/msde/partners/default.asp or
> http://www.aspfaq.com/show.asp?id=2442 , google for others)
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||That's not quite correct. The Appropriate Uses of MSDE FAQ at
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp says the following:
Q. Can I use SQL Server tools and services in conjunction with MSDE?
A. You can only use SQL Server tools and services in conjunction with
MSDE if you acquired MSDE through SQL Server 2000 (Developer Edition,
Standard Edition, or Enterprise Edition), and if you are using MSDE in
conjunction with a properly licensed copy of SQL Server 2000. Visit the How
to Buy page for information on obtaining a valid SQL Server license.
Note: The tools and services included with SQL Server Developer
Edition may not be used to manage production server environments.
The following utilities are installed by the MSDE setup application
and are provided without restrictions for use with the copy of MSDE that is
installed by your application: bcp.exe, cnfgsvr.exe, dcomscm.exe, osql.exe,
sqlmaint.exe, sqlmangr.exe, scm.exe, sqladhlp.exe, and svrnetcn.exe. The
dtsrun.exe utility is also provided, but can only be used to run existing
Data Transformation Services (DTS) packages against the copy of MSDE
installed by your application; it cannot be used to develop new DTS
packages.
The key phrase here is "using MSDE in conjuntion with a properly licensed
copy of SQL Server 2000." Simply owning a copy of SQL Server Standard
Edition isn't enough, and you'll have to talk to your laywer to figure out
what that phrase means. All I've been told is that it doesn't apply in most
cases and requires a room full of lawyers and a white board to understand.
Rather than go through all that, you're probably better off putting Andrea's
suggestion to work and using a third-party tool.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Charles Allen" <CharlesAllen@.discussions.microsoft.com> wrote in message
news:18142445-2FBB-43EC-9719-8751C5AC767D@.microsoft.com...[vbcol=seagreen]
> Thanks for your message. My understanding of the licensing is you can use
> Enterprise Manager IF you own a copy of SQL Server Standard or greater. If
> my
> understanding is correct, then the issue goes back to functionality. Do
> you
> agree?
> In case you are wondering, you might use MSDE even if you have an
> installed
> version of SQL Server if the application you are using is based on one or
> the
> other. Great Plains, for example, knows which one you are using and has
> specific licenses.
> "Andrea Montanari" wrote:
begin 666 ts.gif
J1TE&.#EA`0`!`( ``````/___R'Y! $`````+ `````!``$```(!1 `[
`
end
MSDE and Enterprise manager
-ENTERPRISE MANAGER .
. .
.
http://www.aspfaq.com/show.asp?id=2442
Really? I tend to disagree. (?)
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Tomer" <Tomek13@.bezeqint.net> wrote in message
news:eMYhPqoPEHA.3012@.tk2msftngp13.phx.gbl...
> -ENTERPRISE MANAGER .
> . .
> .
> http://www.aspfaq.com/show.asp?id=2442
>
|||I concur with your findings Aaron.
Steve Plender
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:uCM9EvoPEHA.2740@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> Really? I tend to disagree. (?)
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>
> "Tomer" <Tomek13@.bezeqint.net> wrote in message
> news:eMYhPqoPEHA.3012@.tk2msftngp13.phx.gbl...
[vbcol=seagreen]
>
. .
.
http://www.aspfaq.com/show.asp?id=2442
Really? I tend to disagree. (?)
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Tomer" <Tomek13@.bezeqint.net> wrote in message
news:eMYhPqoPEHA.3012@.tk2msftngp13.phx.gbl...
> -ENTERPRISE MANAGER .
> . .
> .
> http://www.aspfaq.com/show.asp?id=2442
>
|||I concur with your findings Aaron.
Steve Plender
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:uCM9EvoPEHA.2740@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> Really? I tend to disagree. (?)
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>
> "Tomer" <Tomek13@.bezeqint.net> wrote in message
> news:eMYhPqoPEHA.3012@.tk2msftngp13.phx.gbl...
[vbcol=seagreen]
>
MSDE and DTS packages
Hi all
I am new to the msde and have worked with SQL for a little while. I have developed my database on my SQL server and now have transfered it to MSDE with only one problem.
I have exported the dts package to a text file, but when I import it into MSDE there is nothing there.
My question is can I (and how) create a DTS package through vbscript or osql? I have looked in MSDN and found the dtswiz with command line switchs, but I can not find an example using a text file. I unbderstand that there are a few more switches to tell
it the delimitation.
Any help would be very appreciated.
Thanks for your help in advance.
I'm guessing you want to import dts packages into MSDE (if not my
appologies).
you can save the package as a structured storage file and use a little vb
app to load the package in memory and then save it to the msde using
SaveToSQLServer function of the package class ?
If you have a SQL Server then you can also use enterprise manager to simply
save the DTS packes directly to your msde instance.
Hope this helps.
Ranjeet.
"whiggins" <anonymous@.discussions.microsoft.com> wrote in message
news:8A03C082-9B78-4106-83EF-F2DC7FBD65E6@.microsoft.com...
> Hi all
> I am new to the msde and have worked with SQL for a little while. I have
developed my database on my SQL server and now have transfered it to MSDE
with only one problem.
> I have exported the dts package to a text file, but when I import it into
MSDE there is nothing there.
> My question is can I (and how) create a DTS package through vbscript or
osql? I have looked in MSDN and found the dtswiz with command line switchs,
but I can not find an example using a text file. I unbderstand that there
are a few more switches to tell it the delimitation.
> Any help would be very appreciated.
> Thanks for your help in advance.
I am new to the msde and have worked with SQL for a little while. I have developed my database on my SQL server and now have transfered it to MSDE with only one problem.
I have exported the dts package to a text file, but when I import it into MSDE there is nothing there.
My question is can I (and how) create a DTS package through vbscript or osql? I have looked in MSDN and found the dtswiz with command line switchs, but I can not find an example using a text file. I unbderstand that there are a few more switches to tell
it the delimitation.
Any help would be very appreciated.
Thanks for your help in advance.
I'm guessing you want to import dts packages into MSDE (if not my
appologies).
you can save the package as a structured storage file and use a little vb
app to load the package in memory and then save it to the msde using
SaveToSQLServer function of the package class ?
If you have a SQL Server then you can also use enterprise manager to simply
save the DTS packes directly to your msde instance.
Hope this helps.
Ranjeet.
"whiggins" <anonymous@.discussions.microsoft.com> wrote in message
news:8A03C082-9B78-4106-83EF-F2DC7FBD65E6@.microsoft.com...
> Hi all
> I am new to the msde and have worked with SQL for a little while. I have
developed my database on my SQL server and now have transfered it to MSDE
with only one problem.
> I have exported the dts package to a text file, but when I import it into
MSDE there is nothing there.
> My question is can I (and how) create a DTS package through vbscript or
osql? I have looked in MSDN and found the dtswiz with command line switchs,
but I can not find an example using a text file. I unbderstand that there
are a few more switches to tell it the delimitation.
> Any help would be very appreciated.
> Thanks for your help in advance.
Subscribe to:
Posts (Atom)