never used it before (command line and all *shudder*). But supposedly it does come with MSDE. The real answer to the question, "How can I execute a query and view the databases?" is: You write a front-end application in VB, C++, or Delphi (yeah Delphi). And probably using ADO as the database connectivity technology. Other than that, there are some free and (and some not free) grahical MSDE management programs. Google for them "free enterprise manager", or "msde management tool", etc..There are GUI Utils for MSDE 2000 as Ian stated, you can Install Enterprise manager ie the client tools if you have a full SQL server 2000 Server version and a SQL License or use OSQL , see below article: How To Manage the SQL Server Desktop Engine
I have installed MSDE2000A and it is working perfectly on the local machine, but how do I connect from a remote Enterprise Manager? I keep on getting the message that either sql does not exist or access denied. How do I fix this?Hi, Using client network utility (cliconfg.exe) create a new Alias Specifying IP Address and port number in machine which has Enterprise manager. use this ALIAS name to register. Hari SQL Server MVP
the above mentioned error. But I don't understand the solutions. About the operating system I an a novice too. Installed MSDE a few times before the server Icon with the green errow apered. Deinstalled MSDE 2000 a few times and removed also the directories. Some in this newsgroup mentioned that there are entries in the registry that should be deleted. But about the registry I am a novice. Is there another solution to make a clean install. Henkhi Henk, about the folders and registry entries to be deleted, you can have a look at http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q290991, which completely remove an MSDE instance from a pc but for the presence orphaned Windows Installer registry entries.. for the latter you have to use MsiZap.exe, part of the Windows Installer
I am using the MSDE deployment toolkit to deploy MSDE release A. The total size of my install is ~80 MB, of which my application accounts for 1 MB. Is it possible to create a smaller MSDE install by excluding certain merge module depending on the features used by the application?hi Marius, you should always provide the full "package" other "cannibalized" packages could produce erratic behaviours resultin in installation failure..
you want to do with them you can use Acces to query your database, or any other application that is designed to work with SQL Server if you need management tools, to "manage" your MSDE instance for creating logins, databases, tables, objects and so on, you can do it via oSql.exe like explained in http://support.microsoft.com/default.aspx?scid=kb;EN-US;q325003 or resort on third party tools.. you can have a look at a free prj of mine, available at the link following my sign., or for other free and/or commercial tools listed at http://www.microsoft.com/sql/msde/partners/default.asp or http://www.aspfaq.com/show.asp?id=2442; google for furter..Andrea, Thank you very much for the information! You answered my question as well as pointed me out to some resources that I
amp;#39;); SQLConnection.Params.Add('OS Authentication=False'); Now it works very find. It runs on both Win98 and WinXP.hi Peter, are you mixing up trusted connection with user defined credentials for login? how and with what tool are you trying to connect to the MSDE instance? if you use oSql.exe, the command line tool provided with MSDE, you have 2 different ways to connect.. specifying a trusted WinNT connection, c:\ \>osql.exe -E -S(Local) or with a standard SQL Server authenticated connection, c:\..\>osql.exe -Usa -Pyourpwd -S(Local)hi Again, BTW, can you please verify the mixed mode authentication is enabled?.. run regsvr32.exe, locate the registry "LoginMode" key as indicated in http://support.microsoft.com/default.aspx?scid=kb
is running SQL Server is set to Windows Authentication only: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.hi, yes I do think SharePoint installs it' own instance of a modified MSDE release http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_84xl.asp your own strong password for the special SQL during installation. Then I would follow your instructions to check again if the password is blank, if so, using the following to set a password - 1>sp_password @old = NULL , @new = 'yourStrongPassword' , @loginame = One more question about the strong password. Do we have to strictly follow the strong password rules for choosing the password, or could we just use some
parameter to your call to setup.exe boostrap installer, in order to enable verbose logging of the install process.. you can then inspect the txt file for RETURN VALUE 3 entries, and about 10/15 lines before each entry a (sometime cryptic) description of the related problem will be reported before trying again, please verify you have the File and Printer sharing setting enabled, as long as the Server service running.. now. Is there a front end for this like with MSSQL Server, something like the Enterprise manager?hi Joe, you can perhaps have a look at a free prj of mine, at the link following my sign., which implements a user interface similar to Enterprise Manager.. further tools, both commercial and free, can be found at http://www.microsoft.com/sql/msde/partners and http://
I saw this product called Toad and it looked like it was free but I was unable to install it because it complained about expiring and stuff. Thanks for your help.Hi, sure look here: http://www.microsoft.com/downloads/details.aspx?FamilyID=82afbd59-57a4-455e-a2d6-1d4c98d40f6e HTH, Jens Suessmeyer.
to register SQL Server services.. but you can connect to it using the only (command line) tool MSDE is provided with, oSql.exe as reported in http://support.microsoft.com/default.aspx?scid=kb;EN-US;q325003 again MSDE is not provided with graphical tools, but you can have a look at a free prj of mine at the link followind my sign, which provides a user interface similar to Enterprise Manager further tools, bot commercial and free are listed in http://www.microsoft.com/sql/msde/partners and/or http://www.aspfaq.com/show.asp?id=2442Ahaa Andrea, So you are the one the author DBAMgr2K, I'm using it ver 0.7.0. Quite useful some more it's free. Only thing about your powerful software when database structure need to be amended some field for datatype, its prompt
;concurrent queries" versus "concurrent users". The workload governor operates off the former while users are typically looking to configure based on the latter. The workload governor allows essentially 480 (sub-second) database queries or other (e.g., update) operations per minute without degradation. You can ballpark what this means in terms of transactions. Assume a simple transaction has perhaps 5 queries. A mid-level has perhaps 20, and a complex transaction has about 40. So you can support between 10 and 100 transactions per minute with MSDE with no degradation. OLTP leans towards the simple side (volume-wise you might have 70-80% of your transactions in the simple category) so lets assume 75 transactions per minute. The real question for
download the "official" management tool, SQL Server Management Studio Express at http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en for MSDE there's no official graphical tool available, but you can have a look at a free prj of mine, DbaMgr2k, available at http://www.asql.biz/en/DbaMgr.aspx both engines are free to use.. you have to freely register for distribution if you plan to; SQLExpress: http://go.microsoft.com/fwlink/?LinkId=64062 MSDE : http://www.microsoft.com/sql/prodinfo/previousversions/msde/redistregister.mspx yes you have to enable remote connections as, by default, both products disable network protocols at installation time.. you can modify this behaviour both at install
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. BobShi 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
but a Windows admin could move them at desire, as, implementing the required SQL Server privileges managements, a malicious sysadmin can do but in such circumstances I'd argue you should consider to fire your sysadmins direct encryption is not included in SQL Server/MSDE, a bad metropolitan area, isn't it? =;-D ok.. no joke as already said, you can resort on external crypting tecnologies you could even write your own cypher .Net algorithm and pass your data in and out befor saving and after reading but nothing out of the box and xml + encrypted folders suffer the same problems nothing is uncrackable"hey, you are living in a bad metropolitan area, isn't it? =;-D" It's a health agency, and they are a touch paranoid about
a spot opened up. Then again, I don't know what I'm talking about. :) Is there an easy way to tell if I am going to use more than 8 concurrent query plans? Matthi, loosely speaking, yes :) up to 32767 connections are theoretical valid for MSDE too, but you'll go out of resources long before that it's not about query plans, but, again, concurrent workloads.. please have a - would clear a few things up for me though. ScottHi Scott, Comments inline: HTH, -- Greg Low [MVP] MSDE Manager SQL Tools www.whitebearconsulting.com GREG> No, it'll likely be with SQL Server 2005 in the last few months of this year. GREG> Merge replication allows you to have the same table able to be updated on different MSDE servers at the same
', 'weeks', etc. For some reason, this combo is empty. Having skipped this functionality completely, I've setup a complete 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, GBAre you sure you're properly licensed to manage MSDE with Enterprise Manager?Aaron [SQL Server MVP] drukte met precisie uit : I fail to see what the licensing has to do with this problem
Hi, I am running MSDE 2000 and will shortly be moving to sql server. Is there a way using osql to output a script to allow me to easily re- create the database on sql server. thnx in advance leehi Lee, not directly.. but you can perform the required task uing the SQL-DMO component and writing some (actually a bit more then "some") code to do that.. or you can use Enterprise Manager to do that as well.. if you like, you can have a look at a free prj of mine, DbaMgr2k available at the link following my sign., that provides that feauture as well.. or, as MSDE and SQL Server share the same storage engine and the databases can be moved among the editions, you can just retain the database(s) and just upgrade to the higher editions..
at a free prj of mine which implements a user interface similar to Enterprise Manager which includes this feature too other tools, both free and commercial, for MSDE are available as described in http://www.microsoft.com/sql/msde/partners and/or http://www.aspfaq.com/show.asp?id=2442 the "system" is the same MSDE "is" SQL Server just with some limitations and no graphical tools but the core is the same here you are right you should buy SQL Server Developer edition at about $49, that provides you all the tools for testing, debugging, tuning and troubleshooting SQL Server/MSDE based applications.. but for a "starter kit", MSDE can be sufficient as well Hi Andrea Thanks for the info. I tried the osql command
same person on each machine. On the remote machine I've enabled TCP/IP and the default port, and I've added that port to the firewall, but when I try to add a DSN (on the local machine) in the ODBC control panel it says [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. I've looked at the instance via Enterprise Manager and my domain login has admin privs, and can connect a DSN to the SQL2000 server on that machine. Stumped. Suggestions? Keithhi Keith, did you define an exception on the server's firewall on the MSDE used TCP/IP port or on the service itself? http://support.microsoft.com/default.aspx?kbid=841249 http://support.microsoft.com/default.aspx?scid=kb;[LN];841251 http://support.microsoft.com/default.aspx?scid=kb
Hi, I'm installing some software that requires a SQL server database (GFI web monitor reporting). The server I have installed the software on has an existing ISA 2006 MSDE instance. I was wondering if it's possible to create a new MSDE instance for use with the new software. If so is it difficult to do (as I know very little about SQL)? HMSDE is based on SQL Server 2000. While obsolete, it does support multiple instances.
hi, you proabably get this question a lot but can someone point me in the direction of a free adminisatration tool for MSDE ? why dont MS offer one (at least i cant find one) (note: i have the enterprise manager but need an MSDE admin tool for sites that dont have sql server). ScottScott, Look at http://www.asql.biz/DbaMgr.shtm It's a free and useful utility from Andrea Montanari.thanks for reply Scottcheck out this Lite-Version http://sqlmanager.net/products/mssql/manager/ Helmut
set up by the install of the server and I don't know the sa password. If I run osql and try to login with a blank password I get the following error: [Shared Memory]SQL Server does not exist or access denied. [Shared Memory]ConnectionOpen (Connect()). Is there a default sa password? Do I need to do another install of MSDE to create a default installation?hi David, you have better Sharepoint MSDE instance be managed and used by Sharepoint only this for sure I do not know about the other one, SBSMONITORING, but it could be better live this other instance in peace too, but you can probably better ask in SBS NG about this instance, if it's a system requirement or if it allows user's database management at all it it allows user's databases, you can go
complete name, made up by the computer name and instance name, in the form "ComputerName\InstanceName" what kind of problem are you facing?I have a server running MSDE and two existing databases or instances. I am uncertain of the version or how to determine the version. I'm installing HP Insight manager, which requires MSDE 2000, SP3. I installed MSDE 2000, SP3 and created the new instance for Insight Manager. The application worked and the existing databases/instances were accessible and continued to work. A few days later, an Programmer/Administrator was trying to monitor/manipulate one of the previously existing databases via Enterprise Manager and noticed he could not see it the applications utilizing the databases worked fine. I uninstalled the
'm looking for a new manager tool. I have a couple fo custoemrs using MSDE and I am running MSDE manager (Vale Software) to administer them. I was interested in finding out about the newer versions and had a couple of questions regarding bugs. I wrote them weeks ago several times and they have not responded to any of my requests for infromation or help. That was surprising since they used to get back pretty quick. THis has been very disappointing since I really like this tool. So I'm wondering if there is somethign else out there that can be used to manage MSDE? I know that I could use the free SSMSE tool from MS but it doesn't handle the agent and several other things. KeithTry WinSQL (http://www.synametrics.com/SynametricsWebApp/WinSQL.jsp). They have a free version, which
have a clients msde that appears to crash upon any type of connection requiring a restart of the computer.. Cleanup/reinstalling allows the service to stay up for about 15min before begining the same crash issue. Client is on windows XP sp2 - I was going to extract the mdac 2.8sp1 out and rerun that but would like some other ideas before i do that (site is remote and requires phone support) even under osql the server produces a stack of stack data from 0187FA98 to 0187FCB0 0187FA98: 0187FCB0 00514B3F 00A73EA8 00A12578 [ .?KQ..>..x%..] 0187FAA8: 00A125F8 80000000 0061004E 00000000 [.% N.a ..] 0187FAB8: 00200064 003BADC0 003B0640 00000073 [d. ;[email protected]
;.s ] 0187FAC8: 00000000 00000000 00000000 00000000 [ .] :::: 2 Duplicate lines detected 0187FAF8:
restore 2 databases which I need to. I know we can do this with enterprise manager in sql server 2000. How do I restore and see the database with MSDE 2000?? Also, how can I see Enterprise Manager in SQL Express 2005?hi, MSDE is not provided with management tools but oSql.exe, a command line tool you can use as reported in http://support.microsoft.com/default.aspx?scid=kb;EN-US;q325003.. instructions to backup/restore databases are included in the forwarded link for your convenience, you can perhaps have a look at a free prj of mine, DbaMgr2k, available for free at the link following my sign, which provides a user interface similare to EM SQLExpress is not directly provided with a graphical management tool but you can download and use the official limited tool, SQL Server
We have 3 or 4 computers with ADP payroll application on them that uses MSDE. If I install the package under an account such as administrator, then another user attempts to use that computer, each time they logon, it goes through the Windows Installer portion "Please wait while windows configures Microsoft SQL Server Desktop Engine" for about a minute or so. Then it stops, everything is cool. But the next time that user logs on, it will do it again. This will occur everytime someone logs on to the PC. This computer is part of a domain and does NOT use Fast User Switching.hi Martin, this problem keeps popping up from time to time, but I never saw an actual solution/workaround.. as you already pointed out, it is usually referred at installation time or "fast user
Hi all, I've just downloaded SQL Server 2005 Express and I'm wondering what's happened to Express Manager? Apparently it's meant to be available as a separate download? Is it even available yet and if not when's it likely to be out? Simonhi Simon, eXpress Manager will be available for download in the next future at the moment you can resort on a free Query Analyzer replacement you can get for free at http://www.tegels.org/qara/#dl please post messages about SQLExpress and SQL Server 2005 in the related beta newsgroupThanks very much.. What's the full name to the beta newsgroups? Simon.hi Simon, the for please go to http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&slcid=us additional inforamation are provided to access
a working MSDE sp3 (500+ installs) install utilizing the M$ merge modules and Installshield DevStudio. We need to allow a seamless!!! upgrade path to SQL Express which requires sp4 as a minimum. We aquired the new version, created the directories, and switched the merge module location in options. The new SP4 version installed without incidence , but will not uninstall. A ;quot;standard" Microsoft released service packs/hot fixes and requiring the original ISV to distribute branded versions of them.. (service pack 4 [at least] warned about this condition).. you can try manually uninstalling MSDE instances following http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q290991 advices.. http://support.microsoft.com/default.aspx?scid=kb;en-us;320873 adds further hints on how to
USB key at application start up, and obviously detach them before key removal (or the dbs will be marked as suspect).. this is not the very best solution for SQL Server database, both for performance and security reasons, but it can be done and, of course, even if this is an MSDE default setting, set the autoclose db option :D just a side note I recently bought an USB key and read something about 100.000 writes warranty well, I really do not know how long does it takes for SQL Server/MSDE (but even JET) to exceed this value, but I'd expect not that much time . so stay tuned :D SQLExpress will support (single user) User Instances, http://tinyurl.com/bm3to , that combined with .Net XCopy deployment can perhaps get your point Hi Andrea: I know for sure of two
engines.. just remember to modify the compatibility level of each "upgraded" db to 2005 level (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_da-di_5c8c.asp), modify the database owner to a valid principal (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ca-cz_30s2.asp) and update all table's statistics (http://msdn2.microsoft.com/fr-fr/library/ms187348.aspx) with full scan option set.. the very first (pretty physical) one that comes to my mind is Windows Vista support, as MSDE/SQL Server 2000 code based editions will not be supported on the new OS this, of course if you do not need features available on SQLExpress only, such as CLR programmability features, enhaced security, new datatypes
but you do not have to consider about users but agaist concurrent workloads please have a look at http://msdn.microsoft.com/library/?url=/library/en-us/architec/8_ar_sa2_0ciq.asp?frame=true for further info about that I actually use a home made "installer", acutally a UI where all relevant parameters for MSDE installer can be collected, including of course required to your database users if not included in your app, you can have a look at http://www.microsoft.com/sql/msde/partners and/or http://www.aspfaq.com/show.asp?id=2442 for some tool, both free and commercial (my own tool, listed at the link following my sign, provides a free UI similar to Enterprise Manager where this kind of admin tasks can be easely performed) you unfortunately can not
.. ok that number is quite prohibitive as regard resources, as you never will have or desire 16 running instances of MSDE on the same box.. but if you have a "particular" instance you don't want to share with other applications, than you can install a private instance for that app and using a "common" instance for all other databases as long as that instance is up, you need it Does this must be asked to the ISV providing that MSDE instance as per MSDE original EULA it shoul'd be that way, but now MSDE is free, and each instance can be a shared one, as long as the ISV providing it does not specify it's reserved for his/her app(s) it really depends personally I do not, I only have separate instances for test under
same machine. Only one problem left. In testing, I uninstalled and reinstalled with DISABLENETWORKPROTOCOLS=0. But the instance does not show up on the network. In other words, I installed MSDE on Machine A. The Service Manager on Machine A can see its own server, plus an instance of SQL Server on Machine B. Machine B can see its own SQL Server instance, but cannot see the MSDE instance on Machine A. On Machine A, the Network Utility says the tcp/ip default port is 1059 (must be some default, because I did not set it), and Hide Server is not checked. Do you have suggestions about this?hi Paul, it's not a default Microsoft only got 1 unique TCP/IP port for SQL Server assigned by IANA, port TCP/IP 1433 but named instances never listen to that port that is "
but that did not help either. So I uninstalled the Business contact manager, since we were not yet using it and the MSDE, then reinstalled MSDE and that is now working just fine with the database application. Does anyone have any idea what my problem may have been, if I am just unable to have the Business contact manager and MSDE on the same comptuer or if there is a fix or workaround for the problem I am experiencing? Thanks so much, SThi, I do not know about Outlook Business Contact Manager, but as regard the empty SQL Server list in the SQL Server Service Manager, it probably depends on network protocols setting for the installed MSDE instance, as reported in http://support.microsoft.com/default.aspx?scid=kb;EN-US;814132 to modify this behaviour, run the Server Network Utility
This is a newbie question but how can I change the sa password in MSDE?Hi John, We've also got a tool (MSDE Manager) that's free for personal use. Details are on our web site. It can do things like this easily. HTH,