Is it possible to convert SQL login to Windows Login

spandana s

8y889

Hi,

I have Existing database which has a sql login. My requirement is to convert SQL login to Windows login. Due to some reason we don't have a Source code it is whiped out but sql login is still running.There is any chance from SQL end that I can convert SQL login to Windows Login. If you have a workaround or any kind of help is really appreciated.

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mageshwaran R7y ago
Hi,
please refer this link:
https://dba.stackexchange.com/questions/58235/convert-login-from-windows-authentication-to-sql-server-authentication
0
Jeeva Subburaj8y ago
you can try this

https://www.vb-decompiler.org/

to decompile and modify the code and recompile the exe back again. i personally never tried this. you can try this to see if it works for you.
+1
Jeeva Subburaj8y ago
can you post the .ini file detail here. i need to look into that?
+1
spandana s8y ago
Windows Application written in visual BASIC 6
SQL Server user id and password are hard coded inside the application
Connection string to server and database is read from .ini file.
+1
Jeeva Subburaj8y ago
If my understanding correct, you have some application running in the system (but you dont have source code) which connects to sql database with sql login. now, you want that to change it to windows login. can you provide more details for my following questions.
what kind of application you have (Windows App, Web App). What language it is written?
the sql authentication (user id and password) is hard coded inside the application or is it reading from some config file?

Share more details of what you have and i will see if i can help you to solve your issue.
+1
spandana s8y ago
There is any possiblity that Without source code can we build windows login to connect to the database.
+1
Jeeva Subburaj8y ago
No. you can not convert SQL login to Windows Login. you have to create a new windows login from sql server security and provide the permission to it.
+1