Problems With SQL 2000 And 2005 On Same Machine - Can't Connect On 2000
Hi,
i have SQL 2000 and 2005 on same machine(with different intance names,
of course), my laptop - XP with SP2. The 2005 works fine but i can't
connect on SQL 2000. All the the SQL services are started.
Any idea? Have i to reinstall 2000?
Tks,
Lourival
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
SQL 2000 And SQL 2005 Both In The Same Machine
Hi i am new using SQL 2005, i have SQL 2000 Personal Edition SP4 with 2 databases for testing installed in the default instance and i would like to install SQL 2005 standart Edition (i have Windows XP pro sp2) . can i have the same instance for both SQL database engine?. or to create a new instance for the 2005?. what i need is to test SQL 2005 while i keep my database for test in SQL 2000. I was trying to install by typing a named instance, and it gave me an errors. then i try again by choosing the default instance and then it start an upgrade operation and affter a sucess upgrade now i cannot see the sql management studio and neder Enterprice Manager for SQL 2000. i am confuse, some ideas for this issue?
View Replies !
View Related
SQL 2000 And SQL 2005 On Same Machine
Hi, I have SQL 2005 running on a server (Virtual Machine - VMWare) with a default instance. I have just installed SQL 2000 with a new instance name in a separate folder structure. However, i cannot connect to the SQL 2000 instance. I'm getting the following error: "error: 26 - Error Locating Server/Instance Specified" when accessing the instance remotely using SQL Management studio/Enterprise manager. I can access it through Enterprise manager locally on the server. I cannot see the SQL 2000 instance using the ListSQLSvr.exe utility. I can see the "MSSQL$<instancename>" process running on a dynamic port. SQL browser is also running on the server. I did the same on a different Virtual machine and it worked fine. Has any1 come across that? Thanks for your help. Vishaal
View Replies !
View Related
SQL Sever 2000 And 2005 On Same Machine
Hi, 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 Replies !
View Related
SQL 2005 Express && SQL 2000 On Same Machine?
Hi all, I'm about to download the VWD ASP.NET 2.0 with SQL Express 2005, but i currently have Visual studio.net 1.1 and SQL Server 2000 installed on my PC, XP Pro. Has anyone had problems with this or are they happy to run along side one another without over writing projects already created in the older versions? Thanks in advance. Allen
View Replies !
View Related
Sql Server 2000 And 2005 On Same Machine
I've got to install sql server 2000 and 2005 on our test computer (sql server 2000 is already installed). I've heard from the grapevine that trying to install 2005 with 2000 already installed can cause problems, and its difficult for sql 2000 and 2005 to co-exist on the same machine. what are these problems and how can I avoid them? Thanks in advance.
View Replies !
View Related
RS On Sql Server 2000 And 2005 On Same Machine
Hi Samuel, I'd like to draw on your expertise on this topic. I've been browsing at many blogs/forums about installing SQL Server 2000 and 2005 on the same machine. What I'd like to know is how does that work with Reporting Services? Your machine's IIS will need to work with Reporting Services 2000 and Reporting Services 2005. The RS 2005 requires .NET Framework 2.0 and RS 2000 requires .NET Framework 1.1. IIS can only support 1 version of the .NET Framework at a time. Thanks kindly.
View Replies !
View Related
Reporting Services 2000 && 2005 On Same Machine
How can I get the 2000 and 2005 versions of SQL Server Reporting Servicesboth working on my development laptop ?????I have ASP.NET 1.1 and 2.0 installed on my laptop.I have Visual Studio 2003 and 2005 installed on my laptop.I have my default website configured for ASP.NET 2.0.I have the developer edition of SQL Server 2000 installed on my laptop asinstance RMK006 in the MSSQL folder. I have the developer edition of SQLServer installed on my laptop as instance RMK0062005 in the MSSQL.1 folder.I have the corresponding versions of SQL Server Reporting Services installedon my laptop.I have the Reports web site and the Reports web site and ReportServer website configured to ASP.NET 1.1I have the Report$RMK0062005 web site and the ReportsServer$RMK0052006configured to ASP.NET 2.0Entering http://localhost/reports$rmk0062005 in my web browser works fine.Entering http://localhost/reportserver in my web browser generates thefollowing error:Reporting Services Error--------------------------------------------------------------------------------The report server cannot decrypt the symmetric key used to access sensitiveor encrypted data in a report server database. You must either restore abackup key or delete all encrypted content and then restart the service.Check the documentation for more information. (rsReportServerDisabled) GetOnline HelpBad Data.--------------------------------------------------------------------------------Microsoft Reporting ServicesEntering http://localhost/Reports in my web browser generates the followingerror:The report server cannot decrypt the symmetric key used to access sensitiveor encrypted data in a report server database. You must either restore abackup key or delete all encrypted content and then restart the service.Check the documentation for more information. (rsReportServerDisabled) GetOnline Help Bad Data.The only way I can seem to get 2000 Reporting Services working is to do thefollowing:- run C:WINDOWSMicrosoft.NETFrameworkv2.0.50727aspn et_regiis.exe -u- uninstall 2000 Reporting Services- run C:WINDOWSMicrosoft.NETFrameworkv1.1.4322aspne t_regiis.exe -i- install 2000 Reporting ServicesBut once I've done that Visual Studio 2005 etc no longer work.The utlimate goal is an ASP.NET 2.0 application developed in Visual Studio2005; the application is based on a SQL Server 2000 database and needs toinvoke SQL Server 2000 Reporting Services to run reports.What am I doing wrong?ANY HELP WOULD BE GREATLY APPRECIATED - I'M DIEING HERE AND MY CLIENT ISLOSING PATIENCE !!!!!
View Replies !
View Related
SQL Server 2000 And 2005 Express On The Same Machine?
Can I install SQL Server 2005 Express Edition on the same server where I already have SQL Server 2000 Enterprise Edition? Doing this also includes replacing .Net Framework 1.1 with 2.0, could that cause any disturbances to the already existing SQL Server 2000 ? (None of these two databases are heavy production databases)
View Replies !
View Related
Upgrade From SQL 2000 To SQL 2005, Same Machine For Both Instances?
I am trying to install SQL2K5 on my machine where I already have SQL2K installed. The best I have managed to achieve is to get SQL2K5 EM looking at my SQL2K databases. Do I need to uninstall SQL2K before installing SQL2K? Depending on what combo of SQL I have installed my options on SQL2K install vary. I am a bit lost at this point. Anyone know a link to a good white paper type doc that guides me through an install on the same machine. Thanks In Advance MPM
View Replies !
View Related
MSDE 2000 And SQL 2005 Express On The Same Machine
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 Replies !
View Related
Connecting To An External SQL 2000 Server From A Vista Machine With SQL 2005 Installed
hi there - I'm praying someone here can shed some light on this - after many google and web searches, I have found users with similar issues, but have yet to find a solution. Problem: I have recently upgraded my desktop from Windows XP to Windows Vista Ultimate (clean install) and have migrated my local machine to SQL Server 2005. However I have a number of .Net projects that access databased on another server running SQL Server 2000 - prior to my upgrade to Vista, I was running SQL Server 2000 on my desktop as well. During the install, everything seemed to go well, and I also installed the SQL Server 2005 Service pack as instructed via the MSDN site. However, when attempting to test my .net projects on my desktop pc (ie visit http://localhost), I encounter the error: 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) note that the server I am attempting to connect TO is the old SQL 2000 server - NOT 2005. I specify my connection info in the web.config - and it points to an external ip address on the web. Can anyone shed some light on this? I've tried enabling remote access on my local SQL 2005 install, but I'm fairly sure thats for servers that want to connect to my desktop, rather than my desktop attempting to connect to external servers. Any help is greatly appreciated - I'm pulling my hair out over trying to figure this out! :) To summarize my setup (if it helps) Desktop PC:Windows Vista (Ultimate)SQL Server 2005Visual Studio 2005II 7.0.Net 2.0 (ASP.Net Application) External Server (co-located at a datacenter)Windows Server 2003SQL Server 2000IIS 6.0.Net 2.0 (ASP.Net Application) Much appreciated, Ted
View Replies !
View Related
How To Connect To 2005 From 2000?
I have a dts package on SS2000 which loops through connections to a list of databases using activex: set srv = createobject("SQLDMO.SQLServer") srv.LoginSecure = True set gpkg = DTSGlobalVariables.parent set tserv = gpkg.GlobalVariables ("Server") -- where "Server" contains the name of an instance. srv.Connect(tserv.value) This works fine when connecting to ss2000 instances, but not with ss2005 instances. How can I connect to ss2005 instances too??? There must be a way! I don't have time to rewrite the package to IS. Thanks, Michael
View Replies !
View Related
Connect From Sql 2000 To Sql 2005
Hi I have 2 severs. Server A uses sql 2005 and Server B uses sql 2000. I want to create sql sever registration on Server B connecting to Server A. But it saied 'To connect to this server you must use SQL Server Management Studio or SQL Server Management Objects (SMO)' Any idea to solve it? thanks!
View Replies !
View Related
Not Able To Install SSRS For SQL Server 2000 On Production Machine (Windows 2000 Advanced Server)
Hi, I am not able to install SSRS for SQL Server 2000 on our production server, which is Windows 2000 advanced server and it is giving error messages in the last minute and before completing the set up and the message is displayed in meesage box as "SQL Setup failed to execute a command for Server configuration. The error was: Line 1: Incorrect Syntax error near '[]'. Refer to Server logs and set up logs for detailed error information " Please help on this at the earliest. Appreciate your help in advance.
View Replies !
View Related
Urgent, Dot Net 2005 Cannot Connect To SQL Server 2000
I am using VS .net 2005 to develop a web application with sql server 2000, but the SQL servrer 2000 is setup on other computer,so, my web server is setup on A machine and SQL servr is setup on B machine.I got a problem when i try to connect to SQL server through the Web form as following error."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)" I had try to setup the MDAC 2.8 on my Web Server, but i got a setup error sth like "MDAC 2.8 cannot install on your machine because it is not support your windows version.........." Why i can't connect to SQL 2000 through the Web server??? It is a urgent case, Please help thx a lot.
View Replies !
View Related
Cannot Connect To A Named Instance Of SQL 2000 Or 2005
Hi, I am struggling connection to a named instance of SQL 2000 (SP4) from another machine but without any success. I get an error message saying that the server does not exist or access is denied. The security configuration in this named instance is the same as the default instance (also 2000) and the remote machine can connect to it successfully. I also configured the aliases in Client Network Utility in the client machine and set the server (machine) name and the port number used by the instance - but no help. I use osql and Query Analyzer to connect to it, but I cannot connect by any of them. Connecting locally, in the machine where the instance is installed, is successful. The same behaviour appears when I try to connect to another instance on the machine which is 2005. Something with the named instance is problematic. Any help?
View Replies !
View Related
Can Not Connect To SQL 2000 Instance If Installed After SQL 2005
I have about 4 SQL servers that have SQL2005 as the default instance and SQL2000 as a second instance. My problem is that I can not connect to the SQL2000 instances using the instance name. I can get to it using IP address and port number or if I set up an alias with IP and port number, but not by name (ie ServerNameSQL2000 which is how the instance was named). If the process is reversed (install SQL 2000 first and then SQL 2005) I can get to both instances using instance name. I read something about if SQL2005 Browser service is running when SQL2000 service starts, the SQL2000 service won't listen for calls, but it was rather vague and I am not real sure if that is true. I am in the process of trying to test this to see if it is true, but due to the nature of the servers, I have to follow a process and it will take me a couple of days before I can test. So I was hoping to find someone to deny or confirm this. Or who has had a similar issue and can shed some light on this for me. Thank you for you time. I appreciate it. Jim Youmans St Louis, MO
View Replies !
View Related
Cannot Connect To 2000 From 2005 Via Linked Server
Interesting issue.. I think I have 2 linked servers on my dev 2005 instance (sp1-win 2003). My 2005 instance shares the physical server with a 2000 instance. This linked server works fine. The second linked server is on a separate server running sql 2000 sp3. I cannot connect to this server at all. I can connect the other way -- from the 2000 to the 2005. I have tried all kinds of combinations of security and options but nothing works. The only resolutions I have found referenced installing Management Studio on the 2000 server or creating an ODBC connection from the 2005 instance. Any ideas??? Here is the error I get: OLE DB provider "SQLNCLI" for linked server "ALLFLDB6" returned message "Login timeout expired". OLE DB provider "SQLNCLI" for linked server "ALLFLDB6" returned message "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.". Msg 10061, Level 16, State 1, Line 0 TCP Provider: No connection could be made because the target machine actively refused it.
View Replies !
View Related
Will SQL 2000/2005 Block Me If More Users Connect To It Than I Have Licenses?
Hello our organization has never had any problems getting users to connect to our SQL servers but we have grown a lot over the past year or two. Does SQL Server actually block connections if they go over the license limit? I don't have access to the servers to see the model used but I have been asked to look into this. I couldn't find any information on this so I decided to ask you guys. Thanks in advance.
View Replies !
View Related
Can't Connect To SQL Sever 2005 After Upgrading From SQL Server 2000
I 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.
View Replies !
View Related
Install Sql 2005 Instance With Reporting Service 2005 On Sql 2000 With RS 2000 Server
Hi We would like to install Sql 2005 Enterprise Edition (including database engine, reporting service, integration service and analysis service) as a sepearte instance on a server which already has Sql 2000 with reporting services and analysis services. We do not want to disturb the existing sql 2000 setup. If we do that then what will happen to my earlier sql 2000 reporting service? Will it be upgraded to sql 2005 reporting service? I heard that reporting services are instance unaware application. Where will be the default reporting service database available? Please help us. Regards, Sankar N
View Replies !
View Related
Can't Connect To SQL Server 2005 Express From Another Machine
I know there have been many posts made on this subject; however, despite the resources available, I have not been able to get this to work! I've spent time working on this here and there over the last couple of months only resulting in frustration. I am finally posting to solicit help for my situation to figure out what is wrong with my SQL Server or firewall configuration. Two machines connected to a router, one wireless, one wired. Both have SQL Server Express and the Management Studio tools installed. From either machine I can connect to its local SQL Server Express instance. I have enabled Shared Memory, Named Pipes, TCP/IP, and VIA in the SQL Server Configuration Manager. (BTW what is VIA?) I have added sqlsrvr.exe and sqlbrowser.exe to my Windows Firewall exceptions. I have tried disabling Windows Firewall. One of the machines is configured as DMZ in the router configuration. Please, someone offer up some brilliant diagnostic steps I am missing to expose what is wrong in my setup and make this work... Thank you!
View Replies !
View Related
Attach SQL 7.0 DB To A SQL 2000 Machine
I need to move a DB that's on a SQL 7.0 box to a SQL 2000 box for consolidation. I cannot upgrade the 7.0 box to 2000 at this time. I tried reattaching it on the 2000 box and it gave me some errors about versions mismatched. Would DTS be the best way to pull it over? If not, what's the recommended operation?
View Replies !
View Related
Using Bcp In A Window 2000 Machine
Hi, I am using bcp to upload data into SQL 7 Server. I have no problem running the bcp in a Window NT workstation. But if I run the same bcp in a Windows 2000 machine, the bcp just hang. Does anyone has any idea why this happens? Thank you for any help.
View Replies !
View Related
SQL 2005 Thinks A SQL 2000 Backup Is Corrupt, But SQL 2000 Restores Just Fine
I am attempting to move some SQL 2000 databases to SQL 2005. My main production database does not seem to want to move. When I use the SQL 2005 GUI the .bak backup file is marked 'Incomplete'. When I attempt to restore the backup file I get a 'RESTORE detected an error on page (0:0) in database' message. I saw a thread in the SQL Express forum suggesting trying to restore from the T-SQL level to get the GUI out of the picture and I get the same 'error on page (0:0)' message. However when I take the same file and use SQL 2000 Enterprise Manager it restores with no problems. Any ideas? Thanks Mike Mattix
View Replies !
View Related
Can I Access Sql 2000 From Machine Having Sql2005
Dear All,I am developing a network application in asp.net. The database is in local machine having sql 2005. But the user database is already existent. So I am accessing that database which is sql2000. does it give any problem while connecting from sql2005 machine to sql2000. If yes it is giving me error as follows: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: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)connection string is :"Data Source=192.168.1.16,1433;Network Library=DBMSSOCN;Initial Catalog=mycatalog;User ID=myuserid;Password=mypwd;" Please correct me if I am wrong. Thanks and Regards.Fazal
View Replies !
View Related
MSDE && SQL Server 2000 On The Same Machine !
Hi all, I started learning ASP .Net using the "Teach yourself ASP.Net in 24 hours". In that book, the applications use MSDE as the database tool. Now i have started developing some big applications and have installled MS SQL Server 2000 on my machine. I still have databases on the MSDE. My question is 'How do i move the old databases from MSDE to SQL Server 2000' ? Can i uninstall MSDE safely since i already installed SQL Server 2000 ? Please let me know. Thank You :-)
View Replies !
View Related
Installing Sql 6.5 Client On 2000 Machine
i am trying to install SQL 6.5 client on 2000 box. but the installation wants to install an SQL 6.5 SERVER on it. Is there something im forgetting? is there a way and if so how? if not, is there a workaround with out upgrading the sql 6.5 server. Thank you in advance
View Replies !
View Related
Moving SQL 2000 Server To A New Machine
I am moving my SQL 2000 Server from a Small Business Server to a full version of Windows 2000 Server and SQL 2000 Server. I have had no experience doing this but have backed up and restored my production databases for practice in case a of disaster situation. Is there anything special I need to do to move everything, including the system databases to a new server and not loose any of the user logons, etc.? Thanks for any advice, Chris
View Replies !
View Related
Bit-data From SQL Server 2000 (2005 Working, 2000 Doesn't)
Hi, I am trying to edit some data from a SQL2000-datasource in ASP.NET 2.0 and have a problem with a column that has bit-data and is used for selection. SQL2005 works fine when declaring <SelectParameters> <asp:Parameter DefaultValue="TRUE" Name="APL" Type="boolean" /> </SelectParameters>When running this code with SQL2000, there are no error-msgs, but after editing a record the "APL"-column looses its value of 1 and is set to 0. Looks like an issue with type-conversion, we've hit incompatibilities between SQL200 and 2005 with bit/boolean several times before. So, how is this done correctly with SQL2000? (I've tried setting the Type to "int16" -> err. Also setting Defval="1" gave an err) ThanksMichael
View Replies !
View Related
|
TRACKER
