Problem Retrieving @@Identity when inside a transaction.

I'm using transactions with my SqlConnection ( sqlConnection.BeginTransaction() ).
I do an Insert into my User table, and then subsequently use thegenerated identity ( via @.@.identity ) to make an insert into anothertable. The foreign key relationship is dependant on the generatedidentity. For some reason with transactions, I can't retrieve theinsert identity (it always returns as 1). However, I need theinserts to be under a transaction so that one cannot succeed while theother fails. Does anyone know a way around this problem?
So heres a simplefied explanation of what I'm trying to do:
Begin Transaction
Insert into User Table
Retrieve Inserted Identity (userID) via @.@.Identity
Insert into UserContact table, using userID as the foreign key.
Commit Transaction.
Because of the transaction, userID is 1, therefore an insert cannot bemade into the UserContact table because of the foreign key constraint.
I need this to be a transaction in case one or the other fails. Any ideas??


Try using Scope_Identity() instead of @.@.IDENTITY and see if that solvesyour problem. Scope_Identity will give you the last identityvalue generated in your current scope.
|||I tried using Scope_Identity() and I'm getting the exact same problem.
|||I can tell you that I just tried out your scenario and it worked withno problem for me. I tried it both wrapped in a transaction andnot. So there is something particular about your code that iscausing the problem. Could you post it here?
|||Fixed it. Had nothing to do with transactions. Stupid error on my part.
It seems as though I forgot to encapsulate my sql insert procedure in aBegin / End block, so that when I performed an insert it returned 1instead of the @.@.Identity which was on the next line.
Thanks for trying to help! Much appreciated =D
|||I'm glad you got it sorted. Be sure to use Scope_Identity()instead of @.@.IDENTITY. If at some point in the future, e.g., atrigger is added to your table which inserts a record into some table,@.@.IDENTITY will contain the Identity value of that inserted record, andthat's not what you want.

Problem Printing

Hi

I have a problem when I try print a document from a normal user (no work station administrator) the user can't print the report, but when I try print from a administrator I can't print the report without problems.

thanks and greetings.

HI,

I am not sure about this "can't print the report without problems.". Do you mean you also meet some problems when you act as a administrator? If so , What is the exact error or problems you have when you try to print it.

I hope the above information will be helpful. If you have any issues or concerns, please let me know. It's my pleasure to be of assistance

|||

Hi,

I review and the cause of problem they were the permissions of the user over his machine, I give administrator permisions and there is no more the problem, I try found exactly the reason.

greetings.

sql

problem passing UDF scalar result to UDF table function

I'm having difficulties invoking a user defined table function,
when passing to it a parameter that is the result of another
user defined function.

My functions are defined like so:

drop function dbo.scalar_func
go
create function dbo.scalar_func()
returns int
begin
return 1
end
go

drop function dbo.table_func
go
create function dbo.table_func(@.p int)
returns table
return (select @.p as id )
go

Given the above, I can do the following:

Select from the scalar function works:
1> select dbo.scalar_func() as scalar_result
2> go
scalar_result
----
1

Selecting from the table function works, if i pass a
constant value (or a variable)

1> select id from dbo.table_func(1)
2> go
id
----
1

But, if I try to pass the table function the return value
of the scalar function in one call, it doesn't work,
producing the following error:

1> select id from dbo.table_func( dbo.scalar_func() )
2> go
Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '.'.

What am I missing here?

Thanks kindly"roger" <rogerr@.softix.com> wrote in message news:f6e08af1.0405012257.4c2472cf@.posting.google.c om...

<snip
> But, if I try to pass the table function the return value
> of the scalar function in one call, it doesn't work,
> producing the following error:
> 1> select id from dbo.table_func( dbo.scalar_func() )
> 2> go
> Msg 170, Level 15, State 1, Line 1
> Line 1: Incorrect syntax near '.'.
> What am I missing here?
> Thanks kindly

It's barking at the period in the nested call. Try running it without qualifying the function name:

1> select id from dbo.table_func( scalar_func() )

--
Paul Horan
VCI Springfield, MA|||roger (rogerr@.softix.com) writes:
> But, if I try to pass the table function the return value
> of the scalar function in one call, it doesn't work,
> producing the following error:
> 1> select id from dbo.table_func( dbo.scalar_func() )
> 2> go
> Msg 170, Level 15, State 1, Line 1
> Line 1: Incorrect syntax near '.'.
> What am I missing here?

I don't think you can pass expressions as parameters to table-valued
functions; you can only pass constants and variables.

However, I was looking around in Books Online, but I could not find
a passage which actually says so.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||"-P-" <ent_must_dieAThotmailDOTcom> wrote in message news:<UI2dnT_yvLdgPQndRVn-hQ@.adelphia.com>...
> "roger" <rogerr@.softix.com> wrote in message news:f6e08af1.0405012257.4c2472cf@.posting.google.c om...
> <snip>
> It's barking at the period in the nested call. Try running it without qualifying the function name:
> 1> select id from dbo.table_func( scalar_func() )

No, that isn't it.

You have to qualify a scalar function with the owner name.
Curiously, you don't have to qualify a table valued function
in this way.

So, this works
select * from table_function()
but this does not
select scalar_function() from table
requiring instead
select dbo.scalar_function() from table.

I can't see any particular rhyme or reason to this,
it's just the way it seems to be.|||roger (rogerr@.softix.com) writes:
> So, this works
> select * from table_function()
> but this does not
> select scalar_function() from table
> requiring instead
> select dbo.scalar_function() from table.
>
> I can't see any particular rhyme or reason to this,
> it's just the way it seems to be.

The reason is that with out the reqiurement of a two-part name there
would be no possibility to distinguish between scalar system functions
and scalar UDF. And if they look the same syntactically, they share the
same name space, which would mean that each time MS added a new system
function, they would risk to break existing code.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

problem passing UDF scalar result to UDF table function

I'm having difficulties invoking a user defined table function,
when passing to it a parameter that is the result of another
user defined function.

My functions are defined like so:

drop function dbo.scalar_func
go
create function dbo.scalar_func()
returns int
begin
return 1
end
go

drop function dbo.table_func
go
create function dbo.table_func(@.p int)
returns table
return (select @.p as id )
go

Given the above, I can do the following:

Select from the scalar function works:
1> select dbo.scalar_func() as scalar_result
2> go
scalar_result
----
1

Selecting from the table function works, if i pass a
constant value (or a variable)

1> select id from dbo.table_func(1)
2> go
id
----
1

But, if I try to pass the table function the return value
of the scalar function in one call, it doesn't work,
producing the following error:

1> select id from dbo.table_func( dbo.scalar_func() )
2> go
Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '.'.

What am I missing here?

Thanks kindly"roger" <rogerr@.softix.com> wrote in message news:f6e08af1.0405012257.4c2472cf@.posting.google.c om...

<snip
> But, if I try to pass the table function the return value
> of the scalar function in one call, it doesn't work,
> producing the following error:
> 1> select id from dbo.table_func( dbo.scalar_func() )
> 2> go
> Msg 170, Level 15, State 1, Line 1
> Line 1: Incorrect syntax near '.'.
> What am I missing here?
> Thanks kindly

It's barking at the period in the nested call. Try running it without qualifying the function name:

1> select id from dbo.table_func( scalar_func() )

--
Paul Horan
VCI Springfield, MA|||roger (rogerr@.softix.com) writes:
> But, if I try to pass the table function the return value
> of the scalar function in one call, it doesn't work,
> producing the following error:
> 1> select id from dbo.table_func( dbo.scalar_func() )
> 2> go
> Msg 170, Level 15, State 1, Line 1
> Line 1: Incorrect syntax near '.'.
> What am I missing here?

I don't think you can pass expressions as parameters to table-valued
functions; you can only pass constants and variables.

However, I was looking around in Books Online, but I could not find
a passage which actually says so.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||"-P-" <ent_must_dieAThotmailDOTcom> wrote in message news:<UI2dnT_yvLdgPQndRVn-hQ@.adelphia.com>...
> "roger" <rogerr@.softix.com> wrote in message news:f6e08af1.0405012257.4c2472cf@.posting.google.c om...
> <snip>
> It's barking at the period in the nested call. Try running it without qualifying the function name:
> 1> select id from dbo.table_func( scalar_func() )

No, that isn't it.

You have to qualify a scalar function with the owner name.
Curiously, you don't have to qualify a table valued function
in this way.

So, this works
select * from table_function()
but this does not
select scalar_function() from table
requiring instead
select dbo.scalar_function() from table.

I can't see any particular rhyme or reason to this,
it's just the way it seems to be.|||roger (rogerr@.softix.com) writes:
> So, this works
> select * from table_function()
> but this does not
> select scalar_function() from table
> requiring instead
> select dbo.scalar_function() from table.
>
> I can't see any particular rhyme or reason to this,
> it's just the way it seems to be.

The reason is that with out the reqiurement of a two-part name there
would be no possibility to distinguish between scalar system functions
and scalar UDF. And if they look the same syntactically, they share the
same name space, which would mean that each time MS added a new system
function, they would risk to break existing code.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Erland Sommarskog <sommar@.algonet.se> wrote in message news:<Xns94DEEA82AECD9Yazorman@.127.0.0.1>...
> roger (rogerr@.softix.com) writes:
> > So, this works
> > select * from table_function()
> > but this does not
> > select scalar_function() from table
> > requiring instead
> > select dbo.scalar_function() from table.
> > I can't see any particular rhyme or reason to this,
> > it's just the way it seems to be.
> The reason is that with out the reqiurement of a two-part name there
> would be no possibility to distinguish between scalar system functions
> and scalar UDF. And if they look the same syntactically, they share the
> same name space, which would mean that each time MS added a new system
> function, they would risk to break existing code.

Oracle PL/SQL uses the keyword TABLE to introduce a function
that returns a table. eg

select * from table(my_user_function(args))

I would have thought that the context in which the function
is being called would tell you whether a scalar or table result
is required, but maybe there are more scenarios than I can imagine
off hand.

Using the qualified name to distinguish the function return type,
if that is really what that is about, is truly horrid.

As is not being able to pass the result of another function as
an argument. Kind of smells like this stuff was added in a hurry.

Still, I'm thankful that it is there at all I guess.|||Erland Sommarskog <sommar@.algonet.se> wrote in message news:<Xns94DEEA82AECD9Yazorman@.127.0.0.1>...
> roger (rogerr@.softix.com) writes:
> > So, this works
> > select * from table_function()
> > but this does not
> > select scalar_function() from table
> > requiring instead
> > select dbo.scalar_function() from table.
> > I can't see any particular rhyme or reason to this,
> > it's just the way it seems to be.
> The reason is that with out the reqiurement of a two-part name there
> would be no possibility to distinguish between scalar system functions
> and scalar UDF. And if they look the same syntactically, they share the
> same name space, which would mean that each time MS added a new system
> function, they would risk to break existing code.

Oracle PL/SQL uses the keyword TABLE to introduce a function
that returns a table. eg

select * from table(my_user_function(args))

I would have thought that the context in which the function
is being called would tell you whether a scalar or table result
is required, but maybe there are more scenarios than I can imagine
off hand.

Using the qualified name to distinguish the function return type,
if that is really what that is about, is truly horrid.

As is not being able to pass the result of another function as
an argument. Kind of smells like this stuff was added in a hurry.

Still, I'm thankful that it is there at all I guess.|||roger (rogerr@.softix.com) writes:
> Oracle PL/SQL uses the keyword TABLE to introduce a function
> that returns a table. eg
> select * from table(my_user_function(args))
> I would have thought that the context in which the function
> is being called would tell you whether a scalar or table result
> is required, but maybe there are more scenarios than I can imagine
> off hand.

The issue is about distinguishing scalar functions from table functions.
The issue is about distinguishing different sorts of scalar functions,
system functions vs. user-defined ones. SQL Server have no problem
to tell whether you are using a table-valued or scalar function. Or
more correctly: there are no places in the grammar where you can use both.

The system functions had already invaded the flat name space for

SELECT fun(x)

Of course, there are a couple of more options MS could have chosen. For
instance decide that all future scalar system functions would have a
prefix.

This is actually what they have done for table-valued functions:

SELECT * FROM ::fn_helpcollations()

This was possible, since there was no table-valued system functions
prior to SQL2000.

> As is not being able to pass the result of another function as
> an argument. Kind of smells like this stuff was added in a hurry.

It is quite consistent with how you call stored procedures. You
cannot pass expressions in calls to stored procedures with the
EXEC statement. And in fact, you can invoke scalar functions with
the EXEC statement too.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.aspsql

Problem passing a parameter in URL to a report

Hi all.
I have that problem. I need to pass a parameter to a report. That parameter
is a user in a windows domain, so I have the problem that is stored in
"DOMAIN\USER" format, and I can't pass the backslash to the url.
How can I solve that?
--
Regards,
Diego F.I ask myself. I can encode \ with %5C.
I'm embarrased for that stupid question...
--
Regards,
Diego F.
"Diego F." <diegofrNO@.terra.es> escribió en el mensaje
news:OUA34HxMGHA.344@.TK2MSFTNGP11.phx.gbl...
> Hi all.
> I have that problem. I need to pass a parameter to a report. That
> parameter is a user in a windows domain, so I have the problem that is
> stored in "DOMAIN\USER" format, and I can't pass the backslash to the url.
> How can I solve that?
> --
> Regards,
> Diego F.
>
>|||Also, you might not even need to do this. Look at the global variables in
the expression builder User!UserID, it is the user running the report.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Diego F." <diegofrNO@.terra.es> wrote in message
news:OTaydMxMGHA.720@.TK2MSFTNGP14.phx.gbl...
>I ask myself. I can encode \ with %5C.
> I'm embarrased for that stupid question...
> --
> Regards,
> Diego F.
>
> "Diego F." <diegofrNO@.terra.es> escribió en el mensaje
> news:OUA34HxMGHA.344@.TK2MSFTNGP11.phx.gbl...
>> Hi all.
>> I have that problem. I need to pass a parameter to a report. That
>> parameter is a user in a windows domain, so I have the problem that is
>> stored in "DOMAIN\USER" format, and I can't pass the backslash to the
>> url.
>> How can I solve that?
>> --
>> Regards,
>> Diego F.
>>
>|||... or you can use POST instead of GET. In other words, you can pass
parameters in a form instead of passing by querystring.

Problem Oracle with \ and and

Hello for all, I'm a new user and my English isn't very good .. sorry!
I have a problem with an INSERT in Oracle, the code tha I inserd is:

INSERT INTO Schema VALUES(schema_seq.nextval,C:\Documents and Settings\Laura\Desktop\Tesi\File_OGaggi)

the error is:

Error: ORA-00911: invalid character

[Executed: 13/11/03 10.31.25 GMT ] [Execution: 0/ms]

I think that the problems are '\' and the word 'and'. Someone know what can I do? Thank you, by by,

Laura.It seems to me that You have quoted Your string with the wrong character ()

You must use ' instead.sql

Problem opening UDF

Hey,

I am using SQL Server 2005 client tools on a 2000 server. Everything works fine except ................

WHen I try to open (Modify) a user defined function, an error msg appears saying "QuotedIdentifier property not available for the function"

Anyone having same problem and found solution?

This sounds like the following bug, which is scheduled to be fixed in Service Pack 1:
http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=FDBK38845
Steve Kass
Drew University
|||Thanks a lot!

problem on login: user is inactive

hi,

i've just restored my db and when i try to login with a user (even if
the user is "sa"), an error occours.

The error is "User sa is currently inactive"

How can i solve this problem?

Thanks,
MassimozuEgg (zuegg@.hotmail.it) writes:

Quote:

Originally Posted by

i've just restored my db and when i try to login with a user (even if
the user is "sa"), an error occours.
>
The error is "User sa is currently inactive"
>
How can i solve this problem?

I can't find any such message in sysmessages. Which version of SQL Server
do you use? Exactly how do you try to connect? Through Query Analyzer
or Enterprise Manager? Through an application?

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

problem on grant permission to user

I have two kinds of functions in the database that need to grant exec permission to user appUser.
The first kind of function return ordinary datatype, let's call it funcReturnDataType here.
The second kind of function return table datatype, let's call it funcReturnTable
When I issued the folloing command to appUser, no problem.
grant exec on funcReturnDataType to appUser

However when I issued:
grant exec on funcReturnTable to appUser

I got the following error message:
Server: Msg 4606, Level 16, State 1, Line 1
Granted or revoked privilege EXECUTE is not compatible with object.

Any suggestions to resolve this problem?

Thank you!I'm having the same problem. Can anyone help.|||

Maybe this will help you:

http://msdn2.microsoft.com/en-us/library/ms188371.aspx

from the article:

....

permission
Specifies a permission that can be granted on a schema-contained object. For a list of the permissions, see the Remarks section later in this topic.

ALL
Granting ALL does not grant all possible permissions. Granting ALL is equivalent to granting all ANSI-92 permissions applicable to the specified object. The meaning of ALL varies as follows:

Scalar function permissions: EXECUTE, REFERENCES.
Table-valued function permissions: DELETE, INSERT, REFERENCES, SELECT, UPDATE.
Stored procedure permissions: EXECUTE, SYNONYM, DELETE, INSERT, SELECT, UPDATE.
Table permissions: DELETE, INSERT, REFERENCES, SELECT, UPDATE.
View permissions: DELETE, INSERT, REFERENCES, SELECT, UPDATE.

....

problem on grant permission to user

I have two kinds of functions in the database that need to grant exec permission to user appUser.
The first kind of function return ordinary datatype, let's call it funcReturnDataType here.
The second kind of function return table datatype, let's call it funcReturnTable
When I issued the folloing command to appUser, no problem.
grant exec on funcReturnDataType to appUser

However when I issued:
grant exec on funcReturnTable to appUser

I got the following error message:
Server: Msg 4606, Level 16, State 1, Line 1
Granted or revoked privilege EXECUTE is not compatible with object.

Any suggestions to resolve this problem?

Thank you!I'm having the same problem. Can anyone help.|||

Maybe this will help you:

http://msdn2.microsoft.com/en-us/library/ms188371.aspx

from the article:

....

permission
Specifies a permission that can be granted on a schema-contained object. For a list of the permissions, see the Remarks section later in this topic.

ALL
Granting ALL does not grant all possible permissions. Granting ALL is equivalent to granting all ANSI-92 permissions applicable to the specified object. The meaning of ALL varies as follows:

Scalar function permissions: EXECUTE, REFERENCES.
Table-valued function permissions: DELETE, INSERT, REFERENCES, SELECT, UPDATE.
Stored procedure permissions: EXECUTE, SYNONYM, DELETE, INSERT, SELECT, UPDATE.
Table permissions: DELETE, INSERT, REFERENCES, SELECT, UPDATE.
View permissions: DELETE, INSERT, REFERENCES, SELECT, UPDATE.

....

Problem of realization replication through WEB

Hello

There is a following mistake at replication through WEB

A security error occurred

I try to go through IE which user has specified in the master of creation of the subscriber, in a diagnostic mode

https://Servak/Replication/replisapi.dll?diag

And all works, all certificates fulfil correctly who did not collide{face} in what business? WHERE TO DIG?

The name of the server on the certificate and the one you are using in the URL do not match. Hence the error.

It could also be that the the certificate is issued to machine.domain and you are using only machine in the URL. Please use the domain name and try again.

Match up the names on both and retry. Let me know if you continue to see the error.

|||

Certification all has adjusted as it is told BOL

The circuit has turned out such

http://replication2006.narod.ru/index.html

All the same deduces this mistake A security error occurred

The certificate signed the center of certification which has requested with IIS, has established the server certificate both on a server and on the client, and even having given{allowed} unlimited rights to participants of the circuit, it is impossible. Help! In what there can be a mistake? Where to dig?

|||

Here the text of a mistake from JOB

I enter this URL the address in IE all Ок!!

Help!

Selected row details:

Log Job History (REPL-GisisTerminalClient_RED-ReplTerm-SHEIN-GisisTerminalClient_RED- 0)

Step ID 1
Server SHEIN
Job Name REPL-GisisTerminalClient_RED-ReplTerm-SHEIN-GisisTerminalClient_RED- 0
Step Name Run agent.
Duration 00:00:31

Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
-XSTEPID 1
-XSUBSYSTEM Merge
-XSERVER SHEIN

-XCMDLINE 0
-XCancelEventHandle 00000634
2006-11-14 15:14:12.578 Connecting to Subscriber 'SHEIN'
2006-11-14 15:14:12.906 Connecting to Subscriber 'SHEIN'
2006-11-14 15:14:13.062 The upload message to be sent to Publisher 'REPL' is being generated
2006-11-14 15:14:13.078 The merge process is using Exchange ID '7AA8372B-F9E6-4F43-99AB-7C49614D2528' for this web synchronization session.

2006-11-14 15:14:28.500 A security error occurred

2006-11-14 15:14:28.546 Category:NULL
Source: Merge Process
Number: -2147209329

Message: A security error occurred

2006-11-14 15:14:28.546 Category:NULL
Source: Merge Process(Web Sync Client)
Number: -2147010889
Message: The Merge Agent could not connect to the URL 'https://repl/ReplWeb/replisapi.dll' during Web synchronization. Please verify that the URL, Internet login credentials and proxy server settings are correct and tha

Web server is reachable.

|||

Sorry, I dont understand from your reply whether the name of the server on the certificate matches the one on InternetURL in the merge agent.

I see in the job that you have: 'https://repl/ReplWeb/replisapi.dll'

Is the certificate issued to machine "repl"?

Is there domain name also on the certificate? If so, please try using that in the job parameter.

Have you installed the certificate on the client?

Security error is always a result of mismatch or the client does not trust the certificate.

|||

YES, I do{make} inquiry about receptions of the certificate from a computer repl, on a computer repl it is established IISб I sign the made inquiry in the center of certification and I transfer{pass} on repl signed by the center of certification the certificate and the root certificate cent Ра of certification, I install in IE the root certificate, and the certificate signed IIS I fix{establish} for adjustment{option} of encoding SSL, On the client I transfer{pass} the root certificate of the center of certification and I install it{him} with help IE

IE - tools - internet options - content - certificates - trusted root Certification Authorities - import

For check on the client I collect{type}:

<https://shein/ReplGAI/replisapi.dll?diag>

Any problems does not arise at once the window where it is necessary to enter Login and Password is deduced, I receive page:

http://replication2006.narod.ru/TestReplisapi.html

|||Are you saying the problem is now fixed or still have the issue?|||

No. The problem is!

Load a file, I there on steps have described and have drawn a problem. Thanks big that help me!!!

http://www.replication2006.narod.ru/Problem.rar

Problem of MSDE 2000 Release A Installation

Hi,
I'm new user for MSDE 2000 Release A.
Recently i have downloading MSDE2000A.exe and extract the MSDE 2000 Release
A installation files under folder name MSDERelA.
I have read thrg the document but still failed to install a new instance of
Desktop Engine for win XP .
Command Prompt:
C:\MSDERelA\Setup>SAPWD="xxxxx"
'SAPWD' is not recognized as an internal or external command,
operable program or batch file.
I think i'm missed interpreting the installation way.
Can anybody explain wht's the meaning of the below statement? Where can i
find
Windows Authentication Mode?
......To install a default instance configured to use Windows Authentication
Mode, execute: ..........
Appreciating any command suggestion for the above.
Thanks.
Regards
Chris
Try:
setup /sapwd xxxx
or put
[Options]
sapwd=xxxx
in setup.ini
SQL Server has multiple layers of security. The first one determines who can
talk to SQL Server (regardless of any attached databases). Windows
Authentication, the new default, lets anyone with a Windows login talk to
SQL Server. The old method, called SQL Server Authentication, requires a
user name and password instead. There exists Mixed Mode Authentication,
which will allow both, for instance in case you want to allow some user over
the network to access some parts of a database, you first have to allow him
to talk to SQL Server. Windows Authentication is the recommended mode,
unless you have a reason to allow login by name and password.
I'm rather new to all this, so some things I've told you might be wrong.
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:93E4793E-ACAA-4AE1-B0DE-B0C341B76111@.microsoft.com...
> Hi,
> I'm new user for MSDE 2000 Release A.
> Recently i have downloading MSDE2000A.exe and extract the MSDE 2000
> Release
> A installation files under folder name MSDERelA.
> I have read thrg the document but still failed to install a new instance
> of
> Desktop Engine for win XP .
> Command Prompt:
> C:\MSDERelA\Setup>SAPWD="xxxxx"
> 'SAPWD' is not recognized as an internal or external command,
> operable program or batch file.
> I think i'm missed interpreting the installation way.
> Can anybody explain wht's the meaning of the below statement? Where can i
> find
> Windows Authentication Mode?
> .....To install a default instance configured to use Windows
> Authentication
> Mode, execute: ..........
> Appreciating any command suggestion for the above.
> Thanks.
> Regards
> Chris
>
>
>
>
>
|||Thanks for the explaination. I have tried again with the command-
C:\MSDERelA\Setup>Setup/ SAPWD xxxxx
C:\MSDERelA\Setup>
System Prompt msg "pls go to control panel to install &configure your sys
component". Any idea what does it mean?
Below are the files in folder MSDERelA:
-- folder Msi, folder Setup (sql window installer pcks/patches),
autorun.txt, license.txt, ReadmeMSDE2000A.htm, setup.exe, setup.rll &
sqlresld.dll
Did i wrote a command to a wrong file?
Anybody can help to suggest a new command?
Thanks
Chris
"Paul Pedersen" wrote:

> Try:
> setup /sapwd xxxx
> or put
> [Options]
> sapwd=xxxx
> in setup.ini
>
> SQL Server has multiple layers of security. The first one determines who can
> talk to SQL Server (regardless of any attached databases). Windows
> Authentication, the new default, lets anyone with a Windows login talk to
> SQL Server. The old method, called SQL Server Authentication, requires a
> user name and password instead. There exists Mixed Mode Authentication,
> which will allow both, for instance in case you want to allow some user over
> the network to access some parts of a database, you first have to allow him
> to talk to SQL Server. Windows Authentication is the recommended mode,
> unless you have a reason to allow login by name and password.
> I'm rather new to all this, so some things I've told you might be wrong.
>
>
> "Chris" <Chris@.discussions.microsoft.com> wrote in message
> news:93E4793E-ACAA-4AE1-B0DE-B0C341B76111@.microsoft.com...
>
>
|||hi,
Paul Pedersen wrote:
> Try:
> setup /sapwd xxxx
>
just a typo...
SAPWD=xxxx
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I got that message too. I was running setup from a network drive. When I ran
it from a local drive, it worked.
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:4DE8D5D0-9AC8-4837-8AA6-88DF10BBB921@.microsoft.com...[vbcol=seagreen]
> Thanks for the explaination. I have tried again with the command-
> C:\MSDERelA\Setup>Setup/ SAPWD xxxxx
> C:\MSDERelA\Setup>
> System Prompt msg "pls go to control panel to install &configure your sys
> component". Any idea what does it mean?
> Below are the files in folder MSDERelA:
> -- folder Msi, folder Setup (sql window installer pcks/patches),
> autorun.txt, license.txt, ReadmeMSDE2000A.htm, setup.exe, setup.rll &
> sqlresld.dll
> Did i wrote a command to a wrong file?
> Anybody can help to suggest a new command?
> Thanks
> Chris
> "Paul Pedersen" wrote:
|||Hi,
I ran it from a local drive. Unfortunately, the same msg still being
encounter.
C:\MSDERelA\Setup>Setup SAPWD=" xxxxx"[vbcol=seagreen]
Any hint will be sincerly appreciated..
Regards
Chris
"Paul Pedersen" wrote:

> I got that message too. I was running setup from a network drive. When I ran
> it from a local drive, it worked.
>
> "Chris" <Chris@.discussions.microsoft.com> wrote in message
> news:4DE8D5D0-9AC8-4837-8AA6-88DF10BBB921@.microsoft.com...
>
>
|||I have no other experience with that error message, but I when I ran an
internet search on the error message phrase, I got several hits. None of
them helped my situation, but maybe they will help yours.
In my case, I think it was something about Setup not finding network drives
or something like that. Does it work if you run setup with no parameters?
When I tried it, I used only
setup.exe /settings settings.ini
and kept all the switches in the ini file.
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:DED2A104-30C5-4461-9EB6-9FD44B4DDC5B@.microsoft.com...[vbcol=seagreen]
> Hi,
> I ran it from a local drive. Unfortunately, the same msg still being
> encounter.
> C:\MSDERelA\Setup>Setup SAPWD=" xxxxx"
> Any hint will be sincerly appreciated..
> Regards
> Chris
>
>
> "Paul Pedersen" wrote:
|||hi,
Paul Pedersen wrote:
> In my case, I think it was something about Setup not finding network
> drives or something like that. Does it work if you run setup with no
> parameters? When I tried it, I used only
>
are File and Printer sharing set in your network configuration?
is the Server service running in your control panel->admin tools->services ?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Mine is working OK now, thank you. It's Chris who is still having a problem.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3hoakvFi25ieU1@.individual.net...
> hi,
> Paul Pedersen wrote:
> are File and Printer sharing set in your network configuration?
> is the Server service running in your control panel->admin tools->services
> ?
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||Hi,
Appreciating your guys help on my case. I tried, althg still failed to
install it. For the case, I’ll thinking to purchase a pc of Visual.net.
have a nice day's.
Regards
Chris
=======
Regards
Chris
"Paul Pedersen" wrote:

> Mine is working OK now, thank you. It's Chris who is still having a problem.
>
> "Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
> news:3hoakvFi25ieU1@.individual.net...
>
>

Problem of connecting to SQL server

Hi

When I try to connect to SQL Database, I always got some errors following by:

Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection

My code:

SqlConnection objConn = new SqlConnection("server=DEVELOPMENT2;" +
"Database=Job_Control;" +
"User ID=sa; Password=!password1");

objConn.Open();

I don`t know what is the problem

Regards

William

Is SQL authentication enabled for that SQL Server, or is it Windows authentication only?
|||If SQL authentication *is* enabled, try, just for kicks:
SqlConnection objConn = new SqlConnection("server=DEVELOPMENT2;" +
"Database=Job_Control;" +
"uid=sa; pwd=!password1");

I'm too lazy to look and see right now if all of your parameters are valid, but I know these ones are.

problem logging onto Great Plains.

I have a user who is trying to log into Great Plains. It uses SQL Server
2000 which is on the same server. HE gets the following error message:
"Error occurred creating the pass-through SQL connection.:0"
When he clicks OK a second message comes up that says: "You're attempting to
log in from a data source using a trusted connection. Update the SQL server
settings for this data source to disable trusted connections and try logging
in again."
Could you please explain what this means and how do I do this.
Thank you
Davidi do not use Great Plains, but it sounds like you are trying to log in
using your NT/Domain account instead of the sql login.|||GreatPlains need a SQL connection. When you try to login you have a window
that indicate a server. This server is in fact an ODBC. The ODBC need to
use a SQL server authentification to be used to log in Great Plains.
"David Goldberg" wrote:

> I have a user who is trying to log into Great Plains. It uses SQL Server
> 2000 which is on the same server. HE gets the following error message:
> "Error occurred creating the pass-through SQL connection.:0"
> When he clicks OK a second message comes up that says: "You're attempting
to
> log in from a data source using a trusted connection. Update the SQL serv
er
> settings for this data source to disable trusted connections and try loggi
ng
> in again."
> Could you please explain what this means and how do I do this.
> Thank you
> David|||what string are you trying to log in with?|||No. He is using his SQL server account. I know this to be true because he
tried logging in from another machine and he could get in. It is only on hi
s
machine that this problem is occurring. I also hadanother user try to log i
n
on that machine and they could not. It appears to be machine related.|||so if he uses his same login on another machine it works, just not on
his machine? are they inside the same firewall?|||YES.|||You need to change the ODBC DSN using the ODBC control panel. Find the DSN
in the ODBC Data Source Administrator, select it and choose Configure. On
the second page you find the option "How should SQL Server verify the
authenticity of the login ID?" Make sure the SQL Server authentication
option is selected.
Mike
"David Goldberg" <DavidGoldberg@.discussions.microsoft.com> wrote in message
news:84305A48-4487-4DD2-BCAF-EA1065035D10@.microsoft.com...
>I have a user who is trying to log into Great Plains. It uses SQL Server
> 2000 which is on the same server. HE gets the following error message:
> "Error occurred creating the pass-through SQL connection.:0"
> When he clicks OK a second message comes up that says: "You're attempting
> to
> log in from a data source using a trusted connection. Update the SQL
> server
> settings for this data source to disable trusted connections and try
> logging
> in again."
> Could you please explain what this means and how do I do this.
> Thank you
> David

problem logging onto Great Plains.

I have a user who is trying to log into Great Plains. It uses SQL Server
2000 which is on the same server. HE gets the following error message:
"Error occurred creating the pass-through SQL connection.:0"
When he clicks OK a second message comes up that says: "You're attempting to
log in from a data source using a trusted connection. Update the SQL server
settings for this data source to disable trusted connections and try logging
in again."
Could you please explain what this means and how do I do this.
Thank you
David
i do not use Great Plains, but it sounds like you are trying to log in
using your NT/Domain account instead of the sql login.
|||GreatPlains need a SQL connection. When you try to login you have a window
that indicate a server. This server is in fact an ODBC. The ODBC need to
use a SQL server authentification to be used to log in Great Plains.
"David Goldberg" wrote:

> I have a user who is trying to log into Great Plains. It uses SQL Server
> 2000 which is on the same server. HE gets the following error message:
> "Error occurred creating the pass-through SQL connection.:0"
> When he clicks OK a second message comes up that says: "You're attempting to
> log in from a data source using a trusted connection. Update the SQL server
> settings for this data source to disable trusted connections and try logging
> in again."
> Could you please explain what this means and how do I do this.
> Thank you
> David
|||what string are you trying to log in with?
|||No. He is using his SQL server account. I know this to be true because he
tried logging in from another machine and he could get in. It is only on his
machine that this problem is occurring. I also hadanother user try to log in
on that machine and they could not. It appears to be machine related.
|||so if he uses his same login on another machine it works, just not on
his machine? are they inside the same firewall?
|||YES.
|||You need to change the ODBC DSN using the ODBC control panel. Find the DSN
in the ODBC Data Source Administrator, select it and choose Configure. On
the second page you find the option "How should SQL Server verify the
authenticity of the login ID?" Make sure the SQL Server authentication
option is selected.
Mike
"David Goldberg" <DavidGoldberg@.discussions.microsoft.com> wrote in message
news:84305A48-4487-4DD2-BCAF-EA1065035D10@.microsoft.com...
>I have a user who is trying to log into Great Plains. It uses SQL Server
> 2000 which is on the same server. HE gets the following error message:
> "Error occurred creating the pass-through SQL connection.:0"
> When he clicks OK a second message comes up that says: "You're attempting
> to
> log in from a data source using a trusted connection. Update the SQL
> server
> settings for this data source to disable trusted connections and try
> logging
> in again."
> Could you please explain what this means and how do I do this.
> Thank you
> David

problem logging onto Great Plains.

I have a user who is trying to log into Great Plains. It uses SQL Server
2000 which is on the same server. HE gets the following error message:
"Error occurred creating the pass-through SQL connection.:0"
When he clicks OK a second message comes up that says: "You're attempting to
log in from a data source using a trusted connection. Update the SQL server
settings for this data source to disable trusted connections and try logging
in again."
Could you please explain what this means and how do I do this.
Thank you
Davidi do not use Great Plains, but it sounds like you are trying to log in
using your NT/Domain account instead of the sql login.|||GreatPlains need a SQL connection. When you try to login you have a window
that indicate a server. This server is in fact an ODBC. The ODBC need to
use a SQL server authentification to be used to log in Great Plains.
"David Goldberg" wrote:
> I have a user who is trying to log into Great Plains. It uses SQL Server
> 2000 which is on the same server. HE gets the following error message:
> "Error occurred creating the pass-through SQL connection.:0"
> When he clicks OK a second message comes up that says: "You're attempting to
> log in from a data source using a trusted connection. Update the SQL server
> settings for this data source to disable trusted connections and try logging
> in again."
> Could you please explain what this means and how do I do this.
> Thank you
> David|||what string are you trying to log in with?|||No. He is using his SQL server account. I know this to be true because he
tried logging in from another machine and he could get in. It is only on his
machine that this problem is occurring. I also hadanother user try to log in
on that machine and they could not. It appears to be machine related.|||so if he uses his same login on another machine it works, just not on
his machine? are they inside the same firewall?|||YES.|||You need to change the ODBC DSN using the ODBC control panel. Find the DSN
in the ODBC Data Source Administrator, select it and choose Configure. On
the second page you find the option "How should SQL Server verify the
authenticity of the login ID?" Make sure the SQL Server authentication
option is selected.
Mike
"David Goldberg" <DavidGoldberg@.discussions.microsoft.com> wrote in message
news:84305A48-4487-4DD2-BCAF-EA1065035D10@.microsoft.com...
>I have a user who is trying to log into Great Plains. It uses SQL Server
> 2000 which is on the same server. HE gets the following error message:
> "Error occurred creating the pass-through SQL connection.:0"
> When he clicks OK a second message comes up that says: "You're attempting
> to
> log in from a data source using a trusted connection. Update the SQL
> server
> settings for this data source to disable trusted connections and try
> logging
> in again."
> Could you please explain what this means and how do I do this.
> Thank you
> David