Desktop Server

Feb 24, 2007

1. Today I've installed webmatrix and MSDE200A and followed this instruction
"Select 'SQL2kdesksp3.exe' and save it to your computer.

Double-click on the SQL2kdesksp3.exe you downloaded.

Once you have run the self extracting exe (SQL2kdesksp3.exe), go to a command prompt.

Start > Run > cmd

Navigate to the directory you expanded the self extracting exe to and change to the MSDE subdirectory.

The default is C:sql2ksp3

Type Setup SAPWD=(Some password) SecurityMode=SQL

Example:
c:sql2ksp3> Setup SAPWD=password SecurityMode=SQL

After that gets done running, MSDE is installed.

Start services

To get the SQL Server running and the SQL Agent we need start the services.

right click My Computer > manage > services

Double click the following and set to Automatic.

MSSQLSERVER
SQLSERVERAGENT

Make sure both are on automatic." 
then I restarted my comp. I've tried to connect to database but it did not work.
I need the reply ASAP!!!! 
 
 2.What are the different among  MSDE200A.exe, sql2ksp3.exe, and sql2kdesksp3.exe ?

View 1 Replies


ADVERTISEMENT

Desktop SQL Server 7

Dec 7, 1999

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.

View 1 Replies View Related

Sql Server Desktop Edition

Dec 19, 2003

hi, can I use sql server desktop edition to deploy my web application and at the same time I am not violating license agreement with Ms.

thanks
Al

View 1 Replies View Related

Sql Server Desktop Edition

Feb 2, 2005

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?

View 2 Replies View Related

SQL Server Desktop Version?

Jul 16, 2006

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.

View 5 Replies View Related

MSDTC - Remote Accessing SQL Server 2005 From A Desktop Application - Windows 2003 Server

Dec 6, 2007

Hi,

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 ?

View 1 Replies View Related

Unable To Connect To SSIS Or SSRS On SQL Server 2005 Standard Edition Server Via Desktop Connection

Mar 8, 2008

Hi,

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.

What do I do next please?

View 4 Replies View Related

Problem With Installing Sql Server Desktop

Jun 25, 2004

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?

View 1 Replies View Related

Verifying Ms Sql Server Desktop Installation

Feb 20, 2005

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?

Thanks
Ron

View 1 Replies View Related

Problems Sql Server 2000 Desktop

Oct 12, 2005

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

View 5 Replies View Related

What's Difference Between Desktop And Server Version

Oct 19, 1999

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?

Thanks! Guru!

View 1 Replies View Related

Service Won't Start On SQL Server 7.0 Desktop

Apr 7, 1999

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?

View 1 Replies View Related

Service Won't Start On SQL Server 7.0 Desktop

Apr 7, 1999

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?

View 1 Replies View Related

Service Won't Start On SQL Server 7.0 Desktop

Apr 8, 1999

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?

View 1 Replies View Related

SQL Server 2000 Desktop Engine

Feb 28, 2003

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 ?

Thanks for any help in advance ..

Scott..

View 2 Replies View Related

DB Slow On Server But Fast On Desktop

Apr 2, 2008

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?

View 8 Replies View Related

SQL Server 2000 Desktop SBS 2003

Apr 28, 2004

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.

View 1 Replies View Related

Difference Between Running MS SQL Server 2000 On A Desktop PC And A Server

Jul 20, 2005

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

View 1 Replies View Related

Can I Use SQL_Mobile As PC Desktop Server Or PC Local Cache Server?

Jun 14, 2006

Can I use SQL_Mobile as PC desktop server or PC local cache server?

I want many data to be cached at user's PC,
and call for this data to be created transparently as for remote
main SQL server.

Is it possible to do without creating complex structure of doubling functionality
of main queries to single SQL server ?

some articles, samples, links, keywords ?

thanks you

View 1 Replies View Related

MSDE SQL Server 2000 Desktop Engine

Jan 21, 2004

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?

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.

View 2 Replies View Related

Microsoft SQL Server Desktop Engine Question

Jan 23, 2004

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

View 1 Replies View Related

Microsoft SQL Server 2000 Desktop Engine

Jan 29, 2004

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:

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

View 14 Replies View Related

Problem Install SQL Server Desktop Engine

Feb 27, 2004

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!

View 2 Replies View Related

Connect To Sql Server Desktop Engine Over Internet

Apr 11, 2004

i 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

View 1 Replies View Related

SQL Server 2000 Desktop Engine : SQL Agent

May 4, 2008

Did a SQL Server Desktop Engine 2000 (MSDE) having SQL Agent module?

View 2 Replies View Related

Using SQL Server 2005 CE Embedded In Desktop Applications

Jan 3, 2007

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?

Thanks,

IonWarp

View 7 Replies View Related

SQL Server 2005 Desktop Engine Distribution

Dec 31, 2007

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.

Thanks,
LearningWPFnDotNet

View 7 Replies View Related

Sql Server 2000 Desktop Engine Installation

Jul 27, 2006

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?

View 6 Replies View Related

Converting Desktop Engine To SQL Server 2005

Aug 3, 2006

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?

View 1 Replies View Related

How To Create A Database On MS SQL Server Desktop Engine

Nov 30, 2005

Dear friends,

View 3 Replies View Related

Installed Msde Database Server Desktop Edition And Well...

May 1, 2005

its 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 Related

Problems Installing MSDE Desktop SP3a SQL Server

Jul 29, 2005

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

View 3 Replies View Related

SQL 2012 :: Server Agent - Allow Service To Interact With Desktop

Mar 9, 2015

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.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved