Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 284
  • Last Modified:

How to connect to SQL Server DB remotely

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
dstjohnjr
Asked:
dstjohnjr
1 Solution
 
elimesikaCommented:
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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now