I got an error of login "sa" with Error 18456 Level 14

I got an error of login "sa" with Error 18456 Level 14 .
Server A is the MSSQL Server where the database sit and
the other Server B is just with MSSQL Server tool which
act as a Terminal Service and have the Accounting
applications.The Accounting application unable to perform
its database transfer to another application on the
Terminal Service. We use Window 2003 Server. The
application programs are fine. The ODBC, MSSQL and
application "sa" password are identical. Any idea? ThanksHow many times are you going to post this? See the replies in all the other
groups.
Andrew J. Kelly SQL MVP
"Li" <li@.adb.com.au> wrote in message
news:1cc101c46fbb$b7341db0$a601280a@.phx.gbl...
> I got an error of login "sa" with Error 18456 Level 14 .
> Server A is the MSSQL Server where the database sit and
> the other Server B is just with MSSQL Server tool which
> act as a Terminal Service and have the Accounting
> applications.The Accounting application unable to perform
> its database transfer to another application on the
> Terminal Service. We use Window 2003 Server. The
> application programs are fine. The ODBC, MSSQL and
> application "sa" password are identical. Any idea? Thanks

i created a login in SQL SERVER 2005 EXPRESS, but cant login...

create login dave with password='abc', default_database=tempdb

when i use this account to login my sql2005, i got

Msg 18452, Level 14, State 1, Server DAVID-398113F7C\SQLEXPRESS, Line 1
Login failed for user 'dave'. The user is not associated with a trusted SQL Serv
er connection.
why?You have probably installed the server such that it only allows Windows Authentication, so you cannot connect with a SQL login.

See the "How to: Change Server Authentication Mode" topic in Books Online for additional information on how to allow SQL authentication.

Thanks
Laurentiu|||follow the How to instruction, on right-click my sql server, i got a error msg. indicating that my server is not correctly registed !

in the reg. properity dialog box, i see my auth. mode is Windows Authentication, is there anything wrong with this ?|||Windows authentication means you can only connect with a Windows login. The login dave that you created is a SQL login, so it will not work if you only enabled Windows authentication. There is nothing wrong here, this is how it works.

However, the error message that you are getting when you right click on your server looks like a problem. You should post to SQL Server Tools General to find out what is wrong. If you cannot get an answer, please open a bug at http://lab.msdn.microsoft.com/productfeedback/Default.aspx.

In the meantime, you can try to change the authentication mode manually by modifying the following registry information to contain value 2 instead of 1:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\LoginMode

1 means Windows authentication, this is the value you should find set. By changing this to 2, you'll set the mixed authentication mode. Be sure to restart the server for this change to take effect.

Thanks
Laurentiu|||thx! i changed the reg key, and it works fine now!

but, still, i cant get the server work, it popup a [SQL-DMO] erros|||Try posting on the SQL Server SMO/DMO forum with the text of the error and a description of the steps you took before you received it. There might be something wrong with your installation though. Have you tried installing on a different machine or reinstalling? Did you get any errors during the initial installation?

Thanks
Laurentiu

I can't dissable a dimension level

SQL Server 2005 april CTP
Hi, I have an snowflake dimension with 2 levels which I used in a cube. But I need to link it to the top level.
In AS 2000, the only thing I used to do is to disable the next level from the linked level. Now i'm trying to do this with no success.
How can I do that?
For example:
Dimension: Warehouse
Level 1: Warehouse
Level 2: Rack
I have linked my cube to the level Warehouse and I want to disable level Rack but AS raises this error: Errors in the metadata manager. The attribute for the 'Rack' source attribute, of the 'Rack' source cube level, is disabled.
I need to disable this level because it isn't linked to the cube.
Any ideas?
Thanks in advance.It was my error. I have mystake definning the key of the dimension. I fixed the key. Then in dimension usage you only have to define the correct granularity of the dimension and that's all.

I am Really confusing Please help me about a single query

Hi Guys,
This is my Problem.
A table contain following desing for handling different level of categories, bu it is dynamic

int_categoryid,
int_parent_categoryid,
int_categorylevel,
str_categoryname,
bit_active
thatall.
I want to list data from table as following order
categorry_parent11
category_child12
category_child13
category_child23
category_child22
categorry_parent21
..................
................................
.....................
like this..
ie we can insert parent category and sub category to n level dynamically without adding a new table
please mail me for another clarification...

please help me
regards
Abdul
For the example data you provided, can you tell us what data appears in the int_categorylevel column for each row?
categorry_parent11
category_child12
category_child13
category_child23
category_child22
categorry_parent21
|||

Thanks, tmorton
yes I am also interesting in int_categorylevel, and it gives the information about category level, 0,1,2 etc...
for Example Suppose we can take hotel menu categories...
Lunch Catgeroy level is 0
Veg Catgeroy level is 1
Average Catgeroy level is 2
Expensive Catgeroy level is 2
Non Veg Catgeroy level is 1
Chicken Catgeroy level is 2
Mutton Catgeroy level is 2
thanks ur response...