By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,998 Members | 2,773 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,998 IT Pros & Developers. It's quick & easy.

sql server connection problem

P: n/a
"SQL Server does not exist or access denied"

sql server error:17
i cant connect sql Server 2000
why?
Jul 21 '05 #1
Share this Question
Share on Google+
4 Replies


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

Wayne

"Savas Ates" <sa***@indexinteractive.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...
"SQL Server does not exist or access denied"

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

Jul 21 '05 #2

P: n/a
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"

Jul 21 '05 #3

P: n/a
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?

Jul 21 '05 #4

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

--
http://www.aspfaq.com/
(Reverse address to reply.)


"Savas Ates" <sa***@indexinteractive.com> wrote in message
news:Os**************@TK2MSFTNGP12.phx.gbl...
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?

Jul 21 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.