?
Solved

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

Posted on 2013-10-22
1
Medium Priority
?
429 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

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.

Question has a verified solution.

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

I have a large data set and a SSIS package. How can I load this file in multi threading?
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

743 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