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 RepliesWe 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
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
I would like to remove the BUILTIN/Administrators group from SQL Server in
order to prevent NT Administrators from having SQL sysadmin authority.
Does anyone see any harm in doing this eg. could it affect future SQL Server
upgrades if this group no longer exists?
Any help would be appreciated.
Regards,
Ian Brennan
BT (UK)
Is there a synonym for the group BUILTINUsers which can be used for GRANT ... TO and sp_grantlogin/sp_grantdbaccess, but which will work on localized computers?
I have a number of automated unit tests I wish to run on two different computers. The process involves recreating a database if it does not exist and then granting access and privileges to the BUILTINUsers group.
The problem is that one computer is installed with a Swedish Windows XP Professional (the users group is called BUILTINAnvändare) and the other is an English WinXP MCE (the group is called BUILTINUsers) so I cannot easily script this.
An alternative is to be able to retrieve the respective name through a .NET class or the Windows API.
Is any of this possible?
Thanks,
Johan
I have this posted in the VFP section of the forums but the more I find out about the issue the more I think there is an SQL Server security issues.
What I am doing is trying to connect to a LinkedServer of my SQL Express 2005 database running on windows vista. I have the linked server set up to connect to a local FoxPro table using the VFPOLEDB provider. If I log in as the 'sa' account I am able to do my query. But if I log into the server using a trusted connection it doesn't work. I get the error [The OLE DB provider "VFPOLEDB" for linked server "sys" reported an error. The provider did not give any information about the error.]
So I went in and set the BUILTINUser login as the sysAdmin. I also made sure that all of the security settings in SQL server were set up the same between the trusted user and the 'sa' user.
My question is, What am I missing? Is there something that I need to set on windows or is there a setting in SQL server?
Roles Table:
RoleID, RoleName
<RoleID1>, Allow_ClientFolder
<RoleID2>, Allow_ClientReportA
<RoleID3>, Allow_ClientReportB
<RoleID4>, Allow_CompanyFolder
<RoleID5>, Allow_CompanyReportA
<RoleID6>, Allow_CompanyReportB
UsersInRoles Table:
UserID, RoleID
<UserID1>, <RoleID1>
<UserID1>, <RoleID2>
<UserID2>, <RoleID4>
<UserID2>, <RoleID5>
<UserID2>, <RoleID6>
<UserID2>, <RoleID1>
<UserID2>, <RoleID3>
e.g.
when the <UserID1> clicks on the "home" link show only "Client" folder and when <UserID1> clicks on the "Client" folder only "ClientReportA" will show.
Here is the accessable map for each user:
<UserID1>
Client
ClientReportA
<UserID2>
Client
ClientReportB
Company
CompanyReportA
CompanyReportB
Question:
What is the best way to implement CheckAccess? At first I thought I can access the item names and I can test authorization through that, but AceCollection contains operation permission of the accessing object.
We have a development server and someone went ahead and deleted the BuiltinAdministrators account in SSRS 2008 R2. I would like to know if, as a local admin of the server, I can recover content manager access to the SSRS instance.
View 2 Replies View Related
I need to prevent domain and local administrators from having full control over our report manager. (I want them to be assigned permissions just like everyone else, some reports they can see other reports they can not.)
How can I accomplish this? I tried going into Report Manager -> Site Settings -> Configure Site Wide Security and re-assigning BUILTINAdministrators to the System User role instead of the System Administrator role. (A different set of report manager admins was given the system administrator role).
However, it appears that members of the BUILTINAdministrators group still have full control in Report Manager.
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....
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
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
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.
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
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 RelatedI'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.
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
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.
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
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.
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
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 RelatedI 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
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....
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 RelatedI 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 RelatedThe 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)
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.
In SQL 2000, how do I grant system administrator privilege to "sa" or a Windows User?
View 3 Replies View RelatedHello 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.
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
I'm a kid and I'd like to know what kind of work a database administrator does. It would be great to learn from a real database administrator how you spend your typical day at the office. What are some of your main duties? Thanks so much in advance.
View 1 Replies View Related