New to Time Tracker and im having trouble resolving a few issues.

Question

User-122480877 posted

I have been chasing the same thing around and around for many hours now. It all started with this error

Server Error in '/' Application.

---

ConnectionString configuration is missing from you web.config. It should contain  <connectionStrings> <add key="aspnet_staterKits_TimeTracker" value="Server=(local);Integrated Security=True;Database=Issue_Tracker" </connectionStrings>

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.NullReferenceException: ConnectionString configuration is missing from you web.config. It should contain  <connectionStrings> <add key="aspnet_staterKits_TimeTracker" value="Server=(local);Integrated Security=True;Database=Issue_Tracker" </connectionStrings>

Source Error:

Line 12: If String.IsNullOrEmpty(dataAccessStringType) Then Line 13: Line 14: Throw New NullReferenceException("ConnectionString configuration is missing from you web.config. It should contain <connectionStrings> <add key=""aspnet_staterKits_TimeTracker"" value=""Server=(local);Integrated Security=True;Database=Issue_Tracker"" </connectionStrings>") Line 15: Line 16: Else

If anyone could help me get away from this error  would appreciate it alot.

Thanks in advance [:)]

Answer 1

User555306248 posted

Check in web.config for connectionString, configure it according to your server name, password etc.

In Time Tracking System, it uses inbuild Membership classes for user creation, updation etc..

You have to register your DB with ASP.NET Membership classes by executing the command line utility in VS prompt

aspnet_regsql, it will open one window, where you  have to configure DB.

Hope it will help you, let me know.

Answer 2

User-122480877 posted

Thank you for replying, There is 2 web.config files. The other being Web.config 

My website is on live hosted servers and i based the connection string on what i have previously done with other starter kits.

Perhaps this one should be different. I have only set up the blank SQL server using the script provided in App data as i was not sure if i needed the typical asp membership tables. Will i need to change I need to change this?

And using the command prompt locally will not do anything now. will it? Should i start over?

Anyway here is my config for SQL as i never understood this in the first place it is most likely the problem. Both connection strings target the same catalog.

 

<connectionStrings>

<!-- Hosted Live SQL Conection-->

<add name="aspnet_startKits_TimeTracker" connectionString="Data Source=p3swhsql-v04.shr.phx3.secureserver.net; Initial Catalog=#######; User ID=#######; Password='######';" />

<remove name="LocalSqlServer"/>

<add name="LocalSqlServer" connectionString="Data Source=p3swhsql-v04.shr.phx3.secureserver.net; Initial Catalog=######; User ID=######; Password='#######';" />

<!-- End Hosted String-->

<!-- Local Host SQL String

<add name="aspnet_staterKits_TimeTracker" connectionString="Data Source=.\SQLExpress;Integrated Security=True;AttachDBFilename=|DataDirectory|TimeTracker.mdf;User Instance=true" />

<remove name="LocalSqlServer"/>

<add name="LocalSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;AttachDBFilename=|DataDirectory|TimeTracker.mdf;User Instance=true" />

End Local String-->

</connectionStrings>

Answer 3

User555306248 posted

Put only live Sql Connection in web.config i.e.

<add name="aspnet_startKits_TimeTracker" connectionString="Data Source=p3swhsql-v04.shr.phx3.secureserver.net; Initial Catalog=#######; User ID=#######; Password='######';" />

<remove name="LocalSqlServer"/>

<add name="LocalSqlServer" connectionString="Data Source=p3swhsql-v04.shr.phx3.secureserver.net; Initial Catalog=######; User ID=######; Password='#######';" />

Check whether Sql is coonectiong to your application

 

Answer 4

User555306248 posted

Have you solved your problem,If yes please mark it as answer

So it will help for other people

Answer 5

User-122480877 posted

 

The problem was simple. I used a ConnectionString.config file (pointed to it from the web.config) and never uploaded the ConnectionString.config file

Answer 6

User555306248 posted

Ok