Solved

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

Posted on 2013-10-22
1
407 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
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.

914 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now