943,961 Members | Top Members by Rank

Software Development > VB.NET > Connecting to SQL server DB from VB.NET app
Ad:
  • VB.NET Discussion Thread
  • Marked Solved
  • Views: 32055
  • VB.NET RSS
Permalink
Feb 1st, 2006
0

Connecting to SQL server DB from VB.NET app

Expand Post »
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.

Can you help ?

tia,

tejashree.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
Texpert is offline Offline
14 posts
since Jan 2006
Permalink
Feb 2nd, 2006
0

Re: Connecting to SQL server DB from VB.NET app

Quote originally posted by 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.

Can you help ?

tia,

tejashree.
Issue resolved. I'd forgotten to take 'Integrated Security=SSIP" from my web.config.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
Texpert is offline Offline
14 posts
since Jan 2006
Permalink
Feb 16th, 2006
0

Re: Connecting to SQL server DB from VB.NET app

Dagnachew Minda[I][U][QUOTE]
Reputation Points: 10
Solved Threads: 1
Newbie Poster
dagne is offline Offline
1 posts
since Sep 2005
Permalink
Aug 29th, 2006
0

Re: Connecting to SQL server DB from VB.NET app

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?
Reputation Points: 10
Solved Threads: 1
Newbie Poster
police01040 is offline Offline
1 posts
since Aug 2006
Permalink
Aug 25th, 2007
0

Re: Connecting to SQL server DB from VB.NET app

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......
bcm
Reputation Points: 18
Solved Threads: 0
Junior Poster in Training
bcm is offline Offline
63 posts
since Aug 2007
Permalink
Jan 16th, 2008
0

Re: Connecting to SQL server DB from VB.NET app

[QUOTE=dagne;191422]Dagnachew Minda[I][U]i have same problem when i choose server authentication in sqlserver connection
what to do
Reputation Points: 10
Solved Threads: 0
Newbie Poster
nandalanranjith is offline Offline
1 posts
since Jan 2008

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
This thread is currently closed and is not accepting any new replies.
Previous Thread in VB.NET Forum Timeline: read the contents of an XML
Next Thread in VB.NET Forum Timeline: Alarm????





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC