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
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?
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.
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'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 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?
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 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.
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.
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.
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
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?
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....
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?
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?
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'.
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:
