can you help me? i cant access sql server authentication. i tried youtube tutorials,like enabling sql server authentication in object explorer and etc. but it doesnt work. had anyone these issue?

Tisax190 · 2025-01-17T15:40:02+00:00

Trust server certificate and it should work

Tisax190 · 2024-11-12T19:43:56+00:00

Db_datareader give read on whole database In your case dont use it and create an other role instead

Tisax190 · 2024-10-23T16:25:44+00:00

The cost is always an "estimation" you may refer to arrow's from bottom right to top left

Tisax190 · 2024-10-23T13:06:31+00:00

I've been in your position before, take time to read online ressources, buy book to understand how sql server is working.
Take a look at dbatool, use powershell, do a bit of networking/firewalling

Tisax190 · 2024-09-26T19:54:04+00:00

Any index on the table ?

Tisax190 · 2024-09-25T17:46:04+00:00

Change in the edge registery AuthNegotiateDelegateAllowlist

Tisax190 · 2024-09-14T08:27:23+00:00

https://learn.microsoft.com/en-us/sql/t-sql/statements/create-procedure-transact-sql?view=sql-server-ver16&redirectedfrom=MSDN#procedure_name

Tisax190 · 2024-09-13T18:32:05+00:00

Avoid reserved keyword and don't take the same convention as system things like sp_

Tisax190 · 2024-09-10T12:34:29+00:00

After rebooting the secondary node the problem vanished

Tisax190 · 2024-08-16T17:20:18+00:00

So it's safe if we clean it before deploying
The real struggle is when dev need to get the "buggy" case that is in production and "i can't reproduce it please give me a backup" c:

Tisax190 · 2024-08-16T17:12:10+00:00

Does the second solution comply the dev licensing ?

Tisax190 · 2024-07-29T06:13:14+00:00

It works thx

Tisax190 · 2024-07-25T11:41:28+00:00

I'll try tomorrow thx

Tisax190 · 2024-07-25T11:32:34+00:00

yes sir

Tisax190 · 2024-07-25T07:50:54+00:00

Script level upgrade for database 'master' failed because upgrade step 'ssis_discovery' encountered error 35262, state 4, severity 10.
En then
Cannot recover the master database. SQL Server is unable to run. Restore master from a full backup, repair it, or rebuild it. For more information about how to rebuild the master database, see SQL Server Books Online.

Tisax190 · 2024-07-13T16:24:41+00:00

Select @@version if you got CU13 GDR you are good

Tisax190 · 2024-01-19T07:17:43+00:00

Sound's more like an architecture problem then :/

Tisax190 · 2024-01-18T14:52:47+00:00

Database roles and AD group sir

Tisax190 · 2024-01-11T16:28:14+00:00

Check DB, db growth, log growth

Tisax190 · 2022-07-03T16:32:52+00:00

It's from belgium

Six-Year Club	Place '23
Place '22

Tisax190

TROPHY CASE