Solved

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

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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

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…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
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.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

831 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