SQL server 2008
-
Hi, I have install SQL server 2008 on my computer ,i have already SQL server 2005,now problem is that i am not able to connect it through enterprice manager. N!dh! :)
Most likely the SQL Server 2008 is named instance so you should provide the server name as: machinename\instancename. You can check the instance name for example from Windows Services.
The need to optimize rises from a bad design.My articles[^]
-
Most likely the SQL Server 2008 is named instance so you should provide the server name as: machinename\instancename. You can check the instance name for example from Windows Services.
The need to optimize rises from a bad design.My articles[^]
-
so if you specify that to server name, what happens? Do you get an error and if you do, what kind of error.
The need to optimize rises from a bad design.My articles[^]
-
Error is: This version of MSSMSE can only be used to connect to sql server 2000 & 2005 N!dh! :)
Ok, that's the problem. You just have to use newer SQL Server Management Studio. You can download version 2008 from here: http://www.microsoft.com/downloads/details.aspx?FamilyID=7522a683-4cb2-454e-b908-e805e9bd4e28&DisplayLang=en[^]
The need to optimize rises from a bad design.My articles[^]