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

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 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

Lost PHP Access To SQL Server...

Feb 15, 2008

Hi AllI am posting this in the hopes someone has come across the same issue and found a solution. The other day i uninstalled Microsoft ISA server 2000 from my SQL / Web server. Since then i have not been able to connect to the sql server via php. I changed the php config file and pointed it at another sql server i have up for development purposes that has a recent copy of the same db and everything works properly.The errors php is throwing at me show that it is not even able to find the server at all. I have changed it several times from both the netBios name as well as the actual ip and nothing seems to work.I should also note that other than the php access issue sql seems to be working perfectly for all other users in the office that are accessing it through the accounting system.System:Ms SQL 2000Windows Server 2003php 5 on IIS 6Any ideas?ThankspT

View 3 Replies View Related

Lost Access To My SQL SERVER !!!

Apr 5, 2004

Hello,
I have changed the account in which the Sql Server process run and not I cannot log into the server with any other user account (even if they are System Admin, DBO and Domain admin...) than the one which run the SQL process.

What can I do to gain back access (with the user accounts) ?

View 12 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

View 1 Replies View Related

Lost Server Registration! Cannot Access Databases!

Jun 13, 2002

I have a test server where I was experiencing security/rights anomalies. I tried disabling the BUILTINAdministrators account, closed SEM, and when I reopened it, I could not access my Server (all databases,etc.are on local machine). I thought I could just use the SQL accounts (sa, etc.) to connect, but they all fail?? I tried creating a new registration, and that didn't work either. Since I deleted the old registration, and I cannot reconnect, what are my options(short of restoring image)? If I re-install SQL will all my databases still be there? Is there another way to get access back?? Any help would be appreciated.

rob

View 3 Replies View Related

SQL Server Administrator And Local Administrator

Nov 22, 2005

Please help! I am new in SQL Server 2000 Administration. My manager had ask me to manage a SQL Server, but Windows Adminstrator refuse to give me Local Admin rights. I only have sa account to login to databases. I don't know any excuses or reasons to give to Windows Adminstrator so that he can give me the local admin rights. If any one have this answer, please help. Thank you.

-JC

View 4 Replies View Related

Add Administrator

Apr 16, 2007

Hi Everyone,

I am new to sql server. I would like to now how to add somebody as an administrator so that he/she can connect to my instances. what is the easiest way to do it>? thanks....

View 1 Replies View Related

Builtin/Administrator

Nov 19, 2001

I'm using Mix-Moded Authentication. Can I remove the Builtin/Administrator loggin ID without cause any harm to my current Login ID user(Windows NT user)? Are will removing Builtin/Administrator what harm will this cause to my server?

View 1 Replies View Related

MS Web Administrator And IE ... Not Working Right

Oct 1, 2004

Hey folks,

First ... want to applaud the creators/managers of this site. I have found almost all the answers I have had. However, got something new.

I am setting up Web Data Administrator from MS on a Windows 2003/IIS6 server connecting to our SQL 2000 boxes. The server has .Net 1.1 SP1. I have set this up on a Windows 2000/IIS5 server and it worked but was slow. It has .Net 1.1 and has been patched to SP1. When I got the new copy setup on IIS6, IE would not work with it but Firefox does. (I love the irony!) Going back to IIS5 copy, it doesn't work now in IE but it does in Firefox. Anyone else seeing this? Any ideas?

Thanks,
Jared

View 1 Replies View Related

Who Is Default Administrator

May 12, 2008

I just now installed sqlserver 2005 express.
I am connecting to it via oracles 'sqldeveloper' using sourceforge
jtds jdbc driver. I can connect to the server but I cannot logon probably because I dont know any user id or password.
I can't find any reference to the default uid/password in the server 'help'.

Does anyone know how to get started?

thanks
jim murray

View 5 Replies View Related

Administrator Rights

Aug 8, 2007

View 1 Replies View Related

Adding Another System Administrator

Aug 16, 2006

Hi all
I deleted the sa account
how do I add it with all the correct permissions (plus include it in all the tables )
TIA
Guy

View 1 Replies View Related

Can't Install SQL Web Data Administrator

Aug 26, 2006

Hi I am using Web Developer 2005 Express. I am trying to install the SQL Web Data Administrator (setup.msi), but it gives an error message saying that I need to install Framework 1.1, BUT I already have version 2, so no-go for me there. Also I have been trying to install the Cassini version with zero luck. When I run the build.bat file I get the csc and gacutil errors. However, when I set up the Environmental variable PATH within My ComputerPropertiesAdvancedEnvironmental Variablesuser Variables as per the instructions on the Cassini discussion forum, no change, I do not get 200 bucks or pass GO .Please tell me I am being stupid

View 1 Replies View Related

SQL Server Web Data Administrator

Mar 3, 2004

I've installed this on my server and I can control a SQL Database located on a remote server (networked together via Cross Over) but when accessing from the Web it keeps prompting me with a Windows Log In.

Does anyone know how I can prevent this so that the web page displays and we can enter our SQL information to log in using SQL Authentication.

Thanks.

View 2 Replies View Related

SQL Web Data Administrator Error

Mar 22, 2004

Hi

I am having problems getting the SQL wda running properly. I can get it working fine using Cassini server, but when I try to start it using IIS I get the following error:

_____________________

Server Error in '/webadmin' Application.
--------------------------------------------------------------------------------

Access is denied.
Description: An error occurred while accessing the resources required to serve this request. The server may not be configured for access to the requested URL.

Error message 401.2.: You do not have permission to view this directory or page using the credentials you supplied. Contact the Web server's administrator for help.

--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
_______________________

I can browse site on my localhost just fine - it just seems to be the web data administrator pages that are failing. Does anyone have any idea what I am doing wrong?

Thanks

gosatango

View 1 Replies View Related

MSDE And SQL Web Data Administrator

Aug 23, 2004

Hello all,

I am sorry for repeating the question in another section of the forum.

I am using "SQL Web Data Administrator" to manage the security and the roles issues in my database. I am using MSDE and i get to a point that i can not create grant statements in "SQL Web Data Administrator" manualy. I only was able to create some user accounts and giving them some roles automaticly"by clicking" without writtng grant statemnts. Clearly for me there was no place in the program to write grant statments. eg: in the graphical user interface of the "Sql Web Data Administrator" you can not restrict an access to some table in a database, but you can restrict access to a specific database for some users. Now, the question is : Is there any way to write grant permissions for some users using "Sql Web Data Administrator", or alternatevely, where can i wite any T-sql in my application and execute them.

Note:
I do not have Enterprise manager or sql analyzer.

please help.

View 7 Replies View Related

Cannot Login With Web Data Administrator

Oct 8, 2004

With Cassini web server, the hour glass stays on after I type in "sa" and password with SQL Login. Does anyone know how to resolve the issue?

With IIS, it simply displays the content of default.aspx as text. Are there some settings need to be changed?

My system is: Windows XP Professional with SP2.

Any help is appreciated.

Ching

View 3 Replies View Related

Sql Express And Web Data Administrator

Dec 4, 2004

Hi,
I have sucessfully used the Web Data Administrator on another machine using msde, but having trouble with sqlExpress. Can anyone help answer all or some of the following:

1- does the Web Data Administrator work with sqlExpress ?
2- I'm not sure I have sql server authenitication or windows authentication set for sqlExpress ? How can I check ? I need to have sql authentication.
3- I used to use access 2000 to manage/setup my sql server databases and found this the fastest and easiest method. Does access 2003 still have the same support for this ?
4- Is there anyone who knows when the free microsoft sql express admin tool will be available ? I think its called 'XS' or something.

any answers welcome.

View 1 Replies View Related

Web Data Administrator Error

Feb 17, 2005

Hi everyone on this forum,

I'm totally new to ASP.Net and I have some questions about it:

I have installed the Commerce Starter Kit on my computer. It works well. I can navigate through all the pages, I can add objects in the cart an d add users but... where are the database that are coming from those registering on my computer ????

Then why do I have this error message when I try to use web data administrator

Erreur du serveur dans l'application '/webadmin'.
--------------------------------------------------------------------------------

Accès refusé.
Description : Une erreur s'est produite lors de l'accès aux ressources requises pour répondre à cette demande. Le serveur n'est peut-être pas configuré pour accéder à l'URL demandée.

Message d'erreur 401.2.: Vous ne disposez pas des autorisations pour afficher ce répertoire ou cette page à l'aide des informations d'authentification que vous avez fournies. Contactez l'administrateur du serveur Web pour obtenir de l'aide.

--------------------------------------------------------------------------------
Informations sur la version : Version Microsoft .NET Framework :1.1.4322.2032; Version ASP.NET :1.1.4322.2032

I have seen other people on the forum who asked the same questions but no answer. So could you help me please, it's very important for my studies.

Finally, sorry if there are mistakes in my writing. As you can see, I'm from France.

Thank you for your replies,

Bye

View 1 Replies View Related

Stubborn Database Administrator

Oct 26, 2005

Hi,At my company we've got a stubborn database administrator who wants the SQL Server to be restarted each night. This has a performance-cause.Is it necesarry to restart the SQL Server regularly?With regards,ThaYoung1!

View 1 Replies View Related

SQL Server 7 Administrator Password Bug

Jan 13, 2000

I read in Computer Weekly (Jan 6th 2000) about a bug in SQL Server 7. This means that any user can get hold of the administrator (sa) password.

Does anyone know anything more about this ??

thanks
Paul

View 2 Replies View Related

Data Base Administrator

Oct 26, 2005

hello
any one could tell me about database administrator.
i want to connect oracle management server for import database of sql server 2000, i new the its
user : sysman
and also its password.
it is connected first time and i change its password
now i am trying to connect it but a msg is prompt

"VTK-1000 : Unable to connect to the management server (server name). please verify that you have entered the correct host name and the status of the oracle management server"

plz tell me as soon as possible......
i will be thanks for all....

View 1 Replies View Related

Reset Administrator's Password

Jun 12, 2000

i have one prod server and one standby i would like to have same logins on both can some one tell me how to update syslogins table in same order as source

View 2 Replies View Related

MSDE And Web Data Administrator

Dec 22, 2004

I have run setup for MSDE, and I have updated the setup.ini file to name the instancename to "blee" and set my SA password and added tag SECURITYMODE=SQL. Now I have also installed Web Data Administrator. When prompted for the login, password and server. I cannot login with my SA login and password that I set during install. Any suggestions?

View 1 Replies View Related

SQL Server Web Data Administrator

Mar 17, 2004

The SQL Server Web Data Administrator enables you to easily manage your SQL Server data, wherever you are. Using its built-in features, you can do the following from Microsoft Internet Explorer or your favorite Web browser:

1. Create and edit databases in SQL Server 2000 or Microsoft SQL Server 2000 Desktop Engine (MSDE 2000)
2. Perform ad-hoc queries against databases and save them to your file system
3. Export and import database schema and data
4. Manage users and roles
5. View, create and edit stored procedures

Whether you are doing Microsoft Windows or Web development, or just need remote access to data for yourself or your clients, the Web Data Administrator is the perfect complement to your toolbox.

So Get it HERE (http://www.microsoft.com/downloads/details.aspx?FamilyID=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en)

View 5 Replies View Related

Removing Built-in-Administrator

Jun 20, 2008

Hi,
I have created one login with windows authentication.
after that i have deleted the built-in-administrator login.
now i am not able to login thru windows authentication mode.
how to rectify it..
i have tried to create one new login with windows authentication mode..still i am not able to connect thru windows authentication.

View 5 Replies View Related

System Administrator Privilege

Jan 25, 2007

In SQL 2000, how do I grant system administrator privilege to "sa" or a Windows User?

View 3 Replies View Related

BUILTINAdministrators Vs System Administrator

Feb 13, 2007

Hello all,

does someone know where to find information regarding what is accesible to a BUILTINAdministrator which is not accesible to a System Administrator?

Somewhere I have read that a System Administrator can not see the "All users' folders (i.e. the collection of "My folder"s for all users of the Report Server) but I have also experienced a behaviour which has surprised me: as a System Administrator with all permissions I cann't even see folders that a BUILTINAdministrator can.

Does it mean that a System Administrator can not really manage all the resources of a Report Server?

Any ideas will be welcomed. Many thanks.

View 1 Replies View Related

Create DB Without Administrator Rights

Dec 18, 2007

Im working on a setup/deployment project where i have to attatch a database to sqlexpress.
The problem im faceing is that i cant use a Trusted connection as the user doesn't have administrator rights.
Is there a way of creating a user when sqlexpress is installed (this is done as administrator) that have the right to create/attatch databases to the sqlexpress instance?

What roles does that user need? Dbcreator is enought?

regards

View 7 Replies View Related