Hi all,
we have a strange problem in SQL2000 SP3a with SQLTransaction's.
When running SQL Profiler the duration for some SQLTransactions (Commit) are
over six seconds, but the individual SQL statements (sp's) are executed at n
o
time at all.
I've used sp_lock but there are no locks.
Here's an extract from SQLProfiler:
SQLTransaction Commit 6796 5 2005-03-04 15:30:27.887 2005-03-04
15:30:34.683 DTCXact 16335154 sa
Any Ideas ?
Regards Tommy S.Check out master..sysprocesses and find out what the waittypes are
to determine what is causing the extended commit operation.
is the Tlog file on the same disk as the data file . .how busy is the server
?
is this constantly reproduceable? or is it intermittent?
HTH
"Tommy S?derkvist" wrote:
> Hi all,
> we have a strange problem in SQL2000 SP3a with SQLTransaction's.
> When running SQL Profiler the duration for some SQLTransactions (Commit) a
re
> over six seconds, but the individual SQL statements (sp's) are executed at
no
> time at all.
> I've used sp_lock but there are no locks.
> Here's an extract from SQLProfiler:
> SQLTransaction Commit 6796 5 2005-03-04 15:30:27.887 2005-03-04
> 15:30:34.683 DTCXact 16335154 sa
> Any Ideas ?
> Regards Tommy S.
>|||Thanks,
I will try to check out the waittypes the next time I see a long running
transaction.
Yes, the log and the datafile are located on the same disk.
The CPU's (4 of them) are almost idle.
The problem is intermittent and it doesn't seem to be dependent on the
number of users, it can occur at early evening when the number of users
decrease significant.
/Tommy
"Olu Adedeji" wrote:
[vbcol=seagreen]
> Check out master..sysprocesses and find out what the waittypes are
> to determine what is causing the extended commit operation.
> is the Tlog file on the same disk as the data file . .how busy is the serv
er?
> is this constantly reproduceable? or is it intermittent?
> HTH
> "Tommy S?derkvist" wrote:
>|||"Tommy S?derkvist" <TommySderkvist@.discussions.microsoft.com> schrieb im
Newsbeitrag news:72BF587D-E3CF-41FE-9EC8-5681C62E472B@.microsoft.com...
> Thanks,
> I will try to check out the waittypes the next time I see a long running
> transaction.
> Yes, the log and the datafile are located on the same disk.
> The CPU's (4 of them) are almost idle.
> The problem is intermittent and it doesn't seem to be dependent on the
> number of users, it can occur at early evening when the number of users
> decrease significant.
My guess would be that you have an IO bottleneck which makes tx log
writing slow. You could use perfmon to verify this theory.
robert
[vbcol=seagreen]
> /Tommy
> "Olu Adedeji" wrote:
>
server?[vbcol=seagreen]
(Commit) are[vbcol=seagreen]
executed at no[vbcol=seagreen]
Showing posts with label sp3a. Show all posts
Showing posts with label sp3a. Show all posts
Friday, March 30, 2012
Long running SQLTransaction
Hi all,
we have a strange problem in SQL2000 SP3a with SQLTransaction's.
When running SQL Profiler the duration for some SQLTransactions (Commit) are
over six seconds, but the individual SQL statements (sp's) are executed at no
time at all.
I've used sp_lock but there are no locks.
Here's an extract from SQLProfiler:
SQLTransaction Commit 6796 5 2005-03-04 15:30:27.887 2005-03-04
15:30:34.683 DTCXact 16335154 sa
Any Ideas ?
Regards Tommy S.Check out master..sysprocesses and find out what the waittypes are
to determine what is causing the extended commit operation.
is the Tlog file on the same disk as the data file . .how busy is the server?
is this constantly reproduceable? or is it intermittent?
HTH
"Tommy Söderkvist" wrote:
> Hi all,
> we have a strange problem in SQL2000 SP3a with SQLTransaction's.
> When running SQL Profiler the duration for some SQLTransactions (Commit) are
> over six seconds, but the individual SQL statements (sp's) are executed at no
> time at all.
> I've used sp_lock but there are no locks.
> Here's an extract from SQLProfiler:
> SQLTransaction Commit 6796 5 2005-03-04 15:30:27.887 2005-03-04
> 15:30:34.683 DTCXact 16335154 sa
> Any Ideas ?
> Regards Tommy S.
>|||Thanks,
I will try to check out the waittypes the next time I see a long running
transaction.
Yes, the log and the datafile are located on the same disk.
The CPU's (4 of them) are almost idle.
The problem is intermittent and it doesn't seem to be dependent on the
number of users, it can occur at early evening when the number of users
decrease significant.
/Tommy
"Olu Adedeji" wrote:
> Check out master..sysprocesses and find out what the waittypes are
> to determine what is causing the extended commit operation.
> is the Tlog file on the same disk as the data file . .how busy is the server?
> is this constantly reproduceable? or is it intermittent?
> HTH
> "Tommy Söderkvist" wrote:
> > Hi all,
> > we have a strange problem in SQL2000 SP3a with SQLTransaction's.
> > When running SQL Profiler the duration for some SQLTransactions (Commit) are
> > over six seconds, but the individual SQL statements (sp's) are executed at no
> > time at all.
> > I've used sp_lock but there are no locks.
> > Here's an extract from SQLProfiler:
> > SQLTransaction Commit 6796 5 2005-03-04 15:30:27.887 2005-03-04
> > 15:30:34.683 DTCXact 16335154 sa
> > Any Ideas ?
> > Regards Tommy S.
> >|||"Tommy Söderkvist" <TommySderkvist@.discussions.microsoft.com> schrieb im
Newsbeitrag news:72BF587D-E3CF-41FE-9EC8-5681C62E472B@.microsoft.com...
> Thanks,
> I will try to check out the waittypes the next time I see a long running
> transaction.
> Yes, the log and the datafile are located on the same disk.
> The CPU's (4 of them) are almost idle.
> The problem is intermittent and it doesn't seem to be dependent on the
> number of users, it can occur at early evening when the number of users
> decrease significant.
My guess would be that you have an IO bottleneck which makes tx log
writing slow. You could use perfmon to verify this theory.
robert
> /Tommy
> "Olu Adedeji" wrote:
> > Check out master..sysprocesses and find out what the waittypes are
> > to determine what is causing the extended commit operation.
> >
> > is the Tlog file on the same disk as the data file . .how busy is the
server?
> > is this constantly reproduceable? or is it intermittent?
> >
> > HTH
> >
> > "Tommy Söderkvist" wrote:
> >
> > > Hi all,
> > > we have a strange problem in SQL2000 SP3a with SQLTransaction's.
> > > When running SQL Profiler the duration for some SQLTransactions
(Commit) are
> > > over six seconds, but the individual SQL statements (sp's) are
executed at no
> > > time at all.
> > > I've used sp_lock but there are no locks.
> > > Here's an extract from SQLProfiler:
> > > SQLTransaction Commit 6796 5 2005-03-04 15:30:27.887 2005-03-04
> > > 15:30:34.683 DTCXact 16335154 sa
> > > Any Ideas ?
> > > Regards Tommy S.
> > >
we have a strange problem in SQL2000 SP3a with SQLTransaction's.
When running SQL Profiler the duration for some SQLTransactions (Commit) are
over six seconds, but the individual SQL statements (sp's) are executed at no
time at all.
I've used sp_lock but there are no locks.
Here's an extract from SQLProfiler:
SQLTransaction Commit 6796 5 2005-03-04 15:30:27.887 2005-03-04
15:30:34.683 DTCXact 16335154 sa
Any Ideas ?
Regards Tommy S.Check out master..sysprocesses and find out what the waittypes are
to determine what is causing the extended commit operation.
is the Tlog file on the same disk as the data file . .how busy is the server?
is this constantly reproduceable? or is it intermittent?
HTH
"Tommy Söderkvist" wrote:
> Hi all,
> we have a strange problem in SQL2000 SP3a with SQLTransaction's.
> When running SQL Profiler the duration for some SQLTransactions (Commit) are
> over six seconds, but the individual SQL statements (sp's) are executed at no
> time at all.
> I've used sp_lock but there are no locks.
> Here's an extract from SQLProfiler:
> SQLTransaction Commit 6796 5 2005-03-04 15:30:27.887 2005-03-04
> 15:30:34.683 DTCXact 16335154 sa
> Any Ideas ?
> Regards Tommy S.
>|||Thanks,
I will try to check out the waittypes the next time I see a long running
transaction.
Yes, the log and the datafile are located on the same disk.
The CPU's (4 of them) are almost idle.
The problem is intermittent and it doesn't seem to be dependent on the
number of users, it can occur at early evening when the number of users
decrease significant.
/Tommy
"Olu Adedeji" wrote:
> Check out master..sysprocesses and find out what the waittypes are
> to determine what is causing the extended commit operation.
> is the Tlog file on the same disk as the data file . .how busy is the server?
> is this constantly reproduceable? or is it intermittent?
> HTH
> "Tommy Söderkvist" wrote:
> > Hi all,
> > we have a strange problem in SQL2000 SP3a with SQLTransaction's.
> > When running SQL Profiler the duration for some SQLTransactions (Commit) are
> > over six seconds, but the individual SQL statements (sp's) are executed at no
> > time at all.
> > I've used sp_lock but there are no locks.
> > Here's an extract from SQLProfiler:
> > SQLTransaction Commit 6796 5 2005-03-04 15:30:27.887 2005-03-04
> > 15:30:34.683 DTCXact 16335154 sa
> > Any Ideas ?
> > Regards Tommy S.
> >|||"Tommy Söderkvist" <TommySderkvist@.discussions.microsoft.com> schrieb im
Newsbeitrag news:72BF587D-E3CF-41FE-9EC8-5681C62E472B@.microsoft.com...
> Thanks,
> I will try to check out the waittypes the next time I see a long running
> transaction.
> Yes, the log and the datafile are located on the same disk.
> The CPU's (4 of them) are almost idle.
> The problem is intermittent and it doesn't seem to be dependent on the
> number of users, it can occur at early evening when the number of users
> decrease significant.
My guess would be that you have an IO bottleneck which makes tx log
writing slow. You could use perfmon to verify this theory.
robert
> /Tommy
> "Olu Adedeji" wrote:
> > Check out master..sysprocesses and find out what the waittypes are
> > to determine what is causing the extended commit operation.
> >
> > is the Tlog file on the same disk as the data file . .how busy is the
server?
> > is this constantly reproduceable? or is it intermittent?
> >
> > HTH
> >
> > "Tommy Söderkvist" wrote:
> >
> > > Hi all,
> > > we have a strange problem in SQL2000 SP3a with SQLTransaction's.
> > > When running SQL Profiler the duration for some SQLTransactions
(Commit) are
> > > over six seconds, but the individual SQL statements (sp's) are
executed at no
> > > time at all.
> > > I've used sp_lock but there are no locks.
> > > Here's an extract from SQLProfiler:
> > > SQLTransaction Commit 6796 5 2005-03-04 15:30:27.887 2005-03-04
> > > 15:30:34.683 DTCXact 16335154 sa
> > > Any Ideas ?
> > > Regards Tommy S.
> > >
Long running SQLTransaction
Hi all,
we have a strange problem in SQL2000 SP3a with SQLTransaction's.
When running SQL Profiler the duration for some SQLTransactions (Commit) are
over six seconds, but the individual SQL statements (sp's) are executed at no
time at all.
I've used sp_lock but there are no locks.
Here's an extract from SQLProfiler:
SQLTransactionCommit679652005-03-04 15:30:27.8872005-03-04
15:30:34.683DTCXact16335154sa
Any Ideas ?
Regards Tommy S.
Check out master..sysprocesses and find out what the waittypes are
to determine what is causing the extended commit operation.
is the Tlog file on the same disk as the data file . .how busy is the server?
is this constantly reproduceable? or is it intermittent?
HTH
"Tommy S?derkvist" wrote:
> Hi all,
> we have a strange problem in SQL2000 SP3a with SQLTransaction's.
> When running SQL Profiler the duration for some SQLTransactions (Commit) are
> over six seconds, but the individual SQL statements (sp's) are executed at no
> time at all.
> I've used sp_lock but there are no locks.
> Here's an extract from SQLProfiler:
> SQLTransactionCommit679652005-03-04 15:30:27.8872005-03-04
> 15:30:34.683DTCXact16335154sa
> Any Ideas ?
> Regards Tommy S.
>
|||Thanks,
I will try to check out the waittypes the next time I see a long running
transaction.
Yes, the log and the datafile are located on the same disk.
The CPU's (4 of them) are almost idle.
The problem is intermittent and it doesn't seem to be dependent on the
number of users, it can occur at early evening when the number of users
decrease significant.
/Tommy
"Olu Adedeji" wrote:
[vbcol=seagreen]
> Check out master..sysprocesses and find out what the waittypes are
> to determine what is causing the extended commit operation.
> is the Tlog file on the same disk as the data file . .how busy is the server?
> is this constantly reproduceable? or is it intermittent?
> HTH
> "Tommy S?derkvist" wrote:
|||"Tommy S?derkvist" <TommySderkvist@.discussions.microsoft.com> schrieb im
Newsbeitrag news:72BF587D-E3CF-41FE-9EC8-5681C62E472B@.microsoft.com...
> Thanks,
> I will try to check out the waittypes the next time I see a long running
> transaction.
> Yes, the log and the datafile are located on the same disk.
> The CPU's (4 of them) are almost idle.
> The problem is intermittent and it doesn't seem to be dependent on the
> number of users, it can occur at early evening when the number of users
> decrease significant.
My guess would be that you have an IO bottleneck which makes tx log
writing slow. You could use perfmon to verify this theory.
robert
[vbcol=seagreen]
> /Tommy
> "Olu Adedeji" wrote:
server?[vbcol=seagreen]
(Commit) are[vbcol=seagreen]
executed at no[vbcol=seagreen]
we have a strange problem in SQL2000 SP3a with SQLTransaction's.
When running SQL Profiler the duration for some SQLTransactions (Commit) are
over six seconds, but the individual SQL statements (sp's) are executed at no
time at all.
I've used sp_lock but there are no locks.
Here's an extract from SQLProfiler:
SQLTransactionCommit679652005-03-04 15:30:27.8872005-03-04
15:30:34.683DTCXact16335154sa
Any Ideas ?
Regards Tommy S.
Check out master..sysprocesses and find out what the waittypes are
to determine what is causing the extended commit operation.
is the Tlog file on the same disk as the data file . .how busy is the server?
is this constantly reproduceable? or is it intermittent?
HTH
"Tommy S?derkvist" wrote:
> Hi all,
> we have a strange problem in SQL2000 SP3a with SQLTransaction's.
> When running SQL Profiler the duration for some SQLTransactions (Commit) are
> over six seconds, but the individual SQL statements (sp's) are executed at no
> time at all.
> I've used sp_lock but there are no locks.
> Here's an extract from SQLProfiler:
> SQLTransactionCommit679652005-03-04 15:30:27.8872005-03-04
> 15:30:34.683DTCXact16335154sa
> Any Ideas ?
> Regards Tommy S.
>
|||Thanks,
I will try to check out the waittypes the next time I see a long running
transaction.
Yes, the log and the datafile are located on the same disk.
The CPU's (4 of them) are almost idle.
The problem is intermittent and it doesn't seem to be dependent on the
number of users, it can occur at early evening when the number of users
decrease significant.
/Tommy
"Olu Adedeji" wrote:
[vbcol=seagreen]
> Check out master..sysprocesses and find out what the waittypes are
> to determine what is causing the extended commit operation.
> is the Tlog file on the same disk as the data file . .how busy is the server?
> is this constantly reproduceable? or is it intermittent?
> HTH
> "Tommy S?derkvist" wrote:
|||"Tommy S?derkvist" <TommySderkvist@.discussions.microsoft.com> schrieb im
Newsbeitrag news:72BF587D-E3CF-41FE-9EC8-5681C62E472B@.microsoft.com...
> Thanks,
> I will try to check out the waittypes the next time I see a long running
> transaction.
> Yes, the log and the datafile are located on the same disk.
> The CPU's (4 of them) are almost idle.
> The problem is intermittent and it doesn't seem to be dependent on the
> number of users, it can occur at early evening when the number of users
> decrease significant.
My guess would be that you have an IO bottleneck which makes tx log
writing slow. You could use perfmon to verify this theory.
robert
[vbcol=seagreen]
> /Tommy
> "Olu Adedeji" wrote:
server?[vbcol=seagreen]
(Commit) are[vbcol=seagreen]
executed at no[vbcol=seagreen]
Friday, March 9, 2012
Login/connection problem
I have installed SQL Server 2000 SP3a on an XP machine and running in
mixed mode. I log on using a local user name belonging to the
Administrators group.
When I attempt to connect to the DB through .Net with the following
string:
Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
I receive the following error:
Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection.
However, I can login using osql -Uuser and password pwd.
What am I missing here? I am desperate!
TIA, Larzeb
Hello Larzeb,
It seems that SQL client network protocals are not enabled properly. I
suggest that you run
%windir%\SYSTEM32\cliconfg.exe
and enable TCP/IP and named pipes protocals.
Also, please run server network utility to enable the same protocals:
%programfiles%\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
| ath: nntpswitch.com
| From: larzeb <larzeb@.community.nospam>
| Newsgroups: microsoft.public.sqlserver.server
| Subject: Login/connection problem
| Date: Tue, 01 Feb 2005 14:25:15 -0800
| Message-ID: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
| X-Newsreader: Forte Agent 2.0/32.652
| MIME-Version: 1.0
| Content-Type: text/plain; charset=us-ascii
| Content-Transfer-Encoding: 7bit
| Organization: We
| Lines: 20
| NNTP-Posting-Host: 216.251.47.166
| X-Trace: 1107296715 reader1.on.meganewsservers.com 2181
216.251.47.166:52402
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFT NGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsserver s.com!tex
tfeed1.on.meganewsservers.com!meganewsservers.com! reader1.on.meganewsservers
.com!reader1.on.meganewsservers.com!not-for-mail
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376551
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I have installed SQL Server 2000 SP3a on an XP machine and running in
| mixed mode. I log on using a local user name belonging to the
| Administrators group.
|
| When I attempt to connect to the DB through .Net with the following
| string:
|
| Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
| Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
|
| I receive the following error:
|
| Login failed for user '(null)'. Reason: Not associated with a trusted
| SQL Server connection.
|
| However, I can login using osql -Uuser and password pwd.
|
| What am I missing here? I am desperate!
|
| TIA, Larzeb
|
|||Peter,
Both protocols where already set in both the client and server
utilities. Any other ideas?
Larzeb
On Wed, 02 Feb 2005 06:36:42 GMT, petery@.online.microsoft.com (Peter
Yang [MSFT]) wrote:
>Hello Larzeb,
>It seems that SQL client network protocals are not enabled properly. I
>suggest that you run
>%windir%\SYSTEM32\cliconfg.exe
>and enable TCP/IP and named pipes protocals.
>Also, please run server network utility to enable the same protocals:
>%programfiles%\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
>Best Regards,
>Peter Yang
>MCSE2000/2003, MCSA, MCDBA
>Microsoft Online Partner Support
>When responding to posts, please "Reply to Group" via your newsreader so
>that others may learn and benefit from your issue.
>This posting is provided "AS IS" with no warranties, and confers no rights.
>
>--
>| ath: nntpswitch.com
>| From: larzeb <larzeb@.community.nospam>
>| Newsgroups: microsoft.public.sqlserver.server
>| Subject: Login/connection problem
>| Date: Tue, 01 Feb 2005 14:25:15 -0800
>| Message-ID: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
>| X-Newsreader: Forte Agent 2.0/32.652
>| MIME-Version: 1.0
>| Content-Type: text/plain; charset=us-ascii
>| Content-Transfer-Encoding: 7bit
>| Organization: We
>| Lines: 20
>| NNTP-Posting-Host: 216.251.47.166
>| X-Trace: 1107296715 reader1.on.meganewsservers.com 2181
>216.251.47.166:52402
>| Path:
>cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSF TNGP08.phx.gbl!newsfeed00.s
>ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsserver s.com!tex
>tfeed1.on.meganewsservers.com!meganewsservers.com !reader1.on.meganewsservers
>.com!reader1.on.meganewsservers.com!not-for-mail
>| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376551
>| X-Tomcat-NG: microsoft.public.sqlserver.server
>|
>| I have installed SQL Server 2000 SP3a on an XP machine and running in
>| mixed mode. I log on using a local user name belonging to the
>| Administrators group.
>|
>| When I attempt to connect to the DB through .Net with the following
>| string:
>|
>| Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
>| Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
>|
>| I receive the following error:
>|
>| Login failed for user '(null)'. Reason: Not associated with a trusted
>| SQL Server connection.
>|
>| However, I can login using osql -Uuser and password pwd.
>|
>| What am I missing here? I am desperate!
>|
>| TIA, Larzeb
>|
|||Hello Larzeb,
Did you use ASP.net? If so, please check if you encountered the following
issue:
324479 FIX: ASP.NET SQL Server Session State Impersonation Is Lost Under
Load
http://support.microsoft.com/?id=324479
Actually, the error message is most likely caused by Windows
authentication. Could you double check if the error is caused by the
ADO.net call with the sql authention connection string?
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
| ath: nntpswitch.com
| From: larzeb <larzeb@.community.nospam>
| Newsgroups: microsoft.public.sqlserver.server
| Subject: Re: Login/connection problem
| Date: Wed, 02 Feb 2005 09:07:45 -0800
| Message-ID: <652201ph3q6pe86ntu562ms8p05ml68hia@.4ax.com>
| References: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
<BtuQRGPCFHA.768@.cpmsftngxa10.phx.gbl>
| X-Newsreader: Forte Agent 2.0/32.652
| MIME-Version: 1.0
| Content-Type: text/plain; charset=us-ascii
| Content-Transfer-Encoding: 7bit
| Organization: We
| Lines: 80
| NNTP-Posting-Host: 216.251.47.166
| X-Trace: 1107364054 reader1.on.meganewsservers.com 2179
216.251.47.166:59658
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFT NGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsserver s.com!meg
anewsservers.com!reader1.on.meganewsservers.com!re ader1.on.meganewsservers.c
om!not-for-mail
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376672
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Peter,
|
| Both protocols where already set in both the client and server
| utilities. Any other ideas?
|
| Larzeb
| On Wed, 02 Feb 2005 06:36:42 GMT, petery@.online.microsoft.com (Peter
| Yang [MSFT]) wrote:
|
| >Hello Larzeb,
| >
| >It seems that SQL client network protocals are not enabled properly. I
| >suggest that you run
| >
| >%windir%\SYSTEM32\cliconfg.exe
| >
| >and enable TCP/IP and named pipes protocals.
| >
| >Also, please run server network utility to enable the same protocals:
| >
| >%programfiles%\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
| >
| >Best Regards,
| >
| >Peter Yang
| >MCSE2000/2003, MCSA, MCDBA
| >Microsoft Online Partner Support
| >
| >When responding to posts, please "Reply to Group" via your newsreader so
| >that others may learn and benefit from your issue.
| >
| >This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| >
| >--
| >| ath: nntpswitch.com
| >| From: larzeb <larzeb@.community.nospam>
| >| Newsgroups: microsoft.public.sqlserver.server
| >| Subject: Login/connection problem
| >| Date: Tue, 01 Feb 2005 14:25:15 -0800
| >| Message-ID: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
| >| X-Newsreader: Forte Agent 2.0/32.652
| >| MIME-Version: 1.0
| >| Content-Type: text/plain; charset=us-ascii
| >| Content-Transfer-Encoding: 7bit
| >| Organization: We
| >| Lines: 20
| >| NNTP-Posting-Host: 216.251.47.166
| >| X-Trace: 1107296715 reader1.on.meganewsservers.com 2181
| >216.251.47.166:52402
| >| Path:
|
>cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSF TNGP08.phx.gbl!newsfeed00.
s
|
>ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsserver s.com!te
x
|
>tfeed1.on.meganewsservers.com!meganewsservers.com !reader1.on.meganewsserver
s
| >.com!reader1.on.meganewsservers.com!not-for-mail
| >| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376551
| >| X-Tomcat-NG: microsoft.public.sqlserver.server
| >|
| >| I have installed SQL Server 2000 SP3a on an XP machine and running in
| >| mixed mode. I log on using a local user name belonging to the
| >| Administrators group.
| >|
| >| When I attempt to connect to the DB through .Net with the following
| >| string:
| >|
| >| Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
| >| Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
| >|
| >| I receive the following error:
| >|
| >| Login failed for user '(null)'. Reason: Not associated with a trusted
| >| SQL Server connection.
| >|
| >| However, I can login using osql -Uuser and password pwd.
| >|
| >| What am I missing here? I am desperate!
| >|
| >| TIA, Larzeb
| >|
|
|
|||The error message is telling you that, although you passed SQL Server
authentication credentials, the DBMS is actually attempting Integrated
Security=SSPI, that is, Windows Authentication. You should check to make
sure your network account has been granted SQL Server login access or force
SQL Server, and your connection string, to use SQL Server logins.
Sincerely,
Anthony Thomas
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:cbDBaKZCFHA.644@.cpmsftngxa10.phx.gbl...
Hello Larzeb,
Did you use ASP.net? If so, please check if you encountered the following
issue:
324479 FIX: ASP.NET SQL Server Session State Impersonation Is Lost Under
Load
http://support.microsoft.com/?id=324479
Actually, the error message is most likely caused by Windows
authentication. Could you double check if the error is caused by the
ADO.net call with the sql authention connection string?
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
| ath: nntpswitch.com
| From: larzeb <larzeb@.community.nospam>
| Newsgroups: microsoft.public.sqlserver.server
| Subject: Re: Login/connection problem
| Date: Wed, 02 Feb 2005 09:07:45 -0800
| Message-ID: <652201ph3q6pe86ntu562ms8p05ml68hia@.4ax.com>
| References: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
<BtuQRGPCFHA.768@.cpmsftngxa10.phx.gbl>
| X-Newsreader: Forte Agent 2.0/32.652
| MIME-Version: 1.0
| Content-Type: text/plain; charset=us-ascii
| Content-Transfer-Encoding: 7bit
| Organization: We
| Lines: 80
| NNTP-Posting-Host: 216.251.47.166
| X-Trace: 1107364054 reader1.on.meganewsservers.com 2179
216.251.47.166:59658
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFT NGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsserver s.com!meg
anewsservers.com!reader1.on.meganewsservers.com!re ader1.on.meganewsservers.c
om!not-for-mail
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376672
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Peter,
|
| Both protocols where already set in both the client and server
| utilities. Any other ideas?
|
| Larzeb
| On Wed, 02 Feb 2005 06:36:42 GMT, petery@.online.microsoft.com (Peter
| Yang [MSFT]) wrote:
|
| >Hello Larzeb,
| >
| >It seems that SQL client network protocals are not enabled properly. I
| >suggest that you run
| >
| >%windir%\SYSTEM32\cliconfg.exe
| >
| >and enable TCP/IP and named pipes protocals.
| >
| >Also, please run server network utility to enable the same protocals:
| >
| >%programfiles%\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
| >
| >Best Regards,
| >
| >Peter Yang
| >MCSE2000/2003, MCSA, MCDBA
| >Microsoft Online Partner Support
| >
| >When responding to posts, please "Reply to Group" via your newsreader so
| >that others may learn and benefit from your issue.
| >
| >This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| >
| >--
| >| ath: nntpswitch.com
| >| From: larzeb <larzeb@.community.nospam>
| >| Newsgroups: microsoft.public.sqlserver.server
| >| Subject: Login/connection problem
| >| Date: Tue, 01 Feb 2005 14:25:15 -0800
| >| Message-ID: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
| >| X-Newsreader: Forte Agent 2.0/32.652
| >| MIME-Version: 1.0
| >| Content-Type: text/plain; charset=us-ascii
| >| Content-Transfer-Encoding: 7bit
| >| Organization: We
| >| Lines: 20
| >| NNTP-Posting-Host: 216.251.47.166
| >| X-Trace: 1107296715 reader1.on.meganewsservers.com 2181
| >216.251.47.166:52402
| >| Path:
|
>cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSF TNGP08.phx.gbl!newsfeed00.
s
|
>ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsserver s.com!te
x
|
>tfeed1.on.meganewsservers.com!meganewsservers.com !reader1.on.meganewsserver
s
| >.com!reader1.on.meganewsservers.com!not-for-mail
| >| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376551
| >| X-Tomcat-NG: microsoft.public.sqlserver.server
| >|
| >| I have installed SQL Server 2000 SP3a on an XP machine and running in
| >| mixed mode. I log on using a local user name belonging to the
| >| Administrators group.
| >|
| >| When I attempt to connect to the DB through .Net with the following
| >| string:
| >|
| >| Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
| >| Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
| >|
| >| I receive the following error:
| >|
| >| Login failed for user '(null)'. Reason: Not associated with a trusted
| >| SQL Server connection.
| >|
| >| However, I can login using osql -Uuser and password pwd.
| >|
| >| What am I missing here? I am desperate!
| >|
| >| TIA, Larzeb
| >|
|
|
mixed mode. I log on using a local user name belonging to the
Administrators group.
When I attempt to connect to the DB through .Net with the following
string:
Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
I receive the following error:
Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection.
However, I can login using osql -Uuser and password pwd.
What am I missing here? I am desperate!
TIA, Larzeb
Hello Larzeb,
It seems that SQL client network protocals are not enabled properly. I
suggest that you run
%windir%\SYSTEM32\cliconfg.exe
and enable TCP/IP and named pipes protocals.
Also, please run server network utility to enable the same protocals:
%programfiles%\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
| ath: nntpswitch.com
| From: larzeb <larzeb@.community.nospam>
| Newsgroups: microsoft.public.sqlserver.server
| Subject: Login/connection problem
| Date: Tue, 01 Feb 2005 14:25:15 -0800
| Message-ID: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
| X-Newsreader: Forte Agent 2.0/32.652
| MIME-Version: 1.0
| Content-Type: text/plain; charset=us-ascii
| Content-Transfer-Encoding: 7bit
| Organization: We
| Lines: 20
| NNTP-Posting-Host: 216.251.47.166
| X-Trace: 1107296715 reader1.on.meganewsservers.com 2181
216.251.47.166:52402
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFT NGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsserver s.com!tex
tfeed1.on.meganewsservers.com!meganewsservers.com! reader1.on.meganewsservers
.com!reader1.on.meganewsservers.com!not-for-mail
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376551
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I have installed SQL Server 2000 SP3a on an XP machine and running in
| mixed mode. I log on using a local user name belonging to the
| Administrators group.
|
| When I attempt to connect to the DB through .Net with the following
| string:
|
| Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
| Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
|
| I receive the following error:
|
| Login failed for user '(null)'. Reason: Not associated with a trusted
| SQL Server connection.
|
| However, I can login using osql -Uuser and password pwd.
|
| What am I missing here? I am desperate!
|
| TIA, Larzeb
|
|||Peter,
Both protocols where already set in both the client and server
utilities. Any other ideas?
Larzeb
On Wed, 02 Feb 2005 06:36:42 GMT, petery@.online.microsoft.com (Peter
Yang [MSFT]) wrote:
>Hello Larzeb,
>It seems that SQL client network protocals are not enabled properly. I
>suggest that you run
>%windir%\SYSTEM32\cliconfg.exe
>and enable TCP/IP and named pipes protocals.
>Also, please run server network utility to enable the same protocals:
>%programfiles%\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
>Best Regards,
>Peter Yang
>MCSE2000/2003, MCSA, MCDBA
>Microsoft Online Partner Support
>When responding to posts, please "Reply to Group" via your newsreader so
>that others may learn and benefit from your issue.
>This posting is provided "AS IS" with no warranties, and confers no rights.
>
>--
>| ath: nntpswitch.com
>| From: larzeb <larzeb@.community.nospam>
>| Newsgroups: microsoft.public.sqlserver.server
>| Subject: Login/connection problem
>| Date: Tue, 01 Feb 2005 14:25:15 -0800
>| Message-ID: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
>| X-Newsreader: Forte Agent 2.0/32.652
>| MIME-Version: 1.0
>| Content-Type: text/plain; charset=us-ascii
>| Content-Transfer-Encoding: 7bit
>| Organization: We
>| Lines: 20
>| NNTP-Posting-Host: 216.251.47.166
>| X-Trace: 1107296715 reader1.on.meganewsservers.com 2181
>216.251.47.166:52402
>| Path:
>cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSF TNGP08.phx.gbl!newsfeed00.s
>ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsserver s.com!tex
>tfeed1.on.meganewsservers.com!meganewsservers.com !reader1.on.meganewsservers
>.com!reader1.on.meganewsservers.com!not-for-mail
>| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376551
>| X-Tomcat-NG: microsoft.public.sqlserver.server
>|
>| I have installed SQL Server 2000 SP3a on an XP machine and running in
>| mixed mode. I log on using a local user name belonging to the
>| Administrators group.
>|
>| When I attempt to connect to the DB through .Net with the following
>| string:
>|
>| Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
>| Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
>|
>| I receive the following error:
>|
>| Login failed for user '(null)'. Reason: Not associated with a trusted
>| SQL Server connection.
>|
>| However, I can login using osql -Uuser and password pwd.
>|
>| What am I missing here? I am desperate!
>|
>| TIA, Larzeb
>|
|||Hello Larzeb,
Did you use ASP.net? If so, please check if you encountered the following
issue:
324479 FIX: ASP.NET SQL Server Session State Impersonation Is Lost Under
Load
http://support.microsoft.com/?id=324479
Actually, the error message is most likely caused by Windows
authentication. Could you double check if the error is caused by the
ADO.net call with the sql authention connection string?
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
| ath: nntpswitch.com
| From: larzeb <larzeb@.community.nospam>
| Newsgroups: microsoft.public.sqlserver.server
| Subject: Re: Login/connection problem
| Date: Wed, 02 Feb 2005 09:07:45 -0800
| Message-ID: <652201ph3q6pe86ntu562ms8p05ml68hia@.4ax.com>
| References: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
<BtuQRGPCFHA.768@.cpmsftngxa10.phx.gbl>
| X-Newsreader: Forte Agent 2.0/32.652
| MIME-Version: 1.0
| Content-Type: text/plain; charset=us-ascii
| Content-Transfer-Encoding: 7bit
| Organization: We
| Lines: 80
| NNTP-Posting-Host: 216.251.47.166
| X-Trace: 1107364054 reader1.on.meganewsservers.com 2179
216.251.47.166:59658
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFT NGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsserver s.com!meg
anewsservers.com!reader1.on.meganewsservers.com!re ader1.on.meganewsservers.c
om!not-for-mail
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376672
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Peter,
|
| Both protocols where already set in both the client and server
| utilities. Any other ideas?
|
| Larzeb
| On Wed, 02 Feb 2005 06:36:42 GMT, petery@.online.microsoft.com (Peter
| Yang [MSFT]) wrote:
|
| >Hello Larzeb,
| >
| >It seems that SQL client network protocals are not enabled properly. I
| >suggest that you run
| >
| >%windir%\SYSTEM32\cliconfg.exe
| >
| >and enable TCP/IP and named pipes protocals.
| >
| >Also, please run server network utility to enable the same protocals:
| >
| >%programfiles%\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
| >
| >Best Regards,
| >
| >Peter Yang
| >MCSE2000/2003, MCSA, MCDBA
| >Microsoft Online Partner Support
| >
| >When responding to posts, please "Reply to Group" via your newsreader so
| >that others may learn and benefit from your issue.
| >
| >This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| >
| >--
| >| ath: nntpswitch.com
| >| From: larzeb <larzeb@.community.nospam>
| >| Newsgroups: microsoft.public.sqlserver.server
| >| Subject: Login/connection problem
| >| Date: Tue, 01 Feb 2005 14:25:15 -0800
| >| Message-ID: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
| >| X-Newsreader: Forte Agent 2.0/32.652
| >| MIME-Version: 1.0
| >| Content-Type: text/plain; charset=us-ascii
| >| Content-Transfer-Encoding: 7bit
| >| Organization: We
| >| Lines: 20
| >| NNTP-Posting-Host: 216.251.47.166
| >| X-Trace: 1107296715 reader1.on.meganewsservers.com 2181
| >216.251.47.166:52402
| >| Path:
|
>cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSF TNGP08.phx.gbl!newsfeed00.
s
|
>ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsserver s.com!te
x
|
>tfeed1.on.meganewsservers.com!meganewsservers.com !reader1.on.meganewsserver
s
| >.com!reader1.on.meganewsservers.com!not-for-mail
| >| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376551
| >| X-Tomcat-NG: microsoft.public.sqlserver.server
| >|
| >| I have installed SQL Server 2000 SP3a on an XP machine and running in
| >| mixed mode. I log on using a local user name belonging to the
| >| Administrators group.
| >|
| >| When I attempt to connect to the DB through .Net with the following
| >| string:
| >|
| >| Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
| >| Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
| >|
| >| I receive the following error:
| >|
| >| Login failed for user '(null)'. Reason: Not associated with a trusted
| >| SQL Server connection.
| >|
| >| However, I can login using osql -Uuser and password pwd.
| >|
| >| What am I missing here? I am desperate!
| >|
| >| TIA, Larzeb
| >|
|
|
|||The error message is telling you that, although you passed SQL Server
authentication credentials, the DBMS is actually attempting Integrated
Security=SSPI, that is, Windows Authentication. You should check to make
sure your network account has been granted SQL Server login access or force
SQL Server, and your connection string, to use SQL Server logins.
Sincerely,
Anthony Thomas
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:cbDBaKZCFHA.644@.cpmsftngxa10.phx.gbl...
Hello Larzeb,
Did you use ASP.net? If so, please check if you encountered the following
issue:
324479 FIX: ASP.NET SQL Server Session State Impersonation Is Lost Under
Load
http://support.microsoft.com/?id=324479
Actually, the error message is most likely caused by Windows
authentication. Could you double check if the error is caused by the
ADO.net call with the sql authention connection string?
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
| ath: nntpswitch.com
| From: larzeb <larzeb@.community.nospam>
| Newsgroups: microsoft.public.sqlserver.server
| Subject: Re: Login/connection problem
| Date: Wed, 02 Feb 2005 09:07:45 -0800
| Message-ID: <652201ph3q6pe86ntu562ms8p05ml68hia@.4ax.com>
| References: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
<BtuQRGPCFHA.768@.cpmsftngxa10.phx.gbl>
| X-Newsreader: Forte Agent 2.0/32.652
| MIME-Version: 1.0
| Content-Type: text/plain; charset=us-ascii
| Content-Transfer-Encoding: 7bit
| Organization: We
| Lines: 80
| NNTP-Posting-Host: 216.251.47.166
| X-Trace: 1107364054 reader1.on.meganewsservers.com 2179
216.251.47.166:59658
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFT NGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsserver s.com!meg
anewsservers.com!reader1.on.meganewsservers.com!re ader1.on.meganewsservers.c
om!not-for-mail
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376672
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Peter,
|
| Both protocols where already set in both the client and server
| utilities. Any other ideas?
|
| Larzeb
| On Wed, 02 Feb 2005 06:36:42 GMT, petery@.online.microsoft.com (Peter
| Yang [MSFT]) wrote:
|
| >Hello Larzeb,
| >
| >It seems that SQL client network protocals are not enabled properly. I
| >suggest that you run
| >
| >%windir%\SYSTEM32\cliconfg.exe
| >
| >and enable TCP/IP and named pipes protocals.
| >
| >Also, please run server network utility to enable the same protocals:
| >
| >%programfiles%\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
| >
| >Best Regards,
| >
| >Peter Yang
| >MCSE2000/2003, MCSA, MCDBA
| >Microsoft Online Partner Support
| >
| >When responding to posts, please "Reply to Group" via your newsreader so
| >that others may learn and benefit from your issue.
| >
| >This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| >
| >--
| >| ath: nntpswitch.com
| >| From: larzeb <larzeb@.community.nospam>
| >| Newsgroups: microsoft.public.sqlserver.server
| >| Subject: Login/connection problem
| >| Date: Tue, 01 Feb 2005 14:25:15 -0800
| >| Message-ID: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
| >| X-Newsreader: Forte Agent 2.0/32.652
| >| MIME-Version: 1.0
| >| Content-Type: text/plain; charset=us-ascii
| >| Content-Transfer-Encoding: 7bit
| >| Organization: We
| >| Lines: 20
| >| NNTP-Posting-Host: 216.251.47.166
| >| X-Trace: 1107296715 reader1.on.meganewsservers.com 2181
| >216.251.47.166:52402
| >| Path:
|
>cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSF TNGP08.phx.gbl!newsfeed00.
s
|
>ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsserver s.com!te
x
|
>tfeed1.on.meganewsservers.com!meganewsservers.com !reader1.on.meganewsserver
s
| >.com!reader1.on.meganewsservers.com!not-for-mail
| >| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376551
| >| X-Tomcat-NG: microsoft.public.sqlserver.server
| >|
| >| I have installed SQL Server 2000 SP3a on an XP machine and running in
| >| mixed mode. I log on using a local user name belonging to the
| >| Administrators group.
| >|
| >| When I attempt to connect to the DB through .Net with the following
| >| string:
| >|
| >| Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
| >| Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
| >|
| >| I receive the following error:
| >|
| >| Login failed for user '(null)'. Reason: Not associated with a trusted
| >| SQL Server connection.
| >|
| >| However, I can login using osql -Uuser and password pwd.
| >|
| >| What am I missing here? I am desperate!
| >|
| >| TIA, Larzeb
| >|
|
|
Login/connection problem
I have installed SQL Server 2000 SP3a on an XP machine and running in
mixed mode. I log on using a local user name belonging to the
Administrators group.
When I attempt to connect to the DB through .Net with the following
string:
Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
I receive the following error:
Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection.
However, I can login using osql -Uuser and password pwd.
What am I missing here? I am desperate!
TIA, LarzebHello Larzeb,
It seems that SQL client network protocals are not enabled properly. I
suggest that you run
%windir%\SYSTEM32\cliconfg.exe
and enable TCP/IP and named pipes protocals.
Also, please run server network utility to enable the same protocals:
%programfiles%\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
| ath: nntpswitch.com
| From: larzeb <larzeb@.community.nospam>
| Newsgroups: microsoft.public.sqlserver.server
| Subject: Login/connection problem
| Date: Tue, 01 Feb 2005 14:25:15 -0800
| Message-ID: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
| X-Newsreader: Forte Agent 2.0/32.652
| MIME-Version: 1.0
| Content-Type: text/plain; charset=us-ascii
| Content-Transfer-Encoding: 7bit
| Organization: We
| Lines: 20
| NNTP-Posting-Host: 216.251.47.166
| X-Trace: 1107296715 reader1.on.meganewsservers.com 2181
216.251.47.166:52402
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsservers.com!tex
tfeed1.on.meganewsservers.com!meganewsservers.com!reader1.on.meganewsservers
.com!reader1.on.meganewsservers.com!not-for-mail
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376551
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I have installed SQL Server 2000 SP3a on an XP machine and running in
| mixed mode. I log on using a local user name belonging to the
| Administrators group.
|
| When I attempt to connect to the DB through .Net with the following
| string:
|
| Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
| Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
|
| I receive the following error:
|
| Login failed for user '(null)'. Reason: Not associated with a trusted
| SQL Server connection.
|
| However, I can login using osql -Uuser and password pwd.
|
| What am I missing here? I am desperate!
|
| TIA, Larzeb
||||Peter,
Both protocols where already set in both the client and server
utilities. Any other ideas?
Larzeb
On Wed, 02 Feb 2005 06:36:42 GMT, petery@.online.microsoft.com (Peter
Yang [MSFT]) wrote:
>Hello Larzeb,
>It seems that SQL client network protocals are not enabled properly. I
>suggest that you run
>%windir%\SYSTEM32\cliconfg.exe
>and enable TCP/IP and named pipes protocals.
>Also, please run server network utility to enable the same protocals:
>%programfiles%\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
>Best Regards,
>Peter Yang
>MCSE2000/2003, MCSA, MCDBA
>Microsoft Online Partner Support
>When responding to posts, please "Reply to Group" via your newsreader so
>that others may learn and benefit from your issue.
>This posting is provided "AS IS" with no warranties, and confers no rights.
>
>--
>| ath: nntpswitch.com
>| From: larzeb <larzeb@.community.nospam>
>| Newsgroups: microsoft.public.sqlserver.server
>| Subject: Login/connection problem
>| Date: Tue, 01 Feb 2005 14:25:15 -0800
>| Message-ID: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
>| X-Newsreader: Forte Agent 2.0/32.652
>| MIME-Version: 1.0
>| Content-Type: text/plain; charset=us-ascii
>| Content-Transfer-Encoding: 7bit
>| Organization: We
>| Lines: 20
>| NNTP-Posting-Host: 216.251.47.166
>| X-Trace: 1107296715 reader1.on.meganewsservers.com 2181
>216.251.47.166:52402
>| Path:
>cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.
s
>ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsservers.com!te
x
>tfeed1.on.meganewsservers.com!meganewsservers.com!reader1.on.meganewsserver
s
>.com!reader1.on.meganewsservers.com!not-for-mail
>| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376551
>| X-Tomcat-NG: microsoft.public.sqlserver.server
>|
>| I have installed SQL Server 2000 SP3a on an XP machine and running in
>| mixed mode. I log on using a local user name belonging to the
>| Administrators group.
>|
>| When I attempt to connect to the DB through .Net with the following
>| string:
>|
>| Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
>| Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
>|
>| I receive the following error:
>|
>| Login failed for user '(null)'. Reason: Not associated with a trusted
>| SQL Server connection.
>|
>| However, I can login using osql -Uuser and password pwd.
>|
>| What am I missing here? I am desperate!
>|
>| TIA, Larzeb
>||||Hello Larzeb,
Did you use ASP.net? If so, please check if you encountered the following
issue:
324479 FIX: ASP.NET SQL Server Session State Impersonation Is Lost Under
Load
http://support.microsoft.com/?id=324479
Actually, the error message is most likely caused by Windows
authentication. Could you double check if the error is caused by the
ADO.net call with the sql authention connection string?
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
| ath: nntpswitch.com
| From: larzeb <larzeb@.community.nospam>
| Newsgroups: microsoft.public.sqlserver.server
| Subject: Re: Login/connection problem
| Date: Wed, 02 Feb 2005 09:07:45 -0800
| Message-ID: <652201ph3q6pe86ntu562ms8p05ml68hia@.4ax.com>
| References: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
<BtuQRGPCFHA.768@.cpmsftngxa10.phx.gbl>
| X-Newsreader: Forte Agent 2.0/32.652
| MIME-Version: 1.0
| Content-Type: text/plain; charset=us-ascii
| Content-Transfer-Encoding: 7bit
| Organization: We
| Lines: 80
| NNTP-Posting-Host: 216.251.47.166
| X-Trace: 1107364054 reader1.on.meganewsservers.com 2179
216.251.47.166:59658
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsservers.com!meg
anewsservers.com!reader1.on.meganewsservers.com!reader1.on.meganewsservers.c
om!not-for-mail
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376672
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Peter,
|
| Both protocols where already set in both the client and server
| utilities. Any other ideas?
|
| Larzeb
| On Wed, 02 Feb 2005 06:36:42 GMT, petery@.online.microsoft.com (Peter
| Yang [MSFT]) wrote:
|
| >Hello Larzeb,
| >
| >It seems that SQL client network protocals are not enabled properly. I
| >suggest that you run
| >
| >%windir%\SYSTEM32\cliconfg.exe
| >
| >and enable TCP/IP and named pipes protocals.
| >
| >Also, please run server network utility to enable the same protocals:
| >
| >%programfiles%\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
| >
| >Best Regards,
| >
| >Peter Yang
| >MCSE2000/2003, MCSA, MCDBA
| >Microsoft Online Partner Support
| >
| >When responding to posts, please "Reply to Group" via your newsreader so
| >that others may learn and benefit from your issue.
| >
| >This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| >
| >--
| >| ath: nntpswitch.com
| >| From: larzeb <larzeb@.community.nospam>
| >| Newsgroups: microsoft.public.sqlserver.server
| >| Subject: Login/connection problem
| >| Date: Tue, 01 Feb 2005 14:25:15 -0800
| >| Message-ID: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
| >| X-Newsreader: Forte Agent 2.0/32.652
| >| MIME-Version: 1.0
| >| Content-Type: text/plain; charset=us-ascii
| >| Content-Transfer-Encoding: 7bit
| >| Organization: We
| >| Lines: 20
| >| NNTP-Posting-Host: 216.251.47.166
| >| X-Trace: 1107296715 reader1.on.meganewsservers.com 2181
| >216.251.47.166:52402
| >| Path:
|
>cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.
s
|
>ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsservers.com!te
x
|
>tfeed1.on.meganewsservers.com!meganewsservers.com!reader1.on.meganewsserver
s
| >.com!reader1.on.meganewsservers.com!not-for-mail
| >| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376551
| >| X-Tomcat-NG: microsoft.public.sqlserver.server
| >|
| >| I have installed SQL Server 2000 SP3a on an XP machine and running in
| >| mixed mode. I log on using a local user name belonging to the
| >| Administrators group.
| >|
| >| When I attempt to connect to the DB through .Net with the following
| >| string:
| >|
| >| Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
| >| Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
| >|
| >| I receive the following error:
| >|
| >| Login failed for user '(null)'. Reason: Not associated with a trusted
| >| SQL Server connection.
| >|
| >| However, I can login using osql -Uuser and password pwd.
| >|
| >| What am I missing here? I am desperate!
| >|
| >| TIA, Larzeb
| >|
|
||||The error message is telling you that, although you passed SQL Server
authentication credentials, the DBMS is actually attempting Integrated
Security=SSPI, that is, Windows Authentication. You should check to make
sure your network account has been granted SQL Server login access or force
SQL Server, and your connection string, to use SQL Server logins.
Sincerely,
Anthony Thomas
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:cbDBaKZCFHA.644@.cpmsftngxa10.phx.gbl...
Hello Larzeb,
Did you use ASP.net? If so, please check if you encountered the following
issue:
324479 FIX: ASP.NET SQL Server Session State Impersonation Is Lost Under
Load
http://support.microsoft.com/?id=324479
Actually, the error message is most likely caused by Windows
authentication. Could you double check if the error is caused by the
ADO.net call with the sql authention connection string?
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
| ath: nntpswitch.com
| From: larzeb <larzeb@.community.nospam>
| Newsgroups: microsoft.public.sqlserver.server
| Subject: Re: Login/connection problem
| Date: Wed, 02 Feb 2005 09:07:45 -0800
| Message-ID: <652201ph3q6pe86ntu562ms8p05ml68hia@.4ax.com>
| References: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
<BtuQRGPCFHA.768@.cpmsftngxa10.phx.gbl>
| X-Newsreader: Forte Agent 2.0/32.652
| MIME-Version: 1.0
| Content-Type: text/plain; charset=us-ascii
| Content-Transfer-Encoding: 7bit
| Organization: We
| Lines: 80
| NNTP-Posting-Host: 216.251.47.166
| X-Trace: 1107364054 reader1.on.meganewsservers.com 2179
216.251.47.166:59658
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsservers.com!meg
anewsservers.com!reader1.on.meganewsservers.com!reader1.on.meganewsservers.c
om!not-for-mail
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376672
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Peter,
|
| Both protocols where already set in both the client and server
| utilities. Any other ideas?
|
| Larzeb
| On Wed, 02 Feb 2005 06:36:42 GMT, petery@.online.microsoft.com (Peter
| Yang [MSFT]) wrote:
|
| >Hello Larzeb,
| >
| >It seems that SQL client network protocals are not enabled properly. I
| >suggest that you run
| >
| >%windir%\SYSTEM32\cliconfg.exe
| >
| >and enable TCP/IP and named pipes protocals.
| >
| >Also, please run server network utility to enable the same protocals:
| >
| >%programfiles%\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
| >
| >Best Regards,
| >
| >Peter Yang
| >MCSE2000/2003, MCSA, MCDBA
| >Microsoft Online Partner Support
| >
| >When responding to posts, please "Reply to Group" via your newsreader so
| >that others may learn and benefit from your issue.
| >
| >This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| >
| >--
| >| ath: nntpswitch.com
| >| From: larzeb <larzeb@.community.nospam>
| >| Newsgroups: microsoft.public.sqlserver.server
| >| Subject: Login/connection problem
| >| Date: Tue, 01 Feb 2005 14:25:15 -0800
| >| Message-ID: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
| >| X-Newsreader: Forte Agent 2.0/32.652
| >| MIME-Version: 1.0
| >| Content-Type: text/plain; charset=us-ascii
| >| Content-Transfer-Encoding: 7bit
| >| Organization: We
| >| Lines: 20
| >| NNTP-Posting-Host: 216.251.47.166
| >| X-Trace: 1107296715 reader1.on.meganewsservers.com 2181
| >216.251.47.166:52402
| >| Path:
|
>cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.
s
|
>ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsservers.com!te
x
|
>tfeed1.on.meganewsservers.com!meganewsservers.com!reader1.on.meganewsserver
s
| >.com!reader1.on.meganewsservers.com!not-for-mail
| >| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376551
| >| X-Tomcat-NG: microsoft.public.sqlserver.server
| >|
| >| I have installed SQL Server 2000 SP3a on an XP machine and running in
| >| mixed mode. I log on using a local user name belonging to the
| >| Administrators group.
| >|
| >| When I attempt to connect to the DB through .Net with the following
| >| string:
| >|
| >| Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
| >| Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
| >|
| >| I receive the following error:
| >|
| >| Login failed for user '(null)'. Reason: Not associated with a trusted
| >| SQL Server connection.
| >|
| >| However, I can login using osql -Uuser and password pwd.
| >|
| >| What am I missing here? I am desperate!
| >|
| >| TIA, Larzeb
| >|
|
|
mixed mode. I log on using a local user name belonging to the
Administrators group.
When I attempt to connect to the DB through .Net with the following
string:
Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
I receive the following error:
Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection.
However, I can login using osql -Uuser and password pwd.
What am I missing here? I am desperate!
TIA, LarzebHello Larzeb,
It seems that SQL client network protocals are not enabled properly. I
suggest that you run
%windir%\SYSTEM32\cliconfg.exe
and enable TCP/IP and named pipes protocals.
Also, please run server network utility to enable the same protocals:
%programfiles%\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
| ath: nntpswitch.com
| From: larzeb <larzeb@.community.nospam>
| Newsgroups: microsoft.public.sqlserver.server
| Subject: Login/connection problem
| Date: Tue, 01 Feb 2005 14:25:15 -0800
| Message-ID: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
| X-Newsreader: Forte Agent 2.0/32.652
| MIME-Version: 1.0
| Content-Type: text/plain; charset=us-ascii
| Content-Transfer-Encoding: 7bit
| Organization: We
| Lines: 20
| NNTP-Posting-Host: 216.251.47.166
| X-Trace: 1107296715 reader1.on.meganewsservers.com 2181
216.251.47.166:52402
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsservers.com!tex
tfeed1.on.meganewsservers.com!meganewsservers.com!reader1.on.meganewsservers
.com!reader1.on.meganewsservers.com!not-for-mail
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376551
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I have installed SQL Server 2000 SP3a on an XP machine and running in
| mixed mode. I log on using a local user name belonging to the
| Administrators group.
|
| When I attempt to connect to the DB through .Net with the following
| string:
|
| Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
| Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
|
| I receive the following error:
|
| Login failed for user '(null)'. Reason: Not associated with a trusted
| SQL Server connection.
|
| However, I can login using osql -Uuser and password pwd.
|
| What am I missing here? I am desperate!
|
| TIA, Larzeb
||||Peter,
Both protocols where already set in both the client and server
utilities. Any other ideas?
Larzeb
On Wed, 02 Feb 2005 06:36:42 GMT, petery@.online.microsoft.com (Peter
Yang [MSFT]) wrote:
>Hello Larzeb,
>It seems that SQL client network protocals are not enabled properly. I
>suggest that you run
>%windir%\SYSTEM32\cliconfg.exe
>and enable TCP/IP and named pipes protocals.
>Also, please run server network utility to enable the same protocals:
>%programfiles%\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
>Best Regards,
>Peter Yang
>MCSE2000/2003, MCSA, MCDBA
>Microsoft Online Partner Support
>When responding to posts, please "Reply to Group" via your newsreader so
>that others may learn and benefit from your issue.
>This posting is provided "AS IS" with no warranties, and confers no rights.
>
>--
>| ath: nntpswitch.com
>| From: larzeb <larzeb@.community.nospam>
>| Newsgroups: microsoft.public.sqlserver.server
>| Subject: Login/connection problem
>| Date: Tue, 01 Feb 2005 14:25:15 -0800
>| Message-ID: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
>| X-Newsreader: Forte Agent 2.0/32.652
>| MIME-Version: 1.0
>| Content-Type: text/plain; charset=us-ascii
>| Content-Transfer-Encoding: 7bit
>| Organization: We
>| Lines: 20
>| NNTP-Posting-Host: 216.251.47.166
>| X-Trace: 1107296715 reader1.on.meganewsservers.com 2181
>216.251.47.166:52402
>| Path:
>cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.
s
>ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsservers.com!te
x
>tfeed1.on.meganewsservers.com!meganewsservers.com!reader1.on.meganewsserver
s
>.com!reader1.on.meganewsservers.com!not-for-mail
>| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376551
>| X-Tomcat-NG: microsoft.public.sqlserver.server
>|
>| I have installed SQL Server 2000 SP3a on an XP machine and running in
>| mixed mode. I log on using a local user name belonging to the
>| Administrators group.
>|
>| When I attempt to connect to the DB through .Net with the following
>| string:
>|
>| Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
>| Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
>|
>| I receive the following error:
>|
>| Login failed for user '(null)'. Reason: Not associated with a trusted
>| SQL Server connection.
>|
>| However, I can login using osql -Uuser and password pwd.
>|
>| What am I missing here? I am desperate!
>|
>| TIA, Larzeb
>||||Hello Larzeb,
Did you use ASP.net? If so, please check if you encountered the following
issue:
324479 FIX: ASP.NET SQL Server Session State Impersonation Is Lost Under
Load
http://support.microsoft.com/?id=324479
Actually, the error message is most likely caused by Windows
authentication. Could you double check if the error is caused by the
ADO.net call with the sql authention connection string?
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
| ath: nntpswitch.com
| From: larzeb <larzeb@.community.nospam>
| Newsgroups: microsoft.public.sqlserver.server
| Subject: Re: Login/connection problem
| Date: Wed, 02 Feb 2005 09:07:45 -0800
| Message-ID: <652201ph3q6pe86ntu562ms8p05ml68hia@.4ax.com>
| References: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
<BtuQRGPCFHA.768@.cpmsftngxa10.phx.gbl>
| X-Newsreader: Forte Agent 2.0/32.652
| MIME-Version: 1.0
| Content-Type: text/plain; charset=us-ascii
| Content-Transfer-Encoding: 7bit
| Organization: We
| Lines: 80
| NNTP-Posting-Host: 216.251.47.166
| X-Trace: 1107364054 reader1.on.meganewsservers.com 2179
216.251.47.166:59658
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsservers.com!meg
anewsservers.com!reader1.on.meganewsservers.com!reader1.on.meganewsservers.c
om!not-for-mail
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376672
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Peter,
|
| Both protocols where already set in both the client and server
| utilities. Any other ideas?
|
| Larzeb
| On Wed, 02 Feb 2005 06:36:42 GMT, petery@.online.microsoft.com (Peter
| Yang [MSFT]) wrote:
|
| >Hello Larzeb,
| >
| >It seems that SQL client network protocals are not enabled properly. I
| >suggest that you run
| >
| >%windir%\SYSTEM32\cliconfg.exe
| >
| >and enable TCP/IP and named pipes protocals.
| >
| >Also, please run server network utility to enable the same protocals:
| >
| >%programfiles%\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
| >
| >Best Regards,
| >
| >Peter Yang
| >MCSE2000/2003, MCSA, MCDBA
| >Microsoft Online Partner Support
| >
| >When responding to posts, please "Reply to Group" via your newsreader so
| >that others may learn and benefit from your issue.
| >
| >This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| >
| >--
| >| ath: nntpswitch.com
| >| From: larzeb <larzeb@.community.nospam>
| >| Newsgroups: microsoft.public.sqlserver.server
| >| Subject: Login/connection problem
| >| Date: Tue, 01 Feb 2005 14:25:15 -0800
| >| Message-ID: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
| >| X-Newsreader: Forte Agent 2.0/32.652
| >| MIME-Version: 1.0
| >| Content-Type: text/plain; charset=us-ascii
| >| Content-Transfer-Encoding: 7bit
| >| Organization: We
| >| Lines: 20
| >| NNTP-Posting-Host: 216.251.47.166
| >| X-Trace: 1107296715 reader1.on.meganewsservers.com 2181
| >216.251.47.166:52402
| >| Path:
|
>cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.
s
|
>ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsservers.com!te
x
|
>tfeed1.on.meganewsservers.com!meganewsservers.com!reader1.on.meganewsserver
s
| >.com!reader1.on.meganewsservers.com!not-for-mail
| >| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376551
| >| X-Tomcat-NG: microsoft.public.sqlserver.server
| >|
| >| I have installed SQL Server 2000 SP3a on an XP machine and running in
| >| mixed mode. I log on using a local user name belonging to the
| >| Administrators group.
| >|
| >| When I attempt to connect to the DB through .Net with the following
| >| string:
| >|
| >| Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
| >| Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
| >|
| >| I receive the following error:
| >|
| >| Login failed for user '(null)'. Reason: Not associated with a trusted
| >| SQL Server connection.
| >|
| >| However, I can login using osql -Uuser and password pwd.
| >|
| >| What am I missing here? I am desperate!
| >|
| >| TIA, Larzeb
| >|
|
||||The error message is telling you that, although you passed SQL Server
authentication credentials, the DBMS is actually attempting Integrated
Security=SSPI, that is, Windows Authentication. You should check to make
sure your network account has been granted SQL Server login access or force
SQL Server, and your connection string, to use SQL Server logins.
Sincerely,
Anthony Thomas
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:cbDBaKZCFHA.644@.cpmsftngxa10.phx.gbl...
Hello Larzeb,
Did you use ASP.net? If so, please check if you encountered the following
issue:
324479 FIX: ASP.NET SQL Server Session State Impersonation Is Lost Under
Load
http://support.microsoft.com/?id=324479
Actually, the error message is most likely caused by Windows
authentication. Could you double check if the error is caused by the
ADO.net call with the sql authention connection string?
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
| ath: nntpswitch.com
| From: larzeb <larzeb@.community.nospam>
| Newsgroups: microsoft.public.sqlserver.server
| Subject: Re: Login/connection problem
| Date: Wed, 02 Feb 2005 09:07:45 -0800
| Message-ID: <652201ph3q6pe86ntu562ms8p05ml68hia@.4ax.com>
| References: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
<BtuQRGPCFHA.768@.cpmsftngxa10.phx.gbl>
| X-Newsreader: Forte Agent 2.0/32.652
| MIME-Version: 1.0
| Content-Type: text/plain; charset=us-ascii
| Content-Transfer-Encoding: 7bit
| Organization: We
| Lines: 80
| NNTP-Posting-Host: 216.251.47.166
| X-Trace: 1107364054 reader1.on.meganewsservers.com 2179
216.251.47.166:59658
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsservers.com!meg
anewsservers.com!reader1.on.meganewsservers.com!reader1.on.meganewsservers.c
om!not-for-mail
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376672
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Peter,
|
| Both protocols where already set in both the client and server
| utilities. Any other ideas?
|
| Larzeb
| On Wed, 02 Feb 2005 06:36:42 GMT, petery@.online.microsoft.com (Peter
| Yang [MSFT]) wrote:
|
| >Hello Larzeb,
| >
| >It seems that SQL client network protocals are not enabled properly. I
| >suggest that you run
| >
| >%windir%\SYSTEM32\cliconfg.exe
| >
| >and enable TCP/IP and named pipes protocals.
| >
| >Also, please run server network utility to enable the same protocals:
| >
| >%programfiles%\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
| >
| >Best Regards,
| >
| >Peter Yang
| >MCSE2000/2003, MCSA, MCDBA
| >Microsoft Online Partner Support
| >
| >When responding to posts, please "Reply to Group" via your newsreader so
| >that others may learn and benefit from your issue.
| >
| >This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| >
| >--
| >| ath: nntpswitch.com
| >| From: larzeb <larzeb@.community.nospam>
| >| Newsgroups: microsoft.public.sqlserver.server
| >| Subject: Login/connection problem
| >| Date: Tue, 01 Feb 2005 14:25:15 -0800
| >| Message-ID: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
| >| X-Newsreader: Forte Agent 2.0/32.652
| >| MIME-Version: 1.0
| >| Content-Type: text/plain; charset=us-ascii
| >| Content-Transfer-Encoding: 7bit
| >| Organization: We
| >| Lines: 20
| >| NNTP-Posting-Host: 216.251.47.166
| >| X-Trace: 1107296715 reader1.on.meganewsservers.com 2181
| >216.251.47.166:52402
| >| Path:
|
>cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.
s
|
>ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsservers.com!te
x
|
>tfeed1.on.meganewsservers.com!meganewsservers.com!reader1.on.meganewsserver
s
| >.com!reader1.on.meganewsservers.com!not-for-mail
| >| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376551
| >| X-Tomcat-NG: microsoft.public.sqlserver.server
| >|
| >| I have installed SQL Server 2000 SP3a on an XP machine and running in
| >| mixed mode. I log on using a local user name belonging to the
| >| Administrators group.
| >|
| >| When I attempt to connect to the DB through .Net with the following
| >| string:
| >|
| >| Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
| >| Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
| >|
| >| I receive the following error:
| >|
| >| Login failed for user '(null)'. Reason: Not associated with a trusted
| >| SQL Server connection.
| >|
| >| However, I can login using osql -Uuser and password pwd.
| >|
| >| What am I missing here? I am desperate!
| >|
| >| TIA, Larzeb
| >|
|
|
Login/connection problem
I have installed SQL Server 2000 SP3a on an XP machine and running in
mixed mode. I log on using a local user name belonging to the
Administrators group.
When I attempt to connect to the DB through .Net with the following
string:
Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
I receive the following error:
Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection.
However, I can login using osql -Uuser and password pwd.
What am I missing here? I am desperate!
TIA, LarzebHello Larzeb,
It seems that SQL client network protocals are not enabled properly. I
suggest that you run
%windir%\SYSTEM32\cliconfg.exe
and enable TCP/IP and named pipes protocals.
Also, please run server network utility to enable the same protocals:
%programfiles%\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
| ath: nntpswitch.com
| From: larzeb <larzeb@.community.nospam>
| Newsgroups: microsoft.public.sqlserver.server
| Subject: Login/connection problem
| Date: Tue, 01 Feb 2005 14:25:15 -0800
| Message-ID: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
| X-Newsreader: Forte Agent 2.0/32.652
| MIME-Version: 1.0
| Content-Type: text/plain; charset=us-ascii
| Content-Transfer-Encoding: 7bit
| Organization: We
| Lines: 20
| NNTP-Posting-Host: 216.251.47.166
| X-Trace: 1107296715 reader1.on.meganewsservers.com 2181
216.251.47.166:52402
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsservers.com!tex
tfeed1.on.meganewsservers.com!meganewsservers.com!reader1.on.meganewsservers
.com!reader1.on.meganewsservers.com!not-for-mail
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376551
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I have installed SQL Server 2000 SP3a on an XP machine and running in
| mixed mode. I log on using a local user name belonging to the
| Administrators group.
|
| When I attempt to connect to the DB through .Net with the following
| string:
|
| Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
| Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
|
| I receive the following error:
|
| Login failed for user '(null)'. Reason: Not associated with a trusted
| SQL Server connection.
|
| However, I can login using osql -Uuser and password pwd.
|
| What am I missing here? I am desperate!
|
| TIA, Larzeb
||||Peter,
Both protocols where already set in both the client and server
utilities. Any other ideas?
Larzeb
On Wed, 02 Feb 2005 06:36:42 GMT, petery@.online.microsoft.com (Peter
Yang [MSFT]) wrote:
>Hello Larzeb,
>It seems that SQL client network protocals are not enabled properly. I
>suggest that you run
>%windir%\SYSTEM32\cliconfg.exe
>and enable TCP/IP and named pipes protocals.
>Also, please run server network utility to enable the same protocals:
>%programfiles%\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
>Best Regards,
>Peter Yang
>MCSE2000/2003, MCSA, MCDBA
>Microsoft Online Partner Support
>When responding to posts, please "Reply to Group" via your newsreader so
>that others may learn and benefit from your issue.
>This posting is provided "AS IS" with no warranties, and confers no rights.
>
>--
>| ath: nntpswitch.com
>| From: larzeb <larzeb@.community.nospam>
>| Newsgroups: microsoft.public.sqlserver.server
>| Subject: Login/connection problem
>| Date: Tue, 01 Feb 2005 14:25:15 -0800
>| Message-ID: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
>| X-Newsreader: Forte Agent 2.0/32.652
>| MIME-Version: 1.0
>| Content-Type: text/plain; charset=us-ascii
>| Content-Transfer-Encoding: 7bit
>| Organization: We
>| Lines: 20
>| NNTP-Posting-Host: 216.251.47.166
>| X-Trace: 1107296715 reader1.on.meganewsservers.com 2181
>216.251.47.166:52402
>| Path:
>cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
>ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsservers.com!tex
>tfeed1.on.meganewsservers.com!meganewsservers.com!reader1.on.meganewsservers
>.com!reader1.on.meganewsservers.com!not-for-mail
>| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376551
>| X-Tomcat-NG: microsoft.public.sqlserver.server
>|
>| I have installed SQL Server 2000 SP3a on an XP machine and running in
>| mixed mode. I log on using a local user name belonging to the
>| Administrators group.
>|
>| When I attempt to connect to the DB through .Net with the following
>| string:
>|
>| Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
>| Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
>|
>| I receive the following error:
>|
>| Login failed for user '(null)'. Reason: Not associated with a trusted
>| SQL Server connection.
>|
>| However, I can login using osql -Uuser and password pwd.
>|
>| What am I missing here? I am desperate!
>|
>| TIA, Larzeb
>||||Hello Larzeb,
Did you use ASP.net? If so, please check if you encountered the following
issue:
324479 FIX: ASP.NET SQL Server Session State Impersonation Is Lost Under
Load
http://support.microsoft.com/?id=324479
Actually, the error message is most likely caused by Windows
authentication. Could you double check if the error is caused by the
ADO.net call with the sql authention connection string?
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
| ath: nntpswitch.com
| From: larzeb <larzeb@.community.nospam>
| Newsgroups: microsoft.public.sqlserver.server
| Subject: Re: Login/connection problem
| Date: Wed, 02 Feb 2005 09:07:45 -0800
| Message-ID: <652201ph3q6pe86ntu562ms8p05ml68hia@.4ax.com>
| References: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
<BtuQRGPCFHA.768@.cpmsftngxa10.phx.gbl>
| X-Newsreader: Forte Agent 2.0/32.652
| MIME-Version: 1.0
| Content-Type: text/plain; charset=us-ascii
| Content-Transfer-Encoding: 7bit
| Organization: We
| Lines: 80
| NNTP-Posting-Host: 216.251.47.166
| X-Trace: 1107364054 reader1.on.meganewsservers.com 2179
216.251.47.166:59658
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsservers.com!meg
anewsservers.com!reader1.on.meganewsservers.com!reader1.on.meganewsservers.c
om!not-for-mail
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376672
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Peter,
|
| Both protocols where already set in both the client and server
| utilities. Any other ideas?
|
| Larzeb
| On Wed, 02 Feb 2005 06:36:42 GMT, petery@.online.microsoft.com (Peter
| Yang [MSFT]) wrote:
|
| >Hello Larzeb,
| >
| >It seems that SQL client network protocals are not enabled properly. I
| >suggest that you run
| >
| >%windir%\SYSTEM32\cliconfg.exe
| >
| >and enable TCP/IP and named pipes protocals.
| >
| >Also, please run server network utility to enable the same protocals:
| >
| >%programfiles%\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
| >
| >Best Regards,
| >
| >Peter Yang
| >MCSE2000/2003, MCSA, MCDBA
| >Microsoft Online Partner Support
| >
| >When responding to posts, please "Reply to Group" via your newsreader so
| >that others may learn and benefit from your issue.
| >
| >This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| >
| >--
| >| ath: nntpswitch.com
| >| From: larzeb <larzeb@.community.nospam>
| >| Newsgroups: microsoft.public.sqlserver.server
| >| Subject: Login/connection problem
| >| Date: Tue, 01 Feb 2005 14:25:15 -0800
| >| Message-ID: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
| >| X-Newsreader: Forte Agent 2.0/32.652
| >| MIME-Version: 1.0
| >| Content-Type: text/plain; charset=us-ascii
| >| Content-Transfer-Encoding: 7bit
| >| Organization: We
| >| Lines: 20
| >| NNTP-Posting-Host: 216.251.47.166
| >| X-Trace: 1107296715 reader1.on.meganewsservers.com 2181
| >216.251.47.166:52402
| >| Path:
|
>cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.
s
|
>ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsservers.com!te
x
|
>tfeed1.on.meganewsservers.com!meganewsservers.com!reader1.on.meganewsserver
s
| >.com!reader1.on.meganewsservers.com!not-for-mail
| >| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376551
| >| X-Tomcat-NG: microsoft.public.sqlserver.server
| >|
| >| I have installed SQL Server 2000 SP3a on an XP machine and running in
| >| mixed mode. I log on using a local user name belonging to the
| >| Administrators group.
| >|
| >| When I attempt to connect to the DB through .Net with the following
| >| string:
| >|
| >| Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
| >| Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
| >|
| >| I receive the following error:
| >|
| >| Login failed for user '(null)'. Reason: Not associated with a trusted
| >| SQL Server connection.
| >|
| >| However, I can login using osql -Uuser and password pwd.
| >|
| >| What am I missing here? I am desperate!
| >|
| >| TIA, Larzeb
| >|
|
||||The error message is telling you that, although you passed SQL Server
authentication credentials, the DBMS is actually attempting Integrated
Security=SSPI, that is, Windows Authentication. You should check to make
sure your network account has been granted SQL Server login access or force
SQL Server, and your connection string, to use SQL Server logins.
Sincerely,
Anthony Thomas
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:cbDBaKZCFHA.644@.cpmsftngxa10.phx.gbl...
Hello Larzeb,
Did you use ASP.net? If so, please check if you encountered the following
issue:
324479 FIX: ASP.NET SQL Server Session State Impersonation Is Lost Under
Load
http://support.microsoft.com/?id=324479
Actually, the error message is most likely caused by Windows
authentication. Could you double check if the error is caused by the
ADO.net call with the sql authention connection string?
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
| ath: nntpswitch.com
| From: larzeb <larzeb@.community.nospam>
| Newsgroups: microsoft.public.sqlserver.server
| Subject: Re: Login/connection problem
| Date: Wed, 02 Feb 2005 09:07:45 -0800
| Message-ID: <652201ph3q6pe86ntu562ms8p05ml68hia@.4ax.com>
| References: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
<BtuQRGPCFHA.768@.cpmsftngxa10.phx.gbl>
| X-Newsreader: Forte Agent 2.0/32.652
| MIME-Version: 1.0
| Content-Type: text/plain; charset=us-ascii
| Content-Transfer-Encoding: 7bit
| Organization: We
| Lines: 80
| NNTP-Posting-Host: 216.251.47.166
| X-Trace: 1107364054 reader1.on.meganewsservers.com 2179
216.251.47.166:59658
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsservers.com!meg
anewsservers.com!reader1.on.meganewsservers.com!reader1.on.meganewsservers.c
om!not-for-mail
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376672
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Peter,
|
| Both protocols where already set in both the client and server
| utilities. Any other ideas?
|
| Larzeb
| On Wed, 02 Feb 2005 06:36:42 GMT, petery@.online.microsoft.com (Peter
| Yang [MSFT]) wrote:
|
| >Hello Larzeb,
| >
| >It seems that SQL client network protocals are not enabled properly. I
| >suggest that you run
| >
| >%windir%\SYSTEM32\cliconfg.exe
| >
| >and enable TCP/IP and named pipes protocals.
| >
| >Also, please run server network utility to enable the same protocals:
| >
| >%programfiles%\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
| >
| >Best Regards,
| >
| >Peter Yang
| >MCSE2000/2003, MCSA, MCDBA
| >Microsoft Online Partner Support
| >
| >When responding to posts, please "Reply to Group" via your newsreader so
| >that others may learn and benefit from your issue.
| >
| >This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| >
| >--
| >| ath: nntpswitch.com
| >| From: larzeb <larzeb@.community.nospam>
| >| Newsgroups: microsoft.public.sqlserver.server
| >| Subject: Login/connection problem
| >| Date: Tue, 01 Feb 2005 14:25:15 -0800
| >| Message-ID: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
| >| X-Newsreader: Forte Agent 2.0/32.652
| >| MIME-Version: 1.0
| >| Content-Type: text/plain; charset=us-ascii
| >| Content-Transfer-Encoding: 7bit
| >| Organization: We
| >| Lines: 20
| >| NNTP-Posting-Host: 216.251.47.166
| >| X-Trace: 1107296715 reader1.on.meganewsservers.com 2181
| >216.251.47.166:52402
| >| Path:
|
>cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.
s
|
>ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsservers.com!te
x
|
>tfeed1.on.meganewsservers.com!meganewsservers.com!reader1.on.meganewsserver
s
| >.com!reader1.on.meganewsservers.com!not-for-mail
| >| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376551
| >| X-Tomcat-NG: microsoft.public.sqlserver.server
| >|
| >| I have installed SQL Server 2000 SP3a on an XP machine and running in
| >| mixed mode. I log on using a local user name belonging to the
| >| Administrators group.
| >|
| >| When I attempt to connect to the DB through .Net with the following
| >| string:
| >|
| >| Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
| >| Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
| >|
| >| I receive the following error:
| >|
| >| Login failed for user '(null)'. Reason: Not associated with a trusted
| >| SQL Server connection.
| >|
| >| However, I can login using osql -Uuser and password pwd.
| >|
| >| What am I missing here? I am desperate!
| >|
| >| TIA, Larzeb
| >|
|
|
mixed mode. I log on using a local user name belonging to the
Administrators group.
When I attempt to connect to the DB through .Net with the following
string:
Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
I receive the following error:
Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection.
However, I can login using osql -Uuser and password pwd.
What am I missing here? I am desperate!
TIA, LarzebHello Larzeb,
It seems that SQL client network protocals are not enabled properly. I
suggest that you run
%windir%\SYSTEM32\cliconfg.exe
and enable TCP/IP and named pipes protocals.
Also, please run server network utility to enable the same protocals:
%programfiles%\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
| ath: nntpswitch.com
| From: larzeb <larzeb@.community.nospam>
| Newsgroups: microsoft.public.sqlserver.server
| Subject: Login/connection problem
| Date: Tue, 01 Feb 2005 14:25:15 -0800
| Message-ID: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
| X-Newsreader: Forte Agent 2.0/32.652
| MIME-Version: 1.0
| Content-Type: text/plain; charset=us-ascii
| Content-Transfer-Encoding: 7bit
| Organization: We
| Lines: 20
| NNTP-Posting-Host: 216.251.47.166
| X-Trace: 1107296715 reader1.on.meganewsservers.com 2181
216.251.47.166:52402
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsservers.com!tex
tfeed1.on.meganewsservers.com!meganewsservers.com!reader1.on.meganewsservers
.com!reader1.on.meganewsservers.com!not-for-mail
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376551
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I have installed SQL Server 2000 SP3a on an XP machine and running in
| mixed mode. I log on using a local user name belonging to the
| Administrators group.
|
| When I attempt to connect to the DB through .Net with the following
| string:
|
| Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
| Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
|
| I receive the following error:
|
| Login failed for user '(null)'. Reason: Not associated with a trusted
| SQL Server connection.
|
| However, I can login using osql -Uuser and password pwd.
|
| What am I missing here? I am desperate!
|
| TIA, Larzeb
||||Peter,
Both protocols where already set in both the client and server
utilities. Any other ideas?
Larzeb
On Wed, 02 Feb 2005 06:36:42 GMT, petery@.online.microsoft.com (Peter
Yang [MSFT]) wrote:
>Hello Larzeb,
>It seems that SQL client network protocals are not enabled properly. I
>suggest that you run
>%windir%\SYSTEM32\cliconfg.exe
>and enable TCP/IP and named pipes protocals.
>Also, please run server network utility to enable the same protocals:
>%programfiles%\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
>Best Regards,
>Peter Yang
>MCSE2000/2003, MCSA, MCDBA
>Microsoft Online Partner Support
>When responding to posts, please "Reply to Group" via your newsreader so
>that others may learn and benefit from your issue.
>This posting is provided "AS IS" with no warranties, and confers no rights.
>
>--
>| ath: nntpswitch.com
>| From: larzeb <larzeb@.community.nospam>
>| Newsgroups: microsoft.public.sqlserver.server
>| Subject: Login/connection problem
>| Date: Tue, 01 Feb 2005 14:25:15 -0800
>| Message-ID: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
>| X-Newsreader: Forte Agent 2.0/32.652
>| MIME-Version: 1.0
>| Content-Type: text/plain; charset=us-ascii
>| Content-Transfer-Encoding: 7bit
>| Organization: We
>| Lines: 20
>| NNTP-Posting-Host: 216.251.47.166
>| X-Trace: 1107296715 reader1.on.meganewsservers.com 2181
>216.251.47.166:52402
>| Path:
>cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
>ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsservers.com!tex
>tfeed1.on.meganewsservers.com!meganewsservers.com!reader1.on.meganewsservers
>.com!reader1.on.meganewsservers.com!not-for-mail
>| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376551
>| X-Tomcat-NG: microsoft.public.sqlserver.server
>|
>| I have installed SQL Server 2000 SP3a on an XP machine and running in
>| mixed mode. I log on using a local user name belonging to the
>| Administrators group.
>|
>| When I attempt to connect to the DB through .Net with the following
>| string:
>|
>| Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
>| Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
>|
>| I receive the following error:
>|
>| Login failed for user '(null)'. Reason: Not associated with a trusted
>| SQL Server connection.
>|
>| However, I can login using osql -Uuser and password pwd.
>|
>| What am I missing here? I am desperate!
>|
>| TIA, Larzeb
>||||Hello Larzeb,
Did you use ASP.net? If so, please check if you encountered the following
issue:
324479 FIX: ASP.NET SQL Server Session State Impersonation Is Lost Under
Load
http://support.microsoft.com/?id=324479
Actually, the error message is most likely caused by Windows
authentication. Could you double check if the error is caused by the
ADO.net call with the sql authention connection string?
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
| ath: nntpswitch.com
| From: larzeb <larzeb@.community.nospam>
| Newsgroups: microsoft.public.sqlserver.server
| Subject: Re: Login/connection problem
| Date: Wed, 02 Feb 2005 09:07:45 -0800
| Message-ID: <652201ph3q6pe86ntu562ms8p05ml68hia@.4ax.com>
| References: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
<BtuQRGPCFHA.768@.cpmsftngxa10.phx.gbl>
| X-Newsreader: Forte Agent 2.0/32.652
| MIME-Version: 1.0
| Content-Type: text/plain; charset=us-ascii
| Content-Transfer-Encoding: 7bit
| Organization: We
| Lines: 80
| NNTP-Posting-Host: 216.251.47.166
| X-Trace: 1107364054 reader1.on.meganewsservers.com 2179
216.251.47.166:59658
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsservers.com!meg
anewsservers.com!reader1.on.meganewsservers.com!reader1.on.meganewsservers.c
om!not-for-mail
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376672
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Peter,
|
| Both protocols where already set in both the client and server
| utilities. Any other ideas?
|
| Larzeb
| On Wed, 02 Feb 2005 06:36:42 GMT, petery@.online.microsoft.com (Peter
| Yang [MSFT]) wrote:
|
| >Hello Larzeb,
| >
| >It seems that SQL client network protocals are not enabled properly. I
| >suggest that you run
| >
| >%windir%\SYSTEM32\cliconfg.exe
| >
| >and enable TCP/IP and named pipes protocals.
| >
| >Also, please run server network utility to enable the same protocals:
| >
| >%programfiles%\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
| >
| >Best Regards,
| >
| >Peter Yang
| >MCSE2000/2003, MCSA, MCDBA
| >Microsoft Online Partner Support
| >
| >When responding to posts, please "Reply to Group" via your newsreader so
| >that others may learn and benefit from your issue.
| >
| >This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| >
| >--
| >| ath: nntpswitch.com
| >| From: larzeb <larzeb@.community.nospam>
| >| Newsgroups: microsoft.public.sqlserver.server
| >| Subject: Login/connection problem
| >| Date: Tue, 01 Feb 2005 14:25:15 -0800
| >| Message-ID: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
| >| X-Newsreader: Forte Agent 2.0/32.652
| >| MIME-Version: 1.0
| >| Content-Type: text/plain; charset=us-ascii
| >| Content-Transfer-Encoding: 7bit
| >| Organization: We
| >| Lines: 20
| >| NNTP-Posting-Host: 216.251.47.166
| >| X-Trace: 1107296715 reader1.on.meganewsservers.com 2181
| >216.251.47.166:52402
| >| Path:
|
>cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.
s
|
>ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsservers.com!te
x
|
>tfeed1.on.meganewsservers.com!meganewsservers.com!reader1.on.meganewsserver
s
| >.com!reader1.on.meganewsservers.com!not-for-mail
| >| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376551
| >| X-Tomcat-NG: microsoft.public.sqlserver.server
| >|
| >| I have installed SQL Server 2000 SP3a on an XP machine and running in
| >| mixed mode. I log on using a local user name belonging to the
| >| Administrators group.
| >|
| >| When I attempt to connect to the DB through .Net with the following
| >| string:
| >|
| >| Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
| >| Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
| >|
| >| I receive the following error:
| >|
| >| Login failed for user '(null)'. Reason: Not associated with a trusted
| >| SQL Server connection.
| >|
| >| However, I can login using osql -Uuser and password pwd.
| >|
| >| What am I missing here? I am desperate!
| >|
| >| TIA, Larzeb
| >|
|
||||The error message is telling you that, although you passed SQL Server
authentication credentials, the DBMS is actually attempting Integrated
Security=SSPI, that is, Windows Authentication. You should check to make
sure your network account has been granted SQL Server login access or force
SQL Server, and your connection string, to use SQL Server logins.
Sincerely,
Anthony Thomas
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:cbDBaKZCFHA.644@.cpmsftngxa10.phx.gbl...
Hello Larzeb,
Did you use ASP.net? If so, please check if you encountered the following
issue:
324479 FIX: ASP.NET SQL Server Session State Impersonation Is Lost Under
Load
http://support.microsoft.com/?id=324479
Actually, the error message is most likely caused by Windows
authentication. Could you double check if the error is caused by the
ADO.net call with the sql authention connection string?
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
| ath: nntpswitch.com
| From: larzeb <larzeb@.community.nospam>
| Newsgroups: microsoft.public.sqlserver.server
| Subject: Re: Login/connection problem
| Date: Wed, 02 Feb 2005 09:07:45 -0800
| Message-ID: <652201ph3q6pe86ntu562ms8p05ml68hia@.4ax.com>
| References: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
<BtuQRGPCFHA.768@.cpmsftngxa10.phx.gbl>
| X-Newsreader: Forte Agent 2.0/32.652
| MIME-Version: 1.0
| Content-Type: text/plain; charset=us-ascii
| Content-Transfer-Encoding: 7bit
| Organization: We
| Lines: 80
| NNTP-Posting-Host: 216.251.47.166
| X-Trace: 1107364054 reader1.on.meganewsservers.com 2179
216.251.47.166:59658
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsservers.com!meg
anewsservers.com!reader1.on.meganewsservers.com!reader1.on.meganewsservers.c
om!not-for-mail
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376672
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Peter,
|
| Both protocols where already set in both the client and server
| utilities. Any other ideas?
|
| Larzeb
| On Wed, 02 Feb 2005 06:36:42 GMT, petery@.online.microsoft.com (Peter
| Yang [MSFT]) wrote:
|
| >Hello Larzeb,
| >
| >It seems that SQL client network protocals are not enabled properly. I
| >suggest that you run
| >
| >%windir%\SYSTEM32\cliconfg.exe
| >
| >and enable TCP/IP and named pipes protocals.
| >
| >Also, please run server network utility to enable the same protocals:
| >
| >%programfiles%\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
| >
| >Best Regards,
| >
| >Peter Yang
| >MCSE2000/2003, MCSA, MCDBA
| >Microsoft Online Partner Support
| >
| >When responding to posts, please "Reply to Group" via your newsreader so
| >that others may learn and benefit from your issue.
| >
| >This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| >
| >--
| >| ath: nntpswitch.com
| >| From: larzeb <larzeb@.community.nospam>
| >| Newsgroups: microsoft.public.sqlserver.server
| >| Subject: Login/connection problem
| >| Date: Tue, 01 Feb 2005 14:25:15 -0800
| >| Message-ID: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
| >| X-Newsreader: Forte Agent 2.0/32.652
| >| MIME-Version: 1.0
| >| Content-Type: text/plain; charset=us-ascii
| >| Content-Transfer-Encoding: 7bit
| >| Organization: We
| >| Lines: 20
| >| NNTP-Posting-Host: 216.251.47.166
| >| X-Trace: 1107296715 reader1.on.meganewsservers.com 2181
| >216.251.47.166:52402
| >| Path:
|
>cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.
s
|
>ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsservers.com!te
x
|
>tfeed1.on.meganewsservers.com!meganewsservers.com!reader1.on.meganewsserver
s
| >.com!reader1.on.meganewsservers.com!not-for-mail
| >| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376551
| >| X-Tomcat-NG: microsoft.public.sqlserver.server
| >|
| >| I have installed SQL Server 2000 SP3a on an XP machine and running in
| >| mixed mode. I log on using a local user name belonging to the
| >| Administrators group.
| >|
| >| When I attempt to connect to the DB through .Net with the following
| >| string:
| >|
| >| Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
| >| Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
| >|
| >| I receive the following error:
| >|
| >| Login failed for user '(null)'. Reason: Not associated with a trusted
| >| SQL Server connection.
| >|
| >| However, I can login using osql -Uuser and password pwd.
| >|
| >| What am I missing here? I am desperate!
| >|
| >| TIA, Larzeb
| >|
|
|
Subscribe to:
Posts (Atom)