Is it necessary to have a MS Loopback Adaptor to install SQL Server desptop edition at my home ? ( Otherwise i am unable to connect to the server from the EM ) Thanks, Deepak.
my application has a good amount of data that is specific to each company (where there is only one user). i am currently setting it up as a access project, but was wondering about another route. to store the local data would there be an advantage to setting it up as a access project, and use the sql server desktop engine for the data, or should i stick with mdb tables?
Does a desktop version SQL Server exist with Enterprise Manager and Query Analyzer? I'm a developer who uses SQL Server, Enterprise Manager and Query Analyzer at work to write scripts and batches. I would like to enhance my SQL Server skills at home on my desktop computer.
I am developing a windows application that needs to communicate with a remote SQL server 2005 database. Server allows remote connections and MSDTC service also running. Do I need to run MSDTC service on the client machine where I use desktop application ? any ideas ? It's throwing some error like An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.
But my SQL Server allows remote connection, and I am able to do a select statement. But when I insert/update anything, it's throwing this error. I guess some problem with MSDCT. Anybody have any idea ?
I€™ve developed a BI system using the SQL Server 2005 Developer€™s Edition.
SSAS, SSIS and SSRS have been added to a SQL Server 2005 Standard Edition Server in preparation for delivering the developed database to this live environment.
So I am able to connect directly to the Database Engine, SSAS, SSIS and SSRS successfully from the actual SQL Server 2005 Standard Edition box which is sat on a Windows 2003 Server operating system.
However when I launch SQL Server Management Studio from a desk top PC which is connected to the SQL Server Standard Edition box I can€™t connect to either SSIS or SSRS, however I can connect to the Database Engine and it also seems that I can connect to SSAS OK.
I am using Windows Authentication where the I used a SQL Server account which exists with €śsysadmin€? permissions and this SQL Server account has the same login name as the Windows Server 2003 desktop login.
I have a new computer p4 2.8 i just install in it the Microsoft Visual Studio .NET, when i try to install the sql server desktop from: "C:Program FilesMicrosoft Visual Studio .NETSetupMSDE" in the middle it stops installing, I tryed to uninstall Visual Studio and install it again , but i get the same problem what can i do?
I am trying to use msde for the startup kits. but i cannot connect to it. How can I do a simple test to verify it is installed and that I can log into the db?
hI I M VERY MUCH NEWTO ASP.NET +SQL SERVER U CAN SAY I JUST INSTALL BOTH WHEN I I FIRST INSTALL QUICKSTART TUTORIAL OF MS.NET2003 IT ASK ME TO COPY MY DATABASE file to sqlserverosql -E -S (local)NetSDK -i InstPubs.sqlosql -E -S (local)NetSDK -i InstNwnd.sqlosql -E -S (local)NetSDK -i Portal.sqlosql -E -S (local)NetSDK -i Grocer.sqlwhen i tries to do that it give me the following errors [DBMSLPCN]SQL Server does not exist or access denied.[DBMSLPCN]ConnectionOpen (Connect()). well my sql server name is www same as my computer name (www)services is sql servermy computer is running xp sp2and i m running .net1.1also please tell me how to Granting Access to the ASPNET usermy asp.net user name is ASP.NETif i have to reinstall sql server 2000 tell me what step i should follow to configure it correctlyi m waiting for ur QURU's answers hopefully soonhave a nice dayHUssain
As we known, we can build up the data in not only in Server version but also in Sesktop version. So, what's the difference? Except the power that Server can provide compared to the desktop computer. Whatelse?
I recently installed SQL Server 7.0 on my desktop workstation. I has been working great until yesterday when services wouldn't start. The Service Manager gave me a message "An error 1069 - (The service did not start due to a logon failure.) occurred while performing this service operation on the MSSQLServer service." It appears to be a permission problem, but my profile hasn't changed, I have admin rights on my workstation. Can anybody help?
I recently installed SQL Server 7.0 on my desktop workstation. I has been working great until yesterday when services wouldn't start. The Service Manager gave me a message "An error 1069 - (The service did not start due to a logon failure.) occurred while performing this service operation on the MSSQLServer service." It appears to be a permission problem, but my profile hasn't changed, I have admin rights on my workstation. Can anybody help?
I recently installed SQL Server 7.0 on my desktop workstation. I has been working great until yesterday when services wouldn't start. The Service Manager gave me a message "An error 1069 - (The service did not start due to a logon failure.) occurred while performing this service operation on the MSSQLServer service." It appears to be a permission problem, but my profile hasn't changed, I have admin rights on my workstation. Can anybody help?
I 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 ?
I'm trying to figure out how to determine why the same database is fast on my desktop but slow on a robust multiprocessor win2003 server.
I have a complex proc that takes about 27 seconds on my desktop sql server but takes almost 5 minutes on the server. The server processors are running at about 1% utilization while the proc is running.
Any ideas on how to troubleshoot this extremely poor performance?
Has anyone had trouble accessing SQL 2000 desktop install over the LAN on SBS 2003? I cannot access my installation from the same domain, yet when I install it on a machine running something other than SBS 2003 there are no problems. Everything seems shared correctly, and I have tried loggin on to the remote machine as Administrator with no success. Any suggestions would be appreciated.
Hi Everyone,Apparently, I was being asked on a question, "Why don't we procure adesktop PC to run MS SQL Server 2000 rather than a buying a server?".From a Management point-of-view, buying a desktop PC is much cheaperthan a server. However, I just wanted to understand that is it aviable solution given the database size is something around 200 GB?Equipping with more memory, more storage and a more powerful CPU on adesktop PC could really taking up the role to support the DBMS?Besides this "sensitive" costing concerns, what will be othersdifference in running the SQL Server 2000 on the two differenthardware architecture? For example, IO rate, reliability, RAID-1support, performance, … etc.(Note: The operating system is Microsoft Windows 2000 EnterpriseEdition)Regards,Ambrose
Can 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?
Hello, 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
Trying 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:
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.
I'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!
Is it ok to use SQL Server 2005 CE as an embedded DBMS inside a desktop (Windows XP / w2k3 / Vista) application?
The whitepaper available here: http://download.microsoft.com/download/A/4/7/A47B7B0E-976D-4F49-B15D-F02ADE638EBE/Compact_Express_Comparison.doc describes this as one of the primary usages of the product. However, I've seen information elsewhere on this forum that seems to imply that SQL Server 2005 CE is not allowed in desktop applications.
Can you please clarify this, and specify any limitations of this usage?
Also, the whitepaper refers to an online redistribution agreement that needs to be signed in order to freely redistribute SQL Server 2005 CE inside a commercial application. Can you please point to this agreement?
Hi, 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.
I 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?
I 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?
Hi,I'm trying to install MSDE Desktop SP3a SQL server on my Windows 2000 Professional Laptop.Every time I try it nearly finishes the installation and then just rollsback.Can anyone help? Is this a known issue?Thanks in advance,Jocky
What sort of things would it interact with to justify having this ticked as the sqlserver.exe seems to be consuming all the CPU constantly and some suggestions have said that having this ticked can cause a performance issue.
