Click here to Skip to main content
15,867,453 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
As I don't know the username & password of SQL Connection, Can I connect Database without username & password in SQL server 2000 in VB.net ?
Posted
Comments
Misha india 13-Aug-13 1:41am    
actually this is not my pc. i want to connect another user's PC s i don't know their computer password.

1 solution

Possibly you can connect with 'localhost' using '.' and 'integrated security = true' see connectionstrings.com:

Connection strings for SQL Server[^]

Something like:

1) Trusted Connection[^]

2) Or try using :

Data Source=.;Initial Catalog=myDataBase;Integrated Security=true;


Remember, in all of the above cases you can access the database but can not get advantage of 'sa' user rights.


Hope it helps!
 
Share this answer
 
Comments
Misha india 13-Aug-13 1:43am    
i want to take backup of that database i had tried trusted connection also but its not working.
Shahan Ayyub 13-Aug-13 1:51am    
I am a bit confused you are lacking of Windows account credentials or Sql Server credentials ? Are you trying to to take back from VB.Net of from SQL server directly ?
Shahan Ayyub 13-Aug-13 1:53am    
See without Windows credentials you can not even login to others system so this is not possible, if lacking Sql credentials, you can TRY using command line tool to take backup, http://www.howtogeek.com/50295/backup-your-sql-server-database-from-the-command-line/

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900