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


Top 5 Contributors of the Month
david stephan
Asad Ali
Fauzul Azmi
Post New Web Links

SQL server client tool installation on windows XP?

Posted By:      Posted Date: September 01, 2010    Points: 0   Category :Sql Server
 
Hi My desktop is Windows XP sp3 and have office 2010, sql express 2005 management studio and Visual studeio 2008 sp1 installed.  We have a SQL R2 server installed last week.  I was able to use sql 2005 management studio to connect to the new sql 2008 R2.  Question is when i try to install 2008 R2's client tool using the 2008R2 iso image.  It look for windows installer 4.5 as prerequisite.  It fail in installing windows installer 4.5 with msg saying I am not the administrator and it require administrator right.  But I am logging in as administrator on local pc.  I also confirmed with our IT/Server guys and they confirmed that I have the admin right.  Then, I tried the following steps: a) reboot, log in as administrator locally b) checked eventviewer, no error/warning msg that stand out to me c) turn off symantec antivirus d) download windows installer 4.5 (WindowsXP-KB942288-v3-x86.exe   - install it locally   - run as administrator to install All the above steps seems not working, I am kind of out of idea.  Could some on please kindly help out.  All I need is the 2008 management studio and profiler install on my PC.  thank you, Ted.  


View Complete Post


More Related Resource Links

SQL Server 2008 Installation issue in Windows 7 64 bit

  
I'm trying to install SQL 2008, but an error message keeps appearing: Microsoft .NET Framework 3.5 installation has failed. SQL Server 2008 Setup requires .NET Framework 3.5 to be installed.   My OS is Windows 7 Ultimate 64 bits, so already has de .NET Framework 3.5, I turned on/off a lot of times and the same error occurs! I download the .NET Framework 3.5 and .NET Framework 3.5 SP1 from the links: (http://www.microsoft.com/downloads/details.aspx?FamilyId=333325fd-ae52-4e35-b531-508d977d32a6&displaylang=en http://www.microsoft.com/downloads/details.aspx?familyid=AB99342F-5D1A-413D-8319-81DA479AB0D7&displaylang=en) But, when installing the Framework 3.5 or the SP1, I get the message: "Use turn on or off disable features in Windows control panel".   Someone can help me?! - Windows 7 Ultimate 64 bits - SQL Server 2008 Developer (x86, x64, ia64).   Thanks! Marcelo.

Migration of DSN use for SQL Server access from Windows SP-3 clients to Windows 7 64 bit client

  
We have numerous apps which use a named DSN using SQLSRV32.dll for an ODBC connection from our Windows XP-Pro SP3 32 bit machines client access to remote windows 2003 based SQL servers (mix of 2005 and 2008).  On migrating to Windows 7, this dll will not allow the apps to use the newly constructed DSN (using SQLSRV32.dll with ODBC), even though a test connection is sucessful (abbeit much slower than seen on the XP-Pro machines).  What must I use on the Windows 7 64 bit machine to allow a DSN to be used by the migrated apps?  - I have descerned through Google that WDAC is now the tool to use, but I am cluless how to use it. - The expectations from the app on the Windows XP-Pro and on the Windows 7 64 bit machines is to use a DSN to connect to SQL servers on Windows 2003. I would appreciate any advice, and thanks!

Sql Server 2005 installation on windows 7

  
Hi My name is shivesh   From last few days i am trying to install sql server 2005 on my machine having 64-bit OS with windows7 when i run the set up file during installation process the check box for selecting the services comes readonly unchecked and there is no other instance of sql server is installed on my machine.................. please suggest me what is the problem and what is the solution for this..   Regards Shivesh  

Sql server 2008 installation on windows 7 issues

  
Hey all,   I was installing SQl server 2008 Dev version on windows 7. It went smooth and when  ran the select @@version it shows sql server 2005 express edition.Does anybody know what is the issue? Any help would be greatly appreciated Thanks

SQL Server 2008 R2 installation failed on Windows 7

  
ERROR LOG CONTENTS BELOW:   Overall summary:   Final result:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.   Exit code (Decimal):           -2061893608   Exit facility code:            1306   Exit error code:               24   Exit message:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.   Start time:                    2010-08-16 14:52:16   End time:                      2010-08-16 15:24:53   Requested action:              Install   Log with failure:   &n

SQL Server 2008 R2 64 bit Installation on Windows 2003 64 Bit SP2---Installatio help..

  
Hi all I have SQLServer 2008 r2 binaries copied in my Server and I have do side by side installation. Server already has SQL Server 2000 64 bit on Windows 2003 64 bit SP2. Now  I have to install  SQL Server 2008 64 bit (Side by Side.). Is it ok...if I click on setup.exe it will take care of  Installation of 64 bit or I need to specify any thing to install 64 bit SQL Server 2008. Please guide me with link or advise me where I have take care while installation going on to install 64 bit SQL Server 2008 R2. Thanks in advance.  SNIVAS

Sql error+sharepoint server 2007 installation on windows server 2008 r2

  

I am trying to install sharepoint server 2007 on windows server 2008 r2,I downloaded the version of sharepoint that contains service pack2,after the installation finished,message displayed that mssql\officeservers cant be found?

Must I install sql server 208 before installing sharepoint,is sql express that is already installed with sharepoint 2007 not compatible with windows server 2008 r2


SQL Server 2005 installation on windows 2008 cluster error

  

I am trying to install SqlServer 2005 on windows 2008 cluster with domain controller. Installation fails on the second node while trying to set registry settings for server network libraries. Attached error message and output from error log. Can somebody suggest any solutions.

Thanks

Ravi

TITLE: Microsoft SQL Server 2005 Setup
------------------------------

Failed to set registry settings for server network libraries. The action is SetDefaults. The error is 11004 (The requested name is valid, but no data of the requested type was found.
)

 

Func Name='LaunchFunction'>
Function=Do_SetServerSSNLDefaults
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_SetServerSSNLDefaults
PerfTime Start: Do_SetServerSSNLDefaults : Fri Sep 24 17:45:31 2010
<Func Name='Do_SetServerSSNLDefaults'>
Setting server network settings for instance name MSSQLSERVER, instance id MSSQL.1
Failed to set registry settings for server network libraries. The action: SetDefaults Error: 11004
        Error Code: 0x80072afc (11004)
Windows Error Text: The requested name is valid, but no data of the requested type was found.
  Source File Name: sqlca\nlregca.cpp
Compiler Ti

Windows WCF client with internet proxy server showing error The server committed a protocol violatio

  

Our team trying to create a windows application(c#) to call a WCF service using internet proxy server

Showing exception "The server committed a protocol violation. Section=ResponseStatusLine" while calling WCF service

Please give suggestion to solve this problem/any alternative solution

 

//Code for creating proxy
public static DevicesServiceClient CreateProxy()
{
 
var proxy = new DevicesServiceClient("BasicHttpBinding_IDevicesService");

 
BasicHttpBinding binding = new BasicHttpBinding();
  binding
.Security.Mode = BasicHttpSecurityMode.None;
  binding

Net.TCP Endpoint; Windows Authentication security; client can connect to a server at localhost but n

  

Hey all, so here's what going on:

Situation
I have a WCF Service that I have setup as a Windows Service.  Everything works perfectly when I attempt to use the system with all of the components (i.e. server and clients) on the same machine.  However, when I try to connect my client from a different system, I get an error that is trying to tell me that the server rejected the client's credentials.

Objective
I need the client to the able to connect from a different machine.  I want to implement a SQL Role Provider kind of credentialing in the future, but for now, I just need it to work.

What I have tried
I have looked around online and read a few other posts as well some things in the MSDN KB and I have either not found the answer, or not understood it.

  • I have tried setting the <security mode="Transport"> to "None" with the hope that that would disable the accreditation entirely.  All it did was result in a different error saying that there was an error that might have been caused by an invalid message.  I have also tried a few other configurations with this element in the app.config file; to no success.
  • I have read some things about Impersonation, but I am not quite sure I understand how to implement it

Visual Web Developer 2010 Express - installation on Windows Server 2008

  

Hi,

We are trying to install VWD 2010 on a windows 2008 server. We already have installed the 2008 version as well as SQL 2005, 2008 and 2008 R2. The Web Platform installer is not installing VWD 2010 however.

At first it notified us that the OS does not allow it, after running tons of updates on the OS (some of which failed) it is still not doing it, not even donwloading it. The latest message simply asked us to post the error on the forum.

Has anybody had similar experiences? If so, how was it solved?

Cheers,

D



SQL Server 2008 R2 Side by Side installation in Cluster(Active/passive on Windows 2003 SP2).

  

Hi all,

I came again with couple question on SQL Server 2008 R2 side by side installation in Cluster(Active/passive on Windows 2003 SP2).


1.I have already have SQL Server 2000 SP4 Installation.
 
2.Can I start Installation(Side by Side) from Passive node ?

3.you want me give New SQL Server Netwrok name (Instance Configuration  Screen)?.

4.you want me give New Instance ID  name (Instance Configuration  Screen)?

5.Can I chose Excixting Clustore resource group or I need to Create New group which is the best ?

 

Thanks in advance


SNIVAS

URGENT: windows server corrupted - how do I pull back the sql server database in a new installation?

  

Hello,

I have a major problem. I have windows 2003 serverm in it I have installed sqlserver and on it several databases that was published for months.

Now, the windows 2003 server crashed and I cannot login ti windows anymore. 

What I have done is to create a new installation of windows and installed again the sqlserver...

Now, how do I get back the latest database from the previous corupted installation? I still have access to the files in the previous installation.

Please help,


WCF Windows Auth (NTLM) Problem when Client and Server are on the same machine

  

I have WCF service being hosted in IIS with windows auth enabled, it is running under NetworkService account .  I have a simple method on my WCF service which just reflects the identity of who is calling it.

 

public string RefelctIdentity()

{

 

return HttpContext.Current.User.Identity.Name;

}

I am using IIS to authenticate the user and pass me the WindowsPrincipal in the HTTP context.

I am consuming the WCF service witha client used in a WindowsService that is being run under the NetworkService account.  When the WindowsService.  When running b

SQL server 2005 SP3 installation on windows server 2008 64 bit

  

Hi Guys, I was using SQL server 2008 64 bit with my application on windows server 2008 64 bit and all was working fine; then i decided to test SQL server 2005 SP3 64 bit to install on server 2008 64 bit, for this i first uninstalled SQL server 2008 64 bit and then downloaded the SQL server 2005 SP3 from the following address:

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4

and after downloading this exe i started the installation and as soon the installation started i got the following display message that:

"this machine does not have the product that matches this installation package"

The link from where i have downloaded the SQL server 2005 SP3 64 bit file says that ti supports windows server 2008. I am using windows server 2008 Enterprise 64 bit having .NET framework 3.5SP1..

C#, sockets, Windows and port 21 : A simple Client-server using TCP; connection dies after transfer

  

Hello,

I have a thread on Stackoverflow here:

http://stackoverflow.com/questions/4118800/c-networking-server-hangs-after-receiving-more-than-65535-bytes

In short: 

In a very VERY simple Client-Server solution the TCP connection dies after sending 65535 bytes. This only happens when I am connected on port 21. If I change the server port to for example port 22 the connection does not die.

I am posting the simple code here for reference.

CLIENT:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Net;
using System.Threading;
using System.Net.Sockets;

namespace tWorks.Samcom.PassSocketPoller
{
  public class PollerTest2
  {
    private IPAddress _sutiSocketIpAddr;
    private int _sutiSocketPort;

    private Thread pollerThread = null

SQL Server 2008 R2 installation failed on Windows 7

  

**********************************log***********************

Overall summary:
  Final result:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
  Exit code (Decimal):           -2061893608
  Exit facility code:            1306
  Exit error code:               24
  Exit message:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
  Start time:                    2010-11-13 12:29:56
  End time:                      2010-11-13 13:05:05
  Requested action:         

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