cannot create a connection with VisualStudio 2008 and SQLServer 2008

#1

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

#2

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" <tendengarci (AT) yahoo (DOT) com> wrote

Quote:

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

#3

On 5/4/2010 4:18 PM, Rick Byham, MSFT wrote:

Quote:

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

#4

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" <tendengarci (AT) yahoo (DOT) com> wrote

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

cannot create a connection with VisualStudio 2008 and SQLServer 2008

microsoft.public.sqlserver.connect microsoft.public.sqlserver.connect

cannot create a connection with VisualStudio 2008 and SQLServer 2008 - 05-04-2010 , 02:16 PM

Re: cannot create a connection with VisualStudio 2008 and SQLServer 2008 - 05-04-2010 , 03:18 PM

Re: cannot create a connection with VisualStudio 2008 and SQLServer2008 - 05-04-2010 , 05:01 PM

Re: cannot create a connection with VisualStudio 2008 and SQLServer 2008 - 05-08-2010 , 12:38 PM