Creating a connection to MSSQL 2000 on MS Server 2003

[zed500]

I am trying to create a connection to a MSSQL2000 database located on a Win
2003 server. I have successfully used the Database tab on 'Site Settings'
when connecting to MSSQL on a Win 2000 server but I get errors when trying to
connect to the 2003 server. I receive the following error:
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist
or access denied.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147467259 (0x80004005)

I have searched the web and cannot find anything helpful.
Thanks in advance.

 

[zed500]

I am using FrontPage 2003. Sorry, forgto to mention that.

 

[Stefan B Rusynko]

Try http://www.aspfaq.com/show.asp?id=2009

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


|I am using FrontPage 2003. Sorry, forgto to mention that.
|
| "zed500" wrote:
|
| > I am trying to create a connection to a MSSQL2000 database located on a Win
| > 2003 server. I have successfully used the Database tab on 'Site Settings'
| > when connecting to MSSQL on a Win 2000 server but I get errors when trying to
| > connect to the 2003 server. I receive the following error:
| > [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist
| > or access denied.
| >
| > Source: Microsoft OLE DB Provider for ODBC Drivers
| > Number: -2147467259 (0x80004005)
| >
| > I have searched the web and cannot find anything helpful.
| > Thanks in advance.
| >
| >
| >