Solved

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

Posted on 2013-10-22
1
411 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
1 Comment
 
LVL 11

Accepted Solution

by:
John_Vidmar earned 500 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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

828 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