mssql user priveleges

[muthukumar]

hi iam not able to set dba to new users created for mssql. there is no drop down.

can any one help me fast on how to set dba for a user??

[Brangwyn]

You can not set a user to "dbo" on mssql.

If you need it you can temporarily have it set on by submitting a trouble ticket, but you will only be given the dbo access long enough to do what you need and then it will be removed again.

[muthukumar]

why should it be removed again, that is not needed.

also brangwyn can u tell how to see the actual error insteda of the default aspx error page we get, we have added

<customErrors mode="Off"/> in our web.config file but we are still getting the generic error

[muthukumar]

hi brangwyn sorry to disturb you, but can u help me out with this.

i have copy-pasted my tt, can you tell me how to solve the problem.



************************************************** **
Muthukumar Prakasham :

a asp.net app is working ok when it is been put in root, but since it has nearly 50 files and images, i like to put it in a sub dir, can you enable this dir to have apps permision in IIS

right now iam getting error
http://csirxs.com/sswc/tricounty/default.aspx

username :******
dir to be changed : ******/****/*******

is is and emergency

--------------------------------------------------------------------------------
Johnny :

Hello,

This directory already has the same permissions as the root directory as will all directories below it. They are set to inherit parent attributes.
--------------------------------------------------------------------------------

Muthukumar Prakasham :

well then its not working, its working when i put all files in the root dir, but when i move all files to dir, its not working. there is nothing wrong with the code since the app seems to work fine in root.

http://csirxs.com/sswc/tricounty/default.aspx

you can take a look.

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

Johnny :

Hello,

This is a problem in your code as could have been viewed by turning your custom errors off. The web.config in the directory sswc is flawed. Simply deleting it will allow your application to function.
--------------------------------------------------------------------------------

Muthukumar Prakasham:

hi actually there are 2 .net apps. one is in the root directory with its own web.comfig, global.aspx etc files. this is separte and it works OK.

and there is another .net app inside sscw folder. this too has its own set of web.config, global.aspx files in the sscw root folder. then there are files inside tricounty. the aspx file inside tricounty should use web.config and global.aspx from sswc.

thats the situaton, how can i make the .net app which is residing in tricounty folder as a separte app using the web.config and other files in sswc folder.
--------------------------------------------------------------------------------

Johnny :

Hello,

I'm sorry, but that is a bit outside our normal level of support. Coming from a UNIX background, I don't have the correct knowledge to even point you in the right direction.
--------------------------------------------------------------------------------

Muthukumar Prakasham:

ok can u alteast send me what error it is showing in the server, we have set

but we are able to get the excat error.
the below note says that due security reasons we are not able to view the error

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.

Details: To enable the details of this specific error message to be viewable on remote machines, please create a tag within a "web.config" configuration file located in the root directory of the current web application. This tag should then have its "mode" attribute set to "Off".
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@


but we had included

customErrors mode="Off"/

in our web.config file.

but still this generic aspx file is being displayed, can u tell us what excalty the error is.
----------------------------------------------------------------------------------

END

[Brangwyn]

why should it be removed again, that is not needed.

becuase vortech do not allow dbo access, with dbo access you basically have unlimited control over the database and could say make it as big as you want without ever having to pay for the disk space your using.

As for the other error, the directories probably need to be made into virtual directories to enable each .net app to work.

[muthukumar]

thanx for the fast response.

so how can i have 2 .net apps. also how can we view the excat error, adding customErrors mode="Off"/ does'nt seem to work.

[Brangwyn]

it depends a bit on the apps, but putting each in their own directory, and if neccesarry making them virtual dirs should probably work fine, at least thats what I'd do if it was my server.

Can't really help with the cusomerrors problem, I'd suggest double checking your web.config file for other errors like customError defined twice or something else like that which may be stopping it from working correctly. You can also try turning .net off and on from the control panel as this will fix problems sometimes as well.

[muthukumar]

brangwyn i had posted the web.config file which is present in a directory up one level from default.aspx

can u tell if there is any error.
-------------------------------------


<?xml version="1.0" encoding="utf-8" ?>
<configuration>

<system.web>

<!-- DYNAMIC DEBUG COMPILATION
Set compilation debug="true" to insert debugging symbols (.pdb information)
into the compiled page. Because this creates a larger file that executes
more slowly, you should set this value to true only when debugging and to
false at all other times. For more information, refer to the documentation about
debugging ASP.NET files.
-->
<compilation defaultLanguage="vb" debug="true" />

<!-- CUSTOM ERROR MESSAGES
Set customErrors mode="On" or "RemoteOnly" to enable custom error messages, "Off" to disable.
Add <error> tags for each of the errors you want to handle.
-->
<customErrors mode="Off"/>

<!-- AUTHENTICATION
This section sets the authentication policies of the application. Possible modes are "Windows",
"Forms", "Passport" and "None"
-->
<authentication mode="Windows" />


<!-- AUTHORIZATION
This section sets the authorization policies of the application. You can allow or deny access
to application resources by user or role. Wildcards: "*" mean everyone, "?" means anonymous
(unauthenticated) users.
-->
<authorization>
<allow users="*" /> <!-- Allow all users -->

<!-- <allow users="[comma separated list of users]"
roles="[comma separated list of roles]"/>
<deny users="[comma separated list of users]"
roles="[comma separated list of roles]"/>
-->
</authorization>

<!-- APPLICATION-LEVEL TRACE LOGGING
Application-level tracing enables trace log output for every page within an application.
Set trace enabled="true" to enable application trace logging. If pageOutput="true", the
trace information will be displayed at the bottom of each page. Otherwise, you can view the
application trace log by browsing the "trace.axd" page from your web application
root.
-->
<trace enabled="false" requestLimit="10" pageOutput="false" traceMode="SortByTime" localOnly="true" />


<!-- SESSION STATE SETTINGS
By default ASP.NET uses cookies to identify which requests belong to a particular session.
If cookies are not available, a session can be tracked by adding a session identifier to the URL.
To disable cookies, set sessionState cookieless="true".
-->
<sessionState
mode="InProc"
stateConnectionString="tcpip=127.0.0.1:42424"
sqlConnectionString="data source=127.0.0.1;user id=sa;password="
cookieless="false"
timeout="50"
/>

<!-- GLOBALIZATION
This section sets the globalization settings of the application.
-->
<globalization requestEncoding="utf-8" responseEncoding="utf-8" />


</system.web>
<appSettings>
<!--<add key="ConnectionString" value="Data Source=rxwebserver;database=*****;pwd=;uid=****">< /add>-->
<add key="ConnectionString" value="Data Source=65.57.230.105;database=**;pwd=**;uid=**"></add>
</appSettings>
</configuration>

[fgomes]

I dont know much about the configuration sections. Your site reported an error at the Authentication Mode = Windows line. You can try the mode as Form, and check it out. Also I have not used the SessionState section, but I remember reading something about using the MSSQL database to keep track of the session states etc. Maybe you can comment out this section to resolve your problem first, and then uncomment it.

[muthukumar]

this is the actuall error we are getting.
------------------------------------------------------------------------------
Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS.

Source Error:

Line 23: "Forms", "Passport" and "None"
Line 24: -->
Line 25:
Line 26:
Line 27:


Source File: *****.sswcweb.config Line: 25

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

fgomes i tried auth mode=forms, got the same error

any help guys, my client wants needs to put up 15 apps in diff directories . plz somebody help

[Brangwyn]

Have you had the virtual directories created yet ?

Parser Error Message: It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS.

As the error says, it needs to be a virtual directory.

[muthukumar]

yes that folder has been given virtual dierctory by vortech.

It doesn't need to be a virtual directory. If you want to run a ASP.NET with a separate Web.Config file, then you need Application enabled for that directory...

[Brangwyn]

And creating a virtual directory does just that, personally I find it easier becuase you can then have a meaningfull VDir name and it doesn't matter what the actual real directory name is.

If a virtual dir was created then are you actually now loading the app using the VDir or the actual "real dir" name.

[antic]

Do I understand this correctly, that you can't create an SQL Server login with DBO permissions on a database?

If that's true, how is a user supposed to create their database, tables, fields, etc? Only database owners can do that as far as I know.

Surely if you have a client and you give them SQL server space for a database, they want DBO access to it.

Question 2 - when you set up a client, do you just assign SQL database space in MB, or can you also restrict the *number* of databases they can create?

Cheers