November 23, 2015 at 10:42 am
I have a windows 2003 standered 32 bit server. In which I installed 2008 sql server 32 bit Enterprise edition.
My application is on vb.net 2010 .
Application running well when I run this at server.
Now problem is this when I run application through client which have windows 7, did not connect and dispay an error such as Login FAILED USER SERVERNAME/WINDOWS 7 LOGIN NAME.i.e
"LOGIN FAILED SERVER/HP.
EVEN
sql is in mixed mode
Sql login is sql authentication
How can I an solve this?
Kindly suggest.
November 23, 2015 at 1:35 pm
Can you post the connection string you are using for your application to connect to the SQL Server? It looks like you aren't providing a user name and password, but are trying to connect using windows authentication.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
November 23, 2015 at 7:45 pm
Thanks for reply
My connection string is this where
Data Source=Gaurav-Pc;Initial Catalog=AEX15;Integrated Security=False;User id=admin;Password=a
Server Name : Gaurav-Pc
database : AEX15
User Id on Sql server and database : admin
Password : a
But message display "Login Failed User Gaurav-pc/Hp"
Where I mention This "Hp" which is my windows 7 login name .
kindly suggest
November 24, 2015 at 7:21 am
itsgaurav (11/23/2015)
Thanks for replyMy connection string is this where
Data Source=Gaurav-Pc;Initial Catalog=AEX15;Integrated Security=False;User id=admin;Password=a
Server Name : Gaurav-Pc
database : AEX15
User Id on Sql server and database : admin
Password : a
But message display "Login Failed User Gaurav-pc/Hp"
Where I mention This "Hp" which is my windows 7 login name .
kindly suggest
Try removing the Integrated Security=False attribute from the connection string. It isn't necessary when you provide a user id and password. Other than that it all looks fine, but the error seems to indicate the application is trying to connect using windows authentication.
If the client has SSMS installed I'd also try connecting to the server and database using SQL Authentication in SSMS.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
November 24, 2015 at 8:38 pm
Thanks!!!!
Ok let me check in my code...
But funny is that when i open Administrator User which is disable in windows 7 or 8 and run software through administrator login it work fine..
As per my experience , i think there is some problem in between Administrator user and standard user.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply