Hi Tim,

If I remember right, in SQL Server 2008, all network protocols are off by default. I suppose this is done as an added security measure. You turn on only what you want. I'm not at my normal machine so I cannot check this exactly. But I believe there was an additional applet installed that should be available on your menu (where SQL Server is installed) that lets you manage the protocols and network connections. Maybe 'Protocol Manager' or something like that??

The only other thing I can think of is maybe windows firewall is blocking the port. 1433 is the default SQL Server port.

Guy


>Hi All,
>
>I installed a new instance of SQL 2008 on my SBS server as SQL2008 instance name. There is another install of SQL2005 installed there for some other purpose. I also have SQL2008 developer edition installed on my desktop machine. I am unable to connect SSMS from my workstation to the instance of SQL2008 on my SBS server. I am logged in and running SSMS but can't connect with any of the following:
>
>tcp:BTSMAIN\SQL2008
>np:BTSMAIN\SQL2008
>BTSMAIN\SQL2008
>192.168.101.10\SQL2008
>
>I have checked on the server under SQL Server 2008 Configuration Manager the protocols for named pipes and for tcp are enabled. I also see the checkbox for Allow Remote Connections was already checked. I also verified that SQL Browser is running on both my desktop machine and the server.
>
>What else do I check for to be able to establish a connection to this new instance?
>Thanks
>Tim