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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SSL Using Server Created Certificate

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
We need to secure a SQL server using an SSL certificate and I understand there are a couple of ways of doing it.  One of which is having SQL Server generate a self-signed certificate which exposes the man-in-the-middle attack vulernability.  Thus we want to avoid this approach.  My question is, can we just allow the Windows Server 2003 we are running to be configured to be a Ceriifcate Authority and ust it create an SSL certificate.  Is that just a secure as getting an SSL certificate from a third party company such as Verisign?  If it is better to go with a third party company, how do you get a certificate from them when it is not going to be used for a website? Thanks NickNick's Programming Tips

View Complete Post

More Related Resource Links

MS Word Component Not Getting Created on Windows 2008 64 bit Web Server Edition When I Try Using ASP

Hi All, This might look like a similar question to a lot of you considering there are a lot of web activity happening in terms of blogs/forums/suggestions that I have seen with reference to changes that one needs to do in COM+ Services to enable their ASP.NET Web Application to be able to create Word Objects & I have actually used them personally & they worked for me on Windows 2003 32 bit/64 bit servers. The issue started some 1 month back when I was told that we are upgrading our server to Windows 2008 Web Server edition 64 bit ‘cause of some real benefits it offers if used only as a web server. This was just great as we tested a lot of features /functionality that we were using on our existing server & everything seems to be working just fine on this product by Microsoft. However we also have one web module which is responsible for opening up a MS Word 2007 template file at runtime and fill it with data & is then converted into a PDF document. A lot of ideas on Web suggested that we should move onto Open XML standards to generate documents at runtime, which I have been able to do with no issues. But one activity which still requires me to create a Word document is when I have to convert/SaveAs the Word (docx) document into PDF. I tried all the COM+ & registry related changes that I did on my Windows 2003 64 bit server, but nothing seems

System DSN created on x64 08 server but not visible - SQL08 x64 to be used by x32 app

Hi all, I am trying to create a SystemDSN on a 64bit Windows 2008 server. The application that will use it is a 32bit app so i go into C:\Windows\SysWOW64 and run as admin odbcad32.exe I then go ahead to create a systemDSN to a SQL2008 database using the SQL native client. All off the steps of the systemdsn creation wizard go thrugh and i get a success at the end. But then i get no new systemDSN listen in the box. The user that is doing the creation is a domain administrator and also in the admin group on the particular server. This is really strange to me. Has anyone seen this behaviour? SQL server 08 is x64 on a x64 machine. The reason i am using the 32bit ODBC is beacause the app is x32 app. Any advice? Cheers Dan

SharePoint - Report Server - Client Certificate authentication

Hi,I have a SharePoint site collection which requires client certificates. On the server I have configured Reporting Services in integration mode.I can call reports on other site collections which don't require client certificates but not on the site which does. On the site which requires client certificates the pages fail with the following error message:'An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> The request failed with HTTP status 403: forbidden'The error message indicates that SharePoint doesn't call the web service with a client certificate. Does anyone know how I can configure SharePoint to use a client certificate?Any help is greatly appreciated.Adam

SQL Server not starting - FallBack certificate initialization failed

I can not start my SqlServer 2008 Express. The problem seemed to start when I changed my "Built In account, Log in as" from Local Service to Local System. If I try to change back to Local Service I get the messagebox with WMI Provider Error, "Cannot find object or property. [0x80092004]". Getting a bit confused, but read http://support.microsoft.com/kb/900497    mentioned about  HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib, Value name: Certificate, Type: REG_SZ not having a valid value then 2005 would not starte - my value is blank. Changing it to 0 did not work.How can I import a valid certificate using SQL Server Configuration Manager. And how do you turn off Forced Encryption? Not sure if this would fix it, but couldn't hurt.====================================== 2009-03-08 01:39:06.01 Server      Error: 17190, Severity: 16, State: 1.2009-03-08 01:39:06.01 Server      FallBack certificate initialization failed with error code: 1.2009-03-08 01:39:06.01 Server      Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate.2009-03-08 01:39:06.01 Server      Error: 17182, Severity: 16, State: 1.2009-03-08 01:39:06.01 Server      TDSSNIClient initialization failed with error 0x80092004, status code 0x80. Reason: Unable to i

One-To-One Client Certificate Mapping in Exchange Server 2010 WCF Configuration

Hi.I am having a java client which has proxy classes generated with jax-ws to use the exchange web services (exchange server 2010). This proxy only supports SOAP11.What I need is to configure exchange servers with CAS role to (additionally to the default authentication) map one certificate to one windows accout. Until now I: imported the servers certificate and enabled it (import-ExchangeCertificate -fileData ([Byte[]]$(get-content -path <certpath> -encoding byte -readCount 0)) -password:<security-string pwd> | enable-ExchangeCertificate -services IIS) created a client certificate mapping in IIS 7 and here is where I got stuck What do I have to change in the "...\V14\ClientAccess\exchweb\ews\web.config" to get this scenario work?The web.config file looks like this: <services> <service behaviorConfiguration="EWSServiceBehavior" name="Microsoft.Exchange.Services.Wcf.EWSService"> <endpoint address="" binding="customBinding" bindingConfiguration="EWSHttpsBinding" contract="Microsoft.Exchange.Services.Wcf.IEWSContract"> <endpoint address="wssecurity" binding="customBinding" bindingConfiguration="EWSWSSecurityBinding" contract="Microsoft.Exchange.Services.Wcf.IEWSContract"

debugging stored procedure created in sql server 2008

Hi experts,     I want to get rid of old debugging of stored procedure where we use print statement. I know how to debug the stored procedure just wanted to ask, can i get the details of #temp or @tbltemp(TABLE datatype) variable values while debugging

debugging stored procedure created in sql server 2008

Hi experts,     I want to get rid of old debugging of stored procedure where we use print statement. I know how to debug the stored procedure just wanted to ask, can i get the details of #temp or @tbltemp(TABLE datatype) variable values while debugging

C# Database created but does not show up in Server Management Studio unless I manually attach it.


I used C# Linq to Sql to create a database. I look on the hard drive and the database .mdf and .ldf files are there. I open Server Management Studio 2008, attach to SQL express and the database is not there unless I actually attach the database.


First, is this correct behavior?

Second, is it possible to create a Sql Express database that is automatically registered(?) in Management Studio? If so, please give pointer.


Thanks very much.



SQLServer2008 job created by Copy DataBase Wizard fails - cannot determine if job owner has server a


Trying to copy a SQL2000 database on server TUNA to destination server MOJITO which runs default instance of SQL2008 (at ServicePack1) via the CD Wizard. Resulting job fails on MOJITO with this in application log:

SQL Server Scheduled Job 'CopyDatabaseWizard_TUNA_MOJITO_1' (0x64AB69F2880A7E4DA3708546C33DFF40) - Status: Failed - Invoked on: 2010-09-23 17:05:04 - Message: The job failed. Unable to determine if the owner (CBMIWEB\johna) of job CopyDatabaseWizard_TUNA_MOJITO_1 has server access (reason: Could not obtain information about Windows NT group/user 'CBMIWEB\johna', error code 0x5. [SQLSTATE 42000] (Error 15404)).

There is a credential on MOJITO defined for CBMIWEB\johna. There is a proxy on MOJITO that uses that credential. The job has one step and in the properties I have set the RUN AS value for the job to be the name of the Proxy. The proxy is established for SSIS jobs.

The "owner" of the job is also CBMIWEB\johna which is a domain userid in the local Administrators group of each machine (both TUNA and MOJITO). This userid has been granted the permission to Logon as a Batch Job on both servers.

TUNA is a Windows 2000 standalone server; MOJITO is Windows 2003. I can logon to each server as CBMIWEB\johna.

I don't know what else to do.

Does Transfer SQL Server Objects task transfer objects created in the source AFTER the package has b

I created an SSIS package which contains a Transfer SQL Server Objects Task. I configured this task to copy table objects, stored procedures, and object permissions to the destination. Between the time I created my SSIS package and the time it was run, someone created a new table object in the source, and changed permissions on a stored proc in the source. My question is this, at the time the SSIS package is created, behind the scenes, does SSIS create a list of objects to transfer? I had hoped that it creates the list of what specific objects (of the pre-defined type) to transfer at runtime so that whatever changes were made to the source database would be included at runtime.

MS SQL Server on WIN7 connection from PDF file created on LC ES2 - failed


So I created a PDF from in Adoble LifeCycle ES2, chose the right DSN and made sure the connections worked to the MS SQL server. SQL server was up and running and I couild log in. In the form, I was able to see and use all of the tables and fields to populate the forms just fine, saved it.

Issue: When launching the form, I get a 'Connection from Source (name) failed because the environment is not trusted'. And it does this for every connection. I tried several different DSN methods and while some connect in the Adobe form creation and I see the tables created in SQL Server, I cannot link to them to update. Funny part is, the data in the SQL database already there, does populate the form.

Am I missing something obvious?

Install Requirement - The instance name is arbitrary and was created when Microsoft SQL Server was i


On this Technet Article http://technet.microsoft.com/en-us/library/ee662513.aspx related to service account permissions during install there is this requirement mentioned: "The instance name is arbitrary and was created when Microsoft SQL Server was installed."

Does anyone know why the instance needs to be created when SQL Server is installed as opposed to later after SQL Server is already installed?

How to get notification if a new login is created in SQL Server??



I have a requirement wherein to automate a process that when a new login is created in SQL Server 2005, I need to execute code to add the newly created username to another user table in my database.

I am aware of the system tables that can be queried to pull out the list of logins that exist in SQL Server database and identify any newly created logins.

However, I am looking at an alternate solution that allows me to get notified when a new login is created. It would be more like a trigger. Since I am dealing with system tables, I don't want to user triggers on system objects.

I have come across SQL Server Notification Service but I am not sure if it would be an appropriate feature to use for such a requirement.

If anyone knows of a better solution or if SQL notificaition services can be used for this, please share your thoughts.




SSRS - Retreiving generated Parameters from Report Server created by using StoredParametersID


SSRS - Microsoft SQL Server Reporting Services Version 9.00.4309.00

Problem - StoredParametersID is an rs: (report server) parameter and is not a valid Report Parm and can not be used in web services calls as a parameter. It can not be used as <deviceinfo> and it cannot be used as a "ReportPath" in the web services call.

How can I retreive the current set of generated parameters that are created on the report server side, so I can use these to make a web services call to retreive the Drill Down report since the only method to retreive the report information seems to be a Report URL call with the StoredParametersID included.


SSL Certificate not shown up in Protocols for MSSQLServer for SQL Server 2008 R2


I had imported SSL certificate through MMC to local computer account and the certificate reflected in the ‘Protocols for MSSQLServer’. Encryption worked fine with the certificate.

Then I deleted certificate from local computer store and imported again (through MMC). But no certificates are shown in Microsoft Configuration Manager. I am not able to add certificate to SQL Server.

I followed the steps in the below URLs



Can someone help?

This web site must be created on a server that is running Microsoft Sharepoint Foundation. Please ch


Hi all, I installed microsoft sharepoint designer 2010. It was working perfectly up until yesterday when I create a new site, it gave me an error that said " This web site must be created on a server that is running Microsoft Sharepoint Foundation. Please choose another Location " Now I can't create any sharepoint site and it freaks me out. I tried repairing, unistalling and reinstalling but still i get the same message. 

Communicate to secure enable server with certificate



Currently I am facing a problem to communicate with a server that enable ssl...

normally we are using TCPClient to send and receive data from server, but now the server that I trying to connect to, need SSL and certificate..

Is there anybody experience on it?

I was trying to search at google and most of the solutions i got it is use SSLStream and X509Certificates. and I have another question, Am I need to create Client and Listener in order to communicate with that server? Because I had reviewed all the sample and they didn't attach the private key when send request to server. is there anyone able to help me to solve this problem?

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