MS SQL Server :: How To Prevent System Administrator To View And Edit A Database Structure And Data

BUILTINAdministrators Vs System Administrator
Hello 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.

View Replies !

Prevent Backup And Restore On Different System

How do I prevent someone from backing up the data / copying the mdf and then mounting it from a different server or instance to gain access to the DB.

I do not have control over the physical file.

Basically, I want to make sure that only authorized applications and users can access the data.

View Replies !

Default Password For System Administrator
We recently downloaded and installed SQL Express as it was a required program for our new database management software. When trying to install my database management software I was asked to Login to the SQL server. I entered the SQLEXPRESS server, however, I do not have the SA password. When SQL Express installed it did not ask for a password only for a user name and company. I am running Windows Small Business Server with the Administrator and no password. We did not assign a password to the Administrator account yet.

I have tried to leave the password blank using the login SA and I get error message 28000 Login failed for user. The user is not associated with a trusted SQL Server Connection.

Is there a default password for SA? Or in the alternative, how do I create a user or associate an exising Windows user with a trusted SQL server connection?

View Replies !

Only A System Administrator Can Reassign Ownership
Hi guys,

I am new to this forum and new to SQL.

I have a stored procedure which sets the value of a variable (@owner_logon_name, type sysname) to sa. It then calls sp_add_job in the msdb database, which in turn calls numerous other stored procedures. The ASP page I post down to the server is coming back with an internal server error and the log file shows the following message:

"Only a system administrator can reassign ownership of a job."

Even though the login name was set to sa, it seems to be using another role.

The code I have in my sp is:

exec @ReturnCode = msdb.dbo.sp_add_job @job_id = @JobID output ,
@job_name = @JobName,
@owner_login_name = sa,
@description etc, etc

Can anyone think why it would do this? An explanation of how sp_add_job works would also be much apprciated.

View Replies !

Programming Babe In A System Administrator's Woods!
I posted this topic and got not response, but I'm pretty desperate so I'll try one more time.

I'm a programmer at a small company but for the past year I've also been relagated to SysAdmin (fun, fun, fun). We less than 25 users (usually no more than 10-15 at one time). We run NT server on a P133, 64MB RAM, 3.5MB & 2.5MB SCUSI hard drives. We run SQL Server on dual P133's, 98MB RAM, 4MB & 2MB SCUSI hard drives. Our systems are pretty junky, they were bought at Microcenter a couple of years ago and some other machines we had bought about the same time have begun dying left and right. Our Server is very slow and we're afraid it's going to poop out on us soon.

I've been put in charge of taking care of this. "Get us a new server, and don't spend too much money." Being a programmer, not and administrator, I have a few questions:

1. Can I buy 1 good server to replace these two? That would mean running our NT File Server and our SQL Server (on NT of course) on the same box. Is that bad or can I do that? The only thing the NT Server is used for is file sharing (mostly images). No applications, no exchange (although maybe in the future), no internet. 2. If yes, should I go with a really fast desktop with a few ATA/66 drives, a smoking chip, tons of memory. Or, should I get a true server with SCUSI drives, ECC memory, RAID capable and all that. Essentially is it better to get a smoking desktop or a lower end/entry level server?
3. I don't quite understand RAID, do I need it? If so, what is it? We need to backup or data somehow.
4. Anything else you think I'll need? Or, could some list some minimum specs?
5. How much should this cost me?

Our main concern is the SQL Server running fast enough. We have a custom Accounting/Order/Inventory system (Access97-front/SQL-Back end ). The database is about 200MB and growing and the largest table has about 100,000 records and we anticipate about 20,000 records a year in that table. We also store tons of images (art company) on our file server and we would like to link our SQL inventory records to those image files.

I'm really kind of in over my head with the administration but the pressure is on. They want me to do this instead of outsourcing and they want to keep in the <=$3500 range (Server & Backup System). Any help or advice of any kind would be greatly appreciated.

Thanks.

View Replies !

SQL Server 6.5 - HOW TO Create Login With System Administrator Privileges
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 Replies !

System.Security.SecurityException: Request For The Permission Of Type 'System.Data.SqlClient.SqlClientPermission, System.Data
I have created a windows library control that accesses a local sql database

I tried the following strings for connecting

Dim connectionString As String = "Data Source=localhostSQLEXPRESS;Initial Catalog=TimeSheet;Trusted_Connection = true"

Dim connectionString As String = "Data Source=localhostSQLEXPRESS;Initial Catalog=TimeSheet;Integrated Security=SSPI"

I am not running the webpage in a virtual directory but in

C:Inetpubwwwrootusercontrol

and I have a simple index.html that tries to read from an sql db but throws

the error

System.Security.SecurityException: Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
   at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet)
   at System.Security.PermissionSet.Demand()
   at System.Data.Common.DbConnectionOptions.DemandPermission()
   at System.Data.SqlClient.SqlConnection.PermissionDemand()
   at System.Data.SqlClient.SqlConnectionFactory.PermissionDemand(DbConnection outerConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection,

etc etc

The action that failed was:
Demand
The type of the first permission that failed was:
System.Data.SqlClient.SqlClientPermission
The Zone of the assembly that failed was:
Trusted

I looked into the .net config utility but it says unrestricted and I tried adding it to the trusted internet zones in ie options security

I think that a windows form connecting to a sql database running in a webpage should be simple

to configure what am I missing?

View Replies !

Accessing Data Structure Of A MS SQL Database
I have written 5 content-management systems and am getting a little bored writing a lot of the same functionality and tweaking it for different datamodels. Is there a way within .NET to have visibility of a database's structure (ie, data type, column names, foreign keys etc)? I'd like to write up a dynamically generated form for any given table, displaying appropriate form controls based on data type and foreign keys.

View Replies !

Copying Data And Structure From One Database To Another
Hi all!I have an application that needs to copy the database structure fromone database to another without using the "Generate SQL Script"function in Enterprise Manager. I'd like to do this from within astored procedure. Can someone recommend the best approach for this?I've seen references to using SQL-DMO from a stored procedure using thesp_OA* procs in other postings to this group but was wondering if therewas an easier way? Can I use bcp and then use xp_cmdshell from withinmy stored procedure? It's not clear to me from the documentationwhether bcp copies both structure and data or just data? Is there abetter way?Thanks in advance for any help!Karen

View Replies !

Copy Database Structure But Not The Data
I'm looking to create a new version of a database but with completely reloaded data - so I want to retain the database structure but none of the data.

Is there an easy way (read: without a DBA on staff) to copy an existing database structure - preferably with views and stored procedures - and not take the data along for the ride?

Thanks in advance for suggestions...!

View Replies !

Copy Just The Database Structure Not The Data
I have been working on my windows app, using SQL Server 2005 (& C#) but I now have loads of junk data, so I want to copy the structure without any data to a new set of files that can become the production version.

I assume I can use backup and restore in future when I want a copy of my production data to use for future testing.

How would I take just one table from my test database and add it to my production database without retyping the design?

Apart from the size limitation is there any advantage in buying a version of SQL Server over using the Express edition?

View Replies !

How To Copy Database Structure From One Db To Another W/o Affecting Data
Is there a way to copy the structure from one database to anotherwithout affecting the actual data?For example, I added new fields and stored procedures to a db in mydevelopment environment. There are a lot of them.I now want to make the same changes to my production environment db butdon't want to affect the data. Only the fields, stored procs &constraints and stuff pertaining to the structure of the db should bechanged.Does anyone know of a program that can do this or can this be done inMS SQL Enterprise Manager.Any help would be appreciated.7078895

View Replies !

How To Prevent System Form Locking A Table In Case Of Large Insertion
Hi,

I found out that executing the procedure SP_INDEXOPTION and setting 'AllowRowLocks' to false i can prevent the sql server from locking rows in a table and 'AllowPageLocks' prevents from pages being locked. I need to preform same operation
in case of tables. I need to perform insertion operations concurrently and acquire required locks manually. Is there a way to stop sqlserver from acquiring locks on the table. I need to disable all the locks (row, page and table).

Thank you in advance.

View Replies !

View/Edit SDF On Desktop
I inherited a WinCE.net application that uses SQL Server CE as the database. We use Visual Studio 2003 to write the program. Using the query analyzer on the device is difficult and I would much prefer to do my database views/research on my desktop. I could even copy the SDF over to the desktop, slice and dice it and then return it to the compact unit. But what do I need to have on my desktop so I can view these SDF files? Thanks.

View Replies !

Trigger View/Edit
Hi all!

How do u view the triggers in sql 2000 qry analyzer. I know you can use sp_helptrigger-- which will give the list of triggers-- -- But, I need to be able to run command from qry analyze and see the script used to create triggers
Having limited access to the design tables-- wont be able to see trigger from sql design table

Thank you

Josephine

View Replies !

Purging A Database Data While Keeping The Structure Intact
Is it possible to purge all records in the database while retaining the the table structures. Even better yet, could I do it on a table by table basis? If I simply delete all the records the identities for the tables do not revert back to 1.

View Replies !

How To View/edit SSIS Packages Already Created?
I created a few in SqlServer2005 DEV version and ran them manually with success. But where are they? I chose the SqlServer storage option and I see them when I create Job and steps but how do I view/edit these packages from SqlServer Mgmt. Studio? The SSIS service is running.

View Replies !

DropDownLists Edit In Grid View To Display Names But Have Value Of User_ID ... Possible?
Hello,I have inserted a drop down list in my Edit template of Grid view. This DDL should control the User_ID who is responsible for the Computer being edited. However I want it to display the User Names rather than the user IDs. I have a COMPUTERS and a USERS table. They are related by having User_ID in both. Below is my grid view with the parts i feel relative highlighted in bold:<asp:GridView ID="GridView1" runat="server" AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="Computer_ID" DataSourceID="SqlDataSource1" CellPadding="4" ForeColor="#333333" GridLines="None"> <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" /> <RowStyle BackColor="#F7F6F3" ForeColor="#333333" /> <Columns> <asp:CommandField ShowEditButton="True"/> <asp:BoundField DataField="Computer_ID" HeaderText="Computer_ID" InsertVisible="False" SortExpression="Computer_ID" ReadOnly="true" /> <asp:BoundField DataField="Computer_Name" HeaderText="Computer Name" SortExpression="Computer_Name"/> <asp:BoundField DataField="Manufacturer" HeaderText="Manufacturer" SortExpression="Manufacturer"/> <asp:TemplateField HeaderText="User Name" SortExpression="Name"> <EditItemTemplate> <asp:DropDownList ID="DDL_Name" runat="server" DataSourceID="SQLDataSource2" DataValueField="User_ID" SelectedValue='<%# Bind("User_ID") %>'></asp:DropDownList> </EditItemTemplate> <ItemTemplate> <asp:Label ID="lblName1" runat="server" Text='<%# Bind("Name") %>'></asp:Label> </ItemTemplate> </asp:TemplateField> </Columns> <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" /> <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" /> <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" /> <EditRowStyle BackColor="#999999" /> <AlternatingRowStyle BackColor="White" ForeColor="#284775" /> </asp:GridView> <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="Data Source=.SQLEXPRESS;AttachDbFilename=C:AjaxControlToolkitWebSite1App_DataAssetDatabase.mdf;Integrated Security=True;User Instance=True" ProviderName="<%$ ConnectionStrings:AssetDatabaseConnectionString.ProviderName%>" SelectCommand="SELECT * FROM USERS" > </asp:SqlDataSource> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="Data Source=.SQLEXPRESS;AttachDbFilename=C:AjaxControlToolkitWebSite1App_DataAssetDatabase.mdf;Integrated Security=True;User Instance=True" ProviderName="<%$ ConnectionStrings:AssetDatabaseConnectionString.ProviderName%>" SelectCommand="SELECT COMPUTERS.Computer_ID, USERS.User_ID, COMPUTERS.Computer_Name, COMPUTERS.Manufacturer, USERS.Name FROM COMPUTERS INNER JOIN USERS ON COMPUTERS.User_ID = USERS.User_ID" UpdateCommandType="StoredProcedure" UpdateCommand="StoredProcedure1" > <UpdateParameters> <asp:Parameter Name="Computer_ID" Type="Int32" /> <asp:Parameter Name="User_ID" Type="Int32"/> <asp:Parameter Name="Name" Type="String" /> <asp:Parameter Name="Computer_Name" Type="String" /> <asp:Parameter Name="Manufacturer" Type="String" /> </UpdateParameters> </asp:SqlDataSource> <br /> <br /> </form></body></html> THANKS =]

View Replies !

Request For The Permission Of Type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, Pu

I created a .net console application within which I connect to a sql server (not local) as follows,

string conn_str = "Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=QuantEquitySql;Data Source=server name";

SqlConnection conn = new SqlConnection(conn_str);

conn.Open();
.
Everything works fine when I run it from my computer. When I try to run it from a network share I get the following error,

Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

I am using Visual Studio 2005 and .Net framwork v2.0.50727.

Does anybody know a fix to this problem?

Thanks

View Replies !

'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' Fail
I have a report that uses some embedded custom code. The embedded custom code is a function that execute some sql query on a sql server database.Everything works fine in Visual studio. The report gets deployed on the server successfully, however when running the report from report manager i get the following error message :

The Hidden expression for the table €˜table1€™ contains an error: Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

Here is the code :

************************************************************************

Public function get_field() as string
Dim myConnection As System.Data.SqlClient.SqlConnection
Dim myCommand As System.Data.SqlClient.SqlCommand
Dim data_reader As System.Data.SqlClient.SqlDataReader
Dim field(100) as string
Dim i as integer
Dim j as integer
Dim sql_field as string
Dim nbr_field as integer
Dim rtn_string as string

i = 0
sql_field ="Select field from mytable"
myConnection = New System.Data.SqlClient.SqlConnection("Datasource=xxx.xxx.xxx.xxmydatabase;Initial Catalog=mydatabase;User Id=user1;Password=password1;")
myConnection.Open()
myCommand = New System.Data.SqlClient.SqlCommand(sql_field, myConnection)
data_reader = myCommand.ExecuteReader()
While data_reader.Read()
if data_reader.HasRows then
field(i)= data_reader(0).ToString()
end if
nbr_field = nbr_field + 1
i= i+1
End While
data_reader.Close()
myConnection.Close()

for j = 0 to nbr_field -1
rtn_string = rtn_string + field(j) + ","
Next j

rtn_string = left(rtn_string,rtn_string.length-1)
return rtn_string
'return sql_cmd
'return yes_no
'return lkupfield
end function

******************************************************************

Why do i get the error message ?, is this related to Code Access Security issues with .net framework. if yes

how do i set the Security so the report server or report manager allows embedded custom code to be executed. Any advice ?

Chi

View Replies !

How Can I Return Data From A Database And Fill A Data Grid View?
Hi ! I have a textbox and a Search button. When the user inputs a value and press the button, i want a datagrid to be filled.
The following code runs:
Dim connect As New Data.SqlClient.SqlConnection( _
"Server=SrvnameSQLEXPRESS;Integrated Security=True; UID= ;password= ; database=dtbsname")
connect.Open()
Dim cmd As New SqlCommand
Dim valor As New SqlParameter("@valor", SqlDbType.VarChar, 50)
cmd.CommandText = "Ver_Contactos_Reducido"
cmd.CommandType = CommandType.StoredProcedure
cmd.Connection = connect
cmd.Parameters.Add(valor)
cmd.Parameters("@valor").Value = texto
Dim adapter As New SqlDataAdapter(cmd)
Dim ds As New System.Data.DataSet()
adapter.Fill(ds)
GridViewContactos.DataSource = ds
GridViewContactos.DataBind()
connect.Close()
I drag a datagrid on the page and only changed its Id.
Into the SQL database the stored procedure is the following:
ALTER PROCEDURE [dbo].[Ver_Contactos_Reducido]
(@Valor VARCHAR(100))
AS
BEGIN
SET NOCOUNT ON;
SELECT NombreRazonSocial, Nombre, Apellido,TelefonoLaboral,
Interno, TelefonoCelular, Email1, Organizacion
FROM CONTACTOS
WHERE NombreRazonSocial = @Valor OR Nombre = @Valor OR Apellido = @Valor OR TelefonoLaboral = @Valor OR Interno = @Valor OR
TelefonoCelular =@Valor OR Email1 = @Valor OR Organizacion= @Valor
END
When i run the page i can't see the datagrid, and after i enter a text and press the button, nothing happens. What am i doing wrong??
Thks!!

View Replies !

A First Chance Exception Of Type 'System.Data.SqlClient.SqlException' Occurred In System.data.dll
Hi,
I've written this code multiple times now. But for the first time i get an error at the line underlined. My procedure runs perfectly when i execute it through Sql Query analyzer.
plzz help.. Its urgent and am unable to find the reason for this error "A first chance exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll"
Thanks !SqlConnection conn = new SqlConnection(DbConnectionString);
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "dbo.rqryTradesPRR";
cmd.Parameters.Add("@COBDate",SqlDbType.DateTime).Value = "2002-10-31 00:00:00.000" ;
SqlDataReader reader = cmd.ExecuteReader();
while(reader.Read())
{
// have written something here

}
Thanks in advance !

View Replies !

Drill Through Report Problem For Implementing Tree View Structure

Hai Iam new to SSRS 2005, please help me regarding below Drill Through Report Problem. Assum my problem with below example.Iam tried Hard iam not able to find the solution, Any body please help me.my real time problem is same as below functionality

If Suppose iam dispalying two columns like Country,Department,iam taking these two columns in a table, assume country column having America,south africa, individual america column having Florida state, south africa column contains capetown state, in the preview of the report iam applying drilldown to America column like + America, i need when clicking the America column i want to display Florida state under the column of Country like tree view structure

                  i need output like this and the same time i want to display other columns those also contain tree view structure assume other one is department column, with contains computers and sales, individualy computers contains HP, Sales contains Bikes

                                                       Country                      Department

                                          + America                            + Computers

                                                         ---Florida                        -- HP

                                          + SothAfrica                           + Sales

                                                        ---Capetown                    __Bikes

How to implement above output using drill through functionality, i tried with subreports and used all grouping formats, is possible for display output like above explain the procedure .

Thanks In advance

Jacks

View Replies !

System Database Log And Data On Different Devices
I am new to SS7. We are planning to rearrange our system databases so that the logs are on one drive
and the data files are on a different drive. I found a really good white paper on this but just want to
verify that there is not a problem with doing this. In sybase there were some restrictions on doing this.
Any info you have would be appreciated.

View Replies !

Domain Administrator Vs. Local Administrator Group
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 Replies !

Archive Data Instead Of Deleting It To Prevent 4GB Data Limit
We are running SQL Server 2005 express on Windows 2003. The database server gets significant amounts of data.

Because of the 4GB data limit we have a daily cron task which goes through and deletes data older then 90 days.

We would like a way to archive this data instead of deleting it. Is there any way to take data and compress it and store it in a different way, so that if needed, customers can query directly out from the compressed data? Cleary querying from compressed would be slower but that is ok.

Any other solutions that would allow us to archive data instead of deleting it? Thanks.

View Replies !

How Can I Get The 'entire' Database, Structure And Data, From SQL Server 2008 To SQL Server 2005?
1) I can't get the 'copy database' function to work from SQL Server 2008 to SQL Server 2005. I connect ok. Everything goes to the last step and then it fails.2) I cant get a SQL server 2008 backup to restore on SQL SEerver 2005 either.
The only way I know that works is to script the creation of all tables then export and import. This does work.
How can I get the 'entire' database, structure and data, from 2008 to 2005?
ThanksSQL newbie.

View Replies !

MS SQL And Web Data Administrator.
Hello,

I'm new to Microsoft SQL and have recently installed MSDE along with the Web Data Administrator. The SQL server appears to be working because I'm able to use it in Visual Studio .NET to create a database. However, I'm not sure how to login using the Web Data Administrator. At the logon screen, the required fields are: Username, Password, Server, Authentication Method. If I select Windows Integrated for Authentication Method, then would the Username and Password be the same as my Windows XP user name and password? Also, what name do I enter in the Server field, (the name of the SQL server, but how do I obtain that?). Hopefully someone can help me out.

Also, can anyone offer a good resource on the web for learning MS SQL. I've been looking through Microsoft’s web site, but I can't seem to find much.

Thanks very much.

View Replies !

Prevent Data Being Inserted Twice
I have a table with 3 columns: ID, Status, DateTime.

I created a stored procedure to insert a staus value for each ID. This will run every hour. The DateTime stores the time, date when the Status was inserted.

If the procedure was to be run a second time in hour window I do not want any Status to be inserted.

Note: that I cannot rely on the procedure being run at exactly the right time - if it was scheduled to run on the hour (i.e at 1:00, 2:00, 3 :00 etc) but didn't run until 1:20 it sould still be able to run at 2:00.

Does anyone know if there is anyway I can gaurd against this?

View Replies !

How Can I Prevent That All Data Can Be Seen With Notepad?
Hello,

is there a way to say to SQL Server to make the data not readable?

Regards
Markus

View Replies !

Can't Install SQL Web Data Administrator
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 Replies !

SQL Web Data Administrator Error
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 Replies !

Web Data Administrator Hangs
I know some use the sql web data administrator:

http://www.microsoft.com/downloads/details.aspx?FamilyID=c039a798-c57a-419e-acbc-2a332cb7f959&DisplayLang=en

Anyway,have following problem: It hangs. If I try to login,
nothing happens, it just hangs. Whether I try mixed mode or integrated
security, same result. I've a tried older Version of this (2002, new version
is from 2004) and it works. But the problem is, the older version does only
support SQL mixed mode authorization, while the newer works with integrated
windows security too.

Any helpful advices?

View Replies !

Web Data Administrator Error
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 Replies !

Sql Express And Web Data Administrator
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 Replies !

Cannot Login With Web Data Administrator
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 Replies !

Login To Web Data Administrator
I'm running SQL Server Desktop Engine (MSDE) and when i try to logon to Web Data Administrator i keep getting the error message:

"Your session has expired or you have already logged out. Please enter your login info again to reconnect" even though I have yet to login.

I cant work out the problem.

Any ideas?

View Replies !

SQL Server Web Data Administrator
Can be useful for a lot of developers that are using MSDE or SQL Server in their projects and want to administer their databases using a (ASP.NET driven) web application. Actually, you don't even need IIS but you can use Cassini as well which is included with the project:

Microsoft Download

View Replies !

SQL Server Web Data Administrator
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 Replies !

SQL Server Web Data Administrator
For all the guys who're working with MSDE and would like some friendly way to manage the database without having to rely on tools such as osql.exe and other dark command(s) or command-line tools, this might help: http://www.microsoft.com/downloads/details.aspx?FamilyId=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en. It's a free tool to manage MSDE (and SQL Server) databases through a website (ASP.NET driven) and does even not require IIS (runs on Cassini as well). Enjoy!

View Replies !

SQL Server Web Data Administrator
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 Replies !