Microsoft.AspNetCore.Mvc.Localization.LocalizedHtmlStringSQL 2016 Full Edition problem?

SQL 2016 Full Edition problem?

Printed from: Snitz™ Forums .NET Core
URL: https://www.reddick.co.uk/mvc/Topic/Posts/4774?pagenum=1
Printed on: 4/29/2024

Topic

Author : sadra
Subject : SQL 2016 Full Edition problem?
Posted : 9/10/2018
Message :

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...

Replies ...

Reply Author: HuwR
Replied on: 9/25/2018
Message:

I don't follow what you are trying to do, if you have a sql server, just create a database and then point the web.config at that

Reply Author: sadra
Replied on: 9/25/2018
Message:

How Can attach DB to SQL Server Full Edition,
When I try to attach, the database details are not displayed, and attach DB failure.

what is the public UID and PWD?

Reply Author: HuwR
Replied on: 9/10/2018
Message:

Originally posted by sadra Ok i'm waiting

Reply Author: sadra
Replied on: 9/10/2018
Message:

Ok i'm waiting

Reply Author: HuwR
Replied on: 9/10/2018
Message:

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