?
Solved

Remote Desktop and SQL Server 2008R2 connection using TCP/IP

Posted on 2013-10-22
1
Medium Priority
?
440 Views
Last Modified: 2013-12-06
Hello. I have a client running SQL Server 2008 R2 Express on Windows 2008 R2 Standard who has multiple external users accessing an application using remote desktop. The application they need to access is installed in C:/Users/Public and uses ODBC with a TCP/IP connection. The multiple users will use a shortcut on their desktop to access the application in the Public folder. This is working fine for administrative users and one standard user. The problem is a second standard user. I have an ODBC entry for them on the User tab, it connects to the database just fine when I test the connection through ODBC administrator. However, when this login accesses the application via a shortcut, I get an error message as: "The server does not exist .. [DBMSPLCN]". Since the direct ODBC connection is working, I don't know error code details (eg.17 or 53 or 6) The SQL Server implementation uses TCP/IP, I've run clicnfg.exe under this user's login (though, as it's the same computer, not sure what that would accomplish). I've made SQL Server use port 1433 and bypassed SQLBrowser by setting a direct port connection to 1433 for this user. This user login can run the application fine if they're promoted to an admin (as for an install running the app directly). The client uses ActiveDirectory, but I'm not sure to what extent. This seems like a permissions problem, but I don't know what would make one standard user different from another. Any suggestions?
0
Comment
Question by:LynneV
[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 11

Accepted Solution

by:
John_Vidmar earned 2000 total points
ID: 39669509
Using Microsoft SQL Server Management Studio, within the Object Explorer for that database, there is Security.  This list may contain users and/or active-directory groups.  If users only and they are missing then add the user.  If active-directory group is present then add them as a member to that active-directory group.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

650 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