Cannot connect to sql instance after ugrading from 2008 express to 2008 full
Posted on 2010-08-31
We have been using a sql 2008 express edition connecting through management studio using webufcw\sqlexpress with windows auth.
This morning I used the upgrade advisor to upgrade from express to enterprise and now i get the following error when trying to connect using management studio
"A network-related or instance-specific error occured while establishing a connection to sql server. the server was not found or was not accessible. Verify that the instance name is correct and that sql server is configured to allow remote connections (provider named pipes provider, error: 40 - could not open a connect to sql server)"
I made sure tcp-ip and name pipes were enabled for the instance after the upgrade and i also tried turning off windows firewall and still can't connect
thanks in advance