Hi all,
Installing a local copy of Acumatica and it looks like I’m having a SQL login issue:
Exception Details: Microsoft. Data SqlClient.SqlException: Login failed for user 'MIGNETISANDBOXS'.
Are there any in depth walkthroughs you recommend for installing local copies? Thanks!
I
Best answer by MichaelShirk
Create SQL User in SQL Server 2022 Database using SSMS
Give Permission to SQL User in SQL Server using SSMS on database
I use ChatGPT a lot, but I don’t trust it to give me steps to follow since it will make up stuff that doesn’t exist. It seems to be pretty bad at knowing how to navigate a UI.
+4When you installed the instance, which authentication option did you select for the Database Connection?
I had always used Windows Authentication, but then last week I installed a windows update and it broke all my local instances. I had to move to using the SQL Server Authentication method.
For that you just create a Login on your local SQL server instance and make sure it has adequate permissions to the database you want to connect to (typically for a local site I’ll just give it the “db_owner” role), then use that username and password under the “Use Existing Login Credentials” option.
Does that make sense?
Hi @swartzfeger,
Are you able to log in to the SQL Server using SQL Server authentication for the MIGNETISANDBOXS user?
If you can, please verify that the credentials provided in the web.config file are correct.
Hope it helps.
When you installed the instance, which authentication option did you select for the Database Connection?
I had always used Windows Authentication, but then last week I installed a windows update and it broke all my local instances. I had to move to using the SQL Server Authentication method.
For that you just create a Login on your local SQL server instance and make sure it has adequate permissions to the database you want to connect to (typically for a local site I’ll just give it the “db_owner” role), then use that username and password under the “Use Existing Login Credentials” option.
Does that make sense?
Makes total sense Michael and yes, I was thinking the same thing… I used Windows Authentication and figured I need to use a dedicated sql user. Not knowing MSSQL (or Windows, I’m a mac developer lol) I think I may need to hit up ChatGPT or Grok for this one. :)
+4
Create SQL User in SQL Server 2022 Database using SSMS
Give Permission to SQL User in SQL Server using SSMS on database
I use ChatGPT a lot, but I don’t trust it to give me steps to follow since it will make up stuff that doesn’t exist. It seems to be pretty bad at knowing how to navigate a UI.
Create SQL User in SQL Server 2022 Database using SSMS
Give Permission to SQL User in SQL Server using SSMS on database
I use ChatGPT a lot, but I don’t trust it to give me steps to follow since it will make up stuff that doesn’t exist. It seems to be pretty bad at knowing how to navigate a UI.
Yup yup! Thanks!
The issue was the developer edition didn’t include SSMS (beyond weird but that’s Microsoft!). Downloaded SSMS separately, added the primary DB user and the IIS AppPool user and I now at least get a login screen, which I can tackle from here… thanks again!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
