| Groups | Blog | Home |
sql server new users : login doesn't work
Using SQL Express 2005
I created a new login under the security tab. For these purposes, let's say the login is called "asp". I then created a user on the specific database that I want to use, and called it "asp." I tied it to the login called asp. I made sure that SQL Server is running under Mixed mode. I got out of SQL Server, then brought it back up, and tried to log in using SQL Server authentication as user ASP, and it doesn't work. Says it's not assocaited with a trusted SQL Server connection. What am I missing?
[quoted text, click to view]
> Can you post the connection string. It sounds like you are still using > Windows Auth. What connection string? I am trying to bring up the SQL Server program itself.
SQL Server Express is a Windows Service that runs in the background so
that's not what you're trying to run. I assume you are trying to start the SQL Server Management Studio program. The login you created was a SQL Server authenticated login if you specified a password for it. By default, SQL Express installs with only Windows authentication enabled so to use a SQL authenticated login you will have to enable SQL authentication. Login as you did before, right click on the server icon at the top of the object explorer and select properties. Under properties select security and then select SQL Server and Windows Authentication mode. -- 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 [quoted text, click to view] "Middletree" <middletree@hottttttttmail.com> wrote in message
news:e2y%23asvnHHA.4552@TK2MSFTNGP04.phx.gbl... > SQL Server 2005 Express >
Can you post the connection string. It sounds like you are still using
Windows Auth. -- Andrew J. Kelly SQL MVP [quoted text, click to view] "Middletree" <middletree@hottttttttmail.com> wrote in message news:uWPNkitnHHA.716@TK2MSFTNGP05.phx.gbl... > Using SQL Express 2005 > I created a new login under the security tab. For these purposes, let's > say the login is called "asp". I then created a user on the specific > database that I want to use, and called it "asp." I tied it to the login > called asp. > > I made sure that SQL Server is running under Mixed mode. > > I got out of SQL Server, then brought it back up, and tried to log in > using SQL Server authentication as user ASP, and it doesn't work. Says > it's not assocaited with a trusted SQL Server connection. > > What am I missing? >
[quoted text, click to view] >> And everyone knew what I meant. << This is a bad assumption, especially if you expect to get any help. SQL Server is a background service. There are many different programs and methods available for connecting to it. Why do you think Andy asked for your connection string? -- HTH Kalen Delaney, SQL Server MVP www.InsideSQLServer.com http://sqlblog.com [quoted text, click to view] "Middletree" <middletree@hottttttttmail.com> wrote in message news:eL9WibwnHHA.4220@TK2MSFTNGP04.phx.gbl... >> I assume you are trying to start the SQL Server Management Studio >> program. > > Of course it is. And everyone knew what I meant. > >>Under properties select security and then select SQL Server and Windows >>Authentication mode. >> > > As I explained in my initial post, I already was running in Mixed Mode. >
SQL Server 2005 Express
What SQL Server Program is that?
-- Andrew J. Kelly SQL MVP [quoted text, click to view] "Middletree" <middletree@hottttttttmail.com> wrote in message news:%23rP3IQvnHHA.4412@TK2MSFTNGP02.phx.gbl... >> Can you post the connection string. It sounds like you are still using >> Windows Auth. > > What connection string? I am trying to bring up the SQL Server program > itself. >
[quoted text, click to view]
> I assume you are trying to start the SQL Server Management Studio program. Of course it is. And everyone knew what I meant. [quoted text, click to view] >Under properties select security and then select SQL Server and Windows >Authentication mode. > As I explained in my initial post, I already was running in Mixed Mode.
My apologies. I won't bother you again.
-- 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 [quoted text, click to view] "Middletree" <middletree@hottttttttmail.com> wrote in message
news:eL9WibwnHHA.4220@TK2MSFTNGP04.phx.gbl... >> I assume you are trying to start the SQL Server Management Studio >> program. > > Of course it is. And everyone knew what I meant. > >>Under properties select security and then select SQL Server and Windows >>Authentication mode. >> > > As I explained in my initial post, I already was running in Mixed Mode. >
It is very difficult to interpret someone's intentions through their written
words in a newsgroup posting. No one was criticizing your choice of words. We understand that some people when starting out think of whatever program they use to interact with SQL Server as the "SQL Server Program". That is not a problem. However, you seemed to be assuming that we should know what YOU meant when you said "SQL Server Program". Since there are multiple interfaces that could be used, it was not obvious to those people trying to help you. I interpreted you as being amazed that people here couldn't read your mind and know what interface you were talking about when you said "Of course it is. And everyone knew what I meant." I was just pointing out that is not true. Everyone did NOT know what you meant. We're here to help, but we need enough details from you in order to help. I hope we haven't scared you away. :-) -- HTH Kalen Delaney, SQL Server MVP www.InsideSQLServer.com http://sqlblog.com [quoted text, click to view] "Middletree" <middletree@hottttttttmail.com> wrote in message news:OjF90WynHHA.1240@TK2MSFTNGP04.phx.gbl... > On other newsgroups which deal with subjects that I am very knowledgeable > on, the last thing I feel like doing is nitpicking a newbie's choice of > words. If he needs help, I help him, especially if his choice of words, > while incorrect, are reasonable. In this case being the "new users" group, > it is very understandable if a poster refers to the Management Studio as > SQL Server. While I don't know the program very well, I have seen no other > way of getting into my database than starting the Management Studio, or by > referring to Mixed Mode as Mixed Mode. > > >
On other newsgroups which deal with subjects that I am very knowledgeable
on, the last thing I feel like doing is nitpicking a newbie's choice of words. If he needs help, I help him, especially if his choice of words, while incorrect, are reasonable. In this case being the "new users" group, it is very understandable if a poster refers to the Management Studio as SQL Server. While I don't know the program very well, I have seen no other way of getting into my database than starting the Management Studio, or by referring to Mixed Mode as Mixed Mode.
I think the comments came with the comment that said "everyone knew what I
was talking about", that came off a bit harsh. At any rate let's move on past that and figure out what is happening here. Can you connect just fine still with your windows connection? [quoted text, click to view] "Middletree" <middletree@hottttttttmail.com> wrote in message news:OjF90WynHHA.1240@TK2MSFTNGP04.phx.gbl... > On other newsgroups which deal with subjects that I am very knowledgeable > on, the last thing I feel like doing is nitpicking a newbie's choice of > words. If he needs help, I help him, especially if his choice of words, > while incorrect, are reasonable. In this case being the "new users" group, > it is very understandable if a poster refers to the Management Studio as > SQL Server. While I don't know the program very well, I have seen no other > way of getting into my database than starting the Management Studio, or by > referring to Mixed Mode as Mixed Mode. > > >
I am taking off in a bit probably. If you can connect fine through your
windows authentication account, verify that that account is enabled and not locked out (though that should give a separate error). Also since you had to change to Mixed Mode, please verify that you have stopped and restarted SQL Server. That is one of the changes that requires a stopping and restarting to take place. [quoted text, click to view] "Middletree" <middletree@hottttttttmail.com> wrote in message news:OjF90WynHHA.1240@TK2MSFTNGP04.phx.gbl... > On other newsgroups which deal with subjects that I am very knowledgeable > on, the last thing I feel like doing is nitpicking a newbie's choice of > words. If he needs help, I help him, especially if his choice of words, > while incorrect, are reasonable. In this case being the "new users" group, > it is very understandable if a poster refers to the Management Studio as > SQL Server. While I don't know the program very well, I have seen no other > way of getting into my database than starting the Management Studio, or by > referring to Mixed Mode as Mixed Mode. > > >
Don't see what you're looking for? Try a search.
|
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |