Forum

SQL 2016 Full Edition problem? - نوشته شده در Sep 10, 2018 08:52 (3102 Views)

sadra

Average Member

مطلب: 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...

آخرین ویرایش توسط

نوشته شده در Sep 10, 2018 09:29

HuwR

Forum Administrator

مطلب: 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

نوشته شده در Sep 10, 2018 10:59

sadra

Average Member

مطلب: 354

Ok i'm waiting

نوشته شده در Sep 10, 2018 11:06

HuwR

Forum Administrator

مطلب: 4538

Originally posted by sadra Ok i'm waiting

نوشته شده در Sep 25, 2018 08:31

sadra

Average Member

مطلب: 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?

آخرین ویرایش توسط

نوشته شده در Sep 25, 2018 12:11

HuwR

Forum Administrator

مطلب: 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