troubleshooting Question

Set up a new MSSQL Server database user for asp.net

Avatar of critto
crittoFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft IIS Web ServerASP.NETMicrosoft SQL Server 2008
2 Comments1 Solution355 ViewsLast Modified:
Hi experts,

I am developing an asp.net mvc application and I am trying to use a different account with sql server than my system account. I have set up a user in sql server, and added that user to the list of users for the database i am trying to connect to.

When my site hits the database locally, it won't connect with the sqlserver login credentials. Instead Im getting the NT Network \ SQL server Authroisation error.

Im locally working in 3.5 framework with IIS7 and sql 2008.

Should I not just be able to add a user to the database and then make requests to the sql server from my site using the new user's id and password?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros