Ok, really Dumb question but still new

I've got a user that needs to be able to get into the attach to the
SQL database server (SQL 2000) from desktop engines I guess it would
be to manage some databases. He was a user that used to have domain
admin priveledges but I took those away so he wouldn't screw other
things up. How can I give him permissions to get what he needs
without giving him Domain Admin permissions? Is there a SQL admin
group or an area within SQL Enterprise manager to delegate SQL Admin
rights?
Thanks.
On Jan 31, 11:20 am, "newsqlman" <ndit...@.yahoo.com> wrote:
> I've got a user that needs to be able to get into the attach to the
> SQL database server (SQL 2000) from desktop engines I guess it would
> be to manage some databases. He was a user that used to have domain
> admin priveledges but I took those away so he wouldn't screw other
> things up. How can I give him permissions to get what he needs
> without giving him Domain Admin permissions? Is there a SQL admin
> group or an area within SQL Enterprise manager to delegate SQL Admin
> rights?
> Thanks.
If you go to Security/logins in Enterprise manager you can add a login
and assign the system administrator server role. This will give them
full admin privileges on the sql server instance.
|||So under Enterprise Manager, the sql group and local area which lists
all the folders.
There is a security folder and underneath it there is a logins
option. I see you can add logins there.
So what I need to do if I understand correctly is add the login from
the domain list domain\user and then
under the properties of that login I go to the server roles tab and
check server administrators box. Is that all
I need to do or do I need to specify all the databases under the
database access tab as well?
Thanks for the help.
|||If you're a server administrator, you're "god" on all of the databases, yes.
newsqlman wrote:
> So under Enterprise Manager, the sql group and local area which lists
> all the folders.
> There is a security folder and underneath it there is a logins
> option. I see you can add logins there.
> So what I need to do if I understand correctly is add the login from
> the domain list domain\user and then
> under the properties of that login I go to the server roles tab and
> check server administrators box. Is that all
> I need to do or do I need to specify all the databases under the
> database access tab as well?
> Thanks for the help.
>
-Dave Markle
http://www.markleconsulting.com/blog
sql

Ok, really Dumb question but still new

I've got a user that needs to be able to get into the attach to the
SQL database server (SQL 2000) from desktop engines I guess it would
be to manage some databases. He was a user that used to have domain
admin priveledges but I took those away so he wouldn't screw other
things up. How can I give him permissions to get what he needs
without giving him Domain Admin permissions? Is there a SQL admin
group or an area within SQL Enterprise manager to delegate SQL Admin
rights?
Thanks.On Jan 31, 11:20 am, "newsqlman" <ndit...@.yahoo.com> wrote:
> I've got a user that needs to be able to get into the attach to the
> SQL database server (SQL 2000) from desktop engines I guess it would
> be to manage some databases. He was a user that used to have domain
> admin priveledges but I took those away so he wouldn't screw other
> things up. How can I give him permissions to get what he needs
> without giving him Domain Admin permissions? Is there a SQL admin
> group or an area within SQL Enterprise manager to delegate SQL Admin
> rights?
> Thanks.
If you go to Security/logins in Enterprise manager you can add a login
and assign the system administrator server role. This will give them
full admin privileges on the sql server instance.|||So under Enterprise Manager, the sql group and local area which lists
all the folders.
There is a security folder and underneath it there is a logins
option. I see you can add logins there.
So what I need to do if I understand correctly is add the login from
the domain list domain\user and then
under the properties of that login I go to the server roles tab and
check server administrators box. Is that all
I need to do or do I need to specify all the databases under the
database access tab as well?
Thanks for the help.|||If you're a server administrator, you're "god" on all of the databases, yes.
newsqlman wrote:
> So under Enterprise Manager, the sql group and local area which lists
> all the folders.
> There is a security folder and underneath it there is a logins
> option. I see you can add logins there.
> So what I need to do if I understand correctly is add the login from
> the domain list domain\user and then
> under the properties of that login I go to the server roles tab and
> check server administrators box. Is that all
> I need to do or do I need to specify all the databases under the
> database access tab as well?
> Thanks for the help.
>
-Dave Markle
http://www.markleconsulting.com/blog

Ok, really Dumb question but still new

I've got a user that needs to be able to get into the attach to the
SQL database server (SQL 2000) from desktop engines I guess it would
be to manage some databases. He was a user that used to have domain
admin priveledges but I took those away so he wouldn't screw other
things up. How can I give him permissions to get what he needs
without giving him Domain Admin permissions? Is there a SQL admin
group or an area within SQL Enterprise manager to delegate SQL Admin
rights?
Thanks.On Jan 31, 11:20 am, "newsqlman" <ndit...@.yahoo.com> wrote:
> I've got a user that needs to be able to get into the attach to the
> SQL database server (SQL 2000) from desktop engines I guess it would
> be to manage some databases. He was a user that used to have domain
> admin priveledges but I took those away so he wouldn't screw other
> things up. How can I give him permissions to get what he needs
> without giving him Domain Admin permissions? Is there a SQL admin
> group or an area within SQL Enterprise manager to delegate SQL Admin
> rights?
> Thanks.
If you go to Security/logins in Enterprise manager you can add a login
and assign the system administrator server role. This will give them
full admin privileges on the sql server instance.|||So under Enterprise Manager, the sql group and local area which lists
all the folders.
There is a security folder and underneath it there is a logins
option. I see you can add logins there.
So what I need to do if I understand correctly is add the login from
the domain list domain\user and then
under the properties of that login I go to the server roles tab and
check server administrators box. Is that all
I need to do or do I need to specify all the databases under the
database access tab as well?
Thanks for the help.|||If you're a server administrator, you're "god" on all of the databases, yes.
newsqlman wrote:
> So under Enterprise Manager, the sql group and local area which lists
> all the folders.
> There is a security folder and underneath it there is a logins
> option. I see you can add logins there.
> So what I need to do if I understand correctly is add the login from
> the domain list domain\user and then
> under the properties of that login I go to the server roles tab and
> check server administrators box. Is that all
> I need to do or do I need to specify all the databases under the
> database access tab as well?
> Thanks for the help.
>
-Dave Markle
http://www.markleconsulting.com/blog

Ok Im making a webpage but

with SQL desktop engine installed where do I even begin working with it?Hi,

You can get started with the use of this Guided Tour of Web Matrix/MSDE:
http://asp.net/webmatrix/guidedtour/section2/newconn.aspx

Regardssql

Odd Server Behavior

I have a new SQL Server installation on a remote dedicated web server server
hosting several websites.
If I use Remote Desktop, I can log in on the server and perform any DB task,
using any of the created logins without any problem. I can use Enterprise
Manager & Query Analyzer without any problems.
But if I connect with Query Analyzer or Enterprise Manager remotely (from my
home or office PC), things start getting really strange.
First, I don't see all the databases when I connect as sa in Query Analyzer
or Enterprise Manager. Now, I don't like using sa remotely in the first
place, so I have an account that has complete admin access to the database
server. And that account works fine on the server. But no other account on
the server will connect to the database remotely except sa. When I do
connect as sa, I don't see all objects on the server. I don't see 1
database. The other 2 databases I do see? I don't see all the objects using
either QA or EM. I can't run select statements on them. If I run SELECT *
FROM SYSOBJECTS remotely, I don't see all the objects. If I run SELECT *
FROM SYSOBJECTS on the server, I see everything. And yes, the accounts are
set up correctly, they all work as configured on the server. And when I
thought it couldn't behave more wierd, it did. I didn't see a table named
ClubCalendar' remotely. So I created it remotely to see what would happen.
And it created the new table. And if I log on the server, I don't see that
table. I know I'm connecting to the correct server because I doubt anyone
else would use the password I'm using for sa and that account does connect.
Anyone have any ideas about this? This is starting to drive me batty.
Dan
Problem solved. I had to shut down the local instance and not start it and
reset the TCP port. Even though it was set to 1433, I had to set it again.
Odd, since this was working yesterday morning.
Dan
"Dan" wrote:

> I have a new SQL Server installation on a remote dedicated web server server
> hosting several websites.
> If I use Remote Desktop, I can log in on the server and perform any DB task,
> using any of the created logins without any problem. I can use Enterprise
> Manager & Query Analyzer without any problems.
> But if I connect with Query Analyzer or Enterprise Manager remotely (from my
> home or office PC), things start getting really strange.
> First, I don't see all the databases when I connect as sa in Query Analyzer
> or Enterprise Manager. Now, I don't like using sa remotely in the first
> place, so I have an account that has complete admin access to the database
> server. And that account works fine on the server. But no other account on
> the server will connect to the database remotely except sa. When I do
> connect as sa, I don't see all objects on the server. I don't see 1
> database. The other 2 databases I do see? I don't see all the objects using
> either QA or EM. I can't run select statements on them. If I run SELECT *
> FROM SYSOBJECTS remotely, I don't see all the objects. If I run SELECT *
> FROM SYSOBJECTS on the server, I see everything. And yes, the accounts are
> set up correctly, they all work as configured on the server. And when I
> thought it couldn't behave more wierd, it did. I didn't see a table named
> ClubCalendar' remotely. So I created it remotely to see what would happen.
> And it created the new table. And if I log on the server, I don't see that
> table. I know I'm connecting to the correct server because I doubt anyone
> else would use the password I'm using for sa and that account does connect.
> Anyone have any ideas about this? This is starting to drive me batty.
> --
> Dan

Odd Server Behavior

I have a new SQL Server installation on a remote dedicated web server server
hosting several websites.
If I use Remote Desktop, I can log in on the server and perform any DB task,
using any of the created logins without any problem. I can use Enterprise
Manager & Query Analyzer without any problems.
But if I connect with Query Analyzer or Enterprise Manager remotely (from my
home or office PC), things start getting really strange.
First, I don't see all the databases when I connect as sa in Query Analyzer
or Enterprise Manager. Now, I don't like using sa remotely in the first
place, so I have an account that has complete admin access to the database
server. And that account works fine on the server. But no other account on
the server will connect to the database remotely except sa. When I do
connect as sa, I don't see all objects on the server. I don't see 1
database. The other 2 databases I do see? I don't see all the objects usin
g
either QA or EM. I can't run select statements on them. If I run SELECT *
FROM SYSOBJECTS remotely, I don't see all the objects. If I run SELECT *
FROM SYSOBJECTS on the server, I see everything. And yes, the accounts are
set up correctly, they all work as configured on the server. And when I
thought it couldn't behave more wierd, it did. I didn't see a table named
ClubCalendar' remotely. So I created it remotely to see what would happen.
And it created the new table. And if I log on the server, I don't see that
table. I know I'm connecting to the correct server because I doubt anyone
else would use the password I'm using for sa and that account does connect.
Anyone have any ideas about this? This is starting to drive me batty.
DanProblem solved. I had to shut down the local instance and not start it and
reset the TCP port. Even though it was set to 1433, I had to set it again.
Odd, since this was working yesterday morning.
Dan
"Dan" wrote:

> I have a new SQL Server installation on a remote dedicated web server serv
er
> hosting several websites.
> If I use Remote Desktop, I can log in on the server and perform any DB tas
k,
> using any of the created logins without any problem. I can use Enterprise
> Manager & Query Analyzer without any problems.
> But if I connect with Query Analyzer or Enterprise Manager remotely (from
my
> home or office PC), things start getting really strange.
> First, I don't see all the databases when I connect as sa in Query Analyze
r
> or Enterprise Manager. Now, I don't like using sa remotely in the first
> place, so I have an account that has complete admin access to the database
> server. And that account works fine on the server. But no other account
on
> the server will connect to the database remotely except sa. When I do
> connect as sa, I don't see all objects on the server. I don't see 1
> database. The other 2 databases I do see? I don't see all the objects us
ing
> either QA or EM. I can't run select statements on them. If I run SELECT
*
> FROM SYSOBJECTS remotely, I don't see all the objects. If I run SELECT *
> FROM SYSOBJECTS on the server, I see everything. And yes, the accounts ar
e
> set up correctly, they all work as configured on the server. And when I
> thought it couldn't behave more wierd, it did. I didn't see a table named
> ClubCalendar' remotely. So I created it remotely to see what would happen
.
> And it created the new table. And if I log on the server, I don't see tha
t
> table. I know I'm connecting to the correct server because I doubt anyone
> else would use the password I'm using for sa and that account does connect
.
> Anyone have any ideas about this? This is starting to drive me batty.
> --
> Dan

ODBC Setup

I have downloaded MS SQL Server for Desktop to upsize my
access database to SQL Server database.
The upsizing is successful and when I setup the DSN
connection. It gives the following error :
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login
failed for user 'TIMESWEB\IUSR_TIMESWEB'.
I remember the password. But the username is not
recognised by the SQL Server. Can you please let me know
how I can change the Username & password for MS SQL Server
after installing it. I do not know from where I can
change the username & password.
Kindly assist.
Thanks,
Rajesh.VMSDE does not come with the SQL administrator tools (like Enterprise Manager
or Query Analyzer). In order to manage the database, you need to use T-SQL
commands.
The T-SQL commands that should help you are:
If you want to add a SQL login use the following stored procedures:
sp_password:
http://msdn.microsoft.com/library/d.../>
pz_5x44.asp
sp_addlogin:
http://msdn.microsoft.com/library/d... />
a_0q7i.asp
If you want to use an existing Windows username (ie.
'TIMESWEB\IUSR_TIMESWEB'), then use the following stored procedure to give
the username access to the database:
sp_grantlogin:
http://msdn.microsoft.com/library/d... />
a_0q7i.asp
Brannon Jones
Developer - MDAC
This posting is provided "as is" with no warranties and confers no rights.
"Rajesh" <timesweb@.omantel.net.om> wrote in message
news:01a401c3c3a9$87064410$a001280a@.phx.gbl...

quote:

---

> I have downloaded MS SQL Server for Desktop to upsize my
> access database to SQL Server database.
> The upsizing is successful and when I setup the DSN
> connection. It gives the following error :
> Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Login
> failed for user 'TIMESWEB\IUSR_TIMESWEB'.
> I remember the password. But the username is not
> recognised by the SQL Server. Can you please let me know
> how I can change the Username & password for MS SQL Server
> after installing it. I do not know from where I can
> change the username & password.
> Kindly assist.
> Thanks,
> Rajesh.V

---