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)
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.
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.
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
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.
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.
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?
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?
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
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?
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.
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.
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.
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 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?
Hello everyone, I'm trying to create a database using the Web Data Administrator. However, when I run the service (Web Data Administrator) and I have to log in, I can't. First of all, when I choose the "Windows Integrated" option, the service automatically shows me the user name, which is the computer name (Office/Home), no password (empty password field), and the word "(local)" in the server field name, and then when I click "Login" I get the following message: "Invalid user name and/or password, you are using a windows login that is not your own, or server does not exist". In addition, when I choose the "SQL" login option, I don't know what my password is and I don't even know how to know where the password is, or where it can be set up. I have looked to some documentation about the topic and I'm in the process of learning new things. However, I have concluded that probably some of you could give me a hint of where to look, so the learning process can be accelerated and I can cover more in the same time I'm doing my own research. I have SQL 2005 (Express Edition) installed. Further, I have changed my Windows XP user name and password trying to see if SQL server 2005 would get its information from this type of authentication. After changing my user name and password, I went to the SQL2005 manager and in the properties window, I saw that the user name there was “./home� and the password was a dotted string that I don’t know where it came from. I would greatly appreciate some feedback on this problem, Eduardo
1. I installed MSDE with this string: Setup SAPWD=mypassword DISABLENETWORKPROTOCOLS=1 SecurityMode=SQL
2. And then i installed Web Data Administrator.
3. I try to login to my MSDE, but when i press the Login button, NOTHING is happening, I´ve been waiting for half an hour or so and it just freezes??.
4. I have tried Both SQL login and Windows, NONE of them work, i get no error messages at all, it just freezes?.
5. And the funny thing is that i can login with a connectionstring and a ordinary SqlCommand, that is no problem but the Web Data Administrator just freezes?
"SQL Web Data Administrator" was working fine until I installed windows XP service pack 2 Now when I start "SQL Web Data Administrator" I get "Access denied" Error message on the default.aspx webpage. "SQL Web Data Administrator" is still working fine under "Cassini personal web server"
Here is the stack trace:
Server Error in '/webadmin' Application. --------------------------------------------------------------------------------
Access is denied. 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.ApplicationException: Access is denied.
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.
and then the installation just automatically processed and finished, I've never got any prompt asking for setting up uername or password.
2. I've never use any SQL server before, so I dont think I have any SQL credential, thus I have no idea what's the username or pswd I suppose to type in;
3. I also enabled the SQL mixed mode authentication from changing value of 1 to 2.
I'm using SQL Server 2005 Standard edition on Windows 2003 Standard server.
I can connect with no problems as user 'sa' to SQL Server Management Studio. I can also create users and databases there with no problems and I can connect to them using SQL Server Management Studio, again, with no problem. However,. I want to use the Web Data Administrator.
I installed it,. without a problem, and I can access it as Server/Administrator and then using 'sa' and it's corresponding password.
So where is the problem?
The problem is that when I create a different user on the server and want them to have access to the Web Data Administrator, they can pass the WindowsAuth pop up screen, but when prompted to enter the MSSQL username and password, the login doesn't pass. In fact you only see the clock hangin, but no login process is taking place.
I have been using ODBC data source administrator for years without any problem. However, after a unsuccesful MSSQL7.0 installation, i keep getting the following message:
"An error occurred while windows was working with the control panel file
D:WINNTSystem32Odbccp32.cpl"
Any insight into this would be greatly appreciated.
Hello. I see a lot of threads re this but I havent seem an answer. Please help. I have Win xp pro SP2 with msde, IIS 5.1 and Web Data Administrator on two separate machines.
With one machine everything works great. On the other, When I hit the Web Data Administrator Login button (windows integrated or SQL) it just shows the hour glass and doesnt do anything.
On the one that works, I can change the server to one on our lan with sqlserver and it will link in fine. However with the other, the same hourglass shows.
IIS and msde are both running and seem to work fine. I can browse to localhost virtual directories (I have dotnetnuke running using msde on localhost) and access the database from dotnetnuke and visual studios.
I have made sure my localhost is a "Trusted site" und ie browser and I have enable windows integrated authentication for the default web site and the webadmin virtual directory.
I represent a software development house and we have developed a client server system based on SQL Server. Most of our customers have already purchased Enterprise License of SQL Server, therefore they own the SA Login and Password. We are bound to attach our Database with their Server on their machine.
My question is how can we stop a System Administrator of SQL Server to view our Database Structure, Queries, Data installed on their SQL Server on their machine.
Our database structure is a trade secret and we cant reveal the structure to the client.
please answer this question by email to me at farhandotcom@gmail.com
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.
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.Â
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?
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?
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.
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.
