quantum951
Programmer
Hyello,
Does anyone know of a way to establish a connection to a SQL 2000 server in the following scenario:
- logged on as the local administrator on a stand-alone windows 2000 computer that doesn't have a machine account in the domain the SQL server is a member of
- can connect to shares on the SQL server using a domain account I've been assigned for the duration of the project (i.e. net use x: \\server\share /user:domain\user)
- the domain account has been assigned all necessary permissions on the SQL server
- need to connect to the SQL server using a trusted connection (nt authentication)
I've thought about adding the machine to the domain and logging on with the domain account, however that would create a new user profile.
Having to set up shop in a new profile isn't a big deal, however there's a possiblity that this effort will have to be replicated numerous times in the future, so I would like to avoid going that route.
Thanks!
Does anyone know of a way to establish a connection to a SQL 2000 server in the following scenario:
- logged on as the local administrator on a stand-alone windows 2000 computer that doesn't have a machine account in the domain the SQL server is a member of
- can connect to shares on the SQL server using a domain account I've been assigned for the duration of the project (i.e. net use x: \\server\share /user:domain\user)
- the domain account has been assigned all necessary permissions on the SQL server
- need to connect to the SQL server using a trusted connection (nt authentication)
I've thought about adding the machine to the domain and logging on with the domain account, however that would create a new user profile.
Having to set up shop in a new profile isn't a big deal, however there's a possiblity that this effort will have to be replicated numerous times in the future, so I would like to avoid going that route.
Thanks!
