Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Tools General

SQL server 2005 and VS

hi
i have a problem, how can i connect Visual Studio 2005 Professional to SQL server 2005 (SQLENT version), Visual studio is installed on my computer, where i have Windows xp Pro, and SQL server on my virutal machine where i run Windows 2003 server Enterprise Edition.
I tried already to connect but i'm getting the same error all the time, like: SQL server does not allow remote connection (error:40), although i allowed them from SQL surface area connection.

DO i have to install IIS on my hoste computer? I even tried to install both, VS and SQL server on one comp, but then VS asks to remove all previous installations of SQL server, and the other way arround...

Please help :)
thanx

[706 byte] By [jimmyglo] at [2007-12-17]
«« Local Search Problem
»» Problem using 3 timers at the same time.
# 1
It's definitely possible to install VS and SQL Server on the same machine. (After all, SQL Server was written using Visual Studio!) The versions have to be exactly the same though. Visual Studio 2005 RTM only works with SQL Server RTM and vice versa, regardless of where the server is located.

The error sounds like you haven't configured SQL Server to accept remote connections using the protocol that VS is using to connect. Make sure that you have enabled remote TCP connections (if that's what you are using) over the virtual machine's virtual network adapters.

StevenTwitchell at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Tools General...
SQL Server
SQL Server Tools General

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified