Thanks for the response. I'm using a single server that is hosting Visual Web Developer, MSSQL 2005 Sever Standard & IIS. Ran through the steps you recommend prior to your post, unfortunately did not resolve the issue. Ran through them again for good measure. .

Here are my connection strings again

web.config connectionStrings>
add name="aspnet_staterKits_TimeTracker" connectionString="Server=SBMTSQL1\MSSSQL2005;Initial Catalog=TimeTracker;User ID=timetracker;Password=Passw0rd" providerName="System.Data.SqlClient"
/connectionStrings
machine.config

connectionStrings
add name="LocalSqlServer" connectionString="data source=SBMTSQL1\MSSQL2005;initial catalog=TimeTracker;User ID=timetracker;Password=Passw0rd" providerName="System.Data.SqlClient"/
/connectionStrings

When i run SQLProfiler I can see the database level user 'timetracker' from the web.config connection string logging into the server. However the only function I can perform is to create a new user from the default page. As part of the create user process the 'choose role page' appears intermittently. Most the time it does not appear, When I click continue button after creating the user the following error occurs:

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

The below is a trace as I added user jim. From I can see database connectivity is working I still get the above error.

The SQLTrace has many connection resets...
exec dbo.aspnet_UsersInRoles_GetRolesForUser @ApplicationName=N'/',@UserName=N'jim'
go
exec sp_reset_connection
go
declare @p12 uniqueidentifier
set @p12='AAF8F63D-FB63-4208-88FB-7AFC8D385E26'
exec dbo.aspnet_Membership_CreateUser
@ApplicationName=N'/',@UserName=N'ben',@Password=N'jYIeXsN2AJ3ivopH8/EnWthGm/Y=',@PasswordSalt=N'ooLhAcyGuTfc3s4d4Sgq3w==',@Email=N'ben@test.com',@PasswordQuestion=N'van',@PasswordAnswer=N'LB1M4y5vTwAvz1xoEgIpWOpaccM=',@IsApproved=1,@UniqueEmail=0,@PasswordFormat=1,@CurrentTimeUtc='2009-01-12 11:49:34:000',@UserId=@p12 output
select @p12
go
exec sp_reset_connection
go
exec dbo.aspnet_UsersInRoles_GetRolesForUser @ApplicationName=N'/',@UserName=N'jim'
go
exec sp_reset_connection
go
exec dbo.aspnet_UsersInRoles_GetRolesForUser @ApplicationName=N'/',@UserName=N'jim'
go
exec sp_reset_connection
go
exec dbo.aspnet_UsersInRoles_AddUsersToRoles @ApplicationName=N'/',@RoleNames=N'ProjectAdministrator',@UserNames=N'ben',@CurrentTimeUtc='2009-01-12 11:49:43:540'
go
exec sp_reset_connection
go
exec dbo.aspnet_UsersInRoles_AddUsersToRoles @ApplicationName=N'/',@RoleNames=N'ProjectManager',@UserNames=N'ben',@CurrentTimeUtc='2009-01-12 11:49:44:257'
go
exec sp_reset_connection
go
exec dbo.aspnet_UsersInRoles_AddUsersToRoles @ApplicationName=N'/',@RoleNames=N'Consultant',@UserNames=N'ben',@CurrentTimeUtc='2009-01-12 11:49:44:273'
go
exec sp_reset_connection
go
exec dbo.aspnet_UsersInR

Could this be a problem with aspnetdb ? The very first time the aspnet_regsql tool was run it created aspnetdb. After following another post it was run again against the TimeTracker database. Users ASP.NET and timetracker both been given permissions to the aspnetdb & TimeTracker and added to all the asp roles in those databases.

Any support greatly appreciated.