Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 392
  • Last Modified:

Cannot connect to sql instance after ugrading from 2008 express to 2008 full

Hi,

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
 
0
UFCWIT
Asked:
UFCWIT
  • 4
  • 2
1 Solution
 
UFCWITAuthor Commented:
p.s. - I am running windows server 2008
0
 
jlanderson1Commented:
Did you verify all services are running?  Specifically, the SQL Browser?
Also, did you specify a service account for the SQL Services?
0
 
UFCWITAuthor Commented:
the sql server (sqlexpress) is not running. When i try to start it it comes up with the following error message

"the request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details"
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
UFCWITAuthor Commented:
the error it shows in event viewer when trying to start service is
"SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems."
0
 
UFCWITAuthor Commented:
I think i might have got it, I disabled the via in the protocols after reading a help article about it and i am able to connect now
0
 
jlanderson1Commented:
That's good news.  You solved it yourself!
0
 
shalabhsharmaCommented:
Start the MSSQL Service  under the Local service account .
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now