.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

How to logon to FTP server with cetificate, using SSL

Posted By:      Posted Date: October 16, 2010    Points: 0   Category :.NET Framework
 

Hi all,

I have a certificate file that was supplied to me by my FTP provider.
What are the steps I need to use the cetificate for authentication?
I would appreciate some sample in C#.

Thanks in advance.




View Complete Post


More Related Resource Links

sqlcmd - linkedserver - ALL queries fails after FIRST error from remote server - ANONYMOUS LOGON

  
Hello, I have very strange problem with sqlcmd , it stop working after first error returned from remote sql server (like permission denied), lets try show what I'm doing, configuration is quite simple C- client (windows 2003 x64, standalone sqlcmd client sp3) S1 - server1(windows 2003 x64, sql 2005 sp3) S2 - server2 (windows 2003 x64, sql 2005 sp3) I need connect via middle Linked Server (S1) from C to to S2, each machines have the same LOCAL Windows account C\LSUser, S1\LSUser, S2\LSUser with the same password, LSUser is not domain account, linked server is configured for Windows Account Impersonation (checked Impersonate) Example, query executed from client C: 1>exec [LS1].[DB].[dbo ].[ListTab1]; - works well, no problem 1>exec [LS1].[DB].[dbo ].[ListTab2]; - works well, no problem ok , now try modify permission on S2, I explicitly deny execute procedure [DB].[dbo ].[ListTab1] on S2 to S2\LSUser, 1>exec [LS1].[DB].[dbo ].[ListTab1]; Msg 229, Level 14, State 5, Server S2, Procedure ListTab1, Line 1 The EXECUTE permission was denied on the object 'ListTab1', database 'DB', schema 'dbo'. expected message :), but look now: 1> exec [LS1].[DB].[dbo ].[ListTab2]; Msg 18456, Level 14, State 1, Server S2, Line 1 Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. all remote queries STOP working from client C 1> select top 10 * from [L

Sharepoint server 2003 logon issues

  

Hello,

I'm running the above mentioned version of Sharpoint on Win2003 server. I had to change domain admin password and now my Sharpoint doesn't work. I have manually changed all the passwords for Sharpoint services using domain admin account and also in IIS but with no success. In the event manager there is buch of error messages mostly refering to bad password or user name during logon. What am I missing?

Thanks

Daniel 


SQL Server broken - cannot reset 'logon as ' built-in account - urgent

  

 

SQL Server Express 2008, on a standalone XP Pro fully updated, with a named instance of COMPUTERNAME\SQLEXPRESS.

As installed, the 'log on as' was set to NT\NETWORK SERVICE. Basically things worked, though I had some issues, now irrelevant. Foolishly I went into SQL Server Configuration Manager, clicked on SQL Server Services, in the right pane right-clicked on Sql Server (SQLEXPRESS) - Properties, on the logon tab - Built-in account, which showed Network Service.

 

From the dropdown, I selected Local Service and probably Apply, then Start, though maybe vice versa.

 

This stopped pretty much everything working, e.g. no access via Managment Studio etc (cannot login). Now if I attempt to select Network Service from the dropdown to put it back to what it was:

- If I click Apply I get a message box : Cannot find object or property [0x80092004]

- If I click Start there is a long wait while the progress bar ticks over, then a message box with 'The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details'

 

In the logs folder the log starts with informational stuff that looks to me to be pretty

Logon to server (local) failed (ConnUpdateStartExecutionDate)

  

Hi,
I get the below erro in the event logs from MSSQLSERVER.

Error: 60000 Severity: 16 State: 1 SQL Error Log: [382] Logon to server (local) failed (ConnUpdateStartExecutionDate)

No idea if it is related to high memory utilization of SQL Server.
How to get rid of it.


Suman

Can't logon to SQL Server

  

Dear users,

 

SQL Server 2008 Enterprise.

When I tried to logon this morning I couldn't logon. I had no problem until this morning. What do I do to fix this?

 

TITLE: Connect to Server
------------------------------

Cannot connect to ABCD123.

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

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

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

Thank you in advance.


SQL Server 2005, NT AUHTORITY unable to logon

  

Hi,

In the event log of my SQL server I get this error every two minutes:

"Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: <local machine>] Error 18456, Severity: 14, State 16"

I have spent alot of time Googling and reading through this forum but to no avail. I ran a trace according to this site: http://www.eraofdata.com/blog/2009/01/, but I am not able to find anything that seems related to the problems I am experiencing. The few events created by NT AUHTORITY\SYSTEM are of the class SQL:BatchStarting and SQL:BatchCompleted.

The first event says this:

"select serverproperty(N'instancename')"

and the second event this:

"select ServerProperty('ErrorLogFileName')"

Should instancename be the name of the server? What is the next step to troubleshoot this problem?


SET Options on user logon / SQL SERVER 2008 R2

  

I need to capture the logon event and set some options (SET DEFAULTS, SET ANSI_NULLS, etc) and those options should be set that way during all the user's session. I thought a server trigger for logon would do it, but I found out it runs BEFORE the user's session begins, so it does not do the job. I need to set the options only for certain users of an application I don't have the code for.

I also read it could be done using alerts and  auditing, but I'm not sure how. I would appreciate any suggestion.

Thanks

Christian S.


Linked server fails -Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. with SQL2008R2

  

Hi, Kerberos seems to be malfunctioning with SQL2008R2.

 

I have a new dev SQL2008R2 server called BDSDEV2 and an upgraded(in-place) SQL2008R2 server BDSTEST2.

From BDSDEV2 , I can successfully issue a linked server query to BDSTEST2

select * from bdstest2.eis_prod.dbo.wcs_agent

 

But from my client in SSMS, connected to BDSDEV2  , the double hop is failing to BDSTEST2 for same query 

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

 

I have another BDSDEV1 server, which is SQL2008 and there double hop IS WORKING

From my client in SSMS, connected to BDSDEV1  ,I can successfully issue the query to BDSTEST2 .

 

The service accounts  for MSSQLSERVER are both local admins on their servers and sa's

I have confirmed SPN is OK 

This is from BDSDEV2 - sql2008r2 server.

C:\Program Files (x86)\Resource Kit>setspn -L tsqlssvc

Registered ServicePrincipalNames for CN=TSQLSSVC,OU=SvcAcct,DC=corp,DC=saif,DC=c

om

call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side.

Making Ajax Callbacks to the Server Using jQuery with ASP.NET

  
In the first part of this article series I introduced jQuery's functionality and how it provides a rich client side programming model. This time around I'll expand on these concepts and show you how you can use jQuery in combination with ASP.NET using it as an AJAX backend to retrieve data. I'll also discuss how you can create ASP.NET controls and otherwise interact with jQuery content from ASP.NET pages in WebForms.


jQuery is just a JavaScript library so it will work seamlessly with ASP.NET both from page code as well as through backend driven code using the Page.ClientScript object or ScriptManager. You can use jQuery on its own as a client side and Ajax library that communicates with ASP.NET or you can use jQuery in combination with ASP.NET AJAX. The two actually complement each other quite well as jQuery provides functionality that the ASP.NET AJAX library does not and vice versa. For the most part the interaction between the two libraries is trouble free except for a few very rare edge cases.

MS SQL Server: Disconnect Users From Database - Kill User Session

  
If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

  
If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side

Publishing SQL Server Database using Publishing Wizard : Tips & Tricks

  
We can use SQL Server Publishing Wizard to deploy our local Database to remote hosting server/production server.This feature is available in SQL Server 2008/VWD 2008.

Below is the complete step by step guide of this process.

CLR Integration With Microsoft SQL Server

  
Transact-SQL provides as much flexibility as possible but, because it is not a real programming language, it has some shortcomings about many issues (memory management, exception handling, debugging, file processing (or streaming), object-orientation (classes), or thread management). Transact-SQL also lacks features of normal libraries (arrays, collections, serialization, expressions, or string manipulations, etc).

IP Address Blocking or Restriction in SQL Server

  
"is it possible to block connections to SQL Server based on IP address". As far as now there is no official way in SQL Server to block the connections in SQL Server based on IP address. However this can be done from the OS end, we have the following three options available, refer HERE for more.


.Firewall
.IPSec
.RRAS IP Filter

Determine whether Forms Server is installed on a server

  
Check whether the Microsoft.Office.InfoPath.Server.dll and FormServer.aspx files are installed on the server.
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend