No Database Instance

Hello,


I have added connection string for SQL Server Authentication in settings.txt file as below

DataConnectionString: Data Source=ServerName;Initial Catalog=DBName;Integrated Security=True;User ID=UserName;Password=Pswd;MultipleActiveResultSets=True


application throw an error like - "No database instance"


I have read other post related with same but nothing work for me.


Note: I am using 3.80 version

Thanks,
Krish_Patel

krish_patel wrote:

Check your sql server it is running or not.

Database already exist?  Have you already done "Install"?

Hi,

I'm facing the same problem after migrate my development enviroment from Azure VM/SQL Azure configuration to a physical server/local SQL Server 11.

I changed the connection string to point to new server in Settings.txt file.

I noticed that the SQL Server Agent is not running and when I try to start, the service stops right after starts. Is the SQL Server Agent necessary to Nopcommerce 3.4 run?

If not, what can I try to solve this problem?

Thanks!

hcmelo wrote:

Please, check similar post here: No Database Instance

The SQL Server Agent is a component of Microsoft SQL Server which schedules jobs and handles other automated tasks. It is not needed for nopCommerce.  Check your server's 'local Services' and be sure you have a running (Started) instance of "Sql Server (XXXX)"  - use the XXXX as the server name in you connection string.

divyang16 wrote:

I tryied the steps on that post before and I had no success...
Thanks

New York wrote:

Thanks for the explanation!
I followed youy instructions and I found the service running. Then I did put the name found as the server name but the error persists...

Just to guide anyone who needs: In my case was the IIS User (IIS_IUSRS) whithout write permissions on the application folder.

Thanks for the help!

I had the same issue in another occasion and I solved removing the "Encrypt=True" from connection string, after see that on database properties it was set to false.