Last post Apr 26, 2013 01:22 AM by necro_mancer
Apr 25, 2013 11:36 PM|huoli|LINK
when i connect sqlserver installed in my computer , there are reported a error .error message like following :
Please check the instance name and confirm if sqlserver has config to remote connect .Microsoft sqlserver error:2 .
this error message looks like there are a wrong instance name , and i checked my sqlserver configuration manage , and found that there two instances .
one :sql server (sqlexpress)
the other :sql server(sqlserver)
one is running and the other is stoped , and when i try to start the stoped one ,error message occured and it said that the request failed or the service did not response in a timely fashion .
Thanks for your all help .
Apr 25, 2013 11:53 PM|kaushalparik27|LINK
open services (start > run > type services.msc) and see if all sql related services are up and running or not.
open sql server configuration manager and see if all client protocols are up and enabled except VIA?
open surface area configuration manaer and see if everything is fine there.. commonly see if remote/adhocquery access enabled.
hope it helps./.
Apr 26, 2013 01:22 AM|necro_mancer|LINK
please make sure that the 2 SQL Server instance are not operating under the same SQL port.
You may need to assign different SQL port in order for them to work together
Hope this helps!