Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
GrandmaLewis
Starting Member
2 Posts |
 Posted - 2011-03-12 : 13:45:24
|
| Hello,Long story so please bear with me. I will get to my questions but I think you need the background. We use an accounting software package at the office that shipped with Sql 2005 and life was good. I could backup the database at the office, come home and restore the database and work, save the database and restore at the office the next day. Then we hired a consultant who updated our server to Sql 2008 and after that point I couldn't work at home for almost a year. I would get an error message that the Sql server was not compatible. That's not the exact words, but close enough for now.Fast forward a year and we have a new consultant who took an interest in my plight and he installed SQL 2008 express on my home computer. I could work at home but when I would attempt to restore the next day at the office, I was getting a compatibility error message again. This time it said I was trying to restore a SQL 10.50 file and the office version was 10.40. This week, the consultant removed Sql 2008 Express 10.50 on my home machine and reinstalled Sql 2008 Express 10.40 on my home machine so everything should be compatible now but it's not.I can't get the accounting software to reload on my home machine. I get an error message that readsSQL Server connection failedError Details:{Microsoft}{ODBC SQL Server Driver}{Shared Memory} SQL Server does not exist or access deniedI have the option of using Windows NT Authentication or SQL Authentication. The consultant left me with a text file that contains the login and password. I have tried setting up using both options and the login and password he left me, all with no success.Can anyone provide any insight or assistance.Thanks |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-03-12 : 20:50:53
|
| So, a bit of explanation first. SQL Server 2008 R2 is version 10.50 and SQL Server 2008 is version 10.0, and they are not the same version. You can upgrade a database to a higher version, but you cannot downgrade that database to a lower version.So, taking a database from 2005 to 2008 or 2008 R2 will work. Going from 2008 R2 to either 2008 or 2005 will not work.I am not aware of a 10.40 version, but that could be a later service pack to 2008. It definitely is not a 2008 R2 version which is why you were having problems.Now, as long as the versions are the same - you should be able to backup/restore or detach/attach the database. It sounds like that is the case, but now you are having issues with accessing the database.The error that you are getting either means you are trying to access the server with the wrong name, or the service is not currently running. To identify this, go to Programs | Microsoft SQL Server 2008 | SQL Server Configuration Manager. When that opens, find the services that are installed and running. You should see your database engine in there and determine from that whether or not it is running. If it is running, then find the name and make sure you are using that name for the connection.For example, the server name should look something like 'SQL Server (InstanceName)'. Identify the instance name and connect to that instance using either {hostname}\{instance name} or you can use .\{instance name}.Jeff |
 |
|
|
GrandmaLewis
Starting Member
2 Posts |
Posted - 2011-03-12 : 21:56:05
|
| Thanks for the explanation Jeff, that is exactly as I understood it but couldn't say it correctly, hence the drawn out explanation.From poking around on my machine, I think the didn't completely uninstalled 2008 R2. I've talked with someone who is wiser than I and he suggested I wipe all instances of SQL and start over. So that's what I am in the process of doing. He told me to search for a removal tool, so if you know of a good one, please send me a link.Thanks |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-03-13 : 12:44:29
|
| When it was available - I used msizap.exe which worked very well. However, it is no longer available as a single download and you would have to download the full SDK to get it.Hopefully, you won't need to go that far. If you can get everything removed with Add/Remove you should be fine and then you will be able to install the correct version. When you are ready to install - you will want to identify the exact version on your office system.To do that you are going to need to connect to SQL Server using the management studio. If you do not have the management studio, you can search microsoft for SSMS Express. Once you have that (if you don't already), then you can open a new query window and connect to your office instance and get the version using: SELECT @@VERSION.Using that information, we can then identify which version you have installed in your office (e.g. 10.0.xxxxx). The other numbers will tell us what patches have been applied, so you can then apply those patches on your home system.Don't worry, as long as you have the major version correct - you will still be able to work with the database. However, I always recommend keeping the versions the same in these scenarios.Jeff |
|
|
|
|
|
|
|
|
Installing SQL Express 2008 and accounting softwar