Looks like you may be using a 3rd-party app to connect. The above image shows "MS-Access Workgroup" - so, if you are connecting via 3rd party, be sure and double-check your ODBC settings (System DSN) and drivers - since your interface probably requires SQL ODBC driver to make the connection. "Start," Control Panel, Administrative Tools, "Data Sources (ODBC)". Double-check "Drivers" tab that SQL Server is listed, and then check the "System DSN" tab and, as may be necessary, create your ODBC credentials to connect to your database.
On the "System DSN" tab, choose "Add," then make sure "SQL Server" is chosen, click Finish and it will take you to the "Create a New Data Source" area, enter a DSN name, Description and Server Name, then "Next."
On that 'next' screen, you choose either "SQL Authentication" or "Windows Authentication" and then, as necessary, enter any UserID & Password that will be used to make the connection. That's pretty much it.
Also, you can easily check remotely to see if you have access to the SQL instance on that sever:
sc \\lxi249 query | find/I "sqlserver ("
Reference my wiki for more info on that, if you want.
The above command should return something like:
DISPLAY NAME: SQL SERVER (MSSQLSERVER)
I hope I was helpful.
Please remember to Mark as Answer if I was able to help resolve your issue. Thanks!
- Edited by TNJMAN Tuesday, October 08, 2013 6:02 AM more detail