Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Logon Failure: The user has not been granted the requested logon type to the computer

Avatar of street07
street07 asked on
Windows Server 2008
5 Comments1 Solution1559 ViewsLast Modified:
Hey everyone, I am stumped!  Thanks for taking a look at my issue...

I have a Server 2003 DC which has been a running a 50 client (windowsXP) network for about 3 years.  
All the network shares are on this 2003 server and network communication is no problem.

Recently I have added two Server 2008 boxes.  One to act as SQL box housing a new software
package we are going to run.  The Other to run Terminal Services and eventually be the PDC, but for now all it is running
is the TS for remote locations.  Both the Servers are identical hardware.  After installing and joining the
TS server to the network everything is fine.  I can see it from the network and can access this server from the XP clients on the network.
The SQL server has joined the network and the only roll installed is file services.  However no domain users
except for the domain administrator can access the SQL server.  I cannot access it by \\servername, I can see it in network places but again cannot access it.  
Everyone has access to the TS server with no problem.  The everyone group is part of the Domain GPO for access from the network.  The windows firewall is off, filesharing is on, network discovery is on.
When trying to connect to the SQL server from a domain user account I get the screenshot error message that is attached.

1st time poster, sorry if I left info out.  thanks in advance!
network.JPG
ASKER CERTIFIED SOLUTION
Avatar of street07
street07

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 5 Comments.
See Answers