Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-06 : 21:17:49
|
Pablo Fernandez writes "
I have a problem trying to execute a remote stored procedure in a SQL Server 2000 or 7.0 with integrated security from a SQL Server 6.5 with mixed security or integrated security.
The error message is 'Login failed for user xxxx'. I don't know if it is possible to use remote servers with integrated security.
The only situation in which I could execute stored procedures between two servers with integrated security was when the SQL Servers were in the same machine (SQL 2000 instance and a SQL 7.0). In this case when I execute the query
SQL2000.master..sp_sqlexec 'SELECT SUSER_SNAME()'
the result was the NT user I was logged in.
When I used a remote server client (ie: the server that submits the remote query) that wasn't in the same machine than the remote server server the error message was:
Login failed for user xxxx -> where xxxx was the account
name (with no domain) under
the SQL Server runs.
Thanks for your time and knowledge.
Pablo Fernandez
pfmarino@caixagalicia.es
Client: NT 4.0 SP6 and Windows 2000
Server: Windows 2000
" |
|
|
|
|
|
Problem with remote servers and integrated security