DNN Forums

Ask questions about your website to get help learning DNN and help resolve issues.
  • Search Forums
    Advanced Search
Forums Development and Extensions

Forum: SQL and SQL Server

 24 Subscribed to this forum
Page 2 of 2 << < 12

Topics
Replies
Rating
Status
Views
Subscribers
Last Post

SQL Server 2014 Restore failure      

Started By  Patrick M
I had this problem on a VPS with SQL 2014 Express. There was not enough security permission to a do a restore from the default backup directory: C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Backup (although backups worked fine) The error was: C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Backup Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists. Actually, you ca...
 6 4455 1
9/30/2019 1:36 AM
by Patrick M

  

Started By  MarSim
I posted this question on the XMod Pro site but haven't received a response. I have a second local SQL database (in addition to the DNN database). I am trying to connect to that database using XMod Pro > Control Panel > Manage Forms > New Form > Data Source: External SQL Server Database Table > Connection String: 'Data Source=.\SQLExpress;AttachDbFilename=|DataDirectory|mssextradb.mdf;Integrated Security=True;User Instance=True' providerName='System.Data.SqlClient' Then I click 'Load Ta...
 4 3486 1
6/30/2020 1:00 PM
by MarSim

Can't find DNN database with SQL Server Management Studio      

Started By  MarSim
I am a total newbie with DNN. I installed DNN 9.6.1 on my local Windows PC 3 days ago and have only had one major issue. Every morning I attempt to login to my DNN site using the user name 'host' and I'm told the password is incorrect. I am certain the password is correct and I have made no changes to the host account or password. So (1): Why is the host password being reset every night I researched how to add a new superuser by registering a new user and then changing the superuser flag in ...
 5 4137 3
6/9/2020 12:22 PM
by MarSim

update Lists table      

Started By  drcz
I have a very old database, running since DNN 2, and I have updating it regularely. Currently I am on last stable version DNN950. Recently I had the need to use the Countries and Regions form table Lists. And, I do not know for what reason, I have just 405 entries there and just few countries. I checked a newer database and I saw over 5000 and all the countries and regions.  One attept was to delete the entries in the old table and insert the new content. Just that the EntryID does not match a...
 10 7289 3
4/21/2020 11:49 AM
by drcz

Connection error after SQL server upgrade      

Started By  raymondvazquez
Hello, I recently upgraded my sql server version from 2016 to 2017. Now I get 'DNN Error Connection To The Database Failed' on all of my local DNN sites. My server name is the same. I have resynced logins but it does not seem to help.   Has anyone expericened this issuse and wouldn't mind sharing a resoultion Please help! Thank you!
 3 3211 3
8/24/2019 3:11 PM
by raymondvazquez

sql express free      

Started By  Shankar
Installing DNN with sql express (free) . How much Gb of data this can support & if there is a chance of this crossing the limit . Which is the best practise any advice please  Thanks
 2 3074 1
9/4/2019 10:54 PM
by Shankar

PostGre Database is not being accessed from sql pad      

Started By  Indian Guru
I have added connection string to connect PostGre SQL Database it is working in module but not able to connect in SQL Pad (DNN Query) Following is the connection string which i have used to connect Post Gre SQL:- Please let me know if any correction required and do needful
 7 4535 3
8/5/2019 8:40 AM
by Indian Guru
Page 2 of 2 << < 12


RSS Feed Available

These Forums are for the discussion of the open source CMS DNN platform and ecosystem.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. If you have (suspected) security issues, please DO NOT post them in the forums but instead follow the official DNN security policy. 
  2. No Advertising. This includes the promotion of commercial and non-commercial products or services which are not directly related to DNN.
  3. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  4. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  5. No Flaming or Trolling.
  6. No Profanity, Racism, or Prejudice.
  7. Site Moderators have the final word on approving / removing a thread or post or comment.
  8. English language posting only, please.

Would you like to help us?

Awesome! Simply post in the forums using the link below and we'll get you started.

Get Involved