Authorisation for SQL 2005

Hi everyone,
I have a problem, and the problem is this.
I have a development server with an ISP with Windows Server 2003 and
SQL 2005, this server is not part of our companies domain.
I have multiple laptops, of which are apart of our companies domain.
I would like to connect to SQL 2005 using Windows Authentication only,
is this possible'
I have tried adding a user to SQL 2005 on the server, consisting of
DOMAIN\user, but that doesnt work.
I have looked on the net and i know that SQL doesnt except remote
connections by default, and i have changed this option, but i still
cannot connect to it.
Has anyone else had this problem and how did you get round it? I know
i could just accept SQL authentication as well, but our old server kept
getting hit by viruses attempting to connect via sql logins, so this is
really my last option.Hi
If there are no trusts between the domains I don't think this will be
possible. It is better to use a VPN if you are worried about security. You
may want to look at the replication options
http://msdn2.microsoft.com/en-us/library/ms151319.aspx
John
"Nemisis" wrote:

> Hi everyone,
> I have a problem, and the problem is this.
> I have a development server with an ISP with Windows Server 2003 and
> SQL 2005, this server is not part of our companies domain.
> I have multiple laptops, of which are apart of our companies domain.
> I would like to connect to SQL 2005 using Windows Authentication only,
> is this possible'
> I have tried adding a user to SQL 2005 on the server, consisting of
> DOMAIN\user, but that doesnt work.
> I have looked on the net and i know that SQL doesnt except remote
> connections by default, and i have changed this option, but i still
> cannot connect to it.
> Has anyone else had this problem and how did you get round it? I know
> i could just accept SQL authentication as well, but our old server kept
> getting hit by viruses attempting to connect via sql logins, so this is
> really my last option.
>|||Nemisis wrote:
> Hi everyone,
> I have a problem, and the problem is this.
> I have a development server with an ISP with Windows Server 2003 and
> SQL 2005, this server is not part of our companies domain.
> I have multiple laptops, of which are apart of our companies domain.
> I would like to connect to SQL 2005 using Windows Authentication only,
> is this possible'
> I have tried adding a user to SQL 2005 on the server, consisting of
> DOMAIN\user, but that doesnt work.
> I have looked on the net and i know that SQL doesnt except remote
> connections by default, and i have changed this option, but i still
> cannot connect to it.
> Has anyone else had this problem and how did you get round it? I know
> i could just accept SQL authentication as well, but our old server kept
> getting hit by viruses attempting to connect via sql logins, so this is
> really my last option.
>
You can't use Windows Authentication in this way. Using SQL
authentication in no way makes you vulnerable to viruses. Make sure the
"sa" user has a STRONG password, share that password with nobody, you
should be perfectly safe.
Tracy McKibben
MCDBA
http://www.realsqlguy.com