SQL Error running Timer Project

Hot Topic

Can I suppress print preview multipage icons?
Stop remote process
CDate function returns 'IndexOutOfRange' error - also in VB.Net 2005 Beta2
Massive iostream errors
Invisible startup form
How do I close a form via an "OK" button?
Launch and catch Web Form event from it’s hosted windows user control
Importing a form into a project
add record forms using sql
export

VS Express Editions

Check Array for in another Array
Why this limitation in C#express
Problem with SQL query
Some questions?
Icons
Copying root directories (e.g. USB device)
control.visible
Visual C++ SDL Open GL application
VS2003 Add Method / Property / Field dialogs not in VS2005 Express?
Problem in Query (VB 2005)

SQL Error running Timer Project

I down loaded the Timer project in Vis Express. It says it should run right on install. When I run it I get the following Error

" An error has occurred while establishing a connection to the server. When connection to SQL server 2005, this failure may be caused by the fact that under default setting SQL server does not allow remote connections."

Thats clear enough but how do I change that setting.

Thanks

ME

Answer this question

SQL Error running Timer Project

  • Rosario M

    I have the same question. How do I change the default setting in SQL Server 2000 to allow remote connections.

    When I go to Server Properties>Connections The Box "Allow other SQL Servers to connect remotely to this SQL Server" is checked.

    So why is SQL Server 2000 refuding the connection

    I have both SQL Server 2000 & 2005 running on my desktop. But I cannot make the connection from 2005 to 2000. I get this error message:

    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: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) (Microsoft SQL Server, Error: 10061)

    Thank you
  • SQL Error running Timer Project
Answer this question