Solved

sql server 2008 R2 Remote connection

Posted on 2011-03-11
2
423 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
2 Comments
 
LVL 39

Expert Comment

by:BrandonGalderisi
Comment Utility
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
Comment Utility
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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
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…

763 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now