Re: Can no longer connect as sa

Is there a reason you need to connect using SQL authentication? SQL Express
defaults to Windows authentication. If you really want to use SQL
authentication, you will need to change the authentication to mixed mode and
enable the SA login.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

"ralph" <vralphv@xxxxxxxxxxxxx> wrote in message
news:E_3sf.84556$2k.58243@xxxxxxxxxxx
> This post didn't show up 6 hours ago.
>
> 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 butnot
> 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: EXEC master..xp_cmdshell Prevention
    ... > I found that my web application did use a connection string in a file ... > stored procedures for every SQL statement would be impractical. ... I have created a new login account ...
    (microsoft.public.sqlserver.security)
  • Re: Persisting user login credentials across pages
    ... In ASP.Net 1.1 most people add the connection string to the web.config file. ... "Siobhan" wrote in message ... >> Sample code requires you to have a login method on your Principal class ... >>> I am not sure how Forms authentication would work - the sample using ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: [PHP] Is this the best way?
    ... I am attempting to add a little error checking for a very simple login system. ... So maybe I should edit my authentication function... ... I recommend lower or upper case only for sql entity names ... really be either attempting an authentication *or* outputting some message ...
    (php.general)
  • Re: How to prevent connection string from user?
    ... I directly send connection string to DB then another ... > can filter my account and password. ... When you want to connect with Windows authentication, ... the desired SQL Server login needs to be specified. ...
    (microsoft.public.sqlserver.security)
  • Re: Can no longer connect as sa
    ... > Is there a reason you need to connect using SQL authentication? ... >> Login failed for user 'sa'. ... >> I can't figure out what is slightly different in the connection string. ...
    (microsoft.public.sqlserver.setup)