Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
scsfdev
Starting Member
4 Posts |
 Posted - 2009-10-13 : 05:22:12
|
| Hi all,I have a DB server PC and client PC.My Server is set at Mix mode.when I pass the connection string and connect to DB. it said "Login failed for user ''. The user is not associated with a trusted SQL Server connection."My connection is"Provider=SQLOLEDB;Data Source=1x2.xx.5x.26\SQLEXPRESS;Initial Catalog=DBTester;Trusted_Connection=Yes;User ID=sa;Password=saAdmin"I already set "sa" account to dbowner and the DBTester I tried to access is also owned by "sa".I tried to connect to SQL Server Express 2005 from my vbscript.Can anybody help me??Thanks.Visual Studio 2005 Pro + SQL Server 2005 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2009-10-13 : 11:45:45
|
| see http://www.connectionstrings.com/sql-server-2005 |
 |
|
|
scsfdev
Starting Member
4 Posts |
Posted - 2009-10-14 : 03:54:13
|
| Problem solved.I solved it by removing Trusted_Connection = True part.and afrika Thanks for your link.At first I didn't know what you want to mean. :)Thanks.Visual Studio 2005 Pro + SQL Server 2005 |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2009-10-14 : 04:17:22
|
glad2help  |
|
|
|
|
|
|
Client can't connect to Server