Accessing domain user name as a report parameter

In our legacy reports (ASP.NET/Crystal Reports) we use the logged in user account to filter the report.
Basically you are restricted to seeing your 'own' data when running the report based upon your user ID.
I am looking for suggestions as how to restrict report results based on something like domain user ID in Reporting Services.
There are many cases (like in the sales profession) where users of the same report do not want other users to access their information.
Thanks for any suggestions.use the global variable User!UserID
be aware that you may not create subscriptions for a report that contains user-defined parameter values.

Accessing Cube from Excel 2003

Analysis services Cube is created using SQL Server 2005 (CTP June). Server is in Prod domain.
There is no problems accessing and playing with Cube in the same box or within PROD domain.

While trying to access Cube from excel 2003 from a computer in other domain QUAL gives the following error

"an error was encountered in the transportation layer"

Any suggestions ?

I'm not exactly sure how IE Security settings interact with PTS, but your problem is making me think of the 'Access Data Sources across Domains' option in IE / Tools / Options / Security / Custom Level / Misc.

Is that option enabled?

Accessing Cube from Excel 2003

Analysis services Cube is created using SQL Server 2005 (CTP June). Server is in Prod domain.
There is no problems accessing and playing with Cube in the same box or within PROD domain.

While trying to access Cube from excel 2003 from a computer in other domain QUAL gives the following error

"an error was encountered in the transportation layer"

Any suggestions ?

I'm not exactly sure how IE Security settings interact with PTS, but your problem is making me think of the 'Access Data Sources across Domains' option in IE / Tools / Options / Security / Custom Level / Misc.

Is that option enabled?

Access using odbc to connect with SQL server

My workstation is XP prof sp2 w/ office XP under a domain policy.
i act as "administrator" using Access XP to connect with SQL server.
i can view and add records to the SQL server.
at the same workstation, i act as "normal user with normal rights" using
Access XP to connect with SQL server.
i can view BUT cannot add records.
The odbc is the same one. i also use the same login account with SQL
server.
How come i cannot add records? Thanks a lot.
Tony
The issue is not with the client but with the SQL Server whereby your
user-mode connection doesn't have permission to update the server.
You'll need to update the SQL Server to add these permissions to the
databases you want to use. Do a query under 'GRANT' privileges topics on
Books On Line for more details for the queries you want.
| From: "Tony WONG" <x34@.hknet.com>
| Subject: Access using odbc to connect with SQL server
| Date: Mon, 1 Aug 2005 17:21:42 +0800
| Lines: 19
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| X-RFC2646: Format=Flowed; Original
| Message-ID: <#GsS1pnlFHA.572@.TK2MSFTNGP15.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.odbc
| NNTP-Posting-Host: 202.64.158.2
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP15.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.odbc:2524
| X-Tomcat-NG: microsoft.public.sqlserver.odbc
|
| My workstation is XP prof sp2 w/ office XP under a domain policy.
|
| i act as "administrator" using Access XP to connect with SQL server.
|
| i can view and add records to the SQL server.
|
| at the same workstation, i act as "normal user with normal rights" using
| Access XP to connect with SQL server.
|
| i can view BUT cannot add records.
|
| The odbc is the same one. i also use the same login account with SQL
| server.
|
| How come i cannot add records? Thanks a lot.
|
| Tony
|
|
|

Access using odbc to connect with SQL server

My workstation is XP prof sp2 w/ office XP under a domain policy.
i act as "administrator" using Access XP to connect with SQL server.
i can view and add records to the SQL server.
at the same workstation, i act as "normal user with normal rights" using
Access XP to connect with SQL server.
i can view BUT cannot add records.
The odbc is the same one. i also use the same login account with SQL
server.
How come i cannot add records? Thanks a lot.
TonyThe issue is not with the client but with the SQL Server whereby your
user-mode connection doesn't have permission to update the server.
You'll need to update the SQL Server to add these permissions to the
databases you want to use. Do a query under 'GRANT' privileges topics on
Books On Line for more details for the queries you want.
| From: "Tony WONG" <x34@.hknet.com>
| Subject: Access using odbc to connect with SQL server
| Date: Mon, 1 Aug 2005 17:21:42 +0800
| Lines: 19
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| X-RFC2646: Format=Flowed; Original
| Message-ID: <#GsS1pnlFHA.572@.TK2MSFTNGP15.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.odbc
| NNTP-Posting-Host: 202.64.158.2
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.odbc:2524
| X-Tomcat-NG: microsoft.public.sqlserver.odbc
|
| My workstation is XP prof sp2 w/ office XP under a domain policy.
|
| i act as "administrator" using Access XP to connect with SQL server.
|
| i can view and add records to the SQL server.
|
| at the same workstation, i act as "normal user with normal rights" using
| Access XP to connect with SQL server.
|
| i can view BUT cannot add records.
|
| The odbc is the same one. i also use the same login account with SQL
| server.
|
| How come i cannot add records? Thanks a lot.
|
| Tony
|
|
|

Access to SQL Server via WCF works only part time

We have 2 databases ( Guider and Talker ) and we have a WCF service that is logged in with a domain identity.

In our SQL Server we have the service ID added to the Data Server Logins and both Guider and Talker are given access to the user.

When we access Guider we have no problems getting data.

When we access Talker we have a login failure:

Cannot open database 'Talker' requested by the login. The login failed.

Login failed for user 'Acorn\CommunicationServices'.

The thing that gets me is that the user is created at the Server level, in both Databases, and at the server level both databases are checked for the user. master has been set as the default database for the user.

Basically, as far as I can see Talker and Guider are configured identically! So I cannot figure out why I cannot login to the second database!

Is there a specific setting I'm missing somewhere to grant login access to the user? I'm using

Management Studio Express to manage the database.

My guess here is that the default database defined for the login that fails (Acorn\CommunicationServices) is not configured properly. Another possibility may be a typo when specifying the DB name in the client.

One test you can try to verify if the principal can really access the DB is:

*Connect as a sysadmin

* run “EXECUTE AS LOGIN = ‘login_name’ “ to impersonate the principal

* USE [Talker]

I hope this helps,

-Raul Garcia

SDE/T

SQL Server Engine

Access to SQL Server via WCF works only part time

We have 2 databases ( Guider and Talker ) and we have a WCF service that is logged in with a domain identity.

In our SQL Server we have the service ID added to the Data Server Logins and both Guider and Talker are given access to the user.

When we access Guider we have no problems getting data.

When we access Talker we have a login failure:

Cannot open database 'Talker' requested by the login. The login failed.

Login failed for user 'Acorn\CommunicationServices'.

The thing that gets me is that the user is created at the Server level, in both Databases, and at the server level both databases are checked for the user. master has been set as the default database for the user.

Basically, as far as I can see Talker and Guider are configured identically! So I cannot figure out why I cannot login to the second database!

Is there a specific setting I'm missing somewhere to grant login access to the user? I'm using

Management Studio Express to manage the database.

My guess here is that the default database defined for the login that fails (Acorn\CommunicationServices) is not configured properly. Another possibility may be a typo when specifying the DB name in the client.

One test you can try to verify if the principal can really access the DB is:

*Connect as a sysadmin

* run “EXECUTE AS LOGIN = ‘login_name’ “ to impersonate the principal

* USE [Talker]

I hope this helps,

-Raul Garcia

SDE/T

SQL Server Engine

access to SQL from non-domain PC via Enterprise Manager

I have a developer on contract which will use her laptop to work, laptop is
not part of the domain, we install SQL tools on it and now I need to give th
at person access to one of our SQL databases, so I created sql user and then
try to register this serve
r on her laptop in Enterprise Menager but getting error “server is not run
ning or you do no have an access to it” how do bypass it? I have not pro
blem to register this server in Enterprise Manager on my PC using same sql u
ser but my PC is part of do
main, any idea?Make sure they are using TCP/IP to connect. You can force this by setting up
a client alias using the Client Network Utility. Also, try connecting using
Query Analyzer rather than EM and specifying tcp:servername in the
connection dialog to force it to use TCP/IP rather than Named pipes
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"TOM P." <TOMP@.discussions.microsoft.com> wrote in message
news:C1F92B39-7CAB-4649-8645-DBEF1D0EC2E4@.microsoft.com...
> I have a developer on contract which will use her laptop to work, laptop
is not part of the domain, we install SQL tools on it and now I need to give
that person access to one of our SQL databases, so I created sql user and
then try to register this server on her laptop in Enterprise Menager but
getting error "server is not running or you do no have an access to it"
how do bypass it? I have not problem to register this server in Enterprise
Manager on my PC using same sql user but my PC is part of domain, any idea?|||Thanks,
I have figuered it out, anyway thanks for respond... that's exactly what I h
ad to do creat Alias using TCPIP
Thanks again
"Jasper Smith" wrote:

> Make sure they are using TCP/IP to connect. You can force this by setting
up
> a client alias using the Client Network Utility. Also, try connecting usin
g
> Query Analyzer rather than EM and specifying tcp:servername in the
> connection dialog to force it to use TCP/IP rather than Named pipes
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "TOM P." <TOMP@.discussions.microsoft.com> wrote in message
> news:C1F92B39-7CAB-4649-8645-DBEF1D0EC2E4@.microsoft.com...
> is not part of the domain, we install SQL tools on it and now I need to gi
ve
> that person access to one of our SQL databases, so I created sql user and
> then try to register this server on her laptop in Enterprise Menager but
> getting error "server is not running or you do no have an access to it"
> how do bypass it? I have not problem to register this server in Enterprise
> Manager on my PC using same sql user but my PC is part of domain, any idea
?
>
>

access to SQL from non-domain PC via Enterprise Manager

I have a developer on contract which will use her laptop to work, laptop is not part of the domain, we install SQL tools on it and now I need to give that person access to one of our SQL databases, so I created sql user and then try to register this serve
r on her laptop in Enterprise Menager but getting error “server is not running or you do no have an access to it” how do bypass it? I have not problem to register this server in Enterprise Manager on my PC using same sql user but my PC is part of do
main, any idea?
Make sure they are using TCP/IP to connect. You can force this by setting up
a client alias using the Client Network Utility. Also, try connecting using
Query Analyzer rather than EM and specifying tcp:servername in the
connection dialog to force it to use TCP/IP rather than Named pipes
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"TOM P." <TOMP@.discussions.microsoft.com> wrote in message
news:C1F92B39-7CAB-4649-8645-DBEF1D0EC2E4@.microsoft.com...
> I have a developer on contract which will use her laptop to work, laptop
is not part of the domain, we install SQL tools on it and now I need to give
that person access to one of our SQL databases, so I created sql user and
then try to register this server on her laptop in Enterprise Menager but
getting error "server is not running or you do no have an access to it"
how do bypass it? I have not problem to register this server in Enterprise
Manager on my PC using same sql user but my PC is part of domain, any idea?
|||Thanks,
I have figuered it out, anyway thanks for respond... that's exactly what I had to do creat Alias using TCPIP
Thanks again
"Jasper Smith" wrote:

> Make sure they are using TCP/IP to connect. You can force this by setting up
> a client alias using the Client Network Utility. Also, try connecting using
> Query Analyzer rather than EM and specifying tcp:servername in the
> connection dialog to force it to use TCP/IP rather than Named pipes
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "TOM P." <TOMP@.discussions.microsoft.com> wrote in message
> news:C1F92B39-7CAB-4649-8645-DBEF1D0EC2E4@.microsoft.com...
> is not part of the domain, we install SQL tools on it and now I need to give
> that person access to one of our SQL databases, so I created sql user and
> then try to register this server on her laptop in Enterprise Menager but
> getting error "server is not running or you do no have an access to it"
> how do bypass it? I have not problem to register this server in Enterprise
> Manager on my PC using same sql user but my PC is part of domain, any idea?
>
>

access SQL Server on a different domain

Is there a way to access a SQL Server running on a different domain? I can access the same SQL Server from my machine, which is on a different domain using the ODBC connection, but when I try to access it using an application written in VB6.0 then I get the SQL Server does not exist error. I'm using the SQL Authentication method.If you have MDAC 2.6 or above, then TCP/IP is selected by default. Also check your Client Network Configuration.|||My MDAC is 2.7 and I'm using the TCP/IP connection. Also there is no Trusted connection between the two Domains.|||Trust does not matter for SQL, unless there is some kind of TCP filtering configured. It seems like in your case there is something else happening with your VB app. What are you using in it to connect? DAO, RDO, ADO, or direct ODBC API's?

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
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/d...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_client\system_web\1_1_4322\
otherwise the programm hangs when you click the 'login' button.
Hope this helps
M
|||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
|||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
|||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.googlegr oups.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
|||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
|||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.co...TOPIC_ID=10504
HTH
Regards

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, AndreAndre,
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/details.aspx?FamilyId=C039A798-C57A-419E-ACBC-2A332CB7F959&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_client\system_web\1_1_4322\
otherwise the programm hangs when you click the 'login' button.
Hope this helps
M|||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|||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|||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|||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|||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.com/forum/topic.asp?TOPIC_ID=10504
HTH
Regards

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, AndreAndre,
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_client\system_web\1_1_4
322\
otherwise the programm hangs when you click the 'login' button.
Hope this helps
M|||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|||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|||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|||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|||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

Access SQL Server from Stand-Alone PC with Windows Authentication

I have a PC that is not joined to the domain. I want to be able to access
our SQL Server from it, but it is my active directory domain account that ha
s
access. How can I gain access to the SQL Server via Enterprise Manager or
Query Analyzer?Hello,
If the machine is in a workgroup, SQL server machine is in the domain, make
sure you can ping the SQL server machine from the machine you log on
successfully via IP address or machine name.
Create a same Local user account both on the machine and the SQL server
machine. The Local user account and password on both machines need to be
same . On the SQL server machine, add the Local user account as the SQL
server logins and grant the user right to access the database. By doing so,
you can access the SQL server via Query Analyzer with Windows
authentication.
Or you can access the SQL server using a SQL logins via Query Analyzer with
SQL authentication.
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
========================================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.

access sql server across domain thru windows authentication

Hi,
I have a sql server in a domain which is different than the one I log into,
and thats server has Windows authenticatrion, I have a domain account in the domain where sql is running, now how do I provide that domain acc info en EM to connect to that sql server. If I just select windows authenication while registering that server it gives me Cannot generate SSPI context error.

Any help will be appricaited.

Tia,
ParthYou can not do this from EM, as far as I know!
Or if you can, I would like to know that, too.

Best regards!

Access otehr sql server ina domain w/ Query Analyzer

Hi everybody,

I do not know if this is the correct area to post this topic? So, How to access
different sql server with query analyzer? Usually, when to install sql server, it
access the database server locally installed, now I like to access other sql server
within a domain using query analyzer. How to configure this in order I could use
query analyzer to access other sql server within a domain? Thanks in advanced.

den2005

Simply choose Connect from the menu and connect to a different server. If you want to you another server in your query you can setup a linked server whereas you can query across different servers in one query.

HTH, jens Suessmeyer.

Access from MS-Excel to Analysis-Services-Cube from different domain

Hi Profis!
We have some server installed with customer, which run in an exclusive
domain (only this server and because of that also DC). Let's call him
"OLAP-Server".
All the clients are in another domain.
Access to "OLAP-Server" via HTTP works fine, also mapping of a drive (with
manual authification).
There is no firewall between all the Server and PCs in all domains. So we
can exclude problems with ports.
What does not work?
Access from Excel-XP-Clients or Excel-2003-Clients to OLAP-Server (running
Analysis Services) will always be blocked.
If in domain auf OLAP-Server there is an user with SAME username and SAME
password as in the other domains, access from MS-Excel works fine. If not,
access will not be possible.
Analysis Services may not be configured for access via HTTP or HTTPS as we
have installed Standard-Edition of SQL-Server.
Question 1: is there a possibility to access to Analysis-Services-Cube via
HTTP or HTTPS also on standard-edition? (except of installing local Excel
and publice as HTML... ...we need a REAL access via Client-installed
MS-Excel!
Question 2: is there a possibility to deactivate authentification to
Analysis-Services-Cube? A trusted domain (even in outgoing connection) ist
not possible due to internal reasons.
Many thanks for urgently required help!
Best regards,
Klaus
Read the Security Administration section of the AS Operations Guide
http://www.microsoft.com/technet/pro.../anservog.mspx
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Newsgroupsupport" <newsgroupsupport@.itando.net> wrote in message
news:42c2c7e9$0$14549$79720d31@.newsreader.inode.at ...
> Hi Profis!
> We have some server installed with customer, which run in an exclusive
> domain (only this server and because of that also DC). Let's call him
> "OLAP-Server".
> All the clients are in another domain.
> Access to "OLAP-Server" via HTTP works fine, also mapping of a drive (with
> manual authification).
> There is no firewall between all the Server and PCs in all domains. So we
> can exclude problems with ports.
> What does not work?
> Access from Excel-XP-Clients or Excel-2003-Clients to OLAP-Server (running
> Analysis Services) will always be blocked.
> If in domain auf OLAP-Server there is an user with SAME username and SAME
> password as in the other domains, access from MS-Excel works fine. If not,
> access will not be possible.
> Analysis Services may not be configured for access via HTTP or HTTPS as we
> have installed Standard-Edition of SQL-Server.
> Question 1: is there a possibility to access to Analysis-Services-Cube via
> HTTP or HTTPS also on standard-edition? (except of installing local Excel
> and publice as HTML... ...we need a REAL access via Client-installed
> MS-Excel!
> Question 2: is there a possibility to deactivate authentification to
> Analysis-Services-Cube? A trusted domain (even in outgoing connection) ist
> not possible due to internal reasons.
> Many thanks for urgently required help!
> Best regards,
> Klaus
>
>
|||what is the authentication method used in IIS?
NTLM or basic authentication?
does IIS is on the same server as your OLAP Server?
maybe there is a delegation problem.
so try the basic authentication first.
"Newsgroupsupport" <newsgroupsupport@.itando.net> wrote in message
news:42c2c7e9$0$14549$79720d31@.newsreader.inode.at ...
> Hi Profis!
> We have some server installed with customer, which run in an exclusive
> domain (only this server and because of that also DC). Let's call him
> "OLAP-Server".
> All the clients are in another domain.
> Access to "OLAP-Server" via HTTP works fine, also mapping of a drive (with
> manual authification).
> There is no firewall between all the Server and PCs in all domains. So we
> can exclude problems with ports.
> What does not work?
> Access from Excel-XP-Clients or Excel-2003-Clients to OLAP-Server (running
> Analysis Services) will always be blocked.
> If in domain auf OLAP-Server there is an user with SAME username and SAME
> password as in the other domains, access from MS-Excel works fine. If not,
> access will not be possible.
> Analysis Services may not be configured for access via HTTP or HTTPS as we
> have installed Standard-Edition of SQL-Server.
> Question 1: is there a possibility to access to Analysis-Services-Cube via
> HTTP or HTTPS also on standard-edition? (except of installing local Excel
> and publice as HTML... ...we need a REAL access via Client-installed
> MS-Excel!
> Question 2: is there a possibility to deactivate authentification to
> Analysis-Services-Cube? A trusted domain (even in outgoing connection) ist
> not possible due to internal reasons.
> Many thanks for urgently required help!
> Best regards,
> Klaus
>
>

Access from MS-Excel to Analysis-Services-Cube from different domain

Hi Profis!
We have some server installed with customer, which run in an exclusive
domain (only this server and because of that also DC). Let's call him
"OLAP-Server".
All the clients are in another domain.
Access to "OLAP-Server" via HTTP works fine, also mapping of a drive (with
manual authification).
There is no firewall between all the Server and PCs in all domains. So we
can exclude problems with ports.
What does not work?
Access from Excel-XP-Clients or Excel-2003-Clients to OLAP-Server (running
Analysis Services) will always be blocked.
If in domain auf OLAP-Server there is an user with SAME username and SAME
password as in the other domains, access from MS-Excel works fine. If not,
access will not be possible.
Analysis Services may not be configured for access via HTTP or HTTPS as we
have installed Standard-Edition of SQL-Server.
Question 1: is there a possibility to access to Analysis-Services-Cube via
HTTP or HTTPS also on standard-edition? (except of installing local Excel
and publice as HTML... ...we need a REAL access via Client-installed
MS-Excel!
Question 2: is there a possibility to deactivate authentification to
Analysis-Services-Cube? A trusted domain (even in outgoing connection) ist
not possible due to internal reasons.
Many thanks for urgently required help!
Best regards,
KlausRead the Security Administration section of the AS Operations Guide
http://www.microsoft.com/technet/pr...n/anservog.mspx
--
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Newsgroupsupport" <newsgroupsupport@.itando.net> wrote in message
news:42c2c7e9$0$14549$79720d31@.newsreade
r.inode.at...
> Hi Profis!
> We have some server installed with customer, which run in an exclusive
> domain (only this server and because of that also DC). Let's call him
> "OLAP-Server".
> All the clients are in another domain.
> Access to "OLAP-Server" via HTTP works fine, also mapping of a drive (with
> manual authification).
> There is no firewall between all the Server and PCs in all domains. So we
> can exclude problems with ports.
> What does not work?
> Access from Excel-XP-Clients or Excel-2003-Clients to OLAP-Server (running
> Analysis Services) will always be blocked.
> If in domain auf OLAP-Server there is an user with SAME username and SAME
> password as in the other domains, access from MS-Excel works fine. If not,
> access will not be possible.
> Analysis Services may not be configured for access via HTTP or HTTPS as we
> have installed Standard-Edition of SQL-Server.
> Question 1: is there a possibility to access to Analysis-Services-Cube via
> HTTP or HTTPS also on standard-edition? (except of installing local Excel
> and publice as HTML... ...we need a REAL access via Client-installed
> MS-Excel!
> Question 2: is there a possibility to deactivate authentification to
> Analysis-Services-Cube? A trusted domain (even in outgoing connection) ist
> not possible due to internal reasons.
> Many thanks for urgently required help!
> Best regards,
> Klaus
>
>|||what is the authentication method used in IIS?
NTLM or basic authentication?
does IIS is on the same server as your OLAP Server?
maybe there is a delegation problem.
so try the basic authentication first.
"Newsgroupsupport" <newsgroupsupport@.itando.net> wrote in message
news:42c2c7e9$0$14549$79720d31@.newsreade
r.inode.at...
> Hi Profis!
> We have some server installed with customer, which run in an exclusive
> domain (only this server and because of that also DC). Let's call him
> "OLAP-Server".
> All the clients are in another domain.
> Access to "OLAP-Server" via HTTP works fine, also mapping of a drive (with
> manual authification).
> There is no firewall between all the Server and PCs in all domains. So we
> can exclude problems with ports.
> What does not work?
> Access from Excel-XP-Clients or Excel-2003-Clients to OLAP-Server (running
> Analysis Services) will always be blocked.
> If in domain auf OLAP-Server there is an user with SAME username and SAME
> password as in the other domains, access from MS-Excel works fine. If not,
> access will not be possible.
> Analysis Services may not be configured for access via HTTP or HTTPS as we
> have installed Standard-Edition of SQL-Server.
> Question 1: is there a possibility to access to Analysis-Services-Cube via
> HTTP or HTTPS also on standard-edition? (except of installing local Excel
> and publice as HTML... ...we need a REAL access via Client-installed
> MS-Excel!
> Question 2: is there a possibility to deactivate authentification to
> Analysis-Services-Cube? A trusted domain (even in outgoing connection) ist
> not possible due to internal reasons.
> Many thanks for urgently required help!
> Best regards,
> Klaus
>
>

Access Denied when connecting

I am having a problem connecting to my SQL 2005 named instance on a clustered
server in another domaim. If I am within the domain everything works fine. If
I am in a different domain, I cannot register it through SQL Management
Studio or create an ODBC connection. I can ping it and all of the cluster
nodes. When trying to connect I get the following errors:
SQL Management Studio:
"An error has occured while establishing a connection to the server. When
connecting to SAL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
(provider:SQL Network Interfaces, error:26 -Error locating server/instance
specified)
ODBC:
SQL Server Error: 17
ODBC SQL Server Driver SQL Server does not exist or access denied
However, the server is set up for remote connections.
Any Suggestions?
What type of authentication are you using Windows or SQL?
If you are using SQL login, you should be able to connect as long as you can
ping the server. Since your SQL server is on a different Domain, and you
want to use your Windows domain account, make sure that you have a trust
relationship between the 2 domains if you login to one domain and want to
access the other one.
Ayad Shammout
"Rick" <Rick@.discussions.microsoft.com> wrote in message
news:BAD23A07-CEB4-4A33-BC0C-2B5C61602812@.microsoft.com...
>I am having a problem connecting to my SQL 2005 named instance on a
>clustered
> server in another domaim. If I am within the domain everything works fine.
> If
> I am in a different domain, I cannot register it through SQL Management
> Studio or create an ODBC connection. I can ping it and all of the cluster
> nodes. When trying to connect I get the following errors:
> SQL Management Studio:
> "An error has occured while establishing a connection to the server. When
> connecting to SAL Server 2005, this failure may be caused by the fact that
> under the default settings SQL Server does not allow remote connections.
> (provider:SQL Network Interfaces, error:26 -Error locating server/instance
> specified)
> ODBC:
> SQL Server Error: 17
> ODBC SQL Server Driver SQL Server does not exist or access denied
> However, the server is set up for remote connections.
> Any Suggestions?

Access denied starting SQL Server after joining to new Windows domain

Hi, I made following steps:
1. Remove the SQL Server 2000 computer (W2k3) from old Windows domain
2. The same computer joined to new Windows domain (newdomain)
3. On the Domain Controler (W2k3) I create an domain account
SQLLaunch, which is a member of Domain Users group.
4. On the SQL Server 2003 computer I changed the SQL Server service
startup account to SQLStart@.newdomain account. The same thing made I
with the SQL Server Agent Service. Both the SQL Server Service and SQL
Server Agent start automatically when OS starts.
after these steps I tried to start the SQL Server service, but the
SQL Server did not start. Error message dialog appears as follows:
"Could not start the MSSQLSERVER service on Local Computer
Error 5: Access denied"
After I login to the SQL Server computer using SQLStart@.newdomain
account and try to start the sqlservr.exe in SQL Server home directory
similar error dialog appears:
"Access denied"
first after I made the SQLStart@.newdomain account a member of
the local Administrator group on ther SQL Server computer, everything
is going well.
What can I do to avoid to grant the Administrator's rights to the
SQLStart@.newdomain (in order to
minimize risk of exploits - it is not the right way to grant the
Administrator's rights). The desire is to use a domain account
without any Administration rights. Can anyone help me?
thanks
LiborI don't think that the account needs full admin rights to the server, but it
needs the "log on as a service" rights. When you set the account that runs
the service, the OS will automatically grant this right. I'd expect though
that you need to be logged on with an account that has the rights to grant
this rights to do it. In other words, try to log on the the server as
Administrator (or another account with admin rights) and then set the
account for SQLSERVER and SQLServerAgent service. Then the account should be
granted rights to log on as a service. Then try to restart the server (or
just the service). Remember to remove the SQL acounts from the servers admin
group before you test it.
Regards
Steen
Libor Forejtnik wrote:
> Hi, I made following steps:
> 1. Remove the SQL Server 2000 computer (W2k3) from old Windows domain
> 2. The same computer joined to new Windows domain (newdomain)
> 3. On the Domain Controler (W2k3) I create an domain account
> SQLLaunch, which is a member of Domain Users group.
> 4. On the SQL Server 2003 computer I changed the SQL Server service
> startup account to SQLStart@.newdomain account. The same thing made I
> with the SQL Server Agent Service. Both the SQL Server Service and SQL
> Server Agent start automatically when OS starts.
> after these steps I tried to start the SQL Server service, but the
> SQL Server did not start. Error message dialog appears as follows:
> "Could not start the MSSQLSERVER service on Local Computer
> Error 5: Access denied"
> After I login to the SQL Server computer using SQLStart@.newdomain
> account and try to start the sqlservr.exe in SQL Server home directory
> similar error dialog appears:
> "Access denied"
> first after I made the SQLStart@.newdomain account a member of
> the local Administrator group on ther SQL Server computer, everything
> is going well.
> What can I do to avoid to grant the Administrator's rights to the
> SQLStart@.newdomain (in order to
> minimize risk of exploits - it is not the right way to grant the
> Administrator's rights). The desire is to use a domain account
> without any Administration rights. Can anyone help me?
> thanks
> Libor|||Thank for this usefull advice. There is another way to solve the
problem too. Simply reinstall the server with the option
"registry rebuild". I guess, it makes the same things as You
recomended. In addition, the startup account must be
registered as a SQL Server login.
Unfortunatelly, starting the SQLServerAgent needs to have the startup
account a member of the SQL Server System Administration group.
But this is not a critical for me.
Libor
On Wed, 9 Mar 2005 10:08:37 +0100, "Steen Persson"
<SPE@.REMOVEdatea.dk> wrote:

>I don't think that the account needs full admin rights to the server, but i
t
>needs the "log on as a service" rights. When you set the account that runs
>the service, the OS will automatically grant this right. I'd expect though
>that you need to be logged on with an account that has the rights to grant
>this rights to do it. In other words, try to log on the the server as
>Administrator (or another account with admin rights) and then set the
>account for SQLSERVER and SQLServerAgent service. Then the account should b
e
>granted rights to log on as a service. Then try to restart the server (or
>just the service). Remember to remove the SQL acounts from the servers admi
n
>group before you test it.
>Regards
>Steen
>Libor Forejtnik wrote:
>