Can we access SQL Server 2008 R2 Database Engine with other ManagementStudio ?
in [Server Configuration]
|
Prev: Alternative to Ms sql server 2005 express edition
Next: Select TOP on SQL 2005 slower than select full
From: Patrick on 12 May 2010 04:55 I just install SQL Server 2008 R2 Database and try to access from other machine with SQL Server 2005 / SQL Server 2008 Management Studio but not successful. I would like to know whether it is possible to access SQL Server 2008 R2 database via previous release client ? I have started SQL Browser and enabled all Network Protocol, is there anything being missed out ? Thanks
From: Patrick on 13 May 2010 05:52 Dear John and Andrew, Thanks for your advice. I have installed SQL Server 2008 R2 Enterprise on a Windows 7 machine. However, I check the system requirement and find that Windows 7 doesn't support it. In this way, I install it on a Windows 2003 Server. I am able to connect it via Management Studio from other machines. Regards, Patrick On 13/05/2010 12:33 AM, John Bell wrote: > On Wed, 12 May 2010 18:55:22 +1000, Patrick > <Patrick(a)discussions.microsoft.com> wrote: > >> I just install SQL Server 2008 R2 Database and try to access from other >> machine with SQL Server 2005 / SQL Server 2008 Management Studio but not >> successful. >> >> I would like to know whether it is possible to access SQL Server 2008 R2 >> database via previous release client ? I have started SQL Browser and >> enabled all Network Protocol, is there anything being missed out ? >> >> Thanks > > > Hi Patrick > > You don't say what the error is! Have you tried SQLCMD that should > rule out if there are protocol/netowkr issues. > > John
From: Patrick on 13 May 2010 17:29
I cannot recall the exact wording but it says cannot connect to the SQL Server Instance as it is not reachable and ask me to make sure that Name Pipe protocol to be opened. Before checking the system requirement, I also guess whether it is a Firewall Problem. I have disabled Firewall but still cannot get through. Regards, Patrick On 14/05/2010 6:04 AM, John Bell wrote: > On Thu, 13 May 2010 19:52:32 +1000, Patrick > <Patrick(a)discussions.microsoft.com> wrote: > >> Dear John and Andrew, >> >> Thanks for your advice. >> >> I have installed SQL Server 2008 R2 Enterprise on a Windows 7 machine. >> However, I check the system requirement and find that Windows 7 doesn't >> support it. >> >> In this way, I install it on a Windows 2003 Server. I am able to >> connect it via Management Studio from other machines. >> >> Regards, >> Patrick >> >> >> On 13/05/2010 12:33 AM, John Bell wrote: >>> On Wed, 12 May 2010 18:55:22 +1000, Patrick >>> <Patrick(a)discussions.microsoft.com> wrote: >>> >>>> I just install SQL Server 2008 R2 Database and try to access from other >>>> machine with SQL Server 2005 / SQL Server 2008 Management Studio but not >>>> successful. >>>> >>>> I would like to know whether it is possible to access SQL Server 2008 R2 >>>> database via previous release client ? I have started SQL Browser and >>>> enabled all Network Protocol, is there anything being missed out ? >>>> >>>> Thanks >>> >>> >>> Hi Patrick >>> >>> You don't say what the error is! Have you tried SQLCMD that should >>> rule out if there are protocol/netowkr issues. >>> >>> John > > You haven't told us the exact error. Did you try SQLCMD? Have you > checked there isn;t a firewall blocking the ports being used > ? > John |