To all SQL guru I understand MS SQL Express can only "subscribe" which means u need Full version of MS SQL to do the "publication" . Is there any other way to do some sort of replication without the full MS SQL? Gigihi Gigi, AFAIK, actually not you could "write your own" code to perform a "poor's man log shipping" solution, like http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1742 or the like but still it's a "poor's man" solution..
HI EVERYONE, CAN SOMEONE INDICATE A URL WHERE I CAN DOWNLOAD THE MSDE2000 SOFTWARE. I DON'T NEED THE MSDE2000 RELEASE A WHICH IS VERY DIFFICULT TO INSTALL AND CONFIGURE. MANY THANKS IN ADVANCE.hi, you have an additional download at http://www.microsoft.com/sql/downloads/2000/sp4.mspx , and you have to search Sql2kdesksp4.exe, already upgraded at the sp4 level but the installation/configuration complexity is the same.. as the product is the same..I created a batch file to use when installing MSDE. I just edit it for whatever SAPWD i'm going to use. Makes it really easy. @echo off setup.exe INSTANCENAME=MyInstanceName SAPWD=MyStrongPassword SECURITYMODE=sql DISABLENETWORKPROTOCOLS=0
error. In other words, the ODBC driver is translating the field from SQL server (via Cast type function?) but Access thinks that the number can exceed the limit of an autonumber and we get the error. The only work around I have found so far is to link access to a table with the same name and ODBC connection, but where the SQL Server field is just an integer. Access then translates the field as a long integer. Then I replace the SQL table with the one that has the incrementing integer field, but don't refresh the link to Access. Records can now be added and edited in Access without a problem. Anyone seen this bug?I can't follow your scenario, having never seen anything resembling your description. Does the identity column in SQL Server have a unique index or primary key
WSUS server. Problem is it can't install WMSDE (SQL Server 2000 Desktop Engine) http://www.team-novel.com/~zoner/errorlog1.txt http://www.team-novel.com/~zoner/errorlog2.txt http://www.team-novel.com/~zoner/errorlog3.txt Get these errors: arguments Install detected on this machine details successfully successfully installed on this machine (Error 0x80070643: Fatal error during installation.) 0x80070643: Fatal error during installation.) failed (Error 0x80070643: Fatal error during installation.) (Error 0x80070643: Fatal error during installation.) failed. You can look at C:\Program Files\Update Services\LogFiles\WSUSMSDESetup_050920_0836.log file to determine the cause of the failure Setup\UninstallHelper.exe to C:\DOCUME~1\ADMINI~1.CHI\LOCALS~1\Temp
correctly. Thanks! J.Make sure you read all notices as well as the README file before downloading/installing. The current SP4 has known issues.Thanks, that's quite the link! Legal issues aside, a link that long is bound to be fragile (i.e. MS is likely to change the link at some point). I wish there was a permanent location (http or ftp) where you could get at these downloads. It sounds like there's no choice but to bring up an IE window at the download page and tell the user where to click in order to download something. Bummer. Would you happen to know where I could ask about MS's download policy? Who would know about this kind of stuff (e.g. permanent links, putting these long links in code, etc)? It seems like the MSDE newsgroup might not be the best
Hi NG My appologies for cross-posting, but I'm not sure which is the correct NG. As per Books Online: "Managing Desktop Engine Installation Package Files", I have edited the sample.msi package and given it 2 new GUIDs. I have renamed this file to "MSDE2000SP3a.msi", and added it to a folder (C:\Setup) along with "setup.exe" (from the MSDE2000SP3a download), sqlresld.dll, SqlRun.cab, as well as the RESOURCES directory tree. command to install MSDE: "C:\Setup\setup.exe" /i "C:\Setup\MSDE2000SP3a.msi" DISABLENETWORKPROTOCOLS=0 SECURITYMODE=SQL SAPASSWORD="MyPassword123" TARGETDIR="C:\Program Files\Microsoft SQL Server\" DATADIR="C:\Program Files\Microsoft SQL Server\" INSTANCENAME="NetWhyz" /L &
server: 1 Ending custom action UpgDetectBlankSaLogin(). UpgDetectBlankSaLogin.2D02443E_7002_4C0B_ABC9_EAB2C064397B. Return value 3." I search in the log file the value 3 and I see too one link to support http://support.microsoft.com?kbid=830477, but this link hasn't relation for the error of above "UpgDetectBlankSaLogin". Solutions? Carlos Pastorhi Carlos, you should provide the additional parameter SAPWD=the_password to your call to the MSDE boostrap installer..hi Carlos, this can not be true :) probably your MSDE instance has not been set to allow standard SQL Server authenticated connections, which requires "mixed mode", but trusted WinNT authenticated connections only.. you can modify that via the SECURITYMODE=SQL parameter as you already
the database in MSDE, without the aid of Access. I already read everything that had at the Forum, but even so I didn't get. I already consulted the Manual Online. I only need to know which the command to access my database for my application. I already tried: osql healthy /U /P " " /S nameserv /??? and nowI think what you need is either if you are on a domain or on a NT/2K/XP workstation OSQL -E -d"master" -OR- if you are on 9x/Me OSQL -U"username" -P"password" -d"master" Then all you should need to do is 1>sp_attach_single_file_db 'c:\MyDir\MyDatabase.mdf' 2>go IF you don't have a database file already you can script out the CREATE batches and run them
I have a downstream WSUS server running WMSDE synchronizing with an upstream WSUS server running WMSDE. What if I want to move to SQL Server 2005 on the downstream server? Can I load SQL server 2005 on the same machine and leave wmsde running for WSUS? The server is capable of running SQL Server 2005 and the network is small.Yes, since the MSDE is most likely the 'default' server, you will be asked to provide an 'Instance' name for the SQL 2005 installation.
SQL server by going through the MSDE linked server. I can easily create linked tables in Access to a db defined in MSDE, or SQL Server, but I cannot find the magic bullet to let Access link through MSDE to the linked SQL server. HowardNo. Create the linked table directly to the SQL Server you are interested in, or create a view in MSDE that pulls the data in the SQL Server and link to that.A view wouldn't work because the client needs it to be updatable. a SQL MSDEViews can be updateable if you tell Access what the PK/unique index is, but I would recommend linking directly to the SQLS table instead of trying to go through linked servers. If that is not possible, a second option would be to not use links at all for the updates. Write stored procedures in the MSDE database that
\administrators of SQL Server, and grant that windows account login privileges using sp_grantlogin system stored procedure (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts _sp_ga-gz_8dri.asp) and then grant database access to that login for all desired databases using sp_grantdbaccess system stored procedure (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts _sp_ga-gz_290z.asp) for your convenience, you can have a look at a free prj of mine at the link following my sign., which provides a user interface similar to Enterprise Manager, which provides these functionnalities too in a viusal way.. further free and/or commercial tools for managing MSDE can be found at http://www.microsoft.com/sql/msde/partners/default.asp and http://www
and I am concerned there might be issues in using them on the same server: SmarterTicket / MSDE 2000 Windows SharePoint Services / WMSDE Thanks - Jodyhi Jody, WMSDE is a customized version of MSDE 2000 distributed along with and only available with SharePoint it has been modified to fit SharePoint needs and you should avoid using it for your own databases.. I do not have a WMSDE eula available, but I think it prohibits a shared use with other apps and related databases.. install 2 separated instances, 1 of WMSDE to be used by SharePoint and another MSDE one to be used by your other apps.Andrea, In reference to you comment: " it has been modified to fit SharePoint needs and you should avoid using it for your own databases " Do you mean that I should avoid
if you leave it blank it will set it defalt. Also, should I work with the command window at all if I was using setup.ini? -MartinI suggest you download SQL Server Books Online - this covers the MSDE product too, and defines the arguments for the setup.exe, as well as the ini file settings. http://www.microsoft.com/sql/techinfo/productdoc/2000/books.mspx For a default install, you do not need to edit the ini file, there are several command line parameters you can specify in a .bat file. The particular changes you have made are not ideal from a security point of view. AJThanks AJ, The link you gave me brings me to general info about books online. I in fact read through "Installing Desktop Engine" and "Windows Installer Return Codes for Desktop Engine&
Mark, you can try manually uninstalling the MSDE instance, as described in http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q290991 .. just a caveat, the indicated method does not clean up the Windows Installer MSDE related registry entry, so you need to download MSIZap.exe, part of the Windows Installer SDK to fix that (http://support.microsoft.com/default.aspx?scid=kb;en-us;320873) if you need/want to clean that registry area as well..Hi Andrea, thanks for getting back to me. I tried uninstalling MSDE manually (as described in kb;EN-US;Q290991). I removed the entries in my registry and tried installing again. Result was the same; ********************************************************** counter >= 0, shutdown will be denied. Counter after decrement: -1
hi, how can I download msdex86.exehi, MSDE 1.0 is no more available for download you can perhas get it from older Office versions (Office 2000 I think, but I'm not sure..)
one.. I have a co-working that is running Sql Server on a desktop and she has 3 tables that are extremely large. The files are so large she has no disk space let to work, At the current time it is not possible to replace the internal drive. She has a 320gig external drive that she wants to move these tables and then link to them to run her queries. Is this something that is possible in Sql Server?hi, you can detach the database via sp_detach_db system stored procedure (http://msdn2.microsoft.com/en-us/library/ms188031.aspx), move the relative database files to the external drive and reattach the database via CREATE DATABASE FOR ATTACH; statement (http://msdn2.microsoft.com/en-us/library/ms176061.aspx) like USE [master] GO CREATE DATABASE [Raj] ON ( FILENAME = N'
www.microsoft.com/sql/downloads/2000/sp3.asp (sql2kdesksp3.exe) these 2 versions both are updated at service pack 3a level, share the same code build and path but do not share the same EULA and the same feature the first package, MSDE Release A, only allows to install fresh instances of MSDE updated at service pack 3a level, while the second one allows you to install fresh instances of MSDE as long as updating previous installed instances at service pack 3a level, but require you to be entitled for it's use and download, beeing owner of MSDN, SQL Server, VS.Net or other listed Microsoft software Thank you Andrea. That gives me the lead I am looking for. But first if I could pursue this matter which is causing me real problems , almost desperation desperation. 1. The real
I have a small program that linked to ACT! version 6 dbf files. I now have ACT!7 SQL version. This uses MSDE. I need to link to the ACT! tables in the MSDE instance. Any hints? ACT! technical help says I can not link. I thought I would ask the real MSDE experts instead.hi Scott, what do you mean by "link"?
this is a general MDAC error that can be troubleshooted via http://support.microsoft.com/default.aspx?scid=kb;en-us;328306&Product=sql hints..So you are suggesting that Sequel tools should not be used to manage wmsde? How else can you back the database up? I believe the help file suggests using sequel tools.hi Bill, no, I'm not suggesting you have not to use SQL Server Client Tools, but you have to be carefull AFAIK, as http://www.microsoft.com/resources/documentation/wss/2/all/adminguide/en-us/stsglos.mspx states, you must be running SQL Server 2000 and not WMSDE to back up and restore the entire configuration database and each content database on your server.. but I'm not a SharePoint guy :( perhaps you'll find better support on SharePoint newsgroup
database engine. I have 2 questions which can't seem to be answered anywhere on the net: 1. We have various vulnerability scanning tools that show WMSDE not having SQL SP4 applied. I can't find any way of installing SP4. I've tried with the full-blown SQL SP4 installer, and I've also tried with the MSDE SP4 installer, with no luck. How can I ensure my WMSDE is upgraded to SQL SP4? 2. In our environment (WSUS installed with WMSDE on same machine), can I upgrade the WMSDE to SQL 2005 Express and have WSUS continue working? (this would solve my 1st question by ensuring the DB engine is as new as possible) Please, any help would be appreciated. I can't find any definate answers on the internet.I am also looking for a solution for #1. Have you had any
I have a stable 3rd party application which has been running on MSDE Sp3 (ver 2000.80.760.0) as the default instance. I installed WSUS, which apparently uses WMSDE (version 2000.80.884.0), as a named instance. After this installation I noticed that the original SQL server has a memory leak, consuming the resources of the server over a few hours. I upgraded (replaced) the Sp3 default instance with Sp4 (version 2000.80.2039.0). Howeveer the problem seems to be continuing. Is it wise to have these 2 different database versions running on the same machine or should I separate/amalgamate them? TIAhi, WMSDE is a modified version of MSDE that enables db size larger then 2gb per database, that is one of the constraints/limitations of "standard" MSDE, and is provided
version running. I have pinged the SQL Server from the MSDE Server and they can both see each other. Any suggestions you might have would be greatly appreciated!! Thanking you in advance, m00nm0nkey!!Pinging the servers does not prove anything other than each PC is on the network. Can you connect to the MSDE Server through Enterprise Manager (adding it to the default Server Group) on the SQL Server machine. If yes, it is most likely something wrong in how you have defined the link or referencing the SQL Server in your queries. If no, then it would suggest the MSDE Server does not have the Network Protocols enabled (turned off by default in a normal installation). Alternatively, you may have a firewall or packet filtering enabled on the MSDE machine blocking ports 1433 (TCP
time. I've granted my windows account login access, the install is NOT set for windows authentication only, and TCP/IP is enabled. I can login as sa from the command line but not through the ODBC manager. I'm on about my 5th reinstall and have become very frustrated here. Can some one point me in the right direction please?That error is a login failure, it surely doesn't help reinstalling. You need permission to log into your SQL Server. If you are member of the local administrators group, you shouldn't get this error. Other possibilities could be if you have semi-colon in your username (there is a KB article on this). Please use your full name when posting
the new server.. Enterprise Manager can do it for you, both for detacching and re-attaching operations but for your convenience you can have a look at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_da-di_83fm.asp .. once reattached, you can incur in "orphaned users" problems, where database users lose their link to the relative SQL Server standard logins as the trait-d'union, the sid value of database.dbo.sysusers system table and master.dbo.sysxusers master table do not match on it or the database user(s) is not present but you can "fix" that using the sp_change_users_login sytem stored procedure (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ca-cz_8qzy.asp), but
My AV app uses MSDE to keep track of what PC has was sig file, I would like to install WSUS on the same server but since it will install WMSDE I'm wondering if the two will cause problems. Does anyone know anything about this? Has anyone else done this before, or can you even have two apps that run on MSDE on the same server? Any suggestions would be greatly appreciated. Matthi Matt, I've heard it's possible.. depending on your installation, you'll end up with 2 named instances (1 named instance for the AV storage and 1 for WMSDE) or (and this is the most probable situation), you'll have 1 named instance for the AV storage and a default instance for WMSDE and SharePoint..
Hi! We're using MSDE 1.0 and one customer informed us, that his Sygate personal firewall spit out the following message: bcp.exe is trying to connect to go.microsoft.com [22.214.171.124] using port 80. the exe's path is the path that we'd expect and bcp still does it's job, namely saving the databases to files; so I doubt that it is a hijacked version; but we'll have to double check that. Can anyone explain why bcp would want to connect to a website? StefanCheck your event log. For many Microsoft Products, events that have errors can connect to or provide a link to go.microsoft.com if you have error reporting enabled that might be where the error goes I see this in my event log for various auditing events and errors: For more information, see
Hi, I'm deciding whether to use WMSDE or the full SQL Server for the back-end of WSUS. Can you tell me whether it is possible, in any way, to take a backup of the WMSDE database? It doesn't have to be remote, but must be automated, and able to be performed with the database online. This is just so that we can restore the db quickly from a backup file should it be necessary.Backing up databases in MSDE is easy. It can backup to a disk file. You can either use osql to backup, or any of the miriad of utilities out there. The backup can be automated for any schedule you choose. It can be done while the db is online, but when you restore, all users must be logged out. of backup automated, should
I've got a situation where WSUS is already installed on a server and I'm looking at moving my anti-virus system on to the same server, however my AV uses MSDE. The server is running 2003 and therefore WSUS is running in WMSDE. I take it I can't use WMSDE for my AV solution so I'd like to know, is it viable to simply install MSDE 2000 along side WMSDE, or will I have to move WSUS out of WMSDE and into MSDE 2000? I assume I'll have some conflicts at minimum with the ports clashing if the two live together, and there are likely to be other major problems. Does anyone have any ideas or suggestions?hi, WMSDE should not be used for other means then the ones it has been released for, so just install another instance of MSDE for your AV you'll have no "
that exists on a network share that I'm trying to link to as a linked server from SQL Server. Sitting at the SQL server machine, I can create the linked server (both by EM and sql), connect to the access db, query data, see tables, etc with no problems. However, if I go to another machine and try to access the linked database, either through EM or through sql, I get this error message: Server: Msg 7399, Level 16, State 1, Procedure sp_tables_ex, Line 20 OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. [OLE/DB provider returned message: The Microsoft Jet database engine cannot open the file '\\server\path\database.mdb'. It is already opened exclusively by another user, or you need permission to view its data.] OLE DB error trace [OLE/DB Provider '
3 entries, that denotate error conditions a valuable information in oorder to troubleshoot installation can be found at http://support.microsoft.com/kb/317328/en-usI was unable to find any return value 3 in the log. yesterday, I downloaded visual c# 2005 Express. The download gave me the option of downloading Sql Server 2005 Express as well. It downloaded, then the download window said it was installed successfully. But when I look at will be skipped due to the following restrictions: Condition "EventCondition: __STP_LaunchPatchedBootstrap__3796" returned false. Don't know what that means. So I don't know what to do with this database, I need a link to start using it rather than technical stuff for people who already know how to use it. Also,
hi all, Can u provide the link to download MSDE version 1 for Windows 95 & NT Dilhi, it is no longer available for direct download.. you can find it on Office 2000 cd, on MSDN, Hi Andrea, I got MSDE from office 2000 CD. but it requires Access 9.0 or Office server Extensions (OSE) has to b installed on same machine. besides its an installshield setup utility, which allows Remote installation also. pls comment Dilhi, I'm not aware of such requirements in order to install MSDE 1.0 (msdex86.exe installer package).. the requirement I'm aware of is IE 4.0, and the release notes of the msdex68.exe package, part of "MSDE for Visual Studio 6.0" distribution, including SQL Server 7.0 Dev Edition does not list Office 2000 or OSE at all and,
Where can I find WMSDE?Hi Jens, You can't. It's the version used (and installed) by Sharepoint. HTH,
clear up the confusion I am not stopping the SQL server service when using our Restore utility. The service I mentioned is part of our product, and this is really performed as a precaution. Also, the Restore command appears to execute OK. The error occurs when our service is attempting to restart. That being said, I decided to play around with the Backup/Restore operations within DbaMgr2k (I am pretty new at using the tool). I received an error message when trying to run the Restore using the old copy because it could not locate the mssql7\data directory (removed - by me - as part of the uninstall of MSDE 1.0). I added this directory back, and the RESTORE functioned correctly. One thing that I did not realize was that the MDF/LDF files are relocated in this process. I
Hello, What is the best way to import data to a client's MSDE database from our website? We want our client to log onto our website so we can update a table on the client's PC. I need a little direction on this, not sure which is the best way to go. Thank you, Randershi Randers, perhaps you could provide an ftp based solution to download new data from your website and the MSDE remote client proceed with a scheduled job to bulk insert it.. you can even set the job to notify via mail of the success/failure of it (just use an SMTP solution like http://www.sqldev.net/xp/xpsmtp.htm ) or mail them, but this become more manual as the final user has perhaps to read the mail, save the attached file in some defined file system position and let the scheduled task process the file..
Hi. I'm about to install an MSI-packaging software, which needs either MS SQL (we don't have it) or MSDE. I already have WSUS running and it uses WMSDE. Can I install install MSDE (distributed with the software) without screwing up WSUS/WMSDE? Anttihi Antti, yes you can just intall a separate named instance of MSDE up to 16 instance of SQL Server 2000 and MSDE can be installed on the same machine.. each instance will have it's own binaries, memory space, registry entries and the like.. they will only share the shared components at the highes service pack level, like SQL-DMO you can find shared components in \Program Files\80 filder and subfolders..Hi Andrea and thanks, it worked fine. Antti
(in a separate procedure) our app locally on a tablet PC with a blank MSDE database. We'll figure this part out. Then, periodically, when they are able to access our 'master' ASP.NET app from the road, we would like for them to be able to download selected rows from a number of tables from the central SQL db to their local MSDE. They would make changes locally (offline), then reconnect later on and upload the data back to the central db. I am thinking that creating a linked server temporarily on the master db (via a call to sp_addlinkedserver) to transfer this data back and forth to the MSDE db may be the way to go, but haven't found any specific info/case studies/etc. that supports that. In addition, I created an MSDE database on a tablet PC which is hooked