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


ADVERTISEMENT

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

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

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

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

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

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

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

Web Data Administrator - Connectivity Problem

Jan 21, 2008

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
 

View 2 Replies View Related

How To Login To SQL Server Web Data Administrator?

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

Problems With Login To Web Data Administrator

Sep 17, 2004

Hi..

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?

View 3 Replies View Related

SQL Web Data Administrator Problem With IIS And Windows SP2

Sep 22, 2004

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

Stack Trace:


[ApplicationException: Access is denied.
]
System.Security.Principal.WindowsIdentity._ResolveIdentity(IntPtr userToken) +0
System.Security.Principal.WindowsIdentity.get_Name() +71
System.Web.Configuration.AuthorizationConfigRule.IsUserAllowed(IPrincipal user, String verb) +100
System.Web.Configuration.AuthorizationConfig.IsUserAllowed(IPrincipal user, String verb) +81
System.Web.Security.UrlAuthorizationModule.OnEnter(Object source, EventArgs eventArgs) +178
System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() +60
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +87

View 2 Replies View Related

SQL Server Web Data Administrator Question

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

Problem With SQL Server Web Data Administrator

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

MSDE And Web Data Administrator Issue

Oct 23, 2006

Hi,


I have a problem with log into Web Data Administrator. I dont know what's the username, password, as well as server infor I suppose to put there.

1.Inorder to set up my MSDE

Basically I typed in following code

c:sql2ksp3msde> setup.exe /qb+ INSTANCENAME=NetSDK DISABLENETWORKPROTOCOLS=1 SAPWD=PASSWORD

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.

but it doesnt work

Anyone knows what's wrong?

thanks.

Genjioo

View 1 Replies View Related

Need Assistance To Connect To Web Data Administrator

Jun 12, 2006

Hi Y'all,

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'm at a lose on this!

Any pointers?

-Alon.

View 3 Replies View Related

Can't Login To Microsoft SQL Web Data Administrator With Sql Option

Feb 12, 2006

i have installed MSDE 2000 and Microsoft SQL Web Data Administrator.

at first i login using Windows Integrated option and created an account for sql login.

but when i tried to login using newly created account i get the following error.

Invalid username and/or password, you are using a windows login that is not your own, or server does not exist.

i am using XP SP2.

View 3 Replies View Related

ODBC Data Source Administrator Problem

May 25, 1999

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.


Thanks,


--Lawrence

View 1 Replies View Related

Web Data Administrator - If I Wasn't Bald I'd Be Tearing My Hair Out!

Dec 22, 2004

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.

Any help would be greatly appreciated.

View 2 Replies View Related

How To Prevent System Administrator To View And Edit A Database Structure And Data

Dec 26, 2007

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

Thanks & Regards
Farhan

View 1 Replies View Related

Oracle Publication Error:The Permissions Associated With The Administrator Login For Oracle Publisher 'test1' Are Not Sufficient

Jan 12, 2006

Hi,

I am trying to make an oracle publiching from sql server 2005 enterprise final release, i installed the oracle client  10.2 (10g) on the same server where sql server already installed, i made different connection to oracle database instance and it was  ok.

 

from sql server : right click on publication -New oracle publication-Next-Add Oracle Publisher-Add button-Add Oracle Publisher-i entered server insttance test1 and their users and passwords--connect --->

the oracle publisher is displayed in the list of publisher but when press ok i got the following error :

TITLE: Distributor Properties
------------------------------

An error occurred applying the changes to the Distributor.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=Microsoft.SqlServer.Management.UI.DistributorPropertiesErrorSR&EvtID=ErrorApplyingDistributor&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

SQL Server could not enable 'test1' as a Publisher. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

The permissions associated with the administrator login for Oracle publisher 'test1' are not sufficient.
Changed database context to 'master'. (Microsoft SQL Server, Error: 21684)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=21684&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------


Any idea about this error ?

Thanks

Tarek Ghazali
SQL Server MVP.


 

View 2 Replies View Related

How To Connect Remote SQL Server Using Microsoft SQL Server Web Data Administrator

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

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

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

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







Copyrights 2005-15 www.BigResource.com, All rights reserved