Prev: Also the Edit in Excel button has stopped working
Next: Add Windows 7 drivers to the existing printer
From: George on 24 Mar 2010 08:21
Hello All,

Here is my problem. I have a Windows SBS 2003 Server with around 7 XP
Clients. Since i have a SQL2000 database on the server, i installed a SQL7
database on one of the client machine which runs on XP. Now when my program
access the same from database from the same machine it connects

Now i tried to access the same database from a different XP machine , i am
getting time out. Now if i give the user Administrative rights on my SBS
server, i am able to connect to the machine.

The problem seems with some security or rights issuse. How can my users
connect to the database withot having administrative rights
From: Paul Shapiro on 24 Mar 2010 08:43
"George" <George(a)discussions.microsoft.com> wrote in message
news:51C90876-6357-4FE9-9B48-0CB3E47E4B4D(a)microsoft.com...
> Here is my problem. I have a Windows SBS 2003 Server with around 7 XP
> Clients. Since i have a SQL2000 database on the server, i installed a SQL7
> database on one of the client machine which runs on XP. Now when my
> program
> access the same from database from the same machine it connects
>
> Now i tried to access the same database from a different XP machine , i am
> getting time out. Now if i give the user Administrative rights on my SBS
> server, i am able to connect to the machine.
>
> The problem seems with some security or rights issuse. How can my users
> connect to the database withot having administrative rights

I'm not sure I understand exactly what you're trying to do, but it sounds
like you need to give your users access to the SQL Server. You need to
either create SQL logins for each user or setup a Windows security group,
make your users members of that group, and create a sql login for the group.
Then create a user in the db for each login. See sql books online for more
details. In older SQL Server versions, administrators were automatically
added to the SysAdmin role on the SQL Server, giving them complete
permissions to do anything. This is not good from a security standpoint, but
that's probably why it works now when the user has admin rights.

 | 
Pages: 1
Prev: Also the Edit in Excel button has stopped working
Next: Add Windows 7 drivers to the existing printer