IIS virtual directory - what to do?

Why why why do I get the message "an error occured connecting to the server 'servername'. This server does not exist or is unavailable" when trying to connect to a server in IIS. I know the server exists (it's the same computer I'm using) and that is up and running. Also, why do I need to connect, can I use the SQLXML features without a virtual directory? I have no need to access my DB from the Internet.
Thank you,
HelenaHi

Is the SQL account you are using to connect ot SQL Server, actually exist on the SQL server?

Is the SQL server oyu are trying to connect to the default instance or a named instance?

Are you using OLEDB or ODBC connection to SQL from IIS?

Cheers

SG|||Yes, the SQL account exists.

The server I'm trying to connect is a named instance. (But it should be the default as well since i only have one server?)

I have no idea whether I use OLEDB and ODBC connection, how do I know..?

Thank you, Helena

Originally posted by sqlguy7777
Hi

Is the SQL account you are using to connect ot SQL Server, actually exist on the SQL server?

Is the SQL server oyu are trying to connect to the default instance or a named instance?

Are you using OLEDB or ODBC connection to SQL from IIS?

Cheers

SG|||Hi Helena,

If you are using OLEDB ( i.e a DSN-less connection ) you will see the connection string like this in your ASP page :

Connection.Open "PROVIDER=SQLOLEDB;DATA SOURCE=SQLADMIN1;UID=testiis1sql;PWD=password;DATA BASE=ServerMon"

If you had an ODBC ( i.e. a DSN connection ) it would look like this :

"Provider=MSDASQL;DSN=dsnName;UID=MyUserID;PWD=MyPa ssword;"

see also :
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/pg_ado_providers_2.asp

See also :

http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForODBCDatabases

What does your connection look like?

Cheers

SG.