My project is connecting to a sql server . But i cant not open my server normally just by entering the server name in ssms
i do need to follow the steps to connect to the ssms server
- create a shortcut of ssms in desktop and go to properties -> target and there i need to put some url like c:\windows\system32\runas.exe /netonly/user:AD-ENT\name\ "c:\program files(x86)\Microsoft sql server managmanet studio 18\ide\ssms.exe"
- So when i click this it will open a command prompt it will ask for password and i need to enter the password. 3.Now the ssms will open in there i need to go to view -> registered server ->database engine
- Database engine explorer will open
- IN that i need to right click on it and go to new server registration
- in that i need to put my server name
- Since i have already given the password the server will open in windows authendication it self.
I need to create a connection string so that i can use it in my c# project
Kindly help