Lost Connection To SQL 2000 After SQL 2005 Install
Feb 26, 2007
I've had a VB 6 / SQL Server 2000 app running in a network enviroment for a couple of years now at a client of mine. Recently, he upgraded to the latest version of Quickbooks which installed SQL Server 2005 on the server. Now there is SQL Server 2000 and 2005 residing on the same server. My VB app still runs on the server but will not run on other machines. I can ping the server from the other machines. Has SQL 2005 taken over the port I was using or maybe has new security features that won't let me access SQL 2000 using my current connection string? Here is my current connection string:
mstrConnStr = "Provider=SQLOLEDB.1;Persist Security Info=True;User ID=" & strServerLogin & ";Password=" & strServerPW & ";Initial Catalog=" & strDBName & ";Data Source=" & strServer.
Any help will be greatly appreciated.
Keith
View 4 Replies
ADVERTISEMENT
Aug 21, 2007
I need help!
I have Outlook 2007 w/BCM running on XP Pro workstation connecting to a SBS 2003 R2 hosting my SQL 2005 database. I have two problems: First I can get the BCM to connect to the remote data but periodically the connection is lost and many times it requires a reboot to reconnect. Secondly related to teh first, I can never get MS Accounting 2007 to connect to the same server and database from my client.
I have already set up the server to use port 5356 via TCP amd added a hole through my client windows firewall for the same port. Both client and server are set to share files and printers.
Any suggestions?
View 2 Replies
View Related
Jun 19, 2006
Basically I've been using Visual Studio 2005 for a few weeks now moving a Pocket PC project from 2003 to 2005. When I hit the Start Debugging Button every time until today the project would rebuild and deploy to my pocket PC allowing me to debug etc but now I get
The remote connection to the device has been lost.
Please verify the device conection and restart debugging.
I used to get this problem in VS2003 sometimes and just like the numerous posts on different sites that I've looked at the problem eventually goes away and I'm none the wiser. One guy said that he found that if he went to bed the problem was resolved when he came back!
My PDA running Windows 2003 2nd Edition is directly connected to my PC via a USB port. I've rebooted my PC and done a soft reset on the PDA but it didn't help. I'm using ActiveSync 4.1.
Does anyone know how to resolve this problem?
View 54 Replies
View Related
Mar 15, 2007
Hello, I'm running an MS SQL 2005 database which supports our entire website and it's fairly huge. I seem to have lost the sa password for the database.
I COULD get it back if there was a way to convert the SQL 2005 DB to an SQL 2000 DB, seeing as how I found a password cracker for that version. Is there anyway to convert a 2005 DB back to a 2000 DB?
Does anyone have any other ideas they might want to lay on me?
I'm kind of sick about this... I'm usually a really good note-taker; In fact, I do have the sa password recorded in an IT database that I keep. Unfortunately the password just doesn't work. I've tried the caps lock and other variations, but the password just eludes me.
Thanks for your help,
Chris
View 4 Replies
View Related
Mar 15, 2007
Hello, I'm running an MS SQL 2005 database which supports our entire website and it's fairly huge. I seem to have lost the sa password for the database.
I COULD get it back if there was a way to convert the SQL 2005 DB to an SQL 2000 DB, seeing as how I found a password cracker for that version. Is there anyway to convert a 2005 DB back to a 2000 DB?
Does anyone have any other ideas they might want to lay on me?
I'm kind of sick about this... I'm usually a really good note-taker; In fact, I do have the sa password recorded in an IT database that I keep. Unfortunately the password just doesn't work. I've tried the caps lock and other variations, but the password just eludes me.
Thanks for your help,
Chris
View 10 Replies
View Related
Aug 18, 2006
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 1 Replies
View Related
Mar 25, 2008
Hi everyone, I am trying to upgrade a 2000 DB to 2005 with SSIS Database Transfer.
I finally got it to work with an online transfer but the destination database has no primary keys, indexes or identity columns from the source DB.
What am I missing?
What other ways are there to upgrade a SS2000 DB to 2005?
Thank you.
View 4 Replies
View Related
Jan 19, 2007
Most of our sql servers ar still sql 2000. Our programmers created many sql 2000 database diagrams using EM. But they can not access them under sql 2005. (They now have only sql 2005 tools installed on their boxes.)
Question: can we reinstall the sql 2000 client tools on their boxes without affecting the current sql 2005 install on their boxes?
Question: is there any workaround negating the need to ihstall the sql 2000 client?
TIA,
barkingdog
View 1 Replies
View Related
Dec 1, 2005
P4 2.8G Hz, 512 M RAM.thanks.
View 3 Replies
View Related
Mar 4, 2006
I installed the evaluation version of SQL Server 2005 and now my DSL connection on Windows XP is all fouled up; I'm using Server 2003 at the moment. Will uninstalling it get rid of the problem? First Oracle eats my DSL connection, now SQL wants a piece! :eek:
View 4 Replies
View Related
Jan 17, 2007
Hello,
Hope anyone in here can help.
I have tried to install the SQL Server 5 Express, but can't seem to get it to work properly.
I got a terrible name set as default for my database, as well as a terrible name for my username.
I can't find a place to change this to something more manageable.
It is further set to windows auth, but trying to set it to both, and trying a username (and password) always gives me a log in error.
I've tried searching all over the net and in here for a simple tutorial, but can't seem to find one that helps me more than it confuses me.
*****
The second part of the problem is that I have a java program which I want to connect to the database and use the tables in it, but I am at loss to how I can find what username (and password) I am supposed to have, what "url" it needs etc.
I have the jdbc driver so that part should work, I can successfully log to other mssql databases (at work/school), but not my own.
Hope you can help, and thanks in advance.
View 3 Replies
View Related
Mar 30, 2007
Hi.I just downloaded and installed Sql 2005 from the MS site.I see that my instance of Sql 2000 is still on the same computer.I assumed that Sql 2005 would upgrade but it didnt. Should Isimply delete my instance of 2000 or will this cause complications?Sorry - newbie question.
View 1 Replies
View Related
Nov 6, 2007
I installed SQL 2005 developer edition in vista business OS with SP2. it is working fine now i want to install SQL 2000 standard edition. when i am putting SQL 2000 CD into my system it is not run even setup.exe not working.
Thank You.
View 5 Replies
View Related
Aug 3, 2006
Most of the posts here for co-existence of sql 2005 and sql 2000 are for upgrades to 2005 or installing sql 2005 on a box already having sql 2000. This is a bit different..
I have an application installed on sql 2005 sp1, on a default instance, no other instances installed. Because of issues the application is having with sql 2005, the vendor is recommending install of sql 2000 on the same box ('should not have any problems' they say), then script out the user databases in SQL 2005 and back in to the sql 2000 instance.
Has anyone tried this (installing sql 2000 after install of sql 2005) or can point me to an article about it? I've googled around and searched the knowledgebase to no avail.
thx
View 4 Replies
View Related
Mar 1, 2007
My dev. machine already has SQL Server 2005 (sp2) installed.
Can I install SQL Server 2000 on this machine as well (as a named instance) ? Or does 2000 need to be installed before 2005 ?
Thanks.
View 2 Replies
View Related
Oct 5, 2006
Have app that will only run on Sql 2000, am currently using MSDE, we have outgrown and need to upgrade to 2000. I purchased SQL 2005 open license, I was told that 2000 wasn't availabe and that I could intall SQL 2000 from the 2005 cd's I received. How do I do this? They sent me all the 2005 cd's and SP4 for SQl 2000. I installed 2005 but did not see any way to roll back to 2000.
View 1 Replies
View Related
May 21, 2007
I have a user that says that after she installed the ActiveX control for printing, that she can no longer export the reports. Has this happened to anyone else? What settings do I need to check on her machine to fix this problem?
View 2 Replies
View Related
Aug 3, 2007
I have a server which has SQL 2005 express edition supporting web application.
My question is Can I install SQl 2000 along with it ?
Are there any known issues. If yes, how to resolve them ?
Thanks
View 3 Replies
View Related
Apr 7, 2008
I have a sql express .mdf that is located in c:appdirectorymydb.mdf whilst developing an application. During development my connection string uses the above path to connect to the db. e.g.
"server = .sqlexpress; Integrated Security=True; database=C:appdirectorymydb.mdf"
I have published the app using click once in visual studio.net which places the db in : C:Documents and Settingsuser.nameLocal SettingsApps2.0DataJN1WL1DJ.X7B ... 08ed2810aab2abData
When i am executing the application following a clickonce install, what should I use in my connection string for the path to the db ? or where can I find the above path (e.g. in the registry) so that I can provide it to the connection string ?
Alternatively, can I specify where the DB is going to be installed (via click once). e.g. in my app directory under program files ?
I have tried searching what seems like everywhere for a solution to this problem and as a last resort thought it worth posting the question.
Many thanks in advance.
Simon
View 1 Replies
View Related
Dec 27, 2007
I'm trying to remember how to install the SQL 2000 client tools onto a SQL 2005 server. There are a couple of bizarre steps that will allow this to happen, but I can't for the life of me remember what comes after the unicycle down the stairs with the umbrella stand of machetes.
Can anybody remember the magic, or do I resort to using VPC to kludge the install until I can find my clay tablets again?
-PatP
View 5 Replies
View Related
Jul 25, 2007
Is it possible to install a 2000 instance on a 2005 server? Just install a named instance and install 2000 in a different directory?
View 5 Replies
View Related
Aug 17, 2006
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, analysis services. We do not want to disturb the existing sql 2000 setup.
I heard that reporting services are instance unaware application. Please let us know If I can install the sql 2005 on 2000 server.
Sankar N
View 5 Replies
View Related
Jan 4, 2006
I have a Cluster environment that has SQL 2000 Enterprise installed. I would like to install SQL 2005 Enterprise as well. What should I watch out for. Do I need to specify a named instance for the 05 install, setup is giving me the option and does see the 2000 instance? Is there a document that walks through this installation?
Regards
View 7 Replies
View Related
Oct 11, 2006
I now know only I can install both .Net 1.1 and 2.0 on one computerbut I don't know, Can I do it on SQL Server ? Please advise me....
View 8 Replies
View Related
Jan 18, 2006
Hello,
Sorry for my question, I know, that there were several topics about sql 2000 vs SQL 2005, I read all them but unfortunately I haven't got the correct answer. I must install my intranet application that uses asp.net 2.0 and SQL 2005 Express to a Windows 2003 server with SQL 2000. It is possible to install SQL 2005 Express beside the 2000 server? It is very important, because I have no possibility to test and that Win2003 server there are a few programs that use SQL 2000. What will happen with the 2000 databases and their programs if I install the 2005 Express to the server? They will work fine with 2000 and my application will work with 2005?
Or instead it should I configure my application to use 2000 capable connentionstrings?
View 3 Replies
View Related
Apr 21, 2008
hello, what is the general consensus on installing SQL 2005. I usually run a backup of SQL 2000 dbs and then restore on SQL 2005 and change compatibility to 9.0. Is it the right way to upgrade? I'm only asking because I also did one db in-place to SQL 2005 and thought it went well until I browsed my system dbs. All of them are missing tables that usually appear in SQL 2005 system dbs. Other than that I haven't run into too many problems.
View 3 Replies
View Related
Oct 17, 2007
hi there,
we have sql server 2000 installed on win server 2003 and now i want to install a fresh copy of sql server 2005 on the same machine without disturbing the existing state.
is it possible or is there any chance of system/sql server malfunction
suggestions please..
..gcnivas
View 1 Replies
View Related
Aug 10, 2007
Hello Everyone,
I'm trying to connect to Desktop SQL Server 2000 from Windows mobile PC Emulator (VS 2005). I need a direct connection using connection string to SQL Server 2000 through local wireless network without IIS.
Bellow is the code that I use. After executing this code I get an error on line Conn.Open(). Error says SQL Server does not exist or access denied.
SQL is un and running, and I can log in using SA username from the desktop. Even if I chance IP for another SQL server in my connection string I still get the same error. There is no firewall of any kind running.
Dim connectionSTR As String = "Persist Security Info=False;Integrated Security=False;Server=192.168.0.202,1433;initial catalog=MyDB;user id=sa;password=;"
Dim Conn As SqlConnection
Conn = New SqlConnection(connectionSTR)
Conn.Open()
If Conn.State = ConnectionState.Open Then
MessageBox.Show("Open")
End If
About my environment: SQL Server 2000 is running on Desktop PC with Windows XP SP2. Application which I need to connect to SQL Server is in Visual Studio 2005. I execute the application in Windows Mobile PC Emulator and try to connect to SQL Server from emulator.
Your advice and help is very appreciated
Thank you
Ika
View 3 Replies
View Related
Aug 7, 2006
Can the SQL 2005 install upgrade from SQL 2000 handle multiple instances?
View 1 Replies
View Related
Jul 28, 2014
everytime i run my query in mysql workbench the error is "lost connection in sql server".
View 4 Replies
View Related
Jun 15, 2006
I installed on a w2k/sp4 local machine SQLEXPRESS.
I copied the database also to the localmachine
With the sqlexpressmanager I attached the database. Everythinks looks fine.
I quit the manager, but then I start the manager again. Now the manager can't find the sqlserver.
Timeout Expired is the message.
Why is that? I installed SQLEDXPRESS on a lot of machines. No problems. But those machine the manager lost the connection after the first time.
thanks again.
klaas
http://www.planmatigonderhoud.nl
View 4 Replies
View Related
Jan 8, 2004
I have a SQL Server database that I connect a front end to using an ODBC connection. Our LAN folks upgraded the server recently and now I can no longer see any of the tables through the ODBC connection that the user used for login has permission in SQL Server Enterprise Manager to see - throught the ODBC connection the user can only see things like:
dbo.spt_datatype_info
dbo.spt_datatype_info_ext
dbo.spt_fallback_db
dbo.spt_fallback_dev
dbo.spt_fallback_usg
.
.
.
INFORMATION_SCHEMA.CHECK_CONSTRAINTS
INFORMATION_SCHEMA.COLUMN_DOMAIN_USAGE
etc.
I've tried deleting the user for the connection and re-establishing it with owner permissions. I've tried deleting the dsn and re-establishing that as well but nothing so far.
Please help!!!
View 9 Replies
View Related
Feb 8, 2006
Hi,I have a problem. When my computer loses connection toserver during transaction it is rolled back automaticlyby server after 2-5 minutes. During the time a can resetmy computer, run my program again and I can seedata from not commited transaction becouse I have toset isolation level to read uncommited.How to force the server immediately rollback transaction?TIAclint
View 1 Replies
View Related