nithya shiva

nithya shiva

  • NA
  • 15
  • 1.3k

how to connect to registered server in visual studio

Mar 12 2022 3:33 AM

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

  1. 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"
  2. 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
  3. Database engine explorer will open
  4. IN that i need to right click on it and go to new server registration
  5. in that i need to put my server name
  6. 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


Answers (3)