Initial Setup Issues

[mikeclimbs23]

Hi,

I downloaded desigen and I'm connected to sql running on a different server. I can get through the initial setup, but get unhadled exception on the second screen. I verified my windows id has the uirights role assigned, I also tried running as user sa with the same results. Any suggestions would be appreciated.

[TheCakeMonster]

Hi Mike,

I am sorry to hear that you are having problems. The error message suggests that DesiGen is unable to access one of the stored procedures. That is usually because the user account you specified for the every day connection does not have the necessary permissions in the database. Having said that, your message shows that you understand that the credentials need to be set up correctly, so I am slightly confused.

First, let me clarify that two sets of database credentials are required; this is sometimes overlooked by new users.

• One set is for upgrades and must provide a very high level of permissions so that the database structure can be modified. These are requested for each upgrade and are not stored. Using sa for this is fine, or anything that is a database owner.
• The other set of credentials are used for everyday operation. It is the everyday connection whose permissions seem to be inadequate in your case. These everyday credentials are those you entered the first time you started the application, and which are stored so that they need not be requested again. It is the user account you entered for the everyday connection that needs to be a member of the UIRights role.

If you examine the database using SSMS with the sa account or similar, can you see that the dbo.spCodeGenTemplateSourceList_Fetch stored procedure is present in the database? If you can see that this stored procedure is present then it seems highly likely that the user account you entered on first use does not have sufficient permissions to the database. The other alternative is that your everyday connection string is not connecting to the same database as the one you ran the installation against, but that seems unlikely, as that would cause the database initialisation to start again.

What version of SQL Server are you using? It is rare for people to use a version that is not supported by the application, but it does happen.

[mikeclimbs23]

I'm able to exec [dbo].[spCodeGenTemplateSourceList_Fetch] using integrated security, the same credentials used during setup.

I tried running it on both sq; 2017 and SQL 2022.

I also tried running it as sa and received the same error. I'm sure it's something silly I'm doing wrong.

[TheCakeMonster]

Try starting File Explorer and browse to %APPDATA%\DesiGen

You should see a file called appconfiguration.json. This is where the connection string is stored. Check the "ConnectionString" property value; does this connection use the user account, server and database that you intended, and is this user allowed access to the database and a member of the UIRights role?

[TheCakeMonster]

I wonder if the connection string is pointing to the SQL Server 2017 database, whereas you are expecting it to be pointing to the SQL Server 2022 database. It might be something like that.

[mikeclimbs23]

the app configuration file was a year old and pointed at a different database. I deleted the file and I'm starting over. I'll let you know what happens. thanks for your help.

…

On Tue, Apr 25, 2023 at 7:42 PM TheCakeMonster ***@***.***> wrote: I wonder if the connection string is pointing to the SQL Server 2017 database, whereas you are expecting it to be pointing to the SQL Server 2022 database. It might be something like that. — Reply to this email directly, view it on GitHub <#2 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ASIKJHEQW4IZGQHLUYLNPWLXDBOQDANCNFSM6AAAAAAXLLWJDQ> . You are receiving this because you authored the thread.Message ID: <DotNotStandard/DesiGen-Community/repo-discussions/2/comments/5725406@ github.com>

-- Michael Benowitz

[TheCakeMonster]

Yep, that would explain it. I hope you have better luck this time.

[mikeclimbs23]

I have it all working and created my first object. Thanks for your help. Mike

…

On Tue, Apr 25, 2023 at 7:49 PM TheCakeMonster ***@***.***> wrote: Yep, that would explain it. I hope you have better luck this time. — Reply to this email directly, view it on GitHub <#2 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ASIKJHDQFLMMCH4UIYRHCZTXDBPHNANCNFSM6AAAAAAXLLWJDQ> . You are receiving this because you authored the thread.Message ID: <DotNotStandard/DesiGen-Community/repo-discussions/2/comments/5725426@ github.com>

-- Michael Benowitz