Well I would like to get understanding on sql server security. how to map windows user eg:'srm123' to sql server agent so that user when logins in sql server can also work with sql server agent.bydefault u can not see sql server aqent icon in ssms in userlogin.what is a role of a proxy and credentials how to map them with windows user to workwith jobs and alerts.
View 1 Replies
I have setup a job in SQL Server Agent which run a store procedure.
[Code]....
After the job excuted, the temp table have not been created.
If I type "exec data_syn_ClearAllEposData". The temp table has been created.
Global Temp table cannot create in SQL SERVER AGENT?
Start Sql Agent Job from Website Can this be done in VB?
View 2 Repliesi have an asp.net application that connects to a database. I've set up the connection string with the correct server name and username/password. This use to work perfectly. Suddenly for some reason, when i navigate to the site i get a Login failed for user
admin. Account locked. I check the server and the account is not locked, but just to be sure i reset the password and change my conn string accordingly. This makes no difference and i still get the account locked error message.
I would like to do a connection of asp.net page with Sql Server. Here I would like to read the Windows user account name and pass in the connection.The connection should be Windows authentication. IIS server and Sql server are installed in different machine. Here I am able to connect locally, When I am running from server, It takes windows account of Server.
so i can read local account(Where user is accessing the web application) and make windows authentication sql server connection.
I am trying to run a Stored Proc in 2008 using the sql agent. I read some posts on here and other places that say you can and I have tried what they said but isn't running. I can execute the proc form a query window and its working fine so its not my proc.I setup a job and then created a step named the step run stored procType: not sure here but I left it at default T-SQLChanged the database to the database where my sp is located Then in command i put exec dbo.sp_myprocname
View 2 RepliesI am facing grouping the agent wise in stored procedure, here i showned the table columns,views and stored procedures i used.
User Table columns
User_Id,pwd,Created_Dttm,Role,Status
Table1 columns[code]....
Problem is when i am group by A.Name i am getting error "Column 'V1.Target' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause."
I'm getting "Windows NT user or group 'domainwebservername' not found" when I query the following. Why? This is how I got ny domain and webservername.
Response.Write(Environment.UserDomainName);
Response.Write(Request.ServerVariables["SERVER_NAME"]);
-- Create a SQL Server login for your application's domain account
sp_grantlogin 'domainwebservername$'
-- Grant the login access to the membership database
USE aspnetdb
GO
sp_grantdbaccess 'domainwebservername$', 'Web Server Name'
-- Add user to database role
USE aspnetdb
GO
sp_addrolemember 'aspnet_Membership_FullAccess', 'domainwebservername$'
How to write a webservice to call the proxy server through IIS webserver?
View 2 RepliesHow can I access Subject/Body content of emails from a POP3 account using SQL Server Stored Procedures?
View 3 RepliesI have a website [URL]. Recently I found out that somebody has set up a reverse proxy with an almost identical url "www.website1.com" in front of my website.
I'm concerned of those users who came to my website through that reverse proxy. Their username and passwords might be logged when they login.
Is there a way for me to have my web server refuse reverse proxy?
For example, I've set up a reverse proxy using squid with the url "www.fakestackoverflow.com" in front of "www.stackoverflow.com". So whenever I type "www.fakestackoverflow.com" in my web browser address bar, I'll be redirected to "www.stackoverflow.com" by the reverse proxy. Then I notice the url in my address bar changed to "www.stackoverflow.com" indicating that I'm no longer going through the reverse proxy.
"www.stackoverflow.com" must've detected that I came to the website from another url and then redirected me to the website through the actual url.
I am currently using C# and the webClient class to downloading and uploading images, data, see code below
[code]....
This works fine for a direct internet connection, but fails through a proxy server.
And giving the error "The remote server returned an error: (407) Proxy Authentication Required."
I have tried using the default credentials in the credentials property
[code]....
I have started having problems with our asp.net webform applications running behind a proxy since the user base have upgraded to IE7. Some postbacks seem to drop out and at times it is difficult to make controls on a page raise an event. It appears to be intermittant and I have been told there are issues around using IE7 behind a proxy with post requests. Is this the case and what are the options? Rewite in MVC? Does the issue of post requests behind a proxy remain in IE8?
View 3 RepliesWe are using 2 ISA proxy servers in front of our webserver and are getting intermittant Ajax errors in our application.
Our web logs indicate that there are 407 errors occurring during the requests.
When other users hit the webserver directly this issue does not occurr and this is also not an issue in IE8 but is in IE7.
The error dialog has Sys.WebForms.PageRequestManagerParserErrorException and the details say "error parsing near '<!DOCTYPE html P'
In an article I have read "A web browser can be named as proxy server. As safari, chrome, mozilla".But proxy server is like a an intermediatary btween the clent and server know?
What is actually the difference between the two?
our web application should be hosted under proxy server, for that we had to change our URL to be relative.
we changed all the url's but then we saw that web resources that are embeded in the .net dll's are being written to the page with absolute path, start with "/" for example:
[Code]....
how can we change it? how can we set the web resource to be relative like this "../webresource.axd"
I am trying to deploy through webmatrix but my system Proxy server configuration is not being used. I assume that webmatrix would detect the proxy server settings and use that for the msdeploy calls under the hood. Can anyone confirm this is a know issue?
View 1 RepliesThe remote server returned an error: (407) Proxy Authentication Required.I get it when I use the GetReponse() method in WebRequest Dim request As WebRequest = WebRequest.Create(getNextURL()) Dim httpResponse As HttpWebResponse = CType(request.GetResponse(), HttpWebResponse)
View 1 RepliesI am trying to make a web request programmatically. When i submit the request through the browser it seems to work fine but when i programmatically submit the request it comes back with this error message "Unable to connect to the remote server"
Below is the code i am using to executing the command,
[Code]....
[Code]....
I assume the reason why i am getting the error message is because the proxy server has not been set programmatically. Can somebody tell me how i can get the proxy server and set it programmatically?
I need to simulate a proxy server to test mobile device c# application.
Is there a way to do this? how should I do this.
the site normally works fine in all popular browsers including firefox, chrome, safari and ie.
but doesn't work in ie 8 when it's redirected via a proxy server and it gives an error saying
"Message: Sys.WebForms.PageRequestManagerParserErrorException: The message received from the server could not be parsed. Common causes for this error are when the response is modified by calls to Response.Write(), response filters, HttpModules, or server trace is enabled. Details: Error parsing near 'DOCTYPE html PUB'."
I've got an ASP.NET website, and its connecting to a database I've created on SQL Server 2k8 and I'm using windows integrated security on my connection string between asp.net and SQL Server. What account should I give permissions to my database inside SQL Server? Should I give NT AUTHORITYNETWORK SERVICE permission to my database? Right now, I right clicked the network service account, and went to properties, and then I checked my database under "users mapped to this login:" and then in the "database role membership for" diaglogue I then selected public and db_owner. Is that right?
View 1 RepliesSome of my users are getting the following error
HTTP 502 Proxy Error - The size of the response header is too large. Contact your ISA server administrator. (12216) Internet Security and Acceleration Server
I am guessing it has to do with the size of hidden "__ViewState" tag in my ASP.NET pages.
I also realize that this is restriction imposed to by IT on the users end and I have no contol over it.
I disabled ViewState on all the controls in my ASP.NET pages. However, __ViewState is still generated very large (as always) to persist control-state (e.g. checkbox, radiobutton, etc.)
I have a web app Which Uses Forms Authentication.
One thing that we want to be able to do on Support is login to a specific users account Via our admin account.
We are using the standard asp.net membership authentication.
The idea would be for the support technition to be able to login using credentials like admin(<Troubled User>) using the Admin Account password
We are using a a Standard ASP.Login Control
The real Issue is that the Me.Page.User.Identity.Name is set to the value on the CtlLogin.Username Property. I need it to be the the Support Login?
Login Control
Code:
<asp:Login ID="ctlLogin" runat="server" DisplayRememberMe="False" Font-Names="Arial Rounded MT Bold" Font-Size="12pt" ForeColor="Black"
MembershipProvider="MembershipProvider" Width="100%" TitleText="" UserNameLabelText="User" VisibleWhenLoggedIn="False" RememberMeSet="True"
PasswordLabelText="Password" EnableTheming="False" Height="35px" >
[Code] ....
Validate User Script
Code:
Dim objstrSupUser As String = ""
'Load the user from the membership provider
Dim strUserName As String = ctlLogin.UserName
If ctlLogin.UserName.IndexOf("(") > 0 Then
objstrSupUser = Regex.Match(strUserName, "(([^)]*))").Groups(1).Value
[Code] ....
Do I just need to make a field for account type in my user account table? In a technical way, if(account type = admin) then the account would log as admin; otherwise, a user with less privileges.
View 7 Replies
