SQL server was shut down for maintenance(SQL 7 SP4) Since then some users cannot connect from their pc's to the server database using named pipes. If we reconfigure to tcp it works ok. Only sporadically affected users i.e some were ok (still on named pipes) some were not.
Error message recieved
SQL State 01000
SQL Server Error 5
SQL State 08001
SQL Server Error 2
Access is denied
Have changed affected users to TCP as a workaround but would appreciate some advice regardind permanent fix.
Error message recieved
SQL State 01000
SQL Server Error 5
SQL State 08001
SQL Server Error 2
Access is denied
Have changed affected users to TCP as a workaround but would appreciate some advice regardind permanent fix.