Hi Is there a graphic tool I can use with msde? Is it possible to use the enterprise manager? CindyCindy, You can certainly use Enterprise Manager running on a different machine where full SQL server is installed. If you don't have that try WinSQL at http://www.synametrics.com/winsql. WinSQL is not a replacement for Enterprise Manager but for Query Analyzer. Dennis
error messages? In a previous message a similar problem was solved by installing File and Print sharing. Unfortunately I do not know what this means. Any ideas? Yannishi Yannis, open the control panel applet -> services check the "Server" service is running this service allows file and pront sharing activities if not present, select your network connection properties File and Printer sharing for Microsoft network must be installed if not present.. when running the MSDE setup.exe, please add the /L*v "c:\MsdeLog.txt" parameter, in order to log the installation process to file, about 2mb, you can later inspect for troubleshooting, looking for RETURN VALUE 3 entries
Trying to figure out when clients need to purchase a full SQL Svr license. How is the number of concurrent users/transactions determined? SQL stmts are quickly executed so how long is a MSDE user deemed current? Same as IIS server?See if this link has the information you need: http://msdn.microsoft.com/library/?url=/library/en-us/architec/8_ar_sa2_0ciq.asp?frame=true JimGood link. YIKES - I ran the dbcc concurrencyviolation command and got a real surprise! I'll reset it and see just when my activities over 8 are occurring! Kevin http://msdn.microsoft.com/library/?url=/library/en-us/architec/8_ar_sa2_0ciq.asp?frame=true
MSDE would make a great local cache in my app that uses dialup networking. However, the App comminicates with sybase running on Linux. Am I allows to use MSDE this way? Or should I use an open source database for a local cache?you're ok using MSDE. joe.
Hi, I've just reinstalled MSDE release A on my machine. When I boot up the icon in the systray is not there but it shows that it is running in task manager does anyone know why tis is happening at what I can do to have the icon back in the systray??hi, in the Starup folder, create a link pointing to "C:\Programmi\Microsoft SQL Server\80\Tools\Binn\sqlmangr.exe" /n
I created my installation package using the MSDE Deployment Toolkit. Everything compiled fine. When I run setup of the machine that created the setup package, it opens the screen where I can chose my installation etc. When I run it on another machine, I get the error - "Bootstraploader -> Unable to load localized strings." How do I sort this out??I have exactly the same problem the
a question We have recently developed a application in ASP that is being shipped to a client server in Ireland. The ASP application has a database backend in SQL2000. The clients server is likely to have between 25 and 40 users accessing the application. There will be no SQL development or amendments needed on the client server. We will however need to replicate the data back to our HQ. Will MSDE cover the Licensing requirements Many Thanks in advance of your helpHi Carl, Unless the clients are all likely to be hitting the web app constantly and you can live with the 2G database limit, I think it should be fine. HTH,Carl, Remeber that the limit for simultaneous connections is 25. The database starts to lag at 8. 's Bruno app constantly and should be fine. being
We are running the following script to backup an MSDE 2000 DB: osql -Usa -P -n -Q "Backup Database pdticket To Disk = 'E:\mssql7\backup\pdticket.bak'" Our problem is that the above script *appends* and we want to *overwrite* the DB every night. Can someone tell me what I need to do to change the script to *overwrite*? TIA, ClaytonWith Init
Does MSDE support triggers?Hi niv, Yes. Best, Hugo
Hi I 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 dump, below is
I have an ASP.NET web application that will be accessed from the Internet. Does the MSDE redistributable license cover this situation?<WARNING: I'm not a lawyer> Yes. It's commonly used that way. The biggest limitation is usually the database size limit if you make good use of connection pooling. </WARNING: I'm not a lawyer> HTH,
Our DotNet/SQL MSDE app no longer runs after applying XP SP2. When you double-click on the app icon nothing happens. To fix this I simply right-clicked on the app-icon and selected properties. On the Compatibility Tab I selected Windows 2000. Now it works fine. 1) Why is no dialog displayed indicating an error condition, ie. rights/memory, etc. 2) Is there a way to set the Windows 2000 compatibility flag programmatically via a batch file, registry, cmd line tool?hi Bill, properties. SP service pack 2 changed a lot of things regarding SQL Server connections too.. I've not installed sp2 yet, and I'm not aware of your specific troubles, but it's worth reading http://support.microsoft.com/default.aspx?kbid=841249 and related links
I created a install shield package on windows 98 using the MSDE merge modules with vb .net. It works fine on 2000 and xp but on windows 98 it give an ambiguous error: "Error 1723. Theres a problem with this windows installer package. A DLL required for this installation to complete could not be run." This happenes as soon as I click on the msi file. Or if I click the setup file then after a couple checks and when setup tryes running the msi file. Anyone have any ideas
There is a bugfix in sp4 that I need for a customer machine. I have been unsuccesful in getting service pack 4 installed on a test machine. configuration: windows 2000, msde 2000 sp2 setup command line: setup /upgradesp sqlrun SECURITYMODE=SQL UPGRADEUSER=myadminacct UPGRADEPWD=mypassword /L*v C:\MSDELog.log The setup runs for a couple minutes, then dialog progress bar winds down. I have a 3.7 MB log, at the end I have: MSI (c) (44:BC): Note: 1: 1729 MSI (c) (44:BC): Product: Microsoft SQL Server Desktop Engine -- Configuration failed. MSI (c) (44:BC): Grabbed execution mutex. MSI (c) (44:BC): Cleaning up uninstalled install packages,
Hello, We get these events logged every night, apparently when the SQLAGENT tries to do it's backup. I'm afraid I didn't configure MSDE on this particular server, and I don't have any Enterprise Mgr functions on the desktop, so I'm slightly at a loss as to how to go about resolving this issue, being that I'm a noob when it comes to SQL. Any advise, help or pointers would be great. A pint goes to the first correct answer! Andy Griggs.
It's possible work fine with msde 2000 with 50 users concurrent. Thanks for allhi Richard, please see Aaron's reply in [Re: connection or user limitation] thread
I have installed MSDE in WinXP Professional SP2, and already enabled the TCP/IP protocol in SQL Server Network Utility. However, I find that it is failure to connect the database by calling the IP Address even I test it locally (use sa/window authorization) , but it is ok by calling the computer name or (local) (also use sa/window authorization) . I have disabled the firewall and the situation is no change. Anyone have same experience on this case?Yes, I have. But I have no answer how to fix it. There must be a bug somwhere. Lars-Inge Tonnessen
2000 SP3 fails to install on a windows 2000 terminal server. The error message I get is "MSDE 200 SP3 installation failed with exit code 1603" and “A strong password is required for security reasons. Please use SAPWD switch to supply the same. Refer to read me for more details. Setup will now exit.” I have come across this once before and removed the server from the domain, in this case that is not an option. I have denied the read right to the default domain policy which is the only policy that is applying. Anybody have
SQLRUN.cab required for this installation is corrupt and Ic:\MSDERelA\setup.exe SAPWD="Testing"< i get the follwing error.. The cabinet file "sqlrun.cab required for this installation is corrupt and cannot be used> then the install rolls abck..any ideas? I downloaded a copy a second time and got the same error.hi Tim, never had this kind of problem perhaps your copies really have been corrupted while downloading
How does the MSDE and SQL Server 2005 Express calculate the database size for the 2GB and 4GB limit respectively? Are they based on database size or just the allocated part of the database size? Does it include log file size? I want to write a script to check whether a database is reaching 90% of the limit. I wonder which function or system stored procedure I should use. Thanks for any help.*Peter* z wysiłkiem wystukał(a) przypadkowy ciąg słów: IMHO they based on allocated database size. It doesn't include log file size.
Are there any compatibility issues between Microsoft SQL Desktop Edition and SQL Server 2000 Personal Edition Compatibility. I would like to install one packaged application that uses MSDE 2000 and a second packaged application that uses SQL Server 2000 Personal Edition. Both seem to be using MDAC 2.8I dont see that there is any problem as far as compatibility is concerned.
What are the limitations of MSDE compared to SQL 2000? tia, Jim Evanshttp://www.aspfaq.com/2343 http://www.aspfaq.com/2345Thanks, Aaron, some interesting information. Jim Evans
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 different service pack levels, but on production servers I always ask the end user before installing if he/se needs a separate
I been trying to read the posts to answer this, but I don't see a straightforward answer. Can MSDE and SQL Express '05 co-exist on the same machine? Wayne P.Yes, because you can both install them as an instance. However, because SQL Express 2005 is only in Beta at the moment, it is not advisable to do this on a production machine, only on a test machine.
I'm aware you can install MSDE on a customers site if they dont have SQL Server, correct? If so can you install the client setup off the SQL Server cd so you get enterprise manager? How do you handle backup/restore 'nicely' without EM? LHIf so can you install the client setup off the SQL Server -No, that would break the EULA. -There aremany free tools outside to use: One example: https://www.whitebearconsulting.com/Utilities.htm HTH, Jens Suessmeyer.
I use an application that stores all its information in an msde database and i would like to replicate the details in the live system to a backup system. Any idea which files i need to copy?Hi, There are 2 options:- 1. Perform a backup, copy the file to destination server and Restore the database (no downtime) 2. Detach the database, copy MDF and LDF to destination, attach the database I. Backup and Restore 1. Backup the database from OSQL from command prompt. c:\> OSQL -Usa -Ppassword -Sserver_name (
Dear Sirs. MSDE 2000 SP 3a Merge Module Does not installing on Windows XP Without XP Service Pack. It is work if SP1 is instaled on Windows XP. But how i can use that merge modules if SP1 is not installed on Windows XP ? Thank you in advance.Install SP1 on Windows XP. You can generally do this if it's a legal copy.
Can I distribute a MSDE 1.0 database(SQL Server 7) so that the user cannot see its contents even if the user has SQL server installed on his machine? I use visual basic 6.0 and I need to distribute data that cannot be seen(nor opened) by the user, except from the VB 6 application.hi Rick, no, you can't every SQL Server administrator (member of server's sysadmins) will be able to access your database for further info please have a look at http://tinyurl.com/9rzrd
I'm having a problem with my queries that use date fiels. In Access, I have to put # around the date in my SQL statements. This works great on my development computer for Access, MSDE and SQL Server. My problem comes up with I run my product on a workstation. It is giving me a -2147418113 Catastrophic Error on my sql statement. If I change the # to ' it works. Why does it work on my development computer but not on a different PC? My initial guess was because of a different DLL that is installed on my PC. Does anyone have any ideas?hi Jeff, I actually do not know, but, as you already stated, date have to be enclosed in ' for SQL Server statements and should raise an exception at parse time otherway..
The istall hangs at: Executing "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlredis.exe /q:a" The work-around code in the MS white papers is not an option, What is up?This effects us a great deal as well. I have to say the whole install scenario for MSDE 2000 has been incredibly frustrating with many issues that MS could fix, simply KB articled instead. You can't depend on users not running applications that occasionally stop pumping their message queue. This just stops the installer dead.We are having and the install hang at the exact same point. Previously in the thread there was a reference to a knowledge base article. If there is a workaround could you post a link to that article or white
fact that it has completed the stored procedure execution. When I run a stored procedure that inserts data into a table the initial message that it is running the procedure is displayed but there is no further message indicating that it is completed although the inserted data does appear in the table. If anyone can explain why the termination message does not appear and/or how I can cause it to appear I would be very grateful. Thanks very much.msde won't give that info without something being written to do it. Maybe someone has put code into the procs to display this but doesn't have anything for the completion in some procs.
Hi, I am trying to install msde as part of the installation with Live Communications server. The installation rolls back with the following shorten version of the log file. Any suggestions you could give me will be helpful. . Starting custom action InstallSQLAgentSecurity InstallSQLAgentSecurity failed (MACHINENAME,LocalSystem,87). Header(Signature=1397708873,Version=200,Timestamp=827547001,LangId=1033,Platform=0,ScriptType=2,ScriptMajorVersion=21,ScriptMinorVersion=4,ScriptAttributes=1) SQL Server Desktop Engine) RollbackInfo(,RollbackAction=Rollback,RollbackDescription=Rolling back action:,RollbackTemplate=,CleanupAction=RollbackCleanup,CleanupDescription=Removing backup files,CleanupTemplate=File: [
Hi How do I make an MSDE remote instance to be available on the network. It was installed without the network protocols being enabled.Hi, Are you talking about enabling TCP/IP protocols. YOu have a utility under the Program Files/Microsoft SQL server\80\binn\Tools folder Srvnetcnt.exe. You can enable the protocols using this utility. -Zs the network. enabled.
Hello, I'm a network / server guy at heart who has been given a quasi-DBA hat to wear lately, so bear with me. I have a WSUS (localized Windows updates) server that uses MSDE 2000 as its back end. Since last weekend I started to get an error that points to a database problem. For the curious, read this: http://support.microsoft.com/kb/910847 I am disgusted that I cannot go somewhere to download the hotfix, but rather, I have to call and ask for it. And hope to not get charged for the call. So, what I'm looking for are utilities that will allow me to peek inside the database
What is the maximum DB size for MSDE 2 GB per DB?hi Adrian, yes, 2gb per database, including only the data file(s) and not the transaction log file(s)
MSDE 2000 Release A does not support merge modules to embed MSDE with custom application setup. I went through MSDE Bootstrapper Toolkit and apparently it is still in beta. How would I distribute my application? Is there any other way of embedding MSDE 2000 Release A with setup package?Rats, I get to pass the news you won't like again :-) Every option I've seen/tried to install the MSDE silently has issues. We've given up and just ship a setup.ini file that's appropriately modified to suit our requirements and then just get the end user to run the setup.exe program. Since doing so, we've gone from tons of setup issues to almost none. The situation improves greatly with SQL Express but that's not today. HTH,