Advertisement

03.28.2007 at 05:14PM PDT, ID: 22479163
[x]
Attachment Details

"Login failed for user ''. The user is not associated with a trusted SQL Server connection." How do I fix this issue?....

Asked by jazjef in dBase, MS SQL Server

Tags: associated, trusted, sql, server, failed

At work I have a Windows logon account called username 'bullwinkle' and a password called 'moose'

The IT dept has set up a new machine for me so I can setup IIS with a virtual server to an application I wrote that collects data. The application works 100% fine on my development machine. On the new machine it works great up until the point at the end where I have to connect to the SQL db for writing the data.... then I get the following error:

      "Login failed for user ''. The user is not associated with a trusted SQL Server connection."

***I would like to emphasize the fact that:

1) there is no username that shows up in the error... only an empty set of commas ' '
2) SQL server is already set to 'mixed' mode

The IT SQL Server guy gave me the user name and password that allow writing and reading from the SQL database for the application I wrote. The username and password he gave me for this is username 'batman' and the password is called 'robin'. However, there is no account on the new machine for 'batman' to logon with.... only my 'bullwinkle' user account will allow me to logon.

I told the IT guy that the new machine needed an account setup for 'batman' and the pasword setup to 'robin' .... this will allow me to use the Windows logon account of 'batman' and password 'robin'. Having IIS set to use Windows logon will then fall back on this 'batman' account----which is the same account and password that is set up with permission to access the SQL Server dbase.

At the moment, the error occurs when I am logged in with my 'bullwinkle' account----but the SQL Server permission to write-read from the database is only authorized for the 'batman' account---which doesn't exist on the new machine.

Am I correct about insisting there has to be a 'batman' account in order to have an existing Windows logon account that will also have permission to write-read to the SQL Server?

Help. ..... many thanks.

Start Free Trial
[+][-]03.28.2007 at 05:30PM PDT, ID: 18812924

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.28.2007 at 05:41PM PDT, ID: 18812956

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.28.2007 at 06:14PM PDT, ID: 18813085

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]03.28.2007 at 06:25PM PDT, ID: 18813132

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.28.2007 at 06:43PM PDT, ID: 18813186

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: dBase, MS SQL Server
Tags: associated, trusted, sql, server, failed
Sign Up Now!
Solution Provided By: Wizilling
Participating Experts: 2
Solution Grade: A
 
 
[+][-]03.29.2007 at 01:45PM PDT, ID: 18819683

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]03.29.2007 at 03:14PM PDT, ID: 18820227

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32