Solved

sql server 2008 R2 Remote connection

Posted on 2011-03-11
2
468 Views
Last Modified: 2012-05-11
Just sign up a cloud with sql server 2008 R2. and try to remote access the database using Visual Studio 2008 Team Version.

I can' get connection. and also check the Security tab.
Server authentication is SQL Server and Window Auth. mode selected.
I don't know what else I need to do for connection...please help
0
Comment
Question by:Webboy2008
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 35114231
Are you sure that you have the correct instance name, IP/Name, ports, username/password?
0
 
LVL 13

Accepted Solution

by:
agarwalrahul earned 500 total points
ID: 35114237
I think first you need to install VS 2008 SP1 and other patches provided by Microsoft because the VS 2008 need those SPs and patches to coneect with SQL SERVER 2008 R2.

Reference:

http://blog.sqlauthority.com/2008/09/21/sql-server-2008-fix-connection-error-with-visual-studio-2008-server-version-is-not-supported/



0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question