How To Create A Database On MS SQL Server Desktop Engine
Nov 30, 2005Dear friends,
View 3 Replies
ADVERTISEMENT
SQL Server 2000 Desktop Engine
Feb 28, 2003I have a few questions about the SQL Server Desktop Engine (MSDE), sorry there are so many ..
1. Which software products does this come with ?
2. If I create a SQL Server Database and want to distribute it to clients, how do I actually do it with MDSE ?
3. If I need to "upgrade" my database at some point in the future (that may contain data at a client site) how would I go about getting all the data out - would I need to write an external app ?
4. What are it's pros and cons when compared to installing full SQL Server on a client site ?
5. I've heard that the preformance of an MSDE Database degrades severely after more than 5 concurrent connections, is this just due to the performance of the product or is it something to do with the licencing model ?
6. Is it possible to write applications in, say VB, to alter the database once it has been installed on client site e.g. modify/create tables, indexes, stored procedures ?
Thanks for any help in advance ..
Scott..
MSDE SQL Server 2000 Desktop Engine
Jan 21, 2004Can someone advise me if this is basically SQL server 2000 and will work effectively to simulate sql server on a stand alone development machine ? Is this what its meant for?
I'm just not clear on this, here is the link:
http://www.microsoft.com/downloads/details.aspx?FamilyID=413744d1-a0bc-479f-bafa-e4b278eb9147&DisplayLang=en
Thanks in advance for any advice.
Microsoft SQL Server Desktop Engine Question
Jan 23, 2004Hello,
I'm trying to install Microsoft SQL Server Desktop Engine (MDSE) and it said that I require a SA Password. I can't figure out how to do this.
Can anybody help?
Thanks,
Shenra
Microsoft SQL Server 2000 Desktop Engine
Jan 29, 2004Trying to install Microsoft SQL Server 2000 Desktop Engine on my laptop. I downloaded the software and opened it to a folder on the C drive. Then from the command prompt I entered this:
C:msderela>setup sapwd = hillary instancename=mjh targetdir=c:mike
The program starts to install and seems to get near to the end of instal and then the progress bar starts going backwards and nothing gets installed....any ideas of what I'm doing wrong....I really don't know anything about this at all.
Thanks
Problem Install SQL Server Desktop Engine
Feb 27, 2004I'm in the process of attempting to install Microsoft SQL Server Desktop Engine on my computer in support of an email program call Mailloop6. I've tried going through their tech support but they haven't been able to figure it out.
I'm running Windows XP with SP1 upgrade on a DSL connection.
When I installed the program the first time, I got the following error:
"Setup failed to configure the server. Refer to the server error logs and
setup error logs for more information."
The program obviously wouldn't install. I contacted the vendor and they sent a version with a batch file. Same result. I removed all the appropriate registry entries between installs and removed all the data files as well.
I've tried installing the program using the free MDSE download from the MS site with the following result:
"A Strong SA password is required for security reasons. Please use SAPWD switch to supply the same. Refer to readme for more details. Setup will now exit."
Here's the error log that I got after attempting to install:
2004-02-25 19:31:42.55 server Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 1)
2004-02-25 19:31:42.55 server Copyright (C) 1988-2002 Microsoft Corporation.
2004-02-25 19:31:42.55 server All rights reserved.
2004-02-25 19:31:42.55 server Server Process ID is 3404.
2004-02-25 19:31:42.55 server Logging SQL Server messages in file 'C:Program FilesMicrosoft SQL ServerMSSQL$MAILLOOP6LOGERRORLOG'.
2004-02-25 19:31:42.56 server SQL Server is starting at priority class 'normal'(1 CPU detected).
2004-02-25 19:31:42.60 server SQL Server configured for thread mode processing.
2004-02-25 19:31:42.60 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2004-02-25 19:31:42.63 spid3 Warning ******************
2004-02-25 19:31:42.63 spid3 SQL Server started in single user mode. Updates allowed to system catalogs.
2004-02-25 19:31:42.63 spid3 Starting up database 'master'.
2004-02-25 19:31:42.91 server Using 'SSNETLIB.DLL' version '8.0.766'.
2004-02-25 19:31:42.94 spid5 Starting up database 'model'.
2004-02-25 19:31:43.24 server SQL server listening on 152.163.0.0: 4113.
2004-02-25 19:31:43.24 server SQL server listening on 172.16.1.33: 4113.
2004-02-25 19:31:43.24 server SQL server listening on 127.0.0.1: 4113.
2004-02-25 19:31:43.25 spid3 Server name is 'MONSTERMAILLOOP6'.
2004-02-25 19:31:43.25 spid3 Skipping startup of clean database id 5
2004-02-25 19:31:43.25 spid3 Skipping startup of clean database id 6
2004-02-25 19:31:43.25 spid3 Starting up database 'msdb'.
2004-02-25 19:31:43.56 spid5 Clearing tempdb database.
2004-02-25 19:31:44.13 spid5 Starting up database 'tempdb'.
2004-02-25 19:31:44.17 spid3 Recovery complete.
2004-02-25 19:31:44.17 spid3 SQL global counter collection task is created.
2004-02-25 19:31:44.19 spid3 Warning: override, autoexec procedures skipped.
2004-02-25 19:31:47.75 server SQL server listening on TCP, Shared Memory, Named Pipes.
2004-02-25 19:31:47.75 server SQL Server is ready for client connections
2004-02-25 19:31:57.97 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager.
Any thoughts on this would be very much appreciated!
Connect To Sql Server Desktop Engine Over Internet
Apr 11, 2004i have got to connect to sql server desktop engine over internet with the following connection string
conString = "Provider=SQLOLEDB.1;Persist Security Info=True;Initial Catalog=" & dbName & ";Network Address=" & IPAddress & ";Data Source=" & DataSource & " ;User ID=" & UserId & " ; Password=" & Password
Plz also inform me about the restriction imposed in connectivity by any of the window operating system such as that win 98 wont work or work!
There is no firewall involved. The two computers are in the same room and connected directly to the internet.
Even the ping is not going to either computer.
So what could be the possible problem and the solution.
need urgent
SQL Server 2000 Desktop Engine : SQL Agent
May 4, 2008Did a SQL Server Desktop Engine 2000 (MSDE) having SQL Agent module?
View 2 Replies View RelatedSQL Server 2005 Desktop Engine Distribution
Dec 31, 2007Hi,
what is the distribution fee for SQL Server 2005 Desktop Engine distribution? Where can I find this information? I don't need it for development only for distribution.
Thanks,
LearningWPFnDotNet
Sql Server 2000 Desktop Engine Installation
Jul 27, 2006I have SQL Server 2000 installed on my laptop and am trying to install an instance of MSDE. I keep getting the error message: "The installation of SQL Server 2000 Desktop Engine has failed. Please see the Getting Started manual for further instructions."
I have done this installation before on other machines. Something must be corrupt on my machine (?). The error message is not very enlightening. Any ideas?
Converting Desktop Engine To SQL Server 2005
Aug 3, 2006I have got SQL Server Desktop Engine running with 2 database and I need
to install the evaluation version of SQL Server 2005 instead. A
straight upgrade does not seem to be possible. Does someone know if
backing up the databases, uninstalling the desktop engine, installing
SQL Server 2005 and then importing/restoring the databases would be an
option to look into?
Problem Microsoft SQL Server Desktop Engine (MSDE)
Sep 25, 2007
Hi
i'm chanaka my problem is i had a wsus 2.0 version server, last week my server disk was full, finaly i was move the Wsus data to new disk.with all the contens. when i try to move the datbase it's give the error.
when i open the wsus admin console it's give the error message. and it's add the event log error also. this thing is giving to me big problems.
Connection to database failed. Reason=Unknown error.. Connection string: Data Source=EMAIL-FILTERWSUS;Initial Catalog=SUSDB;Connection Timeout=60;Application Name=WSUS SQL Connection;Trusted_Connection=Yes;Pooling='true'; Max Pool Size = 100
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
if u can give me help. . please if u can give me help.
Best Regards,
shadow
Aucsna
Installation Of Microsoft Sql Server Desktop Engine Hangs
May 16, 2008During installation of MSDE the installation hangs at "please wait while Windows configures microsoft sql server desktop engine" I always end up killing the installation process. I am trying to install Windows XPe dev kit and this is the step I am getting stuck on. If I try to skip this step and setup the database the setup obviously tells me that i dont have sql 200 or MSDE installed.
The KB article http://support.microsoft.com/kb/811479 describes the syptoms perfectly, but fast user switching isnt even enabled for this machine and is not the source of the problem.
SQL SERVER 2005 Desktop Engine Version Avaliable?
Nov 20, 2006
hi dear developers;
i just finished my program and i am making a setup for it but the db is MSSQL SERVER 2005. the home users how will they use sql server 2005? is there any thing like sql server 2000 desktop engine? something like that... shortly the user don't have to know sql server and settings of it so how will we do it???
thank you very much...
Create A Mobile Database On Desktop
Jan 21, 2006I have searched through this forum and the news group
microsoft.public.sqlserver.ce
for this topic. I only find a post from Darren Shaffer and I requested a document.
Unfortunately, there is not a clear example of how to create a mobile database (sdf) on a desktop machine which contains VS 2005 and SQL server 2005 by using Visual Basic 2005.
I am sure a clear example in VB for this problem would help a lot of people. Hence anybody who knows how to perform this task, Please help these people.
Thanks in advance
Talat
DB Engine :: Create Read-only Database From Production And Restore On Different Server
Jun 4, 2015We have a production 2012 R2 SQL server that is not part of a domain. I have a database called CSSDC. I need to backup this database and make the BAK file available to a user on a different SQL server. Security is a concern. In order for this user to restore the database, they will have to be in the fixed server role sysadmins. I know I am going to have to use the Move with replace for the filegroups for the restore. Once the database is restored it will have to be altered to read-only. I would also like to remove the existing security and only have this new user access the read-only database.
View 4 Replies View RelatedHow Do I Create A Database During Installation Of My C# Desktop Applicaton?
Nov 24, 2006Dear all,
I have developed a C# desktop application which uses SQL express as its database. It works just fine as I installed the application, used SQL express Server Management Studio CTP to create database with tables , stored procedures etc.
Now, I want to create an installer that will not only install my application to other machines but also create the database with all the tables and stored procedures with it.
How do I do so? I searched the answer in several places but none worked out for me. Can anyone please help me on this??
For your convenience I'm giving the following informations:
Database name: NorthPoleSQL sever Name: IshtiaqueSqlexpress (used Windows Authentication Mode)
I have detached the database from the original machine and have the NorthPole.mdf and NorthPole_Log.ldf files. I want to use these files and create the database in target machine rather than writing sql scrips and executing them.
Please help me with a descriptive, step by step instruction as I am new to this technology.
Thank you.
-Ishtiaque
How To Add Login User (ASPNET) To MS SQL 2000 Desktop Engine Server (MSDE2000)?
Sep 21, 2004How do I add login user ASPNET to my SQL 2000 Desktop Engine Server?. I can not find the "Server Manager" in the Start - Programs. Is there any other way to get around adding ASPNET login to the SQL server so I can test my VB program. I got the error: Login failed for user 'com_nameASPNET'.
View 1 Replies View RelatedMicrosoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A
Feb 17, 2004My objective is to use Enterprise Manager to move (copy) my SQL db from the server to my windows desktop computer.
I downloaded MSDE and am having trouble installing it, no doubt because I do not understand the documentaion (ReadMeMSDE2000A.htm).
When I try to run setup, I get that message that says:
"A strong SA password is required for security reasons. Please use SAPWD switch to supply the same."
Considering my purpose, do I need a "strong" SA password? If not, how do I get around it? If yes, how do I set it up?
I am a Mac user so I have poor windows skills, please make it as painless as possible for me, thanks!
Ron
Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release
Feb 16, 2006venu writes "Hi,
Am very new to MS SQL adminstration
Can anybody help me out how to work on Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A just for the practice.
The activity which am going to workout on MSDE is below.
How to install SQL(on XP)
How the layout will be(like if i insall MSDE what are all Application will be and how they depends on each other)
How to create/delete tables if so, how can we do it either by GUI or CUI
just i need a clarifications reg same
Thank you,
venu"
Desktop Engine And Concurrentlimit Registry Key
Feb 28, 2003I was looking at the registry key value "ConcurrentLimit" in
"HKEY_LOCAL_MACHINE'SOFTWAREMicrosoftMicrosoft SQL Server80MSSQLLicenseInfoMSSQL8.00"
and wondering if this the concurrency control of SQL Server. Can someone please verify??
One of our SQL Production Server I inherited was installed with this version by mistake. The value for this key was set to 2. Does this mean it only allows 2 concurrent access to the SQL Server??
Thanks...byyu :)
A Question Regarding MSDE Desktop Engine
Feb 19, 2005Dear all,
This week I was told to setup MSDE Desktop Engine on my pc bcz my Access back end db is getting bigger in size. And as a little advance step, I decided to put my Access back end on SQL server.
To be frank, I have no experience with SQL server but after reading the instructions, I have installed MSDE (latest version) on my pc successfully. A small icon of SQL server appeared nearby clock icon of my pc showing the SQL server is running on ASHFAQUEPC.
I shifted a Trial db onto this server in following way.
Considering the opened Trial db would be my BE, from the Tools---Database Utility---Upsize wizard, I followed below steps according to Upsize wizard.
1.I selected ‘Local’ server and check marked to ’Use Trusted Connection’.
2.And then I selected some tables to export
3.Kept all default attributes of db as it is
4.Selected ‘Let the wizard decide’ under data option to include.
5.At the next step ‘What application change do you want to make?
a.Create a new Access client/Server application.
b.Link SQL Server tables to existing application.
c.No application changes. (I selected this option)
Then it showed me the report of my db description of changes that were made after deploying it. The report I did not print bcz it was a trial db with one table (2 fields) and a simple query.
My idea was to connect my Trial BE with another one of another Access mdb file so FE would be Access and BE would be from MSDE.
1.Now I don’t know how to link my BE to my FE?
2.From where I can directly see my BE? Because SQL Server Service Manager does
not have any menu?
3.Where I was wrong in following steps?
Guidance in this regards is highly appreciated.
With kind regards,
Ashfaque
Install Sql 2005 On A Machine That Has Desktop Engine
Aug 18, 2007My coworker tried install SQL server 2005 on a server. The server already has a desktop engine running as "MSSQLServer". Because the new sql server 2005 need running as a default instance. So he still using "MSSQLServer" as the instance name.
After installation, the service's running file seems still point to the old location. When view the properties on Management studio, it still report as "desk top engine" and the version is 8.xx..xxxx.
My question is,
1. What has been done during the installation? Is current desktop engine was upgraded?
2. In current situation, what can we do to install the SQL server 2005 as a default instance. Is there way to rename the desktop engine to a named instance?
Thanks
Microsoft SqlServer Desktop Engine Connection Problem
Mar 15, 2004i installed the MSDE2000A on server and i tried to connect from client machine through vb Application using connection string. Server anad client are in LAN. but Some systems able to connect and some systems are unable to connect.
i am getting the error:
"SqlServer does not exist or access denied "
for non connected machines.
the server is listening from these machines. but not connecting to MSDE.
can anyone give me solution what may be the cause.
Connection Problem From Access Front End Application To SQL Desktop Engine Backend
Jul 23, 2005Hi there,I sincerely hope that someone out there can help. I have twoinstances of the SQL 2000 Desktop Engine running. One is on my localmachine for development and the other is on another machine on ournetwork which is the production environment. I have built an Access2003 front end application which connects to this database. Thisworks fine locally, as you would expect. I successfully installed thedatabase on the production machine and am able to connect to it viaAccess 2003 (using the Data Link Properties window) and from thirdparty database manager software (similar to Enterprise Manager). I amnot able to to connect to the database via my application.I am using the "sa" account with a strong password. This is myconnection string:strConnection = "Provider=sqloledb;DataSource=server02;UserId=sa;Password=strong;Initial Catalog=Test"The error I'm getting is:"Connection cannot be used to perform this operation. It is eitherclosed or invalid in this context."The connection string is the only thing that changes in my code when Iswitch from my local to my production database. Is there some reasonthat I can't use the "sa" account in this fashion that I'm not awareof? I'd rather not use integrated security for simplicity's sake asthis is a small, internal application. Also, I would have thoughtthat if that was the issue, I couldn't use "sa" at all, even locally.I'm going to post to the Access group as well but thought someone heremight have some advice to offer as well.Thanks,Barb
View 2 Replies View RelatedQuestion: Can I Synchronize The Mobile Device Which Has A SQL Server CE Database With The Access Database On The Desktop?
Sep 26, 2006Dear All,
i have a question abt winCE 4.2 and SQL server CE.
i am using VB.net of Visual Studio 2005
My platform is using a PDA with winCE 4.2 and SQL server CE. The Host program is using dbf files on desktop side.
I got a problem of how to sync / read the sql CE data from a windows application.
so, i wanna ask,
1. any method to access the data from winCE data by windows application? or can i convert the sdf file to windows readable files? or any others?
2. Can i use a MDB to sync with SQL server CE?
can i synchronize the mobile device which has a SQL Server CE database with the Access database on the desktop?
last question,
3. is that windows CE .net 4.2 not support pocket access (cdb) anymore?
please help me out
Installed Msde Database Server Desktop Edition And Well...
May 1, 2005its sql server 7.0 and im looking for the service network utility and service manager that it didnt come with.. where can i download it?
View 1 Replies View RelatedWhat Is Necessary To Create SDF-Files On Desktop Legally?
Nov 7, 2005I want to write a PC application that prepares a SQL Server Mobile Files (.SDF) and sends it to a PocketPC.
I get this error message:
DB Engine :: Server Restore Database
Jul 20, 2015I am using SQL Server Management Studio 12 to try to restore a backup to a new database. I know I have done this before, but cannot seem to make it happen now. Her is what I have.
Backup file is "C:TempInProcessInspection_DataSQL_backup_2015_02_23_000012_4551393.bak"Â and it is for sure there.Â
This came from a customer of mine.I launch SQL Server Management Studio 12 and log in as SA. I right click on Databases and chose Restore Database. I choose Device then file then Add and try to browse the the named location.Â
When I get there, regardless if I choose All files or Bak, I see no files.I tried to upload an image of the "Upload Backup File" dialog, but MSDN would let it happen. When I get to the c:temp folder, no files appear in the window.
Where's My Default Sql Server Database Engine?
Jul 11, 2007I am a novice in DB learning.
A few months ago, I installed the ms sql server 2005, and use it to learn the book SQL Server 2005 for dummies. It worked just fine. But after i finished the book, i uninstalled the program and deleted the express database engine. Perhaps it was an incomplete installation, yesterday when i tried to reinstall the sql server 2005, i found some configuration tools still in the directory. So i used windows to remove those tools. After that, i reinstall the sql server 2005, and changed some values in the register. The reinstallation goes well. But after it was done. I started the management studio, there's no default database engine for me to connect! All I could find in Internet is how to connect to a database engine without information about how to create one. Can anyone tell me why and help me out?
i am a novice.
What Are New In SQL Server 2008 Database Engine?
Jun 29, 2007Hi, all here,
Just heard about the coming release of SQL Server 2008. Anyone here got some ideas on what are significant new features in SQL Server 2008 Database Engine compared to SQL Server 2005 Database Engine? Would be very interesting to know that.
Thanks.
With best regards,
Yours sincerely,
SQL Server 2005 Cannot Connect To Database Engine...!
Sep 24, 2007Hello
I've just installed 'SQL server 2005' and it installed the components like .Net2.0 and visual studio 2005 . before installing them I had uninstalled sql server2000 . I ran SQL management studio and tried to connect and makin' servers it doesn't allow me to connect or making any new servers...... it gives me this error
Cannot connect to local.
Additional information:
An error has occured while establishing a connection to the server. ......
error:53)
need to solve it....
Critical Problem SQL Server 7.0 - Database Engine
Apr 28, 2001We are a National Level Institutional Stock Broker in India providing trading platform to our Brokers to trade on Exchange nation-wide. We are using Compaq Proliant 8500 Serires computers in clusterd mode having RAM of 1.5 GB on each machine. We are using the Computer-To-Computer-Link (CTCL) solution / application for routing orders of brokers to the Stock Exchange. This application uses the SQL server 7.0 in clustered mode as back-end database on Windows NT Ver 4.0. On daily basis around 20,000 transactions are processed in the database.
Following are the Database Details
----------------------------------
1. Dat Size : 1890 MB
2. Log Size : 838 MB
------------------
Total Size: 2728 MB
3. File growth options: Automated file growth, By percent : 10
4. Maximum File Size : Unrestricted file growth
On April 25, 2001, we found that application was not getting initialize, we (technical team) checked all the procedures, which are getting triggered at that particular time and found all of them were ok, but application did not started.
We also suspected that one of the procedure might have been corrupted, so we re-compiled all procedures which get triggered before starting the application. After havind done so, the application was still not getting initalized / started.
We also executed following commands:
1. DBCC CHECKDB to check inconsistancy, if any but found none (log is available)
2. DUMP TRAN with no_log (To clear transation logs)
We also executed procedures one after the other sequentially, which were being executed before the application starts after binding once again.
After having done this, we also suspected that the problem might have been with "SQL Server 7.0 database engine" and therefore decided to re-start the computers, after which we found that the applicatio started without any hindrance / errors.
This has raised some issues as follows:
1. Has the database corrupted ? If yes, weather it is possible to run DBCC CHECKDB, SQL queries on a corrupted database ?
2. Was there any systems environment failure ?
If so, is it possible to run DBCC CHECKDB, SQL queries on a corrupted
database?
3. Is there any possiblity of Database Engine failure?
What can be the consequeces on Database Engine failure ?
4. Is it possible that Database Engine Failure is the cause for our case ?
Our some of the engineers are of the opinion that the SQL server need to be shutdown and re-started periodically.
1. Will this in any way avoid such re-currance in the future?
2. If this is true, we would like to have your technical feedback as to why this is necessary?
Should you require any further clarification, I shall be glad to furnish it to you in this regard.
I request you to give your techical feed back on an urgent basis as our applications are CRITICAL and needs UTMOST CARE, hence needs consistancy of database.
I shall be glad to receive your feedback at
my e-mail: gchavan@iseindia.com or (+91)(022-781 2389).
Govind Chavan, Mumbai, INDIA