Advice needed - MSDE vs. Access

Hi, I currently have a application that is being used throughout the
country at different customers. Currently it is a VB6 application accessing
DBF/CDX standalone tables via ODBC. We are developing the 'next
generation' of the program in VB.NET and will do data access via OLEDB.
Here is the issue: Stand alone Visual Foxpro DBF tables do not return
'primary key' information, so we lose a lot of potential functionality by
not being able to set relations in a Dataset. Therefore, we are looking
for a new database to host the application. The application DB requirements
are basic INSERT, UPDATE, DELETE. No data replication, or anything fancy.
No "DB security" required. In reality, the application is coded so that it
will actually run on a SQL server or Oracle enterprise DB, too. But
customers that choose that option have an IT dept with appropriate
expertise, so I'm not worried about them.
Here's the problem... most of our customers are in small shops and are
barely computer literate. We need something REALLY simple. With the DBF
files it couldn't be simpler... install the program and then run it. No
real maintenance (except backup of course) is needed. I'm looking at
either MS Access or MSDE as a replacement database. Given that my
customers are the types that use the CD drawer as a cup holder, I'm
concerned that MSDE might be too much for them, and that Access might be
easier for them. Right now this is just my initial thought, as I'm not
familiar with MSDE. Before I get too far down the road, I wanted to tap
some expertise for advise.
So, the application will be coded to the 'lowest common denominator' but
will able to run on SQL server and ORACLE also. The question is, given the
small shops I need to cater to, what should that 'lowest common denominator'
be? Access or MSDE?
Any advice graceously accepted... Thanks.
John
hi John,
JohnR wrote:
>...
> So, the application will be coded to the 'lowest common denominator'
> but will able to run on SQL server and ORACLE also. The question is,
> given the small shops I need to cater to, what should that 'lowest
> common denominator' be? Access or MSDE?
>
difficult question, as the 2 engines can not be compared... ok they are both
database engines, but very different.... from my point of view I'd go with
MSDE as it can be easily scaled to full blown SQL Server editions with no
harm at all... and as you already know, JET database engine is in
maintenance and no additional features will be provided for it..
on the other side, MSDE, and soon SQLExpress, could require some more
maintenace (you can include in you application, for quite all administrative
tasks)... but they are another level of db engines, comparable with Oracle,
where the JET engine is not...
for SQL Server connections I'd go for the SQLClient name space versus the
OLEDB conterpart asi it provides better and targeted support for the SQL
Server worls, where the OLEDB provider is quite generic... but this is
another story..
more... SQLExpress will support easy setup and deployment for your database,
as long as XCopy support...
http://msdn.microsoft.com/library/de...seoverview.asp
provides additional info..
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

Advice MSDE/ACCESS

I wrote an app that uses MSDE. IT is VB.NET, and there are only 10 users
tops.
To make an MSDE installation and get the database working requires me, which
makes it not really a commercially distributable product.
Would I be better just using an MDB file? Seems like MSDE is really nice
and basically SQL but I need something that installs easy--i.e. my users can
install. I know I can easily install an MDB file.
Would the MDB file be sufficient for 10-20 users tops?
thanks,
Shane
On Sat, 12 Jun 2004 02:36:37 -0500, SStory
<TheStorys@.TAKEOUTTHISSPAMBUSTERsofthome.net> wrote:

> Would the MDB file be sufficient for 10-20 users tops?
That depends on the complexity of your queries and the level of your
requirements. If you're only doing some SELECT statements and occasional
updates/inserts, an .mdb file is certainly enough. You could run into
troubles with locking mechanisms in MS Access though, so take care.
Installing MSDE is not a big deal, you just have to care for populating
the database yourself (ie: from your application) to make it easier for
your users.
Using SECURITYMODE and DBPWD(?) as setup parameters can even set up a
version of MSDE that runs similar to MSDE 1.0 (speaking of access to it)
Stefan
Give a man fire and he is warm for a day.
Set him on fire and he is warm for the rest of his life.

ADP files?

Hi,
I just upsized my Access 2000 database to MSDE (which I intend to upsize
to SQL Server in a few ws) and got a .adp file from a .mdb file. How
do I connect to this .adp file from Visual Basic? Can I distribute this
file easily like Access? Please help, I have no idea what to do with
MSDE and how to connect DSN-LESSly to this file.
regards,
Steve"Steve" <stephen@.anu.edu.au> schrieb im Newsbeitrag
news:%23dm9qBUUFHA.3312@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I just upsized my Access 2000 database to MSDE (which I intend to upsize
> to SQL Server in a few ws) and got a .adp file from a .mdb file. How do
> I connect to this .adp file from Visual Basic? Can I distribute this file
> easily like Access? Please help, I have no idea what to do with MSDE and
> how to connect DSN-LESSly to this file.
>
> regards,
> Steve|||You can easily share that file, but would i make sense ? (There must be
alway a connetion between ADP and aAccess to get the data from the MSDE)
Wouldnt that be a better way just to make your way directly to SQL Server ?
Or do you need some special features (Form, Reports) from Access ?
Jens Suessmeyer.
"Steve" <stephen@.anu.edu.au> schrieb im Newsbeitrag
news:%23dm9qBUUFHA.3312@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I just upsized my Access 2000 database to MSDE (which I intend to upsize
> to SQL Server in a few ws) and got a .adp file from a .mdb file. How do
> I connect to this .adp file from Visual Basic? Can I distribute this file
> easily like Access? Please help, I have no idea what to do with MSDE and
> how to connect DSN-LESSly to this file.
>
> regards,
> Steve

ADP dont shows table from MSDE

Hi,

I created one blank ADP to connect default tempdb database on MSDE on server ASHFAQUEPC (name of my msde server). Tested the connection was successful.

I created a table called Testtable from command prompt (MSSQL/Binn) in default tempdb of MSDE using following lines:

Binn>osql/U sa mypassword

1> use tempdb
1> go
1> Create table Testtable (Cnum integer NOT NULL PRIMARY KEY, City Varchar(15))
1> go

Table Created successfully then I added 2-3 records using following lines;

1> INSERT INTO testable (cnum, city)
1> values (1, abc)
1> go

1 Record affected and I did same to add 2-3 more records. Then I used following lines to see all the records I entered.

1> select * from testable
1> go

And a list of records displayed at command prompt. After exit from command prompt I found a Testtable appeared in the above ADP.

But next day when I opened my pc and opened ADP, I did not found the Testtable even though I re-connected to tempdb on MSDE from File menu. I reached then to command prompt to see whether the table itself is existing. Strange it was not there.

Can somebody tell me how can I get connected to testable automatically when I open my ADP? Where might have gone wrong? Do I need to create table again and input records?
I want to make sure before I do anything with my real dbs.

Any help would be highly appreciated.

With kind regards,
Ashfaque :confused:tempdb is recreated everytime sql server restarts. msde restarts when the last connection is closed. create a database with the create database command and create your table in there.|||Thanks Thrasymachus,

IC,
I will create my own db from scratch.

Thanks again....

Wiith kind regards,
Ashfaque|||You should definitely not be mucking around in TEMPDB, MASTER, or MSDB. Even MODEL should not be modified without good cause. Leave the system databases alone, and I'd advise you to read the manual BEFORE trying to fly the plane.|||What the blind dude is saying (with his usual grace and elegance), is that you really need to create a datbase for your purposes, and create all of you objects in there.

tempdb is a critical part of the sql server architecture that allows it to manage your "temporary" objects you can create. Temp tables, derived tables, etc. You should not interfere with it's operation.

btw, have you had a look at SQL Server Express and XM Manager?

It's still beta, but it should be coming out full time soon.

http://download.microsoft.com/download/a/6/3/a63ec922-913e-4228-93e3-970abff3fd66/ReadmeSQLExpMgr.htm|||Thanks blindman & Brett Kaiser for your advice.

I was not aware of behavior of these 4 default models on MSDE.

I upsized my MDB and it successfully created ADP and found steady. I can now go on to take further actions over it. I am close to mid-level carrier in handling MDBs in form of FE and BE. But as a little advance step, I used MSDE and I hope I could deal with it successfully with the help you Genius guys.
btw, have you had a look at SQL Server Express and XM Manager?
No, I did not take a look at SQL Server Express and XM Manager but I will do so.

Thanks again for you people..

With kind regards,
Ashfaque|||One more question...

I upsized the tables on MSDE successfully keeping the current db as MDB.

Why I dont know , the record in my subform is appearing but I can not enter new records any more..(Be is on MSDE). If my tables are on local (Not on MSDE server) it works fine.

Any idea ...?

With kind regards,

Ashfaque|||Could be a permissions issue with your login. Do you get any error messages?

adp connection to msde and exclusive rights

I am attempting to create a View from MS Access 2000 SR-1 to an MSDE 2000
(SQL Server 2000 Desktop Engine) database . I accessed with exclusive rights
but I get the following error when trying to create a view:
"You do not have exclusive access to the database at this time. Your design
changes will not be saved."
how can I get ability to create views ?
I'd recommend not using Access as a development tool for SQL Server
objects. Use the Query Analyzer or Enterprise Manager instead. The
error message you're getting is an Access error, not a SQL Server
error.
--Mary
On Thu, 24 Jun 2004 01:08:50 -0700, "TJS" <nospam@.here.com> wrote:

>I am attempting to create a View from MS Access 2000 SR-1 to an MSDE 2000
>(SQL Server 2000 Desktop Engine) database . I accessed with exclusive rights
>but I get the following error when trying to create a view:
>"You do not have exclusive access to the database at this time. Your design
>changes will not be saved."
>how can I get ability to create views ?
>
|||Hi Mary:
Thanks for replying (I have your book, Developer's guide to SQL Server).
Unfortunately, I don't have the Query Analyzer or Enterprise Manager , so I
was hoping to use access as a front end.
is there any way access can be a front end to msde ?
"Mary Chipman" <mchip@.online.microsoft.com> wrote in message
news:n74md01glum1t5l2c79ak6sjmj11sct03m@.4ax.com... [vbcol=seagreen]
> I'd recommend not using Access as a development tool for SQL Server
> objects. Use the Query Analyzer or Enterprise Manager instead. The
> error message you're getting is an Access error, not a SQL Server
> error.
> --Mary
> On Thu, 24 Jun 2004 01:08:50 -0700, "TJS" <nospam@.here.com> wrote:
rights[vbcol=seagreen]
design
>
|||MSDE is not a development platform, it's a deployment platform. I would
suggest that you spend the <$50 required to purchase SQL Server Developer
Edition. It contains everything you'll need to develop for the SQL Server
and MSDE platforms (really the same thing).
I'll even go out on a limb and predict that Mary will say the same thing.
:-)
Yes, you can use Access as a front end to MSDE, but you'll likely find the
tools she mentioned easier to use to create and manage your database.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"TJS" <nospam@.here.com> wrote in message
news:10dm523btum1rd5@.corp.supernews.com...
> Hi Mary:
> Thanks for replying (I have your book, Developer's guide to SQL Server).
> Unfortunately, I don't have the Query Analyzer or Enterprise Manager , so
I[vbcol=seagreen]
> was hoping to use access as a front end.
> is there any way access can be a front end to msde ?
>
>
> "Mary Chipman" <mchip@.online.microsoft.com> wrote in message
> news:n74md01glum1t5l2c79ak6sjmj11sct03m@.4ax.com...
2000
> rights
> design
>
|||I just want to create a view...
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:OBa0OViWEHA.2844@.TK2MSFTNGP11.phx.gbl...
> MSDE is not a development platform, it's a deployment platform. I would
> suggest that you spend the <$50 required to purchase SQL Server Developer
> Edition. It contains everything you'll need to develop for the SQL Server
> and MSDE platforms (really the same thing).
> I'll even go out on a limb and predict that Mary will say the same thing.
> :-)
> Yes, you can use Access as a front end to MSDE, but you'll likely find the
> tools she mentioned easier to use to create and manage your database.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no
rights.[vbcol=seagreen]
> "TJS" <nospam@.here.com> wrote in message
> news:10dm523btum1rd5@.corp.supernews.com...
so
> I
> 2000
>

ADO.NET works, but data to/from database is truncated

I am using MSDE in a web application. The ADO.NET works, updating the
database correctly. The only thing is when I use the dataset, and when I
check the data in the database using server explorer the data is truncated. I
tried using the various ntext, nvarchar and setting the length to somthing
like a 100, but the data string is still to short somewhere. Only when this
comes to the dataset, and data in the database is this true. What can I do?
Thanks.
Spencer
hi Spencer,
Spencer H. Prue wrote:
> I am using MSDE in a web application. The ADO.NET works, updating the
> database correctly. The only thing is when I use the dataset, and
> when I check the data in the database using server explorer the data
> is truncated. I tried using the various ntext, nvarchar and setting
> the length to somthing like a 100, but the data string is still to
> short somewhere. Only when this comes to the dataset, and data in the
> database is this true. What can I do? Thanks.
did you manually set the datatype size?
check it's settings..
and probably you'll have better luck asking in the .Net heirarchy newsgroups
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
|||"Andrea Montanari" wrote:

> hi Spencer,
> Spencer H. Prue wrote:
> did you manually set the datatype size?
> check it's settings..
> and probably you'll have better luck asking in the .Net heirarchy newsgroups
> --
> 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
>
>
Did you say .NET hierarchy group. I couldn't find that group can you give me
the full name for the group?
|||microsoft.public.dotnet.framework.adonet
"Spencer H. Prue" <SpencerHPrue@.discussions.microsoft.com> wrote in message
news:5E484369-BCA3-4527-96A7-281CE91B01EE@.microsoft.com...
>
> "Andrea Montanari" wrote:
> Did you say .NET hierarchy group. I couldn't find that group can you give
> me
> the full name for the group?

ADO recordcount returns -1

Hi All
Upgraded Vb6 program from Access 2K to MSDE 2K RelA
Now all my checks for rs.recordcount return -1, except if I use Client side
cursor OR
if I use... rs.Open sql, cn, adOpenKeyset, adLockReadOnly
Why is this?
I don't want to use client side cursors and I need to save data so
(adLockReadOnly) is no good
I have found that that checking for rs.eof seems reliable as a substitute
for recordcount but would like to understand the reasoning
Regards
Steve
hi Steve,
steve wrote:
> Hi All
> Upgraded Vb6 program from Access 2K to MSDE 2K RelA
> Now all my checks for rs.recordcount return -1, except if I use
> Client side cursor OR
> if I use... rs.Open sql, cn, adOpenKeyset, adLockReadOnly
> Why is this?
> I don't want to use client side cursors and I need to save data so
> (adLockReadOnly) is no good
> I have found that that checking for rs.eof seems reliable as a
> substitute for recordcount but would like to understand the reasoning
this is quiet normal using ADO recorset as the recordcount will be available
only when the entire rowset has been populated, ant this is true only when a
..movelast operation ins performed and all the data has been transferred..
please be warned that performing a rs.movelast + rs.movefirst can be a
timeconsuming operation for big results...
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
|||> please be warned that performing a rs.movelast + rs.movefirst can be a
> timeconsuming operation for big results...
In addition to that, if you DO need to know how many rows you have
(which OP did not in this case), I would first run a select
count(afield) " and the same from/where clause that you use in the
other query. Actually, in those cases you can sometimes eliminate some
of the INNER JOINS that you might have to use when getting the full
field list, and some of the WHERE clause, too -- which will give you
your rowcount faster.
I do this a lot when I want to display a progress bar.
In addition, when looping through a recordset, I ALWAYS do until
rs.eof...I never use the .rowcount property for anything but advising
the user. Not sure WHY I do this, but I've been doing it for years...
Matt
Matt

ADO doesnt connect without network!

Hi!

I wrote an application which connects to a SQL Server / MSDE 2000 DB through ADO components. Now the application doesn't start if I don't have an active network connection; as far as I try to connect, the error I get is:

[DBNETLIB][ConnectionOpen (Connect()).].......

Everything is ok if I simply plug the network cable and let the PC connect to the TCP/IP network.

Hope someone can help me!
Thanks

Umberto...Of course the DB is located on the same PC than the application!

Umberto|||If I write

Data Source=PC_NAME

instead of

Data Source=127.0.0.1

it works fine! Now the question is: WHY??

Umberto|||Is it MSDE or SQL Server Std ?

If MSDE, have you installed Netlib ? It is lhe parameter
DISABLENETWORKPROTOCOL=0
in setup.ini or command line parameters|||Finally I solved the problem by writing:

....;Data Source=(local);....

in the connection string!

Thanks
Umberto

Administrators

I would like that local administrators or domain administrators dont have
administrative rights on some databases running with MSDE.
I've learned about to enable the user "sa" and to give a personal password
to this user, but apparently administrators continue having full access to
all databases.
Thanks.
Regards.
Jose Nuez
Montevideo - Uruguay
hi Jose,
"Jose Nuez" <josenunez70@.hotmail.com> ha scritto nel messaggio
news:OOeUxFovEHA.164@.TK2MSFTNGP10.phx.gbl
> I would like that local administrators or domain administrators dont
> have administrative rights on some databases running with MSDE.
> I've learned about to enable the user "sa" and to give a personal
> password to this user, but apparently administrators continue having
> full access to all databases.
> Thanks.
> Regards.
> Jose Nuez
> Montevideo - Uruguay
Hari already answered you in june.. http://tinyurl.com/4638l and gave you
additional pointers to troubles you could experience..
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

Administering MSDE with Enterprise Manager

Can I administer SQL 2000 MSDE Release A from SQL Server's Enterprise
Manager (EM) located on another machine on the same network?
When I try to do this the EM setup wizard locates the host running MSDE but
it cannot connect either with Windows authentication or the strong password
created during MSDE's install.
EM can see other instances of SQL Server 2000 on the network (these are not
MSDE).
MSDE is running on XP (SP1) and EM is running on W2K workstation.
Many thanks.
Even if you can figure out your connectivity problem, it's probably not
legal anyway. From the Appropriate Uses of MSDE FAQ at
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp:
Q. Can I use SQL Server tools and services in conjunction with MSDE?
A. You can only use SQL Server tools and services in conjunction with
MSDE if you acquired MSDE through SQL Server 2000 (Developer Edition,
Standard Edition, or Enterprise Edition), and if you are using MSDE in
conjunction with a properly licensed copy of SQL Server 2000. Visit the How
to Buy page for information on obtaining a valid SQL Server license.
Note: The tools and services included with SQL Server Developer
Edition may not be used to manage production server environments.
The following utilities are installed by the MSDE setup application
and are provided without restrictions for use with the copy of MSDE that is
installed by your application: bcp.exe, cnfgsvr.exe, dcomscm.exe, osql.exe,
sqlmaint.exe, sqlmangr.exe, scm.exe, sqladhlp.exe, and svrnetcn.exe. The
dtsrun.exe utility is also provided, but can only be used to run existing
Data Transformation Services (DTS) packages against the copy of MSDE
installed by your application; it cannot be used to develop new DTS
packages.
There's not enough information in your post to determine whether or not it's
legal, but in the vast majority of instances it's not and I'm told that it
requires a room full of lawyers and white board to figure out. There are a
bunch of 3rd-party tools out there that might be of use. Have a look at
Aaron's list at http://www.aspfaq.com/show.asp?id=2442.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andrew Chalk" <achalk@.XXXmagnacartasoftware.com> wrote in message
news:%23VTyAG0nEHA.1160@.tk2msftngp13.phx.gbl...
> Can I administer SQL 2000 MSDE Release A from SQL Server's Enterprise
> Manager (EM) located on another machine on the same network?
> When I try to do this the EM setup wizard locates the host running MSDE
> but
> it cannot connect either with Windows authentication or the strong
> password
> created during MSDE's install.
> EM can see other instances of SQL Server 2000 on the network (these are
> not
> MSDE).
> MSDE is running on XP (SP1) and EM is running on W2K workstation.
> Many thanks.
>
begin 666 ts.gif
J1TE&.#EA`0`!`( ``````/___R'Y! $`````+ `````!``$```(!1 `[
`
end
|||Thanks. I think it is an authentication issue rather than a 'property
rights' issue. This is because:
1) I just installed the same version of MSDE on a W98SE machine and was able
to register it successfully with the copy of 'Enterprise manager';
2) I just deleted the XP 'atempted' registration and tried to re-register
it. The dialog "Register SQL Server Messages" returns the error:
"SVR1 - Registration failed for user 'sa'. Reason: Not associated with a
trusted SQL server connection"
Any idea how to make this Server connection trusted?
Thanks!
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:OZrDqW0nEHA.2616@.tk2msftngp13.phx.gbl...
> Even if you can figure out your connectivity problem, it's probably not
> legal anyway. From the Appropriate Uses of MSDE FAQ at
> http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp:
> Q. Can I use SQL Server tools and services in conjunction with
MSDE?
> A. You can only use SQL Server tools and services in conjunction
with
> MSDE if you acquired MSDE through SQL Server 2000 (Developer Edition,
> Standard Edition, or Enterprise Edition), and if you are using MSDE in
> conjunction with a properly licensed copy of SQL Server 2000. Visit the
How
> to Buy page for information on obtaining a valid SQL Server license.
> Note: The tools and services included with SQL Server Developer
> Edition may not be used to manage production server environments.
> The following utilities are installed by the MSDE setup application
> and are provided without restrictions for use with the copy of MSDE that
is
> installed by your application: bcp.exe, cnfgsvr.exe, dcomscm.exe,
osql.exe,
> sqlmaint.exe, sqlmangr.exe, scm.exe, sqladhlp.exe, and svrnetcn.exe. The
> dtsrun.exe utility is also provided, but can only be used to run existing
> Data Transformation Services (DTS) packages against the copy of MSDE
> installed by your application; it cannot be used to develop new DTS
> packages.
>
> There's not enough information in your post to determine whether or not
it's
> legal, but in the vast majority of instances it's not and I'm told that it
> requires a room full of lawyers and white board to figure out. There are a
> bunch of 3rd-party tools out there that might be of use. Have a look at
> Aaron's list at http://www.aspfaq.com/show.asp?id=2442.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Andrew Chalk" <achalk@.XXXmagnacartasoftware.com> wrote in message
> news:%23VTyAG0nEHA.1160@.tk2msftngp13.phx.gbl...
>
>
|||Hi Andrew,
This message means you don't have Mixed Mode authentication enabled. If you
do have enterprise manager connected, you can change this easily by looking
under the "security" tab in the properties of the server. (Right-click the
server to get to it). You need mixed mode before you can use "sa" or any sql
server username.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Andrew Chalk" <achalk@.XXXmagnacartasoftware.com> wrote in message
news:OzXHOC3nEHA.2616@.tk2msftngp13.phx.gbl...
> Thanks. I think it is an authentication issue rather than a 'property
> rights' issue. This is because:
> 1) I just installed the same version of MSDE on a W98SE machine and was
able[vbcol=seagreen]
> to register it successfully with the copy of 'Enterprise manager';
> 2) I just deleted the XP 'atempted' registration and tried to re-register
> it. The dialog "Register SQL Server Messages" returns the error:
> "SVR1 - Registration failed for user 'sa'. Reason: Not associated with a
> trusted SQL server connection"
> Any idea how to make this Server connection trusted?
> Thanks!
>
> "Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
> news:OZrDqW0nEHA.2616@.tk2msftngp13.phx.gbl...
> MSDE?
> with
> How
application[vbcol=seagreen]
> is
> osql.exe,
existing[vbcol=seagreen]
> it's
it[vbcol=seagreen]
a[vbcol=seagreen]
> rights.
MSDE[vbcol=seagreen]
are
>
|||Found it. The install command that I used:
SETUP SAPWD="wombat" created 'Windows Only Authentication'. A registry tweak
changed it to mixed, and then I could log on. Not sure exactly why Windows
authentication failed except that the admin name and pwd were different on
the MSDE machine from those on the machine that I was connecting from.
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:OZrDqW0nEHA.2616@.tk2msftngp13.phx.gbl...
> Even if you can figure out your connectivity problem, it's probably not
> legal anyway. From the Appropriate Uses of MSDE FAQ at
> http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp:
> Q. Can I use SQL Server tools and services in conjunction with
MSDE?
> A. You can only use SQL Server tools and services in conjunction
with
> MSDE if you acquired MSDE through SQL Server 2000 (Developer Edition,
> Standard Edition, or Enterprise Edition), and if you are using MSDE in
> conjunction with a properly licensed copy of SQL Server 2000. Visit the
How
> to Buy page for information on obtaining a valid SQL Server license.
> Note: The tools and services included with SQL Server Developer
> Edition may not be used to manage production server environments.
> The following utilities are installed by the MSDE setup application
> and are provided without restrictions for use with the copy of MSDE that
is
> installed by your application: bcp.exe, cnfgsvr.exe, dcomscm.exe,
osql.exe,
> sqlmaint.exe, sqlmangr.exe, scm.exe, sqladhlp.exe, and svrnetcn.exe. The
> dtsrun.exe utility is also provided, but can only be used to run existing
> Data Transformation Services (DTS) packages against the copy of MSDE
> installed by your application; it cannot be used to develop new DTS
> packages.
>
> There's not enough information in your post to determine whether or not
it's
> legal, but in the vast majority of instances it's not and I'm told that it
> requires a room full of lawyers and white board to figure out. There are a
> bunch of 3rd-party tools out there that might be of use. Have a look at
> Aaron's list at http://www.aspfaq.com/show.asp?id=2442.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Andrew Chalk" <achalk@.XXXmagnacartasoftware.com> wrote in message
> news:%23VTyAG0nEHA.1160@.tk2msftngp13.phx.gbl...
>
>

Administering MSDE with Enterprise Manager

Can I administer SQL 2000 MSDE Release A from SQL Server's Enterprise
Manager (EM) located on another machine on the same network?
When I try to do this the EM setup wizard locates the host running MSDE but
it cannot connect either with Windows authentication or the strong password
created during MSDE's install.
EM can see other instances of SQL Server 2000 on the network (these are not
MSDE).
MSDE is running on XP (SP1) and EM is running on W2K workstation.
Many thanks.
Even if you can figure out your connectivity problem, it's probably not
legal anyway. From the Appropriate Uses of MSDE FAQ at
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp:
Q. Can I use SQL Server tools and services in conjunction with MSDE?
A. You can only use SQL Server tools and services in conjunction with
MSDE if you acquired MSDE through SQL Server 2000 (Developer Edition,
Standard Edition, or Enterprise Edition), and if you are using MSDE in
conjunction with a properly licensed copy of SQL Server 2000. Visit the How
to Buy page for information on obtaining a valid SQL Server license.
Note: The tools and services included with SQL Server Developer
Edition may not be used to manage production server environments.
The following utilities are installed by the MSDE setup application
and are provided without restrictions for use with the copy of MSDE that is
installed by your application: bcp.exe, cnfgsvr.exe, dcomscm.exe, osql.exe,
sqlmaint.exe, sqlmangr.exe, scm.exe, sqladhlp.exe, and svrnetcn.exe. The
dtsrun.exe utility is also provided, but can only be used to run existing
Data Transformation Services (DTS) packages against the copy of MSDE
installed by your application; it cannot be used to develop new DTS
packages.
There's not enough information in your post to determine whether or not it's
legal, but in the vast majority of instances it's not and I'm told that it
requires a room full of lawyers and white board to figure out. There are a
bunch of 3rd-party tools out there that might be of use. Have a look at
Aaron's list at http://www.aspfaq.com/show.asp?id=2442.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andrew Chalk" <achalk@.XXXmagnacartasoftware.com> wrote in message
news:%23VTyAG0nEHA.1160@.tk2msftngp13.phx.gbl...
> Can I administer SQL 2000 MSDE Release A from SQL Server's Enterprise
> Manager (EM) located on another machine on the same network?
> When I try to do this the EM setup wizard locates the host running MSDE
> but
> it cannot connect either with Windows authentication or the strong
> password
> created during MSDE's install.
> EM can see other instances of SQL Server 2000 on the network (these are
> not
> MSDE).
> MSDE is running on XP (SP1) and EM is running on W2K workstation.
> Many thanks.
>
begin 666 ts.gif
J1TE&.#EA`0`!`( ``````/___R'Y! $`````+ `````!``$```(!1 `[
`
end
|||Thanks. I think it is an authentication issue rather than a 'property
rights' issue. This is because:
1) I just installed the same version of MSDE on a W98SE machine and was able
to register it successfully with the copy of 'Enterprise manager';
2) I just deleted the XP 'atempted' registration and tried to re-register
it. The dialog "Register SQL Server Messages" returns the error:
"SVR1 - Registration failed for user 'sa'. Reason: Not associated with a
trusted SQL server connection"
Any idea how to make this Server connection trusted?
Thanks!
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:OZrDqW0nEHA.2616@.tk2msftngp13.phx.gbl...
> Even if you can figure out your connectivity problem, it's probably not
> legal anyway. From the Appropriate Uses of MSDE FAQ at
> http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp:
> Q. Can I use SQL Server tools and services in conjunction with
MSDE?
> A. You can only use SQL Server tools and services in conjunction
with
> MSDE if you acquired MSDE through SQL Server 2000 (Developer Edition,
> Standard Edition, or Enterprise Edition), and if you are using MSDE in
> conjunction with a properly licensed copy of SQL Server 2000. Visit the
How
> to Buy page for information on obtaining a valid SQL Server license.
> Note: The tools and services included with SQL Server Developer
> Edition may not be used to manage production server environments.
> The following utilities are installed by the MSDE setup application
> and are provided without restrictions for use with the copy of MSDE that
is
> installed by your application: bcp.exe, cnfgsvr.exe, dcomscm.exe,
osql.exe,
> sqlmaint.exe, sqlmangr.exe, scm.exe, sqladhlp.exe, and svrnetcn.exe. The
> dtsrun.exe utility is also provided, but can only be used to run existing
> Data Transformation Services (DTS) packages against the copy of MSDE
> installed by your application; it cannot be used to develop new DTS
> packages.
>
> There's not enough information in your post to determine whether or not
it's
> legal, but in the vast majority of instances it's not and I'm told that it
> requires a room full of lawyers and white board to figure out. There are a
> bunch of 3rd-party tools out there that might be of use. Have a look at
> Aaron's list at http://www.aspfaq.com/show.asp?id=2442.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Andrew Chalk" <achalk@.XXXmagnacartasoftware.com> wrote in message
> news:%23VTyAG0nEHA.1160@.tk2msftngp13.phx.gbl...
>
>
|||Hi Andrew,
This message means you don't have Mixed Mode authentication enabled. If you
do have enterprise manager connected, you can change this easily by looking
under the "security" tab in the properties of the server. (Right-click the
server to get to it). You need mixed mode before you can use "sa" or any sql
server username.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Andrew Chalk" <achalk@.XXXmagnacartasoftware.com> wrote in message
news:OzXHOC3nEHA.2616@.tk2msftngp13.phx.gbl...
> Thanks. I think it is an authentication issue rather than a 'property
> rights' issue. This is because:
> 1) I just installed the same version of MSDE on a W98SE machine and was
able[vbcol=seagreen]
> to register it successfully with the copy of 'Enterprise manager';
> 2) I just deleted the XP 'atempted' registration and tried to re-register
> it. The dialog "Register SQL Server Messages" returns the error:
> "SVR1 - Registration failed for user 'sa'. Reason: Not associated with a
> trusted SQL server connection"
> Any idea how to make this Server connection trusted?
> Thanks!
>
> "Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
> news:OZrDqW0nEHA.2616@.tk2msftngp13.phx.gbl...
> MSDE?
> with
> How
application[vbcol=seagreen]
> is
> osql.exe,
existing[vbcol=seagreen]
> it's
it[vbcol=seagreen]
a[vbcol=seagreen]
> rights.
MSDE[vbcol=seagreen]
are
>
|||Found it. The install command that I used:
SETUP SAPWD="wombat" created 'Windows Only Authentication'. A registry tweak
changed it to mixed, and then I could log on. Not sure exactly why Windows
authentication failed except that the admin name and pwd were different on
the MSDE machine from those on the machine that I was connecting from.
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:OZrDqW0nEHA.2616@.tk2msftngp13.phx.gbl...
> Even if you can figure out your connectivity problem, it's probably not
> legal anyway. From the Appropriate Uses of MSDE FAQ at
> http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp:
> Q. Can I use SQL Server tools and services in conjunction with
MSDE?
> A. You can only use SQL Server tools and services in conjunction
with
> MSDE if you acquired MSDE through SQL Server 2000 (Developer Edition,
> Standard Edition, or Enterprise Edition), and if you are using MSDE in
> conjunction with a properly licensed copy of SQL Server 2000. Visit the
How
> to Buy page for information on obtaining a valid SQL Server license.
> Note: The tools and services included with SQL Server Developer
> Edition may not be used to manage production server environments.
> The following utilities are installed by the MSDE setup application
> and are provided without restrictions for use with the copy of MSDE that
is
> installed by your application: bcp.exe, cnfgsvr.exe, dcomscm.exe,
osql.exe,
> sqlmaint.exe, sqlmangr.exe, scm.exe, sqladhlp.exe, and svrnetcn.exe. The
> dtsrun.exe utility is also provided, but can only be used to run existing
> Data Transformation Services (DTS) packages against the copy of MSDE
> installed by your application; it cannot be used to develop new DTS
> packages.
>
> There's not enough information in your post to determine whether or not
it's
> legal, but in the vast majority of instances it's not and I'm told that it
> requires a room full of lawyers and white board to figure out. There are a
> bunch of 3rd-party tools out there that might be of use. Have a look at
> Aaron's list at http://www.aspfaq.com/show.asp?id=2442.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Andrew Chalk" <achalk@.XXXmagnacartasoftware.com> wrote in message
> news:%23VTyAG0nEHA.1160@.tk2msftngp13.phx.gbl...
>
>

Administering msde

Hi all,
I am totaly new to all this sql server think. I have installed MSDE on Win2K
Server.
How do you administer this think? Is there een interface? I have tried SQL
webadmin.
When I try to open the site with IE I see source code of the file
default.aspx.
Why is this?
Any help would be great.
tnx. in advance
Admir
hi admir,
admir wrote:
> Hi all,
> I am totaly new to all this sql server think. I have installed MSDE
> on Win2K Server.
> How do you administer this think? Is there een interface? I have
> tried SQL webadmin.
> When I try to open the site with IE I see source code of the file
> default.aspx.
> Why is this?
>
personally I do not like WDA very much... but you perhaps can find some
hints at http://www.sqljunkies.com/forums/ ..
if you need a Web based admin you'd probably better invest in myLittleTools
(http://www.mylittletools.net/mla_sql) ... other free and commercial tools
for administering MSDE are listed at
http://www.microsoft.com/sql/msde/partners/default.asp ,
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.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

Admin'ing MSDE?

Hi all,
How are those of you that run MSDE admin the thing?
The Web Data Administrator doesn't seem to much of a solution.
Sean.
hi Sean,
"Sean S - ECU" <SeanSECU@.discussions.microsoft.com> ha scritto nel messaggio
news:FBB4C248-520A-4BC4-BF5A-9E51F6A1D0C4@.microsoft.com...
> Hi all,
> How are those of you that run MSDE admin the thing?
> The Web Data Administrator doesn't seem to much of a solution.
you can have a look at a free prj of mine, at the link foolowing my sign.;
other third parties tools (free and commercial) are listed 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.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
|||"Andrea Montanari" wrote:

> you can have a look at a free prj of mine, at the link foolowing my sign.;
> http://www.aspfaq.com/show.asp?id=2442
Excellent! Thanks.
Sean.

admin tool for MSDE?

What admin tools are developers using for MSDE applications? If SQL Server
Enterprise Manager is unavailable and the Web Access tool is just too
clunky, what else is popular?
Thanks,
Bill
Cincinnati,OH USA
My favourite (if EM is not applicable) is QALite which is a really cool tool
for scripting and other things, just try this.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Bill" <usenet@.spoofed.com> schrieb im Newsbeitrag
news:7dc07$426bf7cd$d8c4ff3d$14512@.FUSE.NET...
> What admin tools are developers using for MSDE applications? If SQL Server
> Enterprise Manager is unavailable and the Web Access tool is just too
> clunky, what else is popular?
> Thanks,
> Bill
> Cincinnati,OH USA
>
|||Hi,
DBARTISAN from embarcadero is also really good for administering SQL Server.
http://www.embarcadero.com/products/dbartisan/
Thanks
Hari
SQL Server MVP
"Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:OLBhrfQSFHA.1268@.TK2MSFTNGP14.phx.gbl...
> My favourite (if EM is not applicable) is QALite which is a really cool
> tool for scripting and other things, just try this.
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "Bill" <usenet@.spoofed.com> schrieb im Newsbeitrag
> news:7dc07$426bf7cd$d8c4ff3d$14512@.FUSE.NET...
>

admin tool for MSDE?

What admin tools are developers using for MSDE applications? If SQL Server
Enterprise Manager is unavailable and the Web Access tool is just too
clunky, what else is popular?
Thanks,
Bill
Cincinnati,OH USAMy favourite (if EM is not applicable) is QALite which is a really cool tool
for scripting and other things, just try this.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Bill" <usenet@.spoofed.com> schrieb im Newsbeitrag
news:7dc07$426bf7cd$d8c4ff3d$14512@.FUSE.NET...
> What admin tools are developers using for MSDE applications? If SQL Server
> Enterprise Manager is unavailable and the Web Access tool is just too
> clunky, what else is popular?
> Thanks,
> Bill
> Cincinnati,OH USA
>|||Hi,
DBARTISAN from embarcadero is also really good for administering SQL Server.
http://www.embarcadero.com/products/dbartisan/
Thanks
Hari
SQL Server MVP
"Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:OLBhrfQSFHA.1268@.TK2MSFTNGP14.phx.gbl...
> My favourite (if EM is not applicable) is QALite which is a really cool
> tool for scripting and other things, just try this.
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "Bill" <usenet@.spoofed.com> schrieb im Newsbeitrag
> news:7dc07$426bf7cd$d8c4ff3d$14512@.FUSE.NET...
>

admin tool for MSDE?

What admin tools are developers using for MSDE applications? If SQL Server
Enterprise Manager is unavailable and the Web Access tool is just too
clunky, what else is popular?
Thanks,
Bill
Cincinnati,OH USAMy favourite (if EM is not applicable) is QALite which is a really cool tool
for scripting and other things, just try this.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Bill" <usenet@.spoofed.com> schrieb im Newsbeitrag
news:7dc07$426bf7cd$d8c4ff3d$14512@.FUSE.NET...
> What admin tools are developers using for MSDE applications? If SQL Server
> Enterprise Manager is unavailable and the Web Access tool is just too
> clunky, what else is popular?
> Thanks,
> Bill
> Cincinnati,OH USA
>|||Hi,
DBARTISAN from embarcadero is also really good for administering SQL Server.
http://www.embarcadero.com/products/dbartisan/
Thanks
Hari
SQL Server MVP
"Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:OLBhrfQSFHA.1268@.TK2MSFTNGP14.phx.gbl...
> My favourite (if EM is not applicable) is QALite which is a really cool
> tool for scripting and other things, just try this.
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "Bill" <usenet@.spoofed.com> schrieb im Newsbeitrag
> news:7dc07$426bf7cd$d8c4ff3d$14512@.FUSE.NET...
>> What admin tools are developers using for MSDE applications? If SQL
>> Server
>> Enterprise Manager is unavailable and the Web Access tool is just too
>> clunky, what else is popular?
>> Thanks,
>> Bill
>> Cincinnati,OH USA
>>
>