September 26, 2005 at 11:26 am
I was following the instructions found here but had a problem and don't know what is causing it.
http://www.sqlservercentral.com/columnists/awarren/introductiontotheadoconnectionobject.asp
I created an application role on the database.
Using the Data Link Properties dialog I chose the provider. Then on the Connection tab, I had to type in the Server name because it did not appear in the combo box or drop down menu. I don't know if that was the first problem or not.
I put in the application role name and password under "Use a specific user name and password:"
I checked Allow saving password.
When i got down to number 3, "Select the database on th server," I clicked the combo box and got an error: "Login failed for user 'FAELOGIN'. Reason: Not associated with a trusted SQL Server connection."
Then another message box displays: "Login failed. Catalog information cannot be retrieved."
I don't know why i'm alway running into these stupid issues!
September 27, 2005 at 4:51 am
September 27, 2005 at 8:36 am
Thanks man! I thought it had worked but it didn't. My server still says LOCAL it does not have my server name in Enterprise Manager.
When i click the drop down arrow in Data Link Properties it still doesn't show.
If i cut and pasted the connection string from elsewhere will it work or does this mean it will not work?
September 27, 2005 at 10:02 am
Here's a handy reference: http://www.connectionstrings.com
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
September 27, 2005 at 11:19 am
Thanks for the site. I'm going to give it a try.
September 27, 2005 at 1:35 pm
Thanks a million! The connect string worked without any problems (using my login at least). Now i have to see if it will use my application role that i set up.
September 27, 2005 at 1:47 pm
Glad to be able to help. Have a great day !
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy