I am trying to connect to SQL 7.0 on a remote machine(machine name: HQ_RAS, Server Name: HQ_RAS) using VB/AD0. Here are the connection parameters:
cn.Provider = “SQLOLEDB”
cn.Properties(“Data Source”)= “\\HQ_RAS\HQ_RAS”
cn.Open
I created a Global group named SQLAccess with 2 members on our PDC, then created a local group on HQ_RAS with the SQLAccess group as a member. I added the local group as a login on the SQL Server and added the login to all of the fixed server roles and to the db_owner fixed database role for the database that I intend to access. I also gave all possible permissions for that database. When cn.Open runs I recieve the following message:
Run-time error’-2147467259 (80004005)’:
[DBNMPNTW]ConnectionOpen (CreateFile())
I am not using ASP or a Web Server, but these are sited in all of the documentation on this error message that I have been able to find.
Thanks!