Problem connecting to SQL-Server  
Author Message
BrianMSFT





PostPosted: Wed Jul 02 05:45:05 CDT 2003 Top

SQL Server >> Problem connecting to SQL-Server

Hello and thanks for reading.

This is my environment:

3 CITRIX Servers with anonymous users to login
Win2K Server with MS-SQL2K and the databases

Users logging in from the first server can connect to the sql-server, the
users logging in on the two other servers can´t. I think the reason is that
the anoymous users from the latter 2 servers have no right to connect to the
DB-Server. I think it is a problem with the windows users security, not with
the SQL-server´s. But I can´t figure out how to change this.

Any idea?

Thank you!
Bernd

SQL Server277  
 
 
Peter





PostPosted: Wed Jul 02 05:45:05 CDT 2003 Top

SQL Server >> Problem connecting to SQL-Server I could tell you how to do this but then I would have to=20
kill you...

But seriously
You will need to add some sort of security in your SQL=20
Server database.

This can be in two forms.
Either Server 2000 security or SQL Security.

So the question is this.
When your CITRIX Servers users log into the Windows server=20
do they have a particualr domain, or are they assigned any=20
sort of proxy ID for use on the Server 2000 ?

If the answer is yes then this domain or ID can be used is=20
SQL Server Secrurity.

If the answer is no then you will need to create each user=20
(or CITRIX Servers application) individually within SQL=20
Server security, assigning it User ID and passwords.

If you have any further questions then please do not=20
hesitate to ask.

Peter Nolan
MCP



>-----Original Message-----
>Hello and thanks for reading.
>
>This is my environment:
>
>3 CITRIX Servers with anonymous users to login
>Win2K Server with MS-SQL2K and the databases
>
>Users logging in from the first server can connect to the=20
sql-server, the
>users logging in on the two other servers can=B4t. I think=20
the reason is that
>the anoymous users from the latter 2 servers have no=20
right to connect to the
>DB-Server. I think it is a problem with the windows users=20
security, not with
>the SQL-server=B4s. But I can=B4t figure out how to change=20
this.
>
>Any idea?
>
>Thank you!
>Bernd
>
>
>.
>
 
 
Bernd





PostPosted: Wed Jul 02 06:05:01 CDT 2003 Top

SQL Server >> Problem connecting to SQL-Server Maybe I was not clear enough:

1) My application connects to the MS-SQL instance using SQL security.
User/Password inside SQL-Sever and does not exist outside.
2) MS-SQL Instance is located on Server DB
3) CITRIX Terminalserver is located on SERVER CT1, CT2, CT3
4) Users log on CT1 - CT3 using windows anonymous users and start the
application (wich tries to connect to the db using the SQL-user)
5) On CT1 this succeeds, CT2-CT3 this fails.

Cheers
Bernd

------------------------------------------------------

This can be in two forms.
Either Server 2000 security or SQL Security.

So the question is this.
When your CITRIX Servers users log into the Windows server
do they have a particualr domain, or are they assigned any
sort of proxy ID for use on the Server 2000 ?

If the answer is yes then this domain or ID can be used is
SQL Server Secrurity.

If the answer is no then you will need to create each user
(or CITRIX Servers application) individually within SQL
Server security, assigning it User ID and passwords.

If you have any further questions then please do not
hesitate to ask.

Peter Nolan
MCP



>-----Original Message-----
>Hello and thanks for reading.
>
>This is my environment:
>
>3 CITRIX Servers with anonymous users to login
>Win2K Server with MS-SQL2K and the databases
>
>Users logging in from the first server can connect to the
sql-server, the
>users logging in on the two other servers can´t. I think
the reason is that
>the anoymous users from the latter 2 servers have no
right to connect to the
>DB-Server. I think it is a problem with the windows users
security, not with
>the SQL-server´s. But I can´t figure out how to change
this.
>
>Any idea?
>
>Thank you!
>Bernd
>
>
>.
>