SQL 2005 && MSDE 2000
Nov 6, 2006
Hi
We have just migrated to SQL 2005 database.
We backup up our SQL database to disk, then backup files to tape using
BckupExec 10.1.
The only snag is that BackupExec uses MSDE2000 to manage jobs etc so
it will want to install a MSDE2000 on the server that has SQL 2005 on
it !!
Backupexec Support tell me that it will be fine to have two version of
SQL install on the server, is that the case?
Naturally, I am concerned about DLL conflicts and breaking my SQL 2005
server
Can any one shed any light on this?
Thanks
RC
View 1 Replies
ADVERTISEMENT
Feb 21, 2006
I have just started to create a new web project using the new VS 2005, but just discovered that my ISP has not yet converted to SQL Server 2005 and uses 2000 MSDE.
My first question is, assuming I don't use any new SQL Server 2005 features will there be any problems in using SQL 2000? Can I create/ reports and use the reporting services, or will I have to make 2 versions of my application?
2nd question is: I have to use their database name and userid. To me, this means changing every form that connects to SQL Server from my local information. Is there a way to make this dynamic so that I can change the DB name, userid, pw, etc. without creating 2 or more versions of this Web application?
Thank you for any help.
View 3 Replies
View Related
Apr 3, 2007
Hi,
I have 2 MSDE 2000 Instances installed on Windows 2003 Server STd w/ SP1.
The application relating to the default instance is being upgraded and will require SQL 2005 Express.
What is the best approach? So the named instance of MSDE 2000 still functions correctly.
Upgrade default instance of MSDE to SQL 2005, or install SQL 2005 Express to own path and restore the DB accross? Then remove the Default Instance of MSDE 2000.
Both MSDE 2000 Instances are listed in Add/Remove Programs.
Thanks
View 1 Replies
View Related
Apr 10, 2007
Does anyone know of a resource that describes the steps to upgrade an instance of MSDE(2000) to SQL 2005 Standard?
We found something on a MS site that indirectly indicated you could upgrade the MSDE to SQL Express and then upgrade Express to the full version of 2005, but that method created quite a bit of problems(System databases), which we were not able to resolve short of uninstalling MSDE and the apps and installing SQL 2005 and re-installing the apps; but I have to believe there is a better way.
Thanks! Bob McEuen
View 4 Replies
View Related
Jul 26, 2007
Hi I would like to ask If its possible to have installed MSDE 2000 and SQL 2005 Express on the same machine. My computer uses MSDE 2000 for one application and I would like to install SQL 2005 Express for my own application. I would like to ask it will be a problem before I install it.
thanks a lot
Martin Molnar
View 1 Replies
View Related
Feb 16, 2007
Hey, This is my first time posting here but here goes nothing...
Ok I upgraded an xp machine running to sql express 2005 by doing the inplace upgrade. The upgrade process went great, after the upgrade I could connect to the databases that had been upgraded using the management studio.
BUT.
When I try to connect to the databases using the third party software which had always worked in the past I get the error when trying to access from both the client and server machines.
[DBNETLIB][Connection open()).]SQL Server does not exist or access denied.
I then tried setting up SQL express 2005 on another xp station just to test how things worked if it wasn't an upgrade. I installed, attached the databases (which I copied to that local machine) and I was able to connect to them through the third party software from the server machine, but not client machines. The client machines gave me the same error as above.
Does anyone have any ideas, I have been talking to the third party support but haven't gotten any where yet... does anyone have any suggestions?
Thanks,
View 4 Replies
View Related
Aug 1, 2007
I need to move the SQL Server 2000 Desktop Engine (MSDE) database and all jobs to the SQL Server 2005 Enterprise Edition.
- May I detach and attach the DB in my case?
- Where is the procedure to move the jobs from MSDE to SQL Server
2005?
View 1 Replies
View Related
Nov 8, 2007
Hi All,
I was trying to restore MSDE 2000 database to SQL 20005 EE and I got stuck with the following error:
System.Data.SqlClient.SqlError: RESTORE detected an error on page (xxxx:xxxxxx) in database 'testdb' as read from the backup set.
Do you think some pages are corrupt from the db or the backup set?
Has anybody come across this? Any ideas to resolve this error?
Thanks,
Siva.
View 4 Replies
View Related
Jun 14, 2006
Can anybody help?
I have a Windows XP and 2003 server; we have installed SQL 2005 Express on it but have an application that installs MSDE 2000 to connect to an application. After the MSDE 2000 is installed we can no longer see the instance across the network. If we uninstall the SQL 2005 express version we can see the Instance in MSDE 2000.
Is there any compatibility issue with install MSDE 2000 after SQL 2005 has been installed.
Many Thanks in advance
David
View 1 Replies
View Related
Dec 2, 2006
Hi,
I got on my developer computer one instance of msde 2000. I want to test sql server express 2005, can I install it without "scrap" my other instance of 2000?
Strange question maybee, but it's what I wanna do!
Thanks all!
View 3 Replies
View Related
Apr 4, 2007
I am having issues trying to do an in place upgrade of msde 2000 to sql express 2005. When I try to upgrade it bombs when it reaches "Running action to shutdown instance(Run As Normal User)" with the following error:
Service 'computername' could not be stopped. Verify that you have sufficient privileges to stop system services. The error code is (16386).
I've tried an upgrade on a clean test machine, and it goes through without any problems. I am logged into an account with local admin permissions. If any one has any ideas, they would be appreciated.
View 1 Replies
View Related
Apr 15, 2005
Hello guys! I have to develop a new web based project. It's a web
portal for events. At the moment it's runnung on an Access database.
The new version should be running on a SQL server - the desicion is:
MSDE 2000 or SQL Server 2005 Express (Beta). What do you recommend? The
webpages are developed under .NET 1.1.
View 3 Replies
View Related
Feb 19, 2008
Hi, I'm wondering if I can use SQL 2005 Reporting Services with SQL Server 2000, SQL Express or MSDE, or I need to install SQL Server 2005 in order to use Reporting Services 2005? Thank you in advance.
Regards,
Miguel
View 1 Replies
View Related
Jun 28, 2006
I'm trying to upgrade the Default Instance of MSDE 2000 Release A which is installed with Mixed Mode and strong password to SQL Server 2005 Express in a Windows 2000 Server with SP4. On the Upgrade Logon Information screen, if I select SQL Server Authentication Mode, it will give me this message:
SQL Server Setup Cannot Upgrade the specified instance by using SQL Server Credential. You must use Windows Authentication credential for the upgrade.
Thanks for any help.
View 1 Replies
View Related
Aug 1, 2006
I have clients that have the MSDE version installed and we need to upgrade there program to the MSSQL 2005. Is there an easy way to convert the data? Should or Could I uninstall MSDE and than install MSSQL2005 WorkGrp? Will there data be affected? Any tips would be appreciated.Thanks!
View 1 Replies
View Related
Sep 18, 2007
Apparently you cannot go backwards. Once 2005 Express is installed, even removing it does not allow you to setup MSDE 2000 again. So there is no "trying it out" option.
Unfortunately, our software does not use 2005 Express. I tried it out, and now have a useless testing workstation that can't have MSDE 2000 installed again.
Any ideas on how to break the chain here are welcome.
View 1 Replies
View Related
Dec 29, 2006
Hi,
Recently we have migrated our application from MSDE 2000 to SQL Server Express 2005(SP 1). This has significantly reduced the performance of our Windows.NET application which is developed using C#.
For example : While logging in to the application two databases are being attached.
Time taken in MSDE: 16 secs
Time taken in SQL Server Express 2005 : 58 secs
Also note performance is degraded for normal screens where data is retrived from database using inline queries.
Questions:
1) Is there any special(optimum) configuration(installation parameters) while installing the SQL Server Express 2005 setup?
2) Is there any query optimization to be done w.r.t SQL Server Express 2005 ?
We highly appreciate any help towards resolving the above problem.
Regards,
Sasi
View 8 Replies
View Related
Jul 3, 2006
According to this http://msdn2.microsoft.com/en-us/library/ms143393(d=robot).aspx, it seems that it cannot. But is this a complete chart?
Thanks for any help,
Peter
View 5 Replies
View Related
Jan 23, 2007
i am working on upgrading the clients and server computers from 2000 MSDE to 2005 SQL Express Adv. Plan to upgrade using the template.ini.
i can find the version of sql server running on th server by @@version but how do i find the version of client connctivity components the computer has installed in order to ugrade?
1. somehow i need to know whether to upgrade a client computer CONNECTIVITY COMPONENTS from 2000 to 2005?
2. is there a way to enable tcp/ip in installation script of SQL Express?
THANKS
View 9 Replies
View Related
May 21, 2005
Can you install Sql Server 2000 Developer Edition with MSDE 2000 release A already installed?
View 2 Replies
View Related
Feb 17, 2004
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
View 3 Replies
View Related
Feb 16, 2006
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"
View 1 Replies
View Related
May 27, 2008
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
View 1 Replies
View Related
Jun 18, 2007
hi all
What I need to include with my application setup,
My application is working with Sql Server 2005.
I mean what substitute MSDE for sql server 2005
thanks
View 1 Replies
View Related
May 20, 2005
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?
View 1 Replies
View Related
Jan 28, 2007
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 Related
Jun 27, 2006
i 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.
View 8 Replies
View Related
Aug 2, 2006
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
View 2 Replies
View Related
Dec 18, 2003
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
View 4 Replies
View Related
Feb 28, 2004
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!
View 1 Replies
View Related
Apr 1, 2004
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.
View 5 Replies
View Related
Dec 5, 2007
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!!
View 4 Replies
View Related
Oct 26, 2004
Did anybody tried to use this as a database server? Is there an administration interface somewhere which is free?
Dennis
View 2 Replies
View Related
