Connecting to SQL server DB from VB.NET app

Please support our VB.NET advertiser: Intel Parallel Studio Home
Thread Solved

Join Date: Jan 2006
Posts: 14
Reputation: Texpert is an unknown quantity at this point 
Solved Threads: 0
Texpert's Avatar
Texpert Texpert is offline Offline
Newbie Poster

Connecting to SQL server DB from VB.NET app

 
0
  #1
Feb 1st, 2006
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.
Reply With Quote Quick reply to this message  
Join Date: Jan 2006
Posts: 14
Reputation: Texpert is an unknown quantity at this point 
Solved Threads: 0
Texpert's Avatar
Texpert Texpert is offline Offline
Newbie Poster

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

 
0
  #2
Feb 2nd, 2006
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.
Reply With Quote Quick reply to this message  
Join Date: Sep 2005
Posts: 1
Reputation: dagne is an unknown quantity at this point 
Solved Threads: 1
dagne dagne is offline Offline
Newbie Poster

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

 
0
  #3
Feb 16th, 2006
Dagnachew Minda[I][U][QUOTE]
Reply With Quote Quick reply to this message  
Join Date: Aug 2006
Posts: 1
Reputation: police01040 is an unknown quantity at this point 
Solved Threads: 1
police01040 police01040 is offline Offline
Newbie Poster

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

 
0
  #4
Aug 29th, 2006
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?
Reply With Quote Quick reply to this message  
Join Date: Aug 2007
Posts: 63
Reputation: bcm is an unknown quantity at this point 
Solved Threads: 0
bcm's Avatar
bcm bcm is offline Offline
Junior Poster in Training

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

 
0
  #5
Aug 25th, 2007
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
Reply With Quote Quick reply to this message  
Join Date: Jan 2008
Posts: 1
Reputation: nandalanranjith is an unknown quantity at this point 
Solved Threads: 0
nandalanranjith nandalanranjith is offline Offline
Newbie Poster

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

 
0
  #6
Jan 16th, 2008
[QUOTE=dagne;191422]Dagnachew Minda[I][U]i have same problem when i choose server authentication in sqlserver connection
what to do
Reply With Quote Quick reply to this message  
Reply

This thread has been marked solved.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC