Forum

SQL 2016 Full Edition problem? - Posted Sep 10, 2018 08:52 (2812 Views)

sadra

Average Member

Posts: 354

My "MS SQL Server" installed on my computer is SQL 2016 Full Edition.

and Web.Config Setting is bellow...

Code:

<connectionStrings>
<add name="SnitzConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=E:\wwwroot\dbase\SnitzForumMvc.mdf;Integrated Security=True" providerName="System.Data.SqlClient" />
<add name="SnitzMemberShip" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=E:\wwwroot\dbase\SnitzForumMvc.mdf;Integrated Security=True" providerName="System.Data.SqlClient" />
</connectionStrings>

Err accoured:

Server Error in '/SnitzNet' Application.
Runtime Error
Description: An exception occurred while processing your request. Additionally, another exception occurred while executing the custom error page for the first exception. The request has been terminated.

Please help...

Last edited by

Posted Sep 10, 2018 09:29

HuwR

Forum Administrator

Posts: 4475

If you have full 2016 then it looks like your connection strings are incorrect in web.config

It should looks something like

Code:


<add name="SnitzConnectionString" connectionString="Data Source=SERVERNAME;Initial Catalog=DATABASENAME;IntegratedSecurity=true;" providerName="System.Data.SqlClient" />

If not using Integrated security then you will need to add the username/password to the string, like below

Code:


<add name="SnitzConnectionString" connectionString="Data Source=SERVERNAME;Initial Catalog=DATABASE;UID=USERNAME;PWD=PASSWORD;" providerName="System.Data.SqlClient" />

You shouldn't really be using the AttachDbFilename, that is meant for local databases rather than a full SQL instance

I would advise waiting until I post the latest code this evening as some bugs were fixed in the install process