sql server connect: I have an application developed by ASP. I use OLE DB to connect Product
Server. I can connect product server with IP address, but failed with
hostname.
Win2k3 sp1 and sql server 2ksp3:
error:
Attempting Connection with Connection String:

Provider=SQLOLEDB;Data Source=Hostname;Initial Catalog=Database;INTEGRATED
SECURITY=SSPI

Microsoft OLE DB Provider for SQL Server error '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied.

/testconn.asp, line 35

--
Developer
QA Dashboard

Could it be that your are using a different instance then the default
(e.g. syntax hostname\InstanceName) or another port than the usual one
1433 ? (e.g. syntax hostname,Portnumber)

Try to runa OSQL -L at the comamndline to do a broadcast around the
network to find available sql servers as they are exposed in the
network.

HTH, jens Suessmeyer.

however, the SQL SERVER isn't local and it is production server. Does someone
offer more helps for this issue?
--
Developer
QA Dashboard
Microsoft China Development Centre


[quoted text, click to view]