Cannot Access DB As A Non-administrator

Sep 27, 2006

Hello,
I use SQL Server 2005 Express and VB.Net for my client server application. From a client machine, if the user is logged on as Windows Administrator, my application connects to the database server just fine. If the client is logged on as a non-administrator, then my app cannot connect. Here is my connection string:

"Server=ServerNameSQLEXPRESS;Database=DBName;Trusted_Connection=True;Connection Timeout=30"

I use TCP/IP.

How can I fix this? Any help will be appreciated.

View 5 Replies

Administrator Access Lost

Aug 9, 2007

Hello,

I seem to have lost the ability to access the site settings as well as any security tabs and modify the properties under the directories etc...somehow i have lost administrator access , how do i get this back? I am still local administrator of the server reporting services is running on...only thing i can think off that could of done this is i installed Sharepoint onto the same machine and created a sharepoint site...are there things i can check in IIS or RS or etc to get this admin access back

thanks

View 2 Replies View Related

Only Able To Access Report Manager As Administrator

Sep 12, 2007

Hi,

I have Reporting Services set up with the permissions (via Right Click Server/Permisions in SSMS or System Role Assignments in Report Manager) set as follows:

BUILTINAdministrators - System Administrator

When logged in as an administrator I am able to access Report Manager, no problem.

However, I want to add a new group so that non-administrators can access Report Manager. However, whatever new item I add in the permissions appears to have no effect. For instance, if I add a permission for Users, i.e. :

BUILTINAdministrators - System Administrator
BUILTINUsers - System Administrator

I can still only access Report Manager as an administrator.. Any other user just gets the blank page.

I have tried creating a custom group, Report Users, with the same result.

I checked IIS to ensure anonymous access was turned off (this was an issue I had earlier on in my setup - it was turned on, but is now firmly off).

I don't know much about IIS, but I guess the problem is there somewhere. Does anybody have any idea what the problem could be and how I get around it?

Thanks very much in advance

Andy

View 7 Replies View Related

Slow Access Unless Administrator Account

Jun 27, 2006

We have an issue with accessing SQL Server 2000 where the access of data from the database is slow unless the user is logged in as an administrator to their computer.

The system is as follows: SQL Server 2000 on a W2K server. Users logging into a Win 2003 domain server. Users using W2K on their workstations. Application is VB.NET using the Enterprise Library Data Block, connection pooling ON, and windows authentication.

We are assuming that the issue is down to one of authentication and that when a user is set as an administrator then they have instant access. We have been able to replicate the issue using just SQL server on a W2K workstation and accessing from another W2K workstation. Again data access is way slow unless the account is an administrator.

Glad of any ideas folks!

Kind Regards

Ian Logan

View 10 Replies View Related

Restricting Computer Administrator Access To Named SQL Instance

Jan 18, 2008

This is a slight re-stating from an older thread, which I think warrants some new discussion. The answer has always been that system administrators should have full access to everything on a system, including databases.

Although that is a logical position for internal IT departments it doesn't quite fit the model of systems with outsourced or external system support.

"If you don't trust your DBA, then you need a new DBA. They are in a position of authority for a reason and restricting that authority makes it impossible for them to do the job they are hired to do."

What about scenarios where you have local machine administrators that should NOT be given access to private data in a secured database, even though they need to be able to access and maintain everything else? And unfortunately some regulations are written about access to stored data whether encrypted or not...

In the modern world of Sarbanes-Oxley and PCI-DSS/CISP it is no longer so cut and dried. Especially where companies have software/hardware support contracts with third parties that require administrative access to other aspects of the systems.

So accepting that you might need someone to have administrative level access to the box but they should not be able to view the contents of a database installed on that box, what would you do?

Is there a way to create an adminstrative group that does not allow access to a specific named instance of SQL?

Is there a way to revoke access for one member of the administrators group only?

Thanks,
Ted

View 6 Replies View Related

Domain Administrator Vs. Local Administrator Group

Jul 16, 2002

We are trying to set up SQLAgent Proxy account. If the SQLServer service id is a domain admin, do we still have to add it to the local administrators group?

Jeff