YAFLogo

mdavey
  • mdavey
  • 65.2% (Friendly)
  • YAF Forumling Topic Starter YAF Version: 3.0.2
2 years ago
Hello,

I am using the sql server version.  Is it possible to build to IIS Express in VS2019?  I keep getting  this error -  Screen Shot 2022-02-10 at 2.36.38 PM.png You have insufficient rights to see the content.

I know this is similar to a previous post but that person was using an install package.

Any help would be appreciated.  

Thanks.

Sponsor
tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 4.0.0 rc 2
2 years ago
Okay found the problem the build script is not up to date.

Remove the line...

 <Delete Files="$(MSBuildProjectDirectory)'bin'System.Threading.Tasks.Extensions.dll" /> 

from the file YAF/BuildScripts/YAF-SqlServer.Package.targets

mdavey
  • mdavey
  • 65.2% (Friendly)
  • YAF Forumling Topic Starter YAF Version: 3.0.2
2 years ago
That worked, thank you.

However, now I am getting this error -

 Screen Shot 2022-02-12 at 1.53.22 PM.png You have insufficient rights to see the content.

My connection string -

  &lt;!-- Connection String for SQL Server with Integrated Security --&gt;
  &lt;add name=&quot;yafnet&quot;
       connectionString=&quot;Server=(localdb)'ProjectsV13;initial catalog=yafnet;integrated security=SSPI&quot;
       providerName=&quot;System.Data.SqlClient&quot; /&gt;

I thought if the software can't find the database on the server on startup it will create a new one.

I tried adding a blank db named yafnet but then got an error that it couldn't find a required table.

Do I have to build the db ahead of time and if so where can I find those scripts?

Again, any help would be greatly appreciated.

Thanks

tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 4.0.0 rc 2
2 years ago
When you set up and there is already a connection string defined Yaf will try to connect to the database. If the Database does not exist it will throw an error.

For install you always need to setup an empty db first (yaf cannot create a db).

If the connection string is setup to an empty db it will start the installer on the first run. Or if there is no connection string the installer runs and you can setup the connection string there.

mdavey
  • mdavey
  • 65.2% (Friendly)
  • YAF Forumling Topic Starter YAF Version: 3.0.2
2 years ago
Okay, everything is working now.

Thank you for your help.