Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JPD71
Starting Member
3 Posts |
 Posted - 2008-09-21 : 04:33:52
|
| Hi all,I have a big problem....We installed a new server at a client's office.He had a Windows 2003 SBS server running his local SQL DB but he wanted the users to be authenticated thru a Linux server.We sad all the users exactly like the usernames and permissions on the Linux server as on the W2k3 server .All the apps work correctly but he has 3 core applications that use the SQL DB and users cannot connect to it.Is there a possibility to have users that connect thru the Linux server and make connection to the W2K3 server connect to the SQL DB so that then can work with the DB?It is not possible for us to convert the DB to mysql for example, he want to keep using the SQL DB.Please help because the bussines of this client is almost stopped.ThnxJPD |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-21 : 05:01:55
|
| have a look at below link and see if it helpshttp://msdn.microsoft.com/en-us/library/ms175483.aspx |
 |
|
|
JPD71
Starting Member
3 Posts |
Posted - 2008-09-21 : 05:06:41
|
| It seems that this topic is for using SQL over the internet.We are facing here a local lan and there is no connectivity to the SQL DB thru the internet |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-21 : 05:12:58
|
quote:
Originally posted by JPD71
It seems that this topic is for using SQL over the internet.We are facing here a local lan and there is no connectivity to the SQL DB thru the internet
i thought question was to connect to SQL DB from linux server. is it in same LAN? |
|
|
|
JPD71
Starting Member
3 Posts |
Posted - 2008-09-21 : 05:19:59
|
| Yes it is on the same LAN.The major problem is ( i think) that the W2k3 server was the domaincontroller and had X as its domain name.Now we setup the Linux server as server who authenticates the users and it has domainname Z I have allready tried to connect thru linux using as credentials X\username on domain X but that does not help.We know that the DB is running and is ok because we haven't migrated 1 workstation and that one connects directly to the W2K3 server on domain X.As soon as we enroll a workstation on to the Z domain problems start. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-21 : 07:11:22
|
| what about this?http://www-01.ibm.com/support/docview.wss?uid=swg21133904 |
|
|
|
|
|
|
Connectivity issue