.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

Can I set up SQL Server 2008 R2 so that it can be queried by an LDAP client?

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :

We have a contact management system that stores its data on an SQL server. We've been trying to make the data available via LDAP using OpenLDAP and Easysoft ODBC drivers to connect to the current MSSQL 2000 database. Alas the suppliers we've used for this have let us down. We're shortly to upgrade the database to MSSQL Server 2008 R2 and I've been told by two different sources that 2008 R2 supports LDAP natively.

However all the searches I've done relate to pulling data from an LDAP server into SQL rather than the other way round.


Is what we want supported by SQL Server 200R2 or are my sources barking up the wrong tree?

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 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.

SQL SERVER 2008 TDE / Pass Private Key from Connecting Client


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. 


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.



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.) 


create subscription on client creates no entry in Sync Center if there is another SQL Server 2008 R2


We created a publication on SQL Server 2008 R2 (Dev. Edition). Then we tried to create a pull-merge subscription on the client which should create an entry in Synchronization Center (Win 7) as well under Windows Explorer – Synchronization (Win XP).


This scenario works if there is only our instance of SQL Server installed on the client.

If there is another instance (default or another named instance) installed before we create our instance with subscription there is following strange situation:


-       Subscription is created properly within Management Studio, property for showing in sync center set to enabled.

-       No entries created in Synchronization Center or Win Explorer Synch.

-  &nbs

Sql Server 2008 Tutorials

This Link Provides total Sql Server 2008 Tutorials

Seven reasons to care about SQL Server 2008 R2

Microsoft begins to fully realize its vision of SQL Server as an information platform and not "just" a database. Hence the main theme for this release -- at least according to Microsoft -- is self-service BI. The PowerPivot plug-ins for Excel 2010 and SharePoint 2010 are easily going to make the biggest splash of all the new features, not least because they're the most complete. But then, SQL Server 2008 R2 isn't strictly necessary for PowerPivot for Excel, which works with plenty of other data sources.

Error upgrading SQL Server 2008


i was normally using VS2005 and SQL server 2005...

i upgraded to SQL Server 2008... and then...

i could not build my project anymore... because of this error:

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 
Exception Details: System.IO.FileNotFoundException: The specified module could not be found. (Exception from HRESULT: 0x8007007E)
Source Error: 

sql server 2008 adventureworks database


dear Friends

For my MCTS 70 -433 examination, I recently installed sql server 2008 and installed the sample databases too. but my issue is, in that book they have mentioned a database called "AdventureWorks2008" and the nice thing is I don't have a such a database with me in my sql server 2008. 

And the query is 

-- MERGE Statement
USE AdventureWorks2008
MERGE INTO	Sales.SalesOrderDetailHistory AS SODH
USING Sales.SalesOrderDetail AS SOD
ON SODH.SalesOrderID = SOD.SalesOrderID
AND SODH.SalesOrderDetailID = SOD.SalesOrderDetailID
INSERT (LineTotal, SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty
, ProductID, SpecialOfferID, UnitPrice, UnitPriceDiscount
, rowguid, ModifiedDate, Cancelled)
VALUES(LineTotal, SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty
, ProductID, SpecialOfferID, UnitPrice, UnitPriceDiscount
, rowguid, ModifiedDate, DEFAULT)
UPDATE SET SOHD.Cancelled = 'True'
OUTPUT $action , inserted.* ;	

Please help me to overcome this issue and let me know where can I download that database too.

Thanking you

happy Coding

PostGreSQL to sql server 2008?



I am new to POSTGREsql.

I have a database built in POSTGresql and I have to migrate it to SQL SERVER 2008.

How can I do that?



LDAP - Can't find server


Hey people,

I would like to get a persons name from their username - a common query on forums i know, but i haven't managed to get mine working yet and any help would be appreciated.

I currently have this code that I found here: http://www.vbforums.com/showthread.php?t=612655 (Thanks Chris128)

I have adapted it from VB into VB.net. The page renders but when i enter my username into the Username textBox and hit the submit button (Which calls IsUser) I just get "The specified domain either does not exist or could not be contacted." I have tried lots of other code but I always get this response...

If anyone can help by posting links to a tutorial or another post for code that they know works, i will give it a go.


Imports System.DirectoryServices

Partial Class UserInfo
    Inherits System.Web.UI.Page

    Private Function GetRealNameFromAd(ByVal UsernameToFind As String) As String
        Using searcher As New DirectorySearcher(New DirectoryEntry())
            searcher.PageSize = 1000
            searcher.SearchScope = SearchScope.Subtree
            searcher.Filter = "(&(samAccountType=805306368)(sAMAccountName=" & UsernameToFind & "))"
            Using Results A

Word Automation Issue in Windows Server 2008 Hosting



The problem I am posting here is that I was facing nearly 2 weeks around. Any body comes with this stuff please help.

Word Automation in sample ASP.NET(C#) application.

I am using Microsoft.Office.Inetrop.Word Assembly for automation. Here I am reading a XXX.dot template file and fill the contents with dynamic data.

When i am executing my code in localhost:someportnumber the automation is working fine and I could get expected result and when I am hosting in my inetmgr(Windows XP is my OS) it is also working fine.

But the problem is that when I am hosting in my production server(Windows Server 2008 Standard Edition) I am not able to perform automation and results in the following error.

Data: System.Collections.ListDictionaryInternal
Message: Word has encountered a problem.
Source: Microsoft Word

The code gets failed in the following line:

ApplicationClass wordApp = new Microsoft.Office.Interop.Word.ApplicationClass();

Document wordDoc = wordApp.Documents.Add(ref oTemplate, ref oFalse, ref oMissing, ref oMissing); // Error in this line

I cannot able to proceed further. Can anybody please help me in solving this issue?

Thank you.

With Regards,


No ASPNET User in Windows Server 2008?


I have been looking everywhere online regarding this, but have not found a clear answer.


I have an ASP.Net app running on Windows Server 2008, it's basically a reporting app using Crystal Reports. I have encountered a roadblock in regards to rendering some pages. When I run the app in Visual Studio(on the same 2008 machine) everything works perfectly. Yet when I publish it and run it live the reports will not display correctly, I get a message saying Failed to render page.


I looked this error up in the Crystal Reports website and the fixes they have there refer to giving the windows "aspnet" user full access rights to certain folders on the machine. I would be happy to do this, however there is no aspnet user in Windows Server 2008.


I installed the server and set its role to be Web Server. I also checked all the options regarding ASP.Net and IIS 6 compatibility. Yet there is no ASPNET username anywhere.


Did I set the server up wrong? or do I have to do something within ASP.Net to  create this user and then give it rights? 

Not working on Windows Server 2008




I had the CSS friendly adapters working great on our old server (windows server 2003 - 32bit) and now we have moved to a 64 bit environment and now I can not get the CSS friendly adapters to work.

We are using SharePoint 2007.

Is there another work thru for 64bit environment.

I notice windows server 2008 has a directory  C:\Windows\Microsoft.NET\Framework64 would I be using the browser file in this directory???

Please help!

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