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 |
|
red
Starting Member
3 Posts |
 Posted - 2008-05-10 : 05:10:07
|
| Hello. I have recently installed MS SQL SERVER 2005 and when I was installing it, it asked me for the username and password, and there I had 2 options: either write my own, either select "Use Windows Authentification". I selected the "Windows Authenthification" ( I guess that means that it uses my username and password from Windows ).Now, Im trying to connect to the Server using Java and JDBC, but I have a problem: I have to specify the username and the password of the connection! My windows' only account is "Vlad" and I have no password. I tried these options, but it didn't work. I also tried with empty string "", and with "sa", "sa" but it didn't work either. I get an error saying that "Login failed for user 'Vlad'. The user is not associated with a trusted SQL Server Connection."Any ideea of what the username/passwords are or how to get them?.Thank you for your time. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-10 : 05:38:07
|
| Do you have a valid login in sql server?Are you a local admin of your system?Probably your user account is not a member of Local Administrators on your computer. |
 |
|
|
red
Starting Member
3 Posts |
Posted - 2008-05-10 : 06:15:13
|
| I am the computer administrator. This is my home PC and "Vlad" is the only account. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-10 : 06:19:57
|
| If you are a local admin on yoursystem, then you'd be able to login to your SQL Server as a sysadmin whichwould let you do anything on SQL Server.Also, logins for BUILTIN\Administrators and BUILTIN\Users would be createdautomatically in SQL Server when it's setup. Check out your account and yourSQL Server logins. |
|
|
|
red
Starting Member
3 Posts |
Posted - 2008-05-10 : 07:37:40
|
| "Check out your account and your SQL Server logins."How do I do that? :D |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-10 : 10:35:12
|
| "Now, Im trying to connect to the Server using Java and JDBC"Check out www.connectionstrings.com |
|
|
|
|
|
|
JDBC Username and Password Problem