Plz help me SQL 2005 ( Attach database File .mdf ) -- sql server connect

hossam mohamed
11/9/2006 2:11:23 PM

when i try to attach file there is an error occur

" 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) "

Plz help me i try all things

• Enable remote connections on the instance of SQL Server that you want
to connect to from a remote computer.
• Turn on the SQL Server Browser service.
• Configure the firewall to allow network traffic that is related to SQL
Server and to the SQL Server Browser service

but still error occur :(
Plz help me :)

Hari Prasad
11/12/2006 8:36:18 PM

Are you able to connect to SQL Server Management studio and exeute simple
queries like SP_WHO and all?
If no; then verify the network connectivity from host to server.

Thanks
Hari

[quoted text, click to view]

sql server connect : Plz help me SQL 2005 ( Attach database File .mdf )