Hi
I'm loged on Workstation as a user EUR\zzzz1 and i use different user
EUR\abc123 to map a drive on remote server SERVER2, SERVER2 is a domain
controler . It works.
On SERVER2 i have SQL Server 2000 with mixed mode authentication.
I have a user abc123 added in Active directory on SERVER2:
SERVER2\abc123. The same user is added in Sql Server with rights etc.
When i lounch Query Analyzer on my Workstation and select Sql
Authentication to use EUR\abc123 user i got message "[Microsoft][ODBC
SQL Server Driver][SQL Server]Login failed for user 'EUR\abc123'"
Why i have no access to sql server ?
regards
m
Hi
You must not use SQL Authentication, as it is a domain account, you need to
select NT Authentication when connecting.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"marta" <grupy_d@.go2.pl> wrote in message
news:1127985222.430902.144700@.o13g2000cwo.googlegr oups.com...
> Hi
> I'm loged on Workstation as a user EUR\zzzz1 and i use different user
> EUR\abc123 to map a drive on remote server SERVER2, SERVER2 is a domain
> controler . It works.
> On SERVER2 i have SQL Server 2000 with mixed mode authentication.
> I have a user abc123 added in Active directory on SERVER2:
> SERVER2\abc123. The same user is added in Sql Server with rights etc.
> When i lounch Query Analyzer on my Workstation and select Sql
> Authentication to use EUR\abc123 user i got message "[Microsoft][ODBC
> SQL Server Driver][SQL Server]Login failed for user 'EUR\abc123'"
> Why i have no access to sql server ?
>
> regards
> m
>
|||Ok now i use windows NT Authentication and i can log in but this way
i'm connected to SERVER2 with user EUR\zzzz1 not abc123... I need to
connect using user abc123. How to do that ?
M.
|||Hi Marta
If EUR\abc123 has been added to the server as a login, you will need SQL
authentication to connect as that login. Are you sure you're using the
right password?
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"marta" <grupy_d@.go2.pl> wrote in message
news:1127989262.660929.186550@.o13g2000cwo.googlegr oups.com...
> Ok now i use windows NT Authentication and i can log in but this way
> i'm connected to SERVER2 with user EUR\zzzz1 not abc123... I need to
> connect using user abc123. How to do that ?
> M.
>
|||Of course i can map a drive using that pass.
The problem is : how to connect to sql server on remote server with
windows authentication, when i am logged on local workstation with
different user.
M
|||You could probably use "Run As" (right-click the shortcut/executable,
and choose "Run as..." from the menu) to run Query Analyzer under the
context of another user, and therefore be able to pass that security
ticket to the SQL Server when you use Windows Authentication. Runas.exe
can also be called from the command line w/ switches. I believe this
functionality is only available from the right-click menu on Windows
2003 and XP - 2000 contains the command line version.
Good luck,
Tony Sebion
"marta" <grupy_d@.go2.pl> wrote in message
news:1128002474.807122.247970@.g14g2000cwa.googlegr oups.com:
> Of course i can map a drive using that pass.
> The problem is : how to connect to sql server on remote server with
> windows authentication, when i am logged on local workstation with
> different user.
> M
|||you can always connect to the ipc share of remote user with the login/pw of
the user you want
NET USE \\REMOTEPUTER\IPC$ /USER:MYUSERNAME "MYPASSWORD"
now event hough your are logged on as user LOCALUSER...any connection to
remote puter will be as MYUSERNAME
get it ?
"marta" <grupy_d@.go2.pl> wrote in message
news:1128002474.807122.247970@.g14g2000cwa.googlegr oups.com...
> Of course i can map a drive using that pass.
> The problem is : how to connect to sql server on remote server with
> windows authentication, when i am logged on local workstation with
> different user.
> M
>
sql
Showing posts with label workstation. Show all posts
Showing posts with label workstation. Show all posts
Wednesday, March 28, 2012
Please help i can't connect....
Hi
I'm loged on Workstation as a user EUR\zzzz1 and i use different user
EUR\abc123 to map a drive on remote server SERVER2, SERVER2 is a domain
controler . It works.
On SERVER2 i have SQL Server 2000 with mixed mode authentication.
I have a user abc123 added in Active directory on SERVER2:
SERVER2\abc123. The same user is added in Sql Server with rights etc.
When i lounch Query Analyzer on my Workstation and select Sql
Authentication to use EUR\abc123 user i got message "[Microsoft][ODB
C
SQL Server Driver][SQL Server]Login failed for user 'EUR\abc123'"
Why i have no access to sql server ?
regards
mHi
You must not use SQL Authentication, as it is a domain account, you need to
select NT Authentication when connecting.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"marta" <grupy_d@.go2.pl> wrote in message
news:1127985222.430902.144700@.o13g2000cwo.googlegroups.com...
> Hi
> I'm loged on Workstation as a user EUR\zzzz1 and i use different user
> EUR\abc123 to map a drive on remote server SERVER2, SERVER2 is a domain
> controler . It works.
> On SERVER2 i have SQL Server 2000 with mixed mode authentication.
> I have a user abc123 added in Active directory on SERVER2:
> SERVER2\abc123. The same user is added in Sql Server with rights etc.
> When i lounch Query Analyzer on my Workstation and select Sql
> Authentication to use EUR\abc123 user i got message "[Microsoft][O
DBC
> SQL Server Driver][SQL Server]Login failed for user 'EUR\abc123'"
> Why i have no access to sql server ?
>
> regards
> m
>|||Ok now i use windows NT Authentication and i can log in but this way
i'm connected to SERVER2 with user EUR\zzzz1 not abc123... I need to
connect using user abc123. How to do that ?
M.|||Hi Marta
If EUR\abc123 has been added to the server as a login, you will need SQL
authentication to connect as that login. Are you sure you're using the
right password?
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"marta" <grupy_d@.go2.pl> wrote in message
news:1127989262.660929.186550@.o13g2000cwo.googlegroups.com...
> Ok now i use windows NT Authentication and i can log in but this way
> i'm connected to SERVER2 with user EUR\zzzz1 not abc123... I need to
> connect using user abc123. How to do that ?
> M.
>|||Of course i can map a drive using that pass.
The problem is : how to connect to sql server on remote server with
windows authentication, when i am logged on local workstation with
different user.
M|||You could probably use "Run As" (right-click the shortcut/executable,
and choose "Run as..." from the menu) to run Query Analyzer under the
context of another user, and therefore be able to pass that security
ticket to the SQL Server when you use Windows Authentication. Runas.exe
can also be called from the command line w/ switches. I believe this
functionality is only available from the right-click menu on Windows
2003 and XP - 2000 contains the command line version.
Good luck,
Tony Sebion
"marta" <grupy_d@.go2.pl> wrote in message
news:1128002474.807122.247970@.g14g2000cwa.googlegroups.com:
> Of course i can map a drive using that pass.
> The problem is : how to connect to sql server on remote server with
> windows authentication, when i am logged on local workstation with
> different user.
> M|||you can always connect to the ipc share of remote user with the login/pw of
the user you want
NET USE \\REMOTEPUTER\IPC$ /USER:MYUSERNAME "MYPASSWORD"
now event hough your are logged on as user LOCALUSER...any connection to
remote puter will be as MYUSERNAME
get it ?
"marta" <grupy_d@.go2.pl> wrote in message
news:1128002474.807122.247970@.g14g2000cwa.googlegroups.com...
> Of course i can map a drive using that pass.
> The problem is : how to connect to sql server on remote server with
> windows authentication, when i am logged on local workstation with
> different user.
> M
>
I'm loged on Workstation as a user EUR\zzzz1 and i use different user
EUR\abc123 to map a drive on remote server SERVER2, SERVER2 is a domain
controler . It works.
On SERVER2 i have SQL Server 2000 with mixed mode authentication.
I have a user abc123 added in Active directory on SERVER2:
SERVER2\abc123. The same user is added in Sql Server with rights etc.
When i lounch Query Analyzer on my Workstation and select Sql
Authentication to use EUR\abc123 user i got message "[Microsoft][ODB
C
SQL Server Driver][SQL Server]Login failed for user 'EUR\abc123'"
Why i have no access to sql server ?
regards
mHi
You must not use SQL Authentication, as it is a domain account, you need to
select NT Authentication when connecting.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"marta" <grupy_d@.go2.pl> wrote in message
news:1127985222.430902.144700@.o13g2000cwo.googlegroups.com...
> Hi
> I'm loged on Workstation as a user EUR\zzzz1 and i use different user
> EUR\abc123 to map a drive on remote server SERVER2, SERVER2 is a domain
> controler . It works.
> On SERVER2 i have SQL Server 2000 with mixed mode authentication.
> I have a user abc123 added in Active directory on SERVER2:
> SERVER2\abc123. The same user is added in Sql Server with rights etc.
> When i lounch Query Analyzer on my Workstation and select Sql
> Authentication to use EUR\abc123 user i got message "[Microsoft][O
DBC
> SQL Server Driver][SQL Server]Login failed for user 'EUR\abc123'"
> Why i have no access to sql server ?
>
> regards
> m
>|||Ok now i use windows NT Authentication and i can log in but this way
i'm connected to SERVER2 with user EUR\zzzz1 not abc123... I need to
connect using user abc123. How to do that ?
M.|||Hi Marta
If EUR\abc123 has been added to the server as a login, you will need SQL
authentication to connect as that login. Are you sure you're using the
right password?
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"marta" <grupy_d@.go2.pl> wrote in message
news:1127989262.660929.186550@.o13g2000cwo.googlegroups.com...
> Ok now i use windows NT Authentication and i can log in but this way
> i'm connected to SERVER2 with user EUR\zzzz1 not abc123... I need to
> connect using user abc123. How to do that ?
> M.
>|||Of course i can map a drive using that pass.
The problem is : how to connect to sql server on remote server with
windows authentication, when i am logged on local workstation with
different user.
M|||You could probably use "Run As" (right-click the shortcut/executable,
and choose "Run as..." from the menu) to run Query Analyzer under the
context of another user, and therefore be able to pass that security
ticket to the SQL Server when you use Windows Authentication. Runas.exe
can also be called from the command line w/ switches. I believe this
functionality is only available from the right-click menu on Windows
2003 and XP - 2000 contains the command line version.
Good luck,
Tony Sebion
"marta" <grupy_d@.go2.pl> wrote in message
news:1128002474.807122.247970@.g14g2000cwa.googlegroups.com:
> Of course i can map a drive using that pass.
> The problem is : how to connect to sql server on remote server with
> windows authentication, when i am logged on local workstation with
> different user.
> M|||you can always connect to the ipc share of remote user with the login/pw of
the user you want
NET USE \\REMOTEPUTER\IPC$ /USER:MYUSERNAME "MYPASSWORD"
now event hough your are logged on as user LOCALUSER...any connection to
remote puter will be as MYUSERNAME
get it ?
"marta" <grupy_d@.go2.pl> wrote in message
news:1128002474.807122.247970@.g14g2000cwa.googlegroups.com...
> Of course i can map a drive using that pass.
> The problem is : how to connect to sql server on remote server with
> windows authentication, when i am logged on local workstation with
> different user.
> M
>
Monday, March 26, 2012
Please help - Installing reporting services on Windows 2000 professional
I have my developer SQL server on a Windows 2000 professional
workstation company will not let me go for a Windows 2003 server.
I am already running ASP.Net Web Matrix which as it own ASP.Net web
server on my PC please clarify if I can install reporting services on
this web server.
Or if I need IIS please help where can I download IIS6 for WIndows
2000 professional did quite a bit of search cannot find the link.
Thanks
KarenOn 4 Apr 2005 14:44:44 -0700, karenmiddleol@.yahoo.com (Karen
Middleton) wrote:
>I have my developer SQL server on a Windows 2000 professional
>workstation company will not let me go for a Windows 2003 server.
>I am already running ASP.Net Web Matrix which as it own ASP.Net web
>server on my PC please clarify if I can install reporting services on
>this web server.
>Or if I need IIS please help where can I download IIS6 for WIndows
>2000 professional did quite a bit of search cannot find the link.
>Thanks
>Karen
Karen,
Windows 2000 uses IIS 5.0.
It's a while since I used Windows 2000 but I think you can install IIS
5.0 using Add/Remove Programs.
Or simply put the Windows CD in the drive and select the option that
allows you to install additional components.
Andrew Watt
MVP - InfoPath|||By default IIS is not running in 2000 Professional. What you need to do is
go to control panel, add remove programs and then on the left pane (I am
remembering this so exactly how you get to it might be off a little) is
something you select to add remove Windows components. That is where you
install IIS. You will be prompted for your Windows install disk (I believe,
it has been awhile). You will also need to install dotnet 1.1 after you get
IIS installed.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Karen Middleton" <karenmiddleol@.yahoo.com> wrote in message
news:a5fd468a.0504041344.1c1540dc@.posting.google.com...
>I have my developer SQL server on a Windows 2000 professional
> workstation company will not let me go for a Windows 2003 server.
> I am already running ASP.Net Web Matrix which as it own ASP.Net web
> server on my PC please clarify if I can install reporting services on
> this web server.
> Or if I need IIS please help where can I download IIS6 for WIndows
> 2000 professional did quite a bit of search cannot find the link.
> Thanks
> Karen|||Andrew
Thanks for the quick feedback.
Will reporting services work on SQL Developer edition and Windows 2000
Professional if I install IIS 5.
Also, can you please recommend some 3rd party authoring tools that
enable quick authoring of reporting services reports and deploying
them if thru Excel it will be very good.
Thanks
Karen
"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in message news:<ude351hpt6vnj5cvf4tmf8scqik66pimbf@.4ax.com>...
> On 4 Apr 2005 14:44:44 -0700, karenmiddleol@.yahoo.com (Karen
> Middleton) wrote:
> >I have my developer SQL server on a Windows 2000 professional
> >workstation company will not let me go for a Windows 2003 server.
> >
> >I am already running ASP.Net Web Matrix which as it own ASP.Net web
> >server on my PC please clarify if I can install reporting services on
> >this web server.
> >
> >Or if I need IIS please help where can I download IIS6 for WIndows
> >2000 professional did quite a bit of search cannot find the link.
> >
> >Thanks
> >Karen
> Karen,
> Windows 2000 uses IIS 5.0.
> It's a while since I used Windows 2000 but I think you can install IIS
> 5.0 using Add/Remove Programs.
> Or simply put the Windows CD in the drive and select the option that
> allows you to install additional components.
> Andrew Watt
> MVP - InfoPath|||This is a great article (this is new since the last time I was on the site).
Definitely worth reading:
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx
As far as the database
http://www.microsoft.com/sql/reporting/productinfo/sysreqs.asp
Note that it says to use the version of database to match the version of RS.
To me that means if you have developer edition of SQL Server that you should
use the same or Reporting Services (i.e. this is good for test and
development only).
MS has a partner page:
http://www.microsoft.com/sql/reporting/partners/default.asp
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Karen Middleton" <karenmiddleol@.yahoo.com> wrote in message
news:a5fd468a.0504041750.300b6c08@.posting.google.com...
> Andrew
> Thanks for the quick feedback.
> Will reporting services work on SQL Developer edition and Windows 2000
> Professional if I install IIS 5.
> Also, can you please recommend some 3rd party authoring tools that
> enable quick authoring of reporting services reports and deploying
> them if thru Excel it will be very good.
> Thanks
> Karen
> "Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in message
> news:<ude351hpt6vnj5cvf4tmf8scqik66pimbf@.4ax.com>...
>> On 4 Apr 2005 14:44:44 -0700, karenmiddleol@.yahoo.com (Karen
>> Middleton) wrote:
>> >I have my developer SQL server on a Windows 2000 professional
>> >workstation company will not let me go for a Windows 2003 server.
>> >
>> >I am already running ASP.Net Web Matrix which as it own ASP.Net web
>> >server on my PC please clarify if I can install reporting services on
>> >this web server.
>> >
>> >Or if I need IIS please help where can I download IIS6 for WIndows
>> >2000 professional did quite a bit of search cannot find the link.
>> >
>> >Thanks
>> >Karen
>> Karen,
>> Windows 2000 uses IIS 5.0.
>> It's a while since I used Windows 2000 but I think you can install IIS
>> 5.0 using Add/Remove Programs.
>> Or simply put the Windows CD in the drive and select the option that
>> allows you to install additional components.
>> Andrew Watt
>> MVP - InfoPath
workstation company will not let me go for a Windows 2003 server.
I am already running ASP.Net Web Matrix which as it own ASP.Net web
server on my PC please clarify if I can install reporting services on
this web server.
Or if I need IIS please help where can I download IIS6 for WIndows
2000 professional did quite a bit of search cannot find the link.
Thanks
KarenOn 4 Apr 2005 14:44:44 -0700, karenmiddleol@.yahoo.com (Karen
Middleton) wrote:
>I have my developer SQL server on a Windows 2000 professional
>workstation company will not let me go for a Windows 2003 server.
>I am already running ASP.Net Web Matrix which as it own ASP.Net web
>server on my PC please clarify if I can install reporting services on
>this web server.
>Or if I need IIS please help where can I download IIS6 for WIndows
>2000 professional did quite a bit of search cannot find the link.
>Thanks
>Karen
Karen,
Windows 2000 uses IIS 5.0.
It's a while since I used Windows 2000 but I think you can install IIS
5.0 using Add/Remove Programs.
Or simply put the Windows CD in the drive and select the option that
allows you to install additional components.
Andrew Watt
MVP - InfoPath|||By default IIS is not running in 2000 Professional. What you need to do is
go to control panel, add remove programs and then on the left pane (I am
remembering this so exactly how you get to it might be off a little) is
something you select to add remove Windows components. That is where you
install IIS. You will be prompted for your Windows install disk (I believe,
it has been awhile). You will also need to install dotnet 1.1 after you get
IIS installed.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Karen Middleton" <karenmiddleol@.yahoo.com> wrote in message
news:a5fd468a.0504041344.1c1540dc@.posting.google.com...
>I have my developer SQL server on a Windows 2000 professional
> workstation company will not let me go for a Windows 2003 server.
> I am already running ASP.Net Web Matrix which as it own ASP.Net web
> server on my PC please clarify if I can install reporting services on
> this web server.
> Or if I need IIS please help where can I download IIS6 for WIndows
> 2000 professional did quite a bit of search cannot find the link.
> Thanks
> Karen|||Andrew
Thanks for the quick feedback.
Will reporting services work on SQL Developer edition and Windows 2000
Professional if I install IIS 5.
Also, can you please recommend some 3rd party authoring tools that
enable quick authoring of reporting services reports and deploying
them if thru Excel it will be very good.
Thanks
Karen
"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in message news:<ude351hpt6vnj5cvf4tmf8scqik66pimbf@.4ax.com>...
> On 4 Apr 2005 14:44:44 -0700, karenmiddleol@.yahoo.com (Karen
> Middleton) wrote:
> >I have my developer SQL server on a Windows 2000 professional
> >workstation company will not let me go for a Windows 2003 server.
> >
> >I am already running ASP.Net Web Matrix which as it own ASP.Net web
> >server on my PC please clarify if I can install reporting services on
> >this web server.
> >
> >Or if I need IIS please help where can I download IIS6 for WIndows
> >2000 professional did quite a bit of search cannot find the link.
> >
> >Thanks
> >Karen
> Karen,
> Windows 2000 uses IIS 5.0.
> It's a while since I used Windows 2000 but I think you can install IIS
> 5.0 using Add/Remove Programs.
> Or simply put the Windows CD in the drive and select the option that
> allows you to install additional components.
> Andrew Watt
> MVP - InfoPath|||This is a great article (this is new since the last time I was on the site).
Definitely worth reading:
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx
As far as the database
http://www.microsoft.com/sql/reporting/productinfo/sysreqs.asp
Note that it says to use the version of database to match the version of RS.
To me that means if you have developer edition of SQL Server that you should
use the same or Reporting Services (i.e. this is good for test and
development only).
MS has a partner page:
http://www.microsoft.com/sql/reporting/partners/default.asp
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Karen Middleton" <karenmiddleol@.yahoo.com> wrote in message
news:a5fd468a.0504041750.300b6c08@.posting.google.com...
> Andrew
> Thanks for the quick feedback.
> Will reporting services work on SQL Developer edition and Windows 2000
> Professional if I install IIS 5.
> Also, can you please recommend some 3rd party authoring tools that
> enable quick authoring of reporting services reports and deploying
> them if thru Excel it will be very good.
> Thanks
> Karen
> "Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in message
> news:<ude351hpt6vnj5cvf4tmf8scqik66pimbf@.4ax.com>...
>> On 4 Apr 2005 14:44:44 -0700, karenmiddleol@.yahoo.com (Karen
>> Middleton) wrote:
>> >I have my developer SQL server on a Windows 2000 professional
>> >workstation company will not let me go for a Windows 2003 server.
>> >
>> >I am already running ASP.Net Web Matrix which as it own ASP.Net web
>> >server on my PC please clarify if I can install reporting services on
>> >this web server.
>> >
>> >Or if I need IIS please help where can I download IIS6 for WIndows
>> >2000 professional did quite a bit of search cannot find the link.
>> >
>> >Thanks
>> >Karen
>> Karen,
>> Windows 2000 uses IIS 5.0.
>> It's a while since I used Windows 2000 but I think you can install IIS
>> 5.0 using Add/Remove Programs.
>> Or simply put the Windows CD in the drive and select the option that
>> allows you to install additional components.
>> Andrew Watt
>> MVP - InfoPath
Subscribe to:
Posts (Atom)