sql server connection problem

[Savas Ates]

"SQL Server does not exist or access denied"

sql server error:17
i cant connect sql Server 2000
why?

 

[Wayne Wengert]

Are you using a SQL Server Login (if so - check login and password used) or
Windows?

Wayne

 

[Savas Ates]

i can connect with system dsn

name=localhost
and i test my connection
it is succesfull with windows nt authentication

in as p my connection string
Set baglantim=Server.Createobject("ADODB.Connection")
Outpost="PROVIDER=SQLoledb;Initial Catalog=friends;User Id=sa;password=;Data
Source=localhost"

im getting this error
"SQL Server does not exist or access denied"

 

[Savas Ates]

Set baglantim=Server.Createobject("ADODB.Connection")
Outpost="PROVIDER=SQLoledb;Initial Catalog=friends;User Id=sa;password=;Data
Source=localhost"


when i write

Data Source=111.111.111.111(myip)
in my connection string it works


when i write

Data Source=localhost

it doesnt work

why?

 

[Aaron [SQL Server MVP]]

What happens when you ping localhost from a command line? Have you tried
(local), your machine name, 127.0.0.1, etc.?