Connection error

[LeoLionHeart]

Hi, I hope that someone can help.

I have two SQL servers with excatly the same databases on (development and live).

When I connect to my dev database using the connection string:

strConnect = "Driver={SQL Server};Server=SERVER;Database=DB;Uid=sa;Pwd=Pass;"

I get results. However, on the other sql server i get the following error:

Error Number: -2147467259
description: [Microsoft][ODBC SQL Server Driver][Named Pipes]Access denied.

Any help would be greatly appreciated.

Thanks

 

[Microbe]

Obviously it is an access error.

Does your user account have rights on the second server? Is the password the same?

Steve Davis

http://www.HaHaHa.com.au/weblog

NOTE: This sig does not include any reference to voting, stars, or marking posts as helpful as doing so is cause for membership termination.