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


Post New Web Links

unable to connect to sqlserver while creating my account using VS2010 proffessional in WIN 7 home pr

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

Hi,

I am getting  an error while  debug my application that unable to connect SQL server......The message is...

 

 at System.Web.DataAccess.SqlConnectionHelper.CreateMdfFile(String fullFileName, String dataDir, String connectionString)
   at System.Web.DataAccess.SqlConnectionHelper.EnsureSqlExpressDBFile(String connectionString)
   at System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation)
   at System.Web.Security.SqlRoleProvider.RoleExists(String roleName)
   at System.Web.Security.Roles.RoleExists(String roleName)
   at BusinessApplication4.Web.UserRegistrationService.CreateUser(RegistrationData user, String password) in C:\Users\Balakrishna\documents\visual studio 2010\Projects\BusinessApplication4\BusinessApplication4.Web\Services\UserRegistrationService.cs:line 51
   at CreateUser(DomainService , Object[] )
   at System.ServiceModel.DomainServices.Server.ReflectionDomainServiceDescriptionProvider.ReflectionDomainOperationEntry.Invoke(DomainService domainService, Object[] parameters)
   at System.ServiceModel.DomainServices.Server.DomainService.Invoke(InvokeDescription invokeDescription, IEnumerable`1& validationErrors)
   at System.


View Complete Post


More Related Resource Links

How to connect a remote Sqlserver 2008 r2 server with IP address and port? I use SMO and VS2010.

  

how to write SMO's conn.ConnectionString with IP address and port?


unable to connect SQLserver 2008 to (local) on windows 7

  

TITLE: Connect to Server
------------------------------

Cannot connect to (local).

------------------------------
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: 2)


SqlServer - Windows Account to install Application from Gallery

  

Referring to this tutorial: http://www.asp.net/webmatrix/tutorials/download-and-install-an-asp-net-application

I selected umbraco cms and got this wizard:


I already have Standard Sql Server 2005 on my machine which I wanted to us for above DB and not SqlExpress.

I did not remember "sa" account pwd nor I use explicitly any account to connect to my Sqlserver. I use Windows Authentication account i.e implicit authentication. So I created new account and gave all rights and used it in the above wizard and was able to install the database after some struggle.

My question is: What if I want to use my Windows Account to install the database above? Why the wizard don't have any option to use Windows Integrated Authentication?

Note: I can create the DB with external user I created, just looking specifics for using Windows Authentication for above installation.


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

Unable to select any stored procedure while creating TableAdapters in wizard

  

I'm using VS 2008 and SQL 2008.

I have created the tables and the stored procedures in SQL 2008.

In VS 2008, I created DataSet1.xsd in App_Code and created the connectionString in web.config file.

Then when I go into the DataSet1.xsd and try to add a TableAdapter, strange things happened.

First I chose the data connection, then selected "Use existing stored procedure", then there was nothing listed in the dropdownlists (in Select, Insert, Update, or Delete). 

I'm sure the connectionString is correct because if I choose "Use SQL statement" and type in a "select * from mytable1", the TableAdapter can be created without any problem.

Any suggestions?


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.

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????

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!

connect client certificate to an account in a membership database

  
Hello I have created a web service that authenticates with username and password, works fine.Basically this one, http://msdn.microsoft.com/en-us/library/ff649647.aspxNow I also want to connect to this web service using client certificates, works finehttp://msdn.microsoft.com/en-us/library/cc948997.aspx But I would like to when authenticated via client certificates, connect that certificate to a user in the membership database.So that I can use Roles.IsUserInRole(...) and such.I thought that, well if I implement a Custom certificate Validatorhttp://msdn.microsoft.com/en-us/library/ms733806.aspxthen I could check for example subject and map that against a created username in the membership database.But in the class X509CertificateValidatorpublic override void Validate(X509Certificate2 certificate)I don't have the same ability as when the user is authenticatedlike  void OnAuthenticateRequest(object source, EventArgs eventArgs)HttpApplication app = (HttpApplication)source;Basically how can I do this app.Context.User = new GenericPrincipal(new GenericIdentity(username, "Membership Provider"),roles);withinpublic override void Validate(X509Certificate2 certificate)and if that is not possible, can this be solved differently?Bottom line, how do I connect a client certificate to a user account in the membership database. Is there a MSDN article

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      

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