Member Avatar for Texpert

Hi,

I have this app running fine on my pc with connecting to SQL server on my localhost using windows authentication. Now I am going to deploy it on my client's server where SQL Server 2K DB is on server "abcd" with SQL Server credientials (No windows authentication) My problem is when I changed my connection string to "Server=abcd;uid=username;pwd=password" in web.config and try to run the app I get following error,
Exception Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
:sad:
Can you help ?

tia,

tejashree.

  • 5 Contributors
  • 5 Replies
  • 237 Views
  • 1 Year Discussion Span
  • Latest Post Latest Post by nandalanranjith
Member Avatar for Texpert

Hi,

I have this app running fine on my pc with connecting to SQL server on my localhost using windows authentication. Now I am going to deploy it on my client's server where SQL Server 2K DB is on server "abcd" with SQL Server credientials (No windows authentication) My problem is when I changed my connection string to "Server=abcd;uid=username;pwd=password" in web.config and try to run the app I get following error,
Exception Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
:sad:
Can you help ?

tia,

tejashree.

Issue resolved. I'd forgotten to take 'Integrated Security=SSIP" from my web.config.

Member Avatar for dagne

Dagnachew Minda

Member Avatar for police01040

Guys i need help in vb application, am making an RSS News Ticker But i want this application to make user authentication from SQL Server to run, can anyone help me?

Member Avatar for bcm

can you please send me your code I too want to connect SQL but in vain.
So please do hlp me...
Waiting for your quick reply......

Member Avatar for nandalanranjith

Dagnachew Minda

i have same problem when i choose server authentication in sqlserver connection
what to do

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.