| | |
Connecting to SQL server DB from VB.NET app
Please support our VB.NET advertiser: Intel Parallel Studio Home
Thread Solved |
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.
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.
•
•
•
•
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.
![]() |
Similar Threads
- How to connect queries from SQL Server 2005 to VB.Net Windows application (VB.NET)
- How to connect queries from SQL Server 2005 to VB.Net Windows application (MS SQL)
- Help needed: Connecting to sql server database (VB.NET)
- struggling with connecting database to server (ASP.NET)
Other Threads in the VB.NET Forum
- Previous Thread: read the contents of an XML
- Next Thread: Alarm????
| Thread Tools | Search this Thread |
"crystal .net .net2005 30minutes 2008 access add arithmetic array assignment basic binary bing box button buttons center click code combobox component connectionstring convert cpu data database databasesearch datagrid datagridview design dissertation dissertations dissertationthesis dosconsolevb.net editvb.net employees excel exists file-dialog firewall folder google hardcopy image images isnumericfuntioncall login math memory mobile module ms msaccess mssqlbackend mysql navigate net networking opacity output pan peertopeervideostreaming picturebox picturebox1 port print printpreview problemwithinstallation project record reports" reuse save savedialog serial sqldatbase storedprocedure string temp text textbox timer toolbox updown useraccounts usercontrol vb vb.net vb.netcode vb.nettoolboxvisualbasic2008sidebar vbnet view vista visual visualbasic visualbasic.net visualstudio web wpf xml





