Hello Ian,



After connecting to SQL server, both authentications should have the same

effect. Since you can connect to SQL server when logging on as Windows

user, the issue may be a performance issue instead of a connectivity

issues.



Please understand that identifying the causes of a performance issue is

typically very time consuming, and you may spend several days evaluating

the collected information. The complexity of the performance analysis is

not specific to a particular database product or operating system. All

applications are subject to performance constraints because of resource,

design, or usage factors.



To narrow down the issue, I suggest you perform steps below to narrow down

the issue:



1. Make sure both users have the same permissions on the database in SQL

server, then run a simple query on the sample database Northwind to see if

you can reproduce the problem.



If you are unable to reproduce the problem, it indicates that the problem

is special to the query you run before; if you can reproduce the problem,

you need perform further steps to narrow down the issue.



2. Collect the information in the following article when logging on as

Windows and SQL server user. Then analyze the output files.



HOW TO: Troubleshoot Application Performance Issues

<http://support.microsoft.com/?id=298475>





If the issue still exists after you have used the troubleshooting steps

above, to efficiently troubleshoot a performance issue, we recommend that

you contact Microsoft Product Support Services and open a support incident

and work with a dedicated Support Professional.



To obtain the phone numbers for specific technology request please take a

look at the web site listed below.



http://support.microsoft.com/default...S;PHONENUMBERS



If you are outside the US please see http://support.microsoft.com for

regional support phone numbers.



I hope above information is helpful.





Sophie Guo

Microsoft Online Partner Support



Get Secure! - www.microsoft.com/security



==================================================  ===

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.

Thanks Sophie. I will try and run some tests, as soon as I can. I'll get

back to you



Cheers

Ian

"Sophie Guo [MSFT]" <v-sguo@online.microsoft.com> wrote in message

news:J0zo6Di%23EHA.644@cpmsftngxa10.phx.gbl...

> Hello Ian,

>

> After connecting to SQL server, both authentications should have the same

> effect. Since you can connect to SQL server when logging on as Windows

> user, the issue may be a performance issue instead of a connectivity

> issues.

>

> Please understand that identifying the causes of a performance issue is

> typically very time consuming, and you may spend several days evaluating

> the collected information. The complexity of the performance analysis is

> not specific to a particular database product or operating system. All

> applications are subject to performance constraints because of resource,

> design, or usage factors.

>

> To narrow down the issue, I suggest you perform steps below to narrow down

> the issue:

>

> 1. Make sure both users have the same permissions on the database in SQL

> server, then run a simple query on the sample database Northwind to see if

> you can reproduce the problem.

>

> If you are unable to reproduce the problem, it indicates that the problem

> is special to the query you run before; if you can reproduce the problem,

> you need perform further steps to narrow down the issue.

>

> 2. Collect the information in the following article when logging on as

> Windows and SQL server user. Then analyze the output files.

>

> HOW TO: Troubleshoot Application Performance Issues

> <http://support.microsoft.com/?id=298475>

>

>

> If the issue still exists after you have used the troubleshooting steps

> above, to efficiently troubleshoot a performance issue, we recommend that

> you contact Microsoft Product Support Services and open a support incident

> and work with a dedicated Support Professional.

>

> To obtain the phone numbers for specific technology request please take a

> look at the web site listed below.

>

> http://support.microsoft.com/default...S;PHONENUMBERS

>

> If you are outside the US please see http://support.microsoft.com for

> regional support phone numbers.

>

> I hope above information is helpful.

>

>

> Sophie Guo

> Microsoft Online Partner Support

>

> Get Secure! - www.microsoft.com/security

>

> ==================================================  ===

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

>

Hello Ian,



thanks for your update.



If you have any questions or concerns, don't hesitate to let me know. We

are always here to be of assistance!





Sophie Guo

Microsoft Online Partner Support



Get Secure! - www.microsoft.com/security



==================================================  ===

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.

	
Quote:
	

	

		

			
				Originally posted by Sophie Guo [MSFT] 

Hello Ian,



thanks for your update.



If you have any questions or concerns, don't hesitate to let me know. We

are always here to be of assistance!





Sophie Guo

Microsoft Online Partner Support



Get Secure! - www.microsoft.com/security



==================================================  ===

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. 
			
		
	
	
Ian and Sophie:



I have experienced the same problem with queries in "SQL Analyzer only" as Ian as in using Windows authentication.



Here is the sequence of events.  

1. Nomal installation of SQL Server 2K - Security mode set to Windows only.



Results: performance in as expected for all queries run.



2.  Install or create an application that requires SQL Server authentication.

a) Open properties on server and change authentication to both Windows and SQL Server



Results: Initial performance of queries run in either mode is identical



3) Began using the application the required the SQL Authentication (Crystal Enterprize accessing a stored procedure or NET ADO adapter calls to queries or stored procedures.



Results:  At some point in time 2-3 days or less after heavy use...you will notice that performance in SQL Analyzer degrades signigficantly when using windows authentication.  This is TRUE of ALL commands including admin cals like sp_who or attach and detach databases.

Enterprize manager does not experience these problems.



REMEDY:



(4)Change the properties of the authentication of the server back to windows only.



RESULTS: The same queries limping minutes beforeunder windows authentication no perform appropriately again.  



(5)Change the properties of the server back to both properties again.



Results:  The queries will perform in SQL Analyzer equally for another few days.





THIS IS A BUG SOPHIE!



Chuck