SQL connection to the server where webpart is deployed

I:

Run the following command according to the default configuration:

C: \ windows \ microsoft.net \ framework \ v2.0.50727 \ aspnet_regsql.exe

II:

Add the following in Web. config:

<Connectionstrings> <remove name = "localsqlserver"/> <Add name = "localsqlserver" connectionstring = "Data Source = localhost; Integrated Security = sspi; initial catalog = aspnetdb;" providername = "system. Data. sqlclient"/> </Connectionstrings> if a problem occurs with network service, follow these steps: Step 1: Add 'nt Authority \ Network Service' to the Administrator Group Step 2: add a network service user to SQL Enterprise Manager to open SQL Server Enterprise Manager → open "security" Node → select "login" → right-click the list on the right → select "New login" → on the "General" tab, click the button next to "name"... "→ select" Administrators "group → click the" members "button below → select" Network Service "→ click" add "→ click" OK ", map the network service to the db_owner of the relevant database instance.