February 22, 2004 at 10:47 pm
Hi
I have a connection string like this which works
"provider=sqloledb;server=UYT3;database=Wordman;uid=****;password=****"
I want to use Trusted_Connection into my connection string and not userid but I get an error
"provider=sqloledb;server=UYT3;database=Wordman;Trusted_Connection=true"
What am I doing wrong? Please any help on this.
Thanks
February 23, 2004 at 12:13 pm
What is the error? Are you using OLE/DB or ODBC?
I assume that the userid you signed on with is a valid login for the server as well as having access to the Wordman database.
Check out http://www.able-consulting.com/ADO_Conn.htm for samples of connection strings.
Francis
February 24, 2004 at 12:53 am
I am using a OLEDB connection
I login to the server(which has IIS installed) using a userid "ABC" and my sql server database login is "XYZ"
and when I request my asp.net webpage in browser I get a an error which is
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'
February 24, 2004 at 7:32 am
I have seen this problem as well. The issue could be that your NT login does not have rights on the SQL server or database or the SQL Server is not set up for Mixed Authentication.
If these are setup then you may need to reboot the server. We have hasd this happen where the SQL Server will not authenticate NT Users because it has gotten out of sync with the domain.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply