LOGIN PROBLEMS - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Author

Topic

Hinduson
Yak Posting Veteran

69 Posts

Posted - 2014-11-22 : 11:36:13

Please am now to SQL SERVER, and am now begining my studies at home. After running the setup and all ended succesfully. I tried logging in and i get an error message.
"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. (Provide: Name pipes provider, error 40- could not open a connection to SQL server) (Microsoft SQL server,error:2)"

Please can someone assist me on how to rectify this problem, and i would be very greatful.

Thanks in advance.

Hinduson

Best Regards.

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2014-11-22 : 16:32:01

Which version of SQL Server did you install? If it is the Express edition, you should try to connect to (local)\SQLExpress. You can find out which version you installed by going to SQL Server configuration manager (SQLServermanagerNN.msc, where NN=10 for 2008, 11 for 2012, 12 for 2014), or to services.msc (i.e., start -> Run -> services.msc). While you are there, verify that the service is running.

Hinduson
Yak Posting Veteran

69 Posts

Posted - 2014-11-23 : 11:10:22

I installed Sql server 2008 enterprise edition

Best Regards.

Hinduson
Yak Posting Veteran

69 Posts

Posted - 2014-11-23 : 11:15:14

Below is the full details..

Overall summary:
Final result: Passed
Exit code (Decimal): 0
Exit message: Passed
Start time: 2014-11-23 13:54:36
End time: 2014-11-23 14:14:30
Requested action: Install

Machine Properties:
Machine name: HINDUSON-PC
Machine processor count: 4
OS version: Windows Vista
OS service pack:
OS region: United States
OS language: English (United States)
OS architecture: x64
Process architecture: 64 Bit
OS clustered: No

Product features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered

Package properties:
Description: SQL Server Database Services 2008
SQLProductFamilyCode: {628F8F38-600E-493D-9946-F4178F20A8A9}
ProductName: SQL2008
Type: RTM
Version: 10
SPLevel: 0
Installation location: I:\SQL.Server.2008.Full.Setup\x64\setup Installation edition: ENTERPRISE

User Input Settings:
ACTION: Install
ADDCURRENTUSERASSQLADMIN: False
AGTSVCACCOUNT: NT AUTHORITY\SYSTEM
AGTSVCPASSWORD: *****
AGTSVCSTARTUPTYPE: Manual
ASBACKUPDIR: Backup
ASCOLLATION: Latin1_General_CI_AS
ASCONFIGDIR: Config
ASDATADIR: Data
ASDOMAINGROUP: <empty>
ASLOGDIR: Log
ASPROVIDERMSOLAP: 1
ASSVCACCOUNT: <empty>
ASSVCPASSWORD: *****
ASSVCSTARTUPTYPE: Automatic
ASSYSADMINACCOUNTS: <empty>
ASTEMPDIR: Temp
BROWSERSVCSTARTUPTYPE: Automatic
CONFIGURATIONFILE: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20141123_135204\ConfigurationFile.ini
ENABLERANU: False
ERRORREPORTING: False
FEATURES: SQLENGINE,FULLTEXT,BIDS,CONN,IS,BC,SDK,BOL,SSMS,ADV_SSMS,SNAC_SDK
FILESTREAMLEVEL: 0
FILESTREAMSHARENAME: <empty>
FTSVCACCOUNT: NT AUTHORITY\LOCAL SERVICE
FTSVCPASSWORD: *****
HELP: False
INDICATEPROGRESS: False
INSTALLSHAREDDIR: C:\Program Files\Microsoft SQL Server INSTALLSHAREDWOWDIR: C:\Program Files (x86)\Microsoft SQL Server INSTALLSQLDATADIR: <empty>
INSTANCEDIR: C:\Program Files\Microsoft SQL Server INSTANCEID: hindu
INSTANCENAME: HINDU
ISSVCACCOUNT: NT AUTHORITY\NetworkService
ISSVCPASSWORD: *****
ISSVCSTARTUPTYPE: Automatic
MEDIASOURCE: I:\SQL.Server.2008.Full.Setup NPENABLED: 0
PID: *****
QUIET: False
QUIETSIMPLE: False
RSINSTALLMODE: FilesOnlyMode
RSSVCACCOUNT: <empty>
RSSVCPASSWORD: *****
RSSVCSTARTUPTYPE: Automatic
SAPWD: *****
SECURITYMODE: SQL
SQLBACKUPDIR: <empty>
SQLCOLLATION: SQL_Latin1_General_CP1_CI_AS
SQLSVCACCOUNT: NT AUTHORITY\SYSTEM
SQLSVCPASSWORD: *****
SQLSVCSTARTUPTYPE: Automatic
SQLSYSADMINACCOUNTS: HINDUSON-PC\HINDUSON
SQLTEMPDBDIR: <empty>
SQLTEMPDBLOGDIR: <empty>
SQLUSERDBDIR: <empty>
SQLUSERDBLOGDIR: <empty>
SQMREPORTING: False
TCPENABLED: 1
X86: False

Configuration file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20141123_135204\ConfigurationFile.ini

Detailed results:
Feature: Database Engine Services
Status: Passed
MSI status: Passed
Configuration status: Passed

Feature: SQL Client Connectivity SDK
Status: Passed
MSI status: Passed
Configuration status: Passed

Feature: Full-Text Search
Status: Passed
MSI status: Passed
Configuration status: Passed

Feature: Integration Services
Status: Passed
MSI status: Passed
Configuration status: Passed

Feature: Client Tools Connectivity
Status: Passed
MSI status: Passed
Configuration status: Passed

Feature: Management Tools - Complete
Status: Passed
MSI status: Passed
Configuration status: Passed

Feature: Management Tools - Basic
Status: Passed
MSI status: Passed
Configuration status: Passed

Feature: Client Tools SDK
Status: Passed
MSI status: Passed
Configuration status: Passed

Feature: Client Tools Backwards Compatibility
Status: Passed
MSI status: Passed
Configuration status: Passed

Feature: Business Intelligence Development Studio
Status: Passed
MSI status: Passed
Configuration status: Passed

Feature: SQL Server Books Online
Status: Passed
MSI status: Passed
Configuration status: Passed

Rules with failures:

Global rules:

Scenario specific rules:

Rules report file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20141123_135204\SystemConfigurationCheck_Report.htm

Best Regards.

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2014-11-24 : 08:27:43

The instance name, as seen in the logs you posted is HINDU. So try connecting to (local)\HINDU. If that does not work, do what I had suggested earlier - i.e., look in the configuration manager or services.msc to see what the name of the service is, and whether it is running.

Hinduson
Yak Posting Veteran

69 Posts

Posted - 2014-11-25 : 09:11:52

Thanks Bro. I tried the windows authentication mode and it worked out without me entering a password.

Best Regards.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources