| Author |
Topic |
|
MakiGjuro
Starting Member
5 Posts |
 Posted - 2010-10-11 : 19:54:30
|
| Hello everyone!!I have a PDA mobile device and i want to connect to sql server on my computer.Made a remote ad hoc connection on the computer with a reciever, And could not login to the server.It's telling me that login failed for user '<the current user>'. I even made a new named instance with new logins and working no mixed authentication mode.Firewall is down and still have no idea why it's not workingPlease help :DD |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
MakiGjuro
Starting Member
5 Posts |
Posted - 2010-10-11 : 19:58:17
|
| It's switched to mixed mode with sql authentication !! |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
MakiGjuro
Starting Member
5 Posts |
Posted - 2010-10-11 : 20:03:44
|
| I know it's not a network/firewall issue, that's very strange. And the default database is verified. |
|
|
|
MakiGjuro
Starting Member
5 Posts |
Posted - 2010-10-11 : 20:15:55
|
| Maybe I need to change something in the permission,i don't know.BTW I working with Windows CE operating system on my mobile device. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
MakiGjuro
Starting Member
5 Posts |
Posted - 2010-10-11 : 20:33:58
|
| In the first the default instance for the server was set. I was trying but nothing.Next i install a new named instance, turn off the default server and started using the new one. In Visual studio I'm able to make new connection with the database locally.I tried with the default user 'sa', even make a new user login but still nothing. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
Login Problem 'Login failed for user'