Time Tracker Starter Kit for SQL Server 2005

Question

User-785518903 posted
Dear all,

is there any possibility to run the new Time Tracker Starter Kit for ASP.net v2.0 without using the SQL Server 2005 Express Edition???
I'm trying to use it with Visual Studio 2005 Professional and SQL Server 2005 Standard - without success.

Has anyone of you the same problems? Or a solution how to get run it?


Thanks,
Jens

Answer 1

User-32825938 posted
Update your web.config connectionstrings named "aspnet_staterKits_TimeTracker" and "LocalSqlServer" with the connectionstring pointing to your sql2005 server and off you go!

You can find how to connect to various datasources at connectionstrings.com

Answer 2

User-785518903 posted
Hi,

I changed the connectionstrings.

Now, I get the followings error:

The user instance login flag is not supported on this verion of SQL Server. The connection will be closed.

Any idea of how to handle it?

Jens

Answer 3

User-32825938 posted
That's a Sql Server specific error, try asking in the Sql Server forums.

But...I had the same problem, but that was when I registered the .mdf-file in my sqlserver. My workaround was to create an empty database and run the supplied sql-scripts.

(I'm not a dba, more of a happy coder [;)] )

Answer 4

User794976187 posted

Hi there-

Remove 'UserInstance ='true'" from your connection string.

should look like this:

<add name="aspnet_staterKits_TimeTracker" connectionString="Server = YOURSERVERNAME; Database=YourDBNameInODBC;Integrated Security=False;uid = YourSQLUsername; pwd =YourSQLPassword;"/>

Answer 5

User555306248 posted
Change your connectionString according to your SQL server instance