September 17, 2012 at 10:42 am
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
September 17, 2012 at 12:11 pm
So you're trying to connect to a named instance without specifying the server name? Is that correct?
September 17, 2012 at 12:33 pm
September 17, 2012 at 3:07 pm
Is the SQL Browser service running?
September 18, 2012 at 6:58 am
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.
September 18, 2012 at 7:11 am
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
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply