MSDE Setup and first database

I'm deploying MSDE with a desktop app (windows forms .net).
after installing MSDE, how do I create the database for the application?
I cannot provide a createdb.sql script to the user because there is no
queryanalyzer or similar tools.
How can I run the create query from the setup? or what is the recommended
method for doing this?
Thank You!
Hi,
Give a batch file to create the database. All you have to do is double click
the batch file. batch file should contain:-
OSQL -Usa -Ppassword -S servername -Q'Create database
dbname' -o'c:\createdb.log'
Save the command inside a .BAT file and send to client side to create the
database. Instad of giving the -Q parameter you
can also input a .SQL file which contans sequence of TSQL commands.
Thanks
Hari
SQL Server MVP
"Harley" <harleyobrienAThotmailDOTcom> wrote in message
news:E3273FC0-ADE4-47B1-9F3D-8DEC479E3341@.microsoft.com...
> I'm deploying MSDE with a desktop app (windows forms .net).
> after installing MSDE, how do I create the database for the application?
> I cannot provide a createdb.sql script to the user because there is no
> queryanalyzer or similar tools.
> How can I run the create query from the setup? or what is the recommended
> method for doing this?
> Thank You!

MSDE on CD

Is it possible to run MSDE from a CD ROM? What I want to
do is create a system using the SQL Server. First, I want
to create a process using DTS to import a text file into
SQL Server. Then from there write a program in VB to
manipulate that data from the sql server. I want to run
all this from a CD-ROM. Is this possible? What would I
need to run the app from the CD? Would the client need to
install any files to run the sql server or vb app? ANy
and all help would be appreciated.
Mike
hi Mike,
"Mike" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:1123001c4166a$f6c84140$a001280a@.phx.gbl...
> Is it possible to run MSDE from a CD ROM? What I want to
> do is create a system using the SQL Server. First, I want
> to create a process using DTS to import a text file into
> SQL Server. Then from there write a program in VB to
> manipulate that data from the sql server. I want to run
> all this from a CD-ROM. Is this possible? What would I
> need to run the app from the CD? Would the client need to
> install any files to run the sql server or vb app? ANy
> and all help would be appreciated.
> Mike
SQL Server must be installed on a pc in order to run it... it can be
installed remotely and you can connect from a remote client, but it must be
installed somewhere on the LAN... you can partially store the databases on
CD (please have a look at
http://msdn.microsoft.com/library/de...es_03_92hx.asp)
but the core engine and all system stuffs must be installed..
VB apps also require all VB runtime and dependencies to be locally
installed... you can then run your app from a CD, but all related VB stuffs
have to be installed and properly registered...
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

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 multiple instances

Hello there,
I want to install multiple instances of MSDE on XP prof edition. How many
instances can i create on a single machine?
Also, any URL for this would be helpful?
Thanks,
David
hi David,
David wrote:
> Hello there,
> I want to install multiple instances of MSDE on XP prof edition. How
> many instances can i create on a single machine?
> Also, any URL for this would be helpful?
> Thanks,
> David
you can install up to 16 instances per server, but this is a theorical limit
as you will not have enought resources to serve all of them..
each additional running instance will add about 20mb of RAM requirement but
this only is the initial load, as the real load will depend on instance
activity that will end up at the Win32 process limit of addressing up to 2gb
of RAM, and many running instances will of course bring your server down to
knees...
for additional information about SQL Server memory management, please have a
look at excellent Ken Henderson's article at
http://msdn.microsoft.com/library/de...v_03252004.asp
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE Maintanence Problem

I am trying to create a maintanence plan for a MSDE database using
Enterprise Manager. Under my MSDE SQL Server/Management, Database
Maintenance Plans icon does not show up. In my three other SQL Servers (1
MSDE, 2 SQL 2000) this icon does show up. And I cannot right click the
database and choose Maintenance Plans under all tasks. I am doing this via
an Enterprise Manage remotely. When I physically view the Enterprise
Manager I can setup Maintenance Plans however the plans do not work. When I
view the properties, none of the schedule shwos up and I get an error. Is
my only choice to reinstall MSDE and Enterprise Manager? Any ideas?
Thanks
hi George,
"George" <george@.noemail.com> ha scritto nel messaggio
news:OOmpQ51bEHA.2840@.TK2MSFTNGP11.phx.gbl...
> I am trying to create a maintanence plan for a MSDE database using
> Enterprise Manager. Under my MSDE SQL Server/Management, Database
> Maintenance Plans icon does not show up. In my three other SQL Servers (1
> MSDE, 2 SQL 2000) this icon does show up. And I cannot right click the
> database and choose Maintenance Plans under all tasks. I am doing this via
> an Enterprise Manage remotely. When I physically view the Enterprise
> Manager I can setup Maintenance Plans however the plans do not work. When
I
> view the properties, none of the schedule shwos up and I get an error. Is
> my only choice to reinstall MSDE and Enterprise Manager? Any ideas?
> Thanks
>
that's weird... never heard about :-(
but, FWIW, you are not allowed to manage MSDE instance with the regular SQL
Server client tools like Enterprise Manager and/or Query Analyzer...
you shoul'd resort on third party tools..
a list of some tools can be found at
http://www.microsoft.com/sql/msde/partners/default.asp and/or
http://www.aspfaq.com/show.asp?id=2442
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Why can't I use Enterprise Manager to manage a MSDE Instance? I do have
licenses for SQL Server.
Thanks
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2m81boFjj6hjU1@.uni-berlin.de...[vbcol=seagreen]
> hi George,
> "George" <george@.noemail.com> ha scritto nel messaggio
> news:OOmpQ51bEHA.2840@.TK2MSFTNGP11.phx.gbl...
(1[vbcol=seagreen]
via[vbcol=seagreen]
When[vbcol=seagreen]
> I
Is
> that's weird... never heard about :-(
> but, FWIW, you are not allowed to manage MSDE instance with the regular
SQL
> Server client tools like Enterprise Manager and/or Query Analyzer...
> you shoul'd resort on third party tools..
> a list of some tools can be found at
> http://www.microsoft.com/sql/msde/partners/default.asp and/or
> http://www.aspfaq.com/show.asp?id=2442
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi George,
"George" <george@.noemail.com> ha scritto nel messaggio
news:Od%23dg7$bEHA.384@.TK2MSFTNGP10.phx.gbl...
> Why can't I use Enterprise Manager to manage a MSDE Instance? I do have
> licenses for SQL Server.
there's an open thread about it in Microsoft it self =;-D
a little extract of such a "flame" is a position by a Microsoft
representative like
"...
The tricky part here is the bit about using MSDE in conjunction with a
properly licensed copy of SQL Server 2000 and the fact that we don't go
into detail about exactly what that means. XXXX (name) has stated many times
in
the private SQL MVP newsgroup that that requires a bunch of lawyers and
a white board. It's almost never the case. In my opinion, we simply need
to tell folks that right now you cannot do it with MS tools at them
moment, here's a bunch of 3rd-party tools you can look at, and we'll be
providing tools with SQL Express and here's how you get a sneak preview
of that...
..."
dev/test environments can be managed with SQL Server Dev edition at will, as
test requires MSDE management too, but production enviroments seem not to be
legitimated...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

msde installation question.

Hi,
When i install MSDE it creates a folder named "Microsoft SQL
Server\80\..." in Program Files why it create this folder? Is there any way
to bypass this folder installation. thanks a lot
hi,
"Shoaib Khanzada" <shoaibkhanzada@.hotmail.com> ha scritto nel messaggio
news:uxeO8cpEEHA.1368@.TK2MSFTNGP11.phx.gbl...
> Hi,
> When i install MSDE it creates a folder named "Microsoft SQL
> Server\80\..." in Program Files why it create this folder? Is there any
way
> to bypass this folder installation. thanks a lot
even when specifying a different path for DATADIR and TARGETDIR, MSDE
requires to install some stuff in \Program Files\...
those files, bynaries and executables, are service pack indipendent (the
always are updated at the higher service pack level) and are shared among
all instances installed on the targe pc...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.6.0 - DbaMgr ver 0.52.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE Installation Problem

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 ODBC list of servers
available.
I am trying this on a system that has SQL Server 2000 for Developers on it
What does appear in the list are the following:
(local)
CRA-SERVER-2
Cra-Server-2
I don't know why there are two servers listed plus local, but all three
point to
the database setup under SQL Server 2000 for Developers.
It appears that MSDE installed properly. When I look in Component Services,
it is listed as MSSQL$CDC2, status = Started, Startup type = Automatic,
Logon as Local System. CDC2 is the instance name that I specified in the
Setup portion of the MSDE install package.
The directories specified all seem to have the files and data structures.
When I run the OSQL -E -S \CDC2 I get an error. The error message says:
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect() ).
When I look at the Task Manager, I have 2 copies of sqlservr.exe running. I
Assume one is for SQL Server 2000 Developer and the other is MSDE. (?)
I am a developer and need an ODBC connection to the database in the MSDE
installed CDC2 server. Can someone point me in the right direction for
resolving
this ODBC/SQL Server problem?
Thanks for your help.
LanceDoes this work with SQL authentication?
Meaning,
Osql -Usa -Ppassword sqlserver\instancename?
If it does, then you might want to check
325022 INFO: MSDE Security and Authentication
http://support.microsoft.com/?id=325022
Cheers,
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 Installation Problem

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 ODBC list of servers
available.
I am trying this on a system that has SQL Server 2000 for Developers on it
What does appear in the list are the following:
(local)
CRA-SERVER-2
Cra-Server-2
I don't know why there are two servers listed plus local, but all three
point to
the database setup under SQL Server 2000 for Developers.
It appears that MSDE installed properly. When I look in Component Services,
it is listed as MSSQL$CDC2, status = Started, Startup type = Automatic,
Logon as Local System. CDC2 is the instance name that I specified in the
Setup portion of the MSDE install package.
The directories specified all seem to have the files and data structures.
When I run the OSQL -E -S \CDC2 I get an error. The error message says:
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect() ).
When I look at the Task Manager, I have 2 copies of sqlservr.exe running. I
Assume one is for SQL Server 2000 Developer and the other is MSDE. (?)
I am a developer and need an ODBC connection to the database in the MSDE
installed CDC2 server. Can someone point me in the right direction for
resolving
this ODBC/SQL Server problem?
Thanks for your help.
Lance
Does this work with SQL authentication?
Meaning,
Osql -Usa -Ppassword sqlserver\instancename?
If it does, then you might want to check
325022 INFO: MSDE Security and Authentication
http://support.microsoft.com/?id=325022
Cheers,
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 Installation Problem

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 ODBC list of servers
available.
I am trying this on a system that has SQL Server 2000 for Developers on it
What does appear in the list are the following:
(local)
CRA-SERVER-2
Cra-Server-2
I don't know why there are two servers listed plus local, but all three
point to
the database setup under SQL Server 2000 for Developers.
It appears that MSDE installed properly. When I look in Component Services,
it is listed as MSSQL$CDC2, status = Started, Startup type = Automatic,
Logon as Local System. CDC2 is the instance name that I specified in the
Setup portion of the MSDE install package.
The directories specified all seem to have the files and data structures.
When I run the OSQL -E -S \CDC2 I get an error. The error message says:
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect() ).
When I look at the Task Manager, I have 2 copies of sqlservr.exe running. I
Assume one is for SQL Server 2000 Developer and the other is MSDE. (?)
I am a developer and need an ODBC connection to the database in the MSDE
installed CDC2 server. Can someone point me in the right direction for
resolving
this ODBC/SQL Server problem?
Thanks for your help.
LanceDoes this work with SQL authentication?
Meaning,
Osql -Usa -Ppassword sqlserver\instancename?
If it does, then you might want to check
325022 INFO: MSDE Security and Authentication
http://support.microsoft.com/?id=325022
Cheers,
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 install hangs -- any ideas?

I installed MSDE. Then I changed the name of my machine. Then I uninstalled MSDE, so I could create a new, properly-named instance.

Now, when I try to install, the installer gets about 75% of the way through the "gathering information" stage, and hangs, every time. I have to kill it with Task Manager.

Help! What can I do?

Extra info: I thought maybe the problem was related to Norton AV, so I uninstalled that. While that was uninstalling, the installer announced that there was a "suspended" install of MSDE that needed to be cleared. So I said, yes, clear it. How do I find out if there are other suspended installs in progress?

Thanks...Solved it myself: the partial install left a bunch of junk in the registry related to SQL server. I deleted all of them, then reinstalled successfully.

MSDE in Enterprise manager: strange number with managed tasks...

Without having read the manual (just assuming it should work), I have a
problem with MSDE and using the Enterprise Manager to create a database
maintenance plan.
I have a desktop machine with SQL2K(sp3) and a portable with MSDE
(msderela.exe). I am testing (developing) an application that should
bee able to pull a subscription-db (portable in this case) from the
main-server (desktop in this case). I've setup all directories needed
(repldata) and the installation-log for MSDE (installed with /L*v)
didn't gave me any error... I've attached a DB (for testing purposes)
and (using the Enterprise manager) it seems to return everything I want
it to return (data that is).
But, when I was trying to setup a maintenance plan on the laptop (so
that user has a backup in case he's traveling and would like to revert
to a backup-file), I run into some very strange errors. Although I can
create a plan (either using the wizard or 'plain'), certain values are,
well, let's say damaged...
For example, the "complete backup" tab. On the right side of the
checkbox "Remove files older then" you have a combo with 'days',
'weeks', etc. For some reason, this combo is empty.
Having skipped this functionality completely, I've setup a complete
plan and saved it. Backup every 1 days at 18:00 (there's more, but for
the example's sake I don't include all settings).
Now, when I open that plan again, I see that the every 1 days is
changed to 366 days (not only for this one, but for all where I've set
it to every 1 day). I can't save the plan anymore (errors complaining
about having the wrong value-types). When I change it back to 1 day,
save it and re-open it, it comes back with the 366 days again...
Any ideas on what's going on here?
Thx,
GB
Dit is een automatische handtekening van MesNews.
Site : http://www.mesnews.net
Are you sure you're properly licensed to manage MSDE with Enterprise
Manager?
http://www.aspfaq.com/
(Reverse address to reply.)
"Gijs Beukenoot" <gijs.beukenoot@.wanadoo.nl> wrote in message
news:mn.8c937d4b9fda54cf.22563@.wanadoo.nl...
> Without having read the manual (just assuming it should work), I have a
> problem with MSDE and using the Enterprise Manager to create a database
> maintenance plan.
> I have a desktop machine with SQL2K(sp3) and a portable with MSDE
> (msderela.exe). I am testing (developing) an application that should
> bee able to pull a subscription-db (portable in this case) from the
> main-server (desktop in this case). I've setup all directories needed
> (repldata) and the installation-log for MSDE (installed with /L*v)
> didn't gave me any error... I've attached a DB (for testing purposes)
> and (using the Enterprise manager) it seems to return everything I want
> it to return (data that is).
> But, when I was trying to setup a maintenance plan on the laptop (so
> that user has a backup in case he's traveling and would like to revert
> to a backup-file), I run into some very strange errors. Although I can
> create a plan (either using the wizard or 'plain'), certain values are,
> well, let's say damaged...
> For example, the "complete backup" tab. On the right side of the
> checkbox "Remove files older then" you have a combo with 'days',
> 'weeks', etc. For some reason, this combo is empty.
> Having skipped this functionality completely, I've setup a complete
> plan and saved it. Backup every 1 days at 18:00 (there's more, but for
> the example's sake I don't include all settings).
> Now, when I open that plan again, I see that the every 1 days is
> changed to 366 days (not only for this one, but for all where I've set
> it to every 1 day). I can't save the plan anymore (errors complaining
> about having the wrong value-types). When I change it back to 1 day,
> save it and re-open it, it comes back with the 366 days again...
> Any ideas on what's going on here?
> Thx,
> GB
> --
> Dit is een automatische handtekening van MesNews.
> Site : http://www.mesnews.net
>
|||Aaron [SQL Server MVP] drukte met precisie uit :
> Are you sure you're properly licensed to manage MSDE with Enterprise
> Manager?
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
I fail to see what the licensing has to do with this problem...
But anyway, I have at least three developer licenses (7 and 2x2K); two
standard licenses (7 and 2K) and one Enterprise license (2K) (all
processor); I also have one dev lic with with Office-xp-dev and I have
an MSDN universal... But from memory (I used to have @.microsoft.com
behind my (not-mentioned-here-due-to-spam)-address although that is a
few years ago), having just one valid SQL license is enough to do what
I want to do.
Dit is een automatische handtekening van MesNews.
Site : http://www.mesnews.net
|||> I fail to see what the licensing has to do with this problem...
Maybe trying to push you to create jobs legally using the stored procedures
in MSDB, instead of Enterprise Manager, which (a) you are having problems
with, and (b) is not likely abiding by licensing agreements.

> But anyway, I have at least three developer licenses (7 and 2x2K); two
> standard licenses (7 and 2K) and one Enterprise license (2K) (all
> processor); I also have one dev lic with with Office-xp-dev and I have
> an MSDN universal... But from memory (I used to have @.microsoft.com
> behind my (not-mentioned-here-due-to-spam)-address although that is a
> few years ago), having just one valid SQL license is enough to do what
> I want to do.
I would consult with a Microsoft licensing rep before having confidence in
such a statement. MSDE has very strict limitations on how you can use SQL
Server tools for management, regardless of how many licenses you have for
other editions. And there are very few cases that I've heard of where it's
legal to manage MSDE with Enterprise Manager, sorry.
|||Aaron [SQL Server MVP] drukte met precisie uit :

> I would consult with a Microsoft licensing rep before having confidence in
> such a statement. MSDE has very strict limitations on how you can use SQL
> Server tools for management, regardless of how many licenses you have for
> other editions. And there are very few cases that I've heard of where it's
> legal to manage MSDE with Enterprise Manager, sorry.
Aaron,
Can I point you to the website?
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp
To be precise :
<cut>
Q. Can I use SQL Server tools and services in conjunction with MSDE?
A. You can only use SQL Server tools and services in conjunction with
MSDE if you acquired MSDE through SQL Server 2000 (Developer Edition,
Standard Edition, or Enterprise Edition), and if you are using MSDE in
conjunction with a properly licensed copy of SQL Server 2000. Visit the
How to Buy page for information on obtaining a valid SQL Server
license.
Note: The tools and services included with SQL Server Developer Edition
may not be used to manage production server environments.
<paste>
And this is exactly what I'm doing...
Sent me a private message if you're still think I am doing something
wrong.
Dit is een automatische handtekening van MesNews.
Site : http://www.mesnews.net
|||> And this is exactly what I'm doing...
I thought the same thing too, but apparently there's much more to it than
that single paragraph, and relying on that paragraph has proved detrimental
in the past.

> Sent me a private message if you're still think I am doing something
> wrong.
Not really my job to prove to you that you are doing something wrong; you
might not be, I don't know because I am neither a lawyer nor a Microsoft
licensing rep. Just reminding you that the onus is on YOU to be sure YOU
are abiding by the licensing agreement(s).
|||Aaron [SQL Server MVP] gebruikte zijn klavier om te schrijven :
> I thought the same thing too, but apparently there's much more to it than
> that single paragraph, and relying on that paragraph has proved detrimental
> in the past.
>
> Not really my job to prove to you that you are doing something wrong; you
> might not be, I don't know because I am neither a lawyer nor a Microsoft
> licensing rep. Just reminding you that the onus is on YOU to be sure YOU
> are abiding by the licensing agreement(s).
Good. Can we go back to the original question then?
Anybody any ideas why the before mentioned method is giving me these
strange numbers?
Dit is een automatische handtekening van MesNews.
Site : http://www.mesnews.net

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 from sql server

Hi,
If I write an sql server application can I use the application and the
database that the application create on different computer running msde?
Can I use msde from a remote computer?
Thanks!
Hi,
No problems at all. You could backup the database and restore it in the new
MSDE database.
As well as you can connect to re
"Dave" <dbg@.012.net.il> wrote in message
news:OManl$nyEHA.2624@.TK2MSFTNGP11.phx.gbl...
> Hi,
> If I write an sql server application can I use the application and the
> database that the application create on different computer running msde?
> Can I use msde from a remote computer?
> Thanks!
>
|||Hi,
No problems at all. You could backup the database and restore it in the new
MSDE database.
As well as you can connect using your appliacion to the remotely installed
MSDE database.
Thanks
Hari
SQL Server MVP
"Dave" <dbg@.012.net.il> wrote in message
news:OManl$nyEHA.2624@.TK2MSFTNGP11.phx.gbl...
> Hi,
> If I write an sql server application can I use the application and the
> database that the application create on different computer running msde?
> Can I use msde from a remote computer?
> Thanks!
>

MSDE from Hoster installed

Hello
my DEd win 2003 server, uses MSDE
all is ok, the server run, and can create from script Db
but if i want login or create connection MSDE say wrong pass
i never change the pass or other
i have the server complet reinstalled from hoster image
what i doing wrong ?
hi,
MS News wrote:
> Hello
> my DEd win 2003 server, uses MSDE
> all is ok, the server run, and can create from script Db
> but if i want login or create connection MSDE say wrong pass
> i never change the pass or other
> i have the server complet reinstalled from hoster image
> what i doing wrong ?
assuming you are trying to connect using the standard SQL Server
authentication with the "sa" login and you can't remember it's pasword, you
can login using integrated security (the Windows authentication) using a
local admin member and set the "sa" password to whatever you want via the
system stored procedure sp_password,
http://msdn.microsoft.com/library/de...a-pz_5x44.asp,
in the form
EXEC sp_password @.new = 'whatever', @.loginame = 'sa'
as all local admins members are automatically members of the
BUILTIN\Administrators login group in MSDE too, with sysadmins privileges...
connect via oSql.exe providing the -E parameter to specify integrated
security..
c:\..\>osql.exe -E -S(local)\InstanceName
1>EXEC sp_password @.new = 'whatever', @.loginame = 'sa'
2>GO
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||hey thats realy works !
thanks!
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> schrieb im Newsbeitrag
news:3s11vbFlebp5U1@.individual.net...
> hi,
> MS News wrote:
> assuming you are trying to connect using the standard SQL Server
> authentication with the "sa" login and you can't remember it's pasword,
> you can login using integrated security (the Windows authentication) using
> a local admin member and set the "sa" password to whatever you want via
> the system stored procedure sp_password,
> http://msdn.microsoft.com/library/de...a-pz_5x44.asp,
> in the form
> EXEC sp_password @.new = 'whatever', @.loginame = 'sa'
> as all local admins members are automatically members of the
> BUILTIN\Administrators login group in MSDE too, with sysadmins
> privileges...
> connect via oSql.exe providing the -E parameter to specify integrated
> security..
> c:\..\>osql.exe -E -S(local)\InstanceName
> 1>EXEC sp_password @.new = 'whatever', @.loginame = 'sa'
> 2>GO
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>

MSDE Error on attempting to create new Access 2000 project

Hi folks
I've just installed MSDE on my Win 2k machine and have attempted to
create a new Access 2000 project. When I do (and using a number of
different Login ID/Password combinations), I get this:
Connection failed:
SQLState: '01000'
SQL Server Error: 123
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen
(CreateFile()).
Connection failed:
SQLState: '08001'
SQL Server Error: 123
[Microsoft][ODBC SQL Server Driver]Client unable to establish
connection
can anyone tell me what this means and what I should do. Any help much
appreciated.
thanks
Laurence
Laurence,
See: http://support.microsoft.com/default...b;en-us;233312
It looks like you do not have named pipes installed with your MSDE, but you
are using it from your client.
Russell Fields
"Laurence" <laurencetruman@.yahoo.com> wrote in message
news:c8e229b3.0406090533.5ecefd75@.posting.google.c om...
> Hi folks
> I've just installed MSDE on my Win 2k machine and have attempted to
> create a new Access 2000 project. When I do (and using a number of
> different Login ID/Password combinations), I get this:
> Connection failed:
> SQLState: '01000'
> SQL Server Error: 123
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen
> (CreateFile()).
> Connection failed:
> SQLState: '08001'
> SQL Server Error: 123
> [Microsoft][ODBC SQL Server Driver]Client unable to establish
> connection
> can anyone tell me what this means and what I should do. Any help much
> appreciated.
> thanks
> Laurence
|||Laurence,
Actually, you might find this more helpful (since my first post was to an
old version of MSDE)
ACC2002: "Configuring SQL Server 2000 Desktop Engine" White Paper Available
in Download Center
http://support.microsoft.com/default...b;en-us;301413
Russell Fields
"Laurence" <laurencetruman@.yahoo.com> wrote in message
news:c8e229b3.0406090533.5ecefd75@.posting.google.c om...
> Hi folks
> I've just installed MSDE on my Win 2k machine and have attempted to
> create a new Access 2000 project. When I do (and using a number of
> different Login ID/Password combinations), I get this:
> Connection failed:
> SQLState: '01000'
> SQL Server Error: 123
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen
> (CreateFile()).
> Connection failed:
> SQLState: '08001'
> SQL Server Error: 123
> [Microsoft][ODBC SQL Server Driver]Client unable to establish
> connection
> can anyone tell me what this means and what I should do. Any help much
> appreciated.
> thanks
> Laurence