si2030
asked on
Sql express Issues
Hi There,
Ok I have not been working on SQL and .NET for a couple of years. Well I want to reinstall SQL and in particular have the managment studio. I have no idea how to get it back. I have downloaded a number of "versions" but there appears to be no where to install or add the management studio... could someone help me get this up and running. I have a database I want to mount but alas alak I cant.
Kind Regards
Simon
Ok I have not been working on SQL and .NET for a couple of years. Well I want to reinstall SQL and in particular have the managment studio. I have no idea how to get it back. I have downloaded a number of "versions" but there appears to be no where to install or add the management studio... could someone help me get this up and running. I have a database I want to mount but alas alak I cant.
Kind Regards
Simon
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I would download from the link and, if prompted, just install client tools/management studio and none of the core database objects.
ASKER
Ok I have come back to the road block I ecountered before... there apears to be no where to actually include the management studio..
I also got a message about possible compatablity issues. I would have thought that this was the latest update and thus wouldnt need to require another upgrade to service pack 2....
I have include two jpgs to display my issues...
KInd regards
Simon
SQL-items-installed.jpg
Comaptablility-issues.png
I also got a message about possible compatablity issues. I would have thought that this was the latest update and thus wouldnt need to require another upgrade to service pack 2....
I have include two jpgs to display my issues...
KInd regards
Simon
SQL-items-installed.jpg
Comaptablility-issues.png
ASKER
Install and then apply the SP1 update to the database and ssmse.
ASKER
Hi there,
Well I downloaded SP1 and took the option to add features. Well the management studio is not available or even exists on this screen. (see file attached)... So I have tried SP1 SP2 and in none of the instances does the management studio display... what can I do now..
Kind Regards
Simon
options-with-SP1.png
Well I downloaded SP1 and took the option to add features. Well the management studio is not available or even exists on this screen. (see file attached)... So I have tried SP1 SP2 and in none of the instances does the management studio display... what can I do now..
Kind Regards
Simon
options-with-SP1.png
ASKER
Any idea on this?
can you see if you have the following path?
C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSSh ell\Common 7\IDE\Ssms .exe
or an equivlalent
or do a file search for ssms.exe
C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSSh
or an equivlalent
or do a file search for ssms.exe
ASKER
I dont know why it didnt want to install but in the end I downloaded the option with advance services... in effect everything. I then uninstalled everything that had SQL in the heading... I then reinstalled. this time I got the option for Management Studio Express and included it.
It installed fully and correctly except for an error right at the very start.
"An error occured creating the configuration section handler for user settings/Microsoft .SQLServer.configuration.L andingPage .Propertie s.Settings : Could not load file or assembly........so on"
Anyway I decided to push on and it worked...
Thanks to those that took the time to help. Simon
It installed fully and correctly except for an error right at the very start.
"An error occured creating the configuration section handler for user settings/Microsoft .SQLServer.configuration.L
Anyway I decided to push on and it worked...
Thanks to those that took the time to help. Simon
ASKER
Simon
SQL-items-installed.jpg