I'd like to stay logged on to windows as myself, a network user, but
logon to a remote SQL Server on the network as a different network
windows user who has an account on SQL Server with more privileges. Is
this possible? Say I'm logged on as network user mynetwork\myself and
I want to keep that open but logon to SQL Server as network user
mynetwork\otheruser.fumanchu wrote:
> I'd like to stay logged on to windows as myself, a network user, but
> logon to a remote SQL Server on the network as a different network
> windows user who has an account on SQL Server with more privileges. Is
> this possible? Say I'm logged on as network user mynetwork\myself and
> I want to keep that open but logon to SQL Server as network user
> mynetwork\otheruser.
If you have the Run As service running on your Windows 2000/XP client,
you can run an Explorer session as another Windows user and run the
application from that new instance on Explorer. To use teh Run As option
hold down the CTRL key and right-click My Computer on the Desktop.
--
David Gugick
Imceda Software
www.imceda.com
Showing posts with label network. Show all posts
Showing posts with label network. Show all posts
Wednesday, March 28, 2012
Is it possible to logon to SQL Server as a different Windows user?
I'd like to stay logged on to windows as myself, a network user, but
logon to a remote SQL Server on the network as a different network
windows user who has an account on SQL Server with more privileges. Is
this possible? Say I'm logged on as network user mynetwork\myself and
I want to keep that open but logon to SQL Server as network user
mynetwork\otheruser.
fumanchu wrote:
> I'd like to stay logged on to windows as myself, a network user, but
> logon to a remote SQL Server on the network as a different network
> windows user who has an account on SQL Server with more privileges. Is
> this possible? Say I'm logged on as network user mynetwork\myself and
> I want to keep that open but logon to SQL Server as network user
> mynetwork\otheruser.
If you have the Run As service running on your Windows 2000/XP client,
you can run an Explorer session as another Windows user and run the
application from that new instance on Explorer. To use teh Run As option
hold down the CTRL key and right-click My Computer on the Desktop.
David Gugick
Imceda Software
www.imceda.com
logon to a remote SQL Server on the network as a different network
windows user who has an account on SQL Server with more privileges. Is
this possible? Say I'm logged on as network user mynetwork\myself and
I want to keep that open but logon to SQL Server as network user
mynetwork\otheruser.
fumanchu wrote:
> I'd like to stay logged on to windows as myself, a network user, but
> logon to a remote SQL Server on the network as a different network
> windows user who has an account on SQL Server with more privileges. Is
> this possible? Say I'm logged on as network user mynetwork\myself and
> I want to keep that open but logon to SQL Server as network user
> mynetwork\otheruser.
If you have the Run As service running on your Windows 2000/XP client,
you can run an Explorer session as another Windows user and run the
application from that new instance on Explorer. To use teh Run As option
hold down the CTRL key and right-click My Computer on the Desktop.
David Gugick
Imceda Software
www.imceda.com
Is it possible to logon to SQL Server as a different Windows user?
I'd like to stay logged on to windows as myself, a network user, but
logon to a remote SQL Server on the network as a different network
windows user who has an account on SQL Server with more privileges. Is
this possible? Say I'm logged on as network user mynetwork\myself and
I want to keep that open but logon to SQL Server as network user
mynetwork\otheruser.fumanchu wrote:
> I'd like to stay logged on to windows as myself, a network user, but
> logon to a remote SQL Server on the network as a different network
> windows user who has an account on SQL Server with more privileges. Is
> this possible? Say I'm logged on as network user mynetwork\myself and
> I want to keep that open but logon to SQL Server as network user
> mynetwork\otheruser.
If you have the Run As service running on your Windows 2000/XP client,
you can run an Explorer session as another Windows user and run the
application from that new instance on Explorer. To use teh Run As option
hold down the CTRL key and right-click My Computer on the Desktop.
David Gugick
Imceda Software
www.imceda.com
logon to a remote SQL Server on the network as a different network
windows user who has an account on SQL Server with more privileges. Is
this possible? Say I'm logged on as network user mynetwork\myself and
I want to keep that open but logon to SQL Server as network user
mynetwork\otheruser.fumanchu wrote:
> I'd like to stay logged on to windows as myself, a network user, but
> logon to a remote SQL Server on the network as a different network
> windows user who has an account on SQL Server with more privileges. Is
> this possible? Say I'm logged on as network user mynetwork\myself and
> I want to keep that open but logon to SQL Server as network user
> mynetwork\otheruser.
If you have the Run As service running on your Windows 2000/XP client,
you can run an Explorer session as another Windows user and run the
application from that new instance on Explorer. To use teh Run As option
hold down the CTRL key and right-click My Computer on the Desktop.
David Gugick
Imceda Software
www.imceda.com
Is it possible to install the third instance?
Hi everyone,
I have active-passive two node cluster server, it's already installed two
instances with associated two network names and IP addresses. Is there
possible to install the third instance in this cluster server, if give the
specific network name and IP address but no physical node 3?
Regards,
-Chen
Yes. The Active-Passive, Active-Active nomenclature is left over from SQL
7.0 and no longer accurately represents the clustering capabilities of SQL
Server 2000. The short version is you can have up to 16 instances on a
cluster, regardless of the number of nodes. You can choose which instances
should be on which nodes during normal operating conditions. You do have to
have a unique network name, IP address, and disk resource for each instance.
You also need to make sure you have enough physical resources (memory, CPU,
IO capacity) on each node to handle the work load, even during a failover
condition.
The correct current terms are single-instance and multiple-instance
clusters.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Chen" <Chen@.discussions.microsoft.com> wrote in message
news:430C357E-407A-4F73-8764-DDAFD3203DC2@.microsoft.com...
> Hi everyone,
> I have active-passive two node cluster server, it's already installed two
> instances with associated two network names and IP addresses. Is there
> possible to install the third instance in this cluster server, if give the
> specific network name and IP address but no physical node 3?
> Regards,
> -Chen
>
sql
I have active-passive two node cluster server, it's already installed two
instances with associated two network names and IP addresses. Is there
possible to install the third instance in this cluster server, if give the
specific network name and IP address but no physical node 3?
Regards,
-Chen
Yes. The Active-Passive, Active-Active nomenclature is left over from SQL
7.0 and no longer accurately represents the clustering capabilities of SQL
Server 2000. The short version is you can have up to 16 instances on a
cluster, regardless of the number of nodes. You can choose which instances
should be on which nodes during normal operating conditions. You do have to
have a unique network name, IP address, and disk resource for each instance.
You also need to make sure you have enough physical resources (memory, CPU,
IO capacity) on each node to handle the work load, even during a failover
condition.
The correct current terms are single-instance and multiple-instance
clusters.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Chen" <Chen@.discussions.microsoft.com> wrote in message
news:430C357E-407A-4F73-8764-DDAFD3203DC2@.microsoft.com...
> Hi everyone,
> I have active-passive two node cluster server, it's already installed two
> instances with associated two network names and IP addresses. Is there
> possible to install the third instance in this cluster server, if give the
> specific network name and IP address but no physical node 3?
> Regards,
> -Chen
>
sql
Wednesday, March 21, 2012
is it possible to connect to SQL Express without network?
I have notebook, client server application and sql express sp2 on this notebook.
Also, I know domain user login/password,
but I don't know any local user name/password
and I don't know any sql server user name/password.
Domain user is not a local administrator on this notebook.
When notebook connected to the office LAN I am working good with my app-> my sql express as a domain/user.
I'd like to work at home too. I can logon to the system (XP SP2) using domain account when notebook has no network connection. (probably OS caches something)
Is it possible to work with sql express using domain login when no network connection?
PS. old version of this software used MSDE 2000 and it was possible(!).
Thank you.
Yes. SQL Server will still work the same as when you are connected to the office LAN.
Since you log on with your domain credentials (they are cachd on the laptop), the same credentials are used to gain entry to SQL Server.
|||
Arnie Rowland wrote:
Yes. SQL Server will still work the same as when you are connected to the office LAN.
Since you log on with your domain credentials (they are cachd on the laptop), the same credentials are used to gain entry to SQL Server.
Ok, thank you.
I did experiment on 2 workstations.
On one machine ist working good, but on the second machine (no netowrk connection) when I tried to connect to the sql server I have a problem:
SSMS is ocnnecting ok
Application gives me message: cannot generate SSPI context.
What can it be? ...
Thank you
|||Check these souces:
Error -Cannot generate SSPI context
http://support.microsoft.com/Default.aspx?id=811889
http://support.microsoft.com/kb/827422/en-us
http://support.microsoft.com/kb/843248/en-us
http://support.microsoft.com/kb/269541/en-us
http://support.microsoft.com/kb/267588/en-us
http://support.microsoft.com/kb/814401/en-us
http://support.microsoft.com/kb/818173/en-us
Monday, February 20, 2012
Is data sent via DTS encrypted?
Hi all,
I may have a requirement to send data from a SQL Server at site A to an Oracle server at site B. These sites have no network connection between them, and the current suggestion is to use ftp, but the transfer (or username and password) will not be encrypted.
If I create a DTS package transferring data from site A, will that transfer be encrypted?
If not, is there an option with SQL Server DTS to ensure that the data is sent in an encrypted form?
Thanks in advance.No, data isn't automagically encrypted when using DTS. You can use a secure (VPN) link that will encrypt the data. You can put the data into a file and encrypt the file (if you do, compress it first to improve security). You can even create an encryption/decryption DTS task (using VC) and make that part of your DTS toolbox.
-PatP|||Thanks Pat.
Not sure that secure VPN is an option to be honest I'm afraid.
The current favourite is actually to ftp an encrypted .csv, I just wondered if DTS could handle the encryption and make my life easier :-)
BTW, what is VC ( or am I just having a blonde moment? )|||VC is Visual C, part of Microsoft's Visual Studio.
The only way I know to add new tasks to DTS is to write them in Visual C. This allows all kinds of interesting things to happen!
Blonde moments are expected, at least now and then. Unfortunately, I don't have blonde hair (heck, I don't have much hair), so I have to attribute those moments to other things... I'm not quite to the point where I can comfortably attribute them to senior moments yet, although from an IT perspective I'm already somewhat older than dirt!
Yes, go ahead and create the CSV file, then use an Execute Process (effectively a command line) Task to handle the encryption.
-PatP|||Thanks for all the advice Pat. I'll investigate that process.
I too am quite far from blonde, but hey, we all have the moments :-)|||Unless I'm having a Blonde moment I'm almost certain DTS tasks can be written in C# and VBScript (the tools I've used) just to name a few.|||I only know how to create a new task that you can add to the DTS designer Task Panel using Visual C. You can certainly add steps to a DTS package using C# or VBScript, but that is a completely different thing in my opinion.
-PatP|||Why not just create a stored procedure?|||There are more ways to skin that cat than there are cats, but that is no reason to stop looking for new ways!
A script or stored procedue would be easy to implement. A custom task would be more efficient to use, since you could for instance just create a step that generated your data, then feed it to the task just like you do with the FTP task.
I did something like this to move data to our mainframe using the 7.0 EM a while ago, and the task was wildly popular with our power users. It just saved them a lot of monkeying around for a task that they did rather frequently.
-PatP|||I only know how to create a new task that you can add to the DTS designer Task Panel using Visual C. You can certainly add steps to a DTS package using C# or VBScript, but that is a completely different thing in my opinion.
-PatP
Ah.. yes. Your looking to make a new task for the DTS toolbar. I missed that. C# could probably handle it but I have doubts about scripting languages.
I may have a requirement to send data from a SQL Server at site A to an Oracle server at site B. These sites have no network connection between them, and the current suggestion is to use ftp, but the transfer (or username and password) will not be encrypted.
If I create a DTS package transferring data from site A, will that transfer be encrypted?
If not, is there an option with SQL Server DTS to ensure that the data is sent in an encrypted form?
Thanks in advance.No, data isn't automagically encrypted when using DTS. You can use a secure (VPN) link that will encrypt the data. You can put the data into a file and encrypt the file (if you do, compress it first to improve security). You can even create an encryption/decryption DTS task (using VC) and make that part of your DTS toolbox.
-PatP|||Thanks Pat.
Not sure that secure VPN is an option to be honest I'm afraid.
The current favourite is actually to ftp an encrypted .csv, I just wondered if DTS could handle the encryption and make my life easier :-)
BTW, what is VC ( or am I just having a blonde moment? )|||VC is Visual C, part of Microsoft's Visual Studio.
The only way I know to add new tasks to DTS is to write them in Visual C. This allows all kinds of interesting things to happen!
Blonde moments are expected, at least now and then. Unfortunately, I don't have blonde hair (heck, I don't have much hair), so I have to attribute those moments to other things... I'm not quite to the point where I can comfortably attribute them to senior moments yet, although from an IT perspective I'm already somewhat older than dirt!
Yes, go ahead and create the CSV file, then use an Execute Process (effectively a command line) Task to handle the encryption.
-PatP|||Thanks for all the advice Pat. I'll investigate that process.
I too am quite far from blonde, but hey, we all have the moments :-)|||Unless I'm having a Blonde moment I'm almost certain DTS tasks can be written in C# and VBScript (the tools I've used) just to name a few.|||I only know how to create a new task that you can add to the DTS designer Task Panel using Visual C. You can certainly add steps to a DTS package using C# or VBScript, but that is a completely different thing in my opinion.
-PatP|||Why not just create a stored procedure?|||There are more ways to skin that cat than there are cats, but that is no reason to stop looking for new ways!
A script or stored procedue would be easy to implement. A custom task would be more efficient to use, since you could for instance just create a step that generated your data, then feed it to the task just like you do with the FTP task.
I did something like this to move data to our mainframe using the 7.0 EM a while ago, and the task was wildly popular with our power users. It just saved them a lot of monkeying around for a task that they did rather frequently.
-PatP|||I only know how to create a new task that you can add to the DTS designer Task Panel using Visual C. You can certainly add steps to a DTS package using C# or VBScript, but that is a completely different thing in my opinion.
-PatP
Ah.. yes. Your looking to make a new task for the DTS toolbar. I missed that. C# could probably handle it but I have doubts about scripting languages.
Subscribe to:
Posts (Atom)