ansaurus

Question

Connection Strings between Web Application and SQL Server

Answer 1

+2 A:

This is is not a coding error, it indicates the authentication credentials are wrong. Are you able to connect with the database using these credentials using SSMS? Are you sure you are connect to the right server?

RedFilter 2010-06-09 15:07:59

for connecting to a local sql express, the database credentials are mostly not known by a database administrator

Tim Mahy 2010-06-09 15:13:14

Good point - OP should have a talk with themselves then! I updated my response.

RedFilter 2010-06-09 15:22:16

I appear to be unable to log in through SSMS with those credentials. I then created a new login (User: theAdmin; pwd: password) and that was unable to connect to the server using SQL authentication either. I got the following error: Cannot connect to DEVPC1\SQLEXPRESS.Login failed for user 'theAdmin'. (Microsoft SQL Server, Error: 18456)

Raven Dreamer 2010-06-11 14:59:15

Answer 2

+2 A:

it will help if you replace USERID and PASSWORD with your actual credentials along with "DATABASE" (unless this is the name of your database ofcourse :) )

Tim Mahy 2010-06-09 15:08:48

I would assume he was obfuscating his credentials as not to let the internets know his stuff.

Tommy 2010-06-09 15:09:45

let's hope so :)

Tim Mahy 2010-06-09 15:12:36

Answer 3

A:

Does user exist in the Db? ConnectionStrings.com is a good reference.

gnome 2010-06-09 15:12:18

ansaurus

tags:

views:

answers:

Connection Strings between Web Application and SQL Server

related questions