will install the new instance. I'm concerned about overwriting the initial instance which I believe is also a named instance. The command line they gave me was with their disc inserted in E drive EXE /I E:\SETUP\MSDE\SQLRUN01.MSI /Q TARGETDIR="C:\PROGRAM FILES\NETWORK ASSOCIATES\EPO\" COLLATION=SQL_LATIN1_GENERAL_CP1_CI_AS SAPWD=<PASSWORD> REBOOT=R I have one instance already. Is this going to overwrite it? DaveHi Dave, AFAIK only one default instance is allowed to exist - all other instances must be named instances. there's an command line parameter for specifying the instance: INSTANCENAME="name" you'll also have to adjust the instance name in the application which is going to access the sql server
associated with a trusted SQL Server connection.' You cannot verify your sa password while in Windows Authentication mode. However, you can create a sa password so that your sa account is secure in case your authentication mode is changed to Mixed Mode in the future." Any ideas? I'm desperatehi Guy, when installing MSDE instances, please always provide the /L*v "C:\MsdeLog.TXT" additional parameter to your call of setup.exe MSDE installer in order to enable verbose logging of the installation process, which will log a 2mb file of it.. if you have problems to troubleshoot, you can then inspect that file searching for RETRUN VALUE 3 entries that, in the 10/15 lines before of after each entry, report some (somtime cryptic) problem of the installation
and enter OSQL -L it says there are no servers. Should it not say which server is available. Has anyone experienced this before. My system is no longer showing the available servers. My application still seems to work because when I type in the name of the server manually it is located. How can I solve this problem. Danny Gaethofshi Danny, MSDE installs by default disabling network protocols in order to minimize external (malicious) attacks, preventing the installed instances to be available for remote connections and disabling it's broadcast enlisting for available SQL Server/MSDE instances to make it available for remote users and to enable server enlistment you have to use Server Network Utility (svrnetcn.exe) and enable the desired/preferred network protocol(s)
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.
present instance of MSDE? If it's OK to use an already existing instance of MSDE then I would need the instance name in order to attach my app DB, which was the reason for my initial post. As always, any and all assistance is greatly appreciated.Hi Pete, With MSDE, the preference is that you install your own instance. I'd suggest a named instance with your app name as the instance name. In future with SQL Express though, this recommendation changes. The preference then will be everyone using a single instance. HTH,Greg; I suspected that the application ought to have its own instance. I appreciate your confirming this for me. As an aside, for any others that come alone, one can locate the named and unamed SQL/MSDE instances via ServiceController.GetServices
Rel A (sp3a level) and upgrade to sp4 via http://www.microsoft.com/sql/downloads/2000/sp4.mspx MSDE package (or directly install MSDE at the sp4 level but currently it's not clear to me if general users not owning a "required" SQL Server license as per http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp are eligile for direct sp4 use just a note, Microsoft representatives already exposed a refresh of MSDE Rel A updated at sp4 level will be made available ) yes, you can install MSDE on both servers, and even provide a replication paht between the 2 MSDE instances, as MSDE supports merge and snapshot replication (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replover_694n.asp) but, unfortunately, without Enterprise
Instance on a Server (only for testing). I have connect the Query Analyzer and the Enterpise Manager with the 3 Instances (always on the server). Then i wanted to connect a client ( the Query Analyzer and the Enterpise Manager of this client) with the Instances. With the instances of SQLServer 2000 it goes but not with the MSDE. Why does it not go withhi, MSDE installs by default disabling network protocols for security reasons you can modify this behaviour both at install time, providing the DISABLENETWORKPROTOCOLS=0 parameter to the setup.exe boostrap installer of MSDE, or later, at "run-time", running the Server Network Utility (svrnetcn.exe) and enabling the required/desired network protocol..Thanks, the problem was, that in the TCP/IP configuration (svrnetcn
3004 thread 3004 Any ideas!!!hi, this is one of the problems that caused Microsoft to stop supporting merge modules consume by installer products the very first one is related (actually to the same problem) disabling direct upgrade of the installed instances via "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 clean Windows Installer related registry entries via MSIZap.exe utility, part of the Windows
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.
create a linked-server definition via Enterprise Manager. Does anyone have any thoughts either about how to get this approach to work, or a better way to solve this problem? Thanks in advance for your help!hi Rick, this seems like you want to perform a push operation, from the "master" to all "remote" MSDE instances I'd go the opposite way when the remote MSDE instance is able to connect to the "master", add a linked server from remote to master, perform the operations you need, drop the the linked server the broadcasting mechanism to propagate server presence over the lan is not always granted as lot of stuff is involved for instance: have a look at ListAvailableServer exposed by SQL-DMO: ListAvailableServer
Hello All I am planning to use DTS against a MSDE database. Can somebody please clarify is it possible to use DTS against the MSDE database. Karenhi Karen, you are legitimate to use the DTSRun.exe command line utility, not the Enterprise Manager GUI but you can deploy your tested DTS packages to MSDE instances and execute them via the command line tool
and testing was conducted on a remote, standalone system, and when completed, we were able to move appropriate copies to the LAN via an external 80GB Western Digital USB attached portable drive. Is it possible to copy one or more or the SQL databases (all tables) from the SBS SQL server to an MSDE system? (ie a network attached laptop). I would appreciate your assistance and comments. Regards .Dave K.hi Dave, as you can't use DTS to manage MSDE instances (and more you say that your SQL Server is a version 7.0 server), you have to rely on backup/restore and/or sp_detach_db/sp_attach_db solutions please keep in mind you will probably experiencing orphaned users problems after that operation(s), you can resolve using system stored procedure sp_change_users_login (http://www
, reachable with teir 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
networked applications cannot. There are no other firewalls or packet filtering on the network. I'm behind a Microsoft Wireless Base Station Router. Am I missing something? This problem is about to drive me insane. I'm using the exact same installation program and parameters to setup.exe, but some instances just don't want to play on the network. Any help would be greatly appreciated. Thanks in advance. Rob Reagan rob at digitallabsinc.comAre any of the MSDE instances installed on XP SP2? If the MSDE instance does not have SP3 installed then XP will block MSDE from broadcasting its status. You can see warnings about this in the system event log. This is the same with Windows Server 2003. Jim all network. Calls. SP2. noYOU ARE THE MAN! Thanks so much for that response.
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? Davidhi 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/
on this machine also. is this possible? What is the command line option for this? STomhi STom, you can install up to 16 SQL Server/MSDE instances on the same pc (having of course a good and boosted pc :D) in order to install a named instance, you have to provide the INSTANCENAME=" pwd verification (as long as weak password) for SQL Server logins is includedAndrea, I appreciate your patience and knowlede on this. Here is my command line: setup INSTANCENAME="myinstance" SECURITYMODE=sql SAPWD="X75_37ABCDEF" /qn MSDE installs fine, no GUI. I then do the following to try to log into the instance osql -S <mymachinename>\<myinstancename> -U sa It then asks me for a password. The only password that works in my
cmd prompt: \setup /upgradesp sqlrun INSTANCENAME=CRM /L*v c:\MSDELog.log This works perfectly.However, I cannot do this on any of my SHAREPOINT Instances. Can anyone assist please? Johnhi John, from the sp4 readme file, "MSDE 2000 SP4 updates instances of SQL Server 2000 MSDE 2000 and MSDE 2000 Release A. " Share Point installs a different version of MSDE, known as WMSDE where some intrinsic MSDE limits has been removed (2gb data file per database) in order to fullfill Share Point needs and requirements so, in my understanding, I think you have to get the new WMSDE package to upgrade your Share Point instances Hi Andrea First of all, many thanks for the reply. Could you post a URL to where I can download the new WMSDE Patch? I've
situation where you can set up the maintenance plan but the drop down box for the type of period (days, weeks, etc) after which to delete expired backups is blank. My first thought is that there's an issue with using EM to set up maintenance plans on MSDE. Thanks for any assistance.hi Charles, unfortunately, your first thought should be that you are not licensed to use Enterprise Manager against MSDE instances, and you should rely on self based solutions or third party tools (http://www.microsoft.com/sql/msde/partners/default.asp or http://www.aspfaq.com/show.asp?id=2442 , google for others)Thanks for your message. My understanding of the licensing is you can use Enterprise Manager IF you own a copy of SQL Server Standard or greater. If my understanding is correct, then the
Hi, Is it possible to create DTS packages with MSDE? If so, how? Would you execute them via the "dtsrun" command-prompt utility? Thanks very much, Mark HolahanMSDE does not come with the tools that are necessary to create DTS packages. For that you will need to user Enterprise Manager, which come with the full versions of SQL Server, including the Developers version. MSDE instances can store DTS packages in their repository and MSDE 2000 comes with the dtsrun.exe utility, allowing you to execute packages. Jim
already and I installed one for the POS System. The client PCs can see the other 3 MSDE instances, but cannot see the one I installed. Any ideas on how the new instance can appear on the network. The new instance was not named. The other three were named instances of MSDE.hi, please verify the required/desired network protocols are enabled MSDE installs by default disabling them and you can override this behavior providing the DISABLENETWORKPROTOCOLS=0 parameter to the setup.exe boostrap installer, or later, at run time, using the Server Network Utility (svrnetcn.exe) and enabling the preferred network protocol.. additionally, WinXP sp2 ships with a built-in Firewall that's enabled by default, preventing network connections to if this is a case, you have to specify
Six months ago I rework our application to use MSDE as a desktop DB. It was used to replace Paradox. I develop in Delphi with ADO. I realized tremendous performance gains and the ability to use stored procs and computed columns made many tasks far eaiser. But we seemed to have shot outselves in the foot. Because to the significant performance gains, we added additional features that involved "max server memory (MB)". Probably it will be 2147483647 which means SQL server can use all of the available memory. While this is good for the performance of SQL server, it might cause problems for other apps on the server. So if the machine is not a dedicated database server (and usually MSDE instances are not), limit the max server memeory to a more convenient number. M
How can I tell which of the SQLServers listed on the network are specifically MSDE. I want to make sure that I have licenses for all the full versions of SQLServer that are running. AlanIssue one of the commands on the servers you want to find that out: Select @@VersionAnother command would be to SELECT SERVERPROPERTY('Edition'); http://msdn.microsoft.com/library/?url=/library/en-us/tsqlref/ts_sa-ses_3mi1.asp?frame=true
Let me re-iterate that I am not upgrading an instance rather I am trying to install an instance with the SP4 updates, hoping that I get all of the tools that I can in one shot.hi, you can directly go with the sp4 version it can both install fresh sp level MSDE instances as long as upgrade existing pre-sp4 instances..ANDREA, Thank you for your answer. I have another question. I am sending these files across a network and trying to automate the installation. I know how to automate the MSDE install after I have extracted the files from the SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE, but is there a way to use command lines to extract silently or maybe even feed it a path to extract to? That way I only have to worry about one file? ANdrewhi, unfortunately this installer is a Wise based
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
and confers no rights. __________________________________ Visit www.hitchhikerguides.net to get more information on my latest book: Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)Thanks. I like the analogy too :) I am new to SQL Express - does one generally have multiple SQL Express instances going like one did with MSDE when each app needed its own Or will SQL Express allow apps to coexist within one SQL Express instance? Thanks again!hi, you should maintain the "shared" template as long as possible, to reduce hardware contentions so install the "default" computerName\SQLExpress "shared" instance for all your needs do not use
application and I'm wondering, if SQL Desktop already exists on the machine its being installed on, what will happen if I try to install a named instance of MSDE? Will it still install and then show an additional service in the Services MMC? STomhi STom, you can install up to 16 instances (1 default instance and 15 named instances) on the same pc all installed instances will have separate binaries (just the shared part of them will be "shared" and updated at the highest service pack level), registry keys, path and folders, and, of course, they will be separately listed in SQL Server Service Manager and in the Services MMC applet.. the default instance will be listed there as MSSQLSERVER and SQLSERVERAGENT, while each named instance as MSSQL$instanceName and
troubles becouse of potential external attacks have you ever checked for them? hope your server is not exposed about removing the pwd it's not strange as it is not a SQL Server constraint to have password (again, even if recommended) providing it at install time is a constraint imposed by Micorsoft in the sp3 installation package because of the Slammer and Saphire hits, where lot of customers where unaware of their (hidden) installations of (1 or more) MSDE instances provided by other softwares but you can always reset to blank via EXEC sp_password @new = NULL , @loginame = 'sa' it's up to your precaution and confidence
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,
to work properly, becouse precding release of Sql-DMO Components of Sql Server 2000 present a bug in this area. Courtesy of Mr. Gert E.R. Drapers further Information at http://sqldev.net/misc.htm The Service Pack 3a introduced some new amenity in order to prevent MSDE 2000 to be hit by Internet worms like Slammer and Saphire virus and to increase security, so that Microsoft decided to default for disabling SuperSockets Network Protocols on new MSDE 2000 installation. Instances of SQL Server 2000 SP3a or MSDE 2000 SP3a will stop listening on UDP port 1434 when they are configured to not listen on any network protocols. This will stop enlisting these servers.Thanks for your response! SuperSockets Network Protocols were enabled during installation of MSDE2000. I am able to connect
my app uses it too? Is it safer always to make my database run in its own instance? Regards jhi Jeff, I don't understand this question if you install an application, does it make sense uninstalling it? if you need that MSDE instance, don't uninstall it.. product I don't know if Visio install a separate MSDE instance (my Visio installation did not) .. but you can install up to 16 different instances of MSDE.. 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"
Is it possible to check programatically (with C#) if there are MSDE instances somwhere in the local network, like you can look with the Service Manager? Thanks, Rainer.hi Rainer, several methods are available please have a look at http://www.sqldev.net/misc/EnumSQLSvr.htm , http://www.sqldev.net/misc/ListSQLSvr.htm and http://www.sqldev.net/misc/OleDbEnum.htm in order the remote instance to be available, they need to have network protocols enabled
me any solution for this issue. And, can I use the Enterprises manager to manage the MSDE? And how can I know any MSDE is running on the PC? Many Thanks!!!!!hi, try changing your Windows collation before installing MSDE to one of the "supported" SQL Server Windows collations you are not allowed to use Enterprise Manager, Query Analyzer and so on, on MSDE solutions you have to rely on home built tools or third party solutions please have a look at http://www.microsoft.com/sql/msde/partners/default.asp , http://www.aspfaq.com/show.asp?id=2442 for some of them, both free and commercial google for further.. in order to know if you are connected to MSDE instances, you can query for SET NOCOUNT ON SELECT SERVERPROPERTY( 'Edition' ) AS [Edition
I have an SBS 2003 R2 box with 1 default SQL MSDE instance and 3 named SQL MSDE instances. We are considering installing Blackberry Professional Server Express Edition, which requires SQL Express 2005. Is it possible to install a single named instance of SQL Express 2005 in parallel with the MSDE instances without interfering with my existing MSDE instances?hi Joe, yes, it is.. but the eventual "shared components" of MSDE will be replaced with the relative 2005 version (SQL DMO libraries, for instance).. and having 5 SQL Server instances running on the very same box seems to me to be a havy load for that machine, but it obviously depends on the real workloads..
the protocols and as you said, TCPIP was disabled. I enabled it and I could walk one step more. But only one step. Now I'm stopped again. I didn't use the command SECURITYMODE=SQL. When I installed MSDE it asked me to write a SA password and I did. Now, if I try to connect from a workstation it gives me two kinds of error, depending on what I do: 1) If I try to connect using the SA user and the =SQL parameter. Here's how I installed it yesterday; setup.exe INSTANCENAME=whateveryouwanttocallit SECURITYMODE=SQL SAPWD=???? DISABLENETWORKPROTOCOLS=0 Because there are already two MSDE instances installed on SBS2003, you'll want to install it with your own instance. That way you can connect by specifying the server as SERVERNAME\INSTANCENAME, and use
I am trying to install a second sql on the main computer, everything works fine till I upload an update to it. Is there a way to make it work properly?hi, teoretically, up to 16 MSDE instances (at different service pack level as well) can be installed on the same machine.. and I can confirm (not about 16 instances, but 5) it works as expected.. what do you mean by "it works fine till I upload an update to it"? if you mean "update data", the obvious question is if you correctly provided the instance name at connection time.. as you already know only 1 instance of them can be the default instance, that can be referred as "(Local)" or "ComputerName", depending on
named instance on it's appropriate port.. if you manually set the TCP/IP port the named instance(s) will be listen on, you can close (on your firewall) the UDP 1434 port as it is no longer needed, but you'll probably need to specify an ALIAS (via Client Network Utility, cliconfg.exe) on all your remote clients..Thank you very much for your reply Andrea. Although I've seen installations with several MSDE instances before I never thought about how they worked untill now, therefore I've never even realised there is a manager service to resolve the ports for each service! Thank you for enlightening to this!