//The remote computer uses a completely different
username/password/domain.//
Then I don't think you can use integrated security with this and will have
to go to mixed authentication.
This happens to me when I "go on the road" with my personal laptop for work
stuff.
Because my personal laptop isn't on the domain, I have to have the dba's
create a sql authenication account for me, with lots of right of course.
..............
Basically, if you go through the "Security/Login" in Sql Server........and
hit the "Browse" button (for usernames on the domain), and you can't see
the user logged into Laptop1 (in your scenario)...then trusted isn't going
to work.
................
Security / Logins / New Login ................... Windows Authentication /
Search.
If you don't find it in there, then you can't use Integrated. If you do
find it in there, you have to ADD the user...and assign privs.
"Kevinp" <ke****@nospam.comwrote in message
news:3m********************************@4ax.com...
The server is on the domain here at our office. My laptop has not been
assigned to any domain. It's actually part of my home workgroup, but it
has been connected to the domain at the office. The computer I'm trying to
connect with is on a completely
different domain and has never been a part of our domain except for VPN.
I use the same username and password on my laptop as I do with my office
computer (obviously the domains are not the same). The remote computer
uses a completely different username/password/domain.
On Tue, 21 Oct 2008 15:35:57 -0400, "sloan" <sl***@ipass.netwrote:
>>
What domain is the Server on?
Has the laptop (machine) been added to the domain?
What login are you using on the laptop computer?
.......(and repeat the question for the "other remote")
Has the (other remote computer)(machine) been added to the domain?
What login are you using on the (other remote computer) computer?
"Kevinp" <ke****@nospam.comwrote in message
news:s7********************************@4ax.com. ..
>>I'm trying to get my program to connect to a SQL Server 2005 database
over
the internet.
The remote computer is on another network and it's connected to our
network through Windows VPN. I'm running Windows Small Business Server
2005 on our server with SQL Server 2005 and ISA Server 2004.
I can do this at home with my laptop using the following connection
string:
strCnn = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security
Info=False;" & "User ID=" & _
sysUser & ";Initial Catalog=" & sysDatabase & ";Data Source=" &
sysServer & ";"
db.CursorLocation = ADODB.CursorLocationEnum.adUseClient
db.Open(strCnn)
I'm using the local IP address of the server as 'sysServer' -
192.168.1.2
But my laptop has Visual Studio 2008 and SQL Server Express on it.
When I try to do it from this other remote computer, I get:
Login failed for user ''. The user is not associated with a trusted SQL
Server connection.
SQL Server is set on Windows authentication and I'd rather not have to
change that. I don't want the users to have to use their Windows
password
to get into my program.
What do I need to change to get this to work?