One Connection String for Multiple Users (VB)

J

jp2msft

We have one connection string to our SQL Server 2000:

"Data Source=WORKAPP;Initial Catalog=Parts_Data;Integrated
Security=SSPI;User ID=public;Password=public"

Everyone can connect to the database in our plant except for the Restricted
Users.

Why can't the Restricted Users access this? How can we get around it?

I can access the data, but I am set up as an Administrator.

Our managers can access the data, but they are set up as Power Users.

Most machines are Windows XP, but some use Citrix Servers and a few are
running Windows Vista. The OS does not seem to make any difference.

We do not want to grand Power User status to everyone, and we should not
need to with the correct connection string.
 
S

sloan

DO NOT MULTI POST.

Etiquette is to CrossPost to a few (frugal and germane) newsgroups.

I answered your question in the csharp group.

......................
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

One Connection String for Multiple Users (C#) 7
IPad Multiple Users 0
connection string variable... 2
Create a connection object (sql/oledb/odbc) based on connection method/string. 2
Passing LINQ a dynamic connection string 1
vb.net string value comparision 3
sql connection string multiple databases 6
SQL Connection help needed 6

Top