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

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

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

Is it possible to install MS SQL 6.5 on Windows 2003?

Is it possible to install MS SQL 6.5 on Windows 2003?
Can you give some information if it is possible by some Patches or MDAC
?
or any spesific SP?
Thanks
SuhasHi ,
Officially SQL 6.5 is not supported on Windows 2003. But you can still
install SQL 6.5 in Windows 2003.
Thanks
Hari
SQL Server MVP
"suhas" <suhasvpatil@.gmail.com> wrote in message
news:1154430945.301135.302420@.b28g2000cwb.googlegroups.com...
> Is it possible to install MS SQL 6.5 on Windows 2003?
> Can you give some information if it is possible by some Patches or MDAC
> ?
> or any spesific SP?
> Thanks
> Suhas
>

Is it possible to install MS SQL 6.5 on Windows 2003?

Is it possible to install MS SQL 6.5 on Windows 2003?
Can you give some information if it is possible by some Patches or MDAC
?
or any spesific SP?
Thanks
SuhasHi ,
Officially SQL 6.5 is not supported on Windows 2003. But you can still
install SQL 6.5 in Windows 2003.
Thanks
Hari
SQL Server MVP
"suhas" <suhasvpatil@.gmail.com> wrote in message
news:1154430945.301135.302420@.b28g2000cwb.googlegroups.com...

> Is it possible to install MS SQL 6.5 on Windows 2003?
> Can you give some information if it is possible by some Patches or MDAC
> ?
> or any spesific SP?
> Thanks
> Suhas
>

Is it possible to import a backup

Had sql database on a dual boot machine... backed up the sql database ...
now put sql on the windows 2003 server... not sure how to import the databas
e to the new sql server... any suggestions or links would be appreciated."Vincent Keller" <anonymous@.discussions.microsoft.com> wrote in message
news:E69894D4-2385-4242-A34A-016B2AA94462@.microsoft.com...
> Had sql database on a dual boot machine... backed up the sql database
... now put sql on the windows 2003 server... not sure how to import the
database to the new sql server... any suggestions or links would be
appreciated.
>
RESTORE DATABASE dbname
FROM wherever
WITH MOVE logical_name TO 'C:\data\whatever.mdf'
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.647 / Virus Database: 414 - Release Date: 29/03/2004sql

Is it possible to connect to a SQL Server 2005 database usine asp.net v1.1

Hi,

I am having difficulties connecting to a SQL Server 2005 database from an ASP.NET windows application.

Is there any difference in the way the connection string is written when connecting to SQL Server 2005

I have the following connections in my App.config file :

<addkey="Sql2000ConnString"value="Data Source=xxx.xxx; Initial Catalog=Sql2000DB; User ID=UID;Password=Pwd;"/>

<addkey="Sql2005ConnString"value="Data Source=xxx.xxx; Initial Catalog=Sql2005DB;User ID=UID; Password=Pwd;"/>

Every time I run my application it crashes when I try to connect to SQLServer2005 - The connection to the Sql2000 database works without any errors.

Do I need to write the connection differently??

Thanks

Hi kellem,

You would have to post your error message.

Good Coding!

Javier Luna
http://guydotnetxmlwebservices.blogspot.com/

|||Make sure the remote connections are enabled on the SQL2005 instance, which can be checked in Sql Server Surface Area Configuration.

is it possible to change the name of a login is sql server 2000

Hi, is it possible to change the name of a login on sql server 2000 from :
domain1\myuser to domain2\myuser
The authentication is windows mode.
Thank you
Is domain1\myuser owns any objects? If not, probably you can just drop
domain1\myuser and add domain2\myuser.
Lucas
"toutous" wrote:

> Hi, is it possible to change the name of a login on sql server 2000 from :
> domain1\myuser to domain2\myuser
> The authentication is windows mode.
> Thank you
>
|||I need to do a script that automates that for all logins. So yes the logins
might also own objects
Thank you
"Lucas Kartawidjaja" wrote:
[vbcol=seagreen]
> Is domain1\myuser owns any objects? If not, probably you can just drop
> domain1\myuser and add domain2\myuser.
> Lucas
> "toutous" wrote:

is it possible to change the name of a login is sql server 2000

Hi, is it possible to change the name of a login on sql server 2000 from :
domain1\myuser to domain2\myuser
The authentication is windows mode.
Thank youIs domain1\myuser owns any objects? If not, probably you can just drop
domain1\myuser and add domain2\myuser.
Lucas
"toutous" wrote:
> Hi, is it possible to change the name of a login on sql server 2000 from :
> domain1\myuser to domain2\myuser
> The authentication is windows mode.
> Thank you
>|||I need to do a script that automates that for all logins. So yes the logins
might also own objects
Thank you
"Lucas Kartawidjaja" wrote:
> Is domain1\myuser owns any objects? If not, probably you can just drop
> domain1\myuser and add domain2\myuser.
> Lucas
> "toutous" wrote:
> > Hi, is it possible to change the name of a login on sql server 2000 from :
> > domain1\myuser to domain2\myuser
> > The authentication is windows mode.
> > Thank you
> >

is it possible to change the name of a login is sql server 2000

Hi, is it possible to change the name of a login on sql server 2000 from :
domain1\myuser to domain2\myuser
The authentication is windows mode.
Thank youIs domain1\myuser owns any objects? If not, probably you can just drop
domain1\myuser and add domain2\myuser.
Lucas
"toutous" wrote:

> Hi, is it possible to change the name of a login on sql server 2000 from :
> domain1\myuser to domain2\myuser
> The authentication is windows mode.
> Thank you
>

is it possible to change the name of a login is sq

Hi, is it possible to change the name of a login on sql server 2000 from :
domain1\myuser to domain2\myuser
The authentication is windows mode.
Thank you

You cannot change logins for windows accounts.

You will have to add the domain2 logins and then map them to the databases as necessary.

It is possible to change SQL Server logins using sp_changeuserslogin system stored procedure, but I do not believe this will work with windows accounts.

is it possible to change the name of a login is sq

Hi, is it possible to change the name of a login on sql server 2000 from :
domain1\myuser to domain2\myuser
The authentication is windows mode.
Thank you

You cannot change logins for windows accounts.

You will have to add the domain2 logins and then map them to the databases as necessary.

It is possible to change SQL Server logins using sp_changeuserslogin system stored procedure, but I do not believe this will work with windows accounts.

IS it OK to promote an SQL Server to a Domain Controller?

I'm running a Windows 2000 stand alone server with SQL Server 2000 on it. I
need to promote this Server to a Domain Controller for a new domain. I
won't be renaming the server as I know this can cause problems with the SQL
Server (unless it can be easily done).
What kind of problems would I run into? Any steps that need to be followed?
Running DCPromo to create a new Domain should copy the local User database
into the new Domain correct?
ThanksMichael,
From SQL 7.0, this article describes some consequences:
http://msdn.microsoft.com/library/en-us/dnsql7/html/sql7security.asp?frame=true
However, this article suggest that you not do that if you have a choice.
http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/dnnetsec/html/thcmch18.asp
Russell Fields
"Michael" <no@.no.com> wrote in message
news:OeEOCu4rDHA.2392@.TK2MSFTNGP10.phx.gbl...
> I'm running a Windows 2000 stand alone server with SQL Server 2000 on it.
I
> need to promote this Server to a Domain Controller for a new domain. I
> won't be renaming the server as I know this can cause problems with the
SQL
> Server (unless it can be easily done).
> What kind of problems would I run into? Any steps that need to be
followed?
> Running DCPromo to create a new Domain should copy the local User database
> into the new Domain correct?
> Thanks
>|||Hi Michael,
Thank you for using MSDN Newsgroup! It's my pleasure to assist you with your issue.
From your description, I understand that you would like to promote you SQL 2000 Server to a
Domain Controller for a new domain. However, you didn't point out the target of this promotion.
Based on my experience, if you promote a SQL Server to a new domain, the most common
problem you will face is orphan logins and some login permission problems. You can use
sp_grantlogin to manually add the logins into the new domain, and use sp_grantdbaccess to
associate the group members with a user identifier (ID) in each database they need to
access.
Here I provide you with a simple example:
============================USE master
GO
-- Authorize all members of NETDOMAIN\Managers to connect
-- using Windows Authentication.
sp_grantlogin 'NETDOMAIN\Managers'
GO
-- Make pubs the default database for Michael and Northwind the default database for Billy.
sp_defaultdb 'NETDOMAIN\Michael', 'pubs'
sp_defaultdb 'NETDOMAIN\Billy', 'Northwind'
USE pubs
GO
-- Grant a specific member Michael of the group access to
-- pubs with a specific user.
sp_grantdbaccess 'NETDOMAIN\Michael', 'Michael'
USE Northwind
GO
-- Grant a specific member Billy of the group access to
-- Northwind with a specific user.
sp_grantdbaccess 'NETDOMAIN\Billy', 'Billy'
=============================
As to renaming the server, there is also an easy way to perform like that:
-- For a default instance:
sp_dropserver <old_servername>
go
sp_addserver <new_servername> , local
go
-- For a named instance:
sp_dropserver <old_servername\instancename>
go
sp_addserver <new_servername\instancename> , local
go
Michael, does this answer your question? Please apply my suggestion above and let me
know if it helps you resolve your problem.
For more information, you can reference the following articles:
240872 HOW TO: Resolve Permission Issues When You Move a Database Between
http://support.microsoft.com/?id=240872
246133 HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
http://support.microsoft.com/?id=246133
Best regards,
Billy Yao
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.

Is is it advisable for SQL installation folder to be on the same drive as Windows?

Hey Community,

What are the guidelines for installing the SQL Software? Is it bottleneck if both Windows and SQL software are installed on the same drive ( I have all the database .mdfs and and .ldfs on a seperate RAID array)?

thanks,
Saptagiri Tangudu
PNT Marketing Services

Under normal situations, that is not a problem, and is often done that way.

Is DTC required in a SQL 2000/Windows 2003 cluster ?

Hi,
If the SQL environment is not going to use distributed transactions, is it
still necessary to configure a DTC resource on the cluster ?
Thanks
In theory, you can run SQL 2000 clustered without DTC. In practice, it can
limit functionality. I generally configure a DTC resource, just to simplify
installation and maintenance.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"SteveO" <SteveO@.discussions.microsoft.com> wrote in message
news:332351AB-0806-4F9A-94DF-C5F929F5B7D0@.microsoft.com...
> Hi,
> If the SQL environment is not going to use distributed transactions, is it
> still necessary to configure a DTC resource on the cluster ?
> Thanks
|||Yes. You will always configured DTC into the cluster. There are other
services which will use it.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"SteveO" <SteveO@.discussions.microsoft.com> wrote in message
news:332351AB-0806-4F9A-94DF-C5F929F5B7D0@.microsoft.com...
> Hi,
> If the SQL environment is not going to use distributed transactions, is it
> still necessary to configure a DTC resource on the cluster ?
> Thanks
|||I hate to nitpick. But technically, you don't have to if you don't need it.
Linchi
"Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
news:%23YUT2d2IGHA.2912@.tk2msftngp13.phx.gbl...
> Yes. You will always configured DTC into the cluster. There are other
> services which will use it.
> --
> Mike
> http://www.solidqualitylearning.com
> Disclaimer: This communication is an original work and represents my sole
> views on the subject. It does not represent the views of any other person
> or entity either by inference or direct reference.
> "SteveO" <SteveO@.discussions.microsoft.com> wrote in message
> news:332351AB-0806-4F9A-94DF-C5F929F5B7D0@.microsoft.com...
>
|||Well, you'd have to take that up with the failover clustering team. It is
their explicit recommendation for ALL clusters that you will install a
failover cluster instance in.
Not having it there is going to cause several errors during the upgrade as
well as throwing additional errors during a fresh install. I haven't tested
enough permutations to say whether it is needed or not, so at this point, I
tend to trust the people who have spent thousands of hours testing hundreds
of different configurations. They know the code a lot better than me since
they wrote it. If that's the recommendation, I'm sticking into in this
case, because I have no way of proving that it shouldn't be followed.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Linchi Shea" <linchi_shea@.NOSPAMml.om> wrote in message
news:%23Dc$G%238IGHA.2064@.TK2MSFTNGP09.phx.gbl...
>I hate to nitpick. But technically, you don't have to if you don't need it.
> Linchi
> "Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
> news:%23YUT2d2IGHA.2912@.tk2msftngp13.phx.gbl...
>
|||I have 15 SQL Clusters in Production without MSDTC in the cluster, the local
service is disabled. No issues. Our application simply does not use it!
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
"Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
news:uuCH0K9IGHA.1132@.TK2MSFTNGP10.phx.gbl...
> Well, you'd have to take that up with the failover clustering team. It is
> their explicit recommendation for ALL clusters that you will install a
> failover cluster instance in.
> Not having it there is going to cause several errors during the upgrade as
> well as throwing additional errors during a fresh install. I haven't
> tested enough permutations to say whether it is needed or not, so at this
> point, I tend to trust the people who have spent thousands of hours
> testing hundreds of different configurations. They know the code a lot
> better than me since they wrote it. If that's the recommendation, I'm
> sticking into in this case, because I have no way of proving that it
> shouldn't be followed.
> --
> Mike
> http://www.solidqualitylearning.com
> Disclaimer: This communication is an original work and represents my sole
> views on the subject. It does not represent the views of any other person
> or entity either by inference or direct reference.
>
> "Linchi Shea" <linchi_shea@.NOSPAMml.om> wrote in message
> news:%23Dc$G%238IGHA.2064@.TK2MSFTNGP09.phx.gbl...
>
>

Is Cr Rpt 4.6 compatible with Win XP?

Hi
I have a simple , but a very crucial question for us.
Is Crystal Report 4.6 compatible with Windows XP Operating System?
Thanks.
RobertI have reports that have been designed using crystal report 4.5, yet they are opening in Windows XP professional edition.

Is bug described in article 872843 really fixed?

I'm running SQL Server 2000 SP4 with the AWE hotfix (build 2040?) on Windows
Server 2003 with replication.
This morning, my log reader agents failed. In the server log, I saw the
following messages:
SQL Server Assertion: File: <logscan.cpp>, line=1985
Failed Assertion = 'startLSN >= m_curLSN'.
...
SQL Server Assertion: File: <logscan.cpp>, line=2223
Failed Assertion = 'm_noOfScAlloc == 0'.
KB article 872843 says that this is supposed to be fixed in SP4... is it?
Or did it come back in the AWE hotfix?
Regards,
JonathanHello,
KB872843 is included in SQL server 2000 SP4. It appears a new issue and is
not related to the AWE hotfix. Please reInitializing the replication and
then check if the issue still exists.
To find out the cause of this issue we may need to analyze memory dumps,
this work has to be done by contacting Microsoft Customer Service and
Support (CSS). Therefore, if the issue still exists, please contact CSS for
more immediate assistance. For more information on available CSS services,
please click here:
http://support.microsoft.com/default.aspx?scid=fh;EN-US;OfferProPhone#faq607