Hi Dominic, Thanks for your quick reply.
I need again your help as I am getting some issue while settings the
connectionString and implementing the database.
I will explain from the starting:
As per your recommendation I have installed
ASP.NET MVC 3 on my server 2008 64bit running Visual Studio 2010,
Downloaded the latest version of LCSK from
Build the solution and It was successful,
Run it and the first page appear – clicked on the Chat Button,
The second window opened and got the following error:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that
the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Hence I checked the webconfig connectionString under LCSK.Web
Changed from Data Source=devpc\sqlexpress; to Data Source=.\test;
did not change the remaining.
(“test” is the name of the instance of my machine)
Re-run and got the new error:
Cannot open database "hlsim" requested by the login. The login failed. Login failed for user 'WV003239\Administrator'.
Modified the connectionString as follows
connectionString="Data Source=.\test;Initial Catalog=hlsim;User Id=AdminTest; Password=MyPassword;"
(Of course I have created a user named “AdminTest” inside my SQL and gave him all rights as well as opened all the remote connections and pipes…)
Re-run and still getting the same error
Cannot open database "hlsim" requested by the login. The login failed. Login failed for user 'AdminTest'.
Even changed the “Intial Catalog” to “Database” but same thing…
<add name="LCSK" providerName="System.Data.SqlClient" connectionString="Data Source=.\sqlexpress; Database=hlsim;Trusted_Connection=true;"
As I know MVC Model uses code-first concept and create the database on the fly! Is that may cause the error???
In meanwhile I was checking if the database was created using Management Studio and the answer is NO
To isolate the issue I created 2 instances: 1 with SQL Dev 2008 R2 – 1 with SQL Dev 2008 Express Edition but with both I am getting the same issue…
In your documentation tab, regarding the section:
Installing the database For the moment the database should exists already, so if you have an existing database just run the installation process, if not, create
a new database before requesting the install page.
When I download the code there was no database and even I ran the installation process through VS 2010: Tools > Library Package Manager > Add Library
Package Reference > LCSK
The installation was successful but no databases installed…
At last, I thought It may SQL issues somewhere so I went to asp.net/mvc site and downloaded their basic demo “Movie List” and it worked fine…It creates the database on the fly and no credentials
Please help Dominic.
From: [email removed]
To: [email removed]
Date: Tue, 18 Jan 2011 08:25:39 -0800
Subject: Re: Installation issues [LiveChatStarterKit:242235]
Thanks you, glad the product is helpful.
The 1.0 version will only work on an ASP.NET MVC enable website. That does not mean your main application should be an MVC application at first. Couple of option here, because I'm assuming the question is "How to install LCSK on a standard ASP.NET WebForms
First option would be to allow MVC into your existing application, that will be easy if you have a Web Application project type not an ASP.NET WebSite project type. You know this if you have App_Code folder you have a WebSite project type.
If you have an Application check this out from Scott Hanselman :
If you have a WebSite project type, the longest route would be to transfer to an Application type project and integrate MVC into it.
Or create a blank MVC 3 app and install LCSK into it.
You might check the Documentation tab as well for documentation.
Hope it's help,