Access Sql Server Without Directly Permission In Domain?
Apr 15, 2010
Here is the situation. All the machines and users are in the same domain.We are in a domain enviroment. There are some sql server 2005/2008 storing data. There is a ASP.NET site in the domain using the Window Authentication. Now, we need read the data from the sql server and display them using SqlDataSource and GridView. But most of users do not have the direct permission to access the database. Is there any solution to get the data from database and display them on the site without granting users permission?
I have this polling script to check if a text file is created on the server. Works great locally, but fails when the file is on a different domain. How would i rewrite this for cross domain support?
EDIT: I ended up using YQL to solve the cross domain issue and although it works, YQL is really slow that's adding quite a bit of performance overhead. Can anyone suggest a better solution for cross domain JQuery calls?
I have upload my files in domain.after uploading,i run the site.i get the following error The EXECUTE permission was denied on the object 'xxxxxxx', database 'zzzzzzz', schema 'dbo'. what reason for this error raised and how to solve it?.
How can i directly access a .cshtml file in ASP.NET MVC using razor view engine?
For example i have this url: localhost/Home/About. This will load the about site inside the "master" page.
I want to load the about page without also loading the master page. So i was thinking that i could use this url: localhost/Home/About.cshtml. But it's not working.
How can i load a view page without loading the master page?
I just moved my website from one server to another.It is a simple website to display news. I used dnn for it. The news module is made of a NEWS_ADD.ascx control and a NEWS_EDIT.ascx control. Now on the new server, when I try to edit the existing news, or try to add a new one, it says: "you don't have permission to access /manageadmin/newsadmin/tabid/72/ctl/edit/mid/376/mode/add/language/fr-FR/Default.aspx on this server."
I have the following pages structure in my asp.net 3.5 website. i want if anybody directly access any page of my site as [URL] then it will automatically redirected to [URL] How to do this using vb.net, asp.net
I want to upload files in my Asp.net application on server but I have to grant it R/W access so that I or anyone can upload files in it. Is there any way that I write some code or configuration lines in Web.config which solve this permission problem?
I have recently succeeded doing a Publish to server from my local sql db and run the sql script on my web host's sql server 2005 db. Now, I get the "The EXECUTE permission was denied on the object 'MyStoredproc', database 'db12345', schema 'dbo'." error.I have Visual Studio Professional 2010, and that's where I create and manage my tables (in Server Explorer). However, when I right-click a stored procedure, I don't get a Seurity option or the like, where I could possibly set permissions.
I'm a bit usure of what SqlServer applications I have installed (as they are intertwingled with the Aps.Net stuff somewhat). When I look at Add/Remove software, this is what I find:
Microsoft Sql Server 2008 (562 MB) Microsoft Sql Server 2008 Native Client Microsoft Sql Server 2008 R2 Data-Tier Application Framework Microsoft Sql Server 2008 R2 Data-Tier Application Project Microsoft Sql Server 2008 R2 Management Objects Microsoft Sql Server 2008 R2 Transact-Sql Language Service Microsoft Sql Server 2008 Setup Support Files Microsoft Sql Server Compact 3.5 SP2 ENU Microsoft Sql Server Database Publishing Wizard 1.3 Microsoft Sql Server Database Publishing Wizard 1.4 Microsoft Sql Server System CLR Types Microsoft Sql Server CSS Writer
Can I use any of these apps to set the security settings? Or would I possibly not be allowed to change any settings at the web host's Sqlserver 2005 server anyway (due to security reasons)? Frankly I don't think I could ask them to change the settings for over a hundred stored procedures, and then call them each time I create a new one.
And also, I can't understand what the point would be in setting different security levels on SELECTs and UPDATEs etc. After all, all my pages call UPDATE statements (for collecting statistics). I guess that the host could set execute permissions on the entire folder (not sure though) but it would of course be a stupid idea if I'm wrong regarding this matter.
Using VS 2008, and i downloaded sql server 2008 that came with installation. I created an applicaton, which runs perfectly when i click run from VS. but when i moved it to wwwroot folder, this error poped up:
CREATE DATABASE permission denied in database 'master'. Cannot attach the file 'C:InetpubwwwrootooksApp_Dataooks.mdf' as database 'books'. This is my <connectionStrings> <add name="books" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=C:InetpubwwwrootooksApp_Dataooks.mdf; Integrated Security=True; trusted_connection = true; User Instance=False; Initial Catalog=books" providerName="System.Data.SqlClient"/>
I have an aspx application using Entity Framework 4.0 and SQL Server 2008. Everything works fine. It's an internal application, so we developed a basic backend for routine maintenance. Some minor data updates are done directly into the SQL Server using SQL Management Studio... the problem is those changes are not reflected in the application! Only after reseting the web service or the server, the new data is displayed.
I have restricted the web login used by my ASP.Net pages to only run procs and pull data from views, it never has direct access to tables. My problem is if I add a new proc or view I have to modify the login's permissions to give access to the new items. Is there some way I can set the login to automaticly have the correct permission to new views/procs I add?
How can I give my ASP.net website permission to see this folder on the server? C:PVSWin. The website is actually running on a virtual path D:WebSitesAdco.We are running IIS ver 6.The website uses a table from Pervasive to locate Vendors. The SqlDataSource works from the VS2008 IDE which is running on the server, but if a user logs into the website remotely they get this error:ERROR [IM003] Specified driver could not be loaded due to system error 1114 (Pervasive ODBC Client Interface). This error generally indicates that the path to the DB components is not found, or is not available to the calling program, so I guess that the website does not have permissions.
I would like to build a Shared Documents Library in ASP .Net and SQL Server but I have a problem, the customer wants to open the documents (stored in SQL Server) in Office UI and when save it, the document should be saved directly in database like SharePoint Server.
I've been researched on web since last week and I didn't found any answer or specific technology to do this.
I need to set folder permission programmaticcaly which is in my GoDaddy server. I have nearly 150 folders in my server so I cant change through server settings or IIS settings. I am using web application. My folder may go on increase in future.I have googled a lot of things.
1. Like Access Control List in System.SEcurity namespace
2.System.principl.security...
I cant able to change the file permission but not a directory.
I must allow all the users to write or move a file to the folder which is in read only mode. That should be done programmatically and should be dynamic.
Im working on an application that has a login section that accepts a username and password. On successful login a userid is returned and encrypted with TripleDesKey. The user details are then stored in a session object. We already have a class library that performs encryption and decryption using a key in the web.config file. I basically want to be able to access the user details of the currently logged in user in a page accessed from the main site that may be in a different domain, but is effectively part of the same site, so I wont have access to the session object from the main site. so basically a user logs in, I have the user details stored in a session object, I also have access to the encrypted userid also in a session object. If a user then clicks a link to another page that is in a different domain, how do I persist the userID?
I suppose I could I tag the encrypted userid to the querystring, but security could be an issue here (even though the id is encrypted, someone could still modify it)
Currently in my application using LDAP to authenticate user to a specific domain & then i check if the user exist in my site database.
Now i need to also allow users who do not belong to this specific LDAP domain to access my site ..How can i make it possible withoput affecting the exisiting users?
Server A exists on domain A and server B exists on domain B. From server A I need to output file names that exist on shared folder on server B. I tried the following with no success (Access denied error):
DirectoryInfo dir = new DirectoryInfo(@"\serversharedFolder");
After some Googling I found that I need to use personlization to impersonate an existing user on Server B that has access to that shared folder. I used a C# personlization class as explained on codeproject (http://www.codeproject.com/KB/cs/cpimpersonation1.aspx). I supply the domain, the user, and the password and hope to get access to the shared folder BUT the error I see now is"Login failure: unknown user or bad password".
I am 100% sure that the domain, user, and password I supplied are correct. When trying to access the share via windows explorer from server A I am prompted for a username and password. After entering domainusername and the password I have access to the folder. So I know that the credentials I supplied are correct.
Am I going about this the right way? I have full access to server A and B so maybe there is an easier way to accomplish my goal.
I have created an access database and i have shared (permision is full for everyone) the folder to get access to it. It works fine from the same domain from any pc i am able to access it.
but was not able to access it from a different domain. is there anyway i can make it happen???
basically all are under same company but different location hence different domain i am able to access anything that is shared
from any location
from other domain just by typing \ and the computername or IP address to get me the shared folder
Session("CellNo") = New List(Of String)() From { _ "CellNo1", _ "CellNo2" _ } Session("SMSMess") = New List(Of String)() From { _ "Messagetext1", _ "Messagetext2" _ } ' Popup window. ' Generate many iframes to send SMS. Dim CellNo As List(Of String) = DirectCast(Session("CellNo"), List(Of String)) Dim SMSMess As List(Of String) = DirectCast(Session("SMSMess"), List(Of String)) For i As Integer = 0 To CellNo.Count - 1 Dim url As String = [URL] ?usr=USERID&pwd=PASSHERE&sndr=SENDERID&ph=" & CellNo(i).Trim() & "&text=" & SMSMess(i).Trim() & "&rpt=1" Response.Write("<iframe frameborder=""0"" height=""1px"" width=""1px"" src=""" & url & """ />") Next
I'm using above Code to send SMS. For some reason I can't send SMS Directly as my web server doesn't allow to browsing other sites. But above code sending only 1 SMS.
is there any way to copy/transfer files directly from client to ftp server through my web application? user will select files through fileupload control.
