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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SQL 2005 and VS 2005 Problem

Author  Topic 

BigMeat
Yak Posting Veteran

56 Posts

Posted - 2008-01-03 : 02:52:04
Hi

I recently moved over to running windows Vista, I installed VS 2005 and then installed SQL Server 2005 and it seems that the mamanmegment studio has not installed for SQL Server. I think it has something to do with SQL Express that is installed with VS 2005.

Does anybody have any ideas how i can get round this? I think I need to do something at the command prompt when i install it.

Many thanks in advance

KenW
Constraint Violating Yak Guru

391 Posts

Posted - 2008-01-03 : 14:08:37
quote:
Originally posted by BigMeat

Hi

I recently moved over to running windows Vista, I installed VS 2005 and then installed SQL Server 2005 and it seems that the mamanmegment studio has not installed for SQL Server. I think it has something to do with SQL Express that is installed with VS 2005.

Does anybody have any ideas how i can get round this? I think I need to do something at the command prompt when i install it.

Many thanks in advance



SQL Server Management Studio (SSMS) is a separate product from SQL Server 2005, and therefore has to be downloaded and installed separately. If you're using SQL Server 2005 Express, just download SSMS Express and install it. You can find it on the Microsoft web site (sorry, don't have the URL handy).
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-01-03 : 23:09:50
SSMS comes with sql2k5, but you need download SSMSE separately for sql2k5 express. By the way, can use ssms to manage sql2k5 express.
Go to Top of Page

BigMeat
Yak Posting Veteran

56 Posts

Posted - 2008-01-03 : 23:42:30
The problem I have is that I dont really want SQL server Express as it is messing up my full blown SQL Server Instalation

Go to Top of Page

KenW
Constraint Violating Yak Guru

391 Posts

Posted - 2008-01-04 : 16:05:18
quote:
Originally posted by BigMeat

The problem I have is that I dont really want SQL server Express as it is messing up my full blown SQL Server Instalation




Then uninstall SQL Server Express, and install SSMS from the SQL Server 2005 CD.
Go to Top of Page
   

- Advertisement -