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


Post New Web Links

bdc - unable to connect to instance

Posted By:      Posted Date: September 15, 2010    Points: 0   Category :SharePoint
 
CAN SOMEONE HELP ME PLEASE??? Here is my scenerio, - only one SSP... 1. Central Admin: Integrated Windows Authentication - Negotiate Kerboros 2. ADF file: <LobSystemInstances>     <LobSystemInstance Name="requestforchanges_Instance">       <Properties>         <Property Name="rdbconnectionData Source" Type="System.String">xxxxxx</Property>         <Property Name="rdbconnectionInitial Catalog" Type="System.String">xxxxxxx</Property>         <Property Name="rdbconnectionIntegrated Security" Type="System.String">True</Property>         <Property Name="DatabaseAccessProvider" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAccessProvider">SqlServer</Property>         <Property Name="AuthenticationMode" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAuthenticationMode">PassThrough</Property>       </Properties>     </LobSystemInstance>   </LobSystemInstances> ..... 3. Using Admin a


View Complete Post


More Related Resource Links

unable to connect to database

  

Hi,

I am using visual studio 2005 and sql server 2005.

I am developing a small quiz application and i have stored the connection string in app.config file which is given below.:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <configSections>
    </configSections>
    <connectionStrings>
       
        <add name="quizdb"
            connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|Quiz Application.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
            providerName="System.Data.SqlClient" />
    </connectionStrings>
</configuration>
 
i have retrieved connection string property through configurationmanager class 

and when i m connecting to database  it gives me a runtime error:

 

Sql Exception was unhandled


System.Data.SqlClient.SqlException was unhandled
  Message="An attempt to attach an auto-named database for file F:\\Quiz\\Quiz\\bin\\Debug\\Quiz Application.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located

need help about "Unable to connect to remote server." using HttpWebRequest

  


Hello friends 
I am creating an application where I want to store an html page from one of my websites into another web site. 
For the same purpose I am taking the url of the html pages 
for example if I want to copy this page "http://mydomain.com/html/page1.html" then i take this url from a text box which user enters.

How to connect to local instance of SQL Server 2008 Management Studio Express ?

  

I just installed SQL Server 2008 Management studio Express on my Vista machine.

i tried connecting to local machine using :

.\sqlexpress, (local)\sqlexpress, or .\SQLExpress, MyPCNAME\SQLExpress

nothing is working, getting this error:

-----------------------------
Cannot connect to PC-NAME\SQLEXPRESS. 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)
----------------------------


Unable to Connect to server

  
I have install sql server 2008 on window 7. But connection to server is failed. These are the options. Sever Type Server Name. Authentication. Login. Pasword. anybody have answer my question????

Could not connect using SQLDMO to SQL Instance ACQ01I

  
Hello, On mom I have an alert very frequent 13.000 times / in 30 days : "could not connect using SQLDMO to SQL Instance xxx". Is afecting only some clusters instances (normal servers are not beeing afected). I'm using mom 2005 ver 5.0.2911.0 and windows server 2003 sp2, sql server 2005 sp3. I have compared 2 instances : one with alert with other without the altert and I could see no difrences. DMO Looks well installed. - How to debug that DMO is working fine ? - How to change the dmo security ? - Why is afecting only some instances and not all ?

Unable to connect to the ASP.NET Development Server

  
 I have VS 2008 with SP1 installed on Win XP. I have .NET 3.5 with SP1 installed When I ran and opened an existing project for the first time, I got the below error WebDev.WebServer.exe has encountered a problem and needs to close. After this error, I continusly get  "Unable to connect to the ASP.NET Development Server." whenever I run the website. I checked the internet and ASP.NET forum and tried all the following Making port numbers auto assign Making it to a specific port number using the Custom web server Tried creating new web site and checking Replaced WebDev.WebServer.EXE after downloading it from a website My anti virus have not blocked any websites as such I tried resetting VS settings by running devenv /resetsettings Can any one help me, what else might be the problem? Thanks in advance

Unable to connect to SQL Server 2005 remotly, all client protocols are blank

  
I have an installation of SQL 2005 and had issues connecting remotly. Looking at the client protocolols, they are all blank. I can see that TCPIP, Named Pipes, VIA, etc. are 'enabled', but where the words 'TCPIP', 'Names Pipes', etc. should be, it's just blank. I tried to install SQL 2008R hoping the Client Protocols would be corrected during the installaion, but they were not. I'm assuming the issue with the Client Protocols not showing up is a symptom of the problem. Does anyone have any ideas? Thanks!

Error: The search request was unable to connect to the Search Service.

  
When attempting a search, I get the the error message "The search request was unable to connect to the Search Service. "  The search sevice has been started in Central Administration.  Does anyone have suggesting as to how to troubleshoot this issue?   Thank you in advance for your help.

Reporting Services Add-In for MOSS2007 : Unable to connect to the database Error at "Set Server Defa

  
Dear Expert, I've succesfully install the Add-In + configure the reporting services (integrated mode) + activate the features on my MOSS2007. As we know by activating this at my Central Admin, i'm able to see "Reporting Services" under my Application Management as below:   1) Manage Integration Setting   ---> My report url : http://servername:808/ReportServer (Trusted Account) 2) Grand Database Access --->  My setting : <servername> with default instance  3) Set Server Defaults ---> Area that i receive an error "Unable to connect to database" Anybody here have a same experience? please assist me, Thanks in Advanced My Note: OS : Windows Server 2008 Enterprise x64bit (SP2) SQL : SQL 2005 with latest Service Pack (SP3)  My Error Log: <Header>   <Product>Microsoft SQL Server Reporting Services Version 9.00.4035.00</Product>   <Locale>en-US</Locale>   <TimeZone>Malay Peninsula Standard Time</TimeZone>   <Path>c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__08_04_2010_10_51_59.log</Path>   <SystemName>SEINE</SystemName>   <OSName>Microsoft Windows NT 6.0.6002 Service Pack 2</OSName>   <OSVersion>6.0.6002.131072</OS

Unable to connect Oracle UCM Secured site with .NET Application

  
Hi, I am working on an integration of a .NET application which calls Oracle UCM web services which does Search, checkin of files to Oracle UCM( Stellent). Here i have an option to connect to a secured Oracle UCM server with credentials which retrieves the result. Here i am facing a problem. When we send a (https://) request we are getting an error as shown below: The underlying connection was closed: An unexpected error occured on a send. We are unable to do any code change on web services code as we have only the wsdl files. Tried Timeout related procedures which didnt work out. One more thing noticed is the .NET program connect to a http:// web url but not to https://. Is this a https:// issue with .NET application?   Kindly help with any inputs      

Problem with MOM using DMO to connect to SQL 2000 instance

  
Since the bank holiday weekend the following error message have been generated in MOM The SQL Server management pack script "SQL Server 2005 Service Availability" is unable to successfully connect to the SQL Server instance "SQL2000 instance running on server". The error message returned is "[SQL-DMO]Code execution exception: EXCEPTION_ACCESS_VIOLATION" Could not connect using SQLDMO to SQL Instance 'SQL 2000 instance running on server' . However, the instance is currently running. I have carried out fixes as per MS details ie registered sqldmo.dll and checked for user accounts being denied and the error continues and now I have the following error appearing: The SQL Server management pack script "SQL Server 2005 Service Availability" is unable to successfully connect to the SQL Server instance "SQL 2005 server running on the same server". The error message returned is "[SQL-DMO]Code execution exception: EXCEPTION_ACCESS_VIOLATION" I have another server with the same SQL2000 and SQL2005 instances set up which is monitored in the same manner but is not reporting these errors  

ASP.net Web Site Administration tool unable to connect ro my SQL DB

  
Hi, I am new to VWD and i am trying to use the Provider Configuration in the ASP.net Web Site Administration tool to configure my Web site management data. When ever i select the "Select a single provider for all site management data" there is only one provider "AspNetSqlProvider". When i select "test" it give me the following error message: "Could not establish a connection to the database. If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider." I have the aspnet_regsql to create a DB, my IIS is already installed and enable but the VWD ASP.net Web Site Administration tool refuse to connect to my SQL DB.What may be the problem and how can i rectify it.Thanks

unable to connect to a database engine

  
Hi. i have recently installed SQll Server 2005 but i am facing issue while connecting to a databse engine..how should i do it..?its showing an error which looks like this TITLE: Connect to Database Engine ------------------------------ Cannot connect to sanchit. ------------------------------ ADDITIONAL INFORMATION: 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476 please assist me in this....

Outlook Unable to connect to MySite's "Social Network"

  
Running into a really odd issue. I have to farms configred pretty much identically, a production farm and a dev farm. For some reason I'm able to set up a social network connection from outlook to my dev farm without any problems but I get "invalid user name or password" when I try and connect tot he production farm. There's no errors showing in the SPLogs or the event viewer. I've checked everything I can think of but knowing me I'm missing something really small.

Unable to connect Oracle UCM Secured site with .NET Application

  
Hi, I am working on an integration of a .NET application which calls Oracle UCM web services which does Search, checkin of files to Oracle UCM( Stellent). Here i have an option to connect to a secured Oracle UCM server with credentials which retrieves the result. Here i am facing a problem. When we send a (https://) request we are getting an error as shown below: The underlying connection was closed: An unexpected error occured on a send. We are unable to do any code change on web services code as we have only the wsdl files. Tried Timeout related procedures which didnt work out. One more thing noticed is the .NET program connect to a http:// web url but not to https://. Is this a https:// issue with .NET application?   Kindly help with any inputs      

Can not connect to user instance of SQL Server 2008 Express with Advance Services in Visual Studio 2

  
I used SQL Server 2008 Express with Advanced Services (not SQL Server 2008 Express) in Visual Studio 2010 because it is the fast and easy way to developed and managed data-driven applications with powerful built-in reporting and full-text search functionality. I received Sql Server 2008 Service Pack 1 with Windows Update. It's ok if I connect to instance of SQL Server 2008 Express with Advance Services (with SP1) through SQL Server Management, but if I try to attach a database in Server Explorer (Visual Studio 2010), I get the following error: "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed." I'm stuck at this point. Is there a fix or a workaround? I've already tried deleting the 'C:\Users\Administrtor\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS' directory as mentioned in other posts, with no luck. The error.log at 'C:\Users\Administrator\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS\error.log' has the following relevant entries: 2010-09-01 14:44:10.47 Server      Error: 17156, Severity: 16, State: 1. 2010-09-01 14:44:10.47 Server      initeventlog: Could not initiate the EventLog Service for the key '3677F6D3-17C7-4F', last error code is 2. 2010-09-01 14:44:10.47 Server &

Crystal Reprort:unable to connect with sql server

  
Hi Guys,               i have a Problem in crystal report which is unable to connect with the hierarchy...can any one give me the solution..i have done this with .xsd nd My code is as Under...Imports SystemImports System.Data.SqlClientImports CrystalDecisions.SharedImports CrystalDecisions.CrystalReports.EngineImports CrystalDecisionsImports CrystalDecisions.ReportSourcePartial Class Default2    Inherits System.Web.UI.Page    'Dim cn As New ConnectionInfo    Dim crtableLogoninfos As New TableLogOnInfos()    Dim crtableLogoninfo As New TableLogOnInfo()    Dim crConnectionInfo As New ConnectionInfo()    Dim CrTables As Tables    Dim CrTable As Table    'Dim TableCounter    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load        Dim crReportDocument As New ReportDocument()        crReportDocument.Load("C:\Users\Utpal\Documents\Visual Studio 2008\WebSites\Report 2\CrystalReport.rpt")        With crConnectionInfo            .ServerName = "\SQLEXPRESS"&nb
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