Connecting to SQL server DB from VB.NET app

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

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

[dagne]

Dagnachew Minda[I][U][QUOTE]

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

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

[nandalanranjith]

[QUOTE=dagne;191422]Dagnachew Minda[I][U]
i have same problem when i choose server authentication in sqlserver connection
what to do