.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

SQL client install was not creating the "ConnectTo" under msssqlserver\client

Posted By:      Posted Date: September 09, 2010    Points: 0   Category :Sql Server
 
We detected the situation and found some info on it and there happened to be a workaround by either importing the key from another box or manually creating it. Then we can add in our alias’s, etc… we can now connect to a 32 bit SQL 2005 DB server.  Is MS aware of this problem and will there be a patch to fix to issue?  You can find more on the issue here: http://mossytips.blogspot.com/2008/10/installing-64-bit-moss-with-32-bit-sql.html  


View Complete Post


More Related Resource Links

C# - Creating web client for automating user activity on a HTTPS site

  
I've been wracking my brain for a couple of weeks on this.  I need to create a web client (I don't want to use the webBrowser control because I need this to be as lightweight as possible) to log in to a secure web site, and then effectively click links and fill in fields to get the data that would normally be displayed in the web browser.  I'm then going to parse the data and perform other actions with it. I have been working with HttpWebRequest and HttpWebResponse and many permutations of suggestions I have found while Googling my issue, but I can't get rid of my problem:  Sometimes when I effictively click the ultimate link that I need to click to get to my data, I get what I am looking for.  However, MOST of the timel, I get a response page that tells me my connection timed out and that I need to log in again.  I have tried messing with cookies and such, but to no avail. I know it's good form to post my code, but it is so sloppy and screwed up right now from tweaking this and trying that, that I'd rather not take the approach of fixing what's there, rather I'd like to start with solid, clean code to begin with. Your help will be greatly appreciated. Thanks, ALo

SQL-DMO Install on SQL Server 2005 Express Client

  
I am installing a Client side SQL 2005 Express that needs SQL-DMO. The Client computer does not have SQL Server 2005 Express installed. I have installed all the MDAC and .Net 2.0. The command line I'm using to try and install the SQL-DMO and XML modules is: SQLEXPR_ADV ADDLOCAL=Tools_Legacy,SQLXML I get a message something like 'SQL Server 2005 Version does not support this install option.' How do I get SQL-DMO installed on a SQL Server 2005 Express Client computer?

Install SQL Server2005 Error:[Native Client]Encryption not supported on the client

  
Product: Microsoft SQL Server 2005 -- Error 29515. SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Encryption not supported on the client. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.

Need suggestion's and guidelines for designing and creating WCF client channel pool

  
  What factor's should be considered for creating a WCF client channel pool? 1)Whether it is advisable to create a pool of pre-opened channel's?or create a new channel as an when needed?which one is expensive operation? 2)what should be the pool size? 3)how pool will support if concurrent request's are coming which use different binding's? 4)what should be channel lifetime? 5)If all the connection's in the pool are busy,whether we should wait till the free channel's are available in the pool or create new one's which is expensive?which one is better? if anybody is able to provide some usefull links it will be helpfull.

Cannot successfully install on Win 7 client. SQL errors.

  
 The installation process failed at the end of a SP2010 Windows 7 single server  install. I  followed all prerequisite steps, including the native sql download. Logs indicated the process could not find SQL or the content database. I cannot verify the sql service is running. I've repeated the sql download and reinstalled Sharepoint, but still get the same problem. I tried to manually run the SP configuration, but same problem.

No client tool available after developer edition install

  
I have installed the developer ediiton to sql server 2005 and I do not see the management studio app available through the start menu. Do I have to install another CD/DVD to get the client tools?

SQL Server Native Client install fails during prerequisites

  
Hi I'm trying to install sharepoint 2010 on a new windows 2k8r2 which is a member server on our domain. The server is fully updated. The SQL Server native client installation fails. This is the entry in the error log;   2010-09-15 08:57:26 - Beginning download of Microsoft SQL Server 2008 Native Client 2010-09-15 08:57:26 - http://go.microsoft.com/fwlink/?LinkID=160387 2010-09-15 08:57:28 - Size of download of "Microsoft SQL Server 2008 Native Client" in bytes is "8073728" 2010-09-15 08:57:28 - Download of "Microsoft SQL Server 2008 Native Client" completed successfully 2010-09-15 08:57:28 - Installing Microsoft SQL Server 2008 Native Client 2010-09-15 08:57:28 - "C:\Windows\system32\msiexec.exe" /i "C:\Users\myadmin\AppData\Local\Temp\SQLCF11.tmp.msi" /quiet /norestart 2010-09-15 08:57:28 - Install process returned (0X660=1632) 2010-09-15 08:57:28 - [In HRESULT format] (0X80070660=-2147023264)   If I run the SQL native client installer manually I get the following error; The installer has encountered an unexpected error. The error code is 2755. Server returned unexpected error 1632 attempting to install package.   Any ideas why this is happening? I've had a quick google and can't see anything for SQL Native Client for that error code. Thanks   Olly

how do i do a minimal client tool install to execute SSIS packages

  

I am trying to migrate our processing from command line based scripts and foxpro to SQL so I need to run the SSIS packages using dtexec. I copied the dtexec file and a few dll's that are missing to our production servers but i cant execute the packages. I dont want to install the full client tools (particularly managment/business inteligence studio) on our production servers due to the overhead and limited system disk space.

Can somebody tell me what the minimum install would be so I would be able to run SSIS packages using the dtexec or dtexecui tools? I would also like to install some of the other command line client tools like osql etc.


Can a table name impact generating the service client when creating Service Reference?

  

I have a new WCF service I'm writing under VS2010 and IIS 7.5.  The service includes a table named Client.

When I built my test class and added the service reference, the first test was confirming the creation of the client.

My service reference did not generate any client that I could call .Open on!!!! I was wondering if it is due to that table name???

 Edited to add that I tested the service through the browser and it brings up the page and XAML fine.

Thanks for any assistance!


How to pass behavior when creating a WCF Client?

  

I am trying to programatically set the behaviors for an endpoint for a WCF Service.

 

For example:

 

BasicHttpBinding binding = WCFBindingConfigSectionHandler.GetBasicHttpBinding(mConfig, mLogger);

EndPointAddress address = WCFBindingConfigSectionHandler.GetEndPointAddress(mConfig, mLogger);

EndPointBehaviorElement behaviors = WCFBindingConfigSectionHandler.GetEndPointBehavior(mConfig, mLogger);

binding.Security.Mode = BasicHttpSecurityMode.None

// call the WCF service.   Binding and Endpoint address set but How do I set the behavior.  The step above gathers the information and now I just need to set the behavior programatically.   Please help.

mpClient = new MeasurandProviderServiceClient(binding, address);

//The client offers a way to read the behavior but not set it.

Any ideas?

 


SQL Server 2005 Management Studio error and cannot re-install client tools too system.serviceModel e

  

Hi,

got some regular OS patches today and voila:

sql management studio error: appidpackage failed to open connection dialog

Have tried to re-install client tools:

F:\>start /wait \setup.exe /qb REINSTALL=SQL_Tools90 REINSTALLMODE=OMUS

Success
The following error occurred:
Configuration system failed to initialize

Error result: -2068774911
Result facility code: 1201
Result error code: 1

Please review the summary.txt log for further details
The following error occurred:
Configuration system failed to initialize

Error result: -2068774911
Result facility code: 1201
Result error code: 1

Please review the summary.txt log for further details

Unhandled Exception: Microsoft.SqlServer.Chainer.Infrastructure.ChainerInfrastru
ctureException: Configuration system failed to initialize ---> System.Configurat
ion.ConfigurationErrorsException: Configuration system failed to initialize --->
 System.Configuration.ConfigurationErrorsException: Unrecognized configuration s
ection system.serviceModel. (C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Confi
g\machine.config line 146)
   at System.Configuration.ConfigurationSchemaErrors.ThrowIfErrors(Boolean ignor
eLocal)
   at System.Configuration.BaseC

SQL Server 2005 Management Studio error and cannot re-install client tools too system.serviceModel e

  

Hi,

got some regular OS patches today and voila:

sql management studio error: appidpackage failed to open connection dialog

Have tried to re-install client tools:

F:\>start /wait \setup.exe /qb REINSTALL=SQL_Tools90 REINSTALLMODE=OMUS

Success
The following error occurred:
Configuration system failed to initialize

Error result: -2068774911
Result facility code: 1201
Result error code: 1

Please review the summary.txt log for further details
The following error occurred:
Configuration system failed to initialize

Error result: -2068774911
Result facility code: 1201
Result error code: 1

Please review the summary.txt log for further details

Unhandled Exception: Microsoft.SqlServer.Chainer.Infrastructure.ChainerInfrastru
ctureException: Configuration system failed to initialize ---> System.Configurat
ion.ConfigurationErrorsException: Configuration system failed to initialize --->
 System.Configuration.ConfigurationErrorsException: Unrecognized configuration s
ection system.serviceModel. (C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Confi
g\machine.config line 146)
   at System.Configuration.ConfigurationSchemaErrors.ThrowIfErrors(Boolean ignor
eLocal)
   at System.Configuration.BaseC

Install an application which is using .net 2.0 SP1 on a computer with windows XP and .net 3.5 client

  

Scenario:
1) I developed an application using .net 2.0 SP1
2) I need to install on windows XP with .net 3.5 SP1 client

When I tried to install .net 2.0 SP1, this installation failed. Installing .net 3.5 (containing .net 2.0 SP1) is not really an option, because of size (>200 MB) and time.

I would prefer to just install .net 2.0 SP1 - which would be sufficient - but thats not possible. Do you have any recommendation?


Need help creating Secure Site that will require client certificate

  

Hi,

I am trying to create a secure web service that will require certificate from clients. I'm not working with WCF, just a web service. This is what I did so far:

On the default web site, where I have other web sites that are not secured, I've configured one of the virtual directories in the following way: Directoy Security->Secure Communication -> Edit I've Tagged Require SSL, and Require client certificate. Then, I've created a Many to One Mapping rule that maps a certificate, by CN to a certain user account.

When I try to access the web site, with a client application (https://SERVERNAME/VIRTUALDIRECTORY/ASMXFILE.asmx) I get the following message :

"Unable to connect to the remote server"

Ofcourse I send a proper certificate.

What am I doing wrong?

Thanks


Use jQuery and ASP.NET AJAX to build a client side Repeater

  
By sending only data to the client, you can profoundly reduce the size of what you send and see a substantial increase in performance. You also allow yourself the ability to easily add features like light-weight sorting and paging on the client. This can not only improve your users' experience, but reduce server load and bandwidth requirements.

Client Side Gridview Pagination using JQuery

  
I would like to show how to use Client Side Gridview Pagination using Jquery Table Pagination Plugin by using Ryan Zielke.

Use jQuery and ASP.NET AJAX to build a client side Repeater

  
By sending only data to the client, you can profoundly reduce the size of what you send and see a substantial increase in performance. You also allow yourself the ability to easily add features like light-weight sorting and paging on the client. This can not only improve your users' experience, but reduce server load and bandwidth requirements.

To that end, I'm going to walk you through these four steps to effectively implementing a client side Repeater, using ASP.NET AJAX and jQuery:
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