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.
| Author |
Topic |
|
Srain
Starting Member
23 Posts |
 Posted - 2009-10-24 : 01:39:37
|
| Hi All,please help me resolving below sql issue.I am building an application which does the Sql server DB setup. The issue am facing is during executing build the build failed with below warning and errorWARNING: this machine does not have a SQL Server 2005 instance named SQL2005.ERROR: Connection failure. An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)I have checked in my SQL Server setup but that shows remote connections enabled. Please suggest what should i do to get the build succeeded. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-10-24 : 06:06:20
|
In normal cases the name of the default sql server instance is the name of the box.Are you sure there is an instance named SQL2005?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
Srain
Starting Member
23 Posts |
Posted - 2009-10-24 : 09:20:18
|
Do I need to create named instance(SQL2005) while installing SQL server 2005? As per the error description under the default settings SQL Server does not allow remote connections but when i have checked the setting in Server properties the remote connection option was enabled. Any help would be much appreciated.quote:
Originally posted by webfred
In normal cases the name of the default sql server instance is the name of the box.Are you sure there is an instance named SQL2005?
No, you're never too old to Yak'n'Roll if you're too young to die.
|
|
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-10-26 : 06:16:54
|
| No, you do not require a named instance. What is the connection string? |
|
|
|
|
|
|
SQL Instance Error