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


Post New Web Links

Connection problem while connecting from client to server.

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql 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


View Complete Post


More Related Resource Links

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
Steve


passing object values from server to client problem

  

I get a message that x_login is not declared.  I added Dim login as String = "123", but that didn't help.  What's the problem?

code behind....

Dim Login = "123"
x_login.Value = loginID


asp....

<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="Default.aspx.vb" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<body>
   
<form id="simForm" runat="server" method='post' action='https://test.authorize.net/gateway/transact.dll'>
        <input id="HiddenValue" type="hidden" value="Initial Value" runat="server" />
        <input type='hidden' runat="server" name='x_login' id='x_login' />
        <input type='submit' runat="server" id='buttonLabel' />
 </form>

</body>
</html>


 


Problem with connection to sql server : A connection was successfully established with the server, b

  
Hi all, I am trying to connect sql server using windows authentication . I am getting the fallowing when I try to establish a connection to sql server A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) Can any one tell me how to resolve this problem..

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?

The SMTP server requires a secure connection or the client was not authenticated.........

  
i am using asp.net & have a emailing modulewhen i use gmail host i amable 2 send the mail but when i am using yahoo host i get  error msgthe yahoo id & password are right  but still getting the below msg ---------------------------Windows Internet Explorer---------------------------  ' The SMTP server requires a secure connection or the client was not authenticated. Authentication Required. '   ---------------------------OK   ---------------------------

A connection could not be made to the report server - Problem deploying an SSRS report from Business

  
I’m having trouble with what seems to be a common issue for people, regarding deployment of an SSRS report from Business Intelligence Development Studio. Unfortunately none of the solution I have seen posted here (and elsewhere) have been able to help me so far.   Two of my collegaues can both deploy with no problem, and I am using exactly the same Target destinations as them (TargetDataSourceFolder, TargetReportFolder, TargetServerURL).   I have posted the error message below, which from my basic understaning would indicate, I think, a security issue (perhaps something local to my PC, or user account)   Has anyone experienced this particular issue who might be able to help?   Best wishes, Jamie TITLE: Microsoft Report Designer ------------------------------ A connection could not be made to the report server http://turpin-net.turpin-bg.local/Reportserver. ------------------------------ ADDITIONAL INFORMATION: Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message: -- <HTML dir="ltr"> <HEAD><meta name="GENERATOR" content="Microsoft SharePoint" /><meta name="progid" content="SharePoint.WebPartPage.Document" /><meta HTTP-EQUIV="Content-Type" content="text/html; c

The SMTP server requires a secure connection or the client was not authenticated. The server respons

  
  here everything with images     http://img704.imageshack.us/img704/5520/problem1w.png http://img704.imageshack.us/img704/2116/problem2j.png   http://img530.imageshack.us/img530/5445/problem3.png   http://img829.imageshack.us/img829/6345/problem4.png            

get error The SMTP server requires a secure connection or the client was not authenticated. The serv

  
 Hi,I was able to send mail with no trouble before few days.Then due to some reason, i Formatted pc &  re-installed visual studio & IIS Now when i try to send mail, i get this error.The SMTP server requires a secure connection or the client was not authenticated.In my web.config file i write<mailSettings>      <smtp from="myemail@gmail.com">        <network host="smtp.gmail.com" port="587" userName="myemail" password="xxxx" defaultCredentials="false"/>      </smtp>    </mailSettings>  </system.net>  And on SEND MAIL Button click event I write ( CODE BEHIND)   Dim smtp As New System.Net.Mail.SmtpClient()  Dim smail As New System.Net.Mail.MailMessage smail.To.Add(New System.Net.Mail.MailAddress("contactperson@yahoo.co.in"))        smail.From = New System.Net.Mail.MailAddress("myemail@gmail.com")        smail.Subject = "HELLOO ..HOW R U?"        smail.IsBodyHtml = "true"        smail.Body = "" & txtmail.Text        s

Bizare sql server connection problem...

  

HI, does anyone have any ideas...

 

I have created a BDC application in VS 2010, and installed it on the sharepoint 2010 server and I am at a loss to explain the behaviour.

I create an external list using my application as the data source. When I open the sharepoint site and access the list from a browser on the sharepoint server itself, everything works fine.

However, when I access the sharepoint site from a different machine, my BDC application reports a failure to open the SQL Server connection (Error 40  - could not open connection to SQL Server).

However, if I access the list from the server (which works), and then access the list from another machine, the remote machine now works, and will work for a short while before reverting to error 40. I am assuming that this is because the connection has been opened when I accessed the list on the server, and then the remote session is picking up the open connection in the pool, because if I then wait a couple of minutes for the connection to time out and try accessing the list again from a remote machine the connection then fails again.

It does not matter who I am logged in as (I have tried being a normal user on the server and an administrator on the remote machine, and visa versa), but the behaviour is consistent. Also, my connection string in my BDC application contains a

web.config connection string problem within VisualStudio 2010 to point to SQL Server 2008 R2 Develop

  

Hello All, I would appreciate any help with this.

I believe my problem exists within the web.config which already had code in it to connect to SQL Server Express 2008.

I uninstalled the SQL Server Express that came with Visual Studio 2010.

I installed SQL Server 2010 R2 Developer, and I'm able to connect via Management Studio and through Visual Studio's Server Explorer's Data Connections I am connected.

I did run aspnet_regsql.exe within the 4.0 folder in order to create the database with Microsoft Service Providers.

Here is the ServerName: USER-5529234649 

Here is the name of the DataBase:  StepByStepChapter9

Here is the name of the Connection within Visual Studio's Server Explorer's Data Connections:  user-5529234649.StepByStepChapter9.dbo

Here is the code I changed in the web.config:

<connectionstrings>
<add name="ApplicationServices" c

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

  

Hello, 

 

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: 127.0.0.1]

 

 

This us

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. 

 


Problem remotely connecting to sql server 2008 express

  

Hi,

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,

Sam


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

Move to Win7 64-bit causing SQL Server Connection problem

  

We have a packaged VB App (Charm) originally developed in VS2003 then redeveloped in VS2005.

It uses a UDL file to point to the appropriate SQL Server and Database, using SQL OLEDB. 

It has been working fine on dozens of different installations both in-house and at customer sites for years.

We recently moved it to Windows 7.  It generally runs fine on 32-bit Win 7 but not on 64-bit, as it can't find its server.

In an effort to resolve the issue we then changed the app to get its connection string from a config file (charm.exe.config) stored in the program folder C:\Program Files (x86)\Charm.

On some 64-bit machines (But not all!) it doesn't work with this setup either.  We put a dialogue in to debug where it thinks its server should be found.  It is ignoring the .config file setting (which I will paste below) and instead getting the server name (NDS-5) from within the original binaries of charm.exe.  This is the server on which the app was compiled - but it doesn't even exist on my test network which is at a different office location.

The connection string settings currently used are:-

 <connectionStrings>
  <add name="Charm.My.MySettings.CallManagerSQLConnectionString"
   connectionString="Provider=SQLOLEDB.1;Data Source=AC-XP\ACXPSQL

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

Problem accessing 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

Steve


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