Solved

How to connect to SQL Server DB remotely

Posted on 2010-11-09
1
278 Views
Last Modified: 2012-05-10
I swear I've done this many times successfully before but for some reason have problems this go around.

I'm trying to connect to a remote named instance of SQL Server 2008 and keep getting a user login error.  This for for a SSRS portal I'm working with trying to setup a remote datasource on an internal SSRS portal.

I believe I have all the necessary ports opened up in the firewall of the SQL Server I am attempting to connect to and have the SQL Server configured for mixed mode auth, TCP, etc. etc.

To reference the SQL Server, I'm using:

99.99.99.99\SQLSERVER08,1433

where 99.99.99.99 = the IP address of my server.

The error I am getting is:

The login failed for user 'myusername'.

Yet, 'myusername' is setup in my SQL Server as a user and has permissions to access the DB.

There has to be something I'm missing!  Any other ideas on what's causing this hangup?  TIA!
0
Comment
Question by:dstjohnjr
[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
1 Comment
 
LVL 19

Accepted Solution

by:
elimesika earned 500 total points
ID: 34096479
HI

Did you enabled remote connections on the database server ?
If yes , follow :
http://social.msdn.microsoft.com/forums/en-US/sqldataaccess/thread/ec77d275-99c7-4cc0-b60d-707bde6f8c67/
0

Featured Post

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

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

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

734 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