Test database connection failed via hostname in ASP Page.

M

Microlong®

I have a problem in the ASP Page. I use the ASP page to test whether the
connection of SQL Server is fine. I use windows authentication. I get fail
when I attempt to use hostname of the destination server. Contrary, I get
success when I attempt to use IP address of the destination server. Does
anyone know how to fix this issue?
Any help will be appreciated.
thanks.
Microlong
 
B

Bob Barrows [MVP]

Microlong® said:
I have a problem in the ASP Page. I use the ASP page to test whether
the connection of SQL Server is fine. I use windows authentication. I
get fail when I attempt to use hostname of the destination server.
Contrary, I get success when I attempt to use IP address of the
destination server. Does anyone know how to fix this issue?
Any help will be appreciated.
thanks.
Microlong
Make sure you are using the appropriate SQLOLEDB connection string. Examples
can be found at www.carlprothman.net.

Other than that, all I can suggest is that you search www.aspfaq.com and
support.microsoft.com for articles containing either your error number or
your error message (whatever those are <hint>)

Bob Barrows
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top