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!
R_D_7
Member
5 Points
1 Post
Need help setting up
May 10, 2006 07:13 PM|LINK
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!