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
ADVERTISEMENT
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
Apr 11, 2007
If there is a local Administrator to the Tyson's Corner area I need help with Administrating my custom App hosted on SQLServer 2005. Must be local, secure server can only be worked on from my site. Can be done in your off hours. Call me David if you are interested 800.230.5331 or email david.jed@knowledgesystemsllc.com
View 1 Replies
View Related
Jan 15, 2008
Hi everybody,
I have an application in dotnet that uses sql express.
This application will be deployed on the user computer and I have to find a way to prevent the user to be able to read the data and access the structure of the database.
Is there a way to do this ? Even if the user is a local administrator of the computer ?
That's a difficult question, isn't it ? ;-))))
Thank you for your possible ideas,
Ciao,
Aurore
View 4 Replies
View Related
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
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
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
Aug 3, 2004
I have installed Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) and the SQL Server Web Data Administrator. After I run the SQL Server Web Data Administrator it
is asking me for login and password. How can I determine my login and password? Thank you.
View 1 Replies
View Related
Feb 10, 2005
Is it possible to install this on a remote web server and set it to use SQL accounts? I installed this on my host and it keeps prompting me for a windows user name and password.
Any instructions on how to do this would be appreciated.
Charles
View 4 Replies
View Related
Nov 23, 2004
I'm so sorry if this is a stupid question. I'm experienced PHP/MySQL developer, but this is my first SQL Server project, I'm really not familiar with Microsoft development tools at all. I have Visual Studio .NET installed. I've just downloaded and installed SQL Server Web Data Administrator. There was no errors during the installation, but when I'm trying to use it to connect to the database I had set up on the hosting server, I get the error message below:
Server Error in '/webadmin' Application.
--------------------------------------------------------------------------------
COM object with CLSID {10020200-E260-11CF-AE68-00AA004A34D5} is either not valid or not registered.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Runtime.InteropServices.COMException: COM object with CLSID {10020200-E260-11CF-AE68-00AA004A34D5} is either not valid or not registered.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[COMException (0x80040154): COM object with CLSID {10020200-E260-11CF-AE68-00AA004A34D5} is either not valid or not registered.]
SqlAdmin.SqlServer.Connect()
SqlWebAdmin.databases.Page_Load(Object sender, EventArgs e) +28
System.Web.UI.Control.OnLoad(EventArgs e) +55
System.Web.UI.Control.LoadRecursive() +27
System.Web.UI.Page.ProcessRequestMain() +731
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
If anyone knows what is the problem and can point me in the right direction, I'd really appreciate.
Inna
View 1 Replies
View Related
Apr 10, 2008
Hello,
There is a SQL Server databse installed in my machine.
I want to modify a data in a table.
How can I access the data with ODBC Administration?
Thanks
View 6 Replies
View Related
May 28, 2015
After installing SSMS on some computers - the only way we can get SSMS to run correctly is to run it as the administrator. Is there a way where you don't have to do that? These end users are logging as themselves and have accounts in SQL Server all set up - but SSMS will only launch for them if we right click and select "run as administrator".After doing some digging - it seems that this is a common problem out there.
View 3 Replies
View Related
Nov 18, 2015
We have an audit happening on our DB environments. All are SQL2008R2. One of the risk highlighed is DBAs are also part of 'Administrators' group on the server. The DBAs having sysadmin (ie full control)on SQL server is not a risk but DBAs included in 'Administators' group is termed as risk.
My question is do the DBAs really need to be Administrator on the box apart from Sysadmins??. If yes,What are the scenarios in which DBA group also need to be an administrator on the box to manage daily admin activities.
View 4 Replies
View Related
May 3, 2007
Sql server driver missing from odbc administrator;
Software; SQL Server 2005 SP2 installed on W23K SP1.
Under Drivers tab in odbc administrator the sql server that uses sqlsrv32.dll, is missing. All the other drivers that comes with W2K3 Service pack1 is there. In addition i can see the SQL Native Client(SQLNCLI.DLL).
I have an application that has to use SQL Server Driver. How can i get it back?
Hope someone can help me?
View 4 Replies
View Related
Mar 28, 2008
Do DBAs need OS Administrator rights to Manage SQL Server? I suspect the answer is no, but, the DBAs tell me that they cannot do their jobs without OS admin rights.
Can someone point me to documentation detailing what OS level rights are needed by SQL Server DBAs?
View 3 Replies
View Related
Apr 30, 2008
I would like to setup the membership and role in web administrator tool, however, under Security section, I got the error message of "Unable to connect to SQL database".
I tried to run aspnet_regsql.exe to edit the config(C:WINDOWSMicrosoft.NETFrameworkv2.0.50727>aspnet_regsql.exe), however, it still shows this error message.
I am using web developer 2008 and SQL Server 2005.
Please advice me how to tackle this problem.
Thank you.
View 4 Replies
View Related
Jul 20, 2004
Hi,
Can any of you tell me how to create a login in SQL Server 6.5 with System Administrator privileges, like we can do with SQL 7 or SQL 2000 ? I don't want to use the sa login.
Thanks
View 1 Replies
View Related
Sep 1, 2006
If i install the SQL Server Express and the Management Studio in my computer with an administrator account... can a non-administrator user run the SQL Server Management Studio Express ?
When the non-administrator user tries run the SSEMS, he gets an error, something like "Cannot load the SQL Management Studio Package".
Can i set several permissions to let non-administrator users run the SSEMS ?
View 1 Replies
View Related
May 15, 2002
Trying to upgrade a 6.5 to a 2K.
Running SQL Agent from an admin account, admin account active as admin on both 6.5 machine and 2K machine, but I can not get the upgrade past the second screen, where I get the error message:
Unable to connect to export server, please verify that you are an NT Administrator on that machine.
Stefanie
View 1 Replies
View Related
Jul 20, 2005
HI!I have a little problem:I have change the administrator password (Windows 2003 Server) which MSSQL 2000 use to login.And now the SQL server can't stand up.What should I do?thx!gicio--Posted via http://dbforums.com
View 1 Replies
View Related
Jun 26, 2007
Hi All,
We're deploying an app. using a MSSQL Server 2005 (Std. Ed.).
In order to install an ODBC driver for the DB, we've made the installation of Sqlncli.msi part of the package.
It will not run - unless user has Admin priv.s on the klient PC targeted.
Does any one have any experience w. other ways of installing the sql native client (like MDAC) - og just an idea about circumventing the Admin rights problem?
Regards
View 1 Replies
View Related
Jun 18, 2004
I want to connect to company's SQL Server from home and to connect to home's SQL server from company remotely.
The new released SQL Server Web Data Administrator by Microsoft seems solving my issue.
I use it to connect to different SQL servers in different domains company wide successfully, but I failed to connect to home from company( I have static IP on the home server).
Also I want to know how to configure the sever name if I want to connect to company's SQL Server from home. The company SQL server is inside the firewall with a internal IP. How it works?
Any ideas?
Thanks!
View 4 Replies
View Related
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
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
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
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
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
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
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
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
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
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