cannot create a connection with VisualStudio 2008 and SQLServer 2008

[coltrane]

I have sqlserver 2008 installed on a windows xp server. I am trying to
connect to the database in visual studio. When I try to add a connection
the instance of the server is not found. I am able to view the database
using the SQL Server Management Studio.

any help would be much appreciated

john

[Rick Byham, MSFT]

Assuming VS and SQL Server are on the same computer, perhaps you are
attempting a TCP connection and the firewall is blocking it. But SSMS is
using shared memory and not going through the firewall.
--
Rick Byham, MSFT
(Implies no warranty or rights)

"coltrane" <tende...@yahoo.com> wrote in message
news:OLanH576...@TK2MSFTNGP05.phx.gbl...

[coltrane]

On 5/4/2010 4:18 PM, Rick Byham, MSFT wrote:
> Assuming VS and SQL Server are on the same computer, perhaps you are
> attempting a TCP connection and the firewall is blocking it. But SSMS is
> using shared memory and not going through the firewall.

I did try disabling the firewall and it didn't have any effect.
I am able to connect to the database using the management studio
provided in sqlserver 2008. This is getting really annoying!

thanks

john

[Edward C. Otto III, Esq.]

Check to make sure that SQL Server Express is NOT installed as the default
instance.
It can screw up EVERYTHING.

I ran into the same issue and Microsoft has a set of instructions available
for uninstalling SQL Express
for SQL 2005 that also work for 2008.

"coltrane" <tende...@yahoo.com> wrote in message

news:4be09929$0$31285$607e...@cv.net...