|
Home > Archive > MS SQL Server > August 2005 > newbie SQL
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| Here is my senario, I have two different logins, and why I don't know. One
login is for my workstation, and one is for "NIT". NIT is the SQL Server.
Anyhow, I need to connect to my SQL Server from my workstation so that I can
work with my databases. I have installed "Client Tools" so that I have
Enterprise Manager available, but when I go into this area, it shows I have
no databases or as they call it "no items". Now if I was to login to the
domain "NIT" through my workstation, I could then connect, and do see all my
databases.
I would appreciate any suggestions on how to connect to "Enterprise
Manager" just using my workstation without connecting to the "NIT" domain?
thanks
--
mollybigd
| |
| Chandra 2005-08-24, 8:23 pm |
| hi molly
probably u are able to access the database from Query Analyser and when u
try to access it from EM u are unable to see the database server.
for this u need to register ur database server under SQL Server group.
just right click and select new server registration. the whizard will guide
u the rest
please let me know if u have any questions
--
best Regards,
Chandra
http://chanduas.blogspot.com/
http://www.SQLResource.com/
---------------------------------------
"molly" wrote:
> Here is my senario, I have two different logins, and why I don't know. One
> login is for my workstation, and one is for "NIT". NIT is the SQL Server.
> Anyhow, I need to connect to my SQL Server from my workstation so that I can
> work with my databases. I have installed "Client Tools" so that I have
> Enterprise Manager available, but when I go into this area, it shows I have
> no databases or as they call it "no items". Now if I was to login to the
> domain "NIT" through my workstation, I could then connect, and do see all my
> databases.
>
> I would appreciate any suggestions on how to connect to "Enterprise
> Manager" just using my workstation without connecting to the "NIT" domain?
> thanks
> --
> mollybigd
| |
| Tom Moreau 2005-08-24, 8:23 pm |
| It appears that your Windows login has been granted access to more databases
than your SQL Server login. Talk to your SQL Server admin and have him/her
grant access to those DB's for your SQL Server login.
That said, using Windows authentication is more secure. Why not just use
that login?
--
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"molly" <molly@discussions.microsoft.com> wrote in message
news:B05E0058-FF26-499D-84D9- 6EF31CAAB312@microso
ft.com...
Here is my senario, I have two different logins, and why I don't know. One
login is for my workstation, and one is for "NIT". NIT is the SQL Server.
Anyhow, I need to connect to my SQL Server from my workstation so that I can
work with my databases. I have installed "Client Tools" so that I have
Enterprise Manager available, but when I go into this area, it shows I have
no databases or as they call it "no items". Now if I was to login to the
domain "NIT" through my workstation, I could then connect, and do see all my
databases.
I would appreciate any suggestions on how to connect to "Enterprise
Manager" just using my workstation without connecting to the "NIT" domain?
thanks
--
mollybigd
|
|
|
|
|