Hi all,
I have a server that is missing some important files, and instead of doing process of elimination, I feel it is best just to reinstall 2000.
Now is there a way to reinstall 2000 and just getting the files that the server is missing?
Is there any guidelines or steps for reinstalling 2000 out there?
Thanking you in advance.
Lystra
I need to reinstall on one production server. What steps to be taken before uninstall and install
I am new to SQL Server, please can anyone guide me on this?
I uninstalled a previous version of SQL Server 2000 Developer because it had some custom configurations that I didn't want. When I try to re-install, I get an error message saying:
A previous program installation created pending file operations on the installation machine. You must reboot the computer before running setup.
I don't know what other programs affect SQL that I have on my machine. My previous instance only contained two known databases and I have deleted the applications that went with those databases.
I have deleted all known registry settings for SQL Server. I have also stopped the IIS service because I thought it would impact the install.
I rebooted my machine, but I still get the same error when I try to install. I don't know what to do next? Please help!
I can€™t use the DTS editor because shows an error.
So, I want to reinstall the enterprise manager without uninstall the sql server 2000, Is that possible?
If the answer is yes, How can I do that?
I think that reinstalling only the Enterprise Manager the DTS editor can be fixed.
Sql Version: Sql Server 2000
SO: Windows 2003 Server
Tanks in advance
Ariel.
Something happened when the server fall down because of no disk space.
Now everything is fine but I have a problem in de DTS (from the Enterprise Manager) editor, I can€™t run, modify and even make a new DTS.
What can I do? Is it possible reinstall de DTS components without reinstall sqlserver 2000?
Sql Version: sqlserver2000 Enterprise
SO Version: Windows 2003 Server
Thanks in advance
Ariel.
I need to recover an entire named instance because of data corruption on the SAN. The DBs are OK but the SQL Server Service will not start due to a 'windows internal error' so I'm going to restinall the instance. I have all of my data and log files from all databses including the master.. can I use these to recover or is a restore of system databases better??
Also, I have a database with 5 .ndf files. I can't quite get the syntax right to attach these files after I do a restore to get the LATEST data? Can anyone help?
I have a situation where I might want to pull(select) some information from a DB2 database, and possibly push(insert) some data to the same DB2 database. I am sure this is being done in the real world. WHat software, infrastrucure, etc would I need to accomplish this. Is it as simple as using DTS and the proper drivers, or are their better products and solutions. ANy
input appreciated.
Hi, I have installed SQL 2000 on my system and when I try to start it gives me an error saying 'ordinal 29 cant be found in the dynamic link library odbcbcp.dll.
Please advice!!
i need write a Feasibility report about MS SQL 2000
Easy of use?
Cost?
Development speed?
Features
I am upgrading our SQL 2000 Server hardware. I am looking for a way to "mirror" this server. The only items that we are changing are updating the hardware and the OS will be Server 2K3 instead of Server 2k
Does anyone have a reliable method, or suggested processes for migrating one server to another?
Knowing that web synchronization is a new feature comes with SQL Server 2005.
View 1 Replies View RelatedHi, I am trying to create a connection string that will connect to a SQL Server 2005 Registration on a remote machine. I have a SQL Server 2000 registration (installed) on the same machine and so I think there may be a conflict. The SQL 2005 registration is denoted as HARDYSQL5 and the 2000 registration is merely HARDY (the machine name). I need to connect to a database on the HARDYSQL5 registration but I am not connecting. I have tried various connection strings but none have worked. I get a Login failure. I think this is red herring because I doubt its even finding the database.I can connect to the 2000 db with:"Server=HARDY;Database=Perimeter;UID=use;pwd=example;" But its fails with the following, for example:"Server=HARDYSQL5;Database=Perimeter;UID=use;pwd=example;" "Server=HARDYSQL5;Database=HARDYSQL5Perimeter;UID=use;pwd=example;" "Server=HARDY;Database=SQL5Perimeter;UID=use;pwd=example;" I'm gon go nuts. What am I doing wrong? Thanks.
View 10 Replies View RelatedWe want to run Unix Scripts on SunSolaris which Connected to MS SQLServer 2000.We would like to connect to SQL Server 2000 from Solaris. Is there anyway to connect to Sql Server 2000 natively (just like isql we use inwindows which has the client) with the help of third party ct library?or any other drivers or tools???TIA
View 5 Replies View RelatedHi all,
I have an aplication in VB6 that uses an ODBC to link to a SQL database.
Until today all my clientes had SQL Server2000 and my aplication worked fine.
Some of my cliente have now SQL 2005 and my application still woks fine except in one of them.
In this particular cliente it gives an error when the application tries to read/write a particular table and a particular column.
This column is data type BIT and my code is
...
Myrs("Servida")= true
...
Any idea why the error appens? And why only in a particular machine and not all of them with SQL2005?
What can I do? I changed the code for
myrs("servida")=abs(cint(true)) and solved the problem, but is not the way that I want to go. I do not want to change thousands of line of code where I read/write a column in the database data type BIT.
Is there a way to configure SQL Server 2005 the way that it controls data type BIT?
Regards
Luis
Is it possible to connect SQL Sever 2005 Express from SQL Sever 2000 Enterprise Manager? Tried to connect but got the error message "must use SQL Server management tools to connect this sever"
Thanks
Hi, i'm very new to Web Matrix. I've been following the C# end-end application tutorial exactly but i can't seem to run my application.
The code given in the link below is for MS Access but I'm using MS SQL 2000, so i'm not sure of the syntax for the code provided below (string connectionString...)
Please help..thank u!!
http://www.asp.net/webmatrix/guidedtour/section91/bookrequestcontrol.aspx
string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:TempProjectsLibraryDatabase.mdb";
public void LoadRequestedBooks(){
try
{
string mySelectQuery = string.Format("SELECT books.* from books, requests where books.bid = requests.bid and requests.mid = {0}", Session["userid"]);
System.Data.OleDb.OleDbConnection myConnection = new System.Data.OleDb.OleDbConnection(connectionString);
System.Data.DataSet myDataSet = new System.Data.DataSet();
System.Data.OleDb.OleDbDataAdapter myOleDbDataAdapter = new System.Data.OleDb.OleDbDataAdapter(mySelectQuery, myConnection);
myOleDbDataAdapter.Fill(myDataSet);
DataGrid1.DataSource = myDataSet.Tables[0];
DataGrid1.DataBind();
myConnection.Close();
}
catch(Exception exp)
{
Label2.Text = "<br>Error: " + exp.Message + "<br>";
}
}
I installed SQL Server 2000 Develloper version and I am wondering what are the limitation of this version compare to the other versions available? Like how many connections can I have open at the same time? Can I use it for my intranet application? etc...
Thanks
Does anyone know of any shareware tools out there that can connect tosql server 2000 from Unix(specifically Sun Solaris) and performqueries and return result sets ? Appreciate your help.Steve Chiang
View 1 Replies View RelatedI recently upgraded from SQL Server 2000 to SQL Server 2005. I have Oracle databases I need to share data with. I was using the Heterogeneous Services (hsodbc) from Oracle and connected to SS 2000 fine. Since I've upgraded, I can't use hsodbc to connect to my SS 2005 database. I get the following error:
ORACLE GENERIC GATEWAY Log File Started at 2006-09-06T09:40:07
hoainit (3): ; hoainit Exited with retcode = 0.
hoalgon (7): ; hoalgon Entered. name = edw.
DB_ODBC_INTERFACE (2085): ; [Microsoft][SQL Native Client][SQL Server]Login
failed for user 'edw'. (SQL State: 28000; SQL Code: 18456)
DRV_InitTdp: DB_ODBC_INTERFACE (2085): ; [Microsoft][SQL Native Client][SQL
Server]Login failed for user 'edw'. (SQL State: 28000; SQL Code: 18456)
nvRETURN (F:WorkConnect_4_6_3srcdrvDRV_BIND.C 356): -2220
nvRETURN (F:WorkConnect_4_6_3srcavNAV_BIND.C 293): -2220
hoalgon (7): ; hoalgon Exited with retcode = 28500.
We have a SQL Server 2000 and want to migrate to SQL Server 2005 Express.
It's possible?
SQL Server 2005 Express have support to do this?
Given than once SQL Server 2005 is installed, SQL Server Studio has to
be used instead of Enterprise manager, can both SQL 2000 and 2005 be
used on the same machine, be it development or production? (The second
one to be installed probably would be a named instance.)
Any experiance of doing this or a pointer to a Microsoft recommendation would be appreciated.
Have reinstalled MSDE using Command Prompt Installation and received Errors.
Then I proceeded with a Batch.file installation and that seemed to work for the most part.
This is what I used for the Batch.file
setup.exe SAPWD=somename INSTANCENAME=somename SECURITYMODE=SQL
The Problem I ran into is - I can't seem to get the (SQL SERVER SERVICE MANAGER) to connect. I've entered the server name & instancename but so far no luck.
Ive checked - Control Panel/Administive Tools/Services - to make sure that it was installed & Yes it is there. So I Proceeded to start it up. Next I tried to Connect Via SERVER MANGER with no luck.
Then I did a c:>osql -E check with the Command Line Prompt which returned the following message:
[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen <Connect<>>.
Tried again with c:>osql -E -S
returned the same message.
[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen <Connect<>>.
Not sure what to do at this point any help/advice. Thx/TIA
(MSDE Version: sql2kdesksp3)
OS = XP Pro
I had SQL Server 7 installed on my desktop (I'm trying to learn SQL Server). The desktop got hit with a virus which necessitated running the rescue disk. Some items were lost (or badly mangled), including SQL Server. When I tried to reinstall SQL Server, I get a message that tells me that the server portion can't be reinstalled from that disk, only the client stuff. This is the same disk I used to install it, so I really don't understand what's wrong. Could someone suggest what to do next (short of "Format C:" and reload everthing from scratch)?
View 2 Replies View RelatedWe are running front end applications provided by a third party against our server. They are
slow.... so far, performance problems can be traced to their code and data model.
Management here had them dial in to our SQL Server. They noticed that our performance counters
are missing and told management here that our SQL installation was corrupted and that we
needed to reinstall SQL. According to them, this "corruption" is causing the performance
problems with their app.
Other apps are not experiencing any performance problems.
Have you EVER heard of a reinstall fixing performance problems, assuming we reinstall with the
same settings as are currently running?
Bob
Sorry about that first post I hit the wrong button.
I have a BIG problem. One day about a week ago I came into my office and everything was working fine, except for the fact that the drive of the NT server was a little fragmented. This machine is a dedicated server and since everything was relatively ok I turned the monitor back off and left the machine alone, after starting Diskkeeper to take care of the fragmentation. Later I go to check on the machine and the following message had appeared on the screen, NT system corrupt service can not continue with an OK button. So I sighed an pressed the ok button already to figure out what service needed to be restarted, unfortunately my best laid plans were soon destroyed when again the message popped up till I had shut down every program and had to reboot.... That is when the real fun started, it never rebooted, I had shut it down properly. So now I had a central server, that had never been backed up before that needed windows NT reinstalled. So I started reinstalling NT. I recently came in to this position and the people before me had not made and backup what so ever. So I had no Emergency Disk, and the systems files, i.e. User database, stuff that would normally be on a Emergency Disk were somehow corrupt and I could no recover them. Well after getting NT up, I worked on restoring the functions of the server, file sharing and web hosting. I still have a lot of programs to reinstall as the reinstall of NT left the actual program files alone, but has rendered them unusable. Now that I`m done with the background, I have now made a copy of what was left on the drive, so I could restore the data files. When I go to reinstall SQL 6.5, it will not let me use the upgrade part. So I try to do a complete install, I`m getting desperate here! Well it starts the install no problem asks me for info and I tell it. I have tried this with a new directory and the old one with the files intact. Well as the install goes along it allows the copying of the files, and then goes to a screen where it has the little hour glass thing in the SQL window setting up the server. A few minutes later it changes the title on the screen to read Microsoft SQL Server 6.5 Setup and brings up a window with the error The SQL Server installation could not be successfully completed Setup was not able to connect to the SQL server the only button is Exit to windows NT. I`m out of ideas. HELP me please.
I made a big mistake and deleted this program and now I cannot reinstall it. I get error messages stating that an instance is already on my machine and I need a unique name to restart install. I also get messages that say to install from the command line but I cannot get there the only access I have is error reporting. Is there any way I can make a FREASH install of this program????
View 2 Replies View RelatedHi,
I have discovered something wrong with my SSIS package and I thought it best to post a new thread since the problem is not what I thought it was initially.
With relation to my post of 'directory variable problem' I have now discovered by opening my project this morning that apparently my project had gone corrupt, according to the dev environment since the message reads:
"There were errors while the package was being loaded.The package might be corrupted.See the Error List for details."
The Error List:
"Error 13 Error loading MyTestSSISPackage.dtsx: The connection "(local).MyTestDB.sa" is not found. This error is thrown by Connections collection when the specific connection element is not found."
This is a buggy ADO.net connection that I deleted yesterday since, even though it connects successfully, doesn't want to work! It keeps on telling me log in failed for user <MyTestUser> even after I test it and it connects fine with the username and password during the UDL screen of the connection.. It's like it forgets the bloody password.
I created another connection, this time an OLE connection and it seems to work fine.
*EDITED*
I stand corrected..no bloody connection manager is working now. They all fail stating that they cannot connect to the db due to some or another 'unsupported' value in the connection string...the connectionstring was set up by the environment's udl????? how is this possible. I am beginning to get annoyed with SSIS
Now finally my question...WHY is it that every time I change something its like the dev environment doesn't cascade the change throughout the project or package? The problem I have been having with my variables not getting picked up with the correct values which I gave them during design time is probably also related to this. How or where can I remove the reference to this old ADO.Net connection since I cannot find it anywhere in the <package>.dtsx file?
Anyone ever experienced this?
Regards
Mike
I appear to have done something wrong in SQL express because I could not connect through VWD and when I tried to look at the Personal Web Site I only got errors.
I decided to uninstall the program and then reinstall and nothing seemed to work.
This is the message I received:
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
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. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
Is there a way to totally remove SQL Express and start again or do I need to try and fix it..../
I had MSDE installed on my machine, but I had problems making it work. I installed the Visual Studio 2005Beta2, and it apparently installed MSDE 2005. I deinstalled MSDE 2000, then tried to make MSDE 2005 work. After lots of hair pulling I finally found the instance name, reset the authenitcation method, and reset the SA password. Then I found out all my sql tools don't work with it. No enterprise manager or query analyzer. So off MSCE 2005 came from my machine. I reinstalled MSCE 2000, but I cannot login. I am not sure if I don't have the proper instance name, or password for the sa account. I have not really found any good into on setting up the msce 2000 software. I think it found the old username/password info because whtn I started it, it did not ask me for any of that information.
View 1 Replies View RelatedI had a problem with my existing SQL Server, so decided to reinstall. During installation it came up with an error saying there was another instance of reporting services (most likely from the previous installation).
The error log (the last part of it) has the below:
Code Snippet
Property(S): BinES.63902412_233C_4EBC_8197_D6B17D4C9C3C = D:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesReportManagerBines
MSI (s) (4C:E4) [19:17:09:718]: Note: 1: 1708
MSI (s) (4C:E4) [19:17:09:718]: Product: Microsoft SQL Server 2005 Reporting Services (64-bit) -- Installation failed.
MSI (s) (4C:E4) [19:17:09:718]: Windows Installer installed the product. Product Name: Microsoft SQL Server 2005 Reporting Services (64-bit). Product Version: 9.00.1399.06. Product Language: 1033. Installation success or error status: 1603.
MSI (s) (4C:E4) [19:17:09:734]: Cleaning up uninstalled install packages, if any exist
MSI (s) (4C:E4) [19:17:09:734]: MainEngineThread is returning 1603
MSI (s) (4C:E0) [19:17:09:734]: Destroying RemoteAPI object.
MSI (s) (4C:B8) [19:17:09:734]: Custom Action Manager thread ending.
MSI (s) (4C:E0) [19:17:09:734]: RESTART MANAGER: Session closed.
MSI (s) (4C:E0) [19:17:09:734]: No System Restore sequence number for this installation.
=== Logging stopped: 19/03/2008 19:17:09 ===
MSI (c) (14:54) [19:17:09:734]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (14:54) [19:17:09:734]: MainEngineThread is returning 1603
=== Verbose logging stopped: 19/03/2008 19:17:09 ===
So my question is how do i reinstall reporting services and check its working as it should?
Thanks in advance
I am trying in vain to reinstall MS SQL Server(2005 SP2) Management Studio
(on Windows XP Pro SP2) due to.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2616564&SiteID=1&mode=1
And I have catch-22 (or catch-33) situation trying to reinstall it.
If I try to launch from DVD Z:SQL Server x86Toolssetup .exe from command prompt (cmd):
setup SKUUPGRADE=1
even after deleting (I tried first without deleting)
Microsoft SQL Server Native Client
Microsoft SQL Server 2005 Setup Support Files
in
Add or Remove Programs in Control Panel,
then I end up with
--------------------------------------
Name: Microsoft SQL Server 2005 Tools
Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
Build version check:
Your upgrade is blocked because the existing component is a later version than the version you are trying to upgrade to. To modify an existing SQL Server component, go to Add or Remove Programs in Control Panel, select the component you would like to modify, and then click Change/Remove
------------------------------
and then
----------------------------
TITLE: Microsoft SQL Server Setup
------------------------------
None of the selected features can be installed or upgraded. Setup cannot proceed since no effective change is being made to the machine. To continue, click Back and then select features to install. To exit SQL Server Setup, click Cancel.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=SQLSetup90&EvtType=28108
------------------------------
BUTTONS:
OK
------------------------------
How should I reinstall client Tools?
Might be to merge original SS2005 DVD with downloaded SP2?
Since there is not a method to uninstall SP2 for SQL Server 2005 Express, it is recommended to completely uninstall and then reinstall. I have backed up all databases as well as generated a script to recover username/passwords, is there anything else I should be taking into consideration?
View 4 Replies View Relatedhi Everybody,
for some reason my Sql Server has stopped and i am not able to restart it at all, do i have to reinstall the complete SQl Software or is there ne way i can start the MSSQL Server