Deployment Toolkit, and MSDE2000 Rel. A. I followed the docs, using the wizard in VS.NET it looks like I was successful in creating an output folder with a "distribution" for MSDE and my application setup. In the directory that contains MSDEBootstrap.exe, I clicked on setup.exe and invoked the Bootstrap dialog. It process running and it will continue to run until I kill it. No log files are created anywhere. I am clueless as to how to debug this. Any suggestions?I'm spent a long time fooling with the MSDE deployment toolkit and merge modules. They're all a piece of junk. The merge modules will mysteriously vomit during the uninstall occasionally leaving the program in an inconsistent (and uninstallable) state. To solve the deployment problem,
2005 technology. This time I don't have the full blown server (and don't need it) so I will use the free version. I know for 2000 it was called MSDE. wanted to verify some preliminary info so I know what to look into further: - new MSDE now called sqlexpress 2005? - configuration of server and databases: - enterprise manager equivelent? - just use visual studio 2005 tools?hi, yes yes SQL Server Management Studio Express, a limited version of the full management tool, available for free at http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en yes.. VS designers give a lot of value already built in the VS Ide.. but SSMSE adds more :D but no tuning tools are present in the Express edition..
integrated security=true" or "integrated security=SSPI" to make a connection. When I try to run my page, everything is fine until it tries to logon to the database server. Then I get a message "Login failed for ServerName\Aspnet. If I specify "user=sa;password=*******" in the connection string everything works fine. What am I doing wrong? Funny thing is, when I use the Server Explorer window in Visual Studio, I have a data connection to the database, and checking the properties, it uses the "integrated security=SSPI" syntax.Hi Mike, The "issue" is "who" the web app is running "as". By default, your web apps run as the user domainormachinename\aspnet. This is configured in your maching
security.. data encryption is embedded in the product of course older applications are not directly SQL Server 2005 "enabled", meaning they do not benefit from these features as they have not been designed to, but the platform is for sure more robust why migrate? it's up to you are you happy with your MSDE solution and/or (for instance) are you heavyly dependent on SQL Server Agent missing feature? or you are likely not very incline to upgrade your very old hardware that can still host MSDE solution? stay there Microsoft supports the current version of the product as long as the pre-current one.. that's to say SQL Server 2005 and 2000 you're granted to be supported (with service packs and the like) all this year long.. but
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 from source server c:\> OSQL -Usa -Ppassword -Sserver_name (enter) 1>sp_detach_db <dbname> 2>go 2. copy the MDF and LDF to destination server 3. Attach the database in source server (Use SP_ATTACH_DB procedure - refer books online) 4.Attach the database in destination server (Use SP_ATTACH_DB procedure - refer books online)thanks i'll try this later and Restore the attach the database with init from OSQL procedure - refer SP_ATTACH_DB procedure - message an in files i
hi Serge, then you can only go for SQLExpress sp2 (not yet released).. tere aren't.. SQLExpress (as MSDE as well) does not include a component to limit connections.. it is limited as you already noticed.. nope SQL Server Personal edition is based on SQL Server 2000 code base..Thanks andrea, its clear nowHello, Perhaps you should also look "out-of-the-box" and take a look at some other free database systems that do not impose these ridiculous limits such as 1cpu and no SQL Agent. Primarily, PostgreSQL and Firebird.
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.
to 16 instances also allowed on the same machine, this means 32,767 2 GB DB's = 64 TB x 16 = 1 PB of space for MSDE on one machine. Now, the interesting part. You can refer to a max of 255 unique DB's in ONE query with MSDE/SQL Server, and hey, that's 255 x 2 GB of data, so theoretically you can query against 510 GB using MSDE. Bye bye 2 GB cap. How to link your 2 GB db's though ? Create a manager lookup table to maintain the virtual/logical name of your DB, that is now 510 GB, while keeping the 'real' name abstracted. I use this with success to query against 1.3 TB of data, all legit and within the EULA. I use AAA, AAB, AAC for db names, and have an abstractor class that manages what the SQL REALLY looks like, such that I can query against one table
." I click OK. The following error appears. "An error 6 - (The handle is invalid.) occurred while performing the service operation on the MSSQLSeerver service." I click stop and then receive the same errors in the same order after being asked if I am sure I wish to stop. I applied a strong password when installing. Thoughts?I am seeing the same symptoms as you are. I just installed VS.Net 200 and MSDE on a brand spanking new hard disk with windows xp sp2 on it Though, I don't know if it is the latest version of MSDE. If I open the sql manager there is nothing in the server field. When try using "local" and click on the refresh services button I get a error saying "The network path is not found." Any ideas how I can get
39;m able to immediately connect after that initial timeout without a problem. This only occurs when wireless networking is enabled, as the timeout does not occur with a physical LAN connection. I have the following installation: MDAC SDK 2.8 MSDE 8.00.761 XP SP2 VS.NET 7.1 Any help would be greatly appreciated. JohnI am having a similar issue using SQL querries over a wireless connection. Is there a technology that is better suited for wireless?? Say .net? Thanks in advance Do you have the same problem if you use an IP address instead of the MSDE instance name? Perhaps you're having a name resolution problem? JimThanks for the post Jim, Ive tried it using IP and Instance name The funny thing is that not all wireless installations have this issue, I have two
is about 42 mb (MSDE2000A). The other is without "Relase A" and its size is around 70 mb (sql2kdesksp3). Can anyone reveal the differences between the two?hi, the differences are bot in the EULA and related rights to install it, as long as the packages them selves.. MSDE Rel A is free to download, install and use and will only install fresh instances of MSDE 2000 updated at the sp 3a level.. sql2kdesksp3.exe can both install fresh instances of MSDE 2000 updated at the sp 3a level and upgrade previuosly installed instances at that sp level, though the size difference.. it's use is related to other EULAS, such as being eligible for having a valid SQL Server licence, VS.Net license, MSDN subscription and so on (other Microsoft software entitle for using that package)
Express. I know the newer the better, but as of this time I cannot afford to take the plung for the devlopers edition of SQL 2005. So back to my questions. I am learning here so take it easy on me. I got SQL 2000 loaded and I can access the server, make tables,etc, I cant get MSDE to work in VS for some reason?(dont know what I am doing probably) Every time I lanch VS and try to connect to the database, I get "VS can only connect using MSDE,etc".I did download MSDE2000 and installed as per instruction went to a command prompted and entered Setup.exe /qb+ INSTANCENAME=VSDOTNET DISABLENETWORKPROTOCOLS=1 SAPWD= as told, an error was promtped, saying to go to the control panel to make changes? -not what the instructions said- , anyhow, to make it short
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
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
MSDE 1. What is the best options to use when doing backups? option 1. OSQL -U sa -P password -S server -Q "BACKUP DATABASE db1 TO DISK = 'c:\Backups\backup1.bck'" option 2. OSQL -U sa -P password -S server -Q "BACKUP DATABASE db1 TO DISK = 'C:\backups\backup1.bck' WITH FORMAT, STATS" 2. Should I also be doing a reindex? I would like to do a batch sql job ( like above backup) USE a database you can have a look at Tibor Karaszi's (SQL Server MVP) article at http://www.karaszi.com/SQLServer/info_dont_shrink.asp about the trusted connection you use here -E indicates to connect as the current logged in account.. and, as the statements you are executing require high permissions in the instance context, this means the current interactive
I developed an application for my customer. I need the MSDE2000 to run the application. Can I install the MSDE2000 for my customer? Should I pay any runtime license fee? Or is it free redistributable?hi, MSDE is free to download, use and redistribute (as long as you register for redistribution rights at http://www.microsoft.com/sql/msde/howtobuy/redistregister.mspx)
Hello, Are there significant performance differences running MSDE 2000 on a Win2k Server vs a WinXP Pro system (not server) for a small network? CharlesC.hi Charles, it all even depends on the overall general system architecture and not only from the OS part disk subsystem, memory, bandwidth, .. I often run MSDE on small lan environments without problems ok, as no DC is present, trusted authentication is not an option, but it often is enought for very small business scenarios..
) at the same time as XP Professional. Might sound like a dump question but this is all new stuff for me. Thanks ..hi, Win XP professional only can host SQL Server Developer edition, Personal Edition or MSDE why do you think you need a full SQL Server instance to solve login troubles? what kind of errors are you reported with, when connecting?Hi Andrea I am getting the MICHELLE\ASPNET login error. Having read appears to be running I can't get to any admin features to adjust the security. So I guess I'd like a remore robust Database system. Besides I though MSDE is best used for deployment rather than development. Thanks for the quick response on my first question. Michellehi Michelle, :D ever best command line tool :D you probably have to grant MICHELLE
responds with the same message: SQL Server does not exist or access denied. I've had a look at all users and groups on my laptop, and I can't find a specific SQL user or anything like that (there is an SQLDebugger account for use with VS.NET, but I don't know what password or whatever that it might be setup with) I'm no guru on this stuff any and all help would be appreciated. What am I doing wrong. Luke. etc reinstall. databases delete on visualLuke, When I installed the latest version of MSDE it only created the system databases (master, model, msdb, and tempdb). It also asked for a strong sa password. You can try logging in as user sa and supply the password you asked it to create. You may have to give it an instance name as well if you
Can i redistribute only osql.exe with my asp.net application we are using licensed Install Shield for packaging.. we use this osql.exe for creating and setup database sahridhayanhi, I do not think you can separate oSql.exe from the full MSDE package from a legal point of view.. but perhaps you've better ask Microsoft representatives I'm not sure about MSDE, but if you have a SQL Server license you can distribute OSQL. Refer to REDIST.TXT for a listing of all the redistributable components of SQL Server.hi, again, I'm not sure you can "cannibalize" osql.exe that way . of course, having a full SQL Server licence, you can install the Client Tools, that include quiet all tools but this way I'm little skeptic but I'm
, Click ok and restart the service. Note: Do the same for SQL Agent service. Hari MCDBA switch IsThank you. But isn't this just part of the changes? Don't I also have to set the right permissions in certain folders and registry keys for the account I am changing the service to? I was wondering if there was a utility that would do all that automatically. Thanks again, Maer Click Agent involved. changeyou need to use an iss file. Check out Setup Initialization File Details and Advanced Installation Options for more info on how to do this.
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 have an access database for 3-5 users. Currently, the size of database increase which in turn reduce the database performance. I thing to put the back end to SQL by using MSDE since my unit cannot afford the SQL Server version. Can I use msde to host data in a shared drive in the network. If so how? SFYou want to examine SQL Server 2005 Express Edition. It is a free download, and should work for you quite well. SQL Server 2005 Express Edition Feature Comparison http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx SQL Server 2005 Express Edition (Advanced/SSMS) http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx http://msdn2.microsoft.com/en-us/library/ms365247.aspx
I'm evaluating HR software and am looking at one MSDE based, wondering what is better / worse about MSDE vs an Access based system. Any input from anyone? Thanks in advance!MSDE (i.e. SQL Server) is almost always better than Jet. Speed. Reliability. Integrity. Functionality. The only value of Jet is that the engine comes with the OS, it's easy to backup/restore, and easy to look inside the database using Access. SQL Server/MSDE is non-trivial to install. It requires special programs to backup/restore, and special programs/your HR front end program to look at the data.
a sample project (Dynamically creates a database) I am trying to use in VS.Net 2002 that my instructor has given me. When I try to connect to an SQL server, (I'm the pc admin with no other groups or accounts) it gives me an error message saying that SQL server does not exist or cannot be accessed. So I figured I'd look at the comments in the code and to my luck I found that the author stated that I needed either SQL or MSDE for the sample project to work. So I downloaded the MSDE and unzipped to a folder. When I double click the setup.exe file it begins to install. After 5 to 10 seconds I get this message saying that: (typed exactly) "A strong SA password is required for security reasons. Please use SAPWD switch to supply the same. Refer to readme for more details
list of redistributable components." Note the words "edistribute certain components of MSDE 2000". Where does it state in the agreement that you can redistribute the entier package? - Hirenhi, the package should be distrubuted as a single unit, and you are licensed to, so that the "components" list is referred to single individual components distribution . ie: you can redistribute SQL-DMO but not SQL-NS (actually SQL-NS is included in the redist.txt list, but http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp exclude it) and so on, and again, only as part of an "application bundle" . MSDE Rel A is free (to download and use) and has been designed to be usable by everyone, and registering for distribution enables
We have a MSDN subscription so I beleive we can redistribute MSDE with our App., but can it be installed on 2003 Server (or any MS Server?). Apart from the limit of 25 connections and 2GB DB size are there any other important restrictions? JamesWorks fine with any of the current OS. I have run it on 2000, xp and 2003. No issues. The 25 connections is a bit vague. MS says a 'workload governor', which I have found to kick in around 15-20 connections.
client site on their 2003 server. I have attached my SQL database via Teratrax Database Manager to the MSDE server however when I try to setup the ODBC connection it doesn't list the database in the drop-down. I cannot attach to the database from my notebook either because I am not authenticated onto their domain. I have also applied the regedit on the LoginMode key setting it to 2 and rebooted but I still cannot connect to the database via the ODBC manager. What am I doing wrong? I am NOT good with the scripts for configuring things - generally I use the Enterprise Manager.Try running the client config (cliconfig.exe) and create an alias for the server. Specify the protocol to talk to it - (probably TCP/IP vs. named pipes). On my system its in \windows\system32. Brian
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 any ideas on how I can install this.hi bob, as indicated by the error description, you have to provide
2000 to SQL Server Express, but I'm beginning to see that more and more as a bad move. Is there any information about storage efficiency of various SQL Server versions? I'm getting extremely poor results with SQL Express. With MSDE there was a 2GB database size limit, with SQL Express that's increased to 4 GB, but it feels like MSDE could store at least as much information in 2GB as SQL Express can in 4GB. Here are some figures _after_ spending half a day trying to delete obsolete data, shrinking the database files etc. - Actual size on disk, and reported in database properties: 1571 MB, with 140 MB free. The log file is < 1MB. - Total size reported by adding data size + index size of all tables: 654 MB. That means more than twice the reported data size
I have two PC running Windows XP Pro in Workgroup Mode. They both in mixed authentication mode with blank sa password. The usernames on each machine are the same and they have no password. The problem I have is with merge replication. The replication fails with the message "Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection." Both computers use the local system account to start the SQL server agent. If we connect manually to the database via ADO using the sa with blank password we have no difficulties. Can someone please advise where I am going wrong. Thank you in advance. ColinHi , There are a number of reasons why this error may occur: Try using these steps: 1) Most probably you may not be able to logon on to the sql server
I need to the best way to make a copy(Backup/export) of the data base put in on a CD or e-mail it. Have instructions to import or restore the database onto another PC. Also in the C:\Program Files\Microsoft SQL Server\80\Tools\Binn> What and how does dtsrun.exe work?Please refer to these articles that might help - 314546 HOW TO: Move Databases Between Computers That Are Running SQL Server http://support.microsoft.com/?id=314546 240872 HOW TO: Resolve Permission Issues When You Move a Database Between http://support.microsoft.com/?id=240872 Vikram Jayaram Microsoft, SQL Server This posting is provided "AS IS" with no warranties, and confers no rights. Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
those don't have a User interface. 3.can i redistribute those databases 4.can i access those stored in another system in a network. 5.what if 2 or 3 application directly accessing that at the same time. hope i delivered my question properly.any help is appreciable GRKhi, SQLExpress is newer than MSDE, and MSDE will not be supported on Vista platform.. I'd 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
a pubs's table and access it's content you write but if your account had not been granted access to your server, you would not seen any SQL Server object, so I think the reason is VS related you could try re-registering the SQL Server instance in the server explorer and perhaps ask in the VS public newsgroups too sorryDear Andrea, Please tell me if I did this correctly. I downloaded MSDE. I downloaded the pubs and nwind databases. I used one of the MSDE utilities to register the database. Is the MSDE compatible with Visual Studio? I noticed that I could have downloaded a different version of SQL Server. Thanks.-Spencer [email protected]
downloads page. I one of the other pubs database them. Is this must have "full wizards database
with various projects, and have done so successfully using the SQL Server GUI tools, and from TO-SQL scripts. When I create the new database, Enterprise Manager and Query Analyzer allow my access to do whatever I want with the database. Not so in VS 2003 Server Explorer! the new database does show up in the list of databases under the MADE instance, but when I try to expand the new database node, up pops a dialog asking for a Username and Password, or offering me the choice of college classes and evaluate student projects, so try to keep it fairly simple? Thanks in advance for any insights.Arrrrgh!! Somehow all instances of "MSDE" in my post were changed to "MADE", could have sworn I clicked "Ignore" in the spell checker. Sorry!
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,