Unable to open named instance

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Unable to open named instance

Unable to open named instance

Rate Topic

Display Mode

Topic Options

Author

Message

Benki Chendu

Posted Monday, September 17, 2012 10:42 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, June 13, 2013 5:23 AM
Points: 119, Visits: 215

I have just installed a named instance for SQL Server 2008 R2.
The name of the instance is "sport".
When I am trying to open the instance in SSMS by specifying the instance name, its throwing an error like"
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)how to solve this error?

But the instance is connecting with I give it as ".\sport"
I need the instance to take the name just as sport. Please help

Post #1360327

Animal Magic

Posted Monday, September 17, 2012 12:11 PM

SSC Eights!

Group: General Forum Members
Last Login: Monday, June 10, 2013 7:21 AM
Points: 983, Visits: 13,356

So you're trying to connect to a named instance without specifying the server name? Is that correct?

Post #1360387

ThomasRushton

Posted Monday, September 17, 2012 12:33 PM

SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 7:39 AM
Points: 967, Visits: 374

This might help: SQL Server Aliases.

Post #1360397

tim_harkin

Posted Monday, September 17, 2012 3:07 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 2:15 PM
Points: 142, Visits: 365

Is the SQL Browser service running?

Post #1360467

Benki Chendu

Posted Tuesday, September 18, 2012 6:58 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, June 13, 2013 5:23 AM
Points: 119, Visits: 215

SQL Browser service is on.
I am also specifying the instance name in Management studio.
Its only accepting the instance name as .\sport and not just sport.

Post #1360763

anthony.green

Posted Tuesday, September 18, 2012 7:11 AM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 2:40 AM
Points: 5,075, Visits: 4,833

You will need to create an alias as already stated above by Thomas.

Other than that create a new server named SPORT and install a default instance.

Note the alias will need to be created on all servers where you want to just connect to the SQL server .\SPORT as just SPORT

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1360767

« Prev Topic | Next Topic »

Permissions