locked
Need help setting up RRS feed

  • Question

  • User-1844084165 posted
    I'm using SQL Server 2000 - I've set up a database named TimeTracker, ran asp_sqlreg.exe, ran the .sql script that came with the project but when I try to create a new user, I get an error.


    I'm  using the following for my connection string in the web.config file:
    Provider=SQLOLEDB;Data Source=SERVER NAME;Initial Catalog=TimeTracker;User ID=sa;Password=PASSWORD;


     but I still keep getting an 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.

    Any hints on what to look for would be greatly appreciated!



    Wednesday, May 10, 2006 3:13 PM

All replies

  • User1137109038 posted
    are remote connections allowed on your sql server 2000?
    Thursday, May 11, 2006 4:40 PM
  • User1169324036 posted
    • Remote OLEDB connection using TCP to a server that is blocked by Firewall

    Error: Microsoft SQL Native Client : 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..

    http://blogs.msdn.com/sql_protocols/archive/2005/09/28/474698.aspx

    Please make sure to check your the firewall on your sql2000 server
    Friday, May 12, 2006 10:55 PM
  • User555306248 posted
    Got any solution ?
    Saturday, April 28, 2007 1:14 AM