How to connect to SQL Server DB remotely
Posted on 2010-11-09
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:
where 126.96.36.199 = 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!