Cannot connect to local instance of SQL Server Epxress after upgrading from Windows 7 to Windows 10 -

the title pretty says all, let me tell have researched.

i have verified following services running ...

• sql server (sqlexpress)
• sql server browser
• sql server vss writer (i don't know 1 does)

this 1 not start ... reason starts automatically turns off.

• sql server agent (sqlexpress)

when try connect using server_name\instance , windows authentication following error ...

"a network-related or instance-specific error occurred while establishing connection sql server. server not found or not accessible. verify instance name correct , sql server configured allow remote connections. (provider: sql network interfaces, error: 26 - error locating server/instance specified) (microsoft sql server)"

the connection specified in "connect server" box working fine before upgraded. thought might have been norton 360 premier uninstalled , didn't help. having issues adapter dropping internet connection disconnect , reconnect , resolves ... perhaps it's related?

the other technique tried replace server name ip address ... 192.168.0.22\instance ... seemed find sql server rejected windows authentication ...

"login failed. login untrusted domain , cannot used windows authentication."

any getting , running appreciated. have several databases on here , hate have reinstall sql server , manually hook them .. or worse lose of them. have client waiting ... sooner more appreciative i'll be!!

sincerely,

g

update

i have access! not sure did made difference.

• open sql server configuration manager.
• expand sql native client 11.0 configuration (32-bit)
• select "aliases"
• choose alias name ".\sqlexpress"
• change alias name "192.168.0.2\sqlexpress" (using ip address)
• change value of "server" 192.168.0.2\sqlexpress (using ip address)

this allowed me log on server using ".\sqlexpress" alias.

some things not understand ...

• i changed "alias name" expecting appear in list of connections drop down in sql management studio. did not, alias "'\sqlexpress" still there , worked!
• for alias "server\sqlexpress" changed "server" value use ip address received authentication error described earlier, though difference alias name.