Just upgraded a users computer from 7.0 to 2000. All previous SQL Server Registrations are gone IP Addresses, User Names and Passwords arent readily availiable. Are the old connections stored in a DLL or Ini that I can place in the SQL 2000 folder to regain those or do I need to recreate some DSNs?
Help
Matt
Can the template.ini be setup to upgrade a previous version of MSDE if it exists or just install it if it does not?
I currently have ADDLOCAL=SQL_Engine and UPGRADE=SQL_Engine INSTANCENAME=MSSQLSERVER in the file but that does not seem to do it if the server does not exist.
Am I going to have to create two seperate ini files and tweak my install program to select the specific one or am I missing a simple step?
Thanks in Advance
Dave
What's the diffrence between the Built-In account 'SERVICES' and the 'NT SERVICEALL SERVICES' ?I want to dploy a group poicy for 'user right assignment' - 'log on a service' to a server, which curretnly has among other things the 'NT SERVICEALL SERVICES' however i can't replicate this account for my GPO, (even locally on the server),I deploy the GPO and overwrite the server settings for 'user right assignment' - 'log on a service' and won't be able to revert back to the original settings..
View 5 Replies View RelatedWhat is the most effecient way to recover a SQL 2000/2005 database to a different server.
View 1 Replies View RelatedI am trying to enable FILESTREAM on a SQL 2012 installation that is supporting a Sharepoint 2013 implementation. When I try to enable FILESTREAM using the SQL Server Configuration Manager I receive the following error:
There was an unknown error applying the FILESTREAM settings.
Check the parameters are valid. (0x80041008)
I have done this succussfully in the past in SQL2008R2/Sharepoin2010 environment but this is my first attempt with SQL2012/Sharepoint2013 and I am not sure how to proceed with troubleshooting.
I'm trying to activate FILESTREAM on my SQL Server 2012, however i'm not accomplishing it. I've tried to follow this instructions: [URL] ...
My SETUP is the following:
Windows 8 (64 bit)SQL Server Standard Edition - Service Pack 1 (64 bit)SQL Version: (11.0.3128.0)
When I go to the configuration manager, on the FILESTREAM tab has a message:
"A previous FILESTREAM configuration attempt was incomplete.
FILESTREAM may be in an inconsistent state until re-configured."
If I click Enable FILESTREAM and "Apply", I get the following message:
"There was an unknown error applying the FILESTREAM settings. Check the parameters are valid. (0x80070002)"
I also read somewhere to run "EXEC sp_configure", which produces the result:
"filestream access level - 0 2 2 0"
Running "SELECT SERVERPROPERTY ('FilestreamEffectiveLevel');" returns 0.
I will doing an installation of MS SQL 2000 that will be used by multilanguage web sites.The languages are Japanese, German and of course English.Currently I'm planning to install MS SQL 2000 standard version butafter reading some articles I'm considering the Enterprise version.Can someone shed some light on the advantages of using Enterprise vsStandard strictly from a language support perspective?Also, is there any caveats or other considerations that I should keepin mind to make sure that the developers have all they need to developthese multi language sites?Thanks in advance.
View 1 Replies View Relatedhi all,
I need to select collation settings to support chinese characters. As i came to know that i need to select 950 character set. But problem is that i am not able to find the option for chinese characters i.e, 950 character set in the collation settings of the setup. It will be helpful if anyone could suggest me if there is any other option to set while set up or in an existing sql server instance to support chinese character data.
Thanks in advance,
sekhar
I have an Active/Active/Passive cluster with 64GB RAM on each node running SQL 2000 EE, AWE is enabled as well as the PAE switch, all is dandy with that.
Question:
Should I configure each SQL Instance to have only a max mem usage of 32GB in the event both failover to the same node ? or will the memory allocation be handled without any issue if each node is configured to use 64GB ?
Thanks.
Hello!I would like to change the SQL server 2000 from Standard version toDevelopment edition. I have two database running on this server, bothreplicated, with few jobs, etc ... Can you recommend the easiest way to dothis? I heard, it would be as easy as, detaching the databases, deletingcurrent SQL software, installing different one, and attaching the olddatabases back. I doubt that is true, so that's why I'm asking here for anyreal-life instructions.Thanks for your input!Kind regards,Dejan--
View 1 Replies View RelatedI don't need 2005
obulay@hotmail.com
There must be many various ways to upgrade a dual processor server from SQL 7 to SQL 2000.
Do you think I am better off to simply run the upgrade CDs?
Would it be better to de-install SQL 7 and then install SQL 2000?
Better still to Rebuild from scratch? (OS & setup)?
This particular server has seen little use actually.
Who has experience and suggestions?
Thanks,
Mark Blackburn
CA Dept of Parks
Hi.
I have two scenerio.
One:
Two servers (SQL 7.0), transaction replication
Two:
Four servers (SQL 7.0), transactional replication one publisher, one distributor and 2 subsribers.
I need to upgrade these two scenerio to 2000.
Please advice me with suggestions and your experience.
-MAK
I am planning on upgrading my existing SQL Server 7 to 2000. I plan on starting out just upgrading the SQL first, then upgrading to Win2k Server later on.
I have read some posts here with some of you having issues, etc. Based on your experiences, do you suggest, I do both upgrades together? I think it would be best to do this on a new server, and keeping everything live on the other server until I feel comfortable in moving over the data.
What files besides the database files, should I restore, if any? Are there any significant application performance issues or bugs? Should I wait to apply the first sql patch that was just released last week? What about any code that needs to be rewritten?I will do it as a test first, but any advice would be great.
I have several SQL 7.0 SQL servers that I need to upgrade to SQL 2000.
I have been tasked with finding out what the risks are in upgrading and where I may run into problems when upgrading.
So far I have'nt been able to find any info of how to prepare for the upgrade.
Does anyone know of potential problems I should look for or documents/kb articles on the web that I can refer to plan correctly.
Thanks.
We are trying to do an upgrade in place and are getting errors that it can't activate model database files. We believe it's because we move all log files to another drive and think Microsoft failed once again to recognize this in their upgrades. They made this mistake in 7.0 SP2 (the SP failed if you moved log files to alternate location) but they fixed it in SP3.
Has anyeone experieinced this problem? Is there a workaround (other than the obvious.)
Replies are appreciated!
Colleen:confused:
We are about do an upgrade from 6.5 to 2000. Does anyone know of any material that would be of assistance to me. If you have any pointers that would also be appreciated.
View 1 Replies View RelatedTry to upgrade SQL 7 on a NT4 system to SQL 2000. Also like to upgrade NT4 to Win2K. Anyone know what's the best sequence for doing so? Thanks on advance.
View 1 Replies View RelatedWhat is the best way of brining a SQL Server 6.5 database to a Consolidated SQL Server 2000 environment? I tried using the SQL Server 2K upgrade wizard and it failed to import some data, which made me uncomfortable in using this tool?
Is this a safe approach:
Create a database on SQL 2K and script out all the objects like tables, Indexes, views and run it against SQL 2K.
Then run the DTS to populate all the tables and you are done?
Hi,
I'm looking to upgrade our old 6.5 server (running NT4) to 2000 and go to Windows Server 2003 at the same time. There are 10 or so small to medium sized DBs on here.
Can anyone provide some decent links to blogs, FAQs or documentation relating to this?
Many thanks,
Matt
Hi,I am trying to use the Upgrade Wizard in SQL 2000 to upgrade a SQL 6.5 db to2000. I am only choosing to update a single database, not system objects.The Upgrade wizard connects to SQL 6.5, checks the db, creates the db on SQL2000 with all tables and imports users from SQL 6.5. The problem comes whenit tries to bring over the actual data. I get an error:"Couldn't connection to the export machine!" in the out log file.The in log file reports login failed.Both SQL services were running at this point, the login via SA must beworking since it copies over the 6.5 db structure and users.The SQL 6.5 machine is NT 4. The 2000 machine is Windows Server 2003. Iwas logged in as domain admin when running this. I tried playing with the"SQLUpgrade" DSN that was created on the SQL 2000 machine to use SA orwindows authentication, both fail.Any ideas?Thanks.
View 1 Replies View RelatedHi! If doing online version upgrade from SQL 7.0 to SQl 2000, (1) do Ineed to shut down server? (2) after upgrading, is all login and dbuser, group information, scheduled Jobs, maintenance paln... stillthere? or I have to save the info before upgrading and recreate afterupgrading? (3) any other tips I need to know? I'm doign that for thefirst time.Thanks!Saiyou
View 2 Replies View Related
This is want happen. We have upgraded from sql 2000 sp3 to sql 2000 sp4 on an window 2003 server with sp1. Now we are getting this error. ERROR: 17805, SEVERITY: 20, STATE: 3 INVALID BUFFER RECEIVED FROM CLIENT..
Any ideas.
Mark
Hello,
I have a project where I have to upgrade SQL 2000 to 2005. When we are upgrading we are going to move to new server so server name will change. Most of our applications have a hard coded connection string. Applications are developed with Classic ASP, .NET 1.1 and 2.0 as well.
Now the question is what is the best way to do this? Changing all the connection string will be a very painful task as we have many applications.
Can anyone suggest a way where we can achieve this without changing all the connection strings?
Thanks in advance.
Tareq
Do I have to upgrade to 7.0 before installing the beta SQL 2000 or can I go straight from 6.5?
View 1 Replies View RelatedI am upgrading a SQL7 std to SQL2000 std
The upgrade process fails in the upgrade.sql step. With no meaningful error messages. All services that may use the db are stopped, the net is disabled so this server is stand alone, nothing can be accessing the db !
I cannot find any log output, from the upgrade so I dont know whats causing this. Has anyone any ideas ?
Thanks
Tom
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,
We have a VB application, which extracts data from SQL Server 6.5 database. Recently we upgraded our database from 6.5 to 2000.
One of the report which used to give results in Sorted order in 6.5 database, is not producing the same report in sorted order. We didn't do any change at database/application level.
As we have not made any changes at application level, I am presuming that the problem is at database level, due to this upgradation.
Can any one guide me how to rectify this problem.
As I don't have source code for this application; Is it possible for me to extract the query running for this report from database?
Thanks.
Hi guys.
I have two scenerio.
One:
Two servers (SQL 7.0), transaction replication
Two:
Four servers (SQL 7.0), transactional replication one publisher, one distributor and 2 subsribers.
I need to upgrade these two scenerio to 2000.
Please advice me with suggestions and your experience.
Is Online replication possible?
-MAK
Hello List,
I've couple of questions about Sql Server 2000 and would greatly appreciate, If somebody out there, please answer to it.
Questions:
I've a SQL 7 server dump file and I was wondering, If I can directly load this file into SQL Server 2000? If yes, Would this call a Upgrade of sql 7.0 database to SQl Server 2000? Or this is just a backward compatability support in 2000?
Well the main objective of this is, We are planning to upgrade one of our production SQL 7.0 server and I was wondering, If we can just take the SQL 7.0 dump file and load it into the SQL 2000 Server? If yes, What are the downgrades of this and if no, Should we upgrade the sql 7.0 server itself and along with it all the databases sitting on it? Please shed some light here.
Many thanks.
I started with a SQL 7.0 installation and installed an instance of SQL 2000. The default instance is SQL 7.0 as expected and both run fine. However, now I'd like to upgrade the SQL 7.0 instance to SQL 2000, but the setup procedure on the install CD only allows you to upgrade/modify the SQL 2000 instance. It seems as though once you've chosen to install SQL 2000 as an instance, you do not have the opportunity again to upgrade the SQL 7.0 instance in place. I tried to remove the SQL 2000 instance and reinstall 2000, but the procedure does not give you the opportunity to upgrade the SQL 7.0 instance -- only to modify the programs installed. Any suggestions?
(I could use the Copy Database Wizard to move all databases along with associated stored procedures, logins, etc., but then I'd have to mess with DTS packages, etc.)
the first 2 parts install but the installation fails on the MSDE installation.
It gves me an error like about invalid installation media or something?
I have sql server enterprise.
plz help
I have tried several SQL 2000 upgrades from SQL 7.0 SP3 , NT 4.0 SP6a and numerous hotfixes.I have not had one go through the first time without a problem. These are inplace upgrades, not an install of a new instance.
Number one was the upgrade failed with "The ordinal 105 could not be located in dynamic link lib opends60.dll. To work around this I had to back out our two hotfixes (MS01-032, a security hotfix and the SQL profiler hotfix).
Number two was that MSSQLSERVER would not start before running MESSSAGES.SQL causing setup to hang. To work around this M$ told me to invoke SETUPSQL in debug mode and step through the upgrade and manually start MSSQLSERVER before MESSAGES.SQL was run. This worked and I was able to complete the upgrade successfully.
Number 3 occurred when SETUP could not find MASTLOG.LDF and died. When I first started running 7.0 I decided to move all logs to our separate log device even if they were truncate log on checkpoint. I know, it sounds stupid. I have since stopped this practice. I was able to move MASTLOG.LDF back to the same device and directory as MASTER.MDF and things worked fine. I feel setup ought to look for the logfile in the location specified on the MSSQLSERVER service startup parameter and not assume it's location.
Fortunately all of these upgrades were on test boxes or non-essential servers. However, I am very worried that new problems are going to crop up at each upgrade. I always ghost all volumes before an upgrade and also have good backups, so falling back is not a problem. Has anyone else had these kinds of problems with upgrades? Remember, I am talking about an upgrade not a detach all dbs, uninstall 7.0, install a new instance and reattach all dbs. Though this is something I can fall back on. Detaching and reattaching all DBs would be allot of work with saving logins and all.
I would appreciate any help or suggestions?
Steve Rinehart
Battelle Memorial Institute
Information Management
Technology Group, Network Computing Systems
(614) 424-6543