sqLServer2000 desktop user access -- sql server new users

Sue Hoegemeier
7/6/2006 9:23:55 AM

I would guess it's a permissions issue. By default, members
of the local administrators windows group would have a login
and be members of the sysadmin server role in SQL Server.
When logged in as an administrator, add your windows login
as a login in SQL Server and add this login to the sysadmin
role in SQL Server.

-Sue

On Thu, 6 Jul 2006 10:19:34 -0400, "Steven Bragg"
[quoted text, click to view]

Steven Bragg
7/6/2006 10:19:34 AM

I can access all the tools of SQLServer2000 desktop when I'm logged on to my
pc with administrator privileges, but if I'm logged on with power user and
debugger user privileges the client software refuses to connect me. I
prefer to use my pc without administrator privileges. Does anyone know what
settings I need to modify? Thanks ;)

Steven Bragg
7/6/2006 4:11:48 PM

Thanks Sue! I granted permissions using the query analyzer and it worked
great!

-- Steve

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server new users

sql server new users : sqLServer2000 desktop user access