Forum

SQL 2016 Full Edition problem? - Postet den Sep 10, 2018 08:52 (3108 Views)

sadra

Average Member

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

Sist redigert av

Postet den Sep 10, 2018 09:29

HuwR

Forum Administrator

Innlegg: 4538

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

Postet den Sep 10, 2018 10:59

sadra

Average Member

Innlegg: 354

Ok i'm waiting

Postet den Sep 10, 2018 11:06

HuwR

Forum Administrator

Innlegg: 4538

Originally posted by sadra Ok i'm waiting

Postet den Sep 25, 2018 08:31

sadra

Average Member

Innlegg: 354

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?

Sist redigert av

Postet den Sep 25, 2018 12:11

HuwR

Forum Administrator

Innlegg: 4538

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