Hi I am planning a desktop application I want to develop in C# and I was thinking about using MSDE instead of an Access database. I have never used of even looked into MSDE before. Do you simply create a database on SQL Server add your tables and Sp's, setup your conection and program against this as normal, then with the install of the software setup MSDE and install the tables and SP's etc into the instance of MSDE?
TIAFrom my experience MSDE has some limitations (db size, number of connections, etc.) but it is real database engine with all features. You can manage it by ISQL or OSQL (if you have installed somewhere in NET enterprise manager - you can use it for MSDE).|||Hi,
The database size is limited to 2GB. Once the DB gets to this size MSDE will not allow the program to use it. You can still go into the DB with Enterprise Manager or Query Analyzer or shareware tools. But nothing will run.
As for connections I beleive the limit is 30.
As for your install.
Create the database on the SQL server and write your program against it. Then back the database up when you are finished debugging it. Include it with your install packaging (I am not a developer so I won't tell you how).
When the install process starts have the MSDE install first (See MS Knowledge Base or google "MSDE install"). Then restore the database to the MSDE ( I suggest osql). Then create your ODBC connection. And finish with your program.
Have fun !|||Thanks for all your comments and advise :)
Showing posts with label desktop. Show all posts
Showing posts with label desktop. Show all posts
Friday, March 30, 2012
Wednesday, March 28, 2012
MSDE 2000 SP4 Merge Modules
I have a MSDE 2000 InstallShield install package that I've created using the
merge modules. I downloaded the SP4 of the desktop engine from the microsoft
site. When downloaded and extracted, there is a folder on my machine
\MSDE\MSM which has all of the merge modules. I've noticed that the SP4
release has 3 new mm's: msxmlsql32.msm, msxmlsqlr32.msm, and qfepatch.msm.
In the InstallShield DevStudio 9.01 IDE, I check the 3 new mm's. When I go
and build I receive the following error: "Error retrieving dependency
MSXMLSQL1033.996A3FBA_B9BC_4189_9DB1_2B3C86B526BC: 1033 of C:\Program
Files\InstallShield\DevStudio 9\Modules\i386\MSXMLSQL32.MSM". Anyone know
why I'm getting this error?
Thanks.
Joanne
hi Joanne
jbayog wrote:
> I have a MSDE 2000 InstallShield install package that I've created
> using the merge modules. I downloaded the SP4 of the desktop engine
> from the microsoft site. When downloaded and extracted, there is a
> folder on my machine \MSDE\MSM which has all of the merge modules.
> I've noticed that the SP4 release has 3 new mm's: msxmlsql32.msm,
> msxmlsqlr32.msm, and qfepatch.msm. In the InstallShield DevStudio
> 9.01 IDE, I check the 3 new mm's. When I go and build I receive the
> following error: "Error retrieving dependency
> MSXMLSQL1033.996A3FBA_B9BC_4189_9DB1_2B3C86B526BC: 1033 of C:\Program
> Files\InstallShield\DevStudio 9\Modules\i386\MSXMLSQL32.MSM". Anyone
> know why I'm getting this error?
no idea, never used MSDE merge modules, always installed using the setup.exe
boostrap installer.... but have you tried modifying the order of
installation?
http://msdn.microsoft.com/library/de...stsql_8yeq.asp
has not been updated (as BOL in general) at sp4 level, so no additional info
about those new merge modules seems available..
BTW, the MSDE readme file, at point 4.2 MSDE 2000 SP4 File location
specifies:
"Note Merge modules are not supported for new installations. They are
provided in SP4 for servicing instances of MSDE 2000 that were previously
installed using merge modules."
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I don't know much about MSDE and am just doing some research on it as of
this week.
However, I cam across this link yesterday which might be useful:
http://www.microsoft.com/sql/downloads/2000/sp4.asp
Here is an extract from the site:
"Users who have an existing instance of MSDE 2000 must know how their
instance of MSDE 2000 was installed to know how to update it. In particular,
you must know the original package name for your instance of MSDE 2000. To
determine the original package name, see the article How To Identify Which
MSI File Was Used for an Existing MSDE Installation in the Microsoft
Knowledge Base."
"jbayog" <jbayog@.discussions.microsoft.com> wrote in message
news:8D058312-1747-4A51-A100-FE79DC32C086@.microsoft.com...
>I have a MSDE 2000 InstallShield install package that I've created using
>the
> merge modules. I downloaded the SP4 of the desktop engine from the
> microsoft
> site. When downloaded and extracted, there is a folder on my machine
> \MSDE\MSM which has all of the merge modules. I've noticed that the SP4
> release has 3 new mm's: msxmlsql32.msm, msxmlsqlr32.msm, and
> qfepatch.msm.
> In the InstallShield DevStudio 9.01 IDE, I check the 3 new mm's. When I
> go
> and build I receive the following error: "Error retrieving dependency
> MSXMLSQL1033.996A3FBA_B9BC_4189_9DB1_2B3C86B526BC: 1033 of C:\Program
> Files\InstallShield\DevStudio 9\Modules\i386\MSXMLSQL32.MSM". Anyone know
> why I'm getting this error?
> Thanks.
> Joanne
|||Thanks so much for your help. This an existing MSDE 2000 InstallShield
install package and we have a client who wants to upgrade to SP4 so that is
why I'm trying to build an upgrade for them. I'd like to get rid of using
the MSDE 2000 merge modules per Microsoft's comment. I got it to build by
editing the msxmlsql32.msm and the msxmlsqlr32.msm using the Orca tool. I
think there is a problem with the rows in the ModuleDependency table. I
guess I have the option of building it without these two mm's as our database
application doesn't use xml. I'm a little apprehensive of doing this only
because there is no documentation on these new mm's. I might post to
InstallShield also. Again thanks.
Joanne
Joanne
"Andrea Montanari" wrote:
> hi Joanne
> jbayog wrote:
> no idea, never used MSDE merge modules, always installed using the setup.exe
> boostrap installer.... but have you tried modifying the order of
> installation?
> http://msdn.microsoft.com/library/de...stsql_8yeq.asp
> has not been updated (as BOL in general) at sp4 level, so no additional info
> about those new merge modules seems available..
> BTW, the MSDE readme file, at point 4.2 MSDE 2000 SP4 File location
> specifies:
> "Note Merge modules are not supported for new installations. They are
> provided in SP4 for servicing instances of MSDE 2000 that were previously
> installed using merge modules."
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
merge modules. I downloaded the SP4 of the desktop engine from the microsoft
site. When downloaded and extracted, there is a folder on my machine
\MSDE\MSM which has all of the merge modules. I've noticed that the SP4
release has 3 new mm's: msxmlsql32.msm, msxmlsqlr32.msm, and qfepatch.msm.
In the InstallShield DevStudio 9.01 IDE, I check the 3 new mm's. When I go
and build I receive the following error: "Error retrieving dependency
MSXMLSQL1033.996A3FBA_B9BC_4189_9DB1_2B3C86B526BC: 1033 of C:\Program
Files\InstallShield\DevStudio 9\Modules\i386\MSXMLSQL32.MSM". Anyone know
why I'm getting this error?
Thanks.
Joanne
hi Joanne
jbayog wrote:
> I have a MSDE 2000 InstallShield install package that I've created
> using the merge modules. I downloaded the SP4 of the desktop engine
> from the microsoft site. When downloaded and extracted, there is a
> folder on my machine \MSDE\MSM which has all of the merge modules.
> I've noticed that the SP4 release has 3 new mm's: msxmlsql32.msm,
> msxmlsqlr32.msm, and qfepatch.msm. In the InstallShield DevStudio
> 9.01 IDE, I check the 3 new mm's. When I go and build I receive the
> following error: "Error retrieving dependency
> MSXMLSQL1033.996A3FBA_B9BC_4189_9DB1_2B3C86B526BC: 1033 of C:\Program
> Files\InstallShield\DevStudio 9\Modules\i386\MSXMLSQL32.MSM". Anyone
> know why I'm getting this error?
no idea, never used MSDE merge modules, always installed using the setup.exe
boostrap installer.... but have you tried modifying the order of
installation?
http://msdn.microsoft.com/library/de...stsql_8yeq.asp
has not been updated (as BOL in general) at sp4 level, so no additional info
about those new merge modules seems available..
BTW, the MSDE readme file, at point 4.2 MSDE 2000 SP4 File location
specifies:
"Note Merge modules are not supported for new installations. They are
provided in SP4 for servicing instances of MSDE 2000 that were previously
installed using merge modules."
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I don't know much about MSDE and am just doing some research on it as of
this week.
However, I cam across this link yesterday which might be useful:
http://www.microsoft.com/sql/downloads/2000/sp4.asp
Here is an extract from the site:
"Users who have an existing instance of MSDE 2000 must know how their
instance of MSDE 2000 was installed to know how to update it. In particular,
you must know the original package name for your instance of MSDE 2000. To
determine the original package name, see the article How To Identify Which
MSI File Was Used for an Existing MSDE Installation in the Microsoft
Knowledge Base."
"jbayog" <jbayog@.discussions.microsoft.com> wrote in message
news:8D058312-1747-4A51-A100-FE79DC32C086@.microsoft.com...
>I have a MSDE 2000 InstallShield install package that I've created using
>the
> merge modules. I downloaded the SP4 of the desktop engine from the
> microsoft
> site. When downloaded and extracted, there is a folder on my machine
> \MSDE\MSM which has all of the merge modules. I've noticed that the SP4
> release has 3 new mm's: msxmlsql32.msm, msxmlsqlr32.msm, and
> qfepatch.msm.
> In the InstallShield DevStudio 9.01 IDE, I check the 3 new mm's. When I
> go
> and build I receive the following error: "Error retrieving dependency
> MSXMLSQL1033.996A3FBA_B9BC_4189_9DB1_2B3C86B526BC: 1033 of C:\Program
> Files\InstallShield\DevStudio 9\Modules\i386\MSXMLSQL32.MSM". Anyone know
> why I'm getting this error?
> Thanks.
> Joanne
|||Thanks so much for your help. This an existing MSDE 2000 InstallShield
install package and we have a client who wants to upgrade to SP4 so that is
why I'm trying to build an upgrade for them. I'd like to get rid of using
the MSDE 2000 merge modules per Microsoft's comment. I got it to build by
editing the msxmlsql32.msm and the msxmlsqlr32.msm using the Orca tool. I
think there is a problem with the rows in the ModuleDependency table. I
guess I have the option of building it without these two mm's as our database
application doesn't use xml. I'm a little apprehensive of doing this only
because there is no documentation on these new mm's. I might post to
InstallShield also. Again thanks.
Joanne
Joanne
"Andrea Montanari" wrote:
> hi Joanne
> jbayog wrote:
> no idea, never used MSDE merge modules, always installed using the setup.exe
> boostrap installer.... but have you tried modifying the order of
> installation?
> http://msdn.microsoft.com/library/de...stsql_8yeq.asp
> has not been updated (as BOL in general) at sp4 level, so no additional info
> about those new merge modules seems available..
> BTW, the MSDE readme file, at point 4.2 MSDE 2000 SP4 File location
> specifies:
> "Note Merge modules are not supported for new installations. They are
> provided in SP4 for servicing instances of MSDE 2000 that were previously
> installed using merge modules."
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
Friday, March 23, 2012
MSDE 2000 INSTALLATION PROBLEM URGENT HELP
I am trying to Install MSDE 2000 A latest version
and I am getting error
product:microsoft sql server desktop engine--installation
of the microsoft distributed transaction coroordinator
package failed
and this fails. I am installing on NT 4.0 Server Sp6a
version. Please help as I need this urgently to
Install Veritas Backup Software and is very critical.
The error log file MSDE.LOG is as follows:
MSI (s) (DF:43): Executing op: InstallProtectedFiles
(AllowUI=1)
MSI (s) (DF:43): Executing op: ActionStart
(Name=InstallDTC.2D02443E_7002_4C0B_ABC9_EAB2C0643 97B,,)
Action 8:36:53:
InstallDTC.2D02443E_7002_4C0B_ABC9_EAB2C064397B.
MSI (s) (DF:43): Executing op: CustomActionSchedule
(Action=InstallDTC.2D02443E_7002_4C0B_ABC9_EAB2C06 4397B,Act
ionType=1025,Source=BinaryData,Target=InstallDTC,)
MSI (s) (DF:43): Creating MSIHANDLE (217) of type 790536
for thread 579
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
E141-427A-AB0C-D3605127224A}
TempFolder is C:\TEMP\{E09B48B5-E141-427A-AB0C-
D3605127224A}\
Loading extended custom action library C:\TEMP\{E09B48B5-
E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
E141-427A-AB0C-D3605127224A}
Starting custom action InstallDTC
Executing "C:\Program Files\Microsoft SQL Server\80
\Tools\Binn\cldtcstp.exe -SupportDir "C:\Program
Files\Microsoft SQL Server\80\Tools\Binn\" -
DTCPkg "C:\Program Files\Microsoft SQL Server\80
\Tools\Binn\dtcsetup.exe" -Silent 1"
Installation of the Microsoft Distribued Transaction
Coordinator package failed.
Action ended 8:36:58: InstallFinalize. Return value 3.
MSI (s) (DF:43): User policy value 'DisableRollback' is 0
I'm not sure this is the solution, but you may give it a try:
Stop all services that might interfere with MSDE or the performace counters.
- Simple Network Management Protocol (SNMP)
- Performance Monitor
- Monitoring services like Surveyor or NetIQ
- Microsoft Distributed Transaction Coordinator (MSDTC)
- Microsoft Search (MSSearch)
- Internet Information Services (IIS)
- WnsService (This service corresponds to the Canon printer driver.)
- Third-party performance monitor utilities that load performance counters.
- Antivirus programs.
In the "setup.ini".
[Options]
DISABLENETWORKPROTOCOLS=0
SAPWD="your-sa-password"
INSTANCENAME="db-instance-name"
SECURITYMODE=SQL
And run setup.exe
Regards,
Lars-Inge Tnnessen
www.larsinge.com
and I am getting error
product:microsoft sql server desktop engine--installation
of the microsoft distributed transaction coroordinator
package failed
and this fails. I am installing on NT 4.0 Server Sp6a
version. Please help as I need this urgently to
Install Veritas Backup Software and is very critical.
The error log file MSDE.LOG is as follows:
MSI (s) (DF:43): Executing op: InstallProtectedFiles
(AllowUI=1)
MSI (s) (DF:43): Executing op: ActionStart
(Name=InstallDTC.2D02443E_7002_4C0B_ABC9_EAB2C0643 97B,,)
Action 8:36:53:
InstallDTC.2D02443E_7002_4C0B_ABC9_EAB2C064397B.
MSI (s) (DF:43): Executing op: CustomActionSchedule
(Action=InstallDTC.2D02443E_7002_4C0B_ABC9_EAB2C06 4397B,Act
ionType=1025,Source=BinaryData,Target=InstallDTC,)
MSI (s) (DF:43): Creating MSIHANDLE (217) of type 790536
for thread 579
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
E141-427A-AB0C-D3605127224A}
TempFolder is C:\TEMP\{E09B48B5-E141-427A-AB0C-
D3605127224A}\
Loading extended custom action library C:\TEMP\{E09B48B5-
E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
E141-427A-AB0C-D3605127224A}
Starting custom action InstallDTC
Executing "C:\Program Files\Microsoft SQL Server\80
\Tools\Binn\cldtcstp.exe -SupportDir "C:\Program
Files\Microsoft SQL Server\80\Tools\Binn\" -
DTCPkg "C:\Program Files\Microsoft SQL Server\80
\Tools\Binn\dtcsetup.exe" -Silent 1"
Installation of the Microsoft Distribued Transaction
Coordinator package failed.
Action ended 8:36:58: InstallFinalize. Return value 3.
MSI (s) (DF:43): User policy value 'DisableRollback' is 0
I'm not sure this is the solution, but you may give it a try:
Stop all services that might interfere with MSDE or the performace counters.
- Simple Network Management Protocol (SNMP)
- Performance Monitor
- Monitoring services like Surveyor or NetIQ
- Microsoft Distributed Transaction Coordinator (MSDTC)
- Microsoft Search (MSSearch)
- Internet Information Services (IIS)
- WnsService (This service corresponds to the Canon printer driver.)
- Third-party performance monitor utilities that load performance counters.
- Antivirus programs.
In the "setup.ini".
[Options]
DISABLENETWORKPROTOCOLS=0
SAPWD="your-sa-password"
INSTANCENAME="db-instance-name"
SECURITYMODE=SQL
And run setup.exe
Regards,
Lars-Inge Tnnessen
www.larsinge.com
MSDE 2000 Installation
I am new to MSDE. Not MS-SQL server was installed in this desktop before. I have downloaded MSDERelA and installed it using the command line prompt. I can not the see the SQLServer programs under Start/Programs menu. What am I doing wrong? Should I be
installing a different program instead of MSDE2000RelA? Please help. Thank you.
MSDE doesn't have a graphical user interface and it doesn't create any menu
items in the Start/Programs menu. You can check if MSDE is installed by
looking in Control Panel|Add/Remove Programs.
Jacco Schalkwijk
SQL Server MVP
"Sukhendu Barua" <anonymous@.discussions.microsoft.com> wrote in message
news:EFAACD33-0C01-426B-8D83-A32F061F9C82@.microsoft.com...
> I am new to MSDE. Not MS-SQL server was installed in this desktop before.
I have downloaded MSDERelA and installed it using the command line prompt.
I can not the see the SQLServer programs under Start/Programs menu. What am
I doing wrong? Should I be installing a different program instead of
MSDE2000RelA? Please help. Thank you.
|||Thanks Jacco,
I checked as you suggested and saw that MSDE is installed. Where would I find the free version of graphical user interface that will work with MSDE? Do I need to remove MSDE to install the GUI?
-- Jacco Schalkwijk wrote: --
MSDE doesn't have a graphical user interface and it doesn't create any menu
items in the Start/Programs menu. You can check if MSDE is installed by
looking in Control Panel|Add/Remove Programs.
Jacco Schalkwijk
SQL Server MVP
"Sukhendu Barua" <anonymous@.discussions.microsoft.com> wrote in message
news:EFAACD33-0C01-426B-8D83-A32F061F9C82@.microsoft.com...
> I am new to MSDE. Not MS-SQL server was installed in this desktop before.
I have downloaded MSDERelA and installed it using the command line prompt.
I can not the see the SQLServer programs under Start/Programs menu. What am
I doing wrong? Should I be installing a different program instead of
MSDE2000RelA? Please help. Thank you.
|||You don't need to remove MSDE to install the GUI. You can download a web
based GUI from Microsoft, www.microsoft.com/sql look for the SQL Server Web
Data Administrator. There are also a host of free tools available from other
source, just try Google.
Jacco Schalkwijk
SQL Server MVP
"Sukhendu Barua" <anonymous@.discussions.microsoft.com> wrote in message
news:19A5FEAA-E692-4273-A5E1-586B95F5C03F@.microsoft.com...
> Thanks Jacco,
> I checked as you suggested and saw that MSDE is installed. Where would I
find the free version of graphical user interface that will work with MSDE?
Do I need to remove MSDE to install the GUI?
> -- Jacco Schalkwijk wrote: --
> MSDE doesn't have a graphical user interface and it doesn't create
any menu
> items in the Start/Programs menu. You can check if MSDE is installed
by
> looking in Control Panel|Add/Remove Programs.
>
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Sukhendu Barua" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
> news:EFAACD33-0C01-426B-8D83-A32F061F9C82@.microsoft.com...
before.
> I have downloaded MSDERelA and installed it using the command line
prompt.
> I can not the see the SQLServer programs under Start/Programs menu.
What am
> I doing wrong? Should I be installing a different program instead of
> MSDE2000RelA? Please help. Thank you.
>
>
|||hi,
"Sukhendu Barua" <anonymous@.discussions.microsoft.com> ha scritto nel
messaggio news:19A5FEAA-E692-4273-A5E1-586B95F5C03F@.microsoft.com...
> Thanks Jacco,
> I checked as you suggested and saw that MSDE is installed. Where would I
find the free version of
>graphical user interface that will work with MSDE? Do I need to remove
MSDE to install the GUI?
as Jacco already pointed out, you can have a look at
http://www.microsoft.com/sql/msde/partners/default.asp and or
http://www.aspfaq.com/show.asp?id=2442 for additional third parties tools..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks Jacco,
I installed the SQL Server Web Data Administrator. The installation never asked for my userid and password. When try to login what userid/pw should I be using?. I tried my windows login and pw and it did not work. Then i tried sa as userid and AStrong
SAPwd as password, did not work it either. I tried both windows authenticate mode and sql mode. The server is (local).
-- Jacco Schalkwijk wrote: --
You don't need to remove MSDE to install the GUI. You can download a web
based GUI from Microsoft, www.microsoft.com/sql look for the SQL Server Web
Data Administrator. There are also a host of free tools available from other
source, just try Google.
Jacco Schalkwijk
SQL Server MVP
"Sukhendu Barua" <anonymous@.discussions.microsoft.com> wrote in message
news:19A5FEAA-E692-4273-A5E1-586B95F5C03F@.microsoft.com...
> Thanks Jacco,
> I checked as you suggested and saw that MSDE is installed. Where would I
find the free version of graphical user interface that will work with MSDE?
Do I need to remove MSDE to install the GUI?[vbcol=seagreen]
any menu
> items in the Start/Programs menu. You can check if MSDE is installed
by[vbcol=seagreen]
> looking in Control Panel|Add/Remove Programs.
> Jacco Schalkwijk
> SQL Server MVP
message[vbcol=seagreen]
> news:EFAACD33-0C01-426B-8D83-A32F061F9C82@.microsoft.com...
before.
> I have downloaded MSDERelA and installed it using the command line
prompt.
> I can not the see the SQLServer programs under Start/Programs menu.
What am[vbcol=seagreen]
> I doing wrong? Should I be installing a different program instead of
> MSDE2000RelA? Please help. Thank you.
|||Thank you Andrea. DbaMgr2k works great!
Cheers,
Sukhendu
-- Andrea Montanari wrote: --
hi,
"Sukhendu Barua" <anonymous@.discussions.microsoft.com> ha scritto nel
messaggio news:19A5FEAA-E692-4273-A5E1-586B95F5C03F@.microsoft.com...
> Thanks Jacco,
> I checked as you suggested and saw that MSDE is installed. Where would I
find the free version of
>graphical user interface that will work with MSDE? Do I need to remove
MSDE to install the GUI?
as Jacco already pointed out, you can have a look at
http://www.microsoft.com/sql/msde/partners/default.asp and or
http://www.aspfaq.com/show.asp?id=2442 for additional third parties tools..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
sql
installing a different program instead of MSDE2000RelA? Please help. Thank you.
MSDE doesn't have a graphical user interface and it doesn't create any menu
items in the Start/Programs menu. You can check if MSDE is installed by
looking in Control Panel|Add/Remove Programs.
Jacco Schalkwijk
SQL Server MVP
"Sukhendu Barua" <anonymous@.discussions.microsoft.com> wrote in message
news:EFAACD33-0C01-426B-8D83-A32F061F9C82@.microsoft.com...
> I am new to MSDE. Not MS-SQL server was installed in this desktop before.
I have downloaded MSDERelA and installed it using the command line prompt.
I can not the see the SQLServer programs under Start/Programs menu. What am
I doing wrong? Should I be installing a different program instead of
MSDE2000RelA? Please help. Thank you.
|||Thanks Jacco,
I checked as you suggested and saw that MSDE is installed. Where would I find the free version of graphical user interface that will work with MSDE? Do I need to remove MSDE to install the GUI?
-- Jacco Schalkwijk wrote: --
MSDE doesn't have a graphical user interface and it doesn't create any menu
items in the Start/Programs menu. You can check if MSDE is installed by
looking in Control Panel|Add/Remove Programs.
Jacco Schalkwijk
SQL Server MVP
"Sukhendu Barua" <anonymous@.discussions.microsoft.com> wrote in message
news:EFAACD33-0C01-426B-8D83-A32F061F9C82@.microsoft.com...
> I am new to MSDE. Not MS-SQL server was installed in this desktop before.
I have downloaded MSDERelA and installed it using the command line prompt.
I can not the see the SQLServer programs under Start/Programs menu. What am
I doing wrong? Should I be installing a different program instead of
MSDE2000RelA? Please help. Thank you.
|||You don't need to remove MSDE to install the GUI. You can download a web
based GUI from Microsoft, www.microsoft.com/sql look for the SQL Server Web
Data Administrator. There are also a host of free tools available from other
source, just try Google.
Jacco Schalkwijk
SQL Server MVP
"Sukhendu Barua" <anonymous@.discussions.microsoft.com> wrote in message
news:19A5FEAA-E692-4273-A5E1-586B95F5C03F@.microsoft.com...
> Thanks Jacco,
> I checked as you suggested and saw that MSDE is installed. Where would I
find the free version of graphical user interface that will work with MSDE?
Do I need to remove MSDE to install the GUI?
> -- Jacco Schalkwijk wrote: --
> MSDE doesn't have a graphical user interface and it doesn't create
any menu
> items in the Start/Programs menu. You can check if MSDE is installed
by
> looking in Control Panel|Add/Remove Programs.
>
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Sukhendu Barua" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
> news:EFAACD33-0C01-426B-8D83-A32F061F9C82@.microsoft.com...
before.
> I have downloaded MSDERelA and installed it using the command line
prompt.
> I can not the see the SQLServer programs under Start/Programs menu.
What am
> I doing wrong? Should I be installing a different program instead of
> MSDE2000RelA? Please help. Thank you.
>
>
|||hi,
"Sukhendu Barua" <anonymous@.discussions.microsoft.com> ha scritto nel
messaggio news:19A5FEAA-E692-4273-A5E1-586B95F5C03F@.microsoft.com...
> Thanks Jacco,
> I checked as you suggested and saw that MSDE is installed. Where would I
find the free version of
>graphical user interface that will work with MSDE? Do I need to remove
MSDE to install the GUI?
as Jacco already pointed out, you can have a look at
http://www.microsoft.com/sql/msde/partners/default.asp and or
http://www.aspfaq.com/show.asp?id=2442 for additional third parties tools..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks Jacco,
I installed the SQL Server Web Data Administrator. The installation never asked for my userid and password. When try to login what userid/pw should I be using?. I tried my windows login and pw and it did not work. Then i tried sa as userid and AStrong
SAPwd as password, did not work it either. I tried both windows authenticate mode and sql mode. The server is (local).
-- Jacco Schalkwijk wrote: --
You don't need to remove MSDE to install the GUI. You can download a web
based GUI from Microsoft, www.microsoft.com/sql look for the SQL Server Web
Data Administrator. There are also a host of free tools available from other
source, just try Google.
Jacco Schalkwijk
SQL Server MVP
"Sukhendu Barua" <anonymous@.discussions.microsoft.com> wrote in message
news:19A5FEAA-E692-4273-A5E1-586B95F5C03F@.microsoft.com...
> Thanks Jacco,
> I checked as you suggested and saw that MSDE is installed. Where would I
find the free version of graphical user interface that will work with MSDE?
Do I need to remove MSDE to install the GUI?[vbcol=seagreen]
any menu
> items in the Start/Programs menu. You can check if MSDE is installed
by[vbcol=seagreen]
> looking in Control Panel|Add/Remove Programs.
> Jacco Schalkwijk
> SQL Server MVP
message[vbcol=seagreen]
> news:EFAACD33-0C01-426B-8D83-A32F061F9C82@.microsoft.com...
before.
> I have downloaded MSDERelA and installed it using the command line
prompt.
> I can not the see the SQLServer programs under Start/Programs menu.
What am[vbcol=seagreen]
> I doing wrong? Should I be installing a different program instead of
> MSDE2000RelA? Please help. Thank you.
|||Thank you Andrea. DbaMgr2k works great!
Cheers,
Sukhendu
-- Andrea Montanari wrote: --
hi,
"Sukhendu Barua" <anonymous@.discussions.microsoft.com> ha scritto nel
messaggio news:19A5FEAA-E692-4273-A5E1-586B95F5C03F@.microsoft.com...
> Thanks Jacco,
> I checked as you suggested and saw that MSDE is installed. Where would I
find the free version of
>graphical user interface that will work with MSDE? Do I need to remove
MSDE to install the GUI?
as Jacco already pointed out, you can have a look at
http://www.microsoft.com/sql/msde/partners/default.asp and or
http://www.aspfaq.com/show.asp?id=2442 for additional third parties tools..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
sql
MSDE 2000 INSTALL FAILS URGENT HELP NEEDED
I am trying to Install MSDE 2000 A latest version
and I am getting error
product:microsoft sql server desktop engine--installation
of the microsoft distributed transaction coroordinator
package failed
and this fails. I am installing on NT 4.0 Server Sp6a
version. Please help as I need this urgently to
Install Veritas Backup Software and is very criticalPls make sure that all 3rd party and non-essential services are turned off.
You also might want to enable Verbose logging so that you can see the setup
log and see where it's failing. Use the parameter /L*v and specify the
full path to a text file where to log the messages.
Thanks,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.sql
and I am getting error
product:microsoft sql server desktop engine--installation
of the microsoft distributed transaction coroordinator
package failed
and this fails. I am installing on NT 4.0 Server Sp6a
version. Please help as I need this urgently to
Install Veritas Backup Software and is very criticalPls make sure that all 3rd party and non-essential services are turned off.
You also might want to enable Verbose logging so that you can see the setup
log and see where it's failing. Use the parameter /L*v and specify the
full path to a text file where to log the messages.
Thanks,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.sql
MSDE 2000 INSTALL FAILS URGENT HELP NEEDED
I am trying to Install MSDE 2000 A latest version
and I am getting error
product:microsoft sql server desktop engine--installation
of the microsoft distributed transaction coroordinator
package failed
and this fails. I am installing on NT 4.0 Server Sp6a
version. Please help as I need this urgently to
Install Veritas Backup Software and is very critical
Pls make sure that all 3rd party and non-essential services are turned off.
You also might want to enable Verbose logging so that you can see the setup
log and see where it's failing. Use the parameter /L*v and specify the
full path to a text file where to log the messages.
Thanks,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
and I am getting error
product:microsoft sql server desktop engine--installation
of the microsoft distributed transaction coroordinator
package failed
and this fails. I am installing on NT 4.0 Server Sp6a
version. Please help as I need this urgently to
Install Veritas Backup Software and is very critical
Pls make sure that all 3rd party and non-essential services are turned off.
You also might want to enable Verbose logging so that you can see the setup
log and see where it's failing. Use the parameter /L*v and specify the
full path to a text file where to log the messages.
Thanks,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
MSDE 2000 error
1. Am i right in assumeing MSDE 2000 and SQL Server 2000 Desktop engine Release A are the same.
2. Only people who have old MSDE shld install MSDE 2000 sp3 or sp3a, does that also mean for fresh insallation MSDE 2000 sp3 is enough.Frankly, at this stage I dont remember which file I downloaded but I guess it is SQL2kdesksp3.exe
3. I would like to use MSDE 2000 for VS.NET 2003 and I downloaded it from this site and followed the instructions given there:
http://www.microsoft.com/downloads/d...displaylang=en
3a. I know it is working because I see the green arrow light at the taskbar for start/stop and pausing the SQL Server
3b. I also downloaded the MS SQL Web Administrator from this site:
http://www.microsoft.com/downloads/d...displaylang=en
3c. But when I use the SQL web administrator to connet to SQL server it doesn't, but I still see the green light on the taskbar. Am I doing something wrong?
4. what is MSDE 2000 Deployment Toolkit Release Candidate - Do I need to install that also?
5. I plan to use VS.NET 2003 with MSDE 2000 - how do I test it from VS.NET? I do have the scripts for intallling Northwind database and when I use the OSQL utility I get the error as
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect()).
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
SQL Server Desktop Engine Rel A *is* MSDE 2000 with SP 3a already applied,
so you don't need to install SP 3a on a Release A installation. What
login/password are you using to connect, or are you using NT Authentication?
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:%23PTvP4fvEHA.908@.TK2MSFTNGP11.phx.gbl...
>
> 1. Am i right in assumeing MSDE 2000 and SQL Server 2000 Desktop engine
Release A are the same.
> 2. Only people who have old MSDE shld install MSDE 2000 sp3 or sp3a, does
that also mean for fresh insallation MSDE 2000 sp3 is enough.Frankly, at
this stage I dont remember which file I downloaded but I guess it is
SQL2kdesksp3.exe
> 3. I would like to use MSDE 2000 for VS.NET 2003 and I downloaded it from
this site and followed the instructions given there:
>
http://www.microsoft.com/downloads/d...displaylang=en
> 3a. I know it is working because I see the green arrow light at the
taskbar for start/stop and pausing the SQL Server
>
> 3b. I also downloaded the MS SQL Web Administrator from this site:
>
http://www.microsoft.com/downloads/d...displaylang=en
> 3c. But when I use the SQL web administrator to connet to SQL server it
doesn't, but I still see the green light on the taskbar. Am I doing
something wrong?
>
> 4. what is MSDE 2000 Deployment Toolkit Release Candidate - Do I need to
install that also?
> 5. I plan to use VS.NET 2003 with MSDE 2000 - how do I test it from
VS.NET? I do have the scripts for intallling Northwind database and when I
use the OSQL utility I get the error as
> [DBNETLIB]SQL Server does not exist or access denied.
> [DBNETLIB]ConnectionOpen (Connect()).
>
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.
2. Only people who have old MSDE shld install MSDE 2000 sp3 or sp3a, does that also mean for fresh insallation MSDE 2000 sp3 is enough.Frankly, at this stage I dont remember which file I downloaded but I guess it is SQL2kdesksp3.exe
3. I would like to use MSDE 2000 for VS.NET 2003 and I downloaded it from this site and followed the instructions given there:
http://www.microsoft.com/downloads/d...displaylang=en
3a. I know it is working because I see the green arrow light at the taskbar for start/stop and pausing the SQL Server
3b. I also downloaded the MS SQL Web Administrator from this site:
http://www.microsoft.com/downloads/d...displaylang=en
3c. But when I use the SQL web administrator to connet to SQL server it doesn't, but I still see the green light on the taskbar. Am I doing something wrong?
4. what is MSDE 2000 Deployment Toolkit Release Candidate - Do I need to install that also?
5. I plan to use VS.NET 2003 with MSDE 2000 - how do I test it from VS.NET? I do have the scripts for intallling Northwind database and when I use the OSQL utility I get the error as
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect()).
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
SQL Server Desktop Engine Rel A *is* MSDE 2000 with SP 3a already applied,
so you don't need to install SP 3a on a Release A installation. What
login/password are you using to connect, or are you using NT Authentication?
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:%23PTvP4fvEHA.908@.TK2MSFTNGP11.phx.gbl...
>
> 1. Am i right in assumeing MSDE 2000 and SQL Server 2000 Desktop engine
Release A are the same.
> 2. Only people who have old MSDE shld install MSDE 2000 sp3 or sp3a, does
that also mean for fresh insallation MSDE 2000 sp3 is enough.Frankly, at
this stage I dont remember which file I downloaded but I guess it is
SQL2kdesksp3.exe
> 3. I would like to use MSDE 2000 for VS.NET 2003 and I downloaded it from
this site and followed the instructions given there:
>
http://www.microsoft.com/downloads/d...displaylang=en
> 3a. I know it is working because I see the green arrow light at the
taskbar for start/stop and pausing the SQL Server
>
> 3b. I also downloaded the MS SQL Web Administrator from this site:
>
http://www.microsoft.com/downloads/d...displaylang=en
> 3c. But when I use the SQL web administrator to connet to SQL server it
doesn't, but I still see the green light on the taskbar. Am I doing
something wrong?
>
> 4. what is MSDE 2000 Deployment Toolkit Release Candidate - Do I need to
install that also?
> 5. I plan to use VS.NET 2003 with MSDE 2000 - how do I test it from
VS.NET? I do have the scripts for intallling Northwind database and when I
use the OSQL utility I get the error as
> [DBNETLIB]SQL Server does not exist or access denied.
> [DBNETLIB]ConnectionOpen (Connect()).
>
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.
MSDE 2000 error
1. Am i right in assumeing MSDE 2000 and SQL Server 2000 Desktop engine Rele
ase A are the same.
2. Only people who have old MSDE shld install MSDE 2000 sp3 or sp3a, does th
at also mean for fresh insallation MSDE 2000 sp3 is enough.Frankly, at this
stage I dont remember which file I downloaded but I guess it is SQL2kdesksp3
.exe
3. I would like to use MSDE 2000 for VS.NET 2003 and I downloaded it from th
is site and followed the instructions given there:
http://www.microsoft.com/downloads/...&displaylang=en
3a. I know it is working because I see the green arrow light at the taskbar
for start/stop and pausing the SQL Server
3b. I also downloaded the MS SQL Web Administrator from this site:
http://www.microsoft.com/downloads/...&displaylang=en
3c. But when I use the SQL web administrator to connet to SQL server it does
n't, but I still see the green light on the taskbar. Am I doing something w
rong?
4. what is MSDE 2000 Deployment Toolkit Release Candidate - Do I need to ins
tall that also?
5. I plan to use VS.NET 2003 with MSDE 2000 - how do I test it from VS.NET?
I do have the scripts for intallling Northwind database and when I use the O
SQL utility I get the error as
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect()).
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine sup
ports Post Alerts, Ratings, and Searching.SQL Server Desktop Engine Rel A *is* MSDE 2000 with SP 3a already applied,
so you don't need to install SP 3a on a Release A installation. What
login/password are you using to connect, or are you using NT Authentication?
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:%23PTvP4fvEHA.908@.TK2MSFTNGP11.phx.gbl...
>
> 1. Am i right in assumeing MSDE 2000 and SQL Server 2000 Desktop engine
Release A are the same.
> 2. Only people who have old MSDE shld install MSDE 2000 sp3 or sp3a, does
that also mean for fresh insallation MSDE 2000 sp3 is enough.Frankly, at
this stage I dont remember which file I downloaded but I guess it is
SQL2kdesksp3.exe
> 3. I would like to use MSDE 2000 for VS.NET 2003 and I downloaded it from
this site and followed the instructions given there:
>
http://www.microsoft.com/downloads/... />
laylang=en
> 3a. I know it is working because I see the green arrow light at the
taskbar for start/stop and pausing the SQL Server
>
> 3b. I also downloaded the MS SQL Web Administrator from this site:
>
http://www.microsoft.com/downloads/... />
laylang=en
> 3c. But when I use the SQL web administrator to connet to SQL server it
doesn't, but I still see the green light on the taskbar. Am I doing
something wrong?
>
> 4. what is MSDE 2000 Deployment Toolkit Release Candidate - Do I need to
install that also?
> 5. I plan to use VS.NET 2003 with MSDE 2000 - how do I test it from
VS.NET? I do have the scripts for intallling Northwind database and when I
use the OSQL utility I get the error as
> [DBNETLIB]SQL Server does not exist or access denied.
> [DBNETLIB]ConnectionOpen (Connect()).
>
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.sql
ase A are the same.
2. Only people who have old MSDE shld install MSDE 2000 sp3 or sp3a, does th
at also mean for fresh insallation MSDE 2000 sp3 is enough.Frankly, at this
stage I dont remember which file I downloaded but I guess it is SQL2kdesksp3
.exe
3. I would like to use MSDE 2000 for VS.NET 2003 and I downloaded it from th
is site and followed the instructions given there:
http://www.microsoft.com/downloads/...&displaylang=en
3a. I know it is working because I see the green arrow light at the taskbar
for start/stop and pausing the SQL Server
3b. I also downloaded the MS SQL Web Administrator from this site:
http://www.microsoft.com/downloads/...&displaylang=en
3c. But when I use the SQL web administrator to connet to SQL server it does
n't, but I still see the green light on the taskbar. Am I doing something w
rong?
4. what is MSDE 2000 Deployment Toolkit Release Candidate - Do I need to ins
tall that also?
5. I plan to use VS.NET 2003 with MSDE 2000 - how do I test it from VS.NET?
I do have the scripts for intallling Northwind database and when I use the O
SQL utility I get the error as
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect()).
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine sup
ports Post Alerts, Ratings, and Searching.SQL Server Desktop Engine Rel A *is* MSDE 2000 with SP 3a already applied,
so you don't need to install SP 3a on a Release A installation. What
login/password are you using to connect, or are you using NT Authentication?
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:%23PTvP4fvEHA.908@.TK2MSFTNGP11.phx.gbl...
>
> 1. Am i right in assumeing MSDE 2000 and SQL Server 2000 Desktop engine
Release A are the same.
> 2. Only people who have old MSDE shld install MSDE 2000 sp3 or sp3a, does
that also mean for fresh insallation MSDE 2000 sp3 is enough.Frankly, at
this stage I dont remember which file I downloaded but I guess it is
SQL2kdesksp3.exe
> 3. I would like to use MSDE 2000 for VS.NET 2003 and I downloaded it from
this site and followed the instructions given there:
>
http://www.microsoft.com/downloads/... />
laylang=en
> 3a. I know it is working because I see the green arrow light at the
taskbar for start/stop and pausing the SQL Server
>
> 3b. I also downloaded the MS SQL Web Administrator from this site:
>
http://www.microsoft.com/downloads/... />
laylang=en
> 3c. But when I use the SQL web administrator to connet to SQL server it
doesn't, but I still see the green light on the taskbar. Am I doing
something wrong?
>
> 4. what is MSDE 2000 Deployment Toolkit Release Candidate - Do I need to
install that also?
> 5. I plan to use VS.NET 2003 with MSDE 2000 - how do I test it from
VS.NET? I do have the scripts for intallling Northwind database and when I
use the OSQL utility I get the error as
> [DBNETLIB]SQL Server does not exist or access denied.
> [DBNETLIB]ConnectionOpen (Connect()).
>
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.sql
MSDE 2000 connectivity problem
Hi,
I have installed MSDE 2000 into my desktop machine.I can
connect from other machines to my desktop and accessing
databases using Query Analyser, Enterperise manager,
Profiler.but I didn't connect from ASP.NET application
using as "connectionstring".
Earlier it was worked.now its not working.
Send me your valuable reply ASAP.
Thanks and regards,
RafiqHow does your connection string look like?
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Rafiq" <anonymous@.discussions.microsoft.com> wrote in message
news:088801c3a9ab$02032c50$a401280a@.phx.gbl...
> Hi,
> I have installed MSDE 2000 into my desktop machine.I can
> connect from other machines to my desktop and accessing
> databases using Query Analyser, Enterperise manager,
> Profiler.but I didn't connect from ASP.NET application
> using as "connectionstring".
> Earlier it was worked.now its not working.
> Send me your valuable reply ASAP.
> Thanks and regards,
> Rafiq
I have installed MSDE 2000 into my desktop machine.I can
connect from other machines to my desktop and accessing
databases using Query Analyser, Enterperise manager,
Profiler.but I didn't connect from ASP.NET application
using as "connectionstring".
Earlier it was worked.now its not working.
Send me your valuable reply ASAP.
Thanks and regards,
RafiqHow does your connection string look like?
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Rafiq" <anonymous@.discussions.microsoft.com> wrote in message
news:088801c3a9ab$02032c50$a401280a@.phx.gbl...
> Hi,
> I have installed MSDE 2000 into my desktop machine.I can
> connect from other machines to my desktop and accessing
> databases using Query Analyser, Enterperise manager,
> Profiler.but I didn't connect from ASP.NET application
> using as "connectionstring".
> Earlier it was worked.now its not working.
> Send me your valuable reply ASAP.
> Thanks and regards,
> Rafiq
Wednesday, March 21, 2012
MSDE 2000 and SQL Server 2000 Personal Edition Compatibility
Are there any compatibility issues between Microsoft SQL Desktop Edition and
SQL Server 2000 Personal Edition Compatibility.
I would like to install one packaged application that uses MSDE 2000 and a
second packaged application that uses SQL Server 2000 Personal Edition.
Both seem to be using MDAC 2.8
Thanks
I dont see that there is any problem as far as compatibility is concerned.
SQL Server 2000 Personal Edition Compatibility.
I would like to install one packaged application that uses MSDE 2000 and a
second packaged application that uses SQL Server 2000 Personal Edition.
Both seem to be using MDAC 2.8
Thanks
I dont see that there is any problem as far as compatibility is concerned.
MSDE 2000 and merge modules
I have a vb.net desktop application that uses msde 2000 for its databasing. I am trying to create a setup file using the output of my desktop application and the msde 2000 merge modules in order to install my own build plus an instance of msde 2000.
The setup runs properly and then asks me to restart my machine. After the restart, however, there is no such instance running on my machine. I am adding the following internal properties to my msi file using ocra:
SQLMSDESelected 1
SqlInstanceName Midas
SqlSaPwd Password1
SqlSecurityMode SQL
SqlDataDir C:\Program Files\Microsoft SQL Server\MSSQL$Midas\Data
SqlProgramDir C:\Program Files\Microsoft SQL Server
This should create an instance of msde on my machine but when I try to connect using enterprize manager or query analizer (I connect to <<machinename>>\Midas), then I get the standard can not connect error.
I am at my witt's end and would really appreciate any help.
Thanks.
Hi,
maybe you could help me....
I'm trying to create a setup file using the VS2003 "Setup Project" and MSDE2000SP4 Merge Modules (editing properties with ORCA).
But when I run the installation file, it shows the following message:
"The Error Code is 2920".
Do you know how to fix that ?
Thanks,
Jo?o Paulo.
sqlMSDE 2000 and merge modules
I have a vb.net desktop application that uses msde 2000 for its databasing. I am trying to create a setup file using the output of my desktop application and the msde 2000 merge modules in order to install my own build plus an instance of msde 2000.
The setup runs properly and then asks me to restart my machine. After the restart, however, there is no such instance running on my machine. I am adding the following internal properties to my msi file using ocra:
SQLMSDESelected 1
SqlInstanceName Midas
SqlSaPwd Password1
SqlSecurityMode SQL
SqlDataDir C:\Program Files\Microsoft SQL Server\MSSQL$Midas\Data
SqlProgramDir C:\Program Files\Microsoft SQL Server
This should create an instance of msde on my machine but when I try to connect using enterprize manager or query analizer (I connect to <<machinename>>\Midas), then I get the standard can not connect error.
I am at my witt's end and would really appreciate any help.
Thanks.
Hi,
maybe you could help me....
I'm trying to create a setup file using the VS2003 "Setup Project" and MSDE2000SP4 Merge Modules (editing properties with ORCA).
But when I run the installation file, it shows the following message:
"The Error Code is 2920".
Do you know how to fix that ?
Thanks,
Jo?o Paulo.
Msde 2000
Hi folks!
Ive got here a Windows 2000 Professional PC and want to install the MSDE 2000 (incl. SP3) Desktop Server.
But when i execute the setup.exe the following Error Message will return:
http://www.dorst.de/sql.jpg
Here is the setup.ini
[Options]
TARGETDIR="C:\Programme\MSDE2000"
DATADIR="C:\Programme\MSDE2000\Daten"
SAPWD="*****"
SECURITYMODE=SQL
DISABLENETWORKPROTOCOLS=0
Can anyone help?
THX !!!!!
Bye
CdRNoone knows why i cant install?|||Where did you get the the MDSE CD from? In seems that it may be corrupt.
I don't recall any internet calls during any installation I have performed. The fact that the website called s in Germany makes me wonder about the validity of the installation CD.
Be careful that it isn't corrupting your system.
Is there a reason that you are installing the German version?
("C:\Programme" as opposed to "C:\Program Files")|||The MSDE is included in a Program CD of Microsoft, but i tried to download it and install the MSDE... nothing change.
"C:\Programme" <- Thats the Standard-Programm-Dir :)
thx 4 help!
Bye
Ive got here a Windows 2000 Professional PC and want to install the MSDE 2000 (incl. SP3) Desktop Server.
But when i execute the setup.exe the following Error Message will return:
http://www.dorst.de/sql.jpg
Here is the setup.ini
[Options]
TARGETDIR="C:\Programme\MSDE2000"
DATADIR="C:\Programme\MSDE2000\Daten"
SAPWD="*****"
SECURITYMODE=SQL
DISABLENETWORKPROTOCOLS=0
Can anyone help?
THX !!!!!
Bye
CdRNoone knows why i cant install?|||Where did you get the the MDSE CD from? In seems that it may be corrupt.
I don't recall any internet calls during any installation I have performed. The fact that the website called s in Germany makes me wonder about the validity of the installation CD.
Be careful that it isn't corrupting your system.
Is there a reason that you are installing the German version?
("C:\Programme" as opposed to "C:\Program Files")|||The MSDE is included in a Program CD of Microsoft, but i tried to download it and install the MSDE... nothing change.
"C:\Programme" <- Thats the Standard-Programm-Dir :)
thx 4 help!
Bye
Msde 2000
This is my first time using SQL. I installed MSDE 2000 on my desktop and after restarting my PC I see an icon in the startup area MSSQLServer with the server being my T-Tag #.
I am trying to upsize my Access DB to Sqlserver. I am still confused as to where does this server reside? How does this whole thing work?
Also, when I tried to upsize my db I got an overflow error.
Could someone please explain how does this work?
Thanks,
DHYou really should have your instance name be one word with no special characters, so you might want to reinstall MSDE to start with.
The MSDE SQL Server can reside anywhere. A server is always preferrable. You just point to it in Access with ODBC or an Access Data Project.
Can you post the exact message you got on the upsize? This is probably an arithmetic overflow error, but who knows without seeing the error.|||Doesn't MSDE create a named instance by default?
Also, the poster is probably referring to the Tag # of the PC or a laptop, like Dell usually assignes to it's products, something like YG2PBF, so I don't see any problem with it.|||Doesn't MSDE create a named instance by default?
Also, the poster is probably referring to the Tag # of the PC or a laptop, like Dell usually assignes to it's products, something like YG2PBF, so I don't see any problem with it.
Yes, you are right. It uses the TTAG number of the desktop. The MSSQL icon in the start up area also had other names unser the serverl ist. Anyway, attached is the screen shot of the verflow error I encountered.|||Yes, you are right. It uses the TTAG number of the desktop. The MSSQL icon in the start up area also had other names unser the serverl ist. Anyway, attached is the screen shot of the verflow error I encountered.
OOps ..I forgot the attachment..
I am trying to upsize my Access DB to Sqlserver. I am still confused as to where does this server reside? How does this whole thing work?
Also, when I tried to upsize my db I got an overflow error.
Could someone please explain how does this work?
Thanks,
DHYou really should have your instance name be one word with no special characters, so you might want to reinstall MSDE to start with.
The MSDE SQL Server can reside anywhere. A server is always preferrable. You just point to it in Access with ODBC or an Access Data Project.
Can you post the exact message you got on the upsize? This is probably an arithmetic overflow error, but who knows without seeing the error.|||Doesn't MSDE create a named instance by default?
Also, the poster is probably referring to the Tag # of the PC or a laptop, like Dell usually assignes to it's products, something like YG2PBF, so I don't see any problem with it.|||Doesn't MSDE create a named instance by default?
Also, the poster is probably referring to the Tag # of the PC or a laptop, like Dell usually assignes to it's products, something like YG2PBF, so I don't see any problem with it.
Yes, you are right. It uses the TTAG number of the desktop. The MSSQL icon in the start up area also had other names unser the serverl ist. Anyway, attached is the screen shot of the verflow error I encountered.|||Yes, you are right. It uses the TTAG number of the desktop. The MSSQL icon in the start up area also had other names unser the serverl ist. Anyway, attached is the screen shot of the verflow error I encountered.
OOps ..I forgot the attachment..
MSDE 1.0 --> MSDE 2000 DB Connection Failure
Just recently updated to MSDE 2000 using the SP3 Desktop upgrade. Now when this software runs it cannot connect to the Database.
I believe the problem to come in a line wrote as so:
BSTR bstrOpen = gServerName.AllocSysString();
although I'm not 100%.
Just wondering if anyone might had the same problem with MSDE 2000 and what they did to fix it. Thanks!
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
Hi,
One of the things that's different about MSDE2000 is that by default, tcp is
not enabled. You might need to re-enable it. You can do this by running
svrnetcn.exe.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:%234NbSXufEHA.2984@.tk2msftngp13.phx.gbl...
> Just recently updated to MSDE 2000 using the SP3 Desktop upgrade. Now
when this software runs it cannot connect to the Database.
> I believe the problem to come in a line wrote as so:
> BSTR bstrOpen = gServerName.AllocSysString();
> although I'm not 100%.
> Just wondering if anyone might had the same problem with MSDE 2000 and
what they did to fix it. Thanks!
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.
I believe the problem to come in a line wrote as so:
BSTR bstrOpen = gServerName.AllocSysString();
although I'm not 100%.
Just wondering if anyone might had the same problem with MSDE 2000 and what they did to fix it. Thanks!
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
Hi,
One of the things that's different about MSDE2000 is that by default, tcp is
not enabled. You might need to re-enable it. You can do this by running
svrnetcn.exe.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:%234NbSXufEHA.2984@.tk2msftngp13.phx.gbl...
> Just recently updated to MSDE 2000 using the SP3 Desktop upgrade. Now
when this software runs it cannot connect to the Database.
> I believe the problem to come in a line wrote as so:
> BSTR bstrOpen = gServerName.AllocSysString();
> although I'm not 100%.
> Just wondering if anyone might had the same problem with MSDE 2000 and
what they did to fix it. Thanks!
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.
Monday, March 19, 2012
MSDE > SQL Express
We have a product on the market, with 100k or so installs that use MSDE as its database (desktop application in .net). Our number 1 complaint is massive installation problems with MSDE.
Now, we are stuck a bit - first, we need to release a Vista Compatible version - which means no MSDE. We also need to migrate users from MSDE to SQL Express, with no data loss (we deal with financial information, and people tend to have zero tolerance for data loss here).
So, I have large scale reservations for two reasons - first, Microsoft's track record in supporting and making MSDE in the past has not been stellar.
With that said - are the multiple installation failure issues fixed in SQL Express? Did MS make the effort to get SQL Express to install on Win2k/XP/Vista improved? Are their benchmark figures out there regarding SQL Express install failure rates?
Additionally, can I get some information regarding MSDE to SQL Express upgrades done during for existing customers?
jason
Hi Jason,
Great strides have been made in installation for SQL Express and it is much better than MSDE. This is not to say there are no issues, a quick search of this forum will confirm that there are, but I have not seen the kind of wholesale failures that were common with MSDE. I think SQL Express is way better for install than MSDE.
I don't know of anyone that tracks benchmarks such as you describe, sorry. I can point you to an article that we have that describes best practices for upgrading from MSDE to SQL Express, you can find it here. I have confidence that our upgrade procedure will not harm or lose our data since your database files are just left in place and then attached once the new server is installed, but I would be remise to not remind you that you should take responsibility for protecting your own important data.
I'd say that it's critical to backup your databases as a first step of any migration process. Additionally, you may want to consider doing a side by side upgrade in stead of in place to give you maximum control. During a side by side upgrade, you manually move your databases, so you can choose to use a copy (leaving the original safe) or even migrate your data by restoring a backup rather than using the original mdf. One thing to remember, once the database is converted to SQL 2005, it can't go back to 2000 format. If you are concerned that you might want to roll back the migration, you need to ensure that you keep a copy of the 2000 format database around until migration is complete.
Mike
Monday, March 12, 2012
MSDE - Unknown Server
Hello,
I installed software called AutoAPP on a users desktop and this software
automatically installs MSDE (No idea what version). When run under the
administrator account everything is fine. When the user logs on under their
account (power user) SQL Icon is on the task bar, but it is blank \\ -
Unknown Server. I have to manually type in the laptop name in the server
field of the SQL Server Service Manager and then the arrow will go green.
Does anyone know why under Administrator account the server name is there,
but not under the users profile? It is annoying having to type in the
computer each time the computer reboots, giving the user Administrative
access to their computer is not really an option. Once the computer name is
entered under the user account everything seems to function normally.
Laptop is running Windows XP Pro SP1
Thank You.
hi John,
"John J. Rambone" <lgm_rambone@.remove.hotmail.com> ha scritto nel
messaggio news:uANQsnFuEHA.1472@.TK2MSFTNGP10.phx.gbl
> Hello,
> I installed software called AutoAPP on a users desktop and this
> software automatically installs MSDE (No idea what version). When
> run under the administrator account everything is fine. When the
> user logs on under their account (power user) SQL Icon is on the task
> bar, but it is blank \\ - Unknown Server. I have to manually type in
> the laptop name in the server field of the SQL Server Service Manager
> and then the arrow will go green. Does anyone know why under
> Administrator account the server name is there, but not under the
> users profile? It is annoying having to type in the computer each
> time the computer reboots, giving the user Administrative access to
> their computer is not really an option. Once the computer name is
> entered under the user account everything seems to function normally.
> Laptop is running Windows XP Pro SP1
is the Service Manager only that does not enlist the local server, or is the
MSDE service itself that is not running when logging as a power user?
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
|||> is the Service Manager only that does not enlist the local server, or is
> the
> MSDE service itself that is not running when logging as a power user?
I uninstalled everything, but once I reinstall I will check under the
Services and Applications -> Services to make sure it is running. I'm
almost positive it is running and the Service manager does load on boot up,
but the circle will not have the green arrow. If I open the Service Manager
the drop down for the Server field will be empty. I type in the name of the
local comptuer i.e. laptop1 and it arrow goes green and the application can
access the database. It is just annoying to have to type in the computer
name each time. I will very 100% for sure if the service is running in the
next day or so, once I get a chance to work on the users laptop again.
Thanks You.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2u4493F26ob6nU1@.uni-berlin.de...
> hi John,
> "John J. Rambone" <lgm_rambone@.remove.hotmail.com> ha scritto nel
> messaggio news:uANQsnFuEHA.1472@.TK2MSFTNGP10.phx.gbl
>
> --
> 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
>
I installed software called AutoAPP on a users desktop and this software
automatically installs MSDE (No idea what version). When run under the
administrator account everything is fine. When the user logs on under their
account (power user) SQL Icon is on the task bar, but it is blank \\ -
Unknown Server. I have to manually type in the laptop name in the server
field of the SQL Server Service Manager and then the arrow will go green.
Does anyone know why under Administrator account the server name is there,
but not under the users profile? It is annoying having to type in the
computer each time the computer reboots, giving the user Administrative
access to their computer is not really an option. Once the computer name is
entered under the user account everything seems to function normally.
Laptop is running Windows XP Pro SP1
Thank You.
hi John,
"John J. Rambone" <lgm_rambone@.remove.hotmail.com> ha scritto nel
messaggio news:uANQsnFuEHA.1472@.TK2MSFTNGP10.phx.gbl
> Hello,
> I installed software called AutoAPP on a users desktop and this
> software automatically installs MSDE (No idea what version). When
> run under the administrator account everything is fine. When the
> user logs on under their account (power user) SQL Icon is on the task
> bar, but it is blank \\ - Unknown Server. I have to manually type in
> the laptop name in the server field of the SQL Server Service Manager
> and then the arrow will go green. Does anyone know why under
> Administrator account the server name is there, but not under the
> users profile? It is annoying having to type in the computer each
> time the computer reboots, giving the user Administrative access to
> their computer is not really an option. Once the computer name is
> entered under the user account everything seems to function normally.
> Laptop is running Windows XP Pro SP1
is the Service Manager only that does not enlist the local server, or is the
MSDE service itself that is not running when logging as a power user?
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
|||> is the Service Manager only that does not enlist the local server, or is
> the
> MSDE service itself that is not running when logging as a power user?
I uninstalled everything, but once I reinstall I will check under the
Services and Applications -> Services to make sure it is running. I'm
almost positive it is running and the Service manager does load on boot up,
but the circle will not have the green arrow. If I open the Service Manager
the drop down for the Server field will be empty. I type in the name of the
local comptuer i.e. laptop1 and it arrow goes green and the application can
access the database. It is just annoying to have to type in the computer
name each time. I will very 100% for sure if the service is running in the
next day or so, once I get a chance to work on the users laptop again.
Thanks You.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2u4493F26ob6nU1@.uni-berlin.de...
> hi John,
> "John J. Rambone" <lgm_rambone@.remove.hotmail.com> ha scritto nel
> messaggio news:uANQsnFuEHA.1472@.TK2MSFTNGP10.phx.gbl
>
> --
> 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
>
MSDE - Start Databases
Hello
I'm using SQL Server 2000 - 8.00.760 Desktop Engine.
When the SQL Server starts, it just start databases master, model and tempdb. The databases that I have created don't start. They just start when I connect to them for the first time.
What I can do to start my own database when the SQL Server starts?
Thank you.
All databases are opened at startup if they are attached to SQl Server. If you have switched on the autoclose option, they are in common closed (but not stopped) after the last user disconnected.
jens Suessmeyer.
http://www.sqlserver2005.de
|||I did't switched on the autoclose option - it is off, but my database just start on first use, causing a delay on my application while it starts. When it is already started, I have no delay. I need start my database when SQLServer (MSDE) starts. Is there anything to do to start my database on start of SQLServer (MSDE)?|||The Service is autostart, but my own databases just start when I connect to them to the first time.
Is there anything to do to auto start databases?
Thanks.
|||Are you sure you are using a MSDE database not a sqlserver express database. This sounds like you are using user instances which are only available after connecting the first time. Where do you actually administer the SQL server databases ? After starting the server do you see the entries in sysdatabase tables / views using SELECT * from sysdatabases ?HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||
I am using MSDE database. To administer SQL Server I use OSQL.
After start the server I ran SELECT * from sysdatabases. My own databases are listed.
|||If the databases are listed they should be available. use the SELECT name, mode, status,status2 from sysdatabases to check their current status. What is currently displayed ?HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||
I have three databases. They are listed and the databases master, model, msdb and tempdb are listed too.
After start SQLServer, the SELECT results the same values for my three databases: mode = 0, status = 1073741848 and status2 = 16777216.
Here, my own databases are not started. In the first connect to the database I has a delay, because they are not started.
Then, I connect to one and the value for status changes to 24. Now, it is started.
Any idea?
MSDE - Start Databases
Hello
I'm using SQL Server 2000 - 8.00.760 Desktop Engine.
When the SQL Server starts, it just start databases master, model and tempdb. The databases that I have created don't start. They just start when I connect to them for the first time.
What I can do to start my own database when the SQL Server starts?
Thank you.
All databases are opened at startup if they are attached to SQl Server. If you have switched on the autoclose option, they are in common closed (but not stopped) after the last user disconnected.jens Suessmeyer.
http://www.sqlserver2005.de
|||I did't switched on the autoclose option - it is off, but my database just start on first use, causing a delay on my application while it starts. When it is already started, I have no delay. I need start my database when SQLServer (MSDE) starts. Is there anything to do to start my database on start of SQLServer (MSDE)?|||The Service is autostart, but my own databases just start when I connect to them to the first time.
Is there anything to do to auto start databases?
Thanks.
|||Are you sure you are using a MSDE database not a sqlserver express database. This sounds like you are using user instances which are only available after connecting the first time. Where do you actually administer the SQL server databases ? After starting the server do you see the entries in sysdatabase tables / views using SELECT * from sysdatabases ?HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de|||
I am using MSDE database. To administer SQL Server I use OSQL.
After start the server I ran SELECT * from sysdatabases. My own databases are listed.
|||If the databases are listed they should be available. use the SELECT name, mode, status,status2 from sysdatabases to check their current status. What is currently displayed ?HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de|||
I have three databases. They are listed and the databases master, model, msdb and tempdb are listed too.
After start SQLServer, the SELECT results the same values for my three databases: mode = 0, status = 1073741848 and status2 = 16777216.
Here, my own databases are not started. In the first connect to the database I has a delay, because they are not started.
Then, I connect to one and the value for status changes to 24. Now, it is started.
Any idea?
Wednesday, March 7, 2012
msde
i have 2 computers 1 desktop dell the other a hp laptop both run windows xp
home , but only the laptop will show the sever running. I would like to get
the same on my desktop but i do not know how if someone could show me how to
set it up on desktop i would appreciate.
ty john myrick
hi John,
john m wrote:
> i have 2 computers 1 desktop dell the other a hp laptop both run
> windows xp home , but only the laptop will show the sever running. I
> would like to get the same on my desktop but i do not know how if
> someone could show me how to set it up on desktop i would appreciate.
what do you mean by "but only the laptop will show the sever running" ?
is the MSDE instance service not running or just not showing in the SQL
Server Service Manager?
(http://support.microsoft.com/default...b;EN-US;814132)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
home , but only the laptop will show the sever running. I would like to get
the same on my desktop but i do not know how if someone could show me how to
set it up on desktop i would appreciate.
ty john myrick
hi John,
john m wrote:
> i have 2 computers 1 desktop dell the other a hp laptop both run
> windows xp home , but only the laptop will show the sever running. I
> would like to get the same on my desktop but i do not know how if
> someone could show me how to set it up on desktop i would appreciate.
what do you mean by "but only the laptop will show the sever running" ?
is the MSDE instance service not running or just not showing in the SQL
Server Service Manager?
(http://support.microsoft.com/default...b;EN-US;814132)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Subscribe to:
Posts (Atom)