Solved

Login failed for sql user

Posted on 2008-11-02
1
226 Views
Last Modified: 2012-05-05
I purchase windows 2008 web server edition and sql server 2008 web edition.

They are both installed on two different boxes on the same network.

The sql server 2008 web  edition is installed on a windows vista ultima operating system.

I created a local user on both boxes SQLIISUser, same password.

In the anonymous authentication for IIS7 for the website, I have added the SQLIISUser and it's password.

On the database server, I have added the user to the security for the database with its password. I gave the user dbreader and dbwriter permissions.

From visual studio 2008, when running in localhost to the remote database, I can connect fine. But when connecting live from the web, I get this error:
Exception Details: System.Data.SqlClient.SqlException: Login failed for user

Also, I did create the user using sql server authentication on the database server, but the connection string in the web config uses windows authentication.

Please help me get these two boxes to communicate.

My hardware firewall does have the two sql ports open, 1433-1434 for tcp and udp.

And yes, both boxes can communicate with one another via the network.

thanks.
0
Comment
Question by:Starr Duskk
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 2

Accepted Solution

by:
m3tech earned 500 total points
ID: 22862890
Did I understand you correctly? The user is set up in SQL using sql authentication and the web app is using windows authentication to autenticate to the sql server?

If that is the case it is also your problem. If you want to use windows authentication the windows account being used by your webserver needs rights to the database.  (such as giving webserver\SQLIISUser permission to read/write to the database).

Alternatively set your web app to connect to your database using sql authentication. There is a SQL ODBC driver available from microsoft that may make this process easier, granting your entire web server access to your database via and ODBC connection.

More specific info / code would be needed to give more specific advice / examples.
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question