SQL 2016 Full Edition problem? sadra
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

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

Ok i'm waiting

Originally posted by sadra Ok i'm waiting
thumbsUp

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?

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