SQL Server 2005, SSMS and Vista

[BoulderBum]

Has anyone been able to get SQL Server 2005 up and running in Vista?

I just started to try, and I can't seem to connect to my database with SSMS. My local database doesn't show up in any dialog (only the Integration Services service does), though the SQL Server Configuration Utility shows that the database server is running fine.

MCP, MCTS - .NET Framework 2.0 Web Applications

 

[onpnt]

Have not tried it but I belive it is only supported with SP2 installed on SQL Server

[sub]____________ signature below ______________
The worst mistake you'll ever make is to do something simply the way you know how while ignoring the way it should be done[/sub]

 

[BoulderBum]

I have the SP2 CTP installed is the thing.

MCP, MCTS - .NET Framework 2.0 Web Applications

 

[SQLBill]

Bolding is mine for emphasis...

Installation Requirements
All editions of SQL Server 2005 Service Pack 2 (SP2) can be run on Windows Vista Release Candidate 1 (RC1) or the Beta 2 release of Windows Server "Longhorn." This configuration is not supported in production environments. We recommend that you run SQL Server 2005 SP2, when it becomes available, on Windows Vista and Windows Server "Longhorn" only in test environments. You must first install the full release version of SQL Server 2005 before you can apply SP2.

http://www.microsoft.com/sql/howtobuy/windowsvistasupport.mspx

http://www.microsoft.com/sql/howtobuy/sqlonvista.mspx

My understanding of the links is that ... you can only use the 2005 Express Edition w/SP1 on Vista. You need to wait until the RELEASE version of 2005 SP2 is available for the other versions to work with Vista. 2005 SP2 CTP is not supported on Vista.

-SQLBill


Posting advice: FAQ481-4875

 

[mrdenny]

I've got SQL Managment Studio installed as well as SQL Express working with no problems.

Make sure that you allow access to SQL through the firewall.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com