Forum Discussion

cjacs's avatar
cjacs
Copper Contributor
Oct 09, 2022
Solved

Problems with connection string for SQLserverexpress 2019

Hi   I am looking for help please. I am new to sqlserverexpress 2019 and experimenting at the moment to get familair with the system.   I have created a sqlserver using all the defaults on my loc...
  • olafhelper's avatar
    olafhelper
    Oct 10, 2022

    Hello Chris,

    use either the instance name or the IP port, but not both. And in .NET you have to quote a backslash =>

     

    Data Source="CHRIS-LAPTOP\\SQLEXPRESS;Persist Security Info=False;User ID=sa;Password=mypasswordhere"

     

    Olaf

olafhelper's avatar
olafhelper
Bronze Contributor
Oct 10, 2022

Hello Chris,

use either the instance name or the IP port, but not both. And in .NET you have to quote a backslash =>

 

Data Source="CHRIS-LAPTOP\\SQLEXPRESS;Persist Security Info=False;User ID=sa;Password=mypasswordhere"

 

Olaf

Resources