[dba-SQLServer] VS cannot connect to SQL Server 2005

Hi Francisco

That is SQL Server.
However, I managed to get it working. I started from the Configuration Manager the SQL Server Browser and that made a difference.

By the way, SQL Management Studio defaults to a packet size of 4096 while when you create connections from within VS the default is 8000. 
Do you know what is to prefer and must these match?

/gustav


>>> fhtapia at gmail.com 17-03-2009 22:24 >>>
What is the authentication you are selecting for VS2008?

-Francisco
http://sqlthis.blogspot.com | Tsql and More...


On Tue, Mar 17, 2009 at 10:46 AM, Gustav Brock <Gustav at cactus.dk> wrote:

> Hi all
>
> Any idea why my VS2008 cannot connect to a SQL Server 2005 Express on a
> remote machine? Plenty of reasons, I know, except from the fact that I from
> SQL Management Studio also on my workstation nicely can connect to that
> server:
>
> Microsoft SQL Server Management Studio Express
>  9.00.4035.00
> Microsoft Data Access Components (MDAC)
>  2000.085.1132.00 (xpsp.080413-0852)
> Microsoft MSXML
>  2.6 3.0 4.0 5.0 6.0
> Microsoft Internet Explorer
>  7.0.5730.11
> Microsoft .NET Framework
>  2.0.50727.3082
> Operating System
>  5.1.2600
>
> ---
>
> Microsoft Visual Studio 2008
> Version 9.0.30729.1 SP
> Microsoft .NET Framework
> Version 3.5 SP1
>
> Installed Edition: Standard
>
> Targe .Net in the solution is 2.0.
>
> /gustav