Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

unable to connect with default instance Expand / Collapse
Author
Message
Posted Thursday, August 1, 2013 11:10 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 4, 2013 7:58 PM
Points: 3, Visits: 21
Hi,

I have installed sql server 2008r2 enterprise edition on my system.i have got the following errors such as
1) unable to connect with an instance name ..some network failure.when I repaired that software master database was not existing and database engine connection problems.

so, i uninstall and installed it properly.still iam unable to connect with default instance but i can connect through named instance and local.

Could anyone explain me the reason.when i searched on Google,someone mentioned that we don't connect through default instance.As of my knowledge i did connect through that instance before on my frnd's system.please explain me the problem.

thank you..!!!
Post #1480044
Posted Friday, August 2, 2013 2:46 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
can you post the error which you recieved last, check in services sql default service is started or not .

Regards
Durai Nagarajan
Post #1480298
Posted Friday, August 2, 2013 2:54 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, June 16, 2014 8:52 AM
Points: 51, Visits: 398
Check out this connectivity troubleshooter:
http://blogs.msdn.com/b/sql_protocols/archive/2008/04/30/steps-to-troubleshoot-connectivity-issues.aspx
Post #1480304
Posted Friday, August 2, 2013 3:37 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 8:00 AM
Points: 234, Visits: 1,083
Is the SQL service running ? Is there anything in the SQL / windows logs ?

Cheers

Vultar
Post #1480632
Posted Sunday, August 4, 2013 5:01 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 4, 2013 7:58 PM
Points: 3, Visits: 21
TITLE: Connect to Server
------------------------------
Hi, the following error has occured.....!!!!! server is running and protocols are also enabled.
Named instance is working but default instance is not.


Cannot connect to SINDU-PC\MSSQLSERVER.

------------------------------
ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred 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: SQL Network Interfaces, error: 25 - Connection string is not valid) (Microsoft SQL Server, Error: 87)



Post #1480797
Posted Monday, August 5, 2013 9:58 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, July 21, 2014 3:07 PM
Points: 47, Visits: 812
teertha (8/4/2013)
TITLE: Connect to Server
------------------------------
Hi, the following error has occured.....!!!!! server is running and protocols are also enabled.
Named instance is working but default instance is not.


Cannot connect to SINDU-PC\MSSQLSERVER.

------------------------------
ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred 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: SQL Network Interfaces, error: 25 - Connection string is not valid) (Microsoft SQL Server, Error: 87)





Hi,

Default instance need not be specified as MSSQLSERVER, you just put the hostname "SINDU-PC" then connect and it should work, also ensure your firewall is enabled for defaults ports and dns properly working.

Regards,
Post #1481151
Posted Tuesday, August 6, 2013 1:41 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, April 9, 2014 4:18 AM
Points: 277, Visits: 288
First Check weather SQL Server Instance is running and exists.
to see list of intances use
Go to command prompt and type in “osql -L” or “sqlcmd -L”.
or
use
http://www.queryingsql.com/2013/02/search-all-running-sql-server-instances.html

If instance is showing in list then check your credentials.


Thanks.......
-----------------------------------
My Blog | Articles
Post #1481195
Posted Wednesday, August 7, 2013 9:08 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 3:21 PM
Points: 1,210, Visits: 2,512
Perhaps a silly question, but did you install a default instance? IIRC, you can install a named instance without first installing a default instance. If you only ran the install once and specified a named instance at the time, you don't have a default instance.

Jason Wolfkill
Blog: SQLSouth
Twitter: @SQLSouth
Post #1481927
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse