If you are running SQL Server 2005 on the other computer, then by
default, it does not have the named pipes protocol enabled.
In order to enable this, you have to go to the SQL Server Configuration
Manager on the machine that has SQL Server installed, and then go to "SQL
Server 2005 Network Configuration". Under that will be a branch "Protocols
for MSSQLSERVER". Select this.
On the right, you will see a listview which has "Protocol Name" and
"Status". Right click on "Named Pipes" and select Enable.
--
- Nicholas Paldino [.NET/C# MVP]
-
mv*@spam.guard.caspershouse.com
"icegray" <ic*****@gmail.comwrote in message
news:11**********************@q69g2000hsb.googlegr oups.com...
Hi,
I am new about C# and MS SQL. I have done a new program which use MS
SQL Database and I've install it to a new computer. But program
doesn't run on new computer. I give SQL Server Connection Error
(provider:SQL Network Interfaces, error: 26 - Error Locating Server/
Instance Specified ).
My Connection strings (I tried both and both are ok on my machine but
don't run on another machines)
"Data Source = Serdar\FARE;Initial Catalog = DigitestStock;Integrated
Security = sspi"
"Server=Serdar\fare;Database=DigitestStock;Trusted _Connection=True;"
How can I fix this problem?
thanks