In Windows XP there was a feature for managing network passwords which
allowed machines that were not members of the domain to use domain
credentials to access domain resources, which I have used to connect to SQL
Server(s) since I am a consultant that has many clients, I do not join my
machine to any domain. However, when I tried to use this same feature in
Windows Vista (Ultimate) it only allowed me to connect to file share
resources, and SQL Server Analysis Services, but it did not let me connect to
SQL Server Database Engine service. I keep getting "Login failed for user
(null)..." The error code was 18452. Please let me know if this is a bug in
Vista. I need to be able to connect to SQL Server using Windows
Authentication from a computer that does not exist on a domain and the SQL
Server does.

If your credentials are not being passed to the SQL server, you will receive
error code was 18452. Which feature do you use to pass credentials to access
domain resources?
--
Bob Lin, MS-MVP, MCSE & CNE
Networking, Internet, Routing, VPN Troubleshooting on
http://www.ChicagoTech.net
How to Setup Windows, Network, VPN & Remote Access on
http://www.HowToNetworking.com


"pietrzbm" wrote in message
...
In Windows XP there was a feature for managing network passwords which
allowed machines that were not members of the domain to use domain
credentials to access domain resources, which I have used to connect to
SQL
Server(s) since I am a consultant that has many clients, I do not join my
machine to any domain. However, when I tried to use this same feature in
Windows Vista (Ultimate) it only allowed me to connect to file share
resources, and SQL Server Analysis Services, but it did not let me connect
to
SQL Server Database Engine service. I keep getting "Login failed for user
(null)..." The error code was 18452. Please let me know if this is a bug
in
Vista. I need to be able to connect to SQL Server using Windows
Authentication from a computer that does not exist on a domain and the SQL
Server does.

I was trying to use the "Manage Network Passwords" feature to pass the domain
credentials. This used to work fine in Windows XP. All you had to do was go
into "Manage Network Passwords" then enter the following:

Server: Domain Server (ServerA)
UserName: Domain\userName
Password: Password

Then when using Windows Authentication in SQL Server Management Studio, it
would use these credentials to gain access to that server without actually
having to have the client machine be a member of the domain. I have seen
various posts about this issue, and it appears that it may be in how Vista
handles access to the token. Is there some setting(s) that need to be
changed? Basically, when I try to do this in Vista it only allows access to
file shares and does not seem to allow client applications to use the
credentials to access domain resources like XP did.
"Robert L. (MS-MVP)" wrote:

If your credentials are not being passed to the SQL server, you will receive
error code was 18452. Which feature do you use to pass credentials to access
domain resources?
--
Bob Lin, MS-MVP, MCSE & CNE
Networking, Internet, Routing, VPN Troubleshooting on
http://www.ChicagoTech.net
How to Setup Windows, Network, VPN & Remote Access on
http://www.HowToNetworking.com


"pietrzbm" wrote in message
...
In Windows XP there was a feature for managing network passwords which
allowed machines that were not members of the domain to use domain
credentials to access domain resources, which I have used to connect to
SQL
Server(s) since I am a consultant that has many clients, I do not join my
machine to any domain. However, when I tried to use this same feature in
Windows Vista (Ultimate) it only allowed me to connect to file share
resources, and SQL Server Analysis Services, but it did not let me connect
to
SQL Server Database Engine service. I keep getting "Login failed for user
(null)..." The error code was 18452. Please let me know if this is a bug
in
Vista. I need to be able to connect to SQL Server using Windows
Authentication from a computer that does not exist on a domain and the SQL
Server does.

Is the Vista the member of a domain or standalone computer? Try this
command: net use \\sqlservername /u:domainname/username. Does that work?
Please post back with the result.

--
Bob Lin, MS-MVP, MCSE & CNE
Networking, Internet, Routing, VPN Troubleshooting on
http://www.ChicagoTech.net
How to Setup Windows, Network, VPN & Remote Access on
http://www.HowToNetworking.com


"pietrzbm" wrote in message
...
I was trying to use the "Manage Network Passwords" feature to pass the
domain
credentials. This used to work fine in Windows XP. All you had to do was
go
into "Manage Network Passwords" then enter the following:

Server: Domain Server (ServerA)
UserName: Domain\userName
Password: Password

Then when using Windows Authentication in SQL Server Management Studio, it
would use these credentials to gain access to that server without actually
having to have the client machine be a member of the domain. I have seen
various posts about this issue, and it appears that it may be in how Vista
handles access to the token. Is there some setting(s) that need to be
changed? Basically, when I try to do this in Vista it only allows access
to
file shares and does not seem to allow client applications to use the
credentials to access domain resources like XP did.
"Robert L. (MS-MVP)" wrote:

If your credentials are not being passed to the SQL server, you will
receive
error code was 18452. Which feature do you use to pass credentials to
access
domain resources?
--
Bob Lin, MS-MVP, MCSE & CNE
Networking, Internet, Routing, VPN Troubleshooting on
http://www.ChicagoTech.net
How to Setup Windows, Network, VPN & Remote Access on
http://www.HowToNetworking.com


"pietrzbm" wrote in message
...
In Windows XP there was a feature for managing network passwords which
allowed machines that were not members of the domain to use domain
credentials to access domain resources, which I have used to connect to
SQL
Server(s) since I am a consultant that has many clients, I do not join
my
machine to any domain. However, when I tried to use this same feature
in
Windows Vista (Ultimate) it only allowed me to connect to file share
resources, and SQL Server Analysis Services, but it did not let me
connect
to
SQL Server Database Engine service. I keep getting "Login failed for
user
(null)..." The error code was 18452. Please let me know if this is a
bug
in
Vista. I need to be able to connect to SQL Server using Windows
Authentication from a computer that does not exist on a domain and the
SQL
Server does.

The result of the command was:

"The command completed successfully."

I want to thank you for taking the time to help with this issue. I will try
and continue to explain the detailed problem as this is an important issue
for my group as we do a lot of work with SQL Server and we don't join our
machines to every domain we work in, so this feature that was working in XP
is very important.

No, the client machine is not a member of the domain. Basically, one of my
questions is how has the functionality changed in the use of "Managed
Passwords" between XP and Vista. If I set a managed password up in Vista it
does allow my non-domain connected machined to access shares, but does not
allow mgmt studio to access the database. I can connect to the domain server
file systems fine. Also, the Managed Password does seem to work with SQL
Analysis Services. It appears to be a problem when trying to connect to the
database engine. By the way, the SQL Server is set for mixed mode
authentication and SQL logins work. I just can't get the mgmt studio to use
integrated security even though I have set up a managed password just like I
did in XP. This only doesn't work with Vista.

"Robert L. (MS-MVP)" wrote:

Is the Vista the member of a domain or standalone computer? Try this
command: net use \\sqlservername /u:domainname/username. Does that work?
Please post back with the result.

--
Bob Lin, MS-MVP, MCSE & CNE
Networking, Internet, Routing, VPN Troubleshooting on
http://www.ChicagoTech.net
How to Setup Windows, Network, VPN & Remote Access on
http://www.HowToNetworking.com


"pietrzbm" wrote in message
...
I was trying to use the "Manage Network Passwords" feature to pass the
domain
credentials. This used to work fine in Windows XP. All you had to do was
go
into "Manage Network Passwords" then enter the following:

Server: Domain Server (ServerA)
UserName: Domain\userName
Password: Password

Then when using Windows Authentication in SQL Server Management Studio, it
would use these credentials to gain access to that server without actually
having to have the client machine be a member of the domain. I have seen
various posts about this issue, and it appears that it may be in how Vista
handles access to the token. Is there some setting(s) that need to be
changed? Basically, when I try to do this in Vista it only allows access
to
file shares and does not seem to allow client applications to use the
credentials to access domain resources like XP did.
"Robert L. (MS-MVP)" wrote:

If your credentials are not being passed to the SQL server, you will
receive
error code was 18452. Which feature do you use to pass credentials to
access
domain resources?
--
Bob Lin, MS-MVP, MCSE & CNE
Networking, Internet, Routing, VPN Troubleshooting on
http://www.ChicagoTech.net
How to Setup Windows, Network, VPN & Remote Access on
http://www.HowToNetworking.com


"pietrzbm" wrote in message
...
In Windows XP there was a feature for managing network passwords which
allowed machines that were not members of the domain to use domain
credentials to access domain resources, which I have used to connect to
SQL
Server(s) since I am a consultant that has many clients, I do not join
my
machine to any domain. However, when I tried to use this same feature
in
Windows Vista (Ultimate) it only allowed me to connect to file share
resources, and SQL Server Analysis Services, but it did not let me
connect
to
SQL Server Database Engine service. I keep getting "Login failed for
user
(null)..." The error code was 18452. Please let me know if this is a
bug
in
Vista. I need to be able to connect to SQL Server using Windows
Authentication from a computer that does not exist on a domain and the
SQL
Server does.

Standalone Vista doesn't work as XP standalone computer in domain network.
To test it, you may want to disable UAC (we don't recommend it, but just for
a test).

How to disable UAC in Vista
http://www.howtonetworking.com/vista/vistasecurity.htm

--
Bob Lin, MS-MVP, MCSE & CNE
Networking, Internet, Routing, VPN Troubleshooting on
http://www.ChicagoTech.net
How to Setup Windows, Network, VPN & Remote Access on
http://www.HowToNetworking.com


"pietrzbm" wrote in message
...
The result of the command was:

"The command completed successfully."

I want to thank you for taking the time to help with this issue. I will
try
and continue to explain the detailed problem as this is an important issue
for my group as we do a lot of work with SQL Server and we don't join our
machines to every domain we work in, so this feature that was working in
XP
is very important.

No, the client machine is not a member of the domain. Basically, one of
my
questions is how has the functionality changed in the use of "Managed
Passwords" between XP and Vista. If I set a managed password up in Vista
it
does allow my non-domain connected machined to access shares, but does not
allow mgmt studio to access the database. I can connect to the domain
server
file systems fine. Also, the Managed Password does seem to work with SQL
Analysis Services. It appears to be a problem when trying to connect to
the
database engine. By the way, the SQL Server is set for mixed mode
authentication and SQL logins work. I just can't get the mgmt studio to
use
integrated security even though I have set up a managed password just like
I
did in XP. This only doesn't work with Vista.

"Robert L. (MS-MVP)" wrote:

Is the Vista the member of a domain or standalone computer? Try this
command: net use \\sqlservername /u:domainname/username. Does that work?
Please post back with the result.

--
Bob Lin, MS-MVP, MCSE & CNE
Networking, Internet, Routing, VPN Troubleshooting on
http://www.ChicagoTech.net
How to Setup Windows, Network, VPN & Remote Access on
http://www.HowToNetworking.com


"pietrzbm" wrote in message
...
I was trying to use the "Manage Network Passwords" feature to pass the
domain
credentials. This used to work fine in Windows XP. All you had to do
was
go
into "Manage Network Passwords" then enter the following:

Server: Domain Server (ServerA)
UserName: Domain\userName
Password: Password

Then when using Windows Authentication in SQL Server Management Studio,
it
would use these credentials to gain access to that server without
actually
having to have the client machine be a member of the domain. I have
seen
various posts about this issue, and it appears that it may be in how
Vista
handles access to the token. Is there some setting(s) that need to be
changed? Basically, when I try to do this in Vista it only allows
access
to
file shares and does not seem to allow client applications to use the
credentials to access domain resources like XP did.
"Robert L. (MS-MVP)" wrote:

If your credentials are not being passed to the SQL server, you will
receive
error code was 18452. Which feature do you use to pass credentials to
access
domain resources?
--
Bob Lin, MS-MVP, MCSE & CNE
Networking, Internet, Routing, VPN Troubleshooting on
http://www.ChicagoTech.net
How to Setup Windows, Network, VPN & Remote Access on
http://www.HowToNetworking.com


"pietrzbm" wrote in message
...
In Windows XP there was a feature for managing network passwords
which
allowed machines that were not members of the domain to use domain
credentials to access domain resources, which I have used to connect
to
SQL
Server(s) since I am a consultant that has many clients, I do not
join
my
machine to any domain. However, when I tried to use this same
feature
in
Windows Vista (Ultimate) it only allowed me to connect to file share
resources, and SQL Server Analysis Services, but it did not let me
connect
to
SQL Server Database Engine service. I keep getting "Login failed
for
user
(null)..." The error code was 18452. Please let me know if this is
a
bug
in
Vista. I need to be able to connect to SQL Server using Windows
Authentication from a computer that does not exist on a domain and
the
SQL
Server does.