Connection Sting to SQL Availability Group Listener.
Set CFFNConn = CreateObject("ADODB.Connection") CFFNConn.ConnectionString = "Supplier=SQLOLEDB;Information Supply=SQLListener,2433;Database=DB_Name;Person ID=sqluser;Password=*********;" CFFNConn.Open
I get the next error.
Microsoft OLE DB Supplier for SQL Server error ‘80004005’ Can’t open
database “DB_Name” requested by the login. The login failed.
/Conn.asp, line 6
I checked out a number of pages by means of Google, and nothing I attempted, labored.
I added the db_owner for the consumer, for the database I used to be testing, and that didn’t work.
Typically this situation is a misspelling of the database identify, however that’s not the case right here.
In a earlier situation I had with a connection string, I needed to write it out like so.
Nonetheless, that’s not the case right here both.
Any help on this might be nice.