SQL Server, SQL Server Express, and SqlDataSource Control

Re: installing sql server management studio on 64 bit OS

integrasol — Sat, 27 Jun 2009 06:13:31 GMT

Check this out, http://blogs.msdn.com/sql_protocols/archive/2007/06/18/connecting-to-sql-server-2005-on-vista-and-longhorn.aspx

Re: installing sql server management studio on 64 bit OS

nb123 — Sat, 27 Jun 2009 05:59:50 GMT

ok,i was able to install SSMS.I had to turn UAC off for this to get installed however. i can connect to database engine using Windows authentication as long as UAC is off but if i turn it back on(which is vista default setting )it does not let me connect.Please help.

Re: installing sql server management studio on 64 bit OS

integrasol — Fri, 26 Jun 2009 05:59:26 GMT

SQL Server 2005 comes in both 32-bit and 64-bit versions for the Standard Edition, so I don't think that's the problem. Can you rerun the setup and add Management Studio, or is it not shown at all?

installing sql server management studio on 64 bit OS

nb123 — Fri, 26 Jun 2009 05:23:37 GMT

Hi,i have just installed Visual Studio 2005 standard edition(with SP1 update as reqd by vista) on Windows vista home premium edition 64 bit.

I tried to install SQL server 2005 standard edition from the CD.I noticed that it did NOT install the SQL server management studio.Currently all i see after install , under SQL server is MS sql server => cofiguration tools=>SQL server configuration manager and 3 other items.

Does it have anything to do with the fact that SQL server 2005 is 32 bit which i am trying to load on OS 64 bit?How do i install sql server 2005 management studio on my 64 bit vista machine?