Long wait times for simple SQL on 2005

I have an existing application deployed on many SQL 2000 servers running without issue. We installed SQL 2005 (8 way DualCore) and the most simple trivial SQL statements are taking an extreme amount of time (e.g. an identical query in 2000 took 10 ms is taking a couple of minutes in 2005). The data in the tables being queried are very small (low row count < 400; and low row size < 1k).

When profiling 2005 we see the connection going into a status of 'suspended' with a wait type of 'ASYNC_NETWORK_IO'. There just simply is not enough data being retrieved for a lag to occur returning data to the client. Has anyone seen anything like this? Any thoughts?

I haven't seen anything relating to NETWORK_IO, one gotcha is not doing index rebuilds. http://sqlblogcasts.com/blogs/simons/archive/2006/10/20/SQL-2005-UpgradeRebuild-your-indexes-.aspx

Can you include more details on the queries.

If you run the queries in SSMS do they still take a long time?

How many users are using the server? Is there server doing anything else?

|||

This is a new client of ours (installing our web app, which, has been in production for a few years and we have no issues in house on our 2005 or 2000 SQL boxes) so there are no current active users (save the one that I was using to test with); so the current activity on the server is virtually nill. This is one of our default databases (again, virtually no data except for so default info in the one table I am querying) - all indexes are up to date.

The table has simple varchar columns and two text columns (the data in the columns vary from 100 bytes to 10k [the high end]. Here is teh defintion of the table:

Table [REPORT_DEF]
[REPORT_GU] [uniqueidentifier] NOT NULL,
[NAME] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[NAMESPACE] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[NUMBER] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PAGE_ORIENTATION] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OWNER_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ORGANIZATION_GU] [uniqueidentifier] NULL,
[XML_DEF] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CLASS_NAME] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ASSEMBLY] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[COMPANY_GU] [uniqueidentifier] NULL,
[LOCATION] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ICON] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TITLE] [nvarchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SHORT_TITLE] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LOCALE] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[REPORT_VIEW_TYPE] [nvarchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MODULE] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DEPLOY_VERSION] [numeric](7, 0) NOT NULL DEFAULT ((0)),
[MAIN_REPORT_RPX] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ASSOCIATED_REPORT_GU] [uniqueidentifier] NULL,
CONSTRAINT PRIMARY KEY CLUSTERED - Column: REPORT_GU
CONSTRAINT UNIQUE NONCLUSTERED - columns: NAMESPACE and NAME

The query that is being run is as follows:

SELECT R0.[COMPANY_GU],R0.[NUMBER],R0.[NAME],R0.[ASSOCIATED_REPORT_GU],R0.[MAIN_REPORT_RPX],
R0.[REPORT_GU],R0.[PAGE_ORIENTATION],R0.[SHORT_TITLE],R0.[ASSEMBLY],R0.[MODULE],R0.[TITLE],
R0.[DEPLOY_VERSION],R0.[NAMESPACE],R0.[LOCATION],R0.[ORGANIZATION_GU],R0.[ICON],R0.[OWNER_TYPE],
R0.[XML_DEF],R0.[LOCALE],R0.[REPORT_VIEW_TYPE],R0.[CLASS_NAME]
FROM [REPORT_DEF] R0

ORDER BY R0.[NAMESPACE] ASC,R0.[NAME] ASC,R0.[REPORT_GU] ASC

Again, when I execute this query on the DB server (via Mgmt Studio) it executes in about 80 ms (give or take a couple ms). When run on a machine on the same network (gigabit backbone, the only two machines on this network) the execution time jumps to 75 seconds (give or take 5 seconds).

Thoughts?

|||

Can you run profiler and capture the XML plans, and then compare them, to check they are getting the same plan.

Also be aware that by default SSMS uses the in memory data provider which will give performance improvements compared with running on the client.

How much data is being returned?

Are you using SSMS on the client as well?

|||

Simon,

Thanks for your thoughts on this one. I broke down and called MS and after about 6 hours we found that there was a network issue. Both SQL and the web server machines have gigabit NICs but the switch that the client had the two machines plugged into is a 10/100 switch...with the NICs set to autosensing basic network traffic was extremely delayed (tested via explorer copying a 70MB file to the SQL server occured in 8 seconds, from the SQL server to the web sever was taking about 35 minutes). Anyway, chalk this one up to experience and something to look for next time.

Thanks for your help!

Logon failure?

Hello,
We just installed SQL Server developer's edition on a new Windows XP Pro
workstation. But whenever we bring up the SQL Server service manager, and
click Start, we get the error:
"The service did not start due to logon failure"
When we did the install, we left the "sa" password blank, and we're using
SQL Server authentication. Can anyone say what might be wrong?
Thanks!!
It's most likely the Windows account that starts up the SQL Server
service. The password is probably expired. Check your SQL
Server Service log on credentials
"Dean J Garrett" <info@.amuletc.com> wrote in message
news:OfpH2J1dFHA.1136@.TK2MSFTNGP12.phx.gbl...
> Hello,
> We just installed SQL Server developer's edition on a new Windows XP Pro
> workstation. But whenever we bring up the SQL Server service manager, and
> click Start, we get the error:
> "The service did not start due to logon failure"
> When we did the install, we left the "sa" password blank, and we're using
> SQL Server authentication. Can anyone say what might be wrong?
> Thanks!!
>
|||Oh, by the way... USE A STRONG PASSWORD FOR 'sa'!!!!
Don't use blanks; a lot of SQL Server exploits use a brute force method
to compromise a system. They'll check for passwords such 'sa' or blank.
"Dean J Garrett" <info@.amuletc.com> wrote in message
news:OfpH2J1dFHA.1136@.TK2MSFTNGP12.phx.gbl...
> Hello,
> We just installed SQL Server developer's edition on a new Windows XP Pro
> workstation. But whenever we bring up the SQL Server service manager, and
> click Start, we get the error:
> "The service did not start due to logon failure"
> When we did the install, we left the "sa" password blank, and we're using
> SQL Server authentication. Can anyone say what might be wrong?
> Thanks!!
>
|||Oh yes, for server deployments of SQL Server, we always use strong
passwords, but the workstation in question is at a home office, and not
connected to the Internet. Thanks!
"Armando Prato" <aprato@.REMOVEMEkronos.com> wrote in message
news:O#ZOgN1dFHA.3836@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> Oh, by the way... USE A STRONG PASSWORD FOR 'sa'!!!!
> Don't use blanks; a lot of SQL Server exploits use a brute force method
> to compromise a system. They'll check for passwords such 'sa' or blank.
> "Dean J Garrett" <info@.amuletc.com> wrote in message
> news:OfpH2J1dFHA.1136@.TK2MSFTNGP12.phx.gbl...
and[vbcol=seagreen]
using
>

Logon failure?

Hello,
We just installed SQL Server developer's edition on a new Windows XP Pro
workstation. But whenever we bring up the SQL Server service manager, and
click Start, we get the error:
"The service did not start due to logon failure"
When we did the install, we left the "sa" password blank, and we're using
SQL Server authentication. Can anyone say what might be wrong?
Thanks!!It's most likely the Windows account that starts up the SQL Server
service. The password is probably expired. Check your SQL
Server Service log on credentials
"Dean J Garrett" <info@.amuletc.com> wrote in message
news:OfpH2J1dFHA.1136@.TK2MSFTNGP12.phx.gbl...
> Hello,
> We just installed SQL Server developer's edition on a new Windows XP Pro
> workstation. But whenever we bring up the SQL Server service manager, and
> click Start, we get the error:
> "The service did not start due to logon failure"
> When we did the install, we left the "sa" password blank, and we're using
> SQL Server authentication. Can anyone say what might be wrong?
> Thanks!!
>|||Oh, by the way... USE A STRONG PASSWORD FOR 'sa'!!!!
Don't use blanks; a lot of SQL Server exploits use a brute force method
to compromise a system. They'll check for passwords such 'sa' or blank.
"Dean J Garrett" <info@.amuletc.com> wrote in message
news:OfpH2J1dFHA.1136@.TK2MSFTNGP12.phx.gbl...
> Hello,
> We just installed SQL Server developer's edition on a new Windows XP Pro
> workstation. But whenever we bring up the SQL Server service manager, and
> click Start, we get the error:
> "The service did not start due to logon failure"
> When we did the install, we left the "sa" password blank, and we're using
> SQL Server authentication. Can anyone say what might be wrong?
> Thanks!!
>|||Oh yes, for server deployments of SQL Server, we always use strong
passwords, but the workstation in question is at a home office, and not
connected to the Internet. Thanks!
"Armando Prato" <aprato@.REMOVEMEkronos.com> wrote in message
news:O#ZOgN1dFHA.3836@.tk2msftngp13.phx.gbl...
> Oh, by the way... USE A STRONG PASSWORD FOR 'sa'!!!!
> Don't use blanks; a lot of SQL Server exploits use a brute force method
> to compromise a system. They'll check for passwords such 'sa' or blank.
> "Dean J Garrett" <info@.amuletc.com> wrote in message
> news:OfpH2J1dFHA.1136@.TK2MSFTNGP12.phx.gbl...
> > Hello,
> >
> > We just installed SQL Server developer's edition on a new Windows XP Pro
> > workstation. But whenever we bring up the SQL Server service manager,
and
> > click Start, we get the error:
> >
> > "The service did not start due to logon failure"
> >
> > When we did the install, we left the "sa" password blank, and we're
using
> > SQL Server authentication. Can anyone say what might be wrong?
> >
> > Thanks!!
> >
> >
>

Logon failure?

Hello,
We just installed SQL Server developer's edition on a new Windows XP Pro
workstation. But whenever we bring up the SQL Server service manager, and
click Start, we get the error:
"The service did not start due to logon failure"
When we did the install, we left the "sa" password blank, and we're using
SQL Server authentication. Can anyone say what might be wrong?
Thanks!!It's most likely the Windows account that starts up the SQL Server
service. The password is probably expired. Check your SQL
Server Service log on credentials
"Dean J Garrett" <info@.amuletc.com> wrote in message
news:OfpH2J1dFHA.1136@.TK2MSFTNGP12.phx.gbl...
> Hello,
> We just installed SQL Server developer's edition on a new Windows XP Pro
> workstation. But whenever we bring up the SQL Server service manager, and
> click Start, we get the error:
> "The service did not start due to logon failure"
> When we did the install, we left the "sa" password blank, and we're using
> SQL Server authentication. Can anyone say what might be wrong?
> Thanks!!
>|||Oh, by the way... USE A STRONG PASSWORD FOR 'sa'!!!!
Don't use blanks; a lot of SQL Server exploits use a brute force method
to compromise a system. They'll check for passwords such 'sa' or blank.
"Dean J Garrett" <info@.amuletc.com> wrote in message
news:OfpH2J1dFHA.1136@.TK2MSFTNGP12.phx.gbl...
> Hello,
> We just installed SQL Server developer's edition on a new Windows XP Pro
> workstation. But whenever we bring up the SQL Server service manager, and
> click Start, we get the error:
> "The service did not start due to logon failure"
> When we did the install, we left the "sa" password blank, and we're using
> SQL Server authentication. Can anyone say what might be wrong?
> Thanks!!
>|||Oh yes, for server deployments of SQL Server, we always use strong
passwords, but the workstation in question is at a home office, and not
connected to the Internet. Thanks!
"Armando Prato" <aprato@.REMOVEMEkronos.com> wrote in message
news:O#ZOgN1dFHA.3836@.tk2msftngp13.phx.gbl...
> Oh, by the way... USE A STRONG PASSWORD FOR 'sa'!!!!
> Don't use blanks; a lot of SQL Server exploits use a brute force method
> to compromise a system. They'll check for passwords such 'sa' or blank.
> "Dean J Garrett" <info@.amuletc.com> wrote in message
> news:OfpH2J1dFHA.1136@.TK2MSFTNGP12.phx.gbl...
and[vbcol=seagreen]
using[vbcol=seagreen]
>

logon failure error in Reporting Services (rskeymgmt error)

Hi,
I have Reporting Services 2000 installed and I have a remote report server
database.
The Report Server is configured to use a domain user account to connect to
the report server database.
The password of the domain user account is changed a few days ago and I
updated the ReportServerConfig using rsconfig utility.
But, I am still getting the error logon failed error :
â'The report server cannot open a connection to the report server database.
The logon failed. (rsReportServerDatabaseLogonFailed) Get Online Help
Logon failure: unknown user name or bad password.
When I tried to take a backup (extract) of the existing symmetric keys using
rskeymgmt utility, I get the error, unable to connect to the database.
Can somebody provide me the resolution? Can I delete the keys without taking
a backup?
Thanks,
MujirDid you get this resolved we are experiencing the same thing?
"Mujir" wrote:
> Hi,
>
> I have Reporting Services 2000 installed and I have a remote report server
> database.
> The Report Server is configured to use a domain user account to connect to
> the report server database.
>
> The password of the domain user account is changed a few days ago and I
> updated the ReportServerConfig using rsconfig utility.
> But, I am still getting the error logon failed error :
> â'The report server cannot open a connection to the report server database.
> The logon failed. (rsReportServerDatabaseLogonFailed) Get Online Help
> Logon failure: unknown user name or bad password.
>
> When I tried to take a backup (extract) of the existing symmetric keys using
> rskeymgmt utility, I get the error, unable to connect to the database.
> Can somebody provide me the resolution? Can I delete the keys without taking
> a backup?
>
> Thanks,
> Mujir
>|||Not exactly, I configured it to use a different account and it works now.
"OriginalStealth" wrote:
> Did you get this resolved we are experiencing the same thing?
> "Mujir" wrote:
> > Hi,
> >
> >
> >
> > I have Reporting Services 2000 installed and I have a remote report server
> > database.
> >
> > The Report Server is configured to use a domain user account to connect to
> > the report server database.
> >
> >
> >
> > The password of the domain user account is changed a few days ago and I
> > updated the ReportServerConfig using rsconfig utility.
> >
> > But, I am still getting the error logon failed error :
> >
> > â'The report server cannot open a connection to the report server database.
> > The logon failed. (rsReportServerDatabaseLogonFailed) Get Online Help
> >
> > Logon failure: unknown user name or bad password.
> >
> >
> >
> > When I tried to take a backup (extract) of the existing symmetric keys using
> > rskeymgmt utility, I get the error, unable to connect to the database.
> >
> > Can somebody provide me the resolution? Can I delete the keys without taking
> > a backup?
> >
> >
> > Thanks,
> > Mujir
> >

Logon failure : (rsInternalError)

On a SQL server 2000 SP4 on XP PRO SP2, I have installed Reporting Services.
I have created an local administrator user and I have given this local
account as "Domain user Account" during installation.
When I try to acces report server, it fails with the message "Logon failure:
unknown user name or bad password. "
In the logfile of Reporting services, I read these informations :
aspnet_wp!library!690!02/03/2006-16:24:09:: i INFO: Call to GetPermissions:/
aspnet_wp!crypto!690!02/03/2006-16:24:09:: i INFO: Initializing crypto as
user: U000103096\ASPNET
aspnet_wp!crypto!690!02/03/2006-16:24:09:: i INFO: Exporting public key
aspnet_wp!library!690!02/03/2006-16:24:10:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
Une erreur interne s'est produite sur le serveur de rapports. Pour plus
d'informations, consultez le journal des erreurs., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
Une erreur interne s'est produite sur le serveur de rapports. Pour plus
d'informations, consultez le journal des erreurs. -->
System.Runtime.InteropServices.COMException (0x8007052E): Logon failure:
unknown user name or bad password.
Can somebody help me to solve this problem ? Thanks for allHi Gaby,
Welcome to the MSDN newsgroup.
From your description, I understand you have installed SQL Server 2000(with
reporting service) on a Windows XP SP2 machine. Also, during the
installation time, you configured the Reporting Service to use a certain
domain account which has been granted the "Local Administrator" role.
However, when you try accessing the report server application, it threw the
following exception:
"Logon failure: unknown user name or bad password. " ,correct?
Based on the log file content you provided, the error occured when the
report server try performing some security operations like reading account
info. I've also checked the error and find some reference in MSDN on the
similiar problem. Are you try viewing a report which use external
datasource and use prompted or stored Windows credentials to connect to the
external datasource? If so, you can have a look at the following
troubleshooting article, and the below section
"Connection error, where login failed for <servername>\ASPNET"
is describing the similiar problem as yours.
#Troubleshooting Server and Database Problems
http://msdn.microsoft.com/library/en-us/rstshoot/htm/trs_tshootdev_v1_3dcz.a
sp?frame=true
Please feel free to post here if there's anything else we can help.
Regards,
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi Steven
Thank you for your help but I am sorry to say that your recommendations
didn't work on my PC
I have just installed an SQL Server on my windows XP (SQL server 2000 + SP4)
and the Reporting Services (+ service pack 2). After that, before making any
own report, I have just tried to contact the report server, on this PC, in
an IE5 session with the address : localhost\reports. And then I have received
the error message : logon failed !!
My PC is an "entreprise PC", this a lot of components "masterised" in a
"logically gathered software" and I think that perhaps some authorizations
are not correctly installed for my requirements, but I don't know where I
have to search !!
"Steven Cheng[MSFT]" wrote:
> Hi Gaby,
> Welcome to the MSDN newsgroup.
> From your description, I understand you have installed SQL Server 2000(with
> reporting service) on a Windows XP SP2 machine. Also, during the
> installation time, you configured the Reporting Service to use a certain
> domain account which has been granted the "Local Administrator" role.
> However, when you try accessing the report server application, it threw the
> following exception:
> "Logon failure: unknown user name or bad password. " ,correct?
> Based on the log file content you provided, the error occured when the
> report server try performing some security operations like reading account
> info. I've also checked the error and find some reference in MSDN on the
> similiar problem. Are you try viewing a report which use external
> datasource and use prompted or stored Windows credentials to connect to the
> external datasource? If so, you can have a look at the following
> troubleshooting article, and the below section
> "Connection error, where login failed for <servername>\ASPNET"
> is describing the similiar problem as yours.
> #Troubleshooting Server and Database Problems
> http://msdn.microsoft.com/library/en-us/rstshoot/htm/trs_tshootdev_v1_3dcz.a
> sp?frame=true
> Please feel free to post here if there's anything else we can help.
> Regards,
> Steven Cheng
> Microsoft Online Support
> Get Secure! www.microsoft.com/security
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>
>
>
>
>
>
>|||Thanks for your response Gaby,
So the problem is somewhat different from that mentioned in the doc. Since
the error stack shows there is some login fail error and also mentioend the
MACHINE\ASPNET account, I think you can try the followings to see whether
it is concerned with account permission:
1. Change the reporting service windows service's identity from the current
account( the one you specified during setup) to Local System.
2. Temporarlily Add the ASP.NET process account (machine\ASPNET) into
local administrators group or just replace the ASP.NET process account
from "Machine" to "SYSTEM", this can be set in the .net framework's
machine.config(under C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\CONFIG)
After that, restart reporting service to see whether it work.
Regards,
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Thank you for your help. At the end, it works. I have just modified the
machine.config file of the current version of the framework (in the CONFIG
Folder), and change, in the processModel parameter, the value of the userName
parameter, from "machine" to "SYSTEM".
By stopping and restarting only the reporting service and the IIS server,
this modification don't work but after the "total reboot" of my computer, all
is OK and I can now see the contents of the folder in the Reports Server
Thank you for all (and I hope that our discussion can help other persons)
"Steven Cheng[MSFT]" wrote:
> Thanks for your response Gaby,
> So the problem is somewhat different from that mentioned in the doc. Since
> the error stack shows there is some login fail error and also mentioend the
> MACHINE\ASPNET account, I think you can try the followings to see whether
> it is concerned with account permission:
> 1. Change the reporting service windows service's identity from the current
> account( the one you specified during setup) to Local System.
> 2. Temporarlily Add the ASP.NET process account (machine\ASPNET) into
> local administrators group or just replace the ASP.NET process account
> from "Machine" to "SYSTEM", this can be set in the .net framework's
> machine.config(under C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\CONFIG)
> After that, restart reporting service to see whether it work.
> Regards,
> Steven Cheng
> Microsoft Online Support
> Get Secure! www.microsoft.com/security
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>
>
>
>
>|||You're welcome Gaby,
Regards,
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

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
| >|
|
|

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
| >|
|
|

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
| >|
|
|

Login.Language property for sa is not set.

I installed SQL 2000 standard edition.

Then I called server.Logins["sa"].Language

For some reason the value of this property was "" (empty string).

Can anyone explain, why?

P.S. After changing Default language for 'sa' login through Management Studio Language property became accessible..

Alexander Sychev.

The language property is tied to the property set in SQL for the login. By default it is just <default> and that is an empty string. When you set it like you did, the property is explicitly set.

Login.Language property for sa is not set.

I installed SQL 2000 standard edition.

Then I called server.Logins["sa"].Language

For some reason the value of this property was "" (empty string).

Can anyone explain, why?

P.S. After changing Default language for 'sa' login through Management Studio Language property became accessible..

Alexander Sychev.

The language property is tied to the property set in SQL for the login. By default it is just <default> and that is an empty string. When you set it like you did, the property is explicitly set.

Login troubles

I've installed SQL server express on a remote server. Using remote desktop, I can log in using Windows Authetication.

But I also want to be able to login remotely. Using Server Management Express I've added a new login and specified the password for SQL server authentication. My problem is that the password keeps getting changed to a mystery 15 character value.

What's going on?

Are you saying that you're tried logging in with the password you're setting and it's not working?

Mike

Login Time and Last Batch not displayed correctly

I recently installed SQL Server 2005 CTP. Now in 2000 Enterprise Manager,
under Current Activity, Process Info, the Login Time and Last Batch columns
are not displayed correctly.
The time is displayed but the date is shown as a square to the left of the
time. This is the same for all SQL Servers registered.
Is there any way to display the date correctly?
Many Thanks
I think that's just one of the bugs, still in the CTP. It's not the
finished product yet, and it's not the only thing not working
correctly.
M
|||The CTP looks to be working ok but its affected my SQL 2000 Enterprise
Manager. I thought it was possible to run them both together.
Thanks
|||I reinstalled SQL Server 2000 and everything works correctly.
Many Thanks
|||Hi
It is, but the warning applies that since it is in beta, it is not
guaranteed not to affect other products.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"si" <si@.discussions.microsoft.com> wrote in message
news:EF2F2DA2-1BEA-4E62-A512-F244C9E25FBC@.microsoft.com...
> The CTP looks to be working ok but its affected my SQL 2000 Enterprise
> Manager. I thought it was possible to run them both together.
> Thanks
|||Hi
Re-registering the SQL DMO component would have done the trick too, but
since you did not post the question in the SQL Server 2005 Beta/CTP
newsgroup, you would have not had the benefit of an answer that would have
saved you a lot of work. This question came up a lot over there and has been
answered as many times.
http://communities.microsoft.com/new...r2005&slcid=us
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"si" <si@.discussions.microsoft.com> wrote in message
news:EE75CCCD-8384-49C3-8455-406B39B85813@.microsoft.com...
>I reinstalled SQL Server 2000 and everything works correctly.
> Many Thanks

Login Security issues

RS installed on machine outside the firewall using SQL installed locally,
accessing data on SQL server inside the firewall using a shared data source.
Have given group browser rights on the top-level folder in RS.
When user initially accesses the reports home page, they are prompted for a
login and then the home page folders are displayed. Clicking on the folder
displays all the reports. Accessing a report prompts for login again. Same
user & password will display the report - and the login is not requested
again for the duration of the session.
How to avoid prompting for login twice?
Thanks
MarkI have more information on this issue...
WHen accessing from outside, the first login grants access to the home page
and the reports folders. However, when selecting a report - at the point
where we get a second login request in side the firewall - instead we get an
error:
The page cannot be displayed
Cannot find server or DNS Error|||More details...
Inside the firewall all works fine..
Outside the firewall I get these results...
This is the home page:
http://<server>/reports/Pages/Folder.aspx
This page works fine
Click on the folder for Remedy Reports and it goes here
http://<server>/Reports/Pages/Folder.aspx?ItemPath=%2fRemedy+Reports&IsDetailsView=False
This page works fine
Click on a report to view it and..
http://<server>/Reports/Pages/Report.aspx?ItemPath=%2fRemedy+Reports%2f72+Hour+Report
Outside the firewall, this page gets an error:
Cannot find server or DNS error|||Hopefully someone else can jump in with the particulars but I remember
seeing in another post
where there was a place in a config file that you need to make a change so
the server is in the form of servername.blah.blah rather than just
servername.
Just a guess since I have not had this situation occur before.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Mark Nicks" <MarkNicks@.discussions.microsoft.com> wrote in message
news:864759C8-39B0-4D23-9F7A-914464D13D3C@.microsoft.com...
> More details...
> Inside the firewall all works fine..
> Outside the firewall I get these results...
> This is the home page:
> http://<server>/reports/Pages/Folder.aspx
> This page works fine
> Click on the folder for Remedy Reports and it goes here:
>
http://<server>/Reports/Pages/Folder.aspx?ItemPath=%2fRemedy+Reports&IsDetailsView=False
> This page works fine
> Click on a report to view it and...
>
http://<server>/Reports/Pages/Report.aspx?ItemPath=%2fRemedy+Reports%2f72+Hour+Report
> Outside the firewall, this page gets an error:
> Cannot find server or DNS error|||Bruce I did find the answer posted in the forum. I'm reposting Dmitry
Vasilevsy's response here for anyone who runs across it...
Try accessing /ReportServer virtual folder (not /Report) from outside the
intranet, if it works, you just need to configure Report Manager application
properly.
The simplest way to do this is when you are running Report Server and Report
Manager application on the same machine (this is the only option available
when you run setup). Go look at the Report Manager configuration file,
RSWebApplication.config. There is a UI section
<UI>
<ReportServerUrl>http://intranet-computer-name/ReportServer</ReportServerUrl
>
</UI>
Change it to
<UI>
<ReportServerVirtualDirectory>/ReportServer</ReportServerVirtualDirectory>
</UI>
You should be able to access Report Manager from both intranet and internet.

Login problems on Vista before and after SP2

Hi:

I have recently updated my Sony Vaio and installed Windows Vista. After installing I could not access my SQL databases because of the NT Authorisation / sysadmin problem.

I have since installed SQLServer SP2 (Nov CTP) but the problem persists. If I run SQL Management Studio under the administrative account I can login just fine. I have also made sure the 'NT AUTHORITY\SYSTEM' is marked for sysadmin access (which it is).

The eror I get is Error 18456.

What else can I do to gain access via Windows Authorisation?

TIA,

MartinH.

Hello Martin,

Are you are logging into the Vista under any domain credentials? If so please add the domain user as the local system administrator and try.

Thanks,

Prakash P [MSFT]

|||

Prakash:

Sorry to be so dense, but I'm not quite sure what you are asking.

I am using Vista on a portable that does not connect to any Domain Server. The locally created user belongs to the Administrators group.

Is this what you meant by 'please add the domain user as the local system administrator'?

Thanks for your reply.

Martin.

|||

Here is a workaround for resolving this issue:

1. Run SSMS “As an Administrator”, by right clicking the SSMS icon and clicking “Run As Administrator” option and select Windows Authentication and login to SQL Server.

2. In the Object Explorer node select the Security node and then select Logins node. Add a new login for your windows account and select Windows Authentication. Also go the Server Roles pane in the same window and select sysadmin role for it.

3. Close SSMS and start it normally and give your domain account and select Windows Authentication and you will not have any issues thereafter.

|||

Rajesh:

That did the trick!!

Thanks very much for your help.

Regards,

Martin.

Login problem, mystery

Hi
I have installed MSDE ver 8.00.760.03 from the package sql2desksp03 located
at go.microsoft.com/fwlink/?linkid=13962
My intention is to develop an asp.net application with Microsoft Visual
Basic.Net Standard. Already installed. Because I can't create a database
with the
standard edition I want to use MS Access 2000 project to create the tables,
but when I try to create the project using the Microsoft SQL Server database
wizard and enter my SQL Server details as follows
name=svrname
user=sa
password=correctpassword
I get the following message.
Connection failed:
SQLState:'28000'
SQL Server Error: 18452
[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user 'sa'.
Reason: Not associated with a trusted SQL Server connection.
If I leave the Microsoft SQL Server database wizard user and password boxes
empty I am able to create my project but unable to create tables.
I'm on WinXP SP2 with Administrative rights. MSDE is running and my password
is definately correct - Please help :-)
hi,
SimonW wrote:
> Hi
> I have installed MSDE ver 8.00.760.03 from the package sql2desksp03
> located at go.microsoft.com/fwlink/?linkid=13962
> My intention is to develop an asp.net application with Microsoft
> Visual Basic.Net Standard. Already installed. Because I can't create
> a database with the
> standard edition I want to use MS Access 2000 project to create the
> tables, but when I try to create the project using the Microsoft SQL
> Server database
> wizard and enter my SQL Server details as follows
> name=svrname
> user=sa
> password=correctpassword
> I get the following message.
> Connection failed:
> SQLState:'28000'
> SQL Server Error: 18452
> [Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user
> 'sa'. Reason: Not associated with a trusted SQL Server connection.
> If I leave the Microsoft SQL Server database wizard user and password
> boxes empty I am able to create my project but unable to create
> tables.
> I'm on WinXP SP2 with Administrative rights. MSDE is running and my
> password is definately correct - Please help :-)
MSDE installs by default only allowing trusted conections... you can modify
this behavior bot at install time, providing the
SECURITYMODE=SQL
parameter to the setup.exe boostrap installer or later, at runtime, hacking
the Windows registry as described in
http://support.microsoft.com/default...n-us;285097... stop and
restart the server..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thank you very much Andrea :-)
"Andrea Montanari" wrote:

> hi,
> SimonW wrote:
> MSDE installs by default only allowing trusted conections... you can modify
> this behavior bot at install time, providing the
> SECURITYMODE=SQL
> parameter to the setup.exe boostrap installer or later, at runtime, hacking
> the Windows registry as described in
> http://support.microsoft.com/default...n-us;285097... stop and
> restart the server..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>

Login problem

Hi all, We have installed a new Win2003Server sp1 with sql2000server sp4. No
we are experiencing som strange problems. If we login to a klient with a
local account, open query analyzer and try to login using 'sql server
authentication', it does not work 'access denied or server does not exist'.
When looking in the security log on the sql server, we can see logon attempts
by the local account from the client computer?! If logon to the same client
with a domain account, everything works fine. My belief was that when using
'sql server auth', windows security had nothing to do with it.. am I wrong.
Thanks for Your help!
Perhaps SQL Server is in "Windows Only" mode? EM, right-click the server, properties, security.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Erik" <Erik@.discussions.microsoft.com> wrote in message
news:4ABD6C8E-8341-44E6-B00D-58D0BDAD7C5C@.microsoft.com...
> Hi all, We have installed a new Win2003Server sp1 with sql2000server sp4. No
> we are experiencing som strange problems. If we login to a klient with a
> local account, open query analyzer and try to login using 'sql server
> authentication', it does not work 'access denied or server does not exist'.
> When looking in the security log on the sql server, we can see logon attempts
> by the local account from the client computer?! If logon to the same client
> with a domain account, everything works fine. My belief was that when using
> 'sql server auth', windows security had nothing to do with it.. am I wrong.
> Thanks for Your help!
|||Hi Tibor,
Thanks for your your reply.
The server is set up in mixed mode.
Strangly enough, if I connect to a share on the sql server with a domain
account (still logged on with a local account), I have no problem connecting
with the sql login I used earlier...
I've heard rumors that others are also experiencing this problem after
applying sp4. Anyhow, I've registered a case with Microsoft, I'll get back
with their reply.
By the way Tibor, I'm attending one of your classes at cornerstone on nov
4th, see you there :-)
Regards,
Erik
"Tibor Karaszi" wrote:

> Perhaps SQL Server is in "Windows Only" mode? EM, right-click the server, properties, security.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Erik" <Erik@.discussions.microsoft.com> wrote in message
> news:4ABD6C8E-8341-44E6-B00D-58D0BDAD7C5C@.microsoft.com...
>
|||Hej Erik,
Perhaps IPC$ has anything to do with it? If you are using Named Pipes, you need to be able to use
IPC$ (at least this is how it used to work, not sure whether it changed). And perhaps you don't get
this validation at the Windows level when you login locally? You can check Client Network Utility on
the client whether you are using NP or IP Sockets.
See you in Nov :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Erik" <Erik@.discussions.microsoft.com> wrote in message
news:046970B4-5E32-42CA-812C-7183D197E76B@.microsoft.com...[vbcol=seagreen]
> Hi Tibor,
> Thanks for your your reply.
> The server is set up in mixed mode.
> Strangly enough, if I connect to a share on the sql server with a domain
> account (still logged on with a local account), I have no problem connecting
> with the sql login I used earlier...
> I've heard rumors that others are also experiencing this problem after
> applying sp4. Anyhow, I've registered a case with Microsoft, I'll get back
> with their reply.
> By the way Tibor, I'm attending one of your classes at cornerstone on nov
> 4th, see you there :-)
> Regards,
> Erik
> "Tibor Karaszi" wrote:

Login problem

Hi all, We have installed a new Win2003Server sp1 with sql2000server sp4. No
we are experiencing som strange problems. If we login to a klient with a
local account, open query analyzer and try to login using 'sql server
authentication', it does not work 'access denied or server does not exist'.
When looking in the security log on the sql server, we can see logon attempt
s
by the local account from the client computer?! If logon to the same client
with a domain account, everything works fine. My belief was that when using
'sql server auth', windows security had nothing to do with it.. am I wrong.
Thanks for Your help!Perhaps SQL Server is in "Windows Only" mode? EM, right-click the server, pr
operties, security.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Erik" <Erik@.discussions.microsoft.com> wrote in message
news:4ABD6C8E-8341-44E6-B00D-58D0BDAD7C5C@.microsoft.com...
> Hi all, We have installed a new Win2003Server sp1 with sql2000server sp4.
No
> we are experiencing som strange problems. If we login to a klient with a
> local account, open query analyzer and try to login using 'sql server
> authentication', it does not work 'access denied or server does not exist'
.
> When looking in the security log on the sql server, we can see logon attem
pts
> by the local account from the client computer?! If logon to the same clien
t
> with a domain account, everything works fine. My belief was that when usin
g
> 'sql server auth', windows security had nothing to do with it.. am I wrong
.
> Thanks for Your help!|||Hi Tibor,
Thanks for your your reply.
The server is set up in mixed mode.
Strangly enough, if I connect to a share on the sql server with a domain
account (still logged on with a local account), I have no problem connecting
with the sql login I used earlier...
I've heard rumors that others are also experiencing this problem after
applying sp4. Anyhow, I've registered a case with Microsoft, I'll get back
with their reply.
By the way Tibor, I'm attending one of your classes at cornerstone on nov
4th, see you there :-)
Regards,
Erik
"Tibor Karaszi" wrote:

> Perhaps SQL Server is in "Windows Only" mode? EM, right-click the server,
properties, security.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Erik" <Erik@.discussions.microsoft.com> wrote in message
> news:4ABD6C8E-8341-44E6-B00D-58D0BDAD7C5C@.microsoft.com...
>|||Hej Erik,
Perhaps IPC$ has anything to do with it? If you are using Named Pipes, you n
eed to be able to use
IPC$ (at least this is how it used to work, not sure whether it changed). An
d perhaps you don't get
this validation at the Windows level when you login locally? You can check C
lient Network Utility on
the client whether you are using NP or IP Sockets.
See you in Nov :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Erik" <Erik@.discussions.microsoft.com> wrote in message
news:046970B4-5E32-42CA-812C-7183D197E76B@.microsoft.com...[vbcol=seagreen]
> Hi Tibor,
> Thanks for your your reply.
> The server is set up in mixed mode.
> Strangly enough, if I connect to a share on the sql server with a domain
> account (still logged on with a local account), I have no problem connecti
ng
> with the sql login I used earlier...
> I've heard rumors that others are also experiencing this problem after
> applying sp4. Anyhow, I've registered a case with Microsoft, I'll get back
> with their reply.
> By the way Tibor, I'm attending one of your classes at cornerstone on nov
> 4th, see you there :-)
> Regards,
> Erik
> "Tibor Karaszi" wrote:
>

Login problem

Hi all, We have installed a new Win2003Server sp1 with sql2000server sp4. No
we are experiencing som strange problems. If we login to a klient with a
local account, open query analyzer and try to login using 'sql server
authentication', it does not work 'access denied or server does not exist'.
When looking in the security log on the sql server, we can see logon attempts
by the local account from the client computer?! If logon to the same client
with a domain account, everything works fine. My belief was that when using
'sql server auth', windows security had nothing to do with it.. am I wrong.
Thanks for Your help!Perhaps SQL Server is in "Windows Only" mode? EM, right-click the server, properties, security.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Erik" <Erik@.discussions.microsoft.com> wrote in message
news:4ABD6C8E-8341-44E6-B00D-58D0BDAD7C5C@.microsoft.com...
> Hi all, We have installed a new Win2003Server sp1 with sql2000server sp4. No
> we are experiencing som strange problems. If we login to a klient with a
> local account, open query analyzer and try to login using 'sql server
> authentication', it does not work 'access denied or server does not exist'.
> When looking in the security log on the sql server, we can see logon attempts
> by the local account from the client computer?! If logon to the same client
> with a domain account, everything works fine. My belief was that when using
> 'sql server auth', windows security had nothing to do with it.. am I wrong.
> Thanks for Your help!|||Hi Tibor,
Thanks for your your reply.
The server is set up in mixed mode.
Strangly enough, if I connect to a share on the sql server with a domain
account (still logged on with a local account), I have no problem connecting
with the sql login I used earlier...
I've heard rumors that others are also experiencing this problem after
applying sp4. Anyhow, I've registered a case with Microsoft, I'll get back
with their reply.
By the way Tibor, I'm attending one of your classes at cornerstone on nov
4th, see you there :-)
Regards,
Erik
"Tibor Karaszi" wrote:
> Perhaps SQL Server is in "Windows Only" mode? EM, right-click the server, properties, security.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Erik" <Erik@.discussions.microsoft.com> wrote in message
> news:4ABD6C8E-8341-44E6-B00D-58D0BDAD7C5C@.microsoft.com...
> > Hi all, We have installed a new Win2003Server sp1 with sql2000server sp4. No
> > we are experiencing som strange problems. If we login to a klient with a
> > local account, open query analyzer and try to login using 'sql server
> > authentication', it does not work 'access denied or server does not exist'.
> > When looking in the security log on the sql server, we can see logon attempts
> > by the local account from the client computer?! If logon to the same client
> > with a domain account, everything works fine. My belief was that when using
> > 'sql server auth', windows security had nothing to do with it.. am I wrong.
> >
> > Thanks for Your help!
>|||Hej Erik,
Perhaps IPC$ has anything to do with it? If you are using Named Pipes, you need to be able to use
IPC$ (at least this is how it used to work, not sure whether it changed). And perhaps you don't get
this validation at the Windows level when you login locally? You can check Client Network Utility on
the client whether you are using NP or IP Sockets.
See you in Nov :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Erik" <Erik@.discussions.microsoft.com> wrote in message
news:046970B4-5E32-42CA-812C-7183D197E76B@.microsoft.com...
> Hi Tibor,
> Thanks for your your reply.
> The server is set up in mixed mode.
> Strangly enough, if I connect to a share on the sql server with a domain
> account (still logged on with a local account), I have no problem connecting
> with the sql login I used earlier...
> I've heard rumors that others are also experiencing this problem after
> applying sp4. Anyhow, I've registered a case with Microsoft, I'll get back
> with their reply.
> By the way Tibor, I'm attending one of your classes at cornerstone on nov
> 4th, see you there :-)
> Regards,
> Erik
> "Tibor Karaszi" wrote:
>> Perhaps SQL Server is in "Windows Only" mode? EM, right-click the server, properties, security.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Erik" <Erik@.discussions.microsoft.com> wrote in message
>> news:4ABD6C8E-8341-44E6-B00D-58D0BDAD7C5C@.microsoft.com...
>> > Hi all, We have installed a new Win2003Server sp1 with sql2000server sp4. No
>> > we are experiencing som strange problems. If we login to a klient with a
>> > local account, open query analyzer and try to login using 'sql server
>> > authentication', it does not work 'access denied or server does not exist'.
>> > When looking in the security log on the sql server, we can see logon attempts
>> > by the local account from the client computer?! If logon to the same client
>> > with a domain account, everything works fine. My belief was that when using
>> > 'sql server auth', windows security had nothing to do with it.. am I wrong.
>> >
>> > Thanks for Your help!
>>