By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,984 Members | 1,045 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,984 IT Pros & Developers. It's quick & easy.

Install SQL 2008 and SSMSE 2008

P: 58
Can someone, anyone, help me, I am pulling my hair out trying to install SQL 2008. I am novice SQL and C# developer, my expertise being with RPG III. I have been using, on my development machine running under Windows 7 (64bit), SQL 2005 and SQL Server Management Studio Express. Everything was dandy until a few weeks ago when I could no longer access my database, I was getting error: “The database ‘database name’ cannot be opened because it is version 661. The server supports version 612 and earlier. A downgrade path is not supported.” I suspect I am getting this error because I foolishly accepted an offer from Microsoft to “Try Visual Studio 2010 Professional” and ever since then I get the error mentioned earlier. In my inexperience, and after digesting the error message, I thought OK, if I upgrade to SQL 2008 and SSMSE 2008, that will solve the problem. Being cautious I did not uninstall 2005 versions of the aforementioned, but I read somewhere that one could run both version on the same machine. After downloading and running the install programs, it seems to be thinking, progress bar moves along, dialog messages flash by, but it’s all smoke and mirrors, at the end of it nothing happens. I have SQL 2008 but no SSMSE 2008. What am I doing wrong?

Joe

PS Please forgive the “novel” above but I thought it necessary to give the complete picture.
Dec 13 '11 #1
Share this Question
Share on Google+
6 Replies


ck9663
Expert 2.5K+
P: 2,878
I have 2008 and 2005 in my workstation. They are both working fine. Though my automatic outlook connection is now failing. Can you try to open your sql2005, back it up and restore it in 2008?


Good Luck!!!

~~ CK
Dec 14 '11 #2

P: 58
Thanks CK, but didn't get a reply for some time and I got despearte and decided to uninstall everything and start from scratch. Managed to uninstall 2005 but can't get 2008 to uninstall. BTW doea one have to manually uninstall all the componenets of sql? Such as Microsoft SQL Server 2008 Data-Tier Application Framework,etc., etc., for example?
Dec 15 '11 #3

ck9663
Expert 2.5K+
P: 2,878
You don't have to if you use the SQL uninstall application. A window will show up asking you if you want all other components uninstalled, just click Yes.


Good Luck!!!


~~ CK
Dec 15 '11 #4

P: 58
I am using a C# program that was written for me to access my database. I recently downloaded Microsoft SQLServer2005_SSMSEE, which I installed successfully, however I am unable to access the database using the Management system, getting the “The database ... is not accessible” message. I am still able to access the database via the C# program. When I look at my profile I am the system administrator, so I am more than a little perplexed at my inability to access the database. Please be aware that I am not a “fundi” with respect to Microsoft systems, so with this in mind can anyone advice me on what I must do to make the database accessible.

Joe
Feb 22 '12 #5

P: 58
A reply to my previous question (see below) was to install SQL Server 2008. Been there, done that… the problem is that then my C# program doesn’t work, and I need my C# program. The programmer did not supply me with any source, and is not contactable, so I am stuck with it until I can re-write the whole system.

PREVIOU QUESTION
I am using a C# program that was written for me to access my database. I recently downloaded Microsoft SQLServer2005_SSMSEE, which I installed successfully, however I am unable to access the database using the Management system, getting the “The database ... is not accessible” message. I am still able to access the database via the C# program. When I look at my profile I am the system administrator, so I am more than a little perplexed at my inability to access the database. Please be aware that I am not a “fundi” with respect to Microsoft systems, so with this in mind can anyone advise me on what I must do to make the database accessible.

Joe
Feb 22 '12 #6

Rabbit
Expert Mod 10K+
P: 12,349
Your threads have been merged because they are all related.
Feb 22 '12 #7

Post your reply

Sign in to post your reply or Sign up for a free account.