|
Home > Archive > MS SQL Server > October 2005 > access sql server in different domain
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]
| Author |
access sql server in different domain
|
|
|
| I just started as a consultant with a company who won't allow my notebook to
join the domain. No biggee - I can understand the security concerns. I am
able to get on the network and can Remote Desktop to the SQL Servers I need
to get to. However, life would be a heck of a lot better if I could map the
servers in EM. The problem is that the only user id I have in SQL is my
Windows id, not a local SQL Server id. And since I'm logged into my
notebook using cached credentials from a different domain, I can't register
the server in EM. I've read an article about using "net use \\<server>\ipc$
/user:<serverdomain>\<userid> <password>" and I was able to successfully run
this in a command window. I just don't really understand what it did for
me - because I still can't connect to the server in EM.
Is it possible to do what I want to do? If a solution is available in
Yukon, that would be acceptable too.
Thanks, Andre
| |
| MarkusB 2005-10-17, 1:23 pm |
| Andre,
you might try to start EM with the "run as" option, but I doubt it will
work. As an alternative you could try using the WebAdmin utility. It's
more limited than EM, but for most tasks it would be sufficient.
You can download it at
http://www.microsoft.com/downloads/...&displaylang=en
After install make sure you copy the updated
WebUIValidation.js file from
WINDOWS\Microsoft.NET\Framework\v1.1.4322
\ASP.NETClientFiles into {SQL Web Administrator
installation path}\Web\aspnet_cli
ent\system_web\1_1_4
322\
otherwise the programm hangs when you click the 'login' button.
Hope this helps
M
| |
| MarkusB 2005-10-17, 1:23 pm |
| Sorry, me again, must be the lack of coffee, but why don't you just
register the server using your SQL login ? Even though the server is in
a different domain this should work as long as your machine can resolve
the name.
M
| |
| Hemantgiri S. Goswami 2005-10-17, 1:23 pm |
| Hi,
as suggested try using sql login, or you could add / map yr windows login to
sql fixed role so that it will works for you.
regards
| |
| msnews.microsoft.com 2005-10-17, 1:23 pm |
| I don't have a SQL login - only a Windows login that has been granted access
to SQL.
Andre
"MarkusB" <m.bohse@quest-consultants.com> wrote in message
news:1129188096.681173.270080@g49g2000cwa.googlegroups.com...
> Sorry, me again, must be the lack of coffee, but why don't you just
> register the server using your SQL login ? Even though the server is in
> a different domain this should work as long as your machine can resolve
> the name.
>
> M
>
| |
|
| I tried to use the WebAdmin utility but I'm not getting it to work. Even
though I copied the file you mentioned, I'm never able to connect to sql -
even my local installation.
And even if I was able to get that to work, it still looks like the only
ways of connecting is using trusted or sql credentials. Unless I can trick
it by selecting sql credentials then typing in domain\username, I'm not sure
this would help me login to a sql server in another domain.
Any tips you have are appreciated.
Thanks, Andre
| |
| Hemantgiri S. Goswami 2005-10-17, 1:23 pm |
| Hi,
are you able to login and do work using QA !? what type of work you wants
to accomplish
Regards
| |
|
| > are you able to login and do work using QA !? what type of work you
> wants
> to accomplish
No, I'm not able to. I want to register EM, be able to login to QA, and run
Profiler. I don't have a sql login and am not in the domain - so I can't
use trusted logins.
Andre
| |
| Hemantgiri S. Goswami 2005-10-20, 8:23 pm |
| Hi,
then you must ensure that you have proper privillages ,
using sp_adduser to add your users to fixeddb role,
to ensure the associated role for yr user get script from :
http://www.sql-server-performance.c...?TOPIC_ID=10504
HTH
Regards
|
|
|
|
|