Hi,
We had deployed a .NET application in a non clustered environment with conection pooling and was working fine. Now we had moved to a clustered env and connection pooling stopped working. Is there any cluster aware setting that we need to look at. Please let me know your thoughts.
Thanks in advanceCan you be more specific on what went wrong? Any error code, exception stack will be helpful.sqlsql
Showing posts with label environment. Show all posts
Showing posts with label environment. Show all posts
Sunday, March 25, 2012
Monday, March 19, 2012
Connection Manager Deployment with master/detail package
Hallo,
I'm currently strugling with the setup of our packages for deployment to a new environment.
We are working with a master/detail package setup. One master package is created that will call all child packages. In the master package we don't have any connection towards our source and/or target databases/sourcesystems.
Everything works fine, however, starting to deploy the whole set of packages, it seems that we don't have the option to set specific properties of our detailed packages, e.g. connection properties. But this is just what we need.
When we are adding a job in the Job Agent for our master package to be scheduled, we want to be able to set all different connection manager properties, not only the one from the master package and definitely the ones from the detailed packages as there we switch the connections from the development environment towards the acceptance environment.
I tried to fix this with parent package variables, but I can't set the password property, only the ServerName and UserName can be set, not the Password.
Anyone an idea what the easiest and best approach is to solve this burden?
Thx
Children packages should use package configuration on their connection strings as well; then when deploying the packages to a different enviroment all you have to do is to change the configuration values.
Be warned that there is a known bug when using package configuration with 'parent variables' that, under certain circustances may prevent you to set connection in children packages properly. See details here: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=126146
Because of that, my recommendation is to define package configurations to set connection strings on every child package(via XML file, SQL server table, env. variable, etc).
"When we are adding a job in the Job Agent for our master package to be scheduled, we want to be able to set all different connection manager properties, not only the one from the master package and definitely the ones from the detailed packages as there we switch the connections from the development environment towards the acceptance environment. "
I think you can only set properties of the invoked package from the command line...as I said before; use configuration packages for that.
Saturday, February 25, 2012
Connection error 40
Hi,
I developed a programm with dot.net 2.0.
On my environment ervy thing works fine.
When I try to use it on the customers envrionment I get the following error
message:
"An error has occured while establishing a connection to the server.
When connecting to SQL Server 2005, this failuer may be cused by the fact
that under the default settings SQL Server does not allow remote connections
(provider Named Pipes Provider, error 40 Could not open a connection to SQL
Server)"
I want to get connect to an SQL 2000 server. Named Pipes and TCP/IP are
enabled on the server.
I use the following connection String:
"Server=server.domain.com; Initial Catalog=database.mdf;;Integrated
Security=False;Connect Timeout=30;Password=password; UID=user"
How can I solve this problem?
TIA
Marcus MngelCheck your connection string, it doesn't look right. I've never seen the
keys "UID" and "Password" used in the same connection string, and unless
you're using Express Edition, you dont need .mdf on the end of your DB name.
Check out this site for help on your connection string:
http://www.connectionstrings.com/
My guess is it should look something like this:
"Server=server.domain.com;Database=database;User ID=user;Password=password;"
"Marcus Mngel" <nc-maengema@.netcologne.de> wrote in message
news:eht7n6$t4t$1@.newsreader2.netcologne.de...
> Hi,
> I developed a programm with dot.net 2.0.
> On my environment ervy thing works fine.
> When I try to use it on the customers envrionment I get the following
> error
> message:
> "An error has occured while establishing a connection to the server.
> When connecting to SQL Server 2005, this failuer may be cused by the fact
> that under the default settings SQL Server does not allow remote
> connections
> (provider Named Pipes Provider, error 40 Could not open a connection to
> SQL
> Server)"
> I want to get connect to an SQL 2000 server. Named Pipes and TCP/IP are
> enabled on the server.
> I use the following connection String:
> "Server=server.domain.com; Initial Catalog=database.mdf;;Integrated
> Security=False;Connect Timeout=30;Password=password; UID=user"
> How can I solve this problem?
> TIA
> Marcus Mngel
>
>
I developed a programm with dot.net 2.0.
On my environment ervy thing works fine.
When I try to use it on the customers envrionment I get the following error
message:
"An error has occured while establishing a connection to the server.
When connecting to SQL Server 2005, this failuer may be cused by the fact
that under the default settings SQL Server does not allow remote connections
(provider Named Pipes Provider, error 40 Could not open a connection to SQL
Server)"
I want to get connect to an SQL 2000 server. Named Pipes and TCP/IP are
enabled on the server.
I use the following connection String:
"Server=server.domain.com; Initial Catalog=database.mdf;;Integrated
Security=False;Connect Timeout=30;Password=password; UID=user"
How can I solve this problem?
TIA
Marcus MngelCheck your connection string, it doesn't look right. I've never seen the
keys "UID" and "Password" used in the same connection string, and unless
you're using Express Edition, you dont need .mdf on the end of your DB name.
Check out this site for help on your connection string:
http://www.connectionstrings.com/
My guess is it should look something like this:
"Server=server.domain.com;Database=database;User ID=user;Password=password;"
"Marcus Mngel" <nc-maengema@.netcologne.de> wrote in message
news:eht7n6$t4t$1@.newsreader2.netcologne.de...
> Hi,
> I developed a programm with dot.net 2.0.
> On my environment ervy thing works fine.
> When I try to use it on the customers envrionment I get the following
> error
> message:
> "An error has occured while establishing a connection to the server.
> When connecting to SQL Server 2005, this failuer may be cused by the fact
> that under the default settings SQL Server does not allow remote
> connections
> (provider Named Pipes Provider, error 40 Could not open a connection to
> SQL
> Server)"
> I want to get connect to an SQL 2000 server. Named Pipes and TCP/IP are
> enabled on the server.
> I use the following connection String:
> "Server=server.domain.com; Initial Catalog=database.mdf;;Integrated
> Security=False;Connect Timeout=30;Password=password; UID=user"
> How can I solve this problem?
> TIA
> Marcus Mngel
>
>
Connection error - please help
I'm setting up a development environment on XP Pro. I'm working with classi
c
ASP. IIS is working great, but when trying to connect to my SQL Server
Database, I get:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access
denied.
I've checked and re-checked both the name of the database and server, plus
everything looks configured correctly in Enterprise Manager (SQL server and
Windows is checked).
In ODBC, after I configure my System DSN, I test it and it connects
correctly. But this dang error persists. I'm at my wits end with it all,
can you help?
Any comments would be very very appreciated.
Thank you.Try making a network trace from the IIS machine to SQL and review the
traffic.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Why IIS machine, what is the relation between IIS and SQL
server here? What kind of trace should I do, can you
explain it in a simple way.
Thanks a lot-Rob
>--Original Message--
>Try making a network trace from the IIS machine to SQL
and review the
>traffic.
>Thanks,
>Kevin McDonnell
>Microsoft Corporation
>This posting is provided AS IS with no warranties, and
confers no rights.
>
>.
>|||IIS is the client to SQL. I"m asuming that they are two different machines.
client -->IIS-->SQL
IIS is opening and closing all the connection to SQL, not the client
browser. So, making a network trace from IIS will show the traffic to the
server.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||I have the same problem. Help.
****************************************
******************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET
resources...
c
ASP. IIS is working great, but when trying to connect to my SQL Server
Database, I get:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access
denied.
I've checked and re-checked both the name of the database and server, plus
everything looks configured correctly in Enterprise Manager (SQL server and
Windows is checked).
In ODBC, after I configure my System DSN, I test it and it connects
correctly. But this dang error persists. I'm at my wits end with it all,
can you help?
Any comments would be very very appreciated.
Thank you.Try making a network trace from the IIS machine to SQL and review the
traffic.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Why IIS machine, what is the relation between IIS and SQL
server here? What kind of trace should I do, can you
explain it in a simple way.
Thanks a lot-Rob
>--Original Message--
>Try making a network trace from the IIS machine to SQL
and review the
>traffic.
>Thanks,
>Kevin McDonnell
>Microsoft Corporation
>This posting is provided AS IS with no warranties, and
confers no rights.
>
>.
>|||IIS is the client to SQL. I"m asuming that they are two different machines.
client -->IIS-->SQL
IIS is opening and closing all the connection to SQL, not the client
browser. So, making a network trace from IIS will show the traffic to the
server.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||I have the same problem. Help.
****************************************
******************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET
resources...
Connection error - please help
I'm setting up a development environment on XP Pro. I'm working with classic
ASP. IIS is working great, but when trying to connect to my SQL Server
Database, I get:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied.
I've checked and re-checked both the name of the database and server, plus
everything looks configured correctly in Enterprise Manager (SQL server and
Windows is checked).
In ODBC, after I configure my System DSN, I test it and it connects
correctly. But this dang error persists. I'm at my wits end with it all,
can you help?
Any comments would be very very appreciated.
Thank you.
Try making a network trace from the IIS machine to SQL and review the
traffic.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||Why IIS machine, what is the relation between IIS and SQL
server here? What kind of trace should I do, can you
explain it in a simple way.
Thanks a lot-Rob
>--Original Message--
>Try making a network trace from the IIS machine to SQL
and review the
>traffic.
>Thanks,
>Kevin McDonnell
>Microsoft Corporation
>This posting is provided AS IS with no warranties, and
confers no rights.
>
>.
>
|||IIS is the client to SQL. I"m asuming that they are two different machines.
client -->IIS-->SQL
IIS is opening and closing all the connection to SQL, not the client
browser. So, making a network trace from IIS will show the traffic to the
server.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||I have the same problem. Help.
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
ASP. IIS is working great, but when trying to connect to my SQL Server
Database, I get:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied.
I've checked and re-checked both the name of the database and server, plus
everything looks configured correctly in Enterprise Manager (SQL server and
Windows is checked).
In ODBC, after I configure my System DSN, I test it and it connects
correctly. But this dang error persists. I'm at my wits end with it all,
can you help?
Any comments would be very very appreciated.
Thank you.
Try making a network trace from the IIS machine to SQL and review the
traffic.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||Why IIS machine, what is the relation between IIS and SQL
server here? What kind of trace should I do, can you
explain it in a simple way.
Thanks a lot-Rob
>--Original Message--
>Try making a network trace from the IIS machine to SQL
and review the
>traffic.
>Thanks,
>Kevin McDonnell
>Microsoft Corporation
>This posting is provided AS IS with no warranties, and
confers no rights.
>
>.
>
|||IIS is the client to SQL. I"m asuming that they are two different machines.
client -->IIS-->SQL
IIS is opening and closing all the connection to SQL, not the client
browser. So, making a network trace from IIS will show the traffic to the
server.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||I have the same problem. Help.
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
Sunday, February 19, 2012
Connection between two domains
Hi All,
We have two different domains in our environment, say ABC and XYZ, and they
are not trusted. I login into my PC using ABC domain .
I have windows authenticated login in SQLServer that is in XYZ domain.
Can anyone tell me how I can connect to SQL server that is in different
domain using Enterprise Manager or query analyzer?
Thanks,
VinodHi,
You can try doing a Run As ...
Shift + Right Click on EM shortcut and select Run As ...
Enter your other domain user credentials in the form:
domain\username
password
I'm not 100% sure that this will work though. Is your computer a member of
both domains?
It will somehow have to authenticate your credentials with the other domain.
HTH
Dan Artuso
"VM" <VM@.discussions.microsoft.com> wrote in message
news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
> Hi All,
> We have two different domains in our environment, say ABC and XYZ, and
> they
> are not trusted. I login into my PC using ABC domain .
> I have windows authenticated login in SQLServer that is in XYZ domain.
> Can anyone tell me how I can connect to SQL server that is in different
> domain using Enterprise Manager or query analyzer?
> Thanks,
> Vinod
>|||I believe that your only option is to create the same account (and same pass
word) in both domains.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"VM" <VM@.discussions.microsoft.com> wrote in message
news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
> Hi All,
> We have two different domains in our environment, say ABC and XYZ, and the
y
> are not trusted. I login into my PC using ABC domain .
> I have windows authenticated login in SQLServer that is in XYZ domain.
> Can anyone tell me how I can connect to SQL server that is in different
> domain using Enterprise Manager or query analyzer?
> Thanks,
> Vinod
>|||Hi Dan,
Thanks for the info. This is working. But it is failing for SQLServers
that are in ABC domain. It looks like I have to maintain two different
shortcuts for Enterprise manager one for each domain.
Thanks,
Vinod
"dan artuso" wrote:
> Hi,
> You can try doing a Run As ...
> Shift + Right Click on EM shortcut and select Run As ...
> Enter your other domain user credentials in the form:
> domain\username
> password
> I'm not 100% sure that this will work though. Is your computer a member of
> both domains?
> It will somehow have to authenticate your credentials with the other domai
n.
> --
> HTH
> Dan Artuso
>
> "VM" <VM@.discussions.microsoft.com> wrote in message
> news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
>
>|||Hi Tibor,
I tried using the same account and same passwords in both the domains, but
that didnot work.
Thanks,
Vinod
"Tibor Karaszi" wrote:
> I believe that your only option is to create the same account (and same pa
ssword) in both domains.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "VM" <VM@.discussions.microsoft.com> wrote in message
> news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
>|||Hi,
Yes, you would never be able to see servers from both domains in one
instance of EM.
HTH
Dan Artuso
"VM" <VM@.discussions.microsoft.com> wrote in message
news:63AA4081-792D-4267-8347-DAE6F36A5716@.microsoft.com...[vbcol=seagreen]
> Hi Dan,
> Thanks for the info. This is working. But it is failing for SQLServers
> that are in ABC domain. It looks like I have to maintain two different
> shortcuts for Enterprise manager one for each domain.
> Thanks,
> Vinod
> "dan artuso" wrote:
>
We have two different domains in our environment, say ABC and XYZ, and they
are not trusted. I login into my PC using ABC domain .
I have windows authenticated login in SQLServer that is in XYZ domain.
Can anyone tell me how I can connect to SQL server that is in different
domain using Enterprise Manager or query analyzer?
Thanks,
VinodHi,
You can try doing a Run As ...
Shift + Right Click on EM shortcut and select Run As ...
Enter your other domain user credentials in the form:
domain\username
password
I'm not 100% sure that this will work though. Is your computer a member of
both domains?
It will somehow have to authenticate your credentials with the other domain.
HTH
Dan Artuso
"VM" <VM@.discussions.microsoft.com> wrote in message
news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
> Hi All,
> We have two different domains in our environment, say ABC and XYZ, and
> they
> are not trusted. I login into my PC using ABC domain .
> I have windows authenticated login in SQLServer that is in XYZ domain.
> Can anyone tell me how I can connect to SQL server that is in different
> domain using Enterprise Manager or query analyzer?
> Thanks,
> Vinod
>|||I believe that your only option is to create the same account (and same pass
word) in both domains.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"VM" <VM@.discussions.microsoft.com> wrote in message
news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
> Hi All,
> We have two different domains in our environment, say ABC and XYZ, and the
y
> are not trusted. I login into my PC using ABC domain .
> I have windows authenticated login in SQLServer that is in XYZ domain.
> Can anyone tell me how I can connect to SQL server that is in different
> domain using Enterprise Manager or query analyzer?
> Thanks,
> Vinod
>|||Hi Dan,
Thanks for the info. This is working. But it is failing for SQLServers
that are in ABC domain. It looks like I have to maintain two different
shortcuts for Enterprise manager one for each domain.
Thanks,
Vinod
"dan artuso" wrote:
> Hi,
> You can try doing a Run As ...
> Shift + Right Click on EM shortcut and select Run As ...
> Enter your other domain user credentials in the form:
> domain\username
> password
> I'm not 100% sure that this will work though. Is your computer a member of
> both domains?
> It will somehow have to authenticate your credentials with the other domai
n.
> --
> HTH
> Dan Artuso
>
> "VM" <VM@.discussions.microsoft.com> wrote in message
> news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
>
>|||Hi Tibor,
I tried using the same account and same passwords in both the domains, but
that didnot work.
Thanks,
Vinod
"Tibor Karaszi" wrote:
> I believe that your only option is to create the same account (and same pa
ssword) in both domains.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "VM" <VM@.discussions.microsoft.com> wrote in message
> news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
>|||Hi,
Yes, you would never be able to see servers from both domains in one
instance of EM.
HTH
Dan Artuso
"VM" <VM@.discussions.microsoft.com> wrote in message
news:63AA4081-792D-4267-8347-DAE6F36A5716@.microsoft.com...[vbcol=seagreen]
> Hi Dan,
> Thanks for the info. This is working. But it is failing for SQLServers
> that are in ABC domain. It looks like I have to maintain two different
> shortcuts for Enterprise manager one for each domain.
> Thanks,
> Vinod
> "dan artuso" wrote:
>
Connection between two domains
Hi All,
We have two different domains in our environment, say ABC and XYZ, and they
are not trusted. I login into my PC using ABC domain .
I have windows authenticated login in SQLServer that is in XYZ domain.
Can anyone tell me how I can connect to SQL server that is in different
domain using Enterprise Manager or query analyzer?
Thanks,
VinodHi,
You can try doing a Run As ...
Shift + Right Click on EM shortcut and select Run As ...
Enter your other domain user credentials in the form:
domain\username
password
I'm not 100% sure that this will work though. Is your computer a member of
both domains?
It will somehow have to authenticate your credentials with the other domain.
--
HTH
Dan Artuso
"VM" <VM@.discussions.microsoft.com> wrote in message
news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
> Hi All,
> We have two different domains in our environment, say ABC and XYZ, and
> they
> are not trusted. I login into my PC using ABC domain .
> I have windows authenticated login in SQLServer that is in XYZ domain.
> Can anyone tell me how I can connect to SQL server that is in different
> domain using Enterprise Manager or query analyzer?
> Thanks,
> Vinod
>|||I believe that your only option is to create the same account (and same password) in both domains.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"VM" <VM@.discussions.microsoft.com> wrote in message
news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
> Hi All,
> We have two different domains in our environment, say ABC and XYZ, and they
> are not trusted. I login into my PC using ABC domain .
> I have windows authenticated login in SQLServer that is in XYZ domain.
> Can anyone tell me how I can connect to SQL server that is in different
> domain using Enterprise Manager or query analyzer?
> Thanks,
> Vinod
>|||Hi Dan,
Thanks for the info. This is working. But it is failing for SQLServers
that are in ABC domain. It looks like I have to maintain two different
shortcuts for Enterprise manager one for each domain.
Thanks,
Vinod
"dan artuso" wrote:
> Hi,
> You can try doing a Run As ...
> Shift + Right Click on EM shortcut and select Run As ...
> Enter your other domain user credentials in the form:
> domain\username
> password
> I'm not 100% sure that this will work though. Is your computer a member of
> both domains?
> It will somehow have to authenticate your credentials with the other domain.
> --
> HTH
> Dan Artuso
>
> "VM" <VM@.discussions.microsoft.com> wrote in message
> news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
> > Hi All,
> >
> > We have two different domains in our environment, say ABC and XYZ, and
> > they
> > are not trusted. I login into my PC using ABC domain .
> >
> > I have windows authenticated login in SQLServer that is in XYZ domain.
> >
> > Can anyone tell me how I can connect to SQL server that is in different
> > domain using Enterprise Manager or query analyzer?
> >
> > Thanks,
> > Vinod
> >
>
>|||Hi Tibor,
I tried using the same account and same passwords in both the domains, but
that didnot work.
Thanks,
Vinod
"Tibor Karaszi" wrote:
> I believe that your only option is to create the same account (and same password) in both domains.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "VM" <VM@.discussions.microsoft.com> wrote in message
> news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
> > Hi All,
> >
> > We have two different domains in our environment, say ABC and XYZ, and they
> > are not trusted. I login into my PC using ABC domain .
> >
> > I have windows authenticated login in SQLServer that is in XYZ domain.
> >
> > Can anyone tell me how I can connect to SQL server that is in different
> > domain using Enterprise Manager or query analyzer?
> >
> > Thanks,
> > Vinod
> >
>|||Hi,
Yes, you would never be able to see servers from both domains in one
instance of EM.
--
HTH
Dan Artuso
"VM" <VM@.discussions.microsoft.com> wrote in message
news:63AA4081-792D-4267-8347-DAE6F36A5716@.microsoft.com...
> Hi Dan,
> Thanks for the info. This is working. But it is failing for SQLServers
> that are in ABC domain. It looks like I have to maintain two different
> shortcuts for Enterprise manager one for each domain.
> Thanks,
> Vinod
> "dan artuso" wrote:
>> Hi,
>> You can try doing a Run As ...
>> Shift + Right Click on EM shortcut and select Run As ...
>> Enter your other domain user credentials in the form:
>> domain\username
>> password
>> I'm not 100% sure that this will work though. Is your computer a member
>> of
>> both domains?
>> It will somehow have to authenticate your credentials with the other
>> domain.
>> --
>> HTH
>> Dan Artuso
>>
>> "VM" <VM@.discussions.microsoft.com> wrote in message
>> news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
>> > Hi All,
>> >
>> > We have two different domains in our environment, say ABC and XYZ, and
>> > they
>> > are not trusted. I login into my PC using ABC domain .
>> >
>> > I have windows authenticated login in SQLServer that is in XYZ domain.
>> >
>> > Can anyone tell me how I can connect to SQL server that is in different
>> > domain using Enterprise Manager or query analyzer?
>> >
>> > Thanks,
>> > Vinod
>> >
>>
We have two different domains in our environment, say ABC and XYZ, and they
are not trusted. I login into my PC using ABC domain .
I have windows authenticated login in SQLServer that is in XYZ domain.
Can anyone tell me how I can connect to SQL server that is in different
domain using Enterprise Manager or query analyzer?
Thanks,
VinodHi,
You can try doing a Run As ...
Shift + Right Click on EM shortcut and select Run As ...
Enter your other domain user credentials in the form:
domain\username
password
I'm not 100% sure that this will work though. Is your computer a member of
both domains?
It will somehow have to authenticate your credentials with the other domain.
--
HTH
Dan Artuso
"VM" <VM@.discussions.microsoft.com> wrote in message
news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
> Hi All,
> We have two different domains in our environment, say ABC and XYZ, and
> they
> are not trusted. I login into my PC using ABC domain .
> I have windows authenticated login in SQLServer that is in XYZ domain.
> Can anyone tell me how I can connect to SQL server that is in different
> domain using Enterprise Manager or query analyzer?
> Thanks,
> Vinod
>|||I believe that your only option is to create the same account (and same password) in both domains.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"VM" <VM@.discussions.microsoft.com> wrote in message
news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
> Hi All,
> We have two different domains in our environment, say ABC and XYZ, and they
> are not trusted. I login into my PC using ABC domain .
> I have windows authenticated login in SQLServer that is in XYZ domain.
> Can anyone tell me how I can connect to SQL server that is in different
> domain using Enterprise Manager or query analyzer?
> Thanks,
> Vinod
>|||Hi Dan,
Thanks for the info. This is working. But it is failing for SQLServers
that are in ABC domain. It looks like I have to maintain two different
shortcuts for Enterprise manager one for each domain.
Thanks,
Vinod
"dan artuso" wrote:
> Hi,
> You can try doing a Run As ...
> Shift + Right Click on EM shortcut and select Run As ...
> Enter your other domain user credentials in the form:
> domain\username
> password
> I'm not 100% sure that this will work though. Is your computer a member of
> both domains?
> It will somehow have to authenticate your credentials with the other domain.
> --
> HTH
> Dan Artuso
>
> "VM" <VM@.discussions.microsoft.com> wrote in message
> news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
> > Hi All,
> >
> > We have two different domains in our environment, say ABC and XYZ, and
> > they
> > are not trusted. I login into my PC using ABC domain .
> >
> > I have windows authenticated login in SQLServer that is in XYZ domain.
> >
> > Can anyone tell me how I can connect to SQL server that is in different
> > domain using Enterprise Manager or query analyzer?
> >
> > Thanks,
> > Vinod
> >
>
>|||Hi Tibor,
I tried using the same account and same passwords in both the domains, but
that didnot work.
Thanks,
Vinod
"Tibor Karaszi" wrote:
> I believe that your only option is to create the same account (and same password) in both domains.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "VM" <VM@.discussions.microsoft.com> wrote in message
> news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
> > Hi All,
> >
> > We have two different domains in our environment, say ABC and XYZ, and they
> > are not trusted. I login into my PC using ABC domain .
> >
> > I have windows authenticated login in SQLServer that is in XYZ domain.
> >
> > Can anyone tell me how I can connect to SQL server that is in different
> > domain using Enterprise Manager or query analyzer?
> >
> > Thanks,
> > Vinod
> >
>|||Hi,
Yes, you would never be able to see servers from both domains in one
instance of EM.
--
HTH
Dan Artuso
"VM" <VM@.discussions.microsoft.com> wrote in message
news:63AA4081-792D-4267-8347-DAE6F36A5716@.microsoft.com...
> Hi Dan,
> Thanks for the info. This is working. But it is failing for SQLServers
> that are in ABC domain. It looks like I have to maintain two different
> shortcuts for Enterprise manager one for each domain.
> Thanks,
> Vinod
> "dan artuso" wrote:
>> Hi,
>> You can try doing a Run As ...
>> Shift + Right Click on EM shortcut and select Run As ...
>> Enter your other domain user credentials in the form:
>> domain\username
>> password
>> I'm not 100% sure that this will work though. Is your computer a member
>> of
>> both domains?
>> It will somehow have to authenticate your credentials with the other
>> domain.
>> --
>> HTH
>> Dan Artuso
>>
>> "VM" <VM@.discussions.microsoft.com> wrote in message
>> news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
>> > Hi All,
>> >
>> > We have two different domains in our environment, say ABC and XYZ, and
>> > they
>> > are not trusted. I login into my PC using ABC domain .
>> >
>> > I have windows authenticated login in SQLServer that is in XYZ domain.
>> >
>> > Can anyone tell me how I can connect to SQL server that is in different
>> > domain using Enterprise Manager or query analyzer?
>> >
>> > Thanks,
>> > Vinod
>> >
>>
Connection between two domains
Hi All,
We have two different domains in our environment, say ABC and XYZ, and they
are not trusted. I login into my PC using ABC domain .
I have windows authenticated login in SQLServer that is in XYZ domain.
Can anyone tell me how I can connect to SQL server that is in different
domain using Enterprise Manager or query analyzer?
Thanks,
Vinod
Hi,
You can try doing a Run As ...
Shift + Right Click on EM shortcut and select Run As ...
Enter your other domain user credentials in the form:
domain\username
password
I'm not 100% sure that this will work though. Is your computer a member of
both domains?
It will somehow have to authenticate your credentials with the other domain.
HTH
Dan Artuso
"VM" <VM@.discussions.microsoft.com> wrote in message
news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
> Hi All,
> We have two different domains in our environment, say ABC and XYZ, and
> they
> are not trusted. I login into my PC using ABC domain .
> I have windows authenticated login in SQLServer that is in XYZ domain.
> Can anyone tell me how I can connect to SQL server that is in different
> domain using Enterprise Manager or query analyzer?
> Thanks,
> Vinod
>
|||I believe that your only option is to create the same account (and same password) in both domains.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"VM" <VM@.discussions.microsoft.com> wrote in message
news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
> Hi All,
> We have two different domains in our environment, say ABC and XYZ, and they
> are not trusted. I login into my PC using ABC domain .
> I have windows authenticated login in SQLServer that is in XYZ domain.
> Can anyone tell me how I can connect to SQL server that is in different
> domain using Enterprise Manager or query analyzer?
> Thanks,
> Vinod
>
|||Hi Dan,
Thanks for the info. This is working. But it is failing for SQLServers
that are in ABC domain. It looks like I have to maintain two different
shortcuts for Enterprise manager one for each domain.
Thanks,
Vinod
"dan artuso" wrote:
> Hi,
> You can try doing a Run As ...
> Shift + Right Click on EM shortcut and select Run As ...
> Enter your other domain user credentials in the form:
> domain\username
> password
> I'm not 100% sure that this will work though. Is your computer a member of
> both domains?
> It will somehow have to authenticate your credentials with the other domain.
> --
> HTH
> Dan Artuso
>
> "VM" <VM@.discussions.microsoft.com> wrote in message
> news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
>
>
|||Hi Tibor,
I tried using the same account and same passwords in both the domains, but
that didnot work.
Thanks,
Vinod
"Tibor Karaszi" wrote:
> I believe that your only option is to create the same account (and same password) in both domains.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "VM" <VM@.discussions.microsoft.com> wrote in message
> news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
>
|||Hi,
Yes, you would never be able to see servers from both domains in one
instance of EM.
HTH
Dan Artuso
"VM" <VM@.discussions.microsoft.com> wrote in message
news:63AA4081-792D-4267-8347-DAE6F36A5716@.microsoft.com...[vbcol=seagreen]
> Hi Dan,
> Thanks for the info. This is working. But it is failing for SQLServers
> that are in ABC domain. It looks like I have to maintain two different
> shortcuts for Enterprise manager one for each domain.
> Thanks,
> Vinod
> "dan artuso" wrote:
We have two different domains in our environment, say ABC and XYZ, and they
are not trusted. I login into my PC using ABC domain .
I have windows authenticated login in SQLServer that is in XYZ domain.
Can anyone tell me how I can connect to SQL server that is in different
domain using Enterprise Manager or query analyzer?
Thanks,
Vinod
Hi,
You can try doing a Run As ...
Shift + Right Click on EM shortcut and select Run As ...
Enter your other domain user credentials in the form:
domain\username
password
I'm not 100% sure that this will work though. Is your computer a member of
both domains?
It will somehow have to authenticate your credentials with the other domain.
HTH
Dan Artuso
"VM" <VM@.discussions.microsoft.com> wrote in message
news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
> Hi All,
> We have two different domains in our environment, say ABC and XYZ, and
> they
> are not trusted. I login into my PC using ABC domain .
> I have windows authenticated login in SQLServer that is in XYZ domain.
> Can anyone tell me how I can connect to SQL server that is in different
> domain using Enterprise Manager or query analyzer?
> Thanks,
> Vinod
>
|||I believe that your only option is to create the same account (and same password) in both domains.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"VM" <VM@.discussions.microsoft.com> wrote in message
news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
> Hi All,
> We have two different domains in our environment, say ABC and XYZ, and they
> are not trusted. I login into my PC using ABC domain .
> I have windows authenticated login in SQLServer that is in XYZ domain.
> Can anyone tell me how I can connect to SQL server that is in different
> domain using Enterprise Manager or query analyzer?
> Thanks,
> Vinod
>
|||Hi Dan,
Thanks for the info. This is working. But it is failing for SQLServers
that are in ABC domain. It looks like I have to maintain two different
shortcuts for Enterprise manager one for each domain.
Thanks,
Vinod
"dan artuso" wrote:
> Hi,
> You can try doing a Run As ...
> Shift + Right Click on EM shortcut and select Run As ...
> Enter your other domain user credentials in the form:
> domain\username
> password
> I'm not 100% sure that this will work though. Is your computer a member of
> both domains?
> It will somehow have to authenticate your credentials with the other domain.
> --
> HTH
> Dan Artuso
>
> "VM" <VM@.discussions.microsoft.com> wrote in message
> news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
>
>
|||Hi Tibor,
I tried using the same account and same passwords in both the domains, but
that didnot work.
Thanks,
Vinod
"Tibor Karaszi" wrote:
> I believe that your only option is to create the same account (and same password) in both domains.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "VM" <VM@.discussions.microsoft.com> wrote in message
> news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
>
|||Hi,
Yes, you would never be able to see servers from both domains in one
instance of EM.
HTH
Dan Artuso
"VM" <VM@.discussions.microsoft.com> wrote in message
news:63AA4081-792D-4267-8347-DAE6F36A5716@.microsoft.com...[vbcol=seagreen]
> Hi Dan,
> Thanks for the info. This is working. But it is failing for SQLServers
> that are in ABC domain. It looks like I have to maintain two different
> shortcuts for Enterprise manager one for each domain.
> Thanks,
> Vinod
> "dan artuso" wrote:
Subscribe to:
Posts (Atom)