Install SQL 2008 and SSMSE 2008

[Joe Campanini]

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.

[ck9663]

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

[Joe Campanini]

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?

[ck9663]

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

[Joe Campanini]

The database ... is not accessible

I am using a C# program that was written for me to access my database. I recently downloaded Microsoft SQLServer2005_S SMSEE, 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

[Joe Campanini]

It has been suggested that I use SQL 2008....

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_S SMSEE, 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

[Rabbit]

Your threads have been merged because they are all related.