can't connetct to SQL server

Discussion in 'Databases' started by qwerty, Dec 25, 2007.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. Hi,
    I have uploaded and attached the Database to a new folder, that I created. I didn't changed anything in web.config file. And I have this kind of error:

    An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

    is it a must to upload the database in _database folder? do I have to change the web.config file?

    What should I do to find a solution for my problem.

    Thanks!
     
  2. I think, my problem is that I used SQL Express on my local computer and now I have to use SQL 2005. What exactly should I change in my web.config file and in the codes?
    so, as you see th error comes when it start to check for a membership, that's database.
    Is everything ok in my web.config file above?
     
  3. Yes your connection looks correct.
    What may be missing is the information missing in the database itself.
    If you can...Synchronize your local data to the remote, make sure queries and tables are up to date/complete.
     
  4. in my web.config I have 3 connectionsrtings, but I have only 1 database, is that ok?
    I mean, now I already deleted the second, and the third one is for membership.
    But I hadn't the third one on my local and it was workinh fine.
     
  5. Your web.config is fine.You can have as many connection strings as you want.It depends on your web application to use the correct one.From the error message,I believe its an issue with your password.Make sure its correct!

    Vikram

    DiscountASP.NET
    www.DiscountASP.NET
     
  6. Are you trying to connect to a disconnected SQL Server database?
     
  7. well, it is connected actually.
    in my web.config I have this:
     
  8. To get that error the connection is good but the login, authorization, is failing.
    Not enough information to give more info but you can start by looking at what's referenced in: Default.aspx.cs Line: 16
     
  9. Ok, I've got it, it's working now, I've changed my connection strings.
    Thank you guys!
    Happy New Year!
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page