MSDE Service Manager on XP Pro SP2

I recently installed MSDE 2K on a Windows XP SP2 system. Everything appears
to be working fine, with the exception of the service manager. For some
reason, it will not find the system on the local network and will not
connect to it if I type the name in the server name area. Is this normal or
am I just missing something? Thanks in advance.
hi David,
"David Young" <cdyoung@.uta.edu> ha scritto nel messaggio
news:eBToEMg3EHA.3840@.tk2msftngp13.phx.gbl
> I recently installed MSDE 2K on a Windows XP SP2 system. Everything
> appears to be working fine, with the exception of the service
> manager. For some reason, it will not find the system on the local
> network and will not connect to it if I type the name in the server
> name area. Is this normal or am I just missing something? Thanks in
> advance.
actually, for local instances connections, WinXP sp2 should not be a
problem, but only for remote connections :D
as regard the Service Manager not showing the instance name, this is a known
issue when network protocols are disabled (default setting) as you can see
in http://support.microsoft.com/default...b;EN-US;814132
as regard directly typing in the instance name... did you provide the name
in the ComputerName\InstanceName format ( or just (local)\InstanceName) ?
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 prototyping

I haven't used MSDE yet. Does it run with an Enterprise Manager & Sql analyser interface?
I'm working on an asp.net vb project using sql2000. Users request me to create a protype for their review and training use. Can I deploy my project with only dlls forthe front end and an MSDE backend created from a script of the original Sql2000 database? Is there any potential discrepacy or problem with my prototyping plan? How can I copy my original database from sql2000 to msde?

Thanks for any help.Yes, Enterprise Manager and Query Analyzer can be interfaces to MSDE.

Yes, you can use MSDE as the back end for development but deploy to a SQL Server 2000 database.

When I mean "can" I mean "technically possible". I am not 100% sure of "legally possible". The licensing information for MSDE is fairly confusion, IMO.

The SQL Server 2000 Developer's edition is made specifically for situations like yours. It is $49.95 US and would give you the EM and QA tools plus the database. SeeDevelopment Edition Licensing.

I think the best way to transfer the data and schema would be to restore a backup.

Terri

MSDE problems

Hi!

I'm working on a website that will be a webshop in the end. I chosed MSDE as database for the project. Now I have a problem. When i want to have a counter (for the cusomers number for exampel) i can't turn autoincresement on. Well I can, but I can't save it. If i try I get an errormessage.
Why is it so and how will i get it to work?
I'm running the newest version...
Thanks for any help!What is the error message you are receiving?

In order to make a column an Identity column the data type must be integer and it may not allow nulls.

Terri|||I have translated the errormessage from swedish to english. I don't think it's absolutley correkt translated but i hope you will understand it anyway:
(And yes i have the column as Int and not allow nulls)

There was an error saving the design of this table. No changes were made.

[Microsoft][ODBC SQL server driver][SQL server] Unable to create standardvalue on colums with IDENTITY-attribut. Tabel 'tbkunder', column 'kundnummer.
[Microsoft][ODBC SQL server driver][SQL server] Unable to create restriction. Watch previous errormessage.|||This is very difficult with the language difference.

It sounds to me like you are trying to set the IDENTITY property on a column that has a Default Value set, which can't be done.

Terri

MSDE Performance Governor - knowing when its kicked in

I'm working on a VB.NET project where we are intending to use MSDE as our
back-end database. The actual number of users is expected to be low and I
don't have any concerns as to whether MSDE will be up to the job (most of
the time). I'm aware that if we end up with lots of users connecting to our
site at once (which may happen as certain times in the year when people need
information for deadlines) then the performance governor in MSDE will kick
in and slow everything down.

What I don't know is how do I find out whether the performance governor has
kicked in?

I would like to know how to monitor this so we can make an educated decision
as to when we need to migrate to a full version of SQL Server (if at all).

Can anyone point me in the right direction for finding this out?

thanks,

Brian Cryer."Brian Cryer" <brianc@.127.0.0.1.activesol.co.uk> wrote in message
news:1106559318.8377.0@.damia.uk.clara.net...
> I'm working on a VB.NET project where we are intending to use MSDE as our
> back-end database. The actual number of users is expected to be low and I
> don't have any concerns as to whether MSDE will be up to the job (most of
> the time). I'm aware that if we end up with lots of users connecting to
> our
> site at once (which may happen as certain times in the year when people
> need
> information for deadlines) then the performance governor in MSDE will kick
> in and slow everything down.
> What I don't know is how do I find out whether the performance governor
> has
> kicked in?
> I would like to know how to monitor this so we can make an educated
> decision
> as to when we need to migrate to a full version of SQL Server (if at all).
> Can anyone point me in the right direction for finding this out?
> thanks,
> Brian Cryer.

Check out DBCC CONCURRENCYVIOLATION in Books Online. If you don't already
have the latest version of BOL, then you should download it, as it has more
detailed information about MSDE and the workload governor that wasn't in
previous versions.

Simon|||"Simon Hayes" <sql@.hayes.ch> wrote in message
news:41f4c703$1_1@.news.bluewin.ch...
> "Brian Cryer" <brianc@.127.0.0.1.activesol.co.uk> wrote in message
> news:1106559318.8377.0@.damia.uk.clara.net...
> > I'm working on a VB.NET project where we are intending to use MSDE as
our
> > back-end database. The actual number of users is expected to be low and
I
> > don't have any concerns as to whether MSDE will be up to the job (most
of
> > the time). I'm aware that if we end up with lots of users connecting to
> > our
> > site at once (which may happen as certain times in the year when people
> > need
> > information for deadlines) then the performance governor in MSDE will
kick
> > in and slow everything down.
> > What I don't know is how do I find out whether the performance governor
> > has
> > kicked in?
> > I would like to know how to monitor this so we can make an educated
> > decision
> > as to when we need to migrate to a full version of SQL Server (if at
all).
> > Can anyone point me in the right direction for finding this out?
> > thanks,
> > Brian Cryer.
> Check out DBCC CONCURRENCYVIOLATION in Books Online. If you don't already
> have the latest version of BOL, then you should download it, as it has
more
> detailed information about MSDE and the workload governor that wasn't in
> previous versions.
> Simon

Excellent Simon. Just what I was after.

Many Thanks.

Brian.

MSDE not working

I have installed MSDE on a computer but when I try to create an odbc
connection to it, I can't find the server in the list.
It seems that it isn't running, but I have checked the service to see if it
is running, and it is.
I am trying this on a system that has SQL Server for developers on it.
Could this be causing the problem?
Can someone point me in the right direction on this?
How are you tring to connect. I take it this is a named instance so what
error do you get if you try and connect with osql e.g.
osql -E -S.\INSTANCENAME
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Lance Geeck" <lgeeck@.cox.net> wrote in message
news:_RzIc.19690$yc.8850@.fed1read06...
> I have installed MSDE on a computer but when I try to create an odbc
> connection to it, I can't find the server in the list.
> It seems that it isn't running, but I have checked the service to see if
it
> is running, and it is.
> I am trying this on a system that has SQL Server for developers on it.
> Could this be causing the problem?
> Can someone point me in the right direction on this?
>
>
|||Jasper,
Thanks for responding.
The error message says:
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect() ).
Thanks
Lance
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:uS%23G5vEaEHA.3420@.TK2MSFTNGP12.phx.gbl...
> How are you tring to connect. I take it this is a named instance so what
> error do you get if you try and connect with osql e.g.
> osql -E -S.\INSTANCENAME
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Lance Geeck" <lgeeck@.cox.net> wrote in message
> news:_RzIc.19690$yc.8850@.fed1read06...
> it
>

MSDE not working

I have installed MSDE on a computer but when I try to create an odbc
connection to it, I can't find the server in the list.
It seems that it isn't running, but I have checked the service to see if it
is running, and it is.
I am trying this on a system that has SQL Server for developers on it.
Could this be causing the problem?
Can someone point me in the right direction on this?How are you tring to connect. I take it this is a named instance so what
error do you get if you try and connect with osql e.g.
osql -E -S.\INSTANCENAME
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Lance Geeck" <lgeeck@.cox.net> wrote in message
news:_RzIc.19690$yc.8850@.fed1read06...
> I have installed MSDE on a computer but when I try to create an odbc
> connection to it, I can't find the server in the list.
> It seems that it isn't running, but I have checked the service to see if
it
> is running, and it is.
> I am trying this on a system that has SQL Server for developers on it.
> Could this be causing the problem?
> Can someone point me in the right direction on this?
>
>|||Jasper,
Thanks for responding.
The error message says:
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect() ).
Thanks
Lance
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:uS%23G5vEaEHA.3420@.TK2MSFTNGP12.phx.gbl...
> How are you tring to connect. I take it this is a named instance so what
> error do you get if you try and connect with osql e.g.
> osql -E -S.\INSTANCENAME
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Lance Geeck" <lgeeck@.cox.net> wrote in message
> news:_RzIc.19690$yc.8850@.fed1read06...
> it
>

MSDE not working

I have installed MSDE on a computer but when I try to create an odbc
connection to it, I can't find the server in the list.
It seems that it isn't running, but I have checked the service to see if it
is running, and it is.
I am trying this on a system that has SQL Server for developers on it.
Could this be causing the problem?
Can someone point me in the right direction on this?How are you tring to connect. I take it this is a named instance so what
error do you get if you try and connect with osql e.g.
osql -E -S.\INSTANCENAME
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Lance Geeck" <lgeeck@.cox.net> wrote in message
news:_RzIc.19690$yc.8850@.fed1read06...
> I have installed MSDE on a computer but when I try to create an odbc
> connection to it, I can't find the server in the list.
> It seems that it isn't running, but I have checked the service to see if
it
> is running, and it is.
> I am trying this on a system that has SQL Server for developers on it.
> Could this be causing the problem?
> Can someone point me in the right direction on this?
>
>|||Jasper,
Thanks for responding.
The error message says:
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect() ).
Thanks
Lance
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:uS%23G5vEaEHA.3420@.TK2MSFTNGP12.phx.gbl...
> How are you tring to connect. I take it this is a named instance so what
> error do you get if you try and connect with osql e.g.
> osql -E -S.\INSTANCENAME
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Lance Geeck" <lgeeck@.cox.net> wrote in message
> news:_RzIc.19690$yc.8850@.fed1read06...
> > I have installed MSDE on a computer but when I try to create an odbc
> > connection to it, I can't find the server in the list.
> >
> > It seems that it isn't running, but I have checked the service to see if
> it
> > is running, and it is.
> >
> > I am trying this on a system that has SQL Server for developers on it.
> > Could this be causing the problem?
> >
> > Can someone point me in the right direction on this?
> >
> >
> >
>sql

MSDE installer problem

Hi
I'm working in visual C++ and through it I start MSDE setup.exe. I have to
wait in my VC++ code before the MSDE installer is finished totally. The
problem i'm having is that as soon as I initiate the process of MSDE
setup.exe, i get its finished status in my VC waiting code, though the
installer is still running. I've tried running the MSDE setup.exe from the
command line and i see that the status also come back to prompt just a
second after the setup.exe is run. I was wondering how can i keep the
control from coming back to the setup.exe instantiating application unless
the whole setup.exe is complete. Hope i've made my point clear.
Regards
Usman Jamil
Hi Usman,
Try this code: here WaitForSingleObject( ) waits till your process gets completed. I used the same for installing MSDE through my setup launcher.
Cheers
Piyush
int ExecCmd(char * pszCmd )
{
BOOL bReturnVal = false ;
STARTUPINFO si ;
DWORD dwExitCode ;
SECURITY_ATTRIBUTES saProcess, saThread ;
PROCESS_INFORMATION process_info ;
ZeroMemory(&si, sizeof(si)) ;
si.cb = sizeof(si) ;
saProcess.nLength = sizeof(saProcess) ;
saProcess.lpSecurityDescriptor = NULL ;
saProcess.bInheritHandle = TRUE ;
saThread.nLength = sizeof(saThread) ;
saThread.lpSecurityDescriptor = NULL ;
saThread.bInheritHandle = FALSE ;
bReturnVal = CreateProcess(NULL, (LPTSTR)pszCmd, &saProcess, &saThread, FALSE,
DETACHED_PROCESS,
NULL,
NULL,
&si,
&process_info) ;
if (bReturnVal)
{
CloseHandle( process_info.hThread ) ;
WaitForSingleObject( process_info.hProcess, INFINITE ) ;
GetExitCodeProcess( process_info.hProcess, &dwExitCode ) ;
CloseHandle( process_info.hProcess ) ;
}
return dwExitCode;
}
"Usman Jamil" <usman@.advcomm.net> wrote in message news:O11ArM2WEHA.2716@.tk2msftngp13.phx.gbl...
> Hi
> I'm working in visual C++ and through it I start MSDE setup.exe. I have to
> wait in my VC++ code before the MSDE installer is finished totally. The
> problem i'm having is that as soon as I initiate the process of MSDE
> setup.exe, i get its finished status in my VC waiting code, though the
> installer is still running. I've tried running the MSDE setup.exe from the
> command line and i see that the status also come back to prompt just a
> second after the setup.exe is run. I was wondering how can i keep the
> control from coming back to the setup.exe instantiating application unless
> the whole setup.exe is complete. Hope i've made my point clear.
> Regards
> Usman Jamil
>
|||Hi viki
I dont know how it worked in your case but its not supposed to work and i've
checked it too. It wont work coz the Waitforsingleobject would also return
as soon as the process created is finished. and when we run the process
setup.exe, this setup.exe script asks the windows installer service to run
the actull installer and it exits itself thus breaking the
waitforsingleobject lock too. So it would not work for MSDE installer from
C++ code. Anyway thanx for your help.
Still waiting for a solution..
Regards
Usman Jamil
"viki" <piyush__jain@.hotmail.com> wrote in message
news:eZ5ZQ3MXEHA.1144@.TK2MSFTNGP10.phx.gbl...
Hi Usman,
Try this code: here WaitForSingleObject( ) waits till your process gets
completed. I used the same for installing MSDE through my setup launcher.
Cheers
Piyush
int ExecCmd(char * pszCmd )
{
BOOL bReturnVal = false ;
STARTUPINFO si ;
DWORD dwExitCode ;
SECURITY_ATTRIBUTES saProcess, saThread ;
PROCESS_INFORMATION process_info ;
ZeroMemory(&si, sizeof(si)) ;
si.cb = sizeof(si) ;
saProcess.nLength = sizeof(saProcess) ;
saProcess.lpSecurityDescriptor = NULL ;
saProcess.bInheritHandle = TRUE ;
saThread.nLength = sizeof(saThread) ;
saThread.lpSecurityDescriptor = NULL ;
saThread.bInheritHandle = FALSE ;
bReturnVal = CreateProcess(NULL, (LPTSTR)pszCmd, &saProcess, &saThread,
FALSE,
DETACHED_PROCESS,
NULL,
NULL,
&si,
&process_info) ;
if (bReturnVal)
{
CloseHandle( process_info.hThread ) ;
WaitForSingleObject( process_info.hProcess, INFINITE ) ;
GetExitCodeProcess( process_info.hProcess, &dwExitCode ) ;
CloseHandle( process_info.hProcess ) ;
}
return dwExitCode;
}
"Usman Jamil" <usman@.advcomm.net> wrote in message
news:O11ArM2WEHA.2716@.tk2msftngp13.phx.gbl...
> Hi
> I'm working in visual C++ and through it I start MSDE setup.exe. I have to
> wait in my VC++ code before the MSDE installer is finished totally. The
> problem i'm having is that as soon as I initiate the process of MSDE
> setup.exe, i get its finished status in my VC waiting code, though the
> installer is still running. I've tried running the MSDE setup.exe from the
> command line and i see that the status also come back to prompt just a
> second after the setup.exe is run. I was wondering how can i keep the
> control from coming back to the setup.exe instantiating application unless
> the whole setup.exe is complete. Hope i've made my point clear.
> Regards
> Usman Jamil
>
|||Hi viki
I dont know how it worked in your case but its not supposed to work and i've
checked it too. It wont work coz the Waitforsingleobject would also return
as soon as the process created is finished. and when we run the process
setup.exe, this setup.exe script asks the windows installer service to run
the actull installer and it exits itself thus breaking the
waitforsingleobject lock too. So it would not work for MSDE installer from
C++ code. Anyway thanx for your help.
Still waiting for a solution..
Regards
Usman Jamil
"viki" <piyush__jain@.hotmail.com> wrote in message
news:eZ5ZQ3MXEHA.1144@.TK2MSFTNGP10.phx.gbl...
Hi Usman,
Try this code: here WaitForSingleObject( ) waits till your process gets
completed. I used the same for installing MSDE through my setup launcher.
Cheers
Piyush
int ExecCmd(char * pszCmd )
{
BOOL bReturnVal = false ;
STARTUPINFO si ;
DWORD dwExitCode ;
SECURITY_ATTRIBUTES saProcess, saThread ;
PROCESS_INFORMATION process_info ;
ZeroMemory(&si, sizeof(si)) ;
si.cb = sizeof(si) ;
saProcess.nLength = sizeof(saProcess) ;
saProcess.lpSecurityDescriptor = NULL ;
saProcess.bInheritHandle = TRUE ;
saThread.nLength = sizeof(saThread) ;
saThread.lpSecurityDescriptor = NULL ;
saThread.bInheritHandle = FALSE ;
bReturnVal = CreateProcess(NULL, (LPTSTR)pszCmd, &saProcess, &saThread,
FALSE,
DETACHED_PROCESS,
NULL,
NULL,
&si,
&process_info) ;
if (bReturnVal)
{
CloseHandle( process_info.hThread ) ;
WaitForSingleObject( process_info.hProcess, INFINITE ) ;
GetExitCodeProcess( process_info.hProcess, &dwExitCode ) ;
CloseHandle( process_info.hProcess ) ;
}
return dwExitCode;
}
"Usman Jamil" <usman@.advcomm.net> wrote in message
news:O11ArM2WEHA.2716@.tk2msftngp13.phx.gbl...
> Hi
> I'm working in visual C++ and through it I start MSDE setup.exe. I have to
> wait in my VC++ code before the MSDE installer is finished totally. The
> problem i'm having is that as soon as I initiate the process of MSDE
> setup.exe, i get its finished status in my VC waiting code, though the
> installer is still running. I've tried running the MSDE setup.exe from the
> command line and i see that the status also come back to prompt just a
> second after the setup.exe is run. I was wondering how can i keep the
> control from coming back to the setup.exe instantiating application unless
> the whole setup.exe is complete. Hope i've made my point clear.
> Regards
> Usman Jamil
>

MSDE Installation and usage on client PC. URGENT HELP!

Hi All,
Have developed Client/Server (VB.NET) application with SQL Server 2000
backend engine. It is working fine. This application can connect to
Database engine if user in our LAN or WAN.
Now, my users need to work on application while they are not in our
network. For instance from Hotel, travel etc.. To achieve this, I
thought to have MSDE installed on user's laptop and get copy of SQL 2k
DB on user machine. But. here I got stuck !. Woudl really appreciate if
you could help me !
MSDE engine, I hope that I can d/load from MS site. Belive that can be
installed easly like other MS application. Upon installation, how can I
get my SQL 2K DB attached or Sychronized ?
What about login id (like "sa") to connect to MSDE engine from my
applciation. I will modify my application user to choose DB engine LOCAL
or LAN. If LAN, I will use my existing connection string. But, LOCAL,
what would be the provider, password, user id etc..
Never user MSDE, so queries will be bit more.
Appreciate all your help to get this resolved.
Many thanks in advance..
Regards,
AJ
*** Sent via Developersdex http://www.developersdex.com ***You have to setup some replication, please refer to the BOL or ressources in
the internet for that, there are tons of examples out there.
HTH, Jens SUessmeyer.
--
http://www.sqlserver2005.de
--
"Ahmed Jewahar" <ahmed.jewahar@.dhl.com> schrieb im Newsbeitrag
news:%23klgAGhWFHA.3280@.TK2MSFTNGP09.phx.gbl...
> Hi All,
> Have developed Client/Server (VB.NET) application with SQL Server 2000
> backend engine. It is working fine. This application can connect to
> Database engine if user in our LAN or WAN.
> Now, my users need to work on application while they are not in our
> network. For instance from Hotel, travel etc.. To achieve this, I
> thought to have MSDE installed on user's laptop and get copy of SQL 2k
> DB on user machine. But. here I got stuck !. Woudl really appreciate if
> you could help me !
> MSDE engine, I hope that I can d/load from MS site. Belive that can be
> installed easly like other MS application. Upon installation, how can I
> get my SQL 2K DB attached or Sychronized ?
> What about login id (like "sa") to connect to MSDE engine from my
> applciation. I will modify my application user to choose DB engine LOCAL
> or LAN. If LAN, I will use my existing connection string. But, LOCAL,
> what would be the provider, password, user id etc..
> Never user MSDE, so queries will be bit more.
> Appreciate all your help to get this resolved.
> Many thanks in advance..
> Regards,
> AJ
>
>
> *** Sent via Developersdex http://www.developersdex.com ***

MSDE Installation and usage on client PC. URGENT HELP!

Hi All,
Have developed Client/Server (VB.NET) application with SQL Server 2000
backend engine. It is working fine. This application can connect to
Database engine if user in our LAN or WAN.
Now, my users need to work on application while they are not in our
network. For instance from Hotel, travel etc.. To achieve this, I
thought to have MSDE installed on user's laptop and get copy of SQL 2k
DB on user machine. But. here I got stuck !. Woudl really appreciate if
you could help me !
MSDE engine, I hope that I can d/load from MS site. Belive that can be
installed easly like other MS application. Upon installation, how can I
get my SQL 2K DB attached or Sychronized ?
What about login id (like "sa") to connect to MSDE engine from my
applciation. I will modify my application user to choose DB engine LOCAL
or LAN. If LAN, I will use my existing connection string. But, LOCAL,
what would be the provider, password, user id etc..
Never user MSDE, so queries will be bit more.
Appreciate all your help to get this resolved.
Many thanks in advance..
Regards,
AJ
*** Sent via Developersdex http://www.codecomments.com ***
You have to setup some replication, please refer to the BOL or ressources in
the internet for that, there are tons of examples out there.
HTH, Jens SUessmeyer.
http://www.sqlserver2005.de
"Ahmed Jewahar" <ahmed.jewahar@.dhl.com> schrieb im Newsbeitrag
news:%23klgAGhWFHA.3280@.TK2MSFTNGP09.phx.gbl...
> Hi All,
> Have developed Client/Server (VB.NET) application with SQL Server 2000
> backend engine. It is working fine. This application can connect to
> Database engine if user in our LAN or WAN.
> Now, my users need to work on application while they are not in our
> network. For instance from Hotel, travel etc.. To achieve this, I
> thought to have MSDE installed on user's laptop and get copy of SQL 2k
> DB on user machine. But. here I got stuck !. Woudl really appreciate if
> you could help me !
> MSDE engine, I hope that I can d/load from MS site. Belive that can be
> installed easly like other MS application. Upon installation, how can I
> get my SQL 2K DB attached or Sychronized ?
> What about login id (like "sa") to connect to MSDE engine from my
> applciation. I will modify my application user to choose DB engine LOCAL
> or LAN. If LAN, I will use my existing connection string. But, LOCAL,
> what would be the provider, password, user id etc..
> Never user MSDE, so queries will be bit more.
> Appreciate all your help to get this resolved.
> Many thanks in advance..
> Regards,
> AJ
>
>
> *** Sent via Developersdex http://www.codecomments.com ***

MSDE Installation and usage on client PC. URGENT HELP!

Hi All,
Have developed Client/Server (VB.NET) application with SQL Server 2000
backend engine. It is working fine. This application can connect to
Database engine if user in our LAN or WAN.
Now, my users need to work on application while they are not in our
network. For instance from Hotel, travel etc.. To achieve this, I
thought to have MSDE installed on user's laptop and get copy of SQL 2k
DB on user machine. But. here I got stuck !. Woudl really appreciate if
you could help me !
MSDE engine, I hope that I can d/load from MS site. Belive that can be
installed easly like other MS application. Upon installation, how can I
get my SQL 2K DB attached or Sychronized ?
What about login id (like "sa") to connect to MSDE engine from my
applciation. I will modify my application user to choose DB engine LOCAL
or LAN. If LAN, I will use my existing connection string. But, LOCAL,
what would be the provider, password, user id etc..
Never user MSDE, so queries will be bit more.
Appreciate all your help to get this resolved.
Many thanks in advance..
Regards,
AJ
*** Sent via Developersdex http://www.codecomments.com ***You have to setup some replication, please refer to the BOL or ressources in
the internet for that, there are tons of examples out there.
HTH, Jens SUessmeyer.
http://www.sqlserver2005.de
--
"Ahmed Jewahar" <ahmed.jewahar@.dhl.com> schrieb im Newsbeitrag
news:%23klgAGhWFHA.3280@.TK2MSFTNGP09.phx.gbl...
> Hi All,
> Have developed Client/Server (VB.NET) application with SQL Server 2000
> backend engine. It is working fine. This application can connect to
> Database engine if user in our LAN or WAN.
> Now, my users need to work on application while they are not in our
> network. For instance from Hotel, travel etc.. To achieve this, I
> thought to have MSDE installed on user's laptop and get copy of SQL 2k
> DB on user machine. But. here I got stuck !. Woudl really appreciate if
> you could help me !
> MSDE engine, I hope that I can d/load from MS site. Belive that can be
> installed easly like other MS application. Upon installation, how can I
> get my SQL 2K DB attached or Sychronized ?
> What about login id (like "sa") to connect to MSDE engine from my
> applciation. I will modify my application user to choose DB engine LOCAL
> or LAN. If LAN, I will use my existing connection string. But, LOCAL,
> what would be the provider, password, user id etc..
> Never user MSDE, so queries will be bit more.
> Appreciate all your help to get this resolved.
> Many thanks in advance..
> Regards,
> AJ
>
>
> *** Sent via Developersdex http://www.codecomments.com ***

MSDE In SQL Server 2000,What We Need In SQL Server 2005

hi all

What I need to include with my application setup,

My application is working with Sql Server 2005.

I mean what substitute MSDE for sql server 2005

thanks

"SQl Server 2005 Express" is the replacement version for MSDE in 2000

MSDE IMAGE "CLONED"

Can MSDE be cloned? I would like to creates an install of MSDE in an image I
am working on, and create an image of the load. Does anyone know if this
will cause problems for MSDE?
Thanks in advance.
BobS
hi BobS,
"BobS" <bobs@.computertorture.com> ha scritto nel messaggio
news:eF6wWaquEHA.1616@.TK2MSFTNGP10.phx.gbl
> Can MSDE be cloned? I would like to creates an install of MSDE in an
> image I am working on, and create an image of the load. Does anyone
> know if this will cause problems for MSDE?
> Thanks in advance.
> BobS
AFAIK not... you can ghost a complete pc, but not a single MSDE instance
installation... I actually do not understand how do you prepare the "image"
to be burned and distributed... lot of dlls, both standard Win32 and COM
dlls, have to be written to disk, both in private \Microsoft SQL Server\..
and system ... stuff has to be written to the registry... services have to
be installed and negotiated...
I do have really no clues...
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
|||Hi Bob,
Apart from Andrea's comments, if you are just talking about creating an
operating system image that contains the MSDE and wanting to clone it, the
main issue relates to renaming the computer. Once you've done that, you
should read
http://msdn.microsoft.com/library/de...stall_5r8f.asp
about renaming a system running sql server.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"BobS" <bobs@.computertorture.com> wrote in message
news:eF6wWaquEHA.1616@.TK2MSFTNGP10.phx.gbl...
> Can MSDE be cloned? I would like to creates an install of MSDE in an image
> I
> am working on, and create an image of the load. Does anyone know if this
> will cause problems for MSDE?
> Thanks in advance.
> BobS
>
|||Thanks Greg. I'll have a look at the docs. I'm working on a special project,
and must find a way of to get this done.
"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
news:O5CbpytuEHA.1988@.TK2MSFTNGP12.phx.gbl...
> Hi Bob,
> Apart from Andrea's comments, if you are just talking about creating an
> operating system image that contains the MSDE and wanting to clone it, the
> main issue relates to renaming the computer. Once you've done that, you
> should read
>
http://msdn.microsoft.com/library/de...stall_5r8f.asp[vbcol=seagreen]
> about renaming a system running sql server.
> HTH,
> --
> Greg Low [MVP]
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
> "BobS" <bobs@.computertorture.com> wrote in message
> news:eF6wWaquEHA.1616@.TK2MSFTNGP10.phx.gbl...
image
>

MSDE hangs on Install

First off, let me say it took me nearly all day to get this working. When you download the sql2decksp3.exe you might think it install like any other program. No. This exe simply unpacks the setup files. The actual setup program, setup.exe must be run from a DOS command prompt... so you've got to look up the correct command line parameters in the sp3reademe.htm file. Something like:

setup INSTANCENAME="InstanceName" SECURITYMODE=SQL SAPWD="AStrongSAPwd"

No problem so far, but then when I go to run the setup.exe with the correct parameters the install goes fine until the last 5 seconds. Then hangs. Again and again. The install program keep getting hung up just before the finish. Each time I had to uninstall and reinstall-- 6 times. When if it hangs you've got to break out with the Task Manager, then do an uninstall from the Control Panel... if... an entry there was created. It usually is.

I tried everything I could think of and then did a search here. There were a few messages. The only one who actually got past this problem said he deleted all references for "Microsoft SQL" in the registry. I tried that too. It didn't work for me. That setup hung in the very same place. Then instead of breaking out and starting again, I tried shutting the machine down, while the setup was hung, thinking that maybe after a restart the installation might continue AND and that point the install completed.

Hope these notes help the next person who runs into the same problem. I also tried putting the modem on standby and disabling Norton anti-virus. Alone that did help, but when I tried all this stuff together... finally at 4:34 PM, I was able to establish a connection, from both VB.NET and with a great FREE MS SQL Manager at http://sqlmanager.net/products/mssql/manager/download

Now I can start. For some reason, the way I think... I can't do any coding until the entire database spec is first set up. Then you write all the add, edit, display and sort form, windows. When designing web applications, you design the database first, then each web form preforms some unique operation or reference on the remote database. I think that's the way it works.

Hey! Hope this helps others.

Paul TownsendSometimes verbose logging can help to pinpoint installation problems:

setup INSTANCENAME="InstanceName" SECURITYMODE=SQL SAPWD="AStrongSAPwd" /L*v c:\MSDEInstall.log

Terri

MSDE for Small Network System

Is it appropriate of using MSDE for peer to peer network system of a few computers, commercially?
All computers are working on Windows XP Pro, sharing DB each other via MSDE.
Are there anyone to advice us regarding the technical problems or licence problems?
Hi,
You can use MSDE on the peer to peer network. There are no licensing
issues, as MSDE is available free of cost and can be freely downloaded from
http://www.microsoft.com/sql/msde/do...s/download.asp
The technical issues that you may face are
1. There is not frontend for MSDE. you can use Web Data Administrator tool.
It can be downloaded from
http://www.microsoft.com/downloads/d...798-C57A-419E-
ACBC-2A332CB7F959&displaylang=en
2. The data size in MSDE is limited to 2GB. The data cannot grow beyond 2
GB in an MSDE database.
3. MSDE has a workload governor that gets activated when there are more
than 8 process running simultaneously on an instance of MSDE. The workload
governor slows down the response of the MSDE instance. However, it does not
stop from multiple users using it. for more information on Workload
governor please visit
http://msdn.microsoft.com/library/?u.../8_ar_sa2_0ciq
.asp?frame=true
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.