This post may contain too much information, but more is better than not enough, and the past week has seen some 'fun times' trying to get this going...
We run a network with 2 domains, A and B, B trusts A for login privleges, etc. A is a windows 2003 domain and B is a windows NT domain. Domain B is on a different network from Domain A. routing from one network to the other works, Everything worked fine.
SQL Server is housed on a Windows 2000 server machine, and hosts several network shares.
Users had used a windows 2000 terminal Server (on domain A) to open an access database, linked to the SQL server, and accessable from a network share on the SQL server. This server died.
We re-used an under-utilized windows 2003 Server (TS enabled) joined to domain B. Configured the ODBC connection as per configuration on previous machine. (thankfully saved) Users would log in onto domain A (trusted) as this was the previous setup.
I recieve these errors:
Initally I thought that the servers themselves were not authenticating to the domain(s) properly. The IP addressing scheme for the network where domain B's Primary server was located has been recently changed, and for a while users from either domain could not log on to either the 'new' machine or the machine housing the SQL server(admins could). That was corrected quickly and easily, but the problem persists. Administrative accounts for either domain and local admin accounts(on SQL machine) are able to access the database without issue. User accounts cannot. This is true both on the local machine, and from the 'new' TS computer.
To me, It almost seems line the SQL server itself is not authenticating to the domain(s) properly. I tried adding a new group to the SQL logins referencing an existing group for settings and using a newly created domain group and recieved this error:
I have good techincal knowledge, but very little in the area of SQL server any help or hints would be appreciated.
We run a network with 2 domains, A and B, B trusts A for login privleges, etc. A is a windows 2003 domain and B is a windows NT domain. Domain B is on a different network from Domain A. routing from one network to the other works, Everything worked fine.
SQL Server is housed on a Windows 2000 server machine, and hosts several network shares.
Users had used a windows 2000 terminal Server (on domain A) to open an access database, linked to the SQL server, and accessable from a network share on the SQL server. This server died.
We re-used an under-utilized windows 2003 Server (TS enabled) joined to domain B. Configured the ODBC connection as per configuration on previous machine. (thankfully saved) Users would log in onto domain A (trusted) as this was the previous setup.
I recieve these errors:
connection failed
SQLState: 28000
SQL Server Error: 18452
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)', Reason: Not associated with a trusted SQL Server Connection
connection failed
SQLState: 28000
SQL Server Error: 18452
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'domain\User', Reason: Not associated with a trusted SQL Server Connection
Initally I thought that the servers themselves were not authenticating to the domain(s) properly. The IP addressing scheme for the network where domain B's Primary server was located has been recently changed, and for a while users from either domain could not log on to either the 'new' machine or the machine housing the SQL server(admins could). That was corrected quickly and easily, but the problem persists. Administrative accounts for either domain and local admin accounts(on SQL machine) are able to access the database without issue. User accounts cannot. This is true both on the local machine, and from the 'new' TS computer.
To me, It almost seems line the SQL server itself is not authenticating to the domain(s) properly. I tried adding a new group to the SQL logins referencing an existing group for settings and using a newly created domain group and recieved this error:
I receve the same error whether I try to add a group from domain A or domain B.error 14501: Windows NT user or group 'domain\groupname' not found.
check the name again
I have good techincal knowledge, but very little in the area of SQL server any help or hints would be appreciated.