.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

SQL SERVER 2008 TDE / Pass Private Key from Connecting Client

Posted By:      Posted Date: October 09, 2010    Points: 0   Category :Sql Server

With TDE is it possible to pass the private key for an encrypted database from the client? 

I need to secure the database from the machine users.  They should only be able to access the database through my software, a C#/.Net app.  The server should only have the certificate and master key. 


View Complete Post

More Related Resource Links

Using SQL Server 2008 R2 client with Enterprise Library



I am modifying an existing application that uses SQL Server 2008 as the database and Enterprise Library 4.1 for Data Access .

What I need to do is to make it use the SQL Server 2008 R2 client to take advantage of out of the box failover capabilities.

Any idea how I can accomplish this?


SQL Server 2008 not connecting to servlet using netbeans

using latest driver from MS site.   added jar and dll in jdk/bin and dll in windows\systems32 , also added library in netbeans added -Djava.library.path="D:\libraries\mssql\auth\x86" in netbeans run. Still getting com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication exception.

Problem connecting to SQL Server 2008 R2 Express from Access 2007

I have a problem with SQL Server 2008 R2 Express with MS Access 2007. I am running Windows 7 with 8 gigs memory. I installed SQL Server 2008 R2 Express. Do I now need to install SP1 because I am running with Windows 7? I can open SQL Server using the Management Screen but I cannot connect to MS Access 2007 using SQL Server Express as the database. When trying to connect to SQL Server from Access 2007, I keep getting the message that SQL Server 2005 cannot be found. It will not allow me to sign onto sql server 2008 stating that it cannot be found. Do I have to now run the SQL Server 2008 R2 Express SP1? Is there an upgrade to MS Access 2007 which will allow me to use SQL Server 2008 R2 Express?

Connection problem while connecting from client to server.

Hello, i am trying to connect sql server 2005 express using c#.net 3.5. my connection string is "Server=.\SQLExpress;AttachDbFilename=C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\db_naren.mdf;Database=db_naren; Trusted_Connection=Yes;" this is working fine when i am connecting to sql server from the local machine. When i am trying to connect from someother machine to server it is giving error like 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) i added previliges in add new administrator on SQL Server 2005 Surface Area Configuration . and i made changes on SQL Server 2005 Surface Area Configuration  page, on Database Engine --> Remote Connections -->Local and remote connections --> Using both TCP/IP and named pipelines. still same error i am getting from client machine i am using connection string as "Server=MyServer\SQLExpress;AttachDbFilename=C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\db_naren.mdf;Database=db_nare; Trusted_Connection=Yes;" is there any thing i need to do to connect from client machine to server?please

Error connecting to Remote report server database in SQL Server 2008 R2 DataCenter Edition

I am trying to configure my report server installed on Server A to point to a reporting services DB on Server B. I am able provide the name and test the connection. However, when i click next on the configuration wizard after providing the Server A name I am receiving the below error: The feature: "Remote access to report data sources and/or the report server database" is not supported in this edition of Reporting Services I have SQL Server 2008 R2 DataCenter Edition on both the servers.    

problem with connecting to local SQL Server 2008 default instance using windows authentication




I have a user getting some problem with connecting to local SQL Server 2008 default instance using windows authentication with a user which has sysadmin role and is owner of each existing database:

2010-09-28 15:40:35.04 Logon       Error: 18456, Severity: 14, State: 11.


2010-09-28 15:40:35.04 Logon       Login failed for user 'IIS APPPOOL\RoomViewSEWebClient'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT:]



This us

SQL Server 2008 client very slow on new Win7 PC


I installed SQL Server 2008 Management Studio on a brand new PC (HP ProBook 6540b with an i5 CPU and 2GB RAM) running Windows 7 x86. A script that runs some stored procedures on a Windows 2008 x64 server (also SQL 2008) and which returns about 10 result sets takes a fraction of a second on our old PC's, including one that runs Windows 7 (the rest are XP and Vista). But on this PC, it takes 30 seconds! I installed the client tools the same way as always, and applied SP1. I disabled the Windows Firewall and anti virus, and then disabled the Aero interface, and it is still slow (now about 15 seconds). Non-SQL functions are faster, e.g. copying files over the network is almost 3x faster than on my old PC, so there doesn't seem to be a general speed problem with the PC.

Do I need to change any settings for Windows 7? I ran the configuration manager, but the settings look the same as on the old PC. I disabled shared memory (I think this is just for a local database server?), but this made no difference.

Any ideas? Thanks!



Looking for Client Query Analyzer (SQL Server 2008) or Equivalent Reporting Tools


I've recently upgraded from SQL Server 2000 to SQL Server 2008.  My accounting and marketing team is skilled and has been using SQL Query Analyzer for years to run smaller queries and build small Crystal Reports.  Unfortunately Query Analyzer is now bundled into the management studio.  That's a bit too much software for this level of power users.

Is there a client-side query analyzer for SQL Server 2008?  I'd rather use a Microsoft product than a 3rd party tool, but I suppose I could do that too.  Looking for something simple that will:

1.  Show users the database tables and/or views

2.  Run queries

Perhaps query analyzer isn't the way to go and my team needs a different reporting system.  If this is the way MS is heading, could you direct me towards a product or service that allows power users to get the information they need?  They will still need to look at raw data to build Crystal Reports though.

Custom client app cannot connect to SQL server 2008



We have a custom application developed using Access 2003 but converted to 2007 which connects to database SQL server 2008 converted from 2005. Users are unable to connect via application and get the following error.  Application uses ADO.NET to connect. But when Network library configuration and enable TCP/IP protocol with servername and portno using SQL Server Network Utility setup (cliconfg), It works fine. We have about 150 users but it is complicated to do for each users.

Also users uses windows authentication to connect. They belong to one of the three Windows Active Directory groups which are given RW permission on the database side.

'Connection Failed' error.

SQL State 01000

ODBC SQL Server Driver: ConnectionOpen(Connect())

Connection failed.

SQL State: '08001'

SQL Server Error: 17

[ODBC SQL Server Driver] [DBNETLIB] SQL Server does not exist or access denied.



connectionstring : "ODBC;DRIVER=SQL Server;SERVER=<<server>>;DATABASE=<<database>>;Trusted_Connection=Yes"



Please help.



Connecting SQL server 2008 to ASP.Net front end



I'm trying to connect a database to an ASP.Net front end. The .net compiler gives me an error

c:\Work\Web-based Applications\XYZCorp\Login.aspx.cs(13,40): error CS1009: Unrecognized escape sequence


The line at which the error resides, is:

string CONNSTR = "server=VARUN\S QLEXPRESS;integrated security=true;database=cs555";


The compiler considers '\S' in the server name as an escape sequence. How do I overcome this without renaming the server???


How pass js array from client to server using jQuery?



i have an array on client side

var ResultArray = new Array();


for (i = 0; i < count; i++)



 var RowValue = { id: current_Id, value: current_Value };




than i send it to server

$.post( "Home/GetResult", { result: ResultArray }, null, "json" );

Before sending to server i can see all values in each item of my array 

But when i receive this one on server side, the answer is  "[object Object],[object Object],[object Object]"


public ActionResult GetResult(object[] result) // first way


object new_result = Request.Form["result"]; // second way

Can you explain me how should i send an array of objects from client side, and how should i receive this and detect each object in array on server side? Thanks.

Problem remotely connecting to sql server 2008 express



I am trying to connect to sql server 2008 express remotely from visual studio 2010. On the server, I've enabled the sql browser service, enabled the TCP/IP and named pipes protocols. Also for firewall I added exceptions for the sqlserver and sqlbrowser instances. I tried connecting to the server through telnet by specifying the ip and port and it worked. But when I try connecting from visual studio through sql client I get the following error:

Timeout expired, the timeout period ellapsed prior to the completion of the operation or the server is not responding. Any ideas what might be the problem?

Thank you,


SQl Server Express 2008 connecting to instance issue


Hi all,

First time user here.

Need some advice on connecting to a database or instance. Keep getting error message when i try to connect to instance.

Error message when I try to connect to instance refers to veryfying that the instance name is correct and to also check that remote connections are enabled.

I just cant connect at all.

I have enabled TCP/IP in config manager tool for sql server.

I am trying to do this locally.

TCP/IP and shared name pipes is enabled.

How do I verify that the instance name is correct?

And one silly question I think, why dont I have sql browser service in Services?

Any help would be greatly appreciated.

Problem connecting to report server from client machine


We've deployed some reports from a server machine which can be accessed without any problems if you are logged onto the server itself by going to the URL of http://servername/ReportServer. However if we try and access the reports from a client machine (even if we use the same administrator Windows account) we get the Windows security window appear asking for a Username and Password to be entered in order to connect to the server. We've tried entering this but we then just get a blank screen after being re prompted a few times to enter the details.
Now I'm not sure whether this will be a Reporting Services or a Windows issue. Could it be a setting within IIS? It can't really be a user thing as the same user works on the server but not on the Client machine so it's more of a machine problem. It's as if there are some authentication settings somewhere that need to be set.
We are using SQL Server 2008 on Windows 7.
Thanks a lot

2008 server Access database connecting win7 workstation with ODBC link works extremely slowly


I have an Access database on a 2008 server (64 bit), and notebooks with 32 bit win7. The program using the mdb is written in delphy, and running on my notebook, and working on data extremely slow. What can be the problem?

The database connector is an ODBC linked network drive.

On that same configured PC with XP it works normally.


ODBC from Windows 7 client to SQL 2008 R2 server


I get an intermittent error when trying to connect to the SQL backend.  I am using the SQL Server Native Client 10.0 for my connection and it was created with no problems.  I am using it to access Dynamics GP 2010 data on the SQL backend.  SOMETIMES when logging into GP I will get a message (after about 5 minutes) stating that my login info could not be verified.  Other times I get in just fine.  When I try to troubleshoot this by "configuring" my DSN, I sometimes get stopped when trying to obtain default setting (or testing the connections) - other times it flies right thru without errors.  I am able to use the same ODBC connection (except that it is the SQL Native Client) from Windows 2008 servers, workstations running XP; but not reliably from my 32-bit Windows 7 machine. 

Any ideas?  Thanks in advance.

Hal Steinkopf.

What will happen with SSMS2005 and BIDS2005 after installing SQL Server 2008 client tools to a works


In 2009, after I installed VS 2008, then I installed SQL Server 2005 client tools.  The SQL Server 2005 client-tools setup installed a VS 2005 for my BIDS.  It seemed to me, with VS 2008 installed, installing SQL Server 2008 will install/add BIDS directly into the installed VS 2008.  Am I right? 

My questions are  – what will happen with our old SQL 2000/2005 databases and BIDS2005 packages if I install SQL 2008 client tools at the same workstation with the existing SQL 2005 client tools.  (Installing SSMS 2005
disabled SSEM 2000.) 


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