Is it possible to install SQL 2000 desktop without installing a database
server? I need to have the interface to access my database servers, but
don't want the overhead of a server and the service on my laptop.
Possible?
Thanks
Doug
My 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
venu 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"
I want to know if there is Desktop edition for SQL 2000 Server and if so does it comes bundled on the same CD like it did for MSS 7.0.Also is there a limit to the size of DB's that can be build with it.
Thanks a Bunch
Hi all:-
How do I upgrade my local sql server 7 to sql 2000 ? Do I just put in the sql server 2000 CD and run it or is there an upgrade CD ? I have lots of stuff on my sql 7 and don't want to lose it.
Thanks in advance!
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
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..
I have used the Upsizing Wizard in Access 2003 to convert a database to SQL. When I open it using SQL 2000 Desktop edition, I am finding a problem with the views and stored procedures.
When I open a query in design view, the tables are displayed in the upper pane without the details of the individual fields. All I get is a tick box next to *(All Columns)
If I create a new table, the same thing happens. If I create a new database, then make a table within it, any queries behave normally, with all the fields displayed.
I would be grateful for any ideas
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.
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.
My question is, is it possible to connect to an SQL database using the MSDE 2000 SP3a edition over the internet? And if so, how do I set it up? Thank you in advance.
View 1 Replies View RelatedTrying 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
Did a SQL Server Desktop Engine 2000 (MSDE) having SQL Agent module?
View 2 Replies View RelatedI 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?
There are special instructions for installing service packs on desktop edition installations -- command line options etc. How do you install hotfix roll-ups? Does build 2187 apply to desktop edition?
View 1 Replies View RelatedHello.
Has anyone attempted and successfully installed SQL Server 2000 SP4
via remote desktop on the cluster.
The reason I am asking is that SP4 readme file has this:
"...
4.3 Systems Management Server Distributed Installation
You cannot install Database Components SP4 from a remote location.
..."
Currently SQL Server has SP3a installed.
Thank you in advance.
How 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 RelatedHello Everyone,
I'm trying to connect to Desktop SQL Server 2000 from Windows mobile PC Emulator (VS 2005). I need a direct connection using connection string to SQL Server 2000 through local wireless network without IIS.
Bellow is the code that I use. After executing this code I get an error on line Conn.Open(). Error says SQL Server does not exist or access denied.
SQL is un and running, and I can log in using SA username from the desktop. Even if I chance IP for another SQL server in my connection string I still get the same error. There is no firewall of any kind running.
Dim connectionSTR As String = "Persist Security Info=False;Integrated Security=False;Server=192.168.0.202,1433;initial catalog=MyDB;user id=sa;password=;"
Dim Conn As SqlConnection
Conn = New SqlConnection(connectionSTR)
Conn.Open()
If Conn.State = ConnectionState.Open Then
MessageBox.Show("Open")
End If
About my environment: SQL Server 2000 is running on Desktop PC with Windows XP SP2. Application which I need to connect to SQL Server is in Visual Studio 2005. I execute the application in Windows Mobile PC Emulator and try to connect to SQL Server from emulator.
Your advice and help is very appreciated
Thank you
Ika
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 RelatedHello, i'm trying to make a c# web form in vs.net 2003 and a connection to a sql database.I'm using a sqlconnection control and a sqlcommand, but when i test it, the page said: "There was an error in login Encuesta, with the user LOCALHOST/ASPNET" (or something like that)i don't have the source code, and i am not in my pc, so, can somebody help me?
View 5 Replies View Relatedhello everybody,
I've installed SQL Compact Edition (with Visual Studio 2005) and i try to compile Northwindoledb for the DeskTop. The goal of this operation is to migrate a Pocket PC application (C++/OLE DB/SQL Mobile) to the desktop. If i can run properly Northwindoledb project i could start to migrate ...
I've the following error :
hr = pICmdText->Execute(NULL, IID_NULL, NULL, NULL, NULL);
GUID_NULL undefined
What can i do ?
Thanks in advance !
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 > cmdNavigate to the directory you expanded the self extracting exe to and change to the MSDE subdirectory.The default is C:sql2ksp3Type Setup SAPWD=(Some password) SecurityMode=SQLExample:c:sql2ksp3> Setup SAPWD=password SecurityMode=SQLAfter that gets done running, MSDE is installed.Start servicesTo get the SQL Server running and the SQL Agent we need start the services.right click My Computer > manage > servicesDouble click the following and set to Automatic.MSSQLSERVERSQLSERVERAGENTMake 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 View RelatedIf I just need a desktop version of SQL 7.0 installed for local development. (Not being used as a server) Do I just need a CAL license?
Thanks!
My organization supports both SQL 7 and SQL 2K. Therefore I have the Enterprise Manager
for SQL 2K on my desktop (it accesses both SQL 7 & SQL 2K, but the SQL 7 EM won't access
both).
I installed the SQL 7 desktop edition on my NT 4 (SP 6) workstation, but only the server (not
client connectivity or client tools).
When I attempt to perform a new server registration using EM (with the desktop server running),
I get the following message:
"SQL Server does not exist or access is denied"
I am attempting to logon as "sa" with a blank password since this will be my very first access of
the installed DB.
Startup of server specifies that the "local system" account be used. Server starts up fine as best
as I can tell.
For client connectivity I have both TCP and NAMED PIPES available.
Any help would be very much appreciated!!!!
Thanks Gary Andrews
andrews_gary_w@solarturbines.com
P.S.
Where blank passwords are used, do I enter a single space or not enter anything
and just press enter?
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.
I have installed Sql 7.0 desktop edition on Win 98 with IE5 and am having a problem starting the Sql server.
It auto registered the server under my machine name. It was returning a network connection error so I deleted it and tried to add one with the name (local). Enterprise Manager then returned an error saying one was already registered under that name.
Anyideas?
Thanks
JC
Hi All.
I have SQL2000 on my WinXP computer. Can I install SQL2005 on my desktop? If yes what version?
Thanks.
Hello,
View 21 Replies View RelatedI have read all posts in this forum, but the answers for the main questions are still not completely clear for me. My scenario is smilar than other described cases.
I would like to send a large amount of data to a Windows CE device which runs SQL Server Mobile Edition 2005. Replication is not possible, cause the desktop size of software sometimes uses Oracle or earlier versions of MSSQL Server (for e.g. MSSQL 7.0).
For syncrhonizing data we have two possibilities:
1. sending the data in some format (csv, xml, etc...) to the Windows CE device, parse this file and insert the data into a database, the speed of this is unacceptable, so if it is possible I wouldn't like to use this method
2. Create the SDF file on desktop side, it would be very fast, because it makes unnecessary the post processing on a slow Windows CE device. So please give me a short (YES / NO is completely enough) answer to this: is there any *LEGAL* way to create an SDF file for SQL Server Mobile Edition without buying VS2005 or MSSQL2005 licenses for the desktop computer?
Thx for any help in advance. If the question was answered clear earlier, sorry for wasting time. I think a lot of us struggling with this problem.
Hello,
Is it possible to create a .SDF file at the develop machine?I want to write an exe which creates a sdf.So, my customer will be able to create a sdf and import this sdf to the device.
Thanks.
Hi,
I want to jumpstart my learning of SQL Server so I downloaded the Express edition onto my desktop in the office and also onto my laptop. I usually connect the two machines (through a LAN) to update whatever I was able to do at home while in the office.
What should I do in order to view or edit whatever I started on the laptop from the desktop? Would the databases I create on one be accessible through the other machine for editing and the likes?
Glint.
I have a very simple application that is desktop and windows mobile. I am just starting work on it so the options are wide open for now. My goal is a simple database that will sync columns on both sides.
The SQL Compact Edition database seems like the perfect database to use for this application.
The only way I currently know of to sync a PDA database to the desktop, however, is to use IIS and SQL server on the desktop side and then use the ADO.NET sync stuff.
I don't want to have to set up IIS and SQL server on my client's computers. It will be a mass market product and that is just inviting a ton of support that I don't want to have to deal with. The application is too simple and cheap for that.
I know I can go the old fasion ActiveSync component route, but that is such a pain. I could also use a 3rd party solution, but again, too expensive for this application.
My question is whether anyone knows of a simple solution.
Is there any way in SQLCE to query a remote database and do updates to it? Could the desktop application get access to the PDA SQLCE database or the other way around?
Any help would be great. I have the experience to write an ActiveSync component myself. That is not the problem. It is just such a pain and it seems like in today's day and age I shouldn't have to.
Hello,
Everybody knows that Upgrade.exe is not a win32 application.
Since it is now possible to connect SQL CE 3.1 database with Framework 2.0 and SQL CE 3.1, I am wondering if someone is aware of a method to convert SQL CE 2.0 database to SQL CE 3.0 with Desktop Framework ?
(--> I have a lot of SQL CE 2.0 databases where I would like to connect avoiding use of a PDA. In order to do that, I need to convert all of them)
Thanks
Adrien