Re: Cannot connect using sa


"Sue Hoegemeier" <Sue_H@xxxxxxxxxxxxx> wrote in message
news:lpg2r19641gd306h3jjt9874cahge32u6b@xxxxxxxxxx
> Make sure you have it configured to allow both SQL Server
> and Windows authentication. Looks like it might be set to
> Windows authentication only.

I found an article in MSDN telling how to change authentication
in SQL Server Management Studio. I don't have that.
I removed the password and user from the connection string.
Now it is working. Funny it didn't work to remove it yesterday.
Still not sure what the advantage of SQL Server authentication is.
Thanks.

Ralph

> -Sue
>
> On Mon, 26 Dec 2005 16:56:05 -0700, "ralph"
> <vralphv@xxxxxxxxxxxxx> wrote:
>
>>I downloaded C# 2005 Express and downloaded sql 2005 Express at the same
>>time.
>>It installed without giving me a chance to set a password.
>>I am able to connect to it using sqlcmd -E -S localhost\SQLEXPRESS but
>>not if I use sqlcmd -S localhost\SQLEXPRESS -U and type in the password.
>>I get
>>Login failed for user 'sa' . The user is not associated with a trusted
>>SQL
>>Server
>>connection.
>>
>>I set using ALTER LOGIN sa WITH PASSWORD = 'mypassword'
>>Now I used an example program in c# for Java Developers, changing it a
>>bit.
>>I put in a connection string containing User ID=sa;PASSWORD=mypassword;
>>I was able to connect to Northwind, but when I tried to select from table
>>Customers it said invalid object 'Customers'.
>>
>>Then I connected with sqlcmd using the -E and then I created a Database
>>called
>>people, and made a table called person. Still problems inserting from the
>>program
>>and doing a select. So I removed the User ID=sa;PASSWORD=mypassword
>>from the connection string, couldn't connect, then when I put it back I
>>still
>>couldn't connect, getting the same error. I can't figure out what is
>>slightly different
>>in the connection string.
>>
>>The connection string currently is
>>
>>string conStr = @"Data Source=.\SQLEXPRESS;" +
>>"User ID=sa;PASSWORD=mypassword;" +
>>"Database=people;" +
>>"Integrated Security=True";
>>
>>The error is
>>
>>Cannot open database \"people\" requested by the login. The login failed.
>>Login
>>failed for user 'MDG-13E0564D3NC\\MDG User'.
>>
>>Also still get the same error using the -U option in sqlcmd.
>>
>>Do I need to make a login for 'MDG-13E0564D3NC\\MDG User'?
>>How do I get sa associated with SQLEXPRESS?
>>Searched in google and found advanced stuff that doesn't help
>>
>>Thanks,
>>Ralph
>>
>>
>
















































.

Relevant Pages

  • Re: Credentials not being passed with remote access
    ... allowed windows authentication to work, ... I had assumed johnx was a domain user rather than a local Windows account. ... johnx was set up as a local login on sql server. ...
    (microsoft.public.sqlserver.security)
  • Re: Very basic login question
    ... In order to use Windows Authentication the two computers have to be members of the same domain or trusted domains. ... you should have a login at the SQL Server on the XP Pro workstation. ...
    (microsoft.public.sqlserver.security)
  • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intra
    ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
    (microsoft.public.sqlserver.connect)
  • Windows Authentication connectionstring Login failed for user Gue
    ... authentication to access SQL Server using the sa login. ... sa login, I want to convert the app to use Windows Authentication. ... Then I changed the connection string to: ...
    (microsoft.public.data.ado)
  • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intranet
    ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
    (microsoft.public.sqlserver.connect)