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 |
|
asafg
Starting Member
39 Posts |
 Posted - 2009-01-22 : 09:39:12
|
| HelloI've built a tiny testing "farm"1. SQLServer (windows server 2003) -- this machine is the domain2. Sharepoint - Server (windows server 2003)3. Development server - (windows xp)When I try to see the DB on the SQLServer using the sharepoint server - no problem - use windows logon and -yepeee.When I try to log on to the same pc with the same login using windows XP - it does not work...To confuse me more it works with the "sa" user and passwordit does not work with the administrator user.I found a place with rights grant deny and.... I try to mark all the administrator as in the SA - clicked ok and all the checkbox are empty again...As you probably understand I don't understand much... help me please... hind ideas anything will be nice but please keep it stupid proof :) Almost forgot among all the error message I've seen yesterday ... the one that almost made some sense to me was about remote access and timeout... |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-22 : 11:44:49
|
| Did you remove Built-in Administrators for SQL Server? Local Administrations donot have full rights to SQL Server. |
 |
|
|
|
|
|
Remote access permissions