This is my first time using SQL. I installed MSDE 2000 on my desktop and after restarting my PC I see an icon in the startup area MSSQLServer with the server being my T-Tag #.
I am trying to upsize my Access DB to Sqlserver. I am still confused as to where does this server reside? How does this whole thing work?
Also, when I tried to upsize my db I got an overflow error.
Could someone please explain how does this work?
Thanks,
DH
Can you install Sql Server 2000 Developer Edition with MSDE 2000 release A already installed?
View 2 Replies View RelatedMy 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"
Parameter
Access 2000/XP
SQL Server 7.0
SQL Server 2000
MSDE 2000
Number of instances per server
n/a
n/a
16
16
Number of databases per instance / server
n/a
32,767
32,767
32,767
Number of objects per database
32,768
2,147,483,647
2,147,483,647
2,147,483,647
Number of users per database
n/a
16,379
16,379
16,379
Number of roles per database
n/a
16,367
16,367
16,367
Overall size of database (excluding logs)
2 GB
1,048,516 TB
1,048,516 TB
2 GB
Number of columns per table
255
1024
1024
1024
Number of rows per table
limited by storage
limited by storage
limited by storage
limited by storage
Number of bytes per row
(Excluding TEXT/MEMO/IMAGE/OLE)
2 KB
8 KB
8 KB
8 KB
Number of columns per query
255
4,096
4,096
4,096
Number of tables per query
32
256
256
256
Size of procedure / query
64 KB
250 MB
250 MB
250 MB
Number of input params per procedure / query
199
1,024
2,100
2,100
Size of SQL statement / batch
64 KB
64 KB
64 KB
64 KB
Depth of subquery nesting
50
32
32
32
Number of indexes per table
32
250 (1 clustered)
250 (1 clustered)
250 (1 clustered)
Number of columns per index
10
16
16
16
Number of characters per object name
64
128
128
128
Number of concurrent user connections
255
32,767
32,767
5
Will any application developed against SQL Server 2000 Developer
Edition work on an identical platform with only MSDE 2000 installed? I
understand there's a concurrency limit with MSDE 2000 of around 25 (and there's no GUI) but apart
from that, are there any aspects of SQL Server 2000 functionality (from the .NET applicaiton code's point of view) that
are "disabled" in MSDE 2000?
Trying to transfer databases from MSDE to SQL. When I use SQLEnterprise Manager - DTS - import or export, it works for the firstdatabase, but then fails for the others. I select the to and fromdatabases using DTS - Import - 'MS OLE DB Provider for SQL Server',then select 'Copy objects and data between SQL Servers'. It failswith the generic error message: 'Copy objects failed', nothingfurther. I tried to just copy data, and it doesn't work totally. Ontwo databases, it said that it copied everything, but when I go inunder Enterprise manager, some of the tables are incomplete, i.e. nodata, table shows up in the list, but if you try to look at it, itsays that it is missing or empty. Also, one table was not evencopied. In the other two cases, I get errors, does not copy alltables. I get errors, like insert fails, but the column it referencesfor the table does not even exist in that table. Any suggestionswould be appreciated.
View 2 Replies View Relatedi went through the documentation but i was not clear on following, here is the scenario :-
a Central server is having SQL Server 2000
3 Remote Locations :- Each having 4-5 no of computers, connected on a Lan, and on one of the machines MSDE 2000 will be running.
My Questions are :-
1. Can remote locations, update data locally and send changes (say in every one hour) to central server. If yes, then how ??
2. Same way they can receive updates from Central Server on whatever was updated on Centra Server or on the 3 remote locations. If yes, then How ??
any help will be highly appreciable.
I am creating an install program and I'm wondering if there is a
difference between SQL Server 2000 and MSDE 2000? Do they have
different entries in the Registry?
From the documentation that I've read it seems as if they are one and the same.
However, if someone knows how to differentiate between them in the Registry it would be greatly appreciated.
Thanks
I am about to setup an application server. This app will generate reports and instead of just having a HTML page up, I am considering running dotnetnuke type portal to offer the userbase a better interface for the reports, info, announcement, etc.
Server isn't too bad (2x1.7Ghz Xeon I think, 2GIG RAM) type of setup (may be little more or less). App doesn't require as much resources, but we are planning for the future )
While I have some resource to play with, I also need to make sure I don't load much that may impact the application performance. In my experience, SQL Server 2000 will take a lot of resources even when not used as much. So I am considering MSDE.
I am curious however, WHAT ARE THE MAIN DIFFERENCES BETWEEN SQL 2000 Server Vs MSDE 2000 ?
Beside no Client tool and mostly command line specific command, what else there to convince that I should go for server vs desktop engine?
Now our company has Enterprise license for SQL, so I am not worried about the cost (well a little maybe), but mostly wondering about performance.
If you think of any reason why I go to SQL Server 2000 over MSDE, please let me. Otherwise, I think MSDE in this case is the appropriate RDBMS to go for.
Regards,
Impu
Hi,
How does one install MSSQL 2000 on a machine that's already running MSDE 2000? Do i need to unintstall MSDE, or both can be installed seperately??
Is there a way to simply upgrade MSDE into MSSQL 2000?
Thanks!
Hi There,
I have install msde in one computer and try to register from my sql server, the following error message is coming.
A connection could not be established to Cal-itimilsina (computer in which MSDE IS INSTALLED)
RESON: SQL SERVER DOES NOT EXIST OR ACCESS DENIED
CONNECTIONOPEN(CONNECT())
====
BUT THE MSDE IS RUNNING IN THE CLIENT MACHINE. Could any one please help me
Thanks.
Indra.
Hello all, im new here and do not have no experience with sql. I am trying to install a tax software that I need to run my little business. When I install it gets to a popint that it asks me for my SQL server usernme and password. I remember doing this last year and I reinstalled MSDE and set up a username and password. I seem to not remember what I used, i tried all that I would have but can not get past that step.
I remember adding some lines in the setup,ini file when I installed it last year. Now I can go ahead and reinstall it again and set up a new one, but will the uninstalling and reinstalling of MSDE affect my previous software from last year? Its the same software but I need this years installed.
I have tried using sa as the username and a blank password, with a password and others that I have read up on, still cant log on. Keep getting worng credential screen.
Is there a way to get that info, i doubt it or else it would not be secure, or can I just simply reinstall MSDE?
Many thanks!!
Did anybody tried to use this as a database server? Is there an administration interface somewhere which is free?
Dennis
I'm trying to install this application but i get an errorSetup failed to configure the server. Refer to the server error logs and setup error logs for more information.I'm running Windows XP SP2.Could my SP2 be causing me problems considering I successfully installed it previously.Many thanks
View 1 Replies View RelatedI am not sure if this is the right forum, I already had some one freakout on me in another forum about posting in the wrong place.
Anyway:
I would like to upgrade a machine from SQL 7 to MSDE 2000. I would like to keep the existing database from Altiris Deployment solutions intact. Is this upgrade possible?
Any help would be appreciated
Hi folks!
Ive got here a Windows 2000 Professional PC and want to install the MSDE 2000 (incl. SP3) Desktop Server.
But when i execute the setup.exe the following Error Message will return:
http://www.dorst.de/sql.jpg
Here is the setup.ini
[Options]
TARGETDIR="C:ProgrammeMSDE2000"
DATADIR="C:ProgrammeMSDE2000Daten"
SAPWD="*****"
SECURITYMODE=SQL
DISABLENETWORKPROTOCOLS=0
Can anyone help?
THX !!!!!
Bye
CdR
I have a client that has a server running Windows 2000 Server. anothercompany has installed MSDE (version unknown) on this server. I need toinstall SQL 2000 on the same server. Will the two coexist peacefully?TiaCruznOz*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View 1 Replies View RelatedHi,
I only have Framework installed on my machine, and I also installed MSDE 2000 Rel. A, using the following command:
C:MSDERelAsetup.exe SAPWD="myPass" INSTANCENAME="myXP"
I can see that the service for this app is running. Though, I could not connect to it using oSql command like the following:
osql -S(local)myXP -E
or
osql -S(local)myXP -Usa, and supply the password "myPass".
The message was:
[DBMSLPCN]SQL Server does not exist or access denied.
[DBMSLPCN]ConnectionOpen (Connect()).
Any response would be appreciated.
Subi_I
Hello to everyone.
I'm looking for an help :(
I'ved installed MSDE on a Windows 2000 Pro with this option in Setup.ini :
INSTANCENAME=msde
SECURITYMODE=SQL
SAPWD=<mypassword>
All goes good, and at the end of install process, i restart pc.
When restarting, i logged in , and the icon of MSDE was in the System Tray.
Strange thing, is that the circle in the icon have no red square or green arrow inside, but is empty.
I open the window of MSDE and at Server and Service, was 2 empty fields.
I filled on SERVER with the IP address of my pc
Service Field, continue to be blank :(
When i try to start the MSDE, it tells to me that there's no selected service, so the MSDE can't start.
Have someone some ideas on how to solve this?
Thanks to everyone for help!
I installed MSDE2000 and i have problem:
In SQL Server Service manager i do not see connection but in MS Visual Studio .NET i see the connection and i can make tables my setup string was:
C:MSDERelAsetup SAPWD="Vedran" instancename="VT"
Please Help.
Thanks
Hi,
I have a customer with Office 2000 and uses Access 2000. I normally use SQL/7, but for this job would it be save to use MSDE on the web site so the customer can upload and download the MSDE file for product information? I use SQL/7 for the backend. Please advise.
Duane
Can you install the SQL client tools on a box running msde and register the msde database under enterprise manager?
Thanks
Hi all,I just got SQL Server 2000, but I already have MSDE installed. Is there anyreason I would want to keep MSDE around on my computer if I install SQLServer 2000? I use MS Visual Studio 2002 on Windows XP SP2, in case itmakes any difference. I intend to deinstall MSDE before installing SQLServer 2000, but I get the impression from a few posts that some people haveboth installed and I'm not sure why that would be done. What functionalityis in MSDE that is not in SQL Server 2000?Thanks for answering.--Diana
View 1 Replies View RelatedHiWe have just migrated to SQL 2005 database.We backup up our SQL database to disk, then backup files to tape usingBckupExec 10.1.The only snag is that BackupExec uses MSDE2000 to manage jobs etc soit will want to install a MSDE2000 on the server that has SQL 2005 onit !!Backupexec Support tell me that it will be fine to have two version ofSQL install on the server, is that the case?Naturally, I am concerned about DLL conflicts and breaking my SQL 2005serverCan any one shed any light on this?ThanksRC
View 1 Replies View RelatedI was wondering if any of you guys can kindly help me in finding allthe different versions of MSDE 2000 that came out since it's firstrelease. I expected to find something similar like Sun's archive(http://java.sun.com/products/archive/index.html) for MSDE 2000 toobut failed to find after a few hours of browsing at the MicrosoftDownload Center (http://www.microsoft.com/downloads/...displaylang=en).They seem more into promoting their new MSDE 2000 Release A for thetime being but nothing much about the previous versions of MSDE toserve my product testing purposes.All I need is a complete list of different versions of MSDE 2000 withdownloadable links.Thanks in advance.IzzY
View 1 Replies View RelatedHi everyone,In using the SQL Server Database Wizard in Access 2000 to create a newaccess project, I get two consecutive error messages and then the wizardshuts down. The first, which apprears immediately after starting the wizardis a message box stating something like "the property value is too large".After clicking through and filling out the values in the connection anddatabase dialog, I get a second dialog box with the message "Overflow" andthe wizard terminates.My operating system is Windows 2000 Professional with Access 2000 and MSDE2000.Does anyone have any thoughts about what might be causing these errors?Thanks in advance.
View 3 Replies View RelatedI try applying the SP 4 on the default instance of the msde 2000 and when it stops after a minute generates the log and says it was successful but no upgrade is done. I use the following command setup /upgradesp sqlrun SECURITYMODE=SQL BLANKSAPWD=1 DISABLENETWORKPROTOCOLS=0 /L*v C:MSDELog.log
On the same machine I has installed also SQLExpress.
I stop the sql services before issuing the command.
Any Ideas?
Hi!
Here's the scenario:
I have a MSDE 2000 installation running, already patched to SP3. Instancename is "STO". I've downloaded SQL2000.MSDE-KB884525-SP4-X86-ENU.exe and extracted the archive to C:SQL2KSP4.
After starting setup from the command prompt with "setup /upgradesp sqlrun DISABLENETWORKPROTOCOLS=0 /L*V C:MSDELog.log" i get a message box, telling me "The product is not installed". This happens even if I specify the exact instancename and supply the sa user and pwd!
Any ideas?`
Thanks in advance and regards
Clemens
Im trying to import tables, stored procedures and data form another sql
2000 instance on my network to my local. After i go
through the steps, it ends up creating hte tables, but none
of the data is pulled over
I have detached my database from the server and copied the mdf and ldf files to the new PC do I need to do anything but attach it to the MSDE? What about logins, roles, etc... does all this remain the same or do I need to delete the old and reenter them?
Please provide any help, thank you.
Hello,
I have a client that is moving their web ap (which has already been developed) from one host to their own servers. The problem is that they don't have MS SQL Server 2000, but they have MSDE. All the code is already writen to work with SQL SERVER 2000.
I have a couple of questions:
1. Can I safely assume that all this code will work with MSDE and all I have to change is the connection string? For example:
SqlConnection myConn = new SqlConnection(connstring);
In other words, can I still use the SqlClient classes to work with MSDE, or will I have to modify the code?
2. Will it be a problem creating the tables and migrating the data from SQL SERVER to MSDE? Can I use Enterprise Manager to do this?
3. I never had to remotely (or even locally) connect to a MSDE database alone, I always develop with a SQL Server db. Can I use a similar connection string for the MSDE database? Do I have to create a data provider on the local machine? Can you give me an example of a MSDE connection string?
Here is the scoop:
I have MSDE installed on a production machine together with a bunch of ASP.NET applications. I was asked to replace MSDE with SQL Server 2000 and move every application from MSDE to SQL Server 2000 with minimum downtime.
Did any of you go through a similar process?
What is the best way of doing this conversion?
How to move the backups from MSDE to SQL Server?
Is it possible to have MSDE and SQL Server 2000 coexists for a time while moving stuff around and redirecting every connection?
Any hints or suggestions would be greatly appreciated.
Thanks.