.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

Cannot Connect To Server From XP Computer To Windows 7 Computer

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

I have a development machine that is Windows 7 x64. I have a client computer that is Windows XP SP3. I have deployed a ClickOnce .NET application that uses SQL Server 2008 (installed on development machine) as it's data access. No matter what I try I cannot get the Windows XP computer to connect to the SQL Server.

Relevant information:

  • Firewall is completely shut off on the Windows 7 machine
  • The SQL Server instance is a named instance
  • I have modified the instance to accept TCP Connections via SQL Server Configuration Manager > Protocols For [named instance] > TCP/IP > Enabled
  • I have created a secure login using SQL Server authentication for the connection string
  • The SQL Server instance is set up for "SQL Server and Windows Authentication Mode"
  • Development computer is setup to allow network discovery
  • SQL Server is not installed on client computer (because it doesn't need to be - correct?)
  • Instance is configured to allow remote connections

Despite this I get a "Error: 26 - Error Locating Server/Instance Specified." I can't figure this out...

What do I need to do so that my development computer can host a named SQL Server instance that other computers on the network can connect to?




View Complete Post


More Related Resource Links

Connect SQL Server 2005 to Ms Access on another computer

  
I'm trying to create a "Linked Server" on my SQL Server 2005.  This linked server is a reference to an Access File on a remote computer.  I've set up all the permissions and shared resources.  I've created an ODBC DSN to connect to the database.  If i open the DSN in excel, i can retrieve data.  If I open a linked server connected to the DB I get the following error when i try to run a query against it.   ------------------ OLE DB provider "MSDASQL" for linked server "LS_Specialty" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed". OLE DB provider "MSDASQL" for linked server "LS_Specialty" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed". OLE DB provider "MSDASQL" for linked server "LS_Specialty" returned message "[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'.  It is already opened exclusively by another user, or you need permission to view its data.". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "LS_Specialty". ---------------------   Why does this DSN work in Excel and Access, but not in SQL

Problems to connect to sharepoint server from another computer

  

Hi.

recently i developed a webservice in Visual Studio 2008 that connects to Microsoft office sharepoint server 2007, i've already have both the WS and the SharePoint server deployed in the same IIS, and when i create a client to that webservice that its on the same machine that the iis, it works perfectly.

 

but the problem comes when i run this client from a different instance or machine, i'm not able to connect to the SharePoint server, i'm wondering if there is a configuration that i'm missing.

 

this is my web.config from my webservice:

 

<?xml version="1.0"?>

<!--

    Note: As an alternative to hand editing this file you can use the 

    web admin tool to configure settings for your application. Use

    the Website->Asp.Net Configuration option in Visual Studio.

    A full list of settings and comments can be found in 

    machine.config.comments usually located in 

    \Windows\Microsoft.Net\Framework\v2.x\Config 

-->

<configuration>

    <configSections>

        <sectionGroup name="system.we

Cannot connect to a configuration database after renaming Windows 7 computer

  

I have just recently installed a standalone instance of SharePoint 2010 on Windows 7 64-bit.  Everything was working fine, however, as part of joining my computer to the domain, my computer was renamed.  Now that the computer has been renamed, I am no longer able to connect to my locally installed SharePoint instance.  I receive an error message stating "Cannot connect to the configuration database."

I found this article on renaming a server for SharePoint Foundation: http://technet.microsoft.com/en-us/library/cc288510.aspx.  However, it seems like the article is assuming that the rename operation occurred while SharePoint was still running.  However, I am running SharePoint Portal Server 2010 and now that I cannot connect to the configuration database, I cannot make any alterations to the SharePoint instance at all.

In addition, my instance of SQL Server as well as the standalone SharePoint instance was installed prior to the computer rename.  What are the steps that are required to address this situation?

Thanks.


How to backup SMS from windows mobile Pocket PC to computer

  
How to backup SMS from windows mobile Pocket PC to computer

Many Windows Mobile Pocket PC Phone users could not backup their SMS to txt file or view on computer. I found this software offers a SMS Messages backup solution to Backup all SMS messages for Windows Mobile Phones onto computer and keep them safe. Here is the user's guide:

SQL Server Express 2008 Setup fails. Support Rule "Restart Computer" Failed

  
Hi, I have been trying to install SQL Server Express for most of the day now without any luck.  Whatever I do setup fails at the stage of Setup Support Rules, Rule "Restart Computer" - Failed.  Needles to say I have restarted (several times!) and I have tried downloading  and installing the "Advanced", "Tools" and "Basic" versions, all give the same error.  Trying a repair does the same.  I have been searching the net for an answer without success, any help would be MUCH appreciated. Further info: I am trying to install a stand-alone installation on to a single PC running under XP SP 3 with .NET 3.5 SP1 installed.  The PC did have some earler versions of SQL server installed but I (?hopefully?) removed all of these through Control Panel.  Before trying the first SQL install I installed Windows installer 4.5 and PowerShell 1.0 as per the Microsoft Instructions. Running SQL Server Configuration Manager results in an error (MMC could not create the snap-in. The snap in might not have been installed correctly).  A directory structure for SQL server exists in "Program Files".  Services MSC shows SQL Server (SQLEXPRESS) as Automatic Statup (not running).  Trying to start this manually gives error 14001: "application configuration incorrect - re-install to fix" .......... Which is precisely what I'm trying to do.........:(

Detect other versions of SQL Server, or SQL server instances on a computer

  
Hi All, I want to detect other versions of SQL Server, or SQL server instances on a computer. I used the recommended Microsoft C# example by using the SQL Server Windows® Management Instrumentation (WMI) provider. http://msdn.microsoft.com/he-il/library/dd981032(en-us,SQL.100).aspx SQL server 2005 has been correctly identified on my PC with Windows 7 64 bit OS. Then I uninstalled the SQLserver and all its tools/components. But even after uninstall the utility detects the SQL server 2005 as if it was not removed. What is an alternative for the correct detection of the SQL server installed on PC? Thanks in advance Dmitry

How to implement Windows Computer Management using Windows API's

  
Hi to all! Please guide me since this is really something new to me, and I hope this is the right place to ask these questions.How do I implement Computer Management (Adding computer user to a Group) in C#?Here are the steps that I have done so far using Win API functions and structures:1. For getting the current user's info, I used NetWkstaUserGetInfo to get the current user's user name and log on domain (the structure used is WKSTA_USER_INFO_1) (Ex. user name acquired = user and domain = domain)2. Next is I have to identify whether the current user is a member of the Administrators group by first getting all the members of "Administrators" using NetLocalGroupGetMembers. (the structure used to store each member is LOCALGROUP_MEMBERS_INFO_3). Then looping through the members, I get the corresponding LOCALGROUP_MEMBERS_INFO_3. If the domainAndName member of LOCALGROUP_MEMBERS_INFO_3 is equivalent to the string combining the user name + backslash + domain from Step 1 (Ex. user\domain) then the current user is a member of the "Administrators" group.3. There is a part where I have to check if a certain user is a valid user, just like in Windows, when adding a user to a group. In Windows Computer Management, there is a "Check names" button and the location is identified above. (Example, domain.org). When I type in user1 i

Linked Server to DB2 from SQL 2005 IA64BIT computer

  
Has anyone created a linked server to DB2 on AS/400 from SQL Server 2005 IA64 BIT? We were hoping to use the new Microsoft OLEDB Provider for DB2...The problem is the driver looks like it will only work on x64 computers."The single setup program will install the provider and tools on both x86 and x64 computers" We were able to install the driver on the IA64 computer and were able to successfully create a data source from the Data Access Tool. Oddly enough when we attempted to create a linked server in SSMS we received an error, we also noticed that the DB2OLEDB provider is not listed in SSMS. This is becoming a real problem so any ideas on how we can get this driver to work or suggestions on an alternative would be greatly appreciated.   thx.art.  

Accessing the command prompt of the server computer in c#

  
Hi ,I'm developing a web application in asp.net using  C# and need to access the command prompt of the server computer.After accessing it I need to run a "ABC.bat" file in the server computer which is in folder "E:\Test".The absolute path of the server is "\\MyServer"Any help to achieve this ( or any other alternative suggestions) would be greatly appreciated....ThanksPS: I need to run the ABC.bat file on the server machine as the bat file runs couple of more applications which are licensed to that server machine.

Getting Sql Server Management Studio 2008 installed on local computer

  
Hello, I have been trying to figure out this problem for a while now so hopefully someone can help me out - I would really appreciate it! Right now I have SQl Server Management Studio2005 installed on my computer for a SQL sever that we have. We recently got a 2008 sql server and if I remotely access the server, I can see that SQL Management Studio 2008 has been isntalled on the new server. I need to build new databases but need SQL Management Studio 2008 on my computer and I have no idea how to get it. I have a "Microsoft SQl Server 2008 R2" folder on my computer, and I have already tried clicking on "Configuration Tools" and then "SQL Server Installation center" and it isntalls a bunch of things, but none of them are "SQL Server Management Studio 2008."  I also found a link on a Microsoft website that says it's SQL Server Management studio 2008 R2 but it was just the same bunch of programs I already downloaded. How do I install Sql Server Managment Studio 2008 on my computer?! Thanks in advance for any help you can provide.

Failure to Install SQL Server 2005 on XP Computer with Service Pack 3

  
I have tried multiple times to Install Business Contact Manager (Office Small Business 2007). Each time the installation fails because it can not complete installation of SQL Servier 2005. Here's the log with the failed component in BOLD: Microsoft SQL Server 2005 9.00.3042.00 ============================== OS Version      : Microsoft Windows XP Professional Service Pack 3 (Build 2600) Time            : Sat Sep 11 16:11:50 2010   Machine         : REF1 Product         : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.3042.00 Install         : Successful Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0009_REF1_SQLSupport_1.log -------------------------------------------------------------------------------- Machine         : REF1 Product         : Microsoft SQL Server Native Client Product Version : 9.00.3042.00 Install         : Successful Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bo

Cannot Connect to SQL server with SQL 2008R2 enterprise On windows server 2008R2

  
I have 2 identical brand new servers Running Windows Server 2008 R2 not on a domain but simple LAN. I Installed a default instance of SQL server 2008 R2 enterprise on each one with all the default settings. No Problems during the Installaion. I Added the Windows Administrators Group and Users group to the SQL admins role during the SQL Server Installation. Remote connections are enabled on each server. I restored the same database from a copy on each Installation. Configured the user accounts on each maching and made them sysadmins and granted permissions where they were needed. Now from server A when i try to establish a connection to Server B from SQl server Management Studio I get An error stating that the server was not found or accesible. keep in mind i can \\server B\c$ and vice versa, named pipes are enabled. I have never had this problem before in my life. And it's happening on both servers. I really need each installation of SQL to be able to see the other remote installation as i have to create a mirror. -Chris

SOS: Cannot connect to SQL Server 2005 locally by Windows Authentication DOMAIN \ myname. But networ

  
Cannot connect to SQL Server 2005 locally by Windows Authentication DOMAIN \ myname. But network connection is successful.   But SQL Server Logins contain   BUILTIN \ Administrators, and                                                    BUILTIN \  Administrators contain DOMAIN \ Domain Admins, and                                                    DOMAIN \ Domain Admins contain DOMAIN \ myname.   Creating SQL Server Login with DOMAIN \ myname entail successful local connection.   Removing SQL Server Login with DOMAIN \ myname and creating SQL Server Login with DOMAIN \ Domain Admins do NOT entail successful connection. Cannot connect! System:   Windows Server 2008. Error 18456

Cannot connect to SQL Server 2005 locally by Windows Authentication, but network connection is succe

  
Cannot connect to SQL Server 2005 locally by Windows Authentication DOMAIN \ myname. But network connection is successful.   But SQL Server Logins contain   BUILTIN \ Administrators, and                                                    BUILTIN \  Administrators contain DOMAIN \ Domain Admins, and                                                    DOMAIN \ Domain Admins contain DOMAIN \ myname.   Creating SQL Server Login with DOMAIN \ myname entail successful local connection.   Removing SQL Server Login with DOMAIN \ myname and creating SQL Server Login with DOMAIN \ Domain Admins do NOT entail successful connection. Cannot connect!                                     &

VB.NET 2008 - How can i get system/shell icons position (Recycle Bin, My Computer etc) on Windows XP

  

Please, read this carefully. It is very important.

I already have the working code for all desktop icons position in VB.NET 2008, but it DOES NOT retrieve the systems icons position (like Recycle Bin, My Computer, My Documents etc), ONLY for the operating system Windows XP 32bit. This vb.net code works perfectly well and get the systems icons position, on Windows XP 64bit, Windows Vista and Windows 7.

So, the only problem that I have with this VB.NET 2008 code, is that it's NOT retrieving the system icons position, only on XP 32bit.

Can anyone help me ? I really need help, as I can't figure this out by myself.

 

Here is the VB.NET 2008 code:

-----------------------------------------------------------------------------------------

Imports System.Runtime.InteropServices

Module mdlDesktopIcons

    Private Const STANDARD_RIGHTS_REQUIRED As Integer = &HF0000
    Private Const SECTION_QUERY As Integer = &H1S
    Private Const SECTION_MAP_WRITE As Integer = &H2S
    Private Const SECTION_MAP_READ As Integer = &H4S
    Private Const SECTION_MAP_EXECUTE As Integer = &H8S
    Private Const SECTION_EXTEND_SIZE As Integer = &H10S
    Private Const SECTI

cannot connect to sharepoint server intranet site through VPN with windows vista home premium 64bit

  
Hi, a company i work for has an intranet site using sharepoint 2008. i can connect to the intranet remotely through their vpn however i am not able to view the instranet site or ping the server it is on...

does anyone have any ideas on whether this might be a vista issue or ????

thanks,
jonathan

my 64 bit computer, windows 7 OS, won't load and run microsoft visual studio 2008

  

hello,

i'm in school and am trying to load and run my downloaded microsoft visual studio 2008 program, and my computer won't let me sighting, incompatability with 64 bit versions of windows. please contact the vedor to see if a 64 bit compatible version is available.

please help!!!

 

angie


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